lag_reports
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
reportId
Report ID
guid
Character guid. See characters.guid
lagType
- 0 = Loot related
- 1 = Auction House related
- 2 = Mail related
- 3 = Chat related
- 4 = Movement related
- 5 = Spells and Abilities related
mapId
Map where lag was reported. See Map.dbc.
posX
Position X.
posY
Position Y.
posZ
Position Z.
latency
Latency in ms at the moment of the report.
createTime
Creation date in Unix Time. (TODO: should be changed to mysql timestamp).