RoyRadio

Top Artists of the Week:

login["Type"]) { case "ibase" : $orderby = "ORDER BY count(songlist.ID) DESC"; break; case "mysql" : default : $orderby = "ORDER BY cnt DESC"; break; } $now = $db->FormatTimestamp($now); $db->open("SELECT songlist.ID, songlist.title, songlist.artist, count(songlist.ID) as plays FROM songlist, historylist WHERE (songlist.ID = historylist.songID) AND (songlist.songtype ='S') AND (historylist.date_played > date_sub(now(), interval 7 day)) AND (historylist.date_played < now()) GROUP BY songlist.artist ORDER BY Plays DESC, songlist.count_played DESC, songlist.date_played ASC",15); //list($key, $song) = each($history); // $listeners = $song["listeners"]; if($db->num_rows()>0) { function TopArtsts0($song) { global $i; Preparesong($song); ?>
:  
row()) { $i++; TopArtsts0($song); } ?>
 

Top Songs of the Week:

login["Type"]) { case "ibase" : $orderby = "ORDER BY count(songlist.ID) DESC"; break; case "mysql" : default : $orderby = "ORDER BY cnt DESC"; break; } $now = $db->FormatTimestamp($now); $db->open("SELECT songlist.ID, songlist.title, songlist.artist, count(songlist.ID) as plays FROM songlist, historylist WHERE (songlist.ID = historylist.songID) AND (songlist.songtype ='S') AND (historylist.date_played > date_sub(now(), interval 7 day)) AND (historylist.date_played < now()) GROUP BY songlist.ID ORDER BY Plays DESC, songlist.count_played DESC, songlist.date_played ASC",15); //list($key, $song) = each($history); // $listeners = $song["listeners"]; if($db->num_rows()>0) { function TopSongs0($song) { global $i; Preparesong($song); ?>
:   - ""
row()) { $i++; TopSongs0($song); } ?>
 

Latest Additions:

open("SELECT album, artist, title, date_added, picture, albumyear, DATE_FORMAT(songlist.date_added, '%b %e, %Y') as dateadded from songlist WHERE songtype='S' GROUP BY title, artist ORDER BY date_added DESC LIMIT 15"); $history = $db->rows(); reset($history); list($key, $song) = each($history); $listeners = $song["listeners"]; function NewAdds0(&$song) { global $rc, $showpic, $darkrow, $lightrow; PrepareSong($song); $rc++; $bgcolor = $darkrow; if(($rc % 2)==0) $bgcolor = $lightrow; ?>
- ""
 
back to top