AzerothCore
Pages :

logs_ip_actions

<-Back-to:Auth

The `logs_ip_actions` table

Table 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 INT UNSIGNED NO Character Guid
type TINYINT UNSIGNED NO
ip VARCHAR(15) SIGNED NO 127.0.0.1
systemnote TEXT SIGNED YES Notes inserted by system
unixtime INT UNSIGNED NO Unixtime
time TIMESTAMP SIGNED NO CURRENT_TIMESTAMP Timestamp
comment TEXT SIGNED YES Allows users to add a comment

Description of the fields

id

The unique ID of the entry.

account_id

The account. See account.id.

character_guid

GUID of the character, 0 for account actions. See characters.guid.

type

Value Action
0 Account login
1 Failed account login
2 Password change
3 Failed password change
4 Email change
5 Failed email change
7 Character created
8 Character login
9 Character logout
10 Character deleted
11 Failed character delete
12 Unknown action

ip

IP the action came from.

systemnote

Note added by the core, for example the account and character names.

unixtime

The time of the action, in Unix time.

time

The time of the action.

comment

A comment that can be added by hand. Not used by the core.