Shared Database services: Difference between revisions

Line 449:

| 0x8 || 0x4 || First entryindex

|-

| 0xC || 0x4 || First timestamp0. Same as the first [[#~~ApplicationEvent~~]] timestamp.

| 0xC || 0x4 || First timestamp0. Same as the first [[#AppletEvent]] timestamp.

|-

| 0x10 || 0x4 || First timestamp1. Same as the second [[#~~ApplicationEvent~~]] timestamp.

| 0x10 || 0x4 || First timestamp1. Same as the second [[#AppletEvent]] timestamp.

|-

| 0x14 || 0x4 || Last entryindex

|-

| 0x18 || 0x4 || Last timestamp0. Same as the first [[#~~ApplicationEvent~~]] timestamp.

| 0x18 || 0x4 || Last timestamp0. Same as the first [[#AppletEvent]] timestamp.

|-

| 0x1C || 0x4 || Last timestamp1. Same as the second [[#~~ApplicationEvent~~]] timestamp.

| 0x1C || 0x4 || Last timestamp1. Same as the second [[#AppletEvent]] timestamp.

|-

| 0x20 || 0x4 || Total play-time in minutes.

Line 475:

| 0x0 || 0x8 || titleID

|-

| 0x8 || 0x4 || Same as the first [[#~~ApplicationEvent~~]] timestamp.

| 0x8 || 0x4 || Same as the first [[#AppletEvent]] timestamp.

|-

| 0xC || 0x4 || Same as the second [[#~~ApplicationEvent~~]] timestamp.

| 0xC || 0x4 || Same as the second [[#AppletEvent]] timestamp.

|-

| 0x10 || 0x4 || Total minutes since the title was last played.

Line 569:

Filtering:

* [[#~~QueryApplicationEvent~~]], [[#QueryLastPlayTime]], and [[#QueryApplicationPlayStatisticsForSystem]]: PlayEvent +0x1C must be 0, +0xC must be 1, and +0xE must be 0.

* [[#QueryAppletEvent]], [[#QueryLastPlayTime]], and [[#QueryApplicationPlayStatisticsForSystem]]: PlayEvent +0x1C must be 0, +0xC must be 1, and +0xE must be 0.

* [[#QueryPlayStatisticsByApplicationId]]: PlayEvent +0x1C must be 0, +0xC must be 1, and the titleID must match.

* [[#QueryAccountEvent]]: PlayEvent +0x1C must be 1 and PlayEvent +0x18 must be <=1.

@@ Line 449: / Line 449: @@
 | 0x8 || 0x4 || First entryindex
 |-
-| 0xC || 0x4 || First timestamp0. Same as the first [[#ApplicationEvent]] timestamp.
+| 0xC || 0x4 || First timestamp0. Same as the first [[#AppletEvent]] timestamp.
 |-
-| 0x10 || 0x4 || First timestamp1. Same as the second [[#ApplicationEvent]] timestamp.
+| 0x10 || 0x4 || First timestamp1. Same as the second [[#AppletEvent]] timestamp.
 |-
 | 0x14 || 0x4 || Last entryindex
 |-
-| 0x18 || 0x4 || Last timestamp0. Same as the first [[#ApplicationEvent]] timestamp.
+| 0x18 || 0x4 || Last timestamp0. Same as the first [[#AppletEvent]] timestamp.
 |-
-| 0x1C || 0x4 || Last timestamp1. Same as the second [[#ApplicationEvent]] timestamp.
+| 0x1C || 0x4 || Last timestamp1. Same as the second [[#AppletEvent]] timestamp.
 |-
 | 0x20 || 0x4 || Total play-time in minutes.
@@ Line 475: / Line 475: @@
 | 0x0 || 0x8 || titleID
 |-
-| 0x8 || 0x4 || Same as the first [[#ApplicationEvent]] timestamp.
+| 0x8 || 0x4 || Same as the first [[#AppletEvent]] timestamp.
 |-
-| 0xC || 0x4 || Same as the second [[#ApplicationEvent]] timestamp.
+| 0xC || 0x4 || Same as the second [[#AppletEvent]] timestamp.
 |-
 | 0x10 || 0x4 || Total minutes since the title was last played.
@@ Line 569: / Line 569: @@
 Filtering:
-* [[#QueryApplicationEvent]], [[#QueryLastPlayTime]], and [[#QueryApplicationPlayStatisticsForSystem]]: PlayEvent +0x1C must be 0, +0xC must be 1, and +0xE must be 0.
+* [[#QueryAppletEvent]], [[#QueryLastPlayTime]], and [[#QueryApplicationPlayStatisticsForSystem]]: PlayEvent +0x1C must be 0, +0xC must be 1, and +0xE must be 0.
 * [[#QueryPlayStatisticsByApplicationId]]: PlayEvent +0x1C must be 0, +0xC must be 1, and the titleID must match.
 * [[#QueryAccountEvent]]: PlayEvent +0x1C must be 1 and PlayEvent +0x18 must be <=1.