Spell_affect

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.

Structure

Field	Type	Null	Key	Default	Extra
entry	smallint(5) unsigned	NO	PRI	0
effectId	tinyint(3) unsigned	NO	PRI	0
SpellClassMask0	int(5) unsigned	NO		0
SpellClassMask1	int(5) unsigned	NO		0
SpellClassMask2	int(5) unsigned	NO		0

Description of the fields

entry

The modifying spell entry ID. See Spell.dbc

effectId

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.

SpellClassMask

This field controls what class 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 SpellClass see spell.dbc (in WoW-3.0.3 column 211)