diff options
| author | Julio A. Leyva Osorio <tony931023@gmail.com> | 2021-07-16 16:23:43 -0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-07-16 22:23:43 +0200 |
| commit | 9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd (patch) | |
| tree | cc7fe36188f6d9144baaddecdc35ed77a2eb1a36 /docs/lag_reports.md | |
| parent | 535ad2787b77d2ffd79b6788e38156ec5144ca7f (diff) | |
| download | wiki-9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd.tar.gz wiki-9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd.tar.bz2 wiki-9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd.zip | |
chore: characters (#584)
* Update account_data.md
* Update account_instance_times.md
* Update account_tutorial.md
* Update addons.md
* Update arena_team.md
* Fix arena_team.md
* Update arena_team_member.md
* Update auctionhouse.md
* Update banned_addons.md
* Update battleground_deserters.md
* Update bugreport.md
* Update calendar_events.md
* fix calendar_events.md
* fix
* fix
* fix3
* update calendar_invites.md
* update channels.md
* fix channels.md
* fix channels.md
* update channels_bans.md
* update channels_bans.md
* update petition.md
* fix 4
* Update characters.md
* Update worlstates.md
* Update gm_ticket.md
* + Update
* + update 2.md
* + update 3
* update + characters.md
* + update 4.md
* + update 5.md
* update characters, thanks @r-o-b-o-t-o
* fix +
* + Update 6
* + Update 7
* + Update 8
* + Update 9
* Fix + @Kitzunu
Diffstat (limited to 'docs/lag_reports.md')
| -rw-r--r-- | docs/lag_reports.md | 51 |
1 files changed, 24 insertions, 27 deletions
diff --git a/docs/lag_reports.md b/docs/lag_reports.md index 1381293..b4a6a0d 100644 --- a/docs/lag_reports.md +++ b/docs/lag_reports.md @@ -1,37 +1,34 @@ -# lag_reports +# lag\_reports [<-Back-to:Characters](database-characters.md) - -## The `lag_reports` table +**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 | UNSIGNED | PRI | NO | | Auto Increment | | -| [guid][2] | INT | UNSIGNED | | NO | 0 | | | -| [lagType][3] | inyint(3) | UNSIGNED | | NO | 0 | | | +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| --------------- | -------- | ---------- | --- | ---- | ------- | -------------- | ------- | +| [reportId][1] | INT | UNSIGNED | PRI | NO | | Auto Increment | | +| [guid][2] | INT | UNSIGNED | | NO | 0 | | | +| [lagType][3] | TINYINT | UNSIGNED | | NO | 0 | | | | [mapId][4] | SMALLINT | UNSIGNED | | NO | 0 | | | -| [posX][5] | FLOAT | SIGNED | | NO | 0 | | | -| [posY][6] | FLOAT | SIGNED | | NO | 0 | | | -| [posZ][7] | FLOAT | SIGNED | | NO | 0 | | | -| [latency][8] | INT | UNSIGNED | | NO | 0 | | | -| [createTime][9] | INT | UNSIGNED | | NO | 0 | | | +| [posX][5] | FLOAT | SIGNED | | NO | 0 | | | +| [posY][6] | FLOAT | SIGNED | | NO | 0 | | | +| [posZ][7] | FLOAT | SIGNED | | NO | 0 | | | +| [latency][8] | INT | UNSIGNED | | NO | 0 | | | +| [createTime][9] | INT | UNSIGNED | | NO | 0 | | | -[1]: #reportId +[1]: #reportid [2]: #guid -[3]: #lagType -[4]: #mapId -[5]: #posX -[6]: #posY -[7]: #posZ +[3]: #lagtype +[4]: #mapid +[5]: #posx +[6]: #posy +[7]: #posz [8]: #latency -[9]: #createTime - +[9]: #createtime ## Description of the fields @@ -54,19 +51,19 @@ Character guid. See [characters.guid](characters#guid) ### mapId -Map where lag was reported. See Map.dbc +Map where lag was reported. See [Map.dbc](map). ### posX -Position X +Position X. ### posY -Position Y +Position Y. ### posZ -Position Z +Position Z. ### latency @@ -74,4 +71,4 @@ Latency in ms at the moment of the report. ### createTime -Creation date in Unix Time (TODO: should be changed to mysql timestamp) +Creation date in Unix Time. (TODO: should be changed to mysql timestamp). |