Erland,
I'm trying to update my SQL Playlists to work on LMS.
I've changed all instances of rand() to random() which makes most work
OK but I still have some problematic ones.
My Recently Added SQL have a 'days' parameter:
Code:
--------------------
-- PlaylistParameter1:list:Added in the
last:1:Day,7:Week,14:Fortnight,30:Month,91:Quarter,182:Six Months,365:Year
--------------------
which is later used in:
Code:
--------------------
and track_statistics.added>UNIX_TIMESTAMP(DATE_ADD(NOW(),INTERVAL
-'PlaylistParameter1' DAY))
--------------------
Could you please advise the syntax for the new version:
Code:
--------------------
and track_statistics.added>STRFTIME("%s",DATE('NOW','-30 DAY'))
--------------------
to add this parameter in the place of the 30 above?
------------------------------------------------------------------------
MillmoorRon's Profile: http://forums.slimdevices.com/member.php?userid=6413
View this thread: http://forums.slimdevices.com/showthread.php?t=94854
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
