Spells

Intro

Spells are arguably one of the most intricate systems in WoW, this page will hopefully explain some of the basics as well as going into how to parse tooltips or how to do some of the number crunching.

Relevant DB2s

Many DB2s are used when it comes to spell data, most are listed below with a small explanation on what they're for.

Table	WoW.tools link	Description
Spell	Browse	Hopefully exhaustive list of all spells in the game, has partial (aura) descriptions for tooltips
SpellAuraOptions	Browse
SpellAuraRestrictions	Browse
SpellCastingRequirements	Browse	Various requirements for being able to cast a spell (e.g. being in a specific area)
SpellCastTimes	Browse	Casting times for spells in milliseconds, linked to spellIDs from SpellMisc
SpellCategories	Browse
SpellCategory	Browse
SpellClassOptions	Browse
SpellCooldowns	Browse
SpellDescriptionVariables	Browse
SpellDuration	Browse
SpellEffect	Browse
SpellEffectAutoDescription	Browse
SpellInterrupts	Browse
SpellItemEnchantment	Browse
SpellLabel	Browse
SpellLearnSpell	Browse
SpellMisc	Browse
SpellName	Browse	Spell names
SpellPower	Browse
SpellProcsPerMinute	Browse
SpellProcsPerMinuteMod	Browse
SpellRadius	Browse
SpellRange	Browse
SpellScaling	Browse
SpellShapeShift	Browse
SpellTargetRestrictions	Browse
SpellXDescriptionVariables	Browse

Intro

SpellIDs

Spells in WoW are referred to by a ID for that spell throughout various of the above DBs. For some DBs such as SpellName the ID field is the Spell ID.

Spell effects

Each spell can have multiple effects.

Calculations

Instance spells

Some spells used in instances can scale differently based on the current difficulty.

TODO

   SpellEffect.Effect = SCHOOL_DAMAGE (2) => CreatureSpellDamage 
   ExpectedStat for lvl 120 = CreatureSpellDamage = 76940.51
   Ny'alotha => Map::ID 2217
   MapDifficulty filter on above Map::ID
   Take all results for specified mod column and multiple them together
   Multiply CreatureSpellDamage with the result of above calculation
   Multiply that by EffectBasePointsF / 100.0

Player spells

TODO

Visuals

TODO

SpellVisual SpellVisualAnim SpellVisualAnimName SpellVisualColorEffect SpellVisualEffectName SpellVisualEvent SpellVisualKit SpellVisualKitAreaModel SpellVisualKitEffect SpellVisualKitModelAttach SpellVisualMissile SpellVisualPrecastTransitions SpellVisualScreenEffect SpellXSpellVisual