Creature SF
Back to world database list of tables.
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 |
| guid | int(10) | unsigned | PRI | NO | NULL | Auto Increment | Global Unique Identifier |
| id | mediumint(8) | unsigned | NO | 0 | Creature Identifier | ||
| map | smallint(5) | unsigned | NO | 0 | Map Identifier | ||
| spawnMask | tinyint(3) | unsigned | NO | 1 | |||
| phaseMask | smallint(5) | unsigned | NO | 1 | |||
| modelid | mediumint(8) | unsigned | NO | 0 | |||
| equipment_id | mediumint(9) | signed | NO | 0 | |||
| position_x | float | signed | NO | 0 | |||
| position_y | float | signed | NO | 0 | |||
| position_z | float | signed | NO | 0 | |||
| orientation | float | signed | NO | 0 | |||
| spawntimesecs | int(10) | unsigned | NO | 120 | |||
| spawndist | float | signed | NO | 5 | |||
| currentwaypoint | mediumint(8) | unsigned | NO | 0 | |||
| curhealth | int(10) | unsigned | NO | 1 | |||
| curmana | int(10) | unsigned | NO | 0 | |||
| DeathState | tinyint(3) | unsigned | NO | 0 | |||
| MovementType | tinyint(3) | unsigned | NO | 0 | |||
| npcflag | int(10) | unsigned | NO | 0 | |||
| unit_flags | int(10) | unsigned | NO | 0 | |||
| dynamicflags | 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 of the equipment that the creature is using. See creature_equip_template.entry
NOTE: equipment should be assigned in creature_template. Only use this if a guid has different equipment than others of the same entry.
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.
DeathState
The creature's death state. -- Should not be used; correct aura and correct creature flags is a better way to do it.
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.