“npc_trainer_template” table

The npc_trainer_template table holds holds spell lists usable for multiple training creatures.

Table structure

Field Type Null Key Default Extra
entry mediumint(8) unsigned NO PRI 0  
spell mediumint(8) unsigned NO PRI 0  
spellcost int(10) unsigned NO   0  
reqskill smallint(5) unsigned NO   0  
reqskillvalue smallint(5) unsigned NO   0  
reqlevel tinyint(3) unsigned NO   0  

Fields

entry

The unique identifier for the training template. A “creature_template” table references this from its trainer_id column.

spell

The spell identifier. The value has to match with a spell identifier defined in Spell.dbc. This has to be a spell which teaches the actual spell.

spellcost

The cost that the player needs to pay in order to learn the spell in copper.

reqskill

The required skill to be able to learn the spell. This references the skill’s entry in the SkillLine.dbc table.

reqskillvalue

The minimum skill level required for the skill referenced in reqskill.

reqlevel

The character level required in order to learn the spell.