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

  • creature_spells


    antz
     Share

     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_spells' table for MaNGOSZero

    A simple in-combat spell casts on a timer in a spell list that is assigned to the creature.

    Table Notes

    This table uses the 'MyISAM' DB Engine

    The Field definitions follow:

    Field Name Field Type Nullable Key Default Value Attributes Notes
    entry int(11) unsigned NO PRI '0'   Id of the list.
    name varchar(255) NO {Blank String}   Name of the list.
    spellId_1 smallint(5) unsigned NO '0'   A spell id from Spell.dbc.
    probability_1 tinyint(3) unsigned NO '100'   Chance to cast the spell.
    castTarget_1 tinyint(2) unsigned NO '1'   On what target to cast the spell.
    targetParam1_1 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    targetParam2_1 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    castFlags_1 tinyint(2) unsigned NO '0'   Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.
    delayInitialMin_1 smallint(5) unsigned NO '0'   Minimum initial delay when entering combat before casting the spell.
    delayInitialMax_1 smallint(5) unsigned NO '0'   Maximum initial delay when entering combat before casting the spell.
    delayRepeatMin_1 smallint(5) unsigned NO '0'   Minimum cooldown to cast the spell a second time.
    delayRepeatMax_1 smallint(5) unsigned NO '0'   Maximum cooldown to cast the spell a second time.
    scriptId_1 mediumint(8) unsigned NO '0'   The ID of the script to be used.
    spellId_2 smallint(5) unsigned NO '0'   A spell id from Spell.dbc.
    probability_2 tinyint(3) unsigned NO '100'   Chance to cast the spell.
    castTarget_2 tinyint(2) unsigned NO '1'   On what target to cast the spell.
    targetParam1_2 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    targetParam2_2 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    castFlags_2 tinyint(2) unsigned NO '0'   Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.
    delayInitialMin_2 smallint(5) unsigned NO '0'   Minimum initial delay when entering combat before casting the spell.
    delayInitialMax_2 smallint(5) unsigned NO '0'   Maximum initial delay when entering combat before casting the spell.
    delayRepeatMin_2 smallint(5) unsigned NO '0'   Minimum cooldown to cast the spell a second time.
    delayRepeatMax_2 smallint(5) unsigned NO '0'   Maximum cooldown to cast the spell a second time.
    scriptId_2 mediumint(8) unsigned NO '0'   The ID of the script to be used.
    spellId_3 smallint(5) unsigned NO '0'   A spell id from Spell.dbc.
    probability_3 tinyint(3) unsigned NO '100'   Chance to cast the spell.
    castTarget_3 tinyint(2) unsigned NO '1'   On what target to cast the spell.
    targetParam1_3 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    targetParam2_3 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    castFlags_3 tinyint(2) unsigned NO '0'   Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.
    delayInitialMin_3 smallint(5) unsigned NO '0'   Minimum initial delay when entering combat before casting the spell.
    delayInitialMax_3 smallint(5) unsigned NO '0'   Maximum initial delay when entering combat before casting the spell.
    delayRepeatMin_3 smallint(5) unsigned NO '0'   Minimum cooldown to cast the spell a second time.
    delayRepeatMax_3 smallint(5) unsigned NO '0'   Maximum cooldown to cast the spell a second time.
    scriptId_3 mediumint(8) unsigned NO '0'   The ID of the script to be used.
    spellId_4 smallint(5) unsigned NO '0'   A spell id from Spell.dbc.
    probability_4 tinyint(3) unsigned NO '100'   Chance to cast the spell.
    castTarget_4 tinyint(2) unsigned NO '1'   On what target to cast the spell.
    targetParam1_4 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    targetParam2_4 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    castFlags_4 tinyint(2) unsigned NO '0'   Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.
    delayInitialMin_4 smallint(5) unsigned NO '0'   Minimum initial delay when entering combat before casting the spell.
    delayInitialMax_4 smallint(5) unsigned NO '0'   Maximum initial delay when entering combat before casting the spell.
    delayRepeatMin_4 smallint(5) unsigned NO '0'   Minimum cooldown to cast the spell a second time.
    delayRepeatMax_4 smallint(5) unsigned NO '0'   Maximum cooldown to cast the spell a second time.
    scriptId_4 mediumint(8) unsigned NO '0'   The ID of the script to be used.
    spellId_5 smallint(5) unsigned NO '0'   A spell id from Spell.dbc.
    probability_5 tinyint(3) unsigned NO '100'   Chance to cast the spell.
    castTarget_5 tinyint(2) unsigned NO '1'   On what target to cast the spell.
    targetParam1_5 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    targetParam2_5 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    castFlags_5 tinyint(2) unsigned NO '0'   Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.
    delayInitialMin_5 smallint(5) unsigned NO '0'   Minimum initial delay when entering combat before casting the spell.
    delayInitialMax_5 smallint(5) unsigned NO '0'   Maximum initial delay when entering combat before casting the spell.
    delayRepeatMin_5 smallint(5) unsigned NO '0'   Minimum cooldown to cast the spell a second time.
    delayRepeatMax_5 smallint(5) unsigned NO '0'   Maximum cooldown to cast the spell a second time.
    scriptId_5 mediumint(8) unsigned NO '0'   The ID of the script to be used.
    spellId_6 smallint(5) unsigned NO '0'   A spell id from Spell.dbc.
    probability_6 tinyint(3) unsigned NO '100'   Chance to cast the spell.
    castTarget_6 tinyint(2) unsigned NO '1'   On what target to cast the spell.
    targetParam1_6 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    targetParam2_6 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    castFlags_6 tinyint(2) unsigned NO '0'   Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.
    delayInitialMin_6 smallint(5) unsigned NO '0'   Minimum initial delay when entering combat before casting the spell.
    delayInitialMax_6 smallint(5) unsigned NO '0'   Maximum initial delay when entering combat before casting the spell.
    delayRepeatMin_6 smallint(5) unsigned NO '0'   Minimum cooldown to cast the spell a second time.
    delayRepeatMax_6 smallint(5) unsigned NO '0'   Maximum cooldown to cast the spell a second time.
    scriptId_6 mediumint(8) unsigned NO '0'   The ID of the script to be used.
    spellId_7 smallint(5) unsigned NO '0'   A spell id from Spell.dbc.
    probability_7 tinyint(3) unsigned NO '100'   Chance to cast the spell.
    castTarget_7 tinyint(2) unsigned NO '1'   On what target to cast the spell.
    targetParam1_7 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    targetParam2_7 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    castFlags_7 tinyint(2) unsigned NO '0'   Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.
    delayInitialMin_7 smallint(5) unsigned NO '0'   Minimum initial delay when entering combat before casting the spell.
    delayInitialMax_7 smallint(5) unsigned NO '0'   Maximum initial delay when entering combat before casting the spell.
    delayRepeatMin_7 smallint(5) unsigned NO '0'   Minimum cooldown to cast the spell a second time.
    delayRepeatMax_7 smallint(5) unsigned NO '0'   Maximum cooldown to cast the spell a second time.
    scriptId_7 mediumint(8) unsigned NO '0'   The ID of the script to be used.
    spellId_8 smallint(5) unsigned NO '0'   A spell id from Spell.dbc.
    probability_8 tinyint(3) unsigned NO '100'   Chance to cast the spell.
    castTarget_8 tinyint(2) unsigned NO '1'   On what target to cast the spell.
    targetParam1_8 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    targetParam2_8 smallint(5) unsigned NO '0'   Additional parameter for the target if needed. See the targeting enum.
    castFlags_8 tinyint(2) unsigned NO '0'   Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.
    delayInitialMin_8 smallint(5) unsigned NO '0'   Minimum initial delay when entering combat before casting the spell.
    delayInitialMax_8 smallint(5) unsigned NO '0'   Maximum initial delay when entering combat before casting the spell.
    delayRepeatMin_8 smallint(5) unsigned NO '0'   Minimum cooldown to cast the spell a second time.
    delayRepeatMax_8 smallint(5) unsigned NO '0'   Maximum cooldown to cast the spell a second time.
    scriptId_8 mediumint(8) unsigned NO '0'   The ID of the script to be used.

    Description of the fields

    entry int(11) unsigned

    This is the Id of the list.
    Convention is to have first list for creature be equal Creature Entry * 10, then second list would be Creature Entry * 10 + 1, etc

    name varchar(255)

    This is the Name of the list.
    Convention is "Zone Name - Creature Name".

    spellId_1 smallint(5) unsigned

    A spell id from Spell.dbc.

    probability_1 tinyint(3) unsigned

    Chance to cast the spell.

    castTarget_1 tinyint(2) unsigned

    On what target to cast the spell. See the targeting enum in CreatureAI.cpp.

    targetParam1_1 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    targetParam2_1 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    castFlags_1 tinyint(2) unsigned

    Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.

    delayInitialMin_1 smallint(5) unsigned

    Minimum initial delay when entering combat before casting the spell.

    delayInitialMax_1 smallint(5) unsigned

    Maximum initial delay when entering combat before casting the spell.

    delayRepeatMin_1 smallint(5) unsigned

    Minimum cooldown to cast the spell a second time.

    delayRepeatMax_1 smallint(5) unsigned

    Maximum cooldown to cast the spell a second time.

    scriptId_1 mediumint(8) unsigned

    The ID of the script to be used.

    spellId_2 smallint(5) unsigned

    A spell id from Spell.dbc.

    probability_2 tinyint(3) unsigned

    Chance to cast the spell.

    castTarget_2 tinyint(2) unsigned

    On what target to cast the spell. See the targeting enum in CreatureAI.cpp.

    targetParam1_2 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    targetParam2_2 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    castFlags_2 tinyint(2) unsigned

    Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.

    delayInitialMin_2 smallint(5) unsigned

    Minimum initial delay when entering combat before casting the spell.

    delayInitialMax_2 smallint(5) unsigned

    Maximum initial delay when entering combat before casting the spell.

    delayRepeatMin_2 smallint(5) unsigned

    Minimum cooldown to cast the spell a second time.

    delayRepeatMax_2 smallint(5) unsigned

    Maximum cooldown to cast the spell a second time.

    scriptId_2 mediumint(8) unsigned

    The ID of the script to be used.

    spellId_3 smallint(5) unsigned

    A spell id from Spell.dbc.

    probability_3 tinyint(3) unsigned

    Chance to cast the spell.

    castTarget_3 tinyint(2) unsigned

    On what target to cast the spell. See the targeting enum in CreatureAI.cpp.

    targetParam1_3 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    targetParam2_3 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    castFlags_3 tinyint(2) unsigned

    Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.

    delayInitialMin_3 smallint(5) unsigned

    Minimum initial delay when entering combat before casting the spell.

    delayInitialMax_3 smallint(5) unsigned

    Maximum initial delay when entering combat before casting the spell.

    delayRepeatMin_3 smallint(5) unsigned

    Minimum cooldown to cast the spell a second time.

    delayRepeatMax_3 smallint(5) unsigned

    Maximum cooldown to cast the spell a second time.

    scriptId_3 mediumint(8) unsigned

    The ID of the script to be used.

    spellId_4 smallint(5) unsigned

    A spell id from Spell.dbc.

    probability_4 tinyint(3) unsigned

    Chance to cast the spell.

    castTarget_4 tinyint(2) unsigned

    On what target to cast the spell. See the targeting enum in CreatureAI.cpp.

    targetParam1_4 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    targetParam2_4 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    castFlags_4 tinyint(2) unsigned

    Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.

    delayInitialMin_4 smallint(5) unsigned

    Minimum initial delay when entering combat before casting the spell.

    delayInitialMax_4 smallint(5) unsigned

    Maximum initial delay when entering combat before casting the spell.

    delayRepeatMin_4 smallint(5) unsigned

    Minimum cooldown to cast the spell a second time.

    delayRepeatMax_4 smallint(5) unsigned

    Maximum cooldown to cast the spell a second time.

    scriptId_4 mediumint(8) unsigned

    The ID of the script to be used.

    spellId_5 smallint(5) unsigned

    A spell id from Spell.dbc.

    probability_5 tinyint(3) unsigned

    Chance to cast the spell.

    castTarget_5 tinyint(2) unsigned

    On what target to cast the spell. See the targeting enum in CreatureAI.cpp.

    targetParam1_5 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    targetParam2_5 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    castFlags_5 tinyint(2) unsigned

    Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.

    delayInitialMin_5 smallint(5) unsigned

    Minimum initial delay when entering combat before casting the spell.

    delayInitialMax_5 smallint(5) unsigned

    Maximum initial delay when entering combat before casting the spell.

    delayRepeatMin_5 smallint(5) unsigned

    Minimum cooldown to cast the spell a second time.

    delayRepeatMax_5 smallint(5) unsigned

    Maximum cooldown to cast the spell a second time.

    scriptId_5 mediumint(8) unsigned

    The ID of the script to be used.

    spellId_6 smallint(5) unsigned

    A spell id from Spell.dbc.

    probability_6 tinyint(3) unsigned

    Chance to cast the spell.

    castTarget_6 tinyint(2) unsigned

    On what target to cast the spell. See the targeting enum in CreatureAI.cpp.

    targetParam1_6 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    targetParam2_6 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    castFlags_6 tinyint(2) unsigned

    Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.

    delayInitialMin_6 smallint(5) unsigned

    Minimum initial delay when entering combat before casting the spell.

    delayInitialMax_6 smallint(5) unsigned

    Maximum initial delay when entering combat before casting the spell.

    delayRepeatMin_6 smallint(5) unsigned

    Minimum cooldown to cast the spell a second time.

    delayRepeatMax_6 smallint(5) unsigned

    Maximum cooldown to cast the spell a second time.

    scriptId_6 mediumint(8) unsigned

    The ID of the script to be used.

    spellId_7 smallint(5) unsigned

    A spell id from Spell.dbc.

    probability_7 tinyint(3) unsigned

    Chance to cast the spell.

    castTarget_7 tinyint(2) unsigned

    On what target to cast the spell. See the targeting enum in CreatureAI.cpp.

    targetParam1_7 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    targetParam2_7 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    castFlags_7 tinyint(2) unsigned

    Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.

    delayInitialMin_7 smallint(5) unsigned

    Minimum initial delay when entering combat before casting the spell.

    delayInitialMax_7 smallint(5) unsigned

    Maximum initial delay when entering combat before casting the spell.

    delayRepeatMin_7 smallint(5) unsigned

    Minimum cooldown to cast the spell a second time.

    delayRepeatMax_7 smallint(5) unsigned

    Maximum cooldown to cast the spell a second time.

    scriptId_7 mediumint(8) unsigned

    The ID of the script to be used.

    spellId_8 smallint(5) unsigned

    A spell id from Spell.dbc.

    probability_8 tinyint(3) unsigned

    Chance to cast the spell.

    castTarget_8 tinyint(2) unsigned

    On what target to cast the spell. See the targeting enum in CreatureAI.cpp.

    targetParam1_8 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    targetParam2_8 smallint(5) unsigned

    Additional parameter for the target if needed. See the targeting enum.

    castFlags_8 tinyint(2) unsigned

    Flags for the cast, see enum SpellListCastFlags in CreatureAI.h.

    delayInitialMin_8 smallint(5) unsigned

    Minimum initial delay when entering combat before casting the spell.

    delayInitialMax_8 smallint(5) unsigned

    Maximum initial delay when entering combat before casting the spell.

    delayRepeatMin_8 smallint(5) unsigned

    Minimum cooldown to cast the spell a second time.

    delayRepeatMax_8 smallint(5) unsigned

    Maximum cooldown to cast the spell a second time.

    scriptId_8 mediumint(8) unsigned

    The ID of the script to be used.


    auto-generated by the getMaNGOS.eu MAGNET dbdocs module

    Edited by Antz

     Share


    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