Skip to content
Schmoozerd edited this page Apr 14, 2013 · 2 revisions

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 Null Key Default Extra
guid int(10) unsigned NO PRI None auto_increment
id mediumint(8) unsigned NO MUL 0
map smallint(5) unsigned NO MUL 0
spawnMask tinyint(3) unsigned NO 1
phaseMask smallint(5) unsigned NO 1
modelid mediumint(8) unsigned YES 0
equipment_id mediumint(9) NO 0
position_x float NO 0
position_y float NO 0
position_z float NO 0
orientation float NO 0
spawntimesecs int(10) unsigned NO 120
spawndist float 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

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 Maps.dbc

spawnMask

Controls under which difficulties the creature will be spawned.

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

Defines which phase the creature belongs. 1 is default phase, rest are from spell’s aura 261, (Aura #261) (4) = phasemask = 4.

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.

equipment_id

The ID of the equipment that the creature is using. See creature_equip_template.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 creature_movement.point

curhealth

The current health that the creature has.

curmana

The current mana that the creature has.

DeathState

The creature’s death state. A boolean, 0 = Alive, 1 = Corpse lying dead around (no gossip possible when dead, if you need corpse-gossip use dynamicflags|32)

MovementType

The movement type associated with this creature. Usually the same as creature_template.MovementType but can be different. See creature_template.MovementType for possible values.

Clone this wiki locally