From cff68d82d1aa0001475f1b2b362353883edcad20 Mon Sep 17 00:00:00 2001 From: Barbz Date: Sun, 5 Jul 2020 18:22:40 +0200 Subject: refactor: lag_reports.md markdown table + add missing columns (#251) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit - Add data for lagtype - Add two missing columns - Refactor that page to correct markdown Co-authored-by: Stefano Borzì --- docs/lag_reports.md | 155 +++++++++++++++++----------------------------------- 1 file changed, 49 insertions(+), 106 deletions(-) diff --git a/docs/lag_reports.md b/docs/lag_reports.md index b85f60e..a83c2ff 100644 --- a/docs/lag_reports.md +++ b/docs/lag_reports.md @@ -1,109 +1,39 @@ -# lag\_reports +# lag_reports [<-Back-to:Characters](database-characters.md) -**The \`lag\_reports\` table** - -`table-no-description|0` - -**Structure** - - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

reportId

int(10)

unsigned

PRI

NO

 

Auto Increment

 

guid

int(10)

unsigned

 

NO

0

 

 

lagType

inyint(3)

unsigned

 

NO

0

 

 

mapId

smallint(5)

unsigned

 

NO

0

 

 

posX

float

signed

 

NO

0

 

 

posY

float

signed

 

NO

0

 

 

posZ

float

signed

 

No

0

 

 

- -**Description of the fields** + +## 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][1] | int(10) | unsigned | PRI | NO | | Auto Increment | | +| [guid][2] | int(10) | unsigned | | NO | 0 | | | +| [lagType][3] | inyint(3) | unsigned | | NO | 0 | | | +| [mapId][4] | smallint(5) | unsigned | | NO | 0 | | | +| [posX][5] | float | signed | | NO | 0 | | | +| [posY][6] | float | signed | | NO | 0 | | | +| [posZ][7] | float | signed | | NO | 0 | | | +| [latency][8] | int(10) | unsigned | | NO | 0 | | | +| [createTime][9] | int(10) | unsigned | | NO | 0 | | | + +[1]: #reportId +[2]: #guid +[3]: #lagType +[4]: #mapId +[5]: #posX +[6]: #posY +[7]: #posZ +[8]: #latency +[9]: #createTime + + +## Description of the fields ### reportId @@ -111,11 +41,16 @@ Report ID ### guid -Player guid. See [characters.guid](http://www.azerothcore.org/wiki/characters#guid) +Character guid. See [characters.guid](characters#guid) ### lagType -`field-no-description|3` +* 0 = Loot related +* 1 = Auction House related +* 2 = Mail related +* 3 = Chat related +* 4 = Movement related +* 5 = Spells and Abilities related ### mapId @@ -131,4 +66,12 @@ Position Y ### posZ -Position Y +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) -- cgit