vagskal;659552 Wrote:
> Sorry to bother you again. This playlist tests fine (once I changed
> rand() to random() as explained in your wiki), but nothing is
> played/added to the current playlist.
>
> >
Code:
--------------------
> > -- PlaylistName:Random songs from one trackyear
> -- PlaylistGroups:
> -- PlaylistParameter1:year:Select year:
> select customscan_track_attributes.url from customscan_track_attributes
> left join dynamicplaylist_history on
> customscan_track_attributes.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
> where
> module='customtag'
> and attr='TRACKYEAR'
> and value='PlaylistParameter1'
> and dynamicplaylist_history.id is null
> order by random()
> limit 10;
--------------------
> >
>
I can see two possible reasons.
1.
customscan_track_attributes.id=dynamicplaylist_history.id
Should really be:
customscan_track_attributes.track=dynamicplaylist_history.id
2.
Make sure it has actually scanned the TRACKYEAR custom tag, you can do
this either by using the "Custom Scan Info" menu template in Custom
Browse plugin or by looking at the "Custom Scan Statistics" report in
Database Query plugin.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
Interested in music discovery ? See 'Social Music Discovery (SMD)'
(http://forums.slimdevices.com/showthread.php?p=656713) project.
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
