ewreck;561055 Wrote: > > Erland i found this old thread; > I knew I had done this somewhere, thanks for finding it.
ewreck;561055 Wrote: > > But can you add one extra playlistparameter for me. About intensity. > Range 1 to 5 > So i can choose between an range of the BPM and the intensity of it. > Exactly what is the intensity tag called in the Custom Scan configuration ? Feels like it should be something like this if the tag is INTENSITY and it only contains integer values: Code: -------------------- -- PlaylistName:BPM Range -- PlaylistGroups: -- PlaylistParameter1:custom:Select Low BPM:select 10*floor(customscan_track_attributes.value/10),10*floor(customscan_track_attributes.value/10) from customscan_track_attributes where customscan_track_attributes.module='customtag' and customscan_track_attributes.attr='BPM' group by 10*floor(customscan_track_attributes.value/10) order by customscan_track_attributes.value -- PlaylistParameter2:custom:Select High BPM:select 10*ceil(customscan_track_attributes.value/10),10*ceil(customscan_track_attributes.value/10) from customscan_track_attributes where customscan_track_attributes.module='customtag' and customscan_track_attributes.attr='BPM' and customscan_track_attributes.value>='PlaylistParameter1' group by 10*ceil(customscan_track_attributes.value/10) order by customscan_track_attributes.value -- PlaylistParameter3:custom:Select Intensity:select customscan_track_attributes.value,customscan_track_attributes.value from customscan_track_attributes where customscan_track_attributes.module='customtag' and customscan_track_attributes.attr='INTENSITY' group by customscan_track_attributes.value order by customscan_track_attributes.value select tracks.url from tracks join track_statistics on tracks.url=track_statistics.url join customscan_track_attributes as lowbpm on tracks.id=lowbpm.track and lowbpm.module='customtag' and lowbpm.attr='BPM' and lowbpm.value>='PlaylistParameter1' join customscan_track_attributes as highbpm on tracks.id=highbpm.track and highbpm.module='customtag' and highbpm.attr='BPM' and highbpm.value<='PlaylistParameter2' join customscan_track_attributes as intensity on tracks.id=intensity.track and intensity.module='customtag' and intensity.attr='INTENSITY' and intensity.value='PlaylistParameter3' left join dynamicplaylist_history on tracks.id=dynamicplaylist_history.id where audio=1 and dynamicplaylist_history.id is null group by tracks.id order by rand() limit 25; -------------------- Note, since I don't have any BPM and INTENSITY tags in my music files, I haven't been able to test if the above playlist actually works. So give it a quick try and report back if it doesn't work and you can't find the error yourself. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=80304 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins