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