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