Edub;283224 Wrote:
> Thanks for your patience and help, erland. That's the part I'm having
> trouble with. I thought I could simply modify the sql query you
> provided in this post:
> http://forums.slimdevices.com/showthread.php?t=45136&highlight=sql+album
> by deleting the references to "contributor" and deleting the "not"
> after album.title, and changing 'Sentimento' to 'Football Daily' but I
> kept getting odd results.
>
Try something like this:
Code:
--------------------
-- PlaylistName:Football
-- PlaylistGroups:
select tracks.url from tracks
join albums on
albums.id=tracks.album
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
audio=1
and dynamicplaylist_history.id is null
and albums.title in ('5 live Football Daily', 'Guardian Unlimited Football',
'ESPN Soccernet')
order by tracks.timestamp desc
limit 25;
--------------------
Edub;283224 Wrote:
>
> I think my description was bad. I simply wanted to have each playlist
> have a different sort method. E.g.:
> Sport, sort by most recent first
> Motorsport, sort by oldest first
> Technology, sort by album
>
> These sort orders would be static.
>
Change the "order by tracks.timestamp desc" part to:
sort by most recent first:
Code:
--------------------
order by tracks.timestamp desc
--------------------
sort by oldest first:
Code:
--------------------
order by tracks.timestamp asc
--------------------
sort by album (and most recent first within each album):
Code:
--------------------
order by albums.titlesort asc,tracks.timestamp desc
--------------------
Edub;283224 Wrote:
>
> Hmmm...I'm sure it would bite me on the nose if it was a snake, but I
> keep getting told that I need to specify a directory. I had always
> assumed it was asking for a local directory on my machine, not a
> location on the 'net.
>
You will need to point the "Template directory" parameter in the
"Server Settings/Plugins/SQL Playlist" section to an empty directory
where SlimServer has write access to. This directory will be used to
store downloaded playlist. You may have to restart SlimServer after you
have specified the directory for the changes to take effect.
Note, that the download functionality is currently only available in
SlimServer 6.5, so if you are using SqueezeCenter 7.0 you won't be able
to use it yet.
--
erland
Erland Isaksson
'My homepage' (http://erland.homeip.net) 'My download page'
(http://erland.homeip.net/download)
(Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse,
Custom Scan, Custom Skip, Multi Library and Database Query plugins'
(http://wiki.erland.homeip.net/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=20533
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
