This table contains all the spells that each trainer can teach.
表结构
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
---|---|---|---|---|---|---|---|
ID | MEDIUMINT | UNSIGNED | PRI | NO | 0 | ||
SpellID | MEDIUMINT | SIGNED | PRI | NO | 0 | ||
MoneyCost | INT | UNSIGNED | NO | 0 | |||
ReqSkillLine | SMALLINT | UNSIGNED | NO | 0 | |||
ReqSkillRank | SMALLINT | UNSIGNED | NO | 0 | |||
ReqLevel | TINYINT | UNSIGNED | NO | 0 |
Usually, this would be an entry of a creature referring to creature_template.entry.
The spell ID from Spell.dbc. If the ID is negative, it's a reference pointing to the positive value of ID.
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.
The required skill the player needs to have in order to be able to learn the spell. See ID in SkillLine.dbc.
The proficiency in the skill from reqskill that the player needs to meet in order to learn the spell.
The level the player needs to be in order to learn the spell.