[SlimDevices: Plugins] Dynamic Playlist - Decade

[Tony T]

Just noticed that Random Songs for Decade no longer works.
When I select Play in the WebUI, the "Select Decade" drop down is
blank.

I'm using the pre-defined code:


Code:
--------------------
    
  -- PlaylistName:Random songs for decade
  -- PlaylistGroups:Random,Random/For selected
  -- PlaylistParameter1:customdecade:Select decade:select 
floor(tracks.year/10)*10,case when tracks.year>0 then 
concat(floor(tracks.year/10)*10,'s') else 'Unknown' end from tracks where 
tracks.audio=1 group by floor(tracks.year/10)*10 order by tracks.year desc
  select tracks.url from tracks
        left join track_statistics on
                tracks.url=track_statistics.url
        where
                audio=1
                and tracks.year>='PlaylistParameter1' and 
tracks.year<('PlaylistParameter1'+10)
                and 
ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-2419200)
        order by random()
        limit 10;
  
--------------------


-- 
Tony T

Tony
&#63743;  SBTouch &#9834; SBRadio &#9836;
------------------------------------------------------------------------
Tony T's Profile: http://forums.slimdevices.com/member.php?userid=34544
View this thread: http://forums.slimdevices.com/showthread.php?t=90482

_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins