Nintendo Switch Brew

Shared Database services

Page Discussion
Revision as of 15:42, 18 October 2019 by Hexkyz (talk | contribs) (→‎pdm:qry)

pl:u, pl:s

These are "nn::pl::detail::IPlatformServiceManager".

Cmd Name
0 #RequestSharedFontLoad
1 #GetSharedFontLoadState
2 #GetSharedFontSize
3 #GetSharedFontAddress
4 #GetSharedFontSharedMemoryHandle
5 #GetSharedFontInOrderOfPriority
6 [4.0.0+] GetSharedFontInOrderOfPriorityForSystem
100 [8.0.0+] RequestApplicationFunctionAuthorization
101 [8.0.0+] RequestApplicationFunctionAuthorizationForSystem
1000 [9.0.0+] LoadNgWordDataForPlatformRegionChina
1001 [9.0.0+] GetNgWordDataSizeForPlatformRegionChina

RequestSharedFontLoad

Takes a #SharedFontType (uint32), no output.

GetSharedFontLoadState

Takes a #SharedFontType (uint32), returns the #LoadState (uint32).

LoadState

Value Description
0x00 Loading
0x01 Loaded

GetSharedFontSize

Takes a #SharedFontType (uint32), returns the Font Size (uint32).

GetSharedFontAddress

Takes a #SharedFontType (uint32), returns the offset (uint32) to the Font Address.

GetSharedFontSharedMemoryHandle

No input, returns an output SharedMemory handle.

User-processes map this SharedMemory with size=0x1100000 and permissions=R--.

Font data is TTF, located at the offset returned by #GetSharedFontAddress.

GetSharedFontInOrderOfPriority

Takes an input u64 LanguageCode and 3 type-0x6 output buffers, returns an output u8 and u32. The u8 is a bool to specify if the fonts are loaded or not and the u32 is the font count. The first buffer contains a list of Shared font types, the second buffer contains the font offsets and the final buffer contains the font sizes. The buffers are an array of u32s which specify information about a specific font. Buffer1[n] is related to Buffer2[n] and Buffer3[n]. Example: Font index 0s offset is at Buffer2[0], size is at Buffer3[0]. The fonts are relative to the shared memory created by #GetSharedFontSharedMemoryHandle

SharedFontType

Value Description
0x00 Japan, US and Europe (Standard)
0x01 Chinese Simplified
0x02 Extended Chinese Simplified
0x03 Chinese Traditional
0x04 Korean (Hangul)
0x05 Nintendo Extended
  • Nintendo Extended: Contains Nintendo-specific characters, including HID buttons, HID controller styles, applet icons, Wii(U) icons, etc.

mii:u, mii:e

This is "nn::mii::detail::IStaticService".

Cmd Name
0 GetDatabaseService

IDatabaseService

This is "nn::mii::detail::IDatabaseService".

Cmd Name
0 IsUpdated
1 IsFullDatabase
2 GetCount
3 Get
4 Get1
5 UpdateLatest
6 BuildRandom
7 BuildDefault
8 Get2
9 Get3
10 UpdateLatest1
11 FindIndex
12 Move
13 AddOrReplace
14 Delete
15 DestroyFile
16 DeleteFile
17 Format
18 Import
19 Export
20 IsBrokenDatabaseWithClearFlag
21 GetIndex
22 [5.0.0+] SetInterfaceVersion
23 [5.0.0+] Convert
24 [7.0.0+] ConvertCoreDataToCharInfo
25 [7.0.0+] ConvertCharInfoToCoreData

miiimg

This is "nn::mii::detail::IImageDatabaseService".

This was added with [5.0.0+].

Cmd Name
0 Initialize
10 Reload
11 GetCount
12 IsEmpty
13 IsFull
14 GetAttribute
15 LoadImage
16 AddOrUpdateImage
17 DeleteImages
100 DeleteFile
101 DestroyFile
102 ImportFile
103 ExportFile
104 ForceInitialize

pdm:ntfy

This is "nn::pdm::detail::INotifyService".

Cmd Name
0 #NotifyAppletEvent
2 #NotifyOperationModeChangeEvent
3 #NotifyPowerStateChangeEvent
4 #NotifyClearAllEvent
5 #NotifyEventForDebug
6 [4.0.0+] SuspendUserAccountEventService
7 [4.0.0+] ResumeUserAccountEventService
8 [6.0.0+]
9 [8.0.0+]

NotifyAppletEvent

Takes an input u8 #AppletEventType, an u8 AppletId, an u8 StorageId, an u8 #PlayLogPolicy, an u32 event_x8, and an u64 titleID. Returns no output.

When #PlayLogPolicy is 2 ("None") this will immediately return 0.

Logs a new #PlayEvent with the following data:

After the initial logging, additional code runs with some of the above input params.

NotifyOperationModeChangeEvent

Takes an input u8 inval, no output.

Logs a new #PlayEvent with the following data: clears the 0x20-bytes at +0x0, u8 +0x1C = 0x3, u8 +0x0 = inval, and sets the 3 timestamps.

NotifyPowerStateChangeEvent

Takes an input u8 inval, no output.

Logs a new #PlayEvent with the following data: clears the 0x20-bytes at +0x0, u8 +0x1C = 0x2, u8 +0x0 = inval, and sets the 3 timestamps.

After the initial logging, additional code runs which uses inval.

NotifyClearAllEvent

No input/output.

NotifyEventForDebug

Takes an input type-0x5 buffer containing an array of #PlayEvent, no output.

Gets the system-setting pdm!is_production, the size must be 1 and the value must be 0, otherwise an error is returned.

Each #PlayEvent entry is validated, throwing an error on failure. After an entry is successfully validated, it is written to the log.

Cmd8

Takes an input u8 #AppletEventType, an u8 LibraryAppletMode, an u8 AppletId, an u8 StorageId, an u8 #PlayLogPolicy, and an u64 titleID. Returns no output.

This is similar to #NotifyAppletEvent.

When #PlayLogPolicy is 2 ("None") this will immediately return 0.

Logs a new #PlayEvent with the following data:

After the initial logging, additional code runs with some of the above input params. This is handled the same as #NotifyAppletEvent, except that the value passed for event_x8 is value 0 here.

Cmd9

Takes an input u8 #AppletEventType, an u8 AppletId, an u8 StorageId, an 0x20-byte struct, an u8 bool flag, an u8 #PlayLogPolicy, an u32 event_x8, and an u64 titleID. Returns no output.

This is identical to #NotifyAppletEvent except for the additional struct/flag params.

After the initial logging, additional code runs with some of the above input params. This is handled the same as #NotifyAppletEvent, except that when the u8 bool flag is set the input struct is used with this.

pdm:qry

This is "nn::pdm::detail::IQueryService".

Cmd Name
0 #QueryAppletEvent ([1.0.0-7.0.1] QueryApplicationEvent)
[1.0.0-6.2.0] 1 [[#QueryPlayStatistics
[1.0.0-6.2.0] 2 [[#QueryPlayStatisticsByUserAccountId
[1.0.0-6.2.0] 3 [[#QueryPlayStatisticsByNetworkServiceAccountId
4 #QueryPlayStatisticsByApplicationId
5 #QueryPlayStatisticsByApplicationIdAndUserAccountId
[1.0.0-6.2.0] 6 [[#QueryPlayStatisticsByApplicationIdAndNetworkServiceAccountId
7 #QueryLastPlayTime
8 #QueryPlayEvent
9 #GetAvailablePlayEventRange
10 #QueryAccountEvent
11 [4.0.0+] #QueryAccountPlayEvent
12 [4.0.0+] #GetAvailableAccountPlayEventRange
13 [5.0.0+] #QueryApplicationPlayStatisticsForSystem
14 [6.0.0+] #QueryRecentlyPlayedApplication
15 [6.0.0+] #GetRecentlyPlayedApplicationUpdateEvent
16 [6.0.0+] #QueryApplicationPlayStatisticsByUserAccountIdForSystem

QueryAppletEvent

Takes an input s32 entry_index, a type-0x6 output buffer containing an array of #AppletEvent, and returns an output s32 for actual total output entries.

QueryPlayStatistics

Takes a type-0x6 output buffer containing an array of #PlayStatistics and returns an output s32 for actual total output entries.

[6.2.0+] This command was removed.

QueryPlayStatisticsByUserAccountId

Takes an input u128 Uid, a type-0x6 output buffer containing an array of #PlayStatistics and returns an output s32 for actual total output entries.

[6.2.0+] This command was removed.

QueryPlayStatisticsByNetworkServiceAccountId

Takes an input u64 NetworkServiceAccountId, a type-0x6 output buffer containing an array of #PlayStatistics and returns an output s32 for actual total output entries.

[6.2.0+] This command was removed.

QueryPlayStatisticsByApplicationId

Takes an input u64 ApplicationId and returns an output #PlayStatistics.

QueryPlayStatisticsByApplicationIdAndUserAccountId

Takes an input u64 ApplicationId, an input u128 Uid and returns an output #PlayStatistics.

QueryPlayStatisticsByApplicationIdAndNetworkServiceAccountId

Takes an input u64 ApplicationId, an input u64 NetworkServiceAccountId and returns an output #PlayStatistics.

[6.2.0+] This command was removed.

QueryLastPlayTime

Takes a type-0x6 output buffer containing an array of #LastPlayTime, and a type-0x5 input buffer containing an array of u64 ApplicationId. Returns an output s32 for actual total output entries.

QueryPlayEvent

Takes an input s32 entry_index, a type-0x6 output buffer containing an array of #PlayEvent, and returns an output s32 for actual total output entries.

GetAvailablePlayEventRange

No input, returns 3 output s32s: total_entries, start_entry_index, and end_entry_index.

QueryAccountEvent

Takes an input s32 entry_index, a type-0x6 output buffer containing an array of #AccountEvent, and returns an output s32 for actual total output entries.

QueryAccountPlayEvent

Takes an input s32 entry_offset, an input u128 Uid, a type-0x6 output buffer containing an array of #AccountPlayEvent, and returns an output s32 for actual total output entries.

GetAvailableAccountPlayEventRange

Takes an input u128 Uid and returns 3 output s32s: total_entries, start_entry_index, and end_entry_index.

QueryApplicationPlayStatisticsForSystem

Takes a type-0x6 output buffer containing an array of #ApplicationPlayStatistics and a type-0x5 input buffer containing an array of u64 ApplicationId. Returns an output s32 for actual total output entries.

The number of entries in each array is the same.

QueryRecentlyPlayedApplication

Takes an input u128 Uid, a type-0x6 output buffer containing an array of u64 ApplicationId, and returns an output s32 for actual total output entries.

Returns a list of titles played by the specified user.

GetRecentlyPlayedApplicationUpdateEvent

No input, returns an output Event handle with autoclear=false.

This is signaled when logging a new #PlayEvent which would be available via #QueryAccountEvent, where #PlayEvent +0x18 is 0.

QueryApplicationPlayStatisticsByUserAccountIdForSystem

Takes a u128 Uid, a type-0x6 output buffer containing an array of #ApplicationPlayStatistics and a type-0x5 input buffer containing an array of u64 ApplicationId. Returns an output s32 for actual total output entries.

Same as #QueryApplicationPlayStatisticsForSystem except this gets playstats specific to Uid.

avm

This is "nn::avm::srv::IAvmService".

This was added with [6.0.0+].

Cmd Name
100
101
102
103 No input, returns an #IVersionListImporter.
200
202
1000
1001
1002

IVersionListImporter

This is "nn::avm::srv::IVersionListImporter".

This was added with [6.0.0+].

Cmd Name
0
1
2

AppletEvent

Offset Size Description
0x0 0x8 titleID
0x8 0x4 entryindex
0xC 0x4 timestamp0
0x10 0x4 timestamp1
0x14 0x1 #PlayEvent +0xF
0x15 0x3 Padding

This is a 0x18-byte struct.

Timestamp format, converted from PosixTime: total minutes since epoch UTC 1999/12/31 00:00.

PlayStatistics

Offset Size Description
0x0 0x8 titleID
0x8 0x4 First entryindex
0xC 0x4 First timestamp0. Same as the first #AppletEvent timestamp.
0x10 0x4 First timestamp1. Same as the second #AppletEvent timestamp.
0x14 0x4 Last entryindex
0x18 0x4 Last timestamp0. Same as the first #AppletEvent timestamp.
0x1C 0x4 Last timestamp1. Same as the second #AppletEvent timestamp.
0x20 0x4 Total play-time in minutes.
0x24 0x4 Total times the application title was launched.

This is a 0x28-byte struct.

LastPlayTime

Offset Size Description
0x0 0x8 titleID
0x8 0x4 Same as the first #AppletEvent timestamp.
0xC 0x4 Same as the second #AppletEvent timestamp.
0x10 0x4 Total minutes since the title was last played.
0x14 0x1 Flag indicating whether the above field is set.
0x15 0x3 Padding

This is a 0x18-byte struct. This contains data from the last time the title was played.

PlayEventType

Value Description
0 Applet
1 Account
2 PowerStateChange
3 OperationModeChange
4 Initialize. Used for the very first #PlayEvent entry in the log.

This is an enum for #PlayEvent +0x1C, which indicates the type of #PlayEvent.

AppletEventType

Value Description
0 "launch"
1 "exit"
2 "in_focus"
3 "out_of_focus"
4 "out_of_focus"
5 "exit"
6 "exit"

This is an enum for #PlayEvent +0xF with #PlayEventType = Applet, this indicates the type of the Applet event.

PlayLogPolicy

Value Meaning Description
0 All All pdm:qry cmds which require #PlayEventType = Applet and AppletId = Application will only return the entry when PlayLogPolicy matches this value.
1 LogOnly The above commands will filter out the entry with this.
2 None pdm:ntfy #NotifyAppletEvent, #Cmd8, and #Cmd9 will immediately return 0 when the input param matches this value.

This is an enum for #PlayEvent +0xE with #PlayEventType = Applet. This is set via the above commands, which uses this as an input param.

PlayEvent

Offset Size Description
0x1C 0x1 #PlayEventType
0x1D 0x3 Padding
0x20 0x8 PosixTime timestamp from StandardUserSystemClock.
0x28 0x8 PosixTime timestamp from StandardNetworkSystemClock.
0x30 0x8 Timestamp in seconds derived from StandardSteadyClock.

This is a 0x38-byte struct.

This is the raw entry struct directly read from FS, without any entry filtering. The other structs are extracted+converted from this one, with filtering.

Filtering:

The structure of the first 0x1C-bytes are determined by #PlayEventType. For titleIDs/userIDs, the low/high u32 in each u64 is swapped.

Applet:

Offset Size Description
0x0 0x8 titleID
0x8 0x4 Title version, set by pdm:ntfy #NotifyAppletEvent and #Cmd9.
0x8 0x1 When set to u8 0x1 by pdm:ntfy #Cmd8, this indicates that +0x9 is set. Only used for non-applications.
0x9 0x1 See above. LibraryAppletMode
0xC 0x1 AppletId
0xD 0x1 StorageId
0xE 0x1 #PlayLogPolicy
0xF 0x1 #AppletEventType
0x10 0xC Unused

Account:

Offset Size Description
0x0 0x10 userID
0x10 0x8 titleID, when u8 +0x18 = 2.
0x18 0x1 Type. 0-1 to be listed by #QueryAccountEvent, or 2 to include the above titleID.
0x19 0x3 Padding

PlayEventType PowerStateChange/OperationModeChange: u8 +0x0 is the input value from #NotifyOperationModeChangeEvent/#NotifyPowerStateChangeEvent, the rest is unused.

AccountEvent

Offset Size Description
0x0 0x10 userID
0x10 0x4 entryindex
0x14 0x4 Padding
0x18 0x8 #PlayEvent +0x20
0x20 0x8 #PlayEvent +0x28
0x28 0x8 #PlayEvent +0x30
0x30 0x1 #PlayEvent +0x18
0x31 0x7 Padding

This is a 0x38-byte struct.

AccountPlayEvent

Offset Size Description
0x0 0x4 ?
0x4 0x8 titleID, with the u32 low/high words swapped.
0xC 0xC ?
0x18 0x8 POSIX timestamp
0x20 0x8 POSIX timestamp

This is a 0x28-byte struct.

This is the raw entry struct directly read from FS, without any entry filtering. This is separate from #PlayEvent.

ApplicationPlayStatistics

Offset Size Description
0x0 0x8 titleID
0x8 0x8 Total play-time in nanoseconds.
0x10 0x8 Total times the application title was launched.

This is "nn::pdm::ApplicationPlayStatistics".

This is a 0x18-byte struct.

Retrieved from "https://switchbrew.org/w/index.php?title=Shared_Database_services&oldid=8108"