App.db: Difference between revisions
Jump to navigation
Jump to search
(→Tables) |
Treasgaming (talk | contribs) |
||
(5 intermediate revisions by 3 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 | ||
Line 20: | Line 20: | ||
* key's purpose: | * key's purpose: | ||
'key' is a `fnv1a32` hash of the SFO parameter's name, here are some examples: | '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 80: | 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 |
Latest revision as of 10: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 |