Spell affect

From OregonCore Wiki
Jump to: navigation, search

Back to world database list of tables.

The `spell_affect` table

This table holds information on what spells are affected by what spell mods. All spells in this table need to apply an aura that either adds a flat modifier to other spells or adds a percent modifier to other spells. Also, a single row in this table only holds information on a single spell effect that applies the aura. Therefore since a spell may have up to three effects, a maximum of 3 rows per spell is allowed. However, only the spell effects that apply the flat or percent auras will be used.

Schema Last Modified: TC1-1828 - Schema Verified: Rev 665


Field Type Attributes Key Null Default Extra Comment
entry smallint(5) unsigned PRI NO 0
effectId tinyint(3) unsigned PRI NO 0
SpellFamilyMask bigint(20) unsigned NO 0

Description of the fields


The modifying spell entry ID. See Spell.dbc


The effect index of the effect that applies the aura with the flat or percent modifier. This field along with entry defines a single modifying entry. The effect IDs are numbered starting with 0, so the first effect is 0, the next is 1, and finally the last is 2.


This field controls what family flag or flags a spell needs to have to be affected by the modifier. This is the main field that defines which spells are affected by modifiers. For SpellFamily see spell.dbc (in WoW-2.4.2 column 198)