trainer

This table contains all the trainer entries.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
Id	int	unsigned	PRI	NO	0
Type	tinyint	unsigned		NO	2
Requirement	int	unsigned		NO	0
Greeting	mediumtext			YES	NULL
VerifiedBuild	int	signed		YES	NULL

 

Description of fields

Id

For trainer, this field signifies a unique trainer ID. It is to this ID that all spells are tied to in trainer_spell.
 

Type

The trainer type dictates the Requirement, if any (0 for no Requirement).

Trainer::Type::Class (0)

• Reqirement: ChrClass ID or 0

  ID	Name		ID	Name
  1	Warrior		6	Death Knight
  2	Paladin		7	Shaman
  3	Hunter		8	Mage
  4	Rogue		9	Warlock
  5	Priest		11	Druid

Trainer::Type::Mount (1)

• Reqirement: ChrRace ID or 0

  ID	Name		ID	Name
  1	Human		2	Orc
  4	Dwarf		16	Undead
  8	Night Elf		32	Tauren
  64	Gnome		128	Troll
  1024	Draenei		512	Blood Elf

Trainer::Type::Tradeskill (2)

• Reqirement: Spell ID or 0
  The player must know this spell to learn from this trainer.

Trainer::Type::Pet (3)

• Requirement: ChrClass ID or 0

  ID	Name		ID	Name
  1	Warrior		6	Death Knight
  2	Paladin		7	Shaman
  3	Hunter		8	Mage
  4	Rogue		9	Warlock
  5	Priest		11	Druid

 

Greeting

This is the text shown, once a trainer window has been opened in the top.

Note: This is not the gossip text.

 

VerifiedBuild

This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.

If value is 0 then it has not been parsed yet.

If value is above 0 then it has been parsed with WDB files from that specific client build.

If value is -1 then it is just a place holder until proper data are found on WDBs.

If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.