====== areatrigger 表 ====== ---- [[数据库:world数据库:首页|<-返回:World 数据库]] This table contains trigger points for events in certain coordinates in the maps. **表结构** ^Field^Type^Attributes^Key^Null^Default^Extra^Comment^ |[[#entry|entry]]|INT|UNSIGNED|PRI|NO| |AUTO_INCREMENT| | |[[#map|map]]|INT|UNSIGNED| |NO|0| | | |[[#X, Y and Z|x]]|FLOAT| | |NO|0| | | |[[#X, Y and Z|y]]|FLOAT| | |NO|0| | | |[[#X, Y and Z|z]]|FLOAT| | |NO|0| | | |[[#radius|radius]]|FLOAT| | |NO|0| |Seems to be a box of size yards with center at x,y,z| |[[#Length, Width, Height and Orientation|length]]|FLOAT| | |NO|0| |Most commonly used when size is 0, but not always| |[[#Length, Width, Height and Orientation|width]]|FLOAT| | |NO|0| |Most commonly used when size is 0, but not always| |[[#Length, Width, Height and Orientation|height]]|FLOAT| | |NO|0| |Most commonly used when size is 0, but not always| |[[#Length, Width, Height and Orientation|orientation]]|FLOAT| | |NO|0| |Most commonly used when size is 0, but not always| ===== 字段说明 ===== ---- ==== Entry ==== This is just a automatic counter that assigns a value to each trigger to list it. ==== Map ==== This field recall a certain map based on the ID (for example, ID 30 recalls Elwynn Forest) ==== X, Y and Z ==== Contains the coordinates of the three 3d dimensions. ==== Radius ==== This contains the radius of activation of the trigger. ==== Length, Width, Height and Orientation ==== these fields contain the values for the physics and behavior of a given trigger. ==== Example ==== ^entry^map^x^y^z^radius^length^width^height^orientation^ |45|0|2924.38|-798.429|161.611|8|0|0|0|0| |71|0|-10645.9|1179.06|48.1781|27|0|0|0|0| |78|0|-11208.5|1685.34|25.7612|7|0|0|0|0| |84|0|16449.9|16393.2|69.4444|15|0|0|0|0| |87|0|-9077.34|-552.925|60.3476|30|0|0|0|0|