The `npc_trainer` table
This table holds all the spells that each trainer can teach.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
mediumint(8) | unsigned | PRI | NO | 0 |
|
| |
mediumint(8) | signed | PRI | NO | 0 |
|
| |
int(10) | unsigned |
| NO | 0 |
|
| |
smallint(5) | unsigned |
| NO | 0 |
|
| |
smallint(5) | unsigned |
| NO | 0 |
|
| |
tinyint(3) | unsigned |
| NO | 0 |
|
|
Description of the fields
entry
The template ID of the creature. See creature_template.entry
333a: Entry can also be used as a reference, Biohazard referenced all the trainers for more information see Reference_list
spell
The spell ID from Spell.dbc
if negative spell then it is a pointer to a reference template
spellcost
The cost that the player needs to pay in order to learn the spell in copper. If you get this information from a data site such as Wowhead, be sure to take into account that they usually post the discounted prices based on friendly to exalted with a given faction.
reqskill
The required skill the player needs to have in order to be able to learn the spell. See ID in SkillLine.dbc)
reqskillvalue
The proficiency in the skill from Npc trainer tc2 that the player needs to meet in order to learn the spell.
reqlevel
The level the player needs to be in order to learn the spell.