-
Notifications
You must be signed in to change notification settings - Fork 48
spell_template
AnonXS edited this page Feb 14, 2018
·
32 revisions
Back to world database list of tables.
holds data about every spell used.
| Field | Type | Null | Key | Default | Extra |
| Id | INT UNSIGNED | NO | 0 | ||
| Category | INT UNSIGNED | NO | 0 | ||
| Dispel | INT UNSIGNED | NO | 0 | ||
| Mechanic | INT UNSIGNED | NO | 0 | ||
| Attributes | INT UNSIGNED | NO | 0 | ||
| AttributesEx | INT UNSIGNED | NO | 0 | ||
| AttributesEx2 | INT UNSIGNED | NO | 0 | ||
| AttributesEx3 | INT UNSIGNED | NO | 0 | ||
| AttributesEx4 | INT UNSIGNED | NO | 0 | ||
| AttributesEx5 | INT UNSIGNED | NO | 0 | ||
| AttributesEx6 | INT UNSIGNED | NO | 0 | ||
| Stances | INT UNSIGNED | NO | 0 | ||
| StancesNot | INT UNSIGNED | NO | 0 | ||
| Targets | INT UNSIGNED | NO | 0 | ||
| TargetCreatureType | INT UNSIGNED | NO | 0 | ||
| RequiresSpellFocus | INT UNSIGNED | NO | 0 | ||
| FacingCasterFlags | INT UNSIGNED | NO | 0 | ||
| CasterAuraState | INT UNSIGNED | NO | 0 | ||
| TargetAuraState | INT UNSIGNED | NO | 0 | ||
| CasterAuraStateNot | INT UNSIGNED | NO | 0 | ||
| TargetAuraStateNot | INT UNSIGNED | NO | 0 | ||
| CastingTimeIndex | INT UNSIGNED | NO | 0 | ||
| RecoveryTime | INT UNSIGNED | NO | 0 | ||
| CategoryRecoveryTime | INT UNSIGNED | NO | 0 | ||
| InterruptFlags | INT UNSIGNED | NO | 0 | ||
| AuraInterruptFlags | INT UNSIGNED | NO | 0 | ||
| ChannelInterruptFlags | INT UNSIGNED | NO | 0 | ||
| procFlags | INT UNSIGNED | NO | 0 | ||
| procChance | INT UNSIGNED | NO | 0 | ||
| procCharges | INT UNSIGNED | NO | 0 | ||
| maxLevel | INT UNSIGNED | NO | 0 | ||
| baseLevel | INT UNSIGNED | NO | 0 | ||
| spellLevel | INT UNSIGNED | NO | 0 | ||
| DurationIndex | int(11) unsigned | NO | 0 | ||
| powerType | INT UNSIGNED | NO | 0 | ||
| manaCost | INT UNSIGNED | NO | 0 | ||
| manaCostPerlevel | INT UNSIGNED | NO | 0 | ||
| manaPerSecond | INT UNSIGNED | NO | 0 | ||
| manaPerSecondPerLevel | INT UNSIGNED | NO | 0 | ||
| rangeIndex | INT UNSIGNED | NO | 1 | ||
| speed | FLOAT | NO | 0 | ||
| StackAmount | INT UNSIGNED | NO | 0 | ||
| Totem1 | INT UNSIGNED | NO | 0 | ||
| Totem2 | INT UNSIGNED | NO | 0 | ||
| Reagent1 | INT UNSIGNED | NO | 0 | ||
| ReagentCount1 | INT UNSIGNED | NO | 0 | ||
| EquippedItemClass | INT UNSIGNED | NO | -1 | ||
| EquippedItemSubClassMask | INT UNSIGNED | NO | 0 | ||
| EquippedItemInventoryTypeMask | INT UNSIGNED | NO | 0 | ||
| Effect1 | INT UNSIGNED | NO | 0 | ||
| EffectDieSides1 | INT UNSIGNED | NO | 0 | ||
| EffectBaseDice1 | INT UNSIGNED | NO | 0 | ||
| EffectDicePerLevel1 | FLOAT | NO | 0 | ||
| EffectRealPointsPerLevel1 | FLOAT | NO | 0 | ||
| EffectBasePoints1 | INT UNSIGNED | NO | 0 | ||
| EffectMechanic1 | INT UNSIGNED | NO | 0 | ||
| EffectImplicitTargetA1 | INT UNSIGNED | NO | 0 | ||
| EffectImplicitTargetB1 | INT UNSIGNED | NO | 0 | ||
| EffectRadiusIndex1 | INT UNSIGNED | NO | 0 | ||
| EffectApplyAuraName1 | INT UNSIGNED | NO | 0 | ||
| EffectAmplitude1 | INT UNSIGNED | NO | 0 | ||
| EffectMultipleValue1 | FLOAT | NO | 0 | ||
| EffectChainTarget1 | INT UNSIGNED | NO | 0 | ||
| EffectItemType1 | INT UNSIGNED | NO | 0 | ||
| EffectMiscValue1 | INT UNSIGNED | NO | 0 | ||
| EffectMiscValueB1 | INT | NO | 0 | ||
| EffectTriggerSpell1 | INT UNSIGNED | NO | 0 | ||
| EffectPointsPerComboPoint1 | FLOAT | NO | 0 | ||
| SpellVisual | INT UNSIGNED | NO | 0 | ||
| SpellIconID | INT UNSIGNED | NO | 0 | ||
| activeIconID | INT UNSIGNED | NO | 0 | ||
| spellPriority | INT UNSIGNED | NO | 0 | ||
| SpellName | TEXT | NO | 0 | ||
| Rank | TEXT | NULL | 0 | ||
| ManaCostPercentage | INT UNSIGNED | NO | 0 | ||
| StartRecoveryCategory | INT UNSIGNED | NO | 0 | ||
| StartRecoveryTime | INT UNSIGNED | NO | 0 | ||
| MaxTargetLevel | INT UNSIGNED | NO | 0 | ||
| SpellFamilyName | INT UNSIGNED | NO | 0 | ||
| SpellFamilyFlags | BIGINT UNSIGNED | NO | 0 | ||
| MaxAffectedTargets | INT UNSIGNED | NO | 0 | ||
| DmgClass | INT UNSIGNED | NO | 0 | ||
| PreventionType | INT UNSIGNED | NO | 0 | ||
| DmgMultiplier1 | INT UNSIGNED | NO | 0 | ||
| TotemCategory1 | INT UNSIGNED | NO | 0 | ||
| TotemCategory2 | INT UNSIGNED | NO | 0 | ||
| AreaId | INT UNSIGNED | NO | 0 | ||
| SchoolMask | INT UNSIGNED | NO | 0 | ||
| IsServerSide | INT UNSIGNED | NO | 0 | ||
| AttributesServerside | INT UNSIGNED | NO | 0 |
The spell ID.
| Bit | Flag | Comment |
| 0 | Killed | |
| 1 | Kill | |
| 2 | Successful Melee Hit | |
| 3 | Taken Melee Hit | |
| 4 | Successful Melee Spell Hit | |
| 5 | Taken Melee Spell Hit | |
| 6 | Successful Ranged Hit | |
| 7 | Taken Ranged Hit | |
| 8 | Successful Ranged Spell Hit | |
| 9 | Taken Ranged Spell Hit | |
| 10 | Successful Positive Aoe Hit | |
| 11 | Taken Positive Aoe | |
| 12 | Successful Aoe Spell Hit | |
| 13 | Taken Aoe Spell Hit | |
| 14 | Successful Positive Spell | |
| 15 | Taken Positive Spell | |
| 16 | Successful Negative Spell Hit | |
| 17 | Taken Negative Spell Hit | |
| 18 | On Do Periodic | |
| 19 | On Take Periodic | |
| 20 | Taken Any Damage | |
| 21 | On Trap Activation | |
| 22 | Successful Mainhand Hit | |
| 23 | Successful Offhand Hit | |
| 24 | Death |