Advertising (This ad goes away for registered users. You can Login or Register)

Add Music Playlists on Vita (using db file)

Post here your guides, tips, how-to, etc...
Post Reply
ManifestX
Posts: 6
Joined: Thu Feb 20, 2014 10:38 pm

Add Music Playlists on Vita (using db file)

Post by ManifestX » Tue Mar 20, 2018 3:16 am

Who is this for:

- Users without a PS3
- No PS Login, can't use CMA/PS3
- Users with music and want the songs in a playlist

Needed:

- PS Vita (with Henkaku)
- `DB Browser for SQLite` Application
- Music imported either by Media Importer v0.91 Homebrew or CMA

Steps:

Get AVContent.db:
1. Open VitaShell, press Select (FTP)
2. With FileZilla, or any other FTP program, go to ux0:mms\music\.
3. Copy AVContent.db to PC; It is recommended for you to make a backup in case of errors

Create Playlist:
1. Open DB Browser for SQLite
2. Open Database, select AVContent.db
3. Click on `Browse Data` tab
4. Go to the drop down table selection: tbl_AVContentList
5. Select the button `New Record`. My created ID is `72057628397666305`
6. Change type field to `2`
7. Change title field to whatever you like; I put `Zombie`, but it can be null as well.
[spoiler]Image[/spoiler]

Find Music IDs:
1. Go to the drop down table selection: tbl_Music
2. Find the IDs you would like to be in the playlist. I am using IDs `72057611217797183` to `72057611217797186`
[spoiler]Image[/spoiler]

Add songs to Playlist:
1. Go to the drop down table selection: tbl_AVContentItem
2. New Record -- If error, then go into Execute SQL tab:

INSERT INTO "tbl_AVContentItem"("id", "list_id", "item_id", "item_type") VALUES (NULL, 72057628397666305, 72057611217797183, 3);
/*
For each playlist that you added, you would need to change the first value (72057628397666305); for each music id (song), you need to change the second value (72057611217797183) according to the playlist and/or song that you are managing.

Legend:
`72057628397666305` = ID of Playlist
`72057611217797183` = ID of music
*/
3. The order of the music in the playlist is the value under order_of_item.
The first item is 0, and then is incremented by 1000.
i.e. 0, 1000, 2000...9000, 10000, 11000, etc.
[spoiler]Image[/spoiler]

Finale:
1. Once done press CTRL+S or `File` > `Write Changes`
2. Replace AVContent.db on your Vita at the following path: ux0:mms/music/
3. There is no reason to reboot, just go straight into Music bubble and your new Playlist should be there
[spoiler]Image[/spoiler]

Please let me know if there is any additions or errors anybody experiences.

Regards,
Advertising
Last edited by ManifestX on Tue Mar 20, 2018 9:17 pm, edited 1 time in total.
1 x PSP Phat 1000
1 x PSP 3000
2 x PS TV (3.65)
2 x PS Vita (3.65)
1 x PS1 (Modded)
1 x PS2 (Modded)
1 x Phat PS3 1.5TB CFW REBUG
1 x Slim PS3 500GB CFW REBUG
1 x PS4 6TB - 4.55
1 x PS4 6TB - latest FW

Lestatlh
Posts: 1
Joined: Tue Mar 20, 2018 1:43 pm

Re: Add Music Playlists on Vita (using db file)

Post by Lestatlh » Tue Mar 20, 2018 1:52 pm

@ManifestX, i need to thank you so much, this works like a charm; is a lot of work adding songs one at the time, but i do everything exactly you as you say exept for this:

2. New Record -- If error, then go into Execute SQL tab:

INSERT INTO "tbl_AVContentItem"("id", "list_id", "item_id", "item_type") VALUES (NULL, 72057628397666305, 72057611217797183, 3);

for each list you need to change the first value (72057628397666305) and for each song you need to change the second value (72057611217797183) acording to the list/song you created. (is in there but maybe a little confusing)

i hope that someone could make a hombrew making this more easy, but i really thank u for this guide, i was trying to find something for making/adding playlist to the ps vita like 2-3 weeks and nothing until NOW.
Advertising

ManifestX
Posts: 6
Joined: Thu Feb 20, 2014 10:38 pm

Re: Add Music Playlists on Vita (using db file)

Post by ManifestX » Tue Mar 20, 2018 9:21 pm

I hear you @Lestatlh. I was also going through the same thing, and it was driving me crazy. I took it into my own hands, and I figured out how the sqlite db worked and decided to share.
I also changed the step that you mentioned, hopefully it is easier to follow now.

Cheers,
1 x PSP Phat 1000
1 x PSP 3000
2 x PS TV (3.65)
2 x PS Vita (3.65)
1 x PS1 (Modded)
1 x PS2 (Modded)
1 x Phat PS3 1.5TB CFW REBUG
1 x Slim PS3 500GB CFW REBUG
1 x PS4 6TB - 4.55
1 x PS4 6TB - latest FW

Post Reply

Return to “Tutorials”