Editing App.db

Jump to navigation Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.

Latest revision Your text
Line 2: Line 2:


=== app.db ===
=== app.db ===
  Application Database used by SceShell for storing themes, notifications, and application metadata.
  Contains paths of files used by applications.
* 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;" | titleId
! style="font-weight: bold;" | tittleId
! style="font-weight: bold;" | key
! style="font-weight: bold;" | key
! style="font-weight: bold;" | val
! style="font-weight: bold;" | val
Line 20: Line 19:


* 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 26: Line 24:
|-
|-
| 566916785
| 566916785
| [[System_File_Object_(SFO)_(PSF)#CATEGORY|CATEGORY]] (gd, gda, gdb, gp)
| [[System_File_Object_(SFO)_(PSF)#CATEGORY|Type of application]] (gd,gda,gdb)
|-
|-
| 1299181514
| 1299181514
| [[System_File_Object_(SFO)_(PSF)#CONTENT_ID|CONTENT_ID]] (i.e.: IV0001-NPXS10007_00-WELCOMEPARK01234)
| [http://www.psdevwiki.com/ps4/Product_ID Product_ID] (i.e.:IV0001-NPXS10007_00-WELCOMEPARK01234)
|-
|-
| 2414097773
| 2414097773
| [[System_File_Object_(SFO)_(PSF)#SUPPORT_URI|SUPPORT_URI]] (i.e.: mailto:)
| [[Title_ID|Application's URI]] (i.e.:mailto:)
|-
|-
| 3168212510
| 3168212510
| [[System_File_Object_(SFO)_(PSF)#PSP2_SYSTEM_VER|PSP2_SYSTEM_VER]] (i.e.:03.010)
| Application's version (i.e.:03.010)
|-
|-
| 278217076
| 278217076
| [[System_File_Object_(SFO)_(PSF)#TITLE_ID|TITLE_ID]](i.e.: NPXS10007)
| TittleID (i.e.: NPXS10007)
|-
|-
| 3794959877
| 3794959877
Line 50: Line 48:
|-
|-
| 904872283
| 904872283
| TitleID (i.e.: NPXS10007)
| TittleID (i.e.:NPXS10007)
|-
|-
| 2275227917
| 2275227917
Line 56: Line 54:
|-
|-
| 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 69: Line 67:
| 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 80: Line 78:


{| class="wikitable"
{| class="wikitable"
! style="background-color:#123AAA; color:#ffffd0;" | pageId 6
! style="background-color:#123AAA; color:#ffffd0;" | pageId
! style="background-color:#123AAA; color:#ffffd0;" | pos 9
! style="background-color:#123AAA; color:#ffffd0;" | pos
! style="background-color:#123AAA; color:#ffffd0;" | iconPath vs0:app/NPXS10021/sce_sys/pic0.png
! style="background-color:#123AAA; color:#ffffd0;" | iconPath
! style="background-color:#123AAA; color:#ffffd0;" | title Ağ Operatörü
! style="background-color:#123AAA; color:#ffffd0;" | title  
! style="background-color:#123AAA; color:#ffffd0;" | type 0
! style="background-color:#123AAA; color:#ffffd0;" | type
! style="background-color:#123AAA; color:#ffffd0;" | command
! style="background-color:#123AAA; color:#ffffd0;" | command
! style="background-color:#123AAA; color:#ffffd0;" | titleId NPXS10021
! style="background-color:#123AAA; color:#ffffd0;" | titleId
! style="background-color:#123AAA; color:#ffffd0;" | icon0Type 5
! style="background-color:#123AAA; color:#ffffd0;" | icon0Type
! style="background-color:#123AAA; color:#ffffd0;" | parentalLockLv 1
! style="background-color:#123AAA; color:#ffffd0;" | parentalLockLv
! style="background-color:#123AAA; color:#ffffd0;" | status 0
! style="background-color:#123AAA; color:#ffffd0;" | status
! 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 103: Line 101:
! 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;" | 5 for an App or 7 for a folder
! 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;" | [[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;" | Used for folders to save the pageId of there content
! 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;" | Used by folders to store the icon of the folder in a dds format. ~16.6kbyte big
! style="background-color:#ffffd0; color:#123AAA;" | reserved05
|-
|}
|}


===== 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 154: Line 123:


===== tbl_newevent =====
===== tbl_newevent =====
{| class="wikitable"
{| class="wikitable"
| style="font-weight: bold;" | rowid
| style="font-weight: bold;" | rowid
|  
|  
|-
|-
| style="font-weight: bold;" | id_title_id
| style="font-weight: bold;" | id_tittle_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 172: Line 140:
|-
|-
| 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 184: Line 152:
|-
|-
| 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;" | exec_title_id
| style="font-weight: bold;" | exec_tittle_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.)
| Tittle 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 238: Line 206:
|-
|-
| style="font-weight: bold;" | icon_data
| style="font-weight: bold;" | icon_data
|
|  
|}
|}
Please note that all contributions to Vita Developer wiki are considered to be released under the GNU Free Documentation License 1.2 (see Vita Developer wiki:Copyrights for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource. Do not submit copyrighted work without permission!

To protect the wiki against automated edit spam, we kindly ask you to solve the following hCaptcha:

Cancel Editing help (opens in new window)
Retrieved from "http://www.psdevwiki.com/vita/App.db"