Home of the Squeezebox™ & Transporter® network music players.
Page 14 of 15 FirstFirst ... 412131415 LastLast
Results 131 to 140 of 146
  1. #131
    Senior Member
    Join Date
    Jul 2010
    Location
    Oz
    Posts
    361
    Quote Originally Posted by Philip Meyer View Post
    https://github.com/AF-1/lms-dynamicplaylists/blob/main/public.xml ?
    No, I meant manual install of the latest GitHub version for testing purposes (see GitHub page for instructions). It might not be 100% bug-free or stable but it includes all commits.

    Quote Originally Posted by Philip Meyer View Post
    I thought I read that it was necessary to uninstall DynamicPlaylist plugin, but for testing if I could get my plugin to work with either Erlands plugin or your updated version, is it safe to both installed?
    Users don't/shouldn't have more than one instance of DPL installed. For testing purposes, you could try but I don't recommend it. Not only because CLI commands, protocol handlers and such have identical names (to maintain backwards compatibility) but you might run into other unexpected problems and waste time researching/solving them.
    Plugin repositories: Ratings Light •••• Visual Statistics •••• Use Comment Tag Info •••• Dynamic Playlists 3 FAQ •••• Custom Skip 3 FAQ

  2. #132
    Senior Member Philip Meyer's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    5,596

    [Announce] Dynamic Playlists 3 (mod)

    Ah okay, makes sense. I was trying to avoid blatting my Dynamic Playlist settings, as I use this for my morning alarm clock!

    I'll have a go on my next spare weekend.

    Cheers,
    Phil

  3. #133
    Senior Member
    Join Date
    Jul 2010
    Location
    Oz
    Posts
    361
    Quote Originally Posted by bernt View Post
    Hi!

    After a few hours of trail end error I reliased that I need help. I want a one click random playlist from a specific genre.

    Here is a wild guess...
    You want the track urls so you start with the tracks table. If you used DPL to select the genre (user input parameter) then DPL would look up the genre ID and therefore all the (built-in) dynamic playlist use the genre_track table (which only matches genre IDs and track IDs). Since you want to use the genre name you'll also need the genre table with the names.
    No guarantees - here's my version:

    Code:
    -- PlaylistName:Jazz-Pop
    -- PlaylistGroups:Soft
    -- PlaylistCategory:songs
    
    select distinct tracks.url from tracks
      join genre_track on
        tracks.id = genre_track.track
      join genres on
        genre_track.genre = genres.id and genres.name like '%%Jazz%%'
      left join dynamicplaylist_history on
        dynamicplaylist_history.id=tracks.id and dynamicplaylist_history.client='PlaylistPlayer'
      where
        tracks.audio = 1
        and tracks.secs >= 'PlaylistTrackMinDuration'
        and dynamicplaylist_history.id is null
      group by tracks.id
      order by random()
      limit 'PlaylistLimit';
    Plugin repositories: Ratings Light •••• Visual Statistics •••• Use Comment Tag Info •••• Dynamic Playlists 3 FAQ •••• Custom Skip 3 FAQ

  4. #134
    Senior Member w3wilkes's Avatar
    Join Date
    Jan 2009
    Location
    Utah, USA
    Posts
    1,572
    Here's one I use for Christmas that was generated with SQL Playlists.

    Code:
    -- PlaylistName:Christmas Random Playlist
    -- PlaylistGroups:
    select tracks.url from tracks
    	join genre_track on
    		tracks.id=genre_track.track
    	join genres on
    		genre_track.genre=genres.id
    	left join dynamicplaylist_history on
    		tracks.id=dynamicplaylist_history.id and dynamicplaylist_history.client='PlaylistPlayer'
    	where
    		audio=1
    		and dynamicplaylist_history.id is null
    		and genres.name in ('Christmas')
    	group by tracks.id
    	order by random()
    	limit 10;
    Main system - Rock Solid with LMS 8.2.0 on WHS 2011 - 2 Duets and Squeeseslave
    Cabin system - Rock solid with LMS 8.2.0 on Win10 Pro - 1 RPi 3 Model B/Hifiberry DAC+ Pro/PiCorePlayer and Squeezeslave
    Squeezebox Boom - "At Large" player around both home and cabin
    Headphones and car - Android phone/Bluetooth w/full library on MicroSD card - PowerAmp music player app (similar to Material Skin)

  5. #135
    Senior Member bernt's Avatar
    Join Date
    Aug 2005
    Location
    Sweden, Kalmar
    Posts
    856
    Quote Originally Posted by afriend View Post
    You want the track urls so you start with the tracks table. If you used DPL to select the genre (user input parameter) then DPL would look up the genre ID and therefore all the (built-in) dynamic playlist use the genre_track table (which only matches genre IDs and track IDs). Since you want to use the genre name you'll also need the genre table with the names.
    No guarantees - here's my version:

    Code:
    -- PlaylistName:Jazz-Pop
    -- PlaylistGroups:Soft
    -- PlaylistCategory:songs
    
    select distinct tracks.url from tracks
      join genre_track on
        tracks.id = genre_track.track
      join genres on
        genre_track.genre = genres.id and genres.name like '%%Jazz%%'
      left join dynamicplaylist_history on
        dynamicplaylist_history.id=tracks.id and dynamicplaylist_history.client='PlaylistPlayer'
      where
        tracks.audio = 1
        and tracks.secs >= 'PlaylistTrackMinDuration'
        and dynamicplaylist_history.id is null
      group by tracks.id
      order by random()
      limit 'PlaylistLimit';
    Thanks!

    I gave up and installed SQL Playlist.
    SB Touch optical to Hegel H90, Speakers Larsen 4.2
    Spare SB3
    AirPlay Bridge to Audio Pro A10
    Squeezelite-x connected to home LMS with ZeroTier One.
    SB Radio
    ReadyNAS 202
    iPeng

  6. #136
    Senior Member bernt's Avatar
    Join Date
    Aug 2005
    Location
    Sweden, Kalmar
    Posts
    856
    Quote Originally Posted by w3wilkes View Post
    Here's one I use for Christmas that was generated with SQL Playlists.

    Code:
    -- PlaylistName:Christmas Random Playlist
    -- PlaylistGroups:
    select tracks.url from tracks
    	join genre_track on
    		tracks.id=genre_track.track
    	join genres on
    		genre_track.genre=genres.id
    	left join dynamicplaylist_history on
    		tracks.id=dynamicplaylist_history.id and dynamicplaylist_history.client='PlaylistPlayer'
    	where
    		audio=1
    		and dynamicplaylist_history.id is null
    		and genres.name in ('Christmas')
    	group by tracks.id
    	order by random()
    	limit 10;
    Thank you! Saving this one.
    SB Touch optical to Hegel H90, Speakers Larsen 4.2
    Spare SB3
    AirPlay Bridge to Audio Pro A10
    Squeezelite-x connected to home LMS with ZeroTier One.
    SB Radio
    ReadyNAS 202
    iPeng

  7. #137
    Senior Member bernt's Avatar
    Join Date
    Aug 2005
    Location
    Sweden, Kalmar
    Posts
    856
    Another one. I want tracks from a specific album mixed with tracks from a specific genre.

    I'm trying to learn SQL but I'm a slow learner, sorry!

    Code:
    -- PlaylistName:Random from mixer
    -- PlaylistGroups:
    select tracks.url from tracks
    	left join dynamicplaylist_history on
    		tracks.id=dynamicplaylist_history.id and dynamicplaylist_history.client='PlaylistPlayer'
    	join albums on
    		tracks.album=albums.id and
    		albums.title='Absolute Music 88'
    
    	join genre_track on
    		tracks.id=genre_track.track  
    	join genres on
    		genres.id=genre_track.genre and
    		genres.name='Hits'
    	
    	
    	where
    		tracks.audio=1
    		and dynamicplaylist_history.id is null
    	group by tracks.id
    	order by random()
    	limit 10;
    SB Touch optical to Hegel H90, Speakers Larsen 4.2
    Spare SB3
    AirPlay Bridge to Audio Pro A10
    Squeezelite-x connected to home LMS with ZeroTier One.
    SB Radio
    ReadyNAS 202
    iPeng

  8. #138
    Senior Member
    Join Date
    Jul 2010
    Location
    Oz
    Posts
    361
    Quote Originally Posted by bernt View Post
    Another one. I want tracks from a specific album mixed with tracks from a specific genre.

    I'm trying to learn SQL but I'm a slow learner, sorry!

    Code:
    -- PlaylistName:Random from mixer
    -- PlaylistGroups:
    select tracks.url from tracks
    	left join dynamicplaylist_history on
    		tracks.id=dynamicplaylist_history.id and dynamicplaylist_history.client='PlaylistPlayer'
    	join albums on
    		tracks.album=albums.id and
    		albums.title='Absolute Music 88'
    
    	join genre_track on
    		tracks.id=genre_track.track  
    	join genres on
    		genres.id=genre_track.genre and
    		genres.name='Hits'
    	
    	
    	where
    		tracks.audio=1
    		and dynamicplaylist_history.id is null
    	group by tracks.id
    	order by random()
    	limit 10;
    I've started a separate thread dedicated to helping users with their custom dynamic playlists.
    Plugin repositories: Ratings Light •••• Visual Statistics •••• Use Comment Tag Info •••• Dynamic Playlists 3 FAQ •••• Custom Skip 3 FAQ

  9. #139

    Latest Update

    I see that a new update was uploaded today. Can we hear more about what was changed/fixed, and how it might affect any existing playlists? Thanks.

  10. #140
    Senior Member
    Join Date
    Jul 2010
    Location
    Oz
    Posts
    361

    3.4

    Quote Originally Posted by nyindieguy View Post
    I see that a new update was uploaded today. Can we hear more about what was changed/fixed
    First place to check would be the GitHub release feed.

    3.4 comes with some new features:

    - select multiple genres: the Songs group has some built-in dynamic playlists that already use this parameter.

    - Save dynamic playlists with user input as LMS favorites: using the LMS Default or Classic skin you can now save dynamic playlists that request user input as LMS favorites.

    - Preselect artists/albums for later use: preselect artists/albums from the context menu and use them later with any dynamic playlist that includes the corresponding playlist parameter. The *Song* group includes some examples.


    Please check FAQ / wiki for more details.
    Plugin repositories: Ratings Light •••• Visual Statistics •••• Use Comment Tag Info •••• Dynamic Playlists 3 FAQ •••• Custom Skip 3 FAQ

Posting Permissions

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