====== lag_reports 表 ====== ---- [[数据库:characters数据库:首页|<-返回:Characters 数据库]] This table stores the lag reports made by players ingame (when they click on "Help Request"). **表结构** ^Field^Type^Attributes^Key^Null^Default^extra^Comment^ |[[#reportId|reportId]]|INT|UNSIGNED|PRI|NO| |Auto Increment| | |[[#guid|guid]]|INT|UNSIGNED| |NO|0| | | |[[#lagType|lagType]]|TINYINT|UNSIGNED| |NO|0| | | |[[#mapId|mapId]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#posX|posX]]|FLOAT|SIGNED| |NO|0| | | |[[#posY|posY]]|FLOAT|SIGNED| |NO|0| | | |[[#posZ|posZ]]|FLOAT|SIGNED| |NO|0| | | |[[#latency|latency]]|INT|UNSIGNED| |NO|0| | | |[[#createTime|createTime]]|INT|UNSIGNED| |NO|0| | | ===== 字段说明 ===== ---- ==== 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).