blob: 0e5d7145e162c729b9050cafc3b86c9db607266d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
# npc\_trainer
[<-Back-to:World](database-world.md)
**The \`npc\_trainer\` table**
This table contains all the spells that each trainer can teach.
**Structure**
| | | | | | | | |
|--------------------------------------------|--------------|----------------|---------|----------|-------------|-----------|-------------|
| **Field** | **Type** | **Attributes** | **Key** | **Null** | **Default** | **Extra** | **Comment** |
| [ID](#npc_trainer-entry) | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | |
| [SpellID](#npc_trainer-spell) | MEDIUMINT | SIGNED | PRI | NO | 0 | | |
| [MoneyCost](#npc_trainer-spellcost) | INT | UNSIGNED | | NO | 0 | | |
| [ReqSkillLine](#npc_trainer-reqskill) | SMALLINT | UNSIGNED | | NO | 0 | | |
| [ReqSkillRank](#npc_trainer-reqskillvalue) | SMALLINT | UNSIGNED | | NO | 0 | | |
| [ReqLevel](#npc_trainer-reqlevel) | TINYINT | UNSIGNED | | NO | 0 | | |
**Description of the fields**
### ID
Usually, this would be an entry of a creature referring to [creature\_template.entry](creature_template#creature_template-entry).
### SpellID
The spell ID from [Spell.dbc](Spell). If the ID is negative, it's a reference pointing to the positive value of ID.
### MoneyCost
The cost that the player needs to pay in order to learn the spell in copper (1 gold = 100 silver = 10000 cooper). 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.
### ReqSkillLine
The required skill the player needs to have in order to be able to learn the spell. See ID in SkillLine.dbc.
### ReqSkillRank
The proficiency in the skill from [reqskill](#npc_trainer-reqskill) 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.
|
