rlem wrote:
> ...
>
> How do other people do this?
>
> Thanks,
> Randy
There's a table in the database that keeps track of the last time a song
was played, *-tracks_persistent-*.
I include this code in SQL playlists to leave out tracks played in the
last 4 days:
Code:
--------------------
where not exists (
select *
from tracks_persistent tp
where tp.urlmd5 = tracks.urlmd5
and datetime( tp.lastPlayed, 'unixepoch' ) < datetime( 'now' )
and datetime( tp.lastPlayed, 'unixepoch' ) > datetime( 'now' , 'start
of day' , '-4 days' )
)
--------------------
------------------------------------------------------------------------
br@m's Profile: http://forums.slimdevices.com/member.php?userid=68632
View this thread: http://forums.slimdevices.com/showthread.php?t=115073
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
