} else { $row = mysql_fetch_array($result); $query = "DELETE FROM mp3act_currentsong"; mysql_query($query); updateNumPlays($row['song_id'], 1, $_SERVER['argv'][2]); setCurrentSong($row['song_id'], 0, 1); playLocal($row['filename']); } } $query = "DELETE FROM mp3act_currentsong"; mysql_query($query); if (file_exists("/tmp/mp3act")) { unlink("/tmp/mp3act"); } } else { while (1) { $query = "SELECT song_id,filename FROM mp3act_songs WHERE random!=1 ORDER BY rand()+0 LIMIT 1"; $result = mysql_query($query); $row = mysql_fetch_array($result); $query = "DELETE FROM mp3act_currentsong"; mysql_query($query); updateNumPlays($row['song_id'], 1, $_SERVER['argv'][2]); setCurrentSong($row['song_id'], 0, 1); playLocal($row['filename']); } $query = "DELETE FROM mp3act_currentsong"; mysql_query($query); if (file_exists("/tmp/mp3act")) { unlink("/tmp/mp3act"); } }
function play($mode, $type, $id) { grammafone_connect(); $tmp = ''; $query = ''; if ($type == 'song') { $query = "SELECT grammafone_songs.song_id,grammafone_artists.artist_name,grammafone_artists.prefix,grammafone_songs.name,grammafone_songs.length,grammafone_songs.filename,grammafone_albums.album_art FROM grammafone_songs,grammafone_artists,grammafone_albums WHERE grammafone_songs.song_id={$id} AND grammafone_artists.artist_id=grammafone_songs.artist_id AND grammafone_songs.album_id = grammafone_albums.album_id AND grammafone_songs.album_id = grammafone_albums.album_id"; } elseif ($type == 'album') { $query = "SELECT grammafone_songs.song_id,grammafone_artists.artist_name,grammafone_songs.name,grammafone_artists.prefix,grammafone_songs.length FROM grammafone_songs,grammafone_artists WHERE grammafone_artists.artist_id=grammafone_songs.artist_id AND grammafone_songs.album_id={$id} ORDER BY grammafone_songs.track"; } elseif ($type == 'pl') { $query = "SELECT grammafone_songs.song_id,grammafone_artists.artist_name,grammafone_songs.name,grammafone_artists.prefix,grammafone_songs.length FROM grammafone_songs,grammafone_artists,grammafone_playlist WHERE grammafone_artists.artist_id=grammafone_songs.artist_id AND grammafone_songs.song_id=grammafone_playlist.song_id AND grammafone_playlist.user_id={$_SESSION['sess_userid']} ORDER BY grammafone_playlist.pl_id"; } elseif ($type == 'stop') { $query = "DELETE FROM grammafone_currentsong"; mysql_query($query); return ""; } $result = mysql_query($query); if ($mode == 'player') { session_cache_limiter('nocache'); header("Content-Type: application/xspf+xml;"); header("Content-Disposition: inline; filename=\"playlist.xspf\""); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Pragma: nocache"); $tmp .= '<?xml version="1.0" encoding="UTF-8"?><playlist version="1" xmlns="http://xspf.org/ns/0/">' . "\n<trackList>\n"; while ($row = mysql_fetch_array($result)) { $length = $row['length']; if (getSystemSetting("sample_mode") == 1) { $length = floor($row['length'] / 4); } $tmp .= "<track>\n"; $tmp .= "\t<creator>{$row['artist_name']}</creator><title>{$row['name']}</title>\n"; $tmp .= "\t<location>{$GLOBALS['http_url']}{$GLOBALS['uri_path']}/playstream.php?i={$row['song_id']}&u={$_SESSION['sess_usermd5']}&b={$_SESSION['sess_bitrate']}&s={$_SESSION['sess_stereo']}</location>\n"; $tmp .= "\t<meta rel=\"type\">sound</meta>\n"; $tmp .= "\t<image>{$GLOBALS['http_url']}{$GLOBALS['uri_path']}/art/{$row['album_art']}</image>\n"; $tmp .= "</track>\n"; $tmp .= " </trackList></playlist>\n"; } setCurrentSong($id, 0, 0); return $tmp; } else { // We must be wanting to stream session_cache_limiter('nocache'); header("Content-Type: audio/mpegurl;"); header("Content-Disposition: inline; filename=\"playlist.m3u\""); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Pragma: nocache"); $tmp .= "#EXTM3U\n"; while ($row = mysql_fetch_array($result)) { $length = $row['length']; if (getSystemSetting("sample_mode") == 1) { $length = floor($row['length'] / 4); } $tmp .= "#EXTINF:{$length},{$row['prefix']} {$row['artist_name']} - {$row['name']}\n"; $tmp .= "{$GLOBALS['http_url']}{$GLOBALS['uri_path']}/playstream.php?i={$row['song_id']}&u={$_SESSION['sess_usermd5']}&b={$_SESSION['sess_bitrate']}&s={$_SESSION['sess_stereo']}\n"; } return $tmp; } }