Creature SF - Revision history

Admin at 06:17, 9 January 2013

2013-01-09T06:17:18Z

← Older revision		Revision as of 01:17, 9 January 2013
Line 2:		Line 2:
	\| __TOC__		\| __TOC__
	\|}		\|}
	~~[[Category: SkyFire World database tables]]~~
	{{Back-to:World}}		{{Back-to:World}}

Line 303:		Line 302:

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

			[[DB:World\|Return to world database structure]]

Cheapgamer at 06:06, 6 July 2012

2012-07-06T06:06:40Z

← Older revision		Revision as of 01:06, 6 July 2012
Line 218:		Line 218:

	==== id ====		==== id ====
	The id of the template that is used when instantiating this creature. See [[~~creature_template_tc2~~#entry\|creature_template.entry]]		The id of the template that is used when instantiating this creature. See [[creature_template_SF#entry\|creature_template.entry]]

	==== map ====		==== map ====
	The Map ID of the position of the creature. See [[Map.dbc ~~tc2~~\|Map.dbc]]		The Map ID of the position of the creature. See [[Map.dbc SF\|Map.dbc]]

	==== spawnMask ====		==== spawnMask ====
Line 248:		Line 248:

	==== modelid ====		==== 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		The model ID associated with this creature. Note that two creatures that use the same template can have different models. See [[creature_model_info_SF\|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.		and a random model from its assigned models in creature_template will be assigned by the core.

	==== equipment_id ====		==== equipment_id ====
	The ID of the equipment that the creature is using. See [[~~creature_equip_template_tc2~~#entry\|creature_equip_template.entry]]		The ID of the equipment that the creature is using. See [[creature_equip_template_SF#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.		NOTE: equipment should be assigned in creature_template. Only use this if a guid has different equipment than others of the same entry.
Line 272:		Line 272:

	==== spawndist ====		==== 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.		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 SF#MovementType\|MovementType]] = 1.

	==== currentwaypoint ====		==== currentwaypoint ====
	The current waypoint number that the creature is on, if any. See [[~~waypoint_data_tc2~~#point\|waypoint_data.point]]		The current waypoint number that the creature is on, if any. See [[waypoint_data_SF#point\|waypoint_data.point]]

	==== curhealth ====		==== curhealth ====
Line 287:		Line 287:

	==== MovementType ====		==== MovementType ====
	The movement type associated with this creature. Usually the same as [[~~creature_template_tc2~~#MovementType\|creature_template.MovementType]] but can be different.		The movement type associated with this creature. Usually the same as [[creature_template_SF#MovementType\|creature_template.MovementType]] but can be different.

	==== npcflag ====		==== npcflag ====
	Same as [[~~Creature_template_tc2~~#npcflag\|creature_template.npcflag]]		Same as [[Creature_template_SF#npcflag\|creature_template.npcflag]]

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

	==== unit_flags ====		==== unit_flags ====
	Same as [[~~Creature_template_tc2~~#unit_flags\|creature_template.unit_flags]]		Same as [[Creature_template_SF#unit_flags\|creature_template.unit_flags]]

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

	==== dynamicflags ====		==== dynamicflags ====
	Same as [[~~Creature_template_tc2~~#dynamicflags\|creature_template.dynamicflags]]		Same as [[Creature_template_SF#dynamicflags\|creature_template.dynamicflags]]

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

Marqin: recategorized

2011-09-04T21:00:24Z

recategorized

← Older revision		Revision as of 16:00, 4 September 2011
Line 2:		Line 2:
	\| __TOC__		\| __TOC__
	\|}		\|}
	[[Category: ~~TrinityCore2~~ World database tables]]		[[Category: SkyFire World database tables]]
	{{Back-to:World}}		{{Back-to:World}}

Marqin: moved from old wiki

2011-09-03T19:48:51Z

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.