Well this is my current artist->albums->tracks menu (filtered on a special folder, the singles have their own menu), just like the original SBS artists menu (some unnecessary tags included, too lazy to tidy up ;) ):
Code:
--------------------
<?xml version="1.0" encoding="utf-8"?>
<custombrowse>
<menu>
<menuname>Alben</menuname>
<menugroup>Musik</menugroup>
<menuorder>50</menuorder>
<menu>
<id>variousartist</id>
<menulinks>alpha</menulinks>
<menuname>Diverse Interpreten</menuname>
<menutype>sql</menutype>
<menudata>
select
contributors.id,contributors.name,substr(contributors.namesort,1,1)
from contributors
where contributors.name='Diverse Interpreten'
and
{property:server:variousArtistAutoIdentification}=1
group by contributors.id
order by contributors.namesort asc
</menudata>
<menu>
<id>album</id>
<menuname>Songs</menuname>
<itemtype>album</itemtype>
<itemformat>album</itemformat>
<menutype>sql</menutype>
<menudata>
select albums.id,albums.title from
albums
where albums.compilation = 1
group by albums.id
order by albums.titlesort
asc,albums.disc asc
</menudata>
<menu>
<id>track</id>
<itemtype>track</itemtype>
<itemformat>track</itemformat>
<playtype>all</playtype>
<menutype>sql</menutype>
<menudata>
select tracks.id,tracks.title
from tracks,albums
where tracks.audio=1
and tracks.album={album}
group by tracks.id
order by
tracks.disc,tracks.tracknum asc,tracks.titlesort asc
</menudata>
<menu>
<id>trackdetails</id>
<menutype>trackdetails</menutype>
<menudata>track|0</menudata>
</menu>
</menu>
</menu>
</menu>
<menu>
<id>artist</id>
<menuname>Albums</menuname>
<itemtype>artist</itemtype>
<menutype>sql</menutype>
<menulinks>alpha</menulinks>
<menudata>
select
contributors.id,contributors.name,substr(contributors.namesort,1,1)
from
contributors,contributor_album,albums,tracks
where contributor_album.contributor =
contributors.id
and contributor_album.album = albums.id
and contributor_album.role in (1,5)
and
(
albums.compilation is null
or albums.compilation=0
or
{property:server:variousArtistAutoIdentification} = 0
)
and tracks.album = albums.id
and tracks.url like '%/share/Musik/Alben/%'
group by contributors.id
order by contributors.namesort asc
</menudata>
<menu>
<id>album</id>
<menuname>Songs</menuname>
<itemtype>album</itemtype>
<itemformat>album</itemformat>
<menutype>sql</menutype>
<jivepattern>^(.*)\s\((.*)\)$</jivepattern>
<menudata>
select
albums.id,albums.title,substr(albums.titlesort,1,1)
from contributor_album,albums
where albums.id =
contributor_album.album
and contributor_album.contributor =
{artist}
and contributor_album.role in (1,5)
and albums.title not in ('Kein Album')
group by albums.id
order by albums.titlesort
asc,albums.disc asc
</menudata>
<menu>
<id>track</id>
<itemtype>track</itemtype>
<itemformat>titleformat</itemformat>
<itemformatdata>TITLE
(DURATION)</itemformatdata>
<playtype>all</playtype>
<menutype>sql</menutype>
<jivepattern>^(.*)\s\((.*)\)$</jivepattern>
<menudata>
select
tracks.id,tracks.title,substr(tracks.title,1,1)
from
tracks,contributor_track,albums
where tracks.audio = 1
and contributor_track.track =
tracks.id
and tracks.album = {album}
and
contributor_track.contributor = {artist}
and contributor_track.role
in (1,5)
group by tracks.id
order by
tracks.disc,tracks.tracknum asc,tracks.titlesort asc
</menudata>
<menu>
<id>trackdetails</id>
<menutype>trackdetails</menutype>
<menudata>track|0</menudata>
</menu>
</menu>
</menu>
</menu>
</menu>
</custombrowse>
--------------------
Maybe someone can tell me why this menu doesn't group the artists on
iPeng, but the original SBS artists menu does (with the exactly same
data load)?
--
sts78
------------------------------------------------------------------------
sts78's Profile: http://forums.slimdevices.com/member.php?userid=50205
View this thread: http://forums.slimdevices.com/showthread.php?t=90754
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
