MillmoorRon;349891 Wrote: > Re. Post 3 > > If I modified a standard Top Rated SQL and added a sort by playcount > ascending, would it always pick the same tracks?
If you add both playcount and rand() it will randomize all tracks within the same playcount, like: order by playcount asc,rand() If you don't have the rand() it will be a bit less random. After a track has been played, it will no longer have the lowest playcount so this also means that it wouldn't be selected again until all tracks with lower playcount (matchine the rest of the query) have been played once. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=53604 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
