Skip to content
killerwife edited this page May 10, 2021 · 10 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 (WotLK)
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
spawntimesecsmin int(10) unsigned NO 120
spawntimesecsmax 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 Map.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. DEPRECATED: Use creature_spawn_data_template paradigm instead.

equipment_id

The ID of the equipment that the creature is using. See creature_equip_template.entry DEPRECATED: Use creature_spawn_data_template paradigm instead.

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))

spawntimesecsmin

The minimum respawn time of the creature in seconds.

spawntimesecsmax

The maximum 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.

Value Comment
1 Orientation change only
2 Lowest random movement value
5 Default random movement value

currentwaypoint

The current waypoint number that the creature is on, if any. See creature_movement.point

curhealth

The current health that the creature has. For CLS enabled NPCs value of 1 should be used unless NPC has lower-than-max HP out of combat. DEPRECATED: Use creature_spawn_data_template paradigm instead.

curmana

The current mana that the creature has. Some NPCs start with 0 mana, needs to be combined with removing REGEN_FLAG_POWER from creature_template. DEPRECATED: Use creature_spawn_data_template paradigm instead.

DeathState

The creature’s death state. DEPRECATED: Official way uses fake death spells like 29266 instead.
A boolean, 0 = Alive, 1 = Corpse lying dead around (no gossip possible when dead, if you need corpse-gossip use dynamicflags|32)

MovementType

See creature_template.MovementType for possible values.

creature_movement and creature_movement_template need to have MovementType set to 2 for a guid.

Clone this wiki locally