[Crazy Pete]

04-23-03 at 08:14 AM Lethal said this in Post #120
Well I think I got the Top 10 working the way its supposed to. In jukebox.php replace all occurances of:

PHP Code:

$mostplayed=$DB_site->query_first("SELECT songsid,sname,surl,splay FROM jukebox ORDER BY splay desc LIMIT 1"); 


With:

PHP Code:

$mostplayed=$DB_site->query_first('SELECT * FROM `jukebox` ORDER BY `splay` DESC LIMIT 0, 30'); 


Takes awhile to load the songs thou. Even on cable. Is that normal? Takes like 1-2 minutes. Will the songs be cached in ur browser after you play them a few times that way they will or should play right away?

Still doesn't work for me. Seems to want to choose the most played and top 10 at random. It didn't affect my song load time at all, though.