amatala;480595 Wrote: > Actually if I understand this correctly, I do not need Trackstat. > I only need DynamicPlaylist and SQLPlaylist because the LastPlayed and > PlayCount info is already stored in the standard SqueezeCenter database > - this is enough to write some custom "least recently played" SQL in > order to get the least recently played tracks with the smallest play > count. > It depends on what you mean with least recently played.
If you mean "Tracks that haven't been played at all recently" a custom SQL statement together with SQL Playlist + Dynamic Playlist will do it. If you mean "Tracks that have been played least number of times during the last month" you will need TrackStat because then you will have to use the track_history table provided by TrackStat that keeps history of exactly when a track was played. Standard Squeezebox Server database just remember the total play count and the last time a track was played. With the TrackStat track_history table you can calculate a play count for last month. -- 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=70617 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins