Here is my menu. I enclosed this as txt-file also as attachment. Also
enclosed screenshots how things are shown on iPeng.

Thank you again, Erland!


<?xml version="1.0" encoding="utf-8"?>
<custombrowse>
        <menu>
            <menuname>Albums1</menuname>
                <menuorder>50</menuorder>
                <menu>
                        <id>album</id>
                        <menuname>Songs</menuname>
                        <itemtype>album</itemtype>
                        <itemformat>albumconcat</itemformat>
                        <menutype>sql</menutype>
                        <jivepattern>^(.*)\s\((.*)\)\s\((.*)\)$</jivepattern>
                        <menudata>
                                select 
                                        albums.id,
                                        concat(
                                                '(',contributors.name,')',
                                                if(albums.year=0,' ( 
)',concat(' (',albums.year,')'))
                                        ),
                                        substr(albums.titlesort,1,1)
                                from 
                                        albums
                                join contributor_album on
                                        albums.id = contributor_album.album
                                join contributors on 
                                        contributor_album.contributor = 
contributors.id
                                join tracks on 
                                        albums.id = tracks.album
                                left join customscan_track_attributes on 
                                        
tracks.id=customscan_track_attributes.track
                                where
                                        contributor_album.role in (1,5) and
                                        tracks.audio = 1 and
                                        
customscan_track_attributes.module='customtag' and
                                        
customscan_track_attributes.attr='YEARSORT'
                                group by 
                                        albums.id 
                                order by 
                                        contributors.namesort asc, 
                                        albums.year asc, 
                                        customscan_track_attributes.value asc,
                                        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 
                                        where 
                                                tracks.audio=1 and 
                                                tracks.album={album} 
                                        order by 
                                                
tracks.disc,tracks.tracknum,tracks.titlesort asc
                                </menudata>
                                <menu>
                                        <id>trackdetails</id>
                                        <menutype>trackdetails</menutype>
                                        <menudata>track|0</menudata>
                                </menu>
                        </menu>
                </menu>
        </menu>
</custombrowse>


+-------------------------------------------------------------------+
|Filename: CustomMenu.txt                                           |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=11704|
+-------------------------------------------------------------------+

-- 
auster
------------------------------------------------------------------------
auster's Profile: http://forums.slimdevices.com/member.php?userid=43850
View this thread: http://forums.slimdevices.com/showthread.php?t=86949

_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins

Reply via email to