logs_player Table¶
Per-player audit log of notable account/character events, written by the core when the corresponding LogDB.* player-logging categories are enabled in mangosd.conf.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
id |
int(10) unsigned | PRI | NO | auto_increment | |
time |
timestamp | NO | current_timestamp() | ||
type |
enum('Basic','WorldPacket','Chat','BG','Character','Honor','RA','DBError','DBErrorFix','ClientIds','Loot','LevelUp','Performance','MoneyTrade','GM','GMCritical','ChatSpam','Anticheat') | NO | |||
subtype |
varchar(20) | YES | |||
account |
int(10) unsigned | MUL | NO | ||
ip |
varchar(16) | YES | |||
guid |
int(11) | MUL | YES | ||
name |
varchar(20) | MUL | YES | ||
map |
int(10) unsigned | YES | |||
pos_x |
float | YES | |||
pos_y |
float | YES | |||
pos_z |
float | YES | |||
text |
varchar(512) | NO |
Field Breakdown¶
id- Primary Key. Log row id.time- Event timestamp.type- Event category, one of theenumvalues listed under type Values. Only a subset of these values is actually persisted; see that section.subtype- Optional sub-category string for the event type.account- Account involved (account.id).ip- Source IP at event time.guid- Character involved (guid + name snapshot).name- Character involved (guid + name snapshot).map- Location at event time.pos_x- Location at event time.pos_y- Location at event time.pos_z- Location at event time.text- Free-form payload/details for the event.
type Values¶
All rows are valid members of the column enum. The core only persists a subset to this table, selected by the LogDB.* config settings in mangosd.conf:
LogDB.* setting |
Recorded type value(s) |
|---|---|
LogDB.Chat |
Chat |
LogDB.Battlegrounds |
BG |
LogDB.Characters |
Character |
LogDB.Loot |
Loot |
LogDB.LevelUp |
LevelUp |
LogDB.Trades |
MoneyTrade |
LogDB.GM |
GM, GMCritical |
The values actually written are therefore: Chat, BG, Character, Loot, LevelUp, MoneyTrade, GM, GMCritical. The remaining enum members (Basic, WorldPacket, Honor, RA, DBError, DBErrorFix, ClientIds, Performance, ChatSpam, Anticheat) are defined in the enum but are not currently recorded by the core.
| Value | Logged content | Persisted to DB? |
|---|---|---|
| Basic | generic player events | No |
| WorldPacket | notable packet-level events | No |
| Chat | chat-related events | Yes |
| BG | battleground events | Yes |
| Character | login/logout/create/delete/rename events | Yes |
| Honor | honour calculation events | No |
| RA | remote-access console actions | No |
| DBError | database error context | No |
| DBErrorFix | automated DB error repairs | No |
| ClientIds | client identification data | No |
| Loot | loot events | Yes |
| LevelUp | level-ups | Yes |
| Performance | performance samples | No |
| MoneyTrade | money flow between players | Yes |
| GM | GM actions on players | Yes |
| GMCritical | critical GM actions | Yes |
| ChatSpam | spam detections/mutes | No |
| Anticheat | movement-anticheat and Warden detections | No |