Re: [SlimDevices: Plugins] Custom Browse singles

[badbob]

hmm ok it's put singles into singles branch, but they're all in one big
list, past the artist. Not so bad if you have only a few CD singles on
each artist, but on a couple have 20+ singles. Contents of singles.xml
is





Singles

artist
Songs
artist
sql
alpha

select distinct
contributors.id,contributors.name,substr(contributors.namesort,1,1) from
contributors,contributor_track,tracks,comments
where

contributors.id=contributor_track.contributor and

contributor_track.track=tracks.id and
contributor_track.role in (1,5)
and
comments.track=tracks.id and
comments.value='singles' and
tracks.audio=1
group by contributors.id
order by contributors.namesort asc


track
Songs
track
track
sql

select tracks.id,tracks.title from
contributor_track,tracks,comments 
where 

tracks.id=contributor_track.track and 
contributor_track.role in (1,5) 
and

contributor_track.contributor={artist} and
comments.track=tracks.id and
comments.value='singles' and
tracks.audio=1
group by tracks.id 
order by tracks.titlesort asc


trackdetails
trackdetails
track







How would I get it to use the similar artist/album/ stucture?


-- 
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

[SlimDevices: Plugins] Custom Browse singles

[badbob]

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.


  deepartists
Artists
and
Singlesvariousartist  
Various
Artists  sql
  select
contributors.id,contributors.name from
contributorswhere   
contributors.name='Various Artists'
and 
{property:server:variousArtistAutoIdentification}=1 
group by
contributors.id
album  
Songs  
album  
album  
sql  
select
albums.id,albums.title from albums  where   
albums.compilation =
1   group by albums.id  
order by albums.titlesort asc  

   
track  track  
track  
sql
  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  
  trackdetails   
trackdetails   
track  
  
artistletter   
Artist
Groupsql
alpha  
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
artist Albums 
artist 
sql
alpha   
  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
album  
Songs  
album  
album  
sql