Here are the custon menus I use:
-----------------------------------
<?xml version="1.0" encoding="utf-8" ?>
- <custombrowse>
- <menu>
<menuname>Komponisten (Klassik)</menuname>
<menuorder>50</menuorder>
- <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,multilibrary_contributor where
contributors.id=multilibrary_contributor.contributor and
multilibrary_contributor.library=1 and
contributor_album.contributor=contributors.id and
contributor_album.role in (2) 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 from
contributor_album,albums,multilibrary_album where
albums.id=multilibrary_album.album and multilibrary_album.library=1 and
albums.id=contributor_album.album and contributor_album.role in (2) and
contributor_album.contributor={artist} 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,contributor_track,albums,multilibrary_track where
tracks.id=multilibrary_track.track and multilibrary_track.library=1 and
tracks.audio=1 and contributor_track.track=tracks.id and
tracks.album={album} and contributor_track.role in (2) and
contributor_track.contributor={artist} 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|library=1</menudata>
</menu>
</menu>
</menu>
</menu>
</menu>
</custombrowse>
-----------------------------------
<?xml version="1.0" encoding="utf-8" ?>
- <custombrowse>
- <menu>
<menuname>Alben (Klassik)</menuname>
<menuorder>50</menuorder>
- <menu>
<id>album</id>
<menuname>Songs</menuname>
<itemtype>album</itemtype>
<itemformat>album</itemformat>
<menutype>sql</menutype>
<defaultoption>bytitle</defaultoption>
<menulinks>alpha</menulinks>
- <option>
<id>bytitle</id>
<name>Sort by title</name>
</option>
- <option>
<id>byyear</id>
<name>Sort by year</name>
<menulinks>number</menulinks>
<itemformat>albumconcat</itemformat>
<menudata>select albums.id,if(albums.year=0,'
',concat('(',albums.year,')')),substr(albums.titlesort,1,1) from
tracks,albums,multilibrary_track where
tracks.id=multilibrary_track.track and multilibrary_track.library=1 and
albums.id=tracks.album group by albums.id order by albums.year
desc,albums.titlesort asc,albums.disc asc</menudata>
</option>
- <option>
<id>byartist</id>
<name>Sort by artist</name>
<menulinks>number</menulinks>
<itemformat>albumconcat</itemformat>
<menudata>select albums.id,if(albums.compilation,' ',concat('(',
group_concat(distinct contributors.name separator ',') ,')')) from
tracks,albums,contributor_track,contributors,multilibrary_track where
tracks.id=multilibrary_track.track and multilibrary_track.library=1 and
tracks.id=contributor_track.track and contributor_track.role in
(1,2,5,6) and contributor_track.contributor=contributors.id and
albums.id=tracks.album group by albums.id order by
contributors.namesort asc,albums.year desc,albums.titlesort
asc,albums.disc asc</menudata>
</option>
<jivepattern>^(.*)\s\((.*)\)$</jivepattern>
<menudata>select albums.id,albums.title,substr(albums.titlesort,1,1)
from tracks,albums,multilibrary_track where
tracks.id=multilibrary_track.track and multilibrary_track.library=1 and
albums.id=tracks.album 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,multilibrary_track where tracks.id=multilibrary_track.track and
multilibrary_track.library=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|library=1</menudata>
</menu>
</menu>
</menu>
</menu>
</custombrowse>
-----------------------------------
<?xml version="1.0" encoding="utf-8" ?>
- <custombrowse>
- <template>
<id>artists.xml</id>
- <parameter type="text" id="menuname">
<value>Interpreten (Pop&Jazz)</value>
</parameter>
<parameter type="text" id="menugroup" />
- <parameter type="text" id="menuorder">
<value>50</value>
</parameter>
<parameter type="text" id="roles" />
- <parameter type="text" id="variousartists">
<value>1</value>
</parameter>
+ <parameter type="text" id="variousartisttext">
<value>Various Artists</value>
</parameter>
- <parameter type="text" id="defaultalbumsort">
<value>bytitle</value>
</parameter>
- <parameter type="text" id="playalltracks">
<value>1</value>
</parameter>
- <parameter type="text" id="library">
<value>3</value>
</parameter>
- <parameter type="text" id="activelibrary">
<value>0</value>
</parameter>
<parameter type="text" id="includedclients" />
<parameter type="text" id="excludedclients" />
<parameter type="text" id="includedlibraries" />
<parameter type="text" id="excludedlibraries" />
</template>
</custombrowse>
--
Fried
------------------------------------------------------------------------
Fried's Profile: http://forums.slimdevices.com/member.php?userid=34444
View this thread: http://forums.slimdevices.com/showthread.php?t=85246
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
