Jump to content
  • We are looking for staff for the Wiki area!
    If interested please
    click here and select "Documentation Team"

  • creature_template_addon


    antz
     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 MaNGOSOne

    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 'MyISAM' 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_flags tinyint(3) unsigned NO '0'   The value here overrides the value for the creature's unit field UNIT_FIELD_BYTE
    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_flags tinyint(3) unsigned

    The value here overrides the value for the creature's unit field UNIT_FIELD_BYTES_2.

    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


    User Feedback

    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 account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use