- 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][/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][/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][/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][/spoiler]
Please let me know if there is any additions or errors anybody experiences.
Regards,
Advertising