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.
Spell tooltips
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