Marqin: fix

2011-09-03T19:48:33Z

fix

Marqin: moved from old wiki

2011-09-03T19:47:03Z

moved from old wiki

New page

{| align="right"
| __TOC__
|}
[[Category: TrinityCore2 World database tables]]
{{Back-to:World}}

<big>'''The `creature` table'''</big>

Contains individual creature spawn data. Spawn of a creature is an instance of the creature object in the world.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#guid|guid]]
|int(10)
|unsigned
|PRI
|NO
|NULL
|Auto Increment
|Global Unique Identifier
|-
|[[#id|id]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|Creature Identifier
|-
|[[#map|map]]
|smallint(5)
|unsigned
|
|NO
|0
|
|Map Identifier
|-
|[[#spawnMask|spawnMask]]
|tinyint(3)
|unsigned
|
|NO
|1
|
|
|-
|[[#phaseMask|phaseMask]]
|smallint(5)
|unsigned
|
|NO
|1
|
|
|-
|[[#modelid|modelid]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|
|-
|[[#equipment_id|equipment_id]]
|mediumint(9)
|signed
|
|NO
|0
|
|
|-
|[[#position_x|position_x]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#position_y|position_y]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#position_z|position_z]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#orientation|orientation]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#spawntimesecs|spawntimesecs]]
|int(10)
|unsigned
|
|NO
|120
|
|
|-
|[[#spawndist|spawndist]]
|float
|signed
|
|NO
|5
|
|
|-
|[[#currentwaypoint|currentwaypoint]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|
|-
|[[#curhealth|curhealth]]
|int(10)
|unsigned
|
|NO
|1
|
|
|-
|[[#curmana|curmana]]
|int(10)
|unsigned
|
|NO
|0
|
|
|-
|[[#DeathState|DeathState]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#MovementType|MovementType]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#npcflag|npcflag]]
|int(10)
|unsigned
|
|NO
|0
|
|
|-
|[[#unit_flags|unit_flags]]
|int(10)
|unsigned
|
|NO
|0
|
|
|-
|[[#dynamicflags|dynamicflags]]
|int(10)
|unsigned
|
|NO
|0
|
|
|}

<big>'''Description of the fields'''</big>
==== 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_tc2#entry|creature_template.entry]]

==== map ====
The Map ID of the position of the creature. See [[Map.dbc tc2|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)

{| border=1 cellpadding=3 cellspacing=0
! 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_tc2|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_tc2#entry|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 [[creature tc2#MovementType|MovementType]] = 1.

==== currentwaypoint ====
The current waypoint number that the creature is on, if any. See [[waypoint_data_tc2#point|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_tc2#MovementType|creature_template.MovementType]] but can be different.

==== npcflag ====
Same as [[Creature_template_tc2#npcflag|creature_template.npcflag]]

NOTE: A creature.npcflag record will override a creature_template.npcflag record.

==== unit_flags ====
Same as [[Creature_template_tc2#unit_flags|creature_template.unit_flags]]

NOTE: A creature.unit_flags record will override a creature_template.unit_flags record.

==== dynamicflags ====
Same as [[Creature_template_tc2#dynamicflags|creature_template.dynamicflags]]

NOTE: A creature.dynamicflags record will override a creature_template.dynamicflags record.

Achievement.dbc SF - Revision history

Marqin: fix

Marqin: moved from old wiki