App.db: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Category:Software<noinclude>Category:Main</noinclude> === app.db === Contains paths of files used by applications. * Path: ur0:shell/db/app.db * Size: 260~390KB ===...") |
Treasgaming (talk | contribs) |
||
(15 intermediate revisions by 7 users not shown) | |||
Line 2: | Line 2: | ||
=== app.db === | === app.db === | ||
Application Database used by SceShell for storing themes, notifications, and application metadata. | |||
* Path: ur0:shell/db/app.db | * Path: ur0:shell/db/app.db | ||
* Size: 260~390KB | * Size: 260~390KB | ||
==== Tables ==== | ==== Tables ==== | ||
===== tbl_appinfo ===== | ===== tbl_appinfo ===== | ||
{| class="wikitable" | {| class="wikitable" | ||
! style="font-weight: bold;" | | ! style="font-weight: bold;" | titleId | ||
! style="font-weight: bold;" | key | ! style="font-weight: bold;" | key | ||
! style="font-weight: bold;" | val | ! style="font-weight: bold;" | val | ||
Line 19: | Line 20: | ||
* key's purpose: | * key's purpose: | ||
'key' is a `fnv1a32` hash in decimal of the SFO parameter's name, here are some examples: | |||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
! style="font-weight: bold;" | key | ! style="font-weight: bold;" | key | ||
Line 24: | Line 26: | ||
|- | |- | ||
| 566916785 | | 566916785 | ||
| [[System_File_Object_(SFO)_(PSF)#CATEGORY| | | [[System_File_Object_(SFO)_(PSF)#CATEGORY|CATEGORY]] (gd, gda, gdb, gp) | ||
|- | |- | ||
| 1299181514 | | 1299181514 | ||
| [ | | [[System_File_Object_(SFO)_(PSF)#CONTENT_ID|CONTENT_ID]] (i.e.: IV0001-NPXS10007_00-WELCOMEPARK01234) | ||
|- | |- | ||
| 2414097773 | | 2414097773 | ||
| [[ | | [[System_File_Object_(SFO)_(PSF)#SUPPORT_URI|SUPPORT_URI]] (i.e.: mailto:) | ||
|- | |- | ||
| 3168212510 | | 3168212510 | ||
| | | [[System_File_Object_(SFO)_(PSF)#PSP2_SYSTEM_VER|PSP2_SYSTEM_VER]] (i.e.:03.010) | ||
|- | |- | ||
| 278217076 | | 278217076 | ||
| | | [[System_File_Object_(SFO)_(PSF)#TITLE_ID|TITLE_ID]](i.e.: NPXS10007) | ||
|- | |- | ||
| 3794959877 | | 3794959877 | ||
Line 48: | Line 50: | ||
|- | |- | ||
| 904872283 | | 904872283 | ||
| | | TitleID (i.e.: NPXS10007) | ||
|- | |- | ||
| 2275227917 | | 2275227917 | ||
Line 54: | Line 56: | ||
|- | |- | ||
| 3022202214 | | 3022202214 | ||
| eboot.bin path (i.e.:vs0:app/NPXS10077/eboot.bin) | | eboot.bin path (i.e.: vs0:app/NPXS10077/eboot.bin) | ||
|- | |- | ||
| 2593862978 | | 2593862978 | ||
| Main directory of an application (i.e.:vs0:app/NPXS10077) | | Main directory of an application (i.e.: vs0:app/NPXS10077) | ||
|- | |- | ||
| 966797424 | | 966797424 | ||
Line 67: | Line 69: | ||
| 1729228973 | | 1729228973 | ||
| Icon path | | Icon path | ||
(i.e.:vs0:app/NPXS10077/sce_sys/pic0.png) | (i.e.: vs0:app/NPXS10077/sce_sys/pic0.png) | ||
(i.e.:ur0:appmeta/PCSI00009/pic0.png) | (i.e.: ur0:appmeta/PCSI00009/pic0.png) | ||
|- | |- | ||
| 4209668781 | | 4209668781 | ||
Line 78: | Line 80: | ||
{| class="wikitable" | {| class="wikitable" | ||
! style="background-color:#123AAA; color:#ffffd0;" | pageId | ! style="background-color:#123AAA; color:#ffffd0;" | pageId 6 | ||
! style="background-color:#123AAA; color:#ffffd0;" | pos | ! style="background-color:#123AAA; color:#ffffd0;" | pos 9 | ||
! style="background-color:#123AAA; color:#ffffd0;" | iconPath | ! style="background-color:#123AAA; color:#ffffd0;" | iconPath vs0:app/NPXS10021/sce_sys/pic0.png | ||
! style="background-color:#123AAA; color:#ffffd0;" | title | ! style="background-color:#123AAA; color:#ffffd0;" | title Ağ Operatörü | ||
! style="background-color:#123AAA; color:#ffffd0;" | type | ! style="background-color:#123AAA; color:#ffffd0;" | type 0 | ||
! style="background-color:#123AAA; color:#ffffd0;" | command | ! style="background-color:#123AAA; color:#ffffd0;" | command | ||
! style="background-color:#123AAA; color:#ffffd0;" | titleId | ! style="background-color:#123AAA; color:#ffffd0;" | titleId NPXS10021 | ||
! style="background-color:#123AAA; color:#ffffd0;" | icon0Type | ! style="background-color:#123AAA; color:#ffffd0;" | icon0Type 5 | ||
! style="background-color:#123AAA; color:#ffffd0;" | parentalLockLv | ! style="background-color:#123AAA; color:#ffffd0;" | parentalLockLv 1 | ||
! style="background-color:#123AAA; color:#ffffd0;" | status | ! style="background-color:#123AAA; color:#ffffd0;" | status 0 | ||
! style="background-color:#123AAA; color:#ffffd0;" | reserved01 | ! style="background-color:#123AAA; color:#ffffd0;" | reserved01 | ||
! style="background-color:#123AAA; color:#ffffd0;" | reserved02 | ! style="background-color:#123AAA; color:#ffffd0;" | reserved02 | ||
Line 101: | Line 103: | ||
! style="background-color:#ffffd0; color:#123AAA;" | Null | ! 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;" | [[System_File_Object_(SFO)_(PSF)#TITLE_ID|TITLE_ID]] | ||
! style="background-color:#ffffd0; color:#123AAA;" | | ! style="background-color:#ffffd0; color:#123AAA;" | 5 for an App or 7 for a folder | ||
! style="background-color:#ffffd0; color:#123AAA;" | [[LiveArea:Parental_Controls|Parental Lock Level]] | ! 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;" | 0 | ||
! style="background-color:#ffffd0; color:#123AAA;" | | ! style="background-color:#ffffd0; color:#123AAA;" | Used for folders to save the pageId of there content | ||
! 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;" | | ! style="background-color:#ffffd0; color:#123AAA;" | Used by folders to store the icon of the folder in a dds format. ~16.6kbyte big | ||
|} | |} | ||
===== tbl_appinfo_page ===== | ===== tbl_appinfo_page ===== | ||
{| class="wikitable" | |||
! style="background-color:#123AAA; color:#ffffd0;" | pageId | |||
! style="background-color:#123AAA; color:#ffffd0;" | pageNo | |||
! style="background-color:#123AAA; color:#ffffd0;" | themeFile | |||
! style="background-color:#123AAA; color:#ffffd0;" | bgColor | |||
! style="background-color:#123AAA; color:#ffffd0;" | texWidth | |||
! style="background-color:#123AAA; color:#ffffd0;" | texHeight | |||
! style="background-color:#123AAA; color:#ffffd0;" | imageWidth | |||
! style="background-color:#123AAA; color:#ffffd0;" | imageHeight | |||
! 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 used to identify pages with apps | |||
! style="background-color:#ffffd0; color:#123AAA;" | Position of the Page from 0-9 (max number of Pages is 10). For Folders it is a negative value with a leading "-1" followed by 7 digits. | |||
! style="background-color:#ffffd0; color:#123AAA;" | - | |||
! style="background-color:#ffffd0; color:#123AAA;" | Color of the Background. Value between 0-30 | |||
! style="background-color:#ffffd0; color:#123AAA;" | - | |||
! style="background-color:#ffffd0; color:#123AAA;" | - | |||
! style="background-color:#ffffd0; color:#123AAA;" | - | |||
! style="background-color:#ffffd0; color:#123AAA;" | - | |||
! style="background-color:#ffffd0; color:#123AAA;" | - | |||
! style="background-color:#ffffd0; color:#123AAA;" | NULL | |||
! style="background-color:#ffffd0; color:#123AAA;" | NULL | |||
! style="background-color:#ffffd0; color:#123AAA;" | NULL | |||
! style="background-color:#ffffd0; color:#123AAA;" | NULL | |||
|} | |||
===== tbl_config ===== | ===== tbl_config ===== | ||
Line 123: | Line 154: | ||
===== tbl_newevent ===== | ===== tbl_newevent ===== | ||
{| class="wikitable" | {| class="wikitable" | ||
| style="font-weight: bold;" | rowid | | style="font-weight: bold;" | rowid | ||
| | | | ||
|- | |- | ||
| style="font-weight: bold;" | | | style="font-weight: bold;" | id_title_id | ||
| (i.e.:NPXS10072) | | (i.e.: NPXS10072) | ||
|- | |- | ||
| style="font-weight: bold;" | id_item_id | | style="font-weight: bold;" | id_item_id | ||
| (i.e.:EmailNewEvent) | | (i.e.: EmailNewEvent) | ||
|- | |- | ||
| style="font-weight: bold;" | del_flag | | style="font-weight: bold;" | del_flag | ||
Line 140: | Line 172: | ||
|- | |- | ||
| style="font-weight: bold;" | act_type | | style="font-weight: bold;" | act_type | ||
| Length:11 Numerical (i.e.:60129542146) | | Length: 11 Numerical (i.e.: 60129542146) | ||
|- | |- | ||
| style="font-weight: bold;" | time_updated | | style="font-weight: bold;" | time_updated | ||
| (i.e.:2015-09-27 00:02:28.634) | | (i.e.: 2015-09-27 00:02:28.634) | ||
|- | |- | ||
| style="font-weight: bold;" | new_flag | | style="font-weight: bold;" | new_flag | ||
Line 152: | Line 184: | ||
|- | |- | ||
| style="font-weight: bold;" | icon_path | | style="font-weight: bold;" | icon_path | ||
| (i.e.:vs0:app/NPXS10072/sce_sys/icon0.png) | | (i.e.: vs0:app/NPXS10072/sce_sys/icon0.png) | ||
|- | |- | ||
| style="font-weight: bold;" | exec_mode | | style="font-weight: bold;" | exec_mode | ||
| | | | ||
|- | |- | ||
| style="font-weight: bold;" | | | style="font-weight: bold;" | exec_title_id | ||
| (i.e.:NPXS10072) | | (i.e.: NPXS10072) | ||
|- | |- | ||
| style="font-weight: bold;" | exec_arg | | style="font-weight: bold;" | exec_arg | ||
| (i.e.:EmailAppLaunchFromNotificationIndicator) | | (i.e.: EmailAppLaunchFromNotificationIndicator) | ||
|- | |- | ||
| style="font-weight: bold;" | title | | style="font-weight: bold;" | title | ||
| | | Title of notification (i.e.: You have new messages.) | ||
|- | |- | ||
| style="font-weight: bold;" | desc | | style="font-weight: bold;" | desc | ||
| Description of notification (i.e.:You have new messages.) | | Description of notification (i.e.: You have new messages.) | ||
|- | |- | ||
| style="font-weight: bold;" | msg_arg0 | | style="font-weight: bold;" | msg_arg0 | ||
Line 206: | Line 238: | ||
|- | |- | ||
| style="font-weight: bold;" | icon_data | | style="font-weight: bold;" | icon_data | ||
| | | | ||
|} | |} |
Latest revision as of 09:00, 24 May 2021
app.db[edit | edit source]
Application Database used by SceShell for storing themes, notifications, and application metadata.
- Path: ur0:shell/db/app.db
- Size: 260~390KB
Tables[edit | edit source]
tbl_appinfo[edit | edit source]
titleId | key | val |
---|---|---|
<Value associated to key> |
- key's purpose:
'key' is a `fnv1a32` hash in decimal of the SFO parameter's name, here are some examples:
key | Purpose |
---|---|
566916785 | CATEGORY (gd, gda, gdb, gp) |
1299181514 | CONTENT_ID (i.e.: IV0001-NPXS10007_00-WELCOMEPARK01234) |
2414097773 | SUPPORT_URI (i.e.: mailto:) |
3168212510 | PSP2_SYSTEM_VER (i.e.:03.010) |
278217076 | TITLE_ID(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 | TitleID (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[edit | edit source]
pageId 6 | pos 9 | iconPath vs0:app/NPXS10021/sce_sys/pic0.png | title Ağ Operatörü | type 0 | command | titleId NPXS10021 | icon0Type 5 | parentalLockLv 1 | status 0 | 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 | 5 for an App or 7 for a folder | Parental Lock Level | 0 | Used for folders to save the pageId of there content | reserved02 | reserved03 | reserved04 | Used by folders to store the icon of the folder in a dds format. ~16.6kbyte big |
tbl_appinfo_page[edit | edit source]
pageId | pageNo | themeFile | bgColor | texWidth | texHeight | imageWidth | imageHeight | reserved01 | reserved02 | reserved03 | reserved04 | reserved05 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Page ID used to identify pages with apps | Position of the Page from 0-9 (max number of Pages is 10). For Folders it is a negative value with a leading "-1" followed by 7 digits. | - | Color of the Background. Value between 0-30 | - | - | - | - | - | NULL | NULL | NULL | NULL |
tbl_config[edit | edit source]
tbl_livearea[edit | edit source]
tbl_livearea_file[edit | edit source]
tbl_livearea_frame[edit | edit source]
tbl_newevent[edit | edit source]
rowid | |
id_title_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_title_id | (i.e.: NPXS10072) |
exec_arg | (i.e.: EmailAppLaunchFromNotificationIndicator) |
title | Title 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 |