Home of the Squeezebox™ & Transporter® network music players.
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14
  1. #11
    Junior Member
    Join Date
    Jul 2009
    Posts
    12
    Hi Erland.

    Thank you very much for for that, it works great on the PC web interface. Haven't got access to my iphones at the moment so can't check Ipeng functionality.

    Cheers........... Bruce

  2. #12
    Senior Member
    Join Date
    May 2009
    Location
    Isle Of Wight, UK
    Posts
    397
    Quote Originally Posted by erland View Post
    I don't want to change that as default, as I think it might be bad on a Boom where the the display isn't that wide so you might end up to only display artist names, but you can select the "Customize" option in the bottom of the menu configuration and see if you can figure out how to adjust it. I guess it might be hard to do the customization unless you are familiar with XML and SQL, but that's the way to handle it in case you like to change this behavior.
    I have tried using the customize option but I know only a little SQL and nothing about XML - I may investigate though. Any hints?

    Bob
    1 x Touch - LMS 7.8.0
    1 x Radio
    1 x Boom
    Lavry DA-10 DAC
    HP PC as main Media Server
    QNAP TS-509 3.6.1 running SSOTS v4.14
    Starfish Pre-amp : Based on NAIM
    Heavily modified NAIM NAP 250 Power-amp
    Behringer DEQ2496
    Linn Isobarik DMS

  3. #13
    Senior Member
    Join Date
    May 2009
    Location
    Isle Of Wight, UK
    Posts
    397
    Hi again erland,

    I think I've found the code block used by Custom Browse to sort albums by artist...

    Code:
    <option>
    	<id>byartist</id>
    	<name>Sort by artist</name>
    	<itemformat>albumconcat</itemformat>
    	<menulinks>number</menulinks>
    	<menudata>
    		select albums.id,if(albums.compilation,' ',concat('(', group_concat(distinct contributors.name) ,')')) from albums,contributor_album,contributors
    		where 
    			albums.id=contributor_album.album and
    			contributor_album.contributor=contributors.id and
    			contributor_album.role in (1,5)
    		group by albums.id
    		order by contributors.namesort asc,albums.year desc,albums.titlesort asc,albums.disc asc
    	</menudata>
    </option>
    If I wanted to swap around the order text output is displayed in the WebUI:

    From: Album (Artist)

    To: Artist (Album)

    Would that be an easy thing to do? If so - how?

    Thanks

    Bob
    1 x Touch - LMS 7.8.0
    1 x Radio
    1 x Boom
    Lavry DA-10 DAC
    HP PC as main Media Server
    QNAP TS-509 3.6.1 running SSOTS v4.14
    Starfish Pre-amp : Based on NAIM
    Heavily modified NAIM NAP 250 Power-amp
    Behringer DEQ2496
    Linn Isobarik DMS

  4. #14
    Senior Member erland's Avatar
    Join Date
    Dec 2005
    Location
    Sweden
    Posts
    10,843
    Quote Originally Posted by bobertuk View Post
    Hi again erland,

    I think I've found the code block used by Custom Browse to sort albums by artist...

    ...

    If I wanted to swap around the order text output is displayed in the WebUI:

    From: Album (Artist)

    To: Artist (Album)

    Would that be an easy thing to do? If so - how?

    Thanks

    Bob
    Try something like this:
    Code:
    <option>
    	<id>byartist</id>
    	<name>Sort by artist</name>
    	<itemformat>albumcustom</itemformat>
    	<menulinks>number</menulinks>
    	<menudata>
    		select albums.id,concat(group_concat(distinct contributors.name), '(', albums.name ,')') from albums,contributor_album,contributors
    		where 
    			albums.id=contributor_album.album and
    			contributor_album.contributor=contributors.id and
    			contributor_album.role in (1,5)
    		group by albums.id
    		order by contributors.namesort asc,albums.year desc,albums.titlesort asc,albums.disc asc
    	</menudata>
    </option>
    I have not verified this myself, I'm just trying to give you some ideas, they key changes are:
    - Change itemformat from "albumconcat" to "albumcustom", I think this is needed because "albumconcat" will add the album title first. If "albumcustom" doesn't work, you can try to remove the <itemformat>...</itemformat> row completely and see if that works, but I think albumcustom should give you albumcovers while removing itemformat row won't.
    - Adjust the first line of the SQL so it starts by adding artist names, then (, the name of the album, and )

    The above doesn't handle compilations, so there is a risk compilation albums are going to look strange.
    Erland Isaksson (My homepage)
    (Developer of many plugins/applets (both free and commercial).
    If you like to encourage future presence on this forum and/or third party plugin/applet development, consider purchasing some plugins)

    Interested in the future of music streaming ? ickStream - A world of music at your fingertips.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •