logs_ip_actions
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.guid0 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.