It's probably easiest if I just show you the code for the menu (although the indentations don't seem to copy correctly here-I can e-mail you a copy off-line if you need me to). It uses a customtag called MEDIATYPE. Right now, the Artist headers show on the menu named Album Type and the Album headers show on the menu named Songs. I'd like to have the Artist headers also show on the menu named Albums which is the level after Album Type and before Songs.
<?xml version="1.0" encoding="utf-8"?>
<custombrowse>
<menu>
<menuname>Artists by Letter</menuname>
<menuorder>50</menuorder>
<menu>
<id>artistletter</id>
<menuname>Artist Group</menuname>
<menutype>sql</menutype>
<menulinks>alpha</menulinks>
<menudata>
select
substr(contributors.namesort,1,1),substr(contributors.namesort,1,1),substr(contributors.namesort,1,1)
from contributors,contributor_album,albums
where
contributor_album.contributor=contributors.id and
contributor_album.album=albums.id and
contributor_album.role in (1,5)
group by substr(contributors.namesort,1,1)
order by contributors.namesort asc
</menudata>
<menu>
<id>artist</id>
<menuname>Album Type</menuname>
<itemtype>artist</itemtype>
<menutype>sql</menutype>
<menulinks>alpha</menulinks>
<menudata>
select
contributors.id,contributors.name,substr(contributors.namesort,1,1)
from contributors,tracks,contributor_track,customscan_track_attributes
where
tracks.audio=1 and
tracks.id=contributor_track.track and
contributor_track.contributor=contributors.id and
contributor_track.role in (1,5)
and
substr(contributors.namesort,1,1)='{artistletter}' and
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='MEDIATYPE'
group by contributors.id
order by contributors.namesort asc
</menudata>
<menu>
<id>customtag</id>
<menuname>Albums</menuname>
<menutype>sql</menutype>
<menudata>
select
customscan_track_attributes.value,customscan_track_attributes.value
from customscan_track_attributes
join contributor_track on
contributor_track.track=customscan_track_attributes.track and
contributor_track.role
in (1,5)
where
contributor_track.contributor={artist} and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='Mediatype'
group by
customscan_track_attributes.value
order by
ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value)
asc
</menudata>
<menu>
<id>album</id>
<menuname>Songs</menuname>
<itemtype>album</itemtype>
<itemformat>album</itemformat>
<menutype>sql</menutype>
<option>
<id>byyear</id>
<name>Sort by
year</name>
<menulinks>number</menulinks>
<keyword name="orderby"
value="albums.year desc,albums.titlesort
asc"/>
</option>
<option>
<id>bytitle</id>
<name>Sort by
title</name>
<menulinks>alpha</menulinks>
<keyword name="orderby"
value="albums.titlesort asc"/>
</option>
<menudata>
select
albums.id,concat(albums.title,' ', case when
albums.year>0 then concat(' (',albums.year,')') else '' END,' ', '*
',tracks.rating,' *'),substr(albums.titlesort,1,1) from
tracks,contributor_track,albums,customscan_track_attributes
where
tracks.audio=1
and
albums.id=tracks.album and
tracks.id=contributor_track.track and
contributor_track.role in (1,5) and
contributor_track.contributor={artist} and
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='MEDIATYPE' and
customscan_track_attributes.value='{customtag}'
group by albums.id
order by {orderby}
</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,customscan_track_attributes
where
tracks.audio=1 and
contributor_track.track=tracks.id and
tracks.album={album} and
contributor_track.role in (1,5) and
contributor_track.contributor={artist} and
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='MEDIATYPE' and
customscan_track_attributes.value='{customtag}'
group by
tracks.id
order by
tracks.disc asc,tracks.tracknum asc,tracks.titlesort
asc
</menudata>
<menu>
<id>trackdetails</id>
<menutype>trackdetails</menutype>
<menudata>track</menudata>
</menu>
</menu>
</menu>
</menu>
</menu>
</menu>
</menu>
</custombrowse>
--
aeo12
------------------------------------------------------------------------
aeo12's Profile: http://forums.slimdevices.com/member.php?userid=10883
View this thread: http://forums.slimdevices.com/showthread.php?t=27043
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
