The `creature` table
Contains individual creature spawn data. Spawn of a creature is an instance of the creature object in the world.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
int(10) | unsigned | PRI | NO | NULL | Auto Increment | Global Unique Identifier | |
mediumint(8) | unsigned |
| NO | 0 |
| Creature Identifier | |
smallint(5) | unsigned |
| NO | 0 |
| Map Identifier | |
tinyint(3) | unsigned |
| NO | 1 |
|
| |
smallint(5) | unsigned |
| NO | 1 |
|
| |
mediumint(8) | unsigned |
| NO | 0 |
| // 0 core determined random model or model_id to prevent random model selection by core. | |
tinyint(3) | unsigned |
| NO | 1 |
|
| |
float | signed |
| NO | 0 |
|
| |
float | signed |
| NO | 0 |
|
| |
float | signed |
| NO | 0 |
|
| |
float | signed |
| NO | 0 |
|
| |
int(10) | unsigned |
| NO | 120 |
|
| |
float | signed |
| NO | 5 |
| // Dist in yards for random movement. | |
mediumint(8) | unsigned |
| NO | 0 |
| // Storage used by core. "Always set as 0" | |
int(10) | unsigned |
| NO | 1 |
| // Storage used by core. "Always set as 1" | |
int(10) | unsigned |
| NO | 0 |
| // Storage used by core. "Always set as 0" | |
tinyint(3) | unsigned |
| NO | 0 |
| // 0 No movement, 1 random, 2 path | |
int(10) | unsigned |
| NO | 0 |
|
| |
int(10) | unsigned |
| NO | 0 |
|
| |
int(10) | unsigned |
| NO | 0 |
|
|
Description of the fields
guid
A unique identifier given to each creature to distinguish one creature from another. Two creatures can NOT have same GUID.
id
The id of the template that is used when instantiating this creature. See creature_template.entry
map
The Map ID of the position of the creature. See Map.dbc
spawnMask
Controls under which difficulties the creature is spawned.
Just like flags you can add them as you wish so 3 would be: Spawned in 10/25 man normal versions of maps (pre 3.2 all maps)
Value | Comment |
|---|---|
0 | Not spawned |
1 | Spawned only in 10-man-normal versions of maps (includes maps without a heroic mode) |
2 | Spawned only in 25-man-normal versions of maps (or heroics pre 3.2) |
4 | Spawned only in 10-man heroic versions of maps |
8 | Spawned only in 25-man-heroic versions of maps |
15 | Spawned in all versions of maps |
phaseMask
This is a bitmask field that describes all the phases that a creature will appear in. Aura 261 determines the phase you can see. For example, if you had this aura http://www.wowhead.com/?spell=55782, you would be able to see creatures in phase 2. If you wanted the creature to be visible in both phase 1 and phase 2, you would set the phaseMask to 3.
modelid
The model ID associated with this creature. Note that two creatures that use the same template can have different models. See creature_model_info for more information on model-specific characteristics. NOTE: This can be left at 0
and a random model from its assigned models in creature_template will be assigned by the core.
equipment_id
The id as defined within creature_equip_template corresponding to the entry. The value essential defines the equip:
- -1: A random equip chosen from it's pre-definition.
- 0: No equipment defined.
- 1+: The individual id within creature_equip_template.
position_x
The X position of the creature.
position_y
The Y position of the creature.
position_z
The Z position of the creature.
orientation
The orientation of the creature. (North = 0.0; South = pi (3.14159))
spawntimesecs
The respawn time of the creature in seconds.
spawndist
The maximum distance that the creature should spawn from its spawn point. Also controls how far away the creature can walk from its spawn point if its MovementType = 1.
currentwaypoint
The current waypoint number that the creature is on, if any. See waypoint_data.point
curhealth
The current health that the creature has.
curmana
The current mana that the creature has.
MovementType
The movement type associated with this creature. Usually the same as creature_template.MovementType but can be different.
npcflag
Same as creature_template.npcflag
NOTE: A creature.npcflag record will override a creature_template.npcflag record.
unit_flags
Same as creature_template.unit_flags
NOTE: A creature.unit_flags record will override a creature_template.unit_flags record.
dynamicflags
Same as creature_template.dynamicflags
NOTE: A creature.dynamicflags record will override a creature_template.dynamicflags record.