trainer_spells

This table defines the important facts to learn a spell.

Structure

Field Type Default Comment
entry int(11) 0  
cast_spell int(11) 0  
learn_spell int(11) 0  
spellcost int(11) 0  
reqspell int(11) 0  
reqskill int(11) 0  
reqskillvalue int(11) 0  
reqlevel int(11) 0  
deletespell int(11) 0  

entry

The creature entry ID from creature_properties table.

cast_spell

The spell ID which would be cast by the trainer.

learn_spell

The spell ID which would be teached by the trainer.

spellcost

The cost to learn this spell.

reqspell

The spell entry ID which is required to learn the new spell.

reqskill

The required skill entry ID.

reqskillvalue

The required skill value of the required skill.

reqlevel

The required level of the player to learn this spell.

deletespell

The spell entry ID which would be removed.