Add new Edit Delete History Source

Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.

npc_trainer

<-Back-to:World

The `npc_trainer` table

This table contains all the spells that each trainer can teach.

Table Structure

Field	Type	Attributes	Key	Null
ID	MEDIUMINT	UNSIGNED	PRI	NO
SpellID	MEDIUMINT	SIGNED	PRI	NO
MoneyCost	INT	UNSIGNED		NO
ReqSkillLine	SMALLINT	UNSIGNED		NO
ReqSkillRank	SMALLINT	UNSIGNED		NO
ReqLevel	TINYINT	UNSIGNED		NO

Description of the fields

ID

Usually, this would be an entry of a creature referring to creature_template.entry.

SpellID

The spell ID is from Spell.dbc. If the ID is negative, it's a reference pointing to the positive value of the ID.

MoneyCost

The price that the player needs to pay to learn the spell in copper. If you get this information from a data site such as Wowhead, consider that they usually post discounted prices based on friendly to exalted with a given faction.'

(1 gold = 100 silver = 10000 cooper).

ReqSkillLine

The required skill the player needs to have to be able to learn the spell. See ID in SkillLine.dbc.

ReqSkillRank

The proficiency in the skill from reqskill that the player needs to meet to learn the spell.

ReqLevel

The level the player needs to be to learn the spell.