RoyRadio

Song History:

open("SELECT songlist.*, DATE_FORMAT(songlist.date_added, '%b %e, %Y') as dateadded, historylist.listeners as listeners, historylist.requestID as requestID, historylist.date_played as starttime FROM historylist,songlist WHERE (historylist.songID = songlist.ID) AND (songlist.songtype='S' or songlist.songtype='C') ORDER BY historylist.date_played DESC",6); $history = $db->rows(); reset($history); $db->open("SELECT songlist.*, queuelist.requestID as requestID FROM queuelist, songlist WHERE (queuelist.songID = songlist.ID) AND (songlist.songtype='S' or songlist.songtype='C') AND (songlist.artist <> '') ORDER BY queuelist.sortID ASC",2); $queue = $db->rows(); reset($queue); function HistoryNow(&$song) { global $rc, $showpic, $darkrow, $lightrow; PrepareSong($song); $rc++; $bgcolor = $darkrow; if(($rc % 2)==0) $bgcolor = $lightrow; ?> open("SELECT songlist.*, historylist.listeners as listeners, DATE_FORMAT(historylist.date_played, '%h:%i %p') as mytime, historylist.requestID as requestID, historylist.date_played as starttime FROM historylist,songlist WHERE (historylist.songID = songlist.ID) AND (songlist.songtype='S' or songlist.songtype='C') ORDER BY historylist.date_played DESC",75); $history = $db->rows(); reset($history); list($key, $song) = each($history); $listeners = $song["listeners"]; function History(&$song) { global $rc, $showpic, $darkrow, $lightrow; PrepareSong($song); $rc++; $bgcolor = "#302226" ; if(($rc % 2)==0) $bgcolor = "#595454" ; ?>
NOW:
:
 
back to top