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

Reply via email to