Edit Static Playlist? (web edited)

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #1923
    blamm
    Participant

    I have created a Static Playlist via the Firefly playlist webpage. I want to edit it. Does it exist on the disc anywhere?

    #14300
    sonichouse
    Participant

    The playlists are in the database, so you need to execute some sql using sqlite.

    bash-3.2# sqlite3 /opt/var/mt-daapd/songs3.db
    SQLite version 3.4.1
    Enter ".help" for instructions
    sqlite> .headers ON
    sqlite> select * from playlists;
    id|title|type|items|query|db_timestamp|path|idx
    1|Library|1|2686|1|0||0
    3|Muse - Black Holes & Revelations|1|11|artist = "Muse" AND album includes "Black"|0||0
    4|Prince - Planet Earth|1|10|artist = "Prince" and album ="Planet Earth"|0||0
    5|Moby - Play|1|18|artist="Moby" and album="Play"|0||0
    6|Jamelia - Thank You|1|14|artist="Jamelia" and album="Thank You"|0||0
    7|Coldplay - X & Y|1|13|artist="Coldplay" and album="X & Y"|0||0
    8|KT Tunstall - Eye to the telescope|1|12|artist="KT Tunstall" and album="Eye to the Telescope"|0||0
    10|Jack Johnson|1|15|artist="Jack Johnson"|0||0
    11|Lily Allen - Alright Still|1|11|Artist = "Lily Allen" and album = "Alright, S
    till"|0||0
    12|Shaggy|1|14|artist="Shaggy"|0||0
    14|The Rolling Stone Magazines 500 Greatest Songs Of All Time|1|501|album includes "The Rolling Stone Magazines 500 Greatest Songs Of All Time"|0||0
    16|podcast|2|13||1194509883|/share/hdd/data/public/mp3/podcasts/podcast.m3u|0
    sqlite>

    You can then issue an update set query=’xxxxx’ where id=x

    #14301
    blamm
    Participant

    Ouch 🙁

    #14302
    sonichouse
    Participant

    @blamm wrote:

    Ouch 🙁

    Sorry, but my taste in music is quite eclictic 🙂

    #14303
    blamm
    Participant

    That was a reaction to the solution not your playlist. 😉

    Is that the “sql” for a static playlist?

    #14304
    sonichouse
    Participant

    Sorry, a static playlist is an .m3u file that is parsed by firefly.
    In my example, if have podcast.m3u which is just a list of mp3 files.
    e.g

    bash-3.2# cat podcast.m3u
    dailysourcecode-86176-11-05-2007_pshow_201439.mp3
    dailysourcecode-86406-11-07-2007_pshow_202204.mp3
    drkarl_20071101-1448.mp3
    drkarl_20071108-0348.mp3
    fricomedy_20071026-1855.mp3
    fricomedy_20071102-1845.mp3
    scia_20071102-1230.mp3
    scia_20071109-1230.mp3

    so you could you just edit the m3u file

    #14305
    blamm
    Participant

    Yes. But I created this static playlist thru the hidden “playlist” page so I have no idea where I can edit it.

    #14306
    sonichouse
    Participant

    @blamm wrote:

    Yes. But I created this static playlist thru the hidden “playlist” page so I have no idea where I can edit it.

    Sorry again,I now understand.

    they are stored in the database in playlistitems.

    I wrote this sql to retrieve them

    sqlite> select p.id,p.title,songid,s.path from playlistitems l inner join playlists p on l.playlistid=p.id inner join songs s on s.id=l.songid;

    17|podcast|3300|/share/hdd/data/public/mp3/podcasts/dailysourcecode-85376-10-30-2007_pshow_198056.mp3
    17|podcast|3299|/share/hdd/data/public/mp3/podcasts/dailysourcecode-85638-11-01-2007_pshow_199356.mp3
    17|podcast|3298|/share/hdd/data/public/mp3/podcasts/dailysourcecode-85765-11-01-2007_pshow_199687.mp3
    17|podcast|3301|/share/hdd/data/public/mp3/podcasts/dailysourcecode-86176-11-05-2007_pshow_201439.mp3
    17|podcast|3303|/share/hdd/data/public/mp3/podcasts/dailysourcecode-86406-11-07-2007_pshow_202204.mp3
    17|podcast|3291|/share/hdd/data/public/mp3/podcasts/drkarl_20071101-1448.mp3
    17|podcast|3302|/share/hdd/data/public/mp3/podcasts/drkarl_20071108-0348.mp3
    17|podcast|3293|/share/hdd/data/public/mp3/podcasts/fricomedy_20071026-1855.mp3
    17|podcast|3296|/share/hdd/data/public/mp3/podcasts/fricomedy_20071102-1845.mp3
    17|podcast|3305|/share/hdd/data/public/mp3/podcasts/fricomedy_20071109-1855.mp3
    17|podcast|3294|/share/hdd/data/public/mp3/podcasts/ross_20071027-1416.mp3
    17|podcast|3297|/share/hdd/data/public/mp3/podcasts/ross_20071103-1600.mp3
    17|podcast|3292|/share/hdd/data/public/mp3/podcasts/scia_20071026-1300.mp3
    17|podcast|3295|/share/hdd/data/public/mp3/podcasts/scia_20071102-1230.mp3
    17|podcast|3304|/share/hdd/data/public/mp3/podcasts/scia_20071109-1230.mp3
    17|podcast|2551|/share/hdd/data/public/mp3/iTunes Music/Lily Allen/Alright, Still/07 Shame For You.m4a
    17|podcast|1638|/share/hdd/data/public/mp3/iTunes Music/KT Tunstall/Eye to the Telescope/06 Silent Sea.m4a
    17|podcast|1635|/share/hdd/data/public/mp3/iTunes Music/KT Tunstall/Eye to the Telescope/03 Under the Weather.m4a
    17|podcast|1633|/share/hdd/data/public/mp3/iTunes Music/KT Tunstall/Eye to the Telescope/01 Other Side of the World.m4a
    17|podcast|1361|/share/hdd/data/public/mp3/iTunes Music/Jean-Michel Jarre/Equinoxe/06 Equinoxe Part 6.mp3
    17|podcast|1359|/share/hdd/data/public/mp3/iTunes Music/Jean-Michel Jarre/Equinoxe/04 Equinoxe Part 4.mp3
    17|podcast|1357|/share/hdd/data/public/mp3/iTunes Music/Jean-Michel Jarre/Equinoxe/02 Equinoxe Part 2.mp3
    17|podcast|1356|/share/hdd/data/public/mp3/iTunes Music/Jean-Michel Jarre/Equinoxe/01 Equinoxe Part 1.mp3

    playlistitems has the following structure

    sqlite> .schema playlistitems
    CREATE TABLE playlistitems (
    id INTEGER PRIMARY KEY NOT NULL,
    playlistid INTEGER NOT NULL,
    songid INTEGER NOT NULL
    );

    so you need to add/remove rows in that table – not for the faint hearted 🙂

    Does pressing delete on the song not work ?

    Dragging a song to a playlist will add it I found.

    #14307
    shark64
    Guest

    From reading the above it appears that maybe the best way to get rid of the static playlist is to do some sort of database rebuilt. Will a full scan do this or do I have to uninstall firefly and then reinstall from scratch? Seems like a lot of trouble to delete a few static playlists but if that is the only way then so be it.
    Shark

Viewing 9 posts - 1 through 9 (of 9 total)
  • The forum ‘Setup Issues’ is closed to new topics and replies.