“spell_affect” table¶

The spell_affect table holds information on what spells are affected by spell modifiers.

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. Each entry applies to one spell effect, thus spells with multiple effects will require multiple entries.

Table structure¶

Field	Type	Null	Key
entry	smallint(5) unsigned	NO	PRI
effectId	tinyint(3) unsigned	NO	PRI
SpellFamilyMask	bigint(20) unsigned	NO

Fields¶

entry¶

The spell identifier. The value has to match with a spell identifier defined in Spell.dbc.

effectId¶

This holds an index to the referenced spells effect. Three spell effects may be contained in a single spell, thus valid indexes are 0, 1 and 2.

SpellFamilyMask¶

A spell class identifier. The value has to match with a spell class identifier from Spell.dbc, and references the spellClassSet field in that file.