The \lag\_reports\ table
This table stores the lag reports made by players ingame (when they click on “Help Request”).
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| reportId | INT | UNSIGNED | PRI | NO | Auto Increment | ||
| guid | INT | UNSIGNED | NO | 0 | |||
| lagType | TINYINT | UNSIGNED | NO | 0 | |||
| mapId | SMALLINT | UNSIGNED | NO | 0 | |||
| posX | FLOAT | SIGNED | NO | 0 | |||
| posY | FLOAT | SIGNED | NO | 0 | |||
| posZ | FLOAT | SIGNED | NO | 0 | |||
| latency | INT | UNSIGNED | NO | 0 | |||
| createTime | INT | UNSIGNED | NO | 0 |
Description of the fields
Report ID
Character guid. See characters.guid
Map where lag was reported. See Map.dbc.
Position X.
Position Y.
Position Z.
Latency in ms at the moment of the report.
Creation date in Unix Time. (TODO: should be changed to mysql timestamp).