From 9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd Mon Sep 17 00:00:00 2001 From: "Julio A. Leyva Osorio" Date: Fri, 16 Jul 2021 16:23:43 -0400 Subject: 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 --- docs/lag_reports.md | 51 ++++++++++++++++++++++++--------------------------- 1 file changed, 24 insertions(+), 27 deletions(-) (limited to 'docs/lag_reports.md') 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). -- cgit