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).

Tabset

Type::Class (0)

Trainer::Type::ClassChrClass ID or 0

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

Type::Mount (1)

Trainer::Type::MountChrRace ID or 0

Requirement	Description
1	Human
2	Orc
3	Dwarf
4	Night Elf
5	Undead
6	Tauren
7	Gnome
8	Troll
10	Blood Elf
11	Draenei

Type::Tradeskill (2)

Trainer::Type::TradeskillSpell ID or 0

The player must know this spell to learn from this trainer.

Type::Pet (3)

Trainer::Type::PetChrClass ID or 0

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

EndTabset

 

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.