The `areatrigger` table
This table contains trigger points for events in certain coordinates in the maps.
How to Import DBC Data onto my Database
Table Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
---|---|---|---|---|---|---|---|
entry | INT | UNSIGNED | PRI | NO | AUTO_INCREMENT | ||
map | INT | UNSIGNED | NO | 0 | |||
x | FLOAT | NO | 0 | ||||
y | FLOAT | NO | 0 | ||||
z | FLOAT | NO | 0 | ||||
radius | FLOAT | NO | 0 | Seems to be a box of size yards with center at x,y,z | |||
length | FLOAT | NO | 0 | Most commonly used when size is 0, but not always | |||
width | FLOAT | NO | 0 | Most commonly used when size is 0, but not always | |||
height | FLOAT | NO | 0 | Most commonly used when size is 0, but not always | |||
orientation | FLOAT | NO | 0 | Most commonly used when size is 0, but not always |
Description of the fields
This is just a automatic counter that assigns a value to each trigger to list it.
This field recall a certain map based on the ID (for example, ID 30 recalls Elwynn Forest)
Contains the coordinates of the three 3d dimensions.
This contains the radius of activation of the trigger.
these fields contain the values for the physics and behavior of a given trigger.
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 |