Is no longer working. It used to work. Basically I want all CD singles to be in a seperate menu, not in the artists & albums menu. Here's the XML file
What's working..
Singles do not appear in artists & albums.
Singles are in the artists & singles menu
But what's not correct is that Artists & Singles also has albums. I
only want Singles to be in this menu.
<?xml version="1.0"
encoding="utf-8"?><custombrowse> <menu> <id>deepartists</id>
<menuname>Artists
and
Singles</menuname> <menu> <id>variousartist</id>
<menuname>Various
Artists</menuname> <menutype>sql</menutype>
<menudata> select
contributors.id,contributors.name from
contributors where
contributors.name='Various Artists'
and
{property:server:variousArtistAutoIdentification}=1
group by
contributors.id </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
</menudata> <menu>
<id>track</id> <itemtype>track</itemtype>
<itemformat>track</itemformat>
<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.tracknum asc,tracks.titlesort
asc </menudata>
<menu> <id>trackdetails</id>
<menutype>trackdetails</menutype>
<menudata>track</menudata>
</menu> </menu>
</menu> </menu> <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 (
albums.compilation is null or
albums.compilation=0
or
{property:server:variousArtistAutoIdentification}=0
) group
by substr(contributors.namesort,1,1) order by
contributors.namesort
asc </menudata> <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 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
substr(contributors.namesort,1,1)='{artistletter}'
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>
<menulinks>alpha</menulinks> <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}
group by albums.id
order by albums.titlesort
asc </menudata>
<menu> <id>track</id>
<itemtype>track</itemtype>
<itemformat>track</itemformat>
<menutype>sql</menutype>
<menudata> select
tracks.id,tracks.title from tracks,contributor_track,albums
where
tracks.audio=1
and
contributor_track.track=tracks.id and
tracks.album={album} and
contributor_track.contributor={artist}
group by tracks.id
order by
tracks.tracknum asc,tracks.titlesort
asc </menudata>
<menu>
<id>trackdetails</id>
<menutype>trackdetails</menutype>
<menudata>track</menudata>
</menu> </menu> </menu>
</menu> </menu> </menu></custombrowse>
oops I just noticed Custom browse has a built in singles menu, so I
have no need for my filter. I assume the filter for this is single or
singles in comment tag?
--
badbob
------------------------------------------------------------------------
badbob's Profile: http://forums.slimdevices.com/member.php?userid=7358
View this thread: http://forums.slimdevices.com/showthread.php?t=63129
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
