“spell_learn_spell” table¶

The spell_learn_spell table holds information on spells which should be learned by a character when learning a spell.

This is e.g. used when learning professions, where a character gains the profession spell and an initial set of recipe spells.

Note

Do not include spells with SPELL_EFFECT_LEARN_SPELL here.

Table structure¶

Field Type Null Key Default Extra
entry smallint(5) unsigned NO PRI 0
SpellID smallint(5) unsigned NO PRI 0
Active tinyint(3) unsigned NO   1

entry¶

The spell identifier. The value has to match with a spell identifier defined in Spell.dbc. This is the spell which will teach the spell given by SpellID.

SpellID¶

The spell identifier. The value has to match with a spell identifier defined in Spell.dbc. This is the spell which a character will actually learn.

Active¶

Decides if a learned spell will appear in the character’s spell book.

Value Description
0 Will not appear in the spell book.
1 Will appear in the spell book.