App.db: Difference between revisions

From Vita Developer wiki
Jump to navigation Jump to search
 
(8 intermediate revisions by 3 users not shown)
Line 2: Line 2:


=== app.db ===
=== app.db ===
  Contains paths of files used by applications.
  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 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
! style="font-weight: bold;" | Purpose
! style="font-weight: bold;" | Purpose
|-
| 'key' is a `fnv1a32` hash of the SFO parameter's name, here are some examples: 
|-
|-
| 566916785
| 566916785
| [[System_File_Object_(SFO)_(PSF)#CATEGORY|Type of application]] (gd, gda, gdb, gp)
| [[System_File_Object_(SFO)_(PSF)#CATEGORY|CATEGORY]] (gd, gda, gdb, gp)
|-
|-
| 1299181514
| 1299181514
| [http://www.psdevwiki.com/ps4/Product_ID Product_ID] (i.e.: IV0001-NPXS10007_00-WELCOMEPARK01234)
| [[System_File_Object_(SFO)_(PSF)#CONTENT_ID|CONTENT_ID]] (i.e.: IV0001-NPXS10007_00-WELCOMEPARK01234)
|-
|-
| 2414097773
| 2414097773
| Application's URI (i.e.: mailto:)
| [[System_File_Object_(SFO)_(PSF)#SUPPORT_URI|SUPPORT_URI]] (i.e.: mailto:)
|-
|-
| 3168212510
| 3168212510
| Application's version (i.e.:03.010)
| [[System_File_Object_(SFO)_(PSF)#PSP2_SYSTEM_VER|PSP2_SYSTEM_VER]] (i.e.:03.010)
|-
|-
| 278217076
| 278217076
| TitleID (i.e.: NPXS10007)
| [[System_File_Object_(SFO)_(PSF)#TITLE_ID|TITLE_ID]](i.e.: NPXS10007)
|-
|-
| 3794959877
| 3794959877
Line 81: 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
Retrieved from "http://www.psdevwiki.com/vita/index.php?title=App.db&oldid=7327"