vagskal;519502 Wrote:
> 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?
>
It all depends why it's slow, it could be that the query takes time.
However, if it's the amount of albums returned, you can add a "limit 50"
to the SQL statement to limit the result to 50 albums. I should probably
add a parameter for this in the template, feels like a useful option.
The configuration would look something like this:
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
limit 50
</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>
--------------------
--
erland
Erland Isaksson
'My homepage' (http://erland.isaksson.info) (Install my plugins through
Extension Downloader)
(Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse,
Custom Scan, Custom Skip, Multi Library, Title Switcher and Database
Query plugins'
(http://wiki.erland.isaksson.info/index.php/Category:SlimServer))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
