|
NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'creature' table for MaNGOSThree
Contains individual creature spawn data. Spawn of a creature is an instance of the creature object in the world.
Table Notes
This table uses the 'MyISAM' DB Engine
The Field definitions follow:
| Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
|---|---|---|---|---|---|---|
| guid | int(10) unsigned | NO | PRI | NULL | 'auto_increment' | A unique identifier given to each creature to distinguish creatures. |
| id | mediumint(8) unsigned | NO | MUL | '0' | The id of the template that is used when instantiating this creature. | |
| map | smallint(5) unsigned | NO | MUL | '0' | The map id of the location of the creature [See map.dbc]. | |
| spawnMask | tinyint(3) unsigned | NO | '1' | |||
| phaseMask | int(11) unsigned | NO | '1' | |||
| modelid | mediumint(8) unsigned | NO | '0' | The model id of the the creature. | ||
| equipment_id | mediumint(9) | NO | '0' | The ID of the equipment that the creature is using. | ||
| position_x | float | NO | '0' | The x position of the creature. | ||
| position_y | float | NO | '0' | The y position of the creature. | ||
| position_z | float | NO | '0' | The z position of the creature. | ||
| orientation | float | NO | '0' | The orientation of the creature. (North = 0.0; South = pi (3.14159)) | ||
| spawntimesecs | int(10) unsigned | NO | '120' | The respawn time of the creature in seconds. | ||
| spawndist | float | NO | '5' | The maximum distance that the creature should spawn from its spawn point. | ||
| currentwaypoint | mediumint(8) unsigned | NO | '0' | The current waypoint of the creature. | ||
| curhealth | int(10) unsigned | NO | '1' | The current health of the creature. | ||
| curmana | int(10) unsigned | NO | '0' | The current mana of the creature. | ||
| DeathState | tinyint(3) unsigned | NO | '0' | The creature's death state. | ||
| MovementType | tinyint(3) unsigned | NO | '0' | The movement type associated with this creature. |
Description of the fields
guid int(10) unsigned
A unique identifier given to each creature to distinguish one creature from another. Two creatures can NOT have same GUID.
id mediumint(8) unsigned
The id of the template that is used when instantiating this creature [See creature_template.entry].
map smallint(5) unsigned
The map id of the location of the creature [See map.dbc].
spawnMask tinyint(3) unsigned
phaseMask int(11) unsigned
modelid mediumint(8) unsigned
The model id of the the creature.
equipment_id mediumint(9)
The ID of the equipment that the creature is using [See creature_equip_template.entry].
position_x float
The x position of the creature.
position_y float
The y position of the creature.
position_z float
The z position of the creature.
orientation float
The orientation of the creature. (North = 0.0; South = pi (3.14159))
spawntimesecs int(10) unsigned
The respawn time of the creature in seconds.
spawndist float
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 mediumint(8) unsigned
The current waypoint of the creature.
curhealth int(10) unsigned
The current health of the creature.
curmana int(10) unsigned
The current mana of the creature.
DeathState tinyint(3) unsigned
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)
| Value | State |
|---|---|
| 0 | Alive |
| 1 | Dead |
Note:
Dead creatures can not have gossip dialogues, unless you explicitly set the dynamic flag for corpses on the "creature_template" table.
MovementType tinyint(3) unsigned
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.
| ID | Type |
|---|---|
| 0 | Idle; stay in one place |
| 1 | Random movement inside the spawndist radius |
| 2 | Waypoint movement |
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now