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
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
