FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Setup Issues › Edit Static Playlist? (web edited) › Reply To: Edit Static Playlist? (web edited)
09/11/2007 at 9:36 PM
#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.