The standard New Albums Costume Browse menu returns for me a menu with
thousands of albums, which chokes the SBS. Would it be possible to limit
the number of albums shown in that menu (like the option for the
original SBS menu New Music)? What would the code for such limitation
look like and where should it be inserted?
Any help would be appreciated. Below is for reference the code for the
menu:
Code:
--------------------
<?xml version="1.0" encoding="utf-8"?>
<custombrowse>
<minslimserverversion>6.5</minslimserverversion>
<menu>
<menuname>Nya album</menuname>
<menuorder>48</menuorder>
<menu>
<id>album</id>
<menuname>Songs</menuname>
<itemtype>album</itemtype>
<itemformat>albumconcat</itemformat>
<menutype>sql</menutype>
<jivepattern>^(.*)\s\(([^,]+),?(.*)\)$</jivepattern>
<menudata>
select
albums.id,if(albums.compilation,if(albums.year=0,'
',concat('(',albums.year,')')),concat(if(albums.year=0,'(',concat('(',albums.year,',')),
group_concat(distinct contributors.name separator ',') ,')')) from tracks
join contributor_track on
tracks.id=contributor_track.track and
contributor_track.role in (5)
join contributors on
contributor_track.contributor=contributors.id
join albums on
albums.id=tracks.album
left join track_statistics on
tracks.url=track_statistics.url
where
tracks.audio=1
group by albums.id
order by max(track_statistics.added) desc
</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
where
tracks.audio=1 and
tracks.album={album}
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>
</custombrowse>
--------------------
--
vagskal
2 x SB3 (wired), Receiver (wireless), Boom (wireless), Controller, iPeng
on iPod Touch, muso on remote computer running Win XP | 7.4.2 on Win XP
------------------------------------------------------------------------
vagskal's Profile: http://forums.slimdevices.com/member.php?userid=20778
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
