Spell learn spell

From UDB

Jump to: navigation, search

Contents

Back to world database list of tables.


The `spell_learn_spell` table

This table holds information on spells that should be learned at the same time a player learns another spell. For example the few spells that are automatically learned when a player first learns a new profession. All fields in this table use spell IDs from Spell.dbc

NOTE: Spells with spell effects SPELL_EFFECT_LEARN_SPELL should NOT be included in this table.


Structure

Field Type Null Key Default Extra
entry smallint(6) unsigned NO PRI 0
SpellID smallint(6) unsigned NO PRI 0
IfNoSpell smallint(6) unsigned NO 0


Description of the fields

entry

The entry of the spell that the player learns, either from a trainer or from anywhere else (.learn for example).

SpellID

The entry of the spell that will be automatically learned by the player when the player learns the spell specified in entry.

IfNoSpell

This field acts as a check. Again this field holds spell IDs. If a player has the spell in this field already learned, then it will NOT automatically learn the spell in SpellID. For example hunters learn Auto-shot while warriors and rogues learn regular shoot; so if we put the spell ID of Auto-shot in here (75), then hunters will not automatically learn Shoot (because they already know the Auto-shot spell) when they are taught a ranged weapon skill.

Personal tools