Just for information if you are interested.
The latest version of SQLPlayList/DynamicPlayList plugins makes it
possible to create dynamic playlists that requests parameters from the
user.
By using this funtionality it is possible to create a "Random album"
playlist that would show the user 10 random albums, the user has to
select one of them and then the selected album is played.
A playlist like this is defined i SQLPlayList for slimserver 6.5 as
follows:
Code:
--------------------
-- PlaylistParameter1:custom:Select album:select albums.id,albums.title from
tracks join albums on tracks.album=albums.id where tracks.audio=1 group by
albums.id order by rand() limit 10
select tracks.url from tracks
where tracks.album='PlaylistParameter1'
order by tracks.tracknum;
--------------------
If you are running slimserver 6.3 or earlier which uses SQLite you will
have to change "rand()" to "random()" to make it work.
--
erland
Erland Isaksson
'My homepage' (http://erland.homeip.net) 'My download page'
(http://erland.homeip.net/download)
(Developer of 'TrackStat'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat)
, 'SQLPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist)
, 'DynamicPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist)
and 'RandomPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist)
plugins)
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=25712
_______________________________________________
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/discuss
