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.
|guid||int(10)||unsigned||PRI||NO||NULL||Auto Increment||Global Unique Identifier|
Description of the fields
A unique identifier given to each creature to distinguish one creature from another. Two creatures can NOT have same GUID.
The id of the template that is used when instantiating this creature. See creature_template.entry
The Map ID of the position of the creature. See Map.dbc
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)
|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|
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.
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.
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.
The X position of the creature.
The Y position of the creature.
The Z position of the creature.
The orientation of the creature. (North = 0.0; South = pi (3.14159))
The respawn time of the creature in seconds.
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.
The current waypoint number that the creature is on, if any. See waypoint_data.point
The current health that the creature has.
The current mana that the creature has.
The creature's death state. -- Should not be used; correct aura and correct creature flags is a better way to do it.
The movement type associated with this creature. Usually the same as creature_template.MovementType but can be different.
Same as creature_template.npcflag
NOTE: A creature.npcflag record will override a creature_template.npcflag record.
Same as creature_template.unit_flags
NOTE: A creature.unit_flags record will override a creature_template.unit_flags record.
Same as creature_template.dynamicflags
NOTE: A creature.dynamicflags record will override a creature_template.dynamicflags record.