nyindieguy wrote:
> *context menu* that uses an existing static playlist and allows me to
> choose a subset of that playlist that chooses multiple genres and/or a
> year.
With *year* you'll have to choose a year. Not optional.
Code:
--------------------
-- PlaylistName:Songs - multiple genres & year (from selected playlist)
-- PlaylistGroups:
-- PlaylistMenuListType:contextmenu
-- PlaylistParameter1:playlist:Select playlist:
-- PlaylistParameter2:multiplegenres:Select genres:
-- PlaylistParameter3:year:Select year:
select distinct playlist_track.track from playlist_track
join tracks on
tracks.url = playlist_track.track
join genre_track on
genre_track.track = tracks.id and genre_track.genre in
('PlaylistParameter2')
left join dynamicplaylist_history on
dynamicplaylist_history.id=tracks.id and
dynamicplaylist_history.client='PlaylistPlayer'
where
playlist_track.playlist='PlaylistParameter1'
and tracks.year='PlaylistParameter3'
and tracks.audio = 1
and tracks.secs >= 'PlaylistTrackMinDuration'
and dynamicplaylist_history.id is null
group by playlist_track.track
order by random()
limit 'PlaylistLimit';
--------------------
With *decades* it's optional (select -any-).
Code:
--------------------
-- PlaylistName:Songs - multiple genres & decade (from selected playlist)
-- PlaylistGroups:
-- PlaylistMenuListType:contextmenu
-- PlaylistParameter1:playlist:Select playlist:
-- PlaylistParameter2:multiplegenres:Select genres:
-- PlaylistParameter3:customdecadechained:Select decade:select
cast(((ifnull(tracks.year,0)/10)*10) as int),case when tracks.year>0 then
cast(((tracks.year/10)*10) as int)||'s' else 'Unknown' end from tracks where
tracks.audio=1 group by cast(((ifnull(tracks.year,0)/10)*10) as int) order by
tracks.year desc
select distinct playlist_track.track from playlist_track
join tracks on
tracks.url = playlist_track.track
join genre_track on
genre_track.track = tracks.id and genre_track.genre in
('PlaylistParameter2')
left join dynamicplaylist_history on
dynamicplaylist_history.id=tracks.id and
dynamicplaylist_history.client='PlaylistPlayer'
where
playlist_track.playlist='PlaylistParameter1'
and tracks.year='PlaylistParameter3'
and tracks.audio = 1
and tracks.secs >= 'PlaylistTrackMinDuration'
and dynamicplaylist_history.id is null
and
case
when 'PlaylistParameter3'!=999999999 then
tracks.year>='PlaylistParameter3' and tracks.year<('PlaylistParameter3'+10)
else 1
end
group by playlist_track.track
order by random()
limit 'PlaylistLimit';
--------------------
*Plugin repositories:* 'Ratings Light'
(https://github.com/AF-1/lms-ratingslight) 'Visual Statistics'
(https://github.com/AF-1/lms-visualstatistics) 'Use Comment Tag
Info' (https://github.com/AF-1/lms-usecommenttaginfo) 'Dynamic
Playlists 3 FAQ' (https://github.com/AF-1/lms-dynamicplaylists#faq)
'Custom Skip 3 FAQ' (https://github.com/AF-1/lms-customskip#faq)
------------------------------------------------------------------------
afriend's Profile: http://forums.slimdevices.com/member.php?userid=39306
View this thread: http://forums.slimdevices.com/showthread.php?t=115501
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
