} 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;
}
}
