Skip to content
Schmoozerd edited this page Apr 14, 2013 · 1 revision

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
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 (2.4.3)#entry

map

The Map ID of where this NPC is to be spawned. See Maps.dbc (2.4.3).dbc

spawnMask

Controls under which difficulties the creature will be spawned.

Core value Description spawnMask
SPAWNMASK_REGULAR Will be visible everywhere, everytime 1
SPAWNMASK_DUNGEON_NORMAL Will be visible only in normal version of the dungeon 1
SPAWNMASK_DUNGEON_HEROIC Will be visible only in heroic version of the dungeon 2
SPAWNMASK_DUNGEON_ALL Will be visible in every version of the dungeon 3
SPAWNMASK_RAID_10MAN_NORMAL Will be visible only in 10-man normal version of the raid 1
SPAWNMASK_RAID_25MAN_NORMAL Will be visible only in 25-man normal version of the raid 2
SPAWNMASK_RAID_NORMAL_ALL Will be visible in every normal version of the raid 3
SPAWNMASK_RAID_10MAN_HEROIC Will be visible in 10-man heroic version of the raid 4
SPAWNMASK_RAID_25MAN_HEROIC Will be visible in 25-man heroic version of the raid 8
SPAWNMASK_RAID_HEROIC_ALL Will be visible in every heroic version of the raid 12
SPAWNMASK_RAID_ALL Will be visible in every version of the raid 15

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 (2.4.3) for more information on model-specific characteristics.

equipment_id

The ID of the equipment that the creature is using. See creature_equip_template.entry (2.4.3)#entry. Currently if the ID is not found in creature_equip_template MaNGOS One will look in creature_equip_template_raw.entry (2.4.3)#entry for a matching entry.

NOTE: The creature_equip_template_raw (2.4.3) table data is being converted in TBC-DB currently into creature_equip_template entries and the RAW table will eventually be phased out.

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 (2.4.3)#MovementType = 1.

currentwaypoint

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

curhealth

The current health that the creature has. It is a good idea to cross reference creature_template (2.4.3) Min/Max Health values.

curmana

The current mana that the creature has. It is a good idea to cross reference creature_template (2.4.3) Min/Max Mana values.

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 (2.4.3)#MovementType but can be different. See creature_template.MovementType (2.4.3)#MovementType for possible values.

Clone this wiki locally