Hello,
I took look on the plugin yesterday, in the hope, o work around the
problem that the original brows entries are not presenting compilations
tracks in differnt folders as one album.
I started modifying the shallowgenre template to cater my needs. I
modifyed two sections that select the albums and tracks to present to
the user.
Code:
--------------------
<menudata>
SELECT
albums.id,albums.title,substr(albums.titlesort,1,1)
FROM tracks left JOIN albums ON
albums.id=tracks.album LEFT JOIN genre_track ON tracks.id=genre_track.track
WHERE
tracks.audio=1 and
genre_track.genre={genre}
group by albums.title
order by {orderby}
</menudata>
--------------------
and
Code:
--------------------
<menudata>
SELECT albums.id, albums.title,
tracks.id, tracks.title
FROM tracks LEFT JOIN albums ON
albums.id=tracks.album LEFT JOIN genre_track ON tracks.id=genre_track.track
WHERE
tracks.audio=1 AND
albums.title = ( SELECT
albums.title
FROM albums
WHERE albums.id
= {album} ) AND
genre_track.genre =
{genre}
order by tracks.tracknum
asc,tracks.titlesort asc
</menudata>
--------------------
The problem I have is, that those selections work as I would expect it
in every query browser (when I put in numbers for the {genre} and
{album} place holders). But if I uses those querries from within the
SlimServer I only get weired results. I guess, I did not catch one o
two important points about how the SlimServer querries work ...
Regards, Lars
--
Lars
------------------------------------------------------------------------
Lars's Profile: http://forums.slimdevices.com/member.php?userid=6541
View this thread: http://forums.slimdevices.com/showthread.php?t=27043
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
