Back to 'logs' Return to auth Go to 'rbac_account_permissions'
Used to log ips of individual actions
¶ Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | int | unsigned | PRI | NO | auto_increment | Unique Identifier | |
| account_id | int | unsigned | NO | Account ID | |||
| character_guid | bigint | unsigned | NO | Character Guid | |||
| realm_id | int | unsigned | NO | 0 | Realm ID | ||
| type | tinyint | unsigned | NO | ||||
| ip | varchar(15) | NO | 127.0.0.1 | ||||
| systemnote | text | YES | NULL | Notes inserted by system | |||
| unixtime | int | unsigned | NO | Unixtime | |||
| time | timestamp | NO | CURRENT_TIMESTAMP | DEFAULT_GENERATED | Timestamp | ||
| comment | text | YES | NULL | Allows users to add a comment |
¶ Description of fields
¶ id
Unique log enumerator
¶ account_id
references account.id
¶ character_guid
references characters.guid
0 on account actions
¶ realm_id
The realm this happened on.
0 on account actions
¶ type
| ID | Name | systemnote |
|---|---|---|
| 0 | ACCOUNT_LOGIN | Logged into WoW |
| 1 | ACCOUNT_FAIL_LOGIN | Login to WoW Failed |
| 2 | ACCOUNT_CHANGE_PW | Password Reset Completed |
| 3 | ACCOUNT_CHANGE_PW_FAIL | Password Reset Failed |
| 4 | ACCOUNT_CHANGE_EMAIL | Email Change Completed |
| 5 | ACCOUNT_CHANGE_EMAIL_FAIL | Email Change Failed |
| 6 |  ACCOUNT_LOGOUT |
OBSOLETE |
| 7 | CHARACTER_CREATE | Character Created |
| 8 | CHARACTER_LOGIN | Logged onto Character |
| 9 | CHARACTER_LOGOUT | Logged out of Character |
| 10 | CHARACTER_DELETE | Character Deleted |
| 11 | CHARACTER_FAILED_DELETE | Character Deletion Failed |
| 12 | UNKNOWN_ACTION | ERROR! Unknown action! |
¶ ip
IP address of the player.
¶ systemnote
Directly tied to type.
¶ unixtime
Timestamp as UnixTime integer.
¶ time
Timestamp as DateTime string.
¶ comment
Comments can be added manually.
Back to 'logs' Return to auth Go to 'rbac_account_permissions'