You are here: Home » Reply » Reply To: Edit Static Playlist? (web edited)

Reply To: Edit Static Playlist? (web edited)

#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.