Spell learn spell
From UDB
|
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.

