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_template_addon' table for MaNGOSThree
The creature_addon and creature_template_addon tables define different things that are applied on creatures when they are loaded. These "different things" can be for example to have the creature be mounted, to have it emote something, to have it display an aura effect, etc. Through the use of the fields in this table, many things can be changed about the outward visual appearance of the creature. The creature_template_addon table affects all creatures with that creature template ID while the creature_addon table affects individually spawned creatures (so that two creatures using the same template can look different).
NOTES:
A creature_addon record will override a creature_template_addon record should they overlap on the same creature.
The data for this table is largely incomplete and is mostly just a regurgitation of what the client receives from the server. This article is a WIP as to what all the possible values are.
Table Notes
This table uses the 'InnoDB' DB Engine
The Field definitions follow:
Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
---|---|---|---|---|---|---|
entry | mediumint(8) unsigned | NO | PRI | '0' | This references the "creature_template" table's unique ID. | |
mount | mediumint(8) unsigned | NO | '0' | A display model identifier used as mount for the creature_template. | ||
bytes1 | int(10) unsigned | NO | '0' | TODO | ||
b2_0_sheath | tinyint(3) unsigned | NO | '0' | Defines the sheath state of the creature_template. | ||
b2_1_pvp_state | tinyint(3) unsigned | NO | '0' | |||
emote | mediumint(8) unsigned | NO | '0' | Emote ID that the creature should continually perform. | ||
moveflags | int(10) unsigned | NO | '0' | The flag controls how a creature_template will be animated while moving. | ||
auras | text | YES | NULL | Allows to attach auras to a creature_template entry. |
Description of the fields
entry mediumint(8) unsigned
This references the unique ID in table "creature_template" [See creature_template.id] for which the entry is valid.
mount mediumint(8) unsigned
A display model identifier used as mount for the creature_template. This references the "creature_model_info" table tables unique ID for which this entry is valid.
bytes1 int(10) unsigned
TODO
b2_0_sheath tinyint(3) unsigned
Defines the sheath state of the creature_template.
Value | State |
---|---|
0 | All weapons sheathed |
1 | Melee weapon unsheathed |
2 | Ranged weapon unsheathed |
b2_1_pvp_state tinyint(3) unsigned
emote mediumint(8) unsigned
Emote ID that the creature should continually perform.
List of often used emote IDs and what they do ie. 65 Makes the creature look dead by lying on the ground.
Value | Emote Name |
---|---|
10 | EMOTE_STATE_DANCE |
12 | EMOTE_STATE_SLEEP |
13 | EMOTE_STATE_SIT |
26 | EMOTE_STATE_STAND |
28 | EMOTE_STATE_WORK |
64 | EMOTE_STATE_STUN |
64 | EMOTE_STATE_DEAD |
68 | EMOTE_STATE_KNEEL |
70 | EMOTE_ONESHOT_WAVE_NOSHEATHE |
71 | EMOTE_ONESHOT_CHEER_NOSHEATHE |
92 | EMOTE_ONESHOT_EAT_NOSHEATHE |
173 | EMOTE_STATE_WORK_NOSHEATHE |
379 | EMOTE_STATE_FISHING |
380 | EMOTE_ONESHOT_FISHING |
381 | EMOTE_ONESHOT_LOOT |
382 | EMOTE_STATE_WHIRLWIND |
392 | EMOTE_STATE_LAUGH |
398 | EMOTE_STATE_CANNIBALIZE |
400 | EMOTE_STATE_DANCESPECIAL |
412 | EMOTE_STATE_EXCLAIM |
415 | EMOTE_STATE_SIT_CHAIR_MED |
moveflags int(10) unsigned
The flag controls how a creature_template will be animated while moving.
Value | Movement Animation |
---|---|
0x00000000 | MOVEFLAG_NONE |
0x00000001 | MOVEFLAG_FORWARD |
0x00000002 | MOVEFLAG_BACKWARD |
0x00000004 | MOVEFLAG_STRAFE_LEFT |
0x00000008 | MOVEFLAG_STRAFE_RIGHT |
0x00000010 | MOVEFLAG_TURN_LEFT |
0x00000020 | MOVEFLAG_TURN_RIGHT |
0x00000040 | MOVEFLAG_PITCH_UP |
0x00000080 | MOVEFLAG_PITCH_DOWN |
0x00000100 | MOVEFLAG_WALK_MODE |
0x00000400 | MOVEFLAG_LEVITATING |
0x00000800 | MOVEFLAG_ROOT |
0x00002000 | MOVEFLAG_FALLING |
0x00004000 | MOVEFLAG_FALLINGFAR |
0x00200000 | MOVEFLAG_SWIMMING |
0x00400000 | MOVEFLAG_ASCENDING |
0x00800000 | MOVEFLAG_CAN_FLY |
0x01000000 | MOVEFLAG_FLYING |
0x02000000 | MOVEFLAG_ONTRANSPORT |
0x04000000 | MOVEFLAG_SPLINE_ELEVATION |
0x08000000 | MOVEFLAG_SPLINE_ENABLED |
0x10000000 | MOVEFLAG_WATERWALKING |
0x20000000 | MOVEFLAG_SAFE_FALL |
0x40000000 | MOVEFLAG_HOVER |
auras text
Allows to attach auras to a creature_template entry. This includes visual auras and spell effects. The field is a string containing a spell identifier defined in Spell.dbc with an index to the spell effect.
Multiple spells can be concatenated. Spells and effect indexes are separated by space characters.
Examples
Value | Result |
---|---|
'16380 0' | Makes the creature_template invisible |
'18950 0 18950 1' | Makes the creature_template detect invisible creatures and players |
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