accountonlinetime - OpenPerpetuum/OPDB GitHub Wiki
Description
???
Table Structure
ID | Type | Name | Description | Properties | Links |
---|---|---|---|---|---|
1 | Number | accountid | The ID of the account of which this row describes. | PRIMARY | ??? |
2 | DateTime | loggedin | When did the user last log in? | ??? | |
3 | DateTime | loggedout | When did the user last logged out? | ??? | |
4 | String | ip | The IP address the user last logged in from. | ??? | |
5 | Boolean | safelogout | Did the user perform a safe log out? | ??? | |
6 | String | hwhash | ??? | ??? | |
7 | Boolean | istrial | Is the account a trial account? ??? | ??? |
Notes
loggedin & loggedout
We can figure out if a user is currently logged in if the loggedin
timestamp is greater than the loggedout
timestamp.
If should it be vice versa, the player is obviously offline.