*.db Files: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
|||
Line 83: | Line 83: | ||
{| class="wikitable" | {| class="wikitable" | ||
! style="background-color:#ffffd0; color:#123AAA;" | | ! style="background-color:#123AAA; color:#ffffd0;" | pageId | ||
! style="background-color:#ffffd0; color:#123AAA;" | | ! style="background-color:#123AAA; color:#ffffd0;" | pos | ||
! style="background-color:#ffffd0; color:#123AAA;" | | ! style="background-color:#123AAA; color:#ffffd0;" | iconPath | ||
! style="background-color:#ffffd0; color:#123AAA;" | | ! style="background-color:#123AAA; color:#ffffd0;" | title | ||
! style="background-color:#ffffd0; color:#123AAA;" | | ! style="background-color:#123AAA; color:#ffffd0;" | type | ||
! style="background-color:#ffffd0; color:#123AAA;" | | ! style="background-color:#123AAA; color:#ffffd0;" | command | ||
! style="background-color:#ffffd0; color:#123AAA;" | | ! style="background-color:#123AAA; color:#ffffd0;" | titleId | ||
! style="background-color:#ffffd0; color:#123AAA;" | | ! style="background-color:#123AAA; color:#ffffd0;" | icon0Type | ||
! style="background-color:#ffffd0; color:#123AAA;" | | ! style="background-color:#123AAA; color:#ffffd0;" | parentalLockLv | ||
! style="background-color:#ffffd0; color:#123AAA;" | | ! style="background-color:#123AAA; color:#ffffd0;" | status | ||
! style="background-color:#ffffd0; color:#123AAA;" | | ! style="background-color:#123AAA; color:#ffffd0;" | reserved01 | ||
! style="background-color:#123AAA; color:#ffffd0;" | reserved02 | |||
! style="background-color:#123AAA; color:#ffffd0;" | reserved03 | |||
! style="background-color:#123AAA; color:#ffffd0;" | reserved04 | |||
! style="background-color:#123AAA; color:#ffffd0;" | reserved05 | |||
|- | |||
! style="background-color:#ffffd0; color:#123AAA;" | Page ID on live area for the app | |||
! style="background-color:#ffffd0; color:#123AAA;" | Position of the app icon0 on a page | |||
! style="background-color:#ffffd0; color:#123AAA;" | icon Path partition for the app | |||
! style="background-color:#ffffd0; color:#123AAA;" | [[System_File_Object_(SFO)_(PSF)#TITLE|TITLE]] | |||
! style="background-color:#ffffd0; color:#123AAA;" | Value: 0 or if folder: number of apps inside it | |||
! style="background-color:#ffffd0; color:#123AAA;" | Null | |||
! style="background-color:#ffffd0; color:#123AAA;" | [[System_File_Object_(SFO)_(PSF)#TITLE_ID|TITLE_ID]] | |||
! style="background-color:#ffffd0; color:#123AAA;" | Value: 5, 7 for folder | |||
! style="background-color:#ffffd0; color:#123AAA;" | [[LiveArea:Parental_Controls|Parental Lock Level]] | |||
! style="background-color:#ffffd0; color:#123AAA;" | 0 | |||
! style="background-color:#ffffd0; color:#123AAA;" | Unknown | |||
! style="background-color:#ffffd0; color:#123AAA;" | reserved02 | ! style="background-color:#ffffd0; color:#123AAA;" | reserved02 | ||
! style="background-color:#ffffd0; color:#123AAA;" | reserved03 | ! style="background-color:#ffffd0; color:#123AAA;" | reserved03 | ||
! style="background-color:#ffffd0; color:#123AAA;" | reserved04 | ! style="background-color:#ffffd0; color:#123AAA;" | reserved04 | ||
! style="background-color:#ffffd0; color:#123AAA;" | reserved05 | ! style="background-color:#ffffd0; color:#123AAA;" | reserved05 | ||
|- | |- | ||
|} | |} |
Revision as of 01:35, 12 December 2015
.db files are database files.
They're usually opened with SqliteBrowser
Usefull .db
app.db
Contains paths of files used by applications.
- Path: ur0:shell/db/app.db
- Size: 260~390KB
Tables
tbl_appinfo
tittleId | key | val |
---|---|---|
<Value associated to key> |
- key's purpose:
key | Purpose |
---|---|
566916785 | Type of application (gd,gda,gdb) |
1299181514 | Product_ID (i.e.:IV0001-NPXS10007_00-WELCOMEPARK01234) |
2414097773 | Application's URI (i.e.:mailto:) |
3168212510 | Application's version (i.e.:03.010) |
278217076 | TittleID (i.e.: NPXS10007) |
3794959877 | Minimum firmware version required (decimal to hexadecimal). Where:
-22020096 = 1.500 -50397184 = 3.010 -51707904 = 3.15 |
1203824812 | Displayed minimum firmware version required |
904872283 | TittleID (i.e.:NPXS10007) |
2275227917 | Parental Control Level |
3022202214 | eboot.bin path (i.e.:vs0:app/NPXS10077/eboot.bin) |
2593862978 | Main directory of an application (i.e.:vs0:app/NPXS10077) |
966797424 | URI for near's manual (sceman:near) |
2630610402 | Livearea stuff path (i.e.:vs0:app/NPXS10077/sce_sys/livearea) |
1729228973 | Icon path
(i.e.:vs0:app/NPXS10077/sce_sys/pic0.png) (i.e.:ur0:appmeta/PCSI00009/pic0.png) |
4209668781 | Value for Title_ID NPXS: 0, others: 1 |
tbl_appinfo_icon
pageId | pos | iconPath | title | type | command | titleId | icon0Type | parentalLockLv | status | reserved01 | reserved02 | reserved03 | reserved04 | reserved05 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Page ID on live area for the app | Position of the app icon0 on a page | icon Path partition for the app | TITLE | Value: 0 or if folder: number of apps inside it | Null | TITLE_ID | Value: 5, 7 for folder | Parental Lock Level | 0 | Unknown | reserved02 | reserved03 | reserved04 | reserved05 |
tbl_appinfo_page
tbl_config
tbl_livearea
tbl_livearea_file
tbl_livearea_frame
tbl_newevent
rowid | |
id_tittle_id | (i.e.:NPXS10072) |
id_item_id | (i.e.:EmailNewEvent) |
del_flag | |
msg_type | (i.e.:256) |
act_type | Length:11 Numerical (i.e.:60129542146) |
time_updated | (i.e.:2015-09-27 00:02:28.634) |
new_flag | |
popup_no | |
icon_path | (i.e.:vs0:app/NPXS10072/sce_sys/icon0.png) |
exec_mode | |
exec_tittle_id | (i.e.:NPXS10072) |
exec_arg | (i.e.:EmailAppLaunchFromNotificationIndicator) |
title | Tittle of notification (i.e.:You have new messages.) |
desc | Description of notification (i.e.:You have new messages.) |
msg_arg0 | |
msg_arg0 | |
msg_arg2 | |
msg_arg3 | |
msg_arg4 | |
msg_arg5 | |
msg_arg6 | |
msg_arg7 | |
msg_arg8 | |
se_id | |
se_volume | |
hash | Length:10 Numerical |
icon_data |
Files.db
See main article here.
- Path: pd0:app/NPXS10007/sce_pfs/files.db
- Size: 30KB
- Use ListDirVita to read it.
pspmtp.db
- Path: ux0:mtp/pspmtp.db
- Size: 12KB
Tables
tbl_mtpObject
UID | |
ParentUID | xxxxxxxxxx<Numeric> |
ObjectFormat | xxxxx<Numeric> |
ProtectionStatus | xxxxx<Numeric> |
ObjectSize | |
DateCreated | |
DateModified | |
FullPathName | |
Name | ROOT |
NonConsumable | |
PUOID | <Non-Readable ASCII> |
Artist | |
Genre | |
Album | |
AlbumArtist | |
UseCount | |
SampleRate | |
AudioWaveCodec | |
AudioBitRate | |
OriginalReleaseDate | |
Duration | |
NumberOfChannels | |
Rating | |
BitrateType | |
DrmStatus | |
Track | |
SampleFormat | |
Buyflag | |
AudioBitDepth | |
Width | |
Height |