erland;643562 Wrote:
> If you have customized the SQL yourself, you need to change "rand" to
> "random".
>
> If you haven't customized the SQL and sees the more user friendly view
> when editing the SQL playlist, it should handle it automatically as
> long as you have the latest version of Dynamic Playlists and SQL
> Playlists plugins.
>
> If you don't get it to work, please let me know which playlist template
> the playlist is based on because then I might have missed something.
I have Dynamic Playlist v2.8.4 and SQL Playlist v2.5.3359
I'm using the 'user friendly version', and also none of the pre-set
templates in SQL Playlist work either.
Here's one of the templates:
Code:
--------------------
-- PlaylistName:Random songs
-- PlaylistGroups:Random
-- PlaylistStartAction1:cli:customskip setsecondaryfilter
recentlyaddedartistfilterset.cs.xml
-- PlaylistStopAction1:cli:customskip clearsecondaryfilter
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
where
audio=1
and (ifnull(track_statistics.rating,0)=0 or
track_statistics.rating>=30)
and not exists (select * from tracks t2,genre_track,genres
where
t2.id=tracks.id and
tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in
('Comedy'))
and ifnull(track_statistics.playcount,0)=0
group by tracks.id
order by random()
limit 10;
--------------------
--
Tony T
Tony
 SBTouch ♪ SBRadio ♬
------------------------------------------------------------------------
Tony T's Profile: http://forums.slimdevices.com/member.php?userid=34544
View this thread: http://forums.slimdevices.com/showthread.php?t=89056
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
