MillmoorRon;501719 Wrote: > Not sure exactly how to do the first thing, but I exported my TrackStat > backup and looked at the offending tracks and they do have ratings of 81 > or 82! > > I do have automatic rating enabled however I have the percentage > increase/decrease set at 0. Maybe these few tracks were played whilst I > was still setting everything up? > > Could I edit my SQLs to select 'rating>=x' rather than 'as top rated' > to get round this problem. > > Thanks very much for your speedy help - I was worried that I'd > corrupted 3 years of trackstat data! > You have the following choices as I see it: 1. Add the following to the SQL: "and track_statistics.rating>=80" and change "order by track_statistics.rating desc,rand()" to "order by rand()" 2. Change "order by track_statistics.rating desc,rand()" to something like "order by floor((track_statistics.rating+10)/20)*20,rand()" 3. Set the rating manually with IR remote, Controller or web interface. This will change the 81 and 82 ratings to 80.
-- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=49483 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
