Back to 'spelldifficulty_dbc' Return to world Go to 'trainer_locale'
This table contains all the trainer entries.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| Id | int | unsigned | PRI | NO | 0 | ||
| Type | tinyint | unsigned | NO | 2 | |||
| Requirement | mediumint | unsigned | NO | 0 | |||
| Greeting | text | YES | NULL | ||||
| VerifiedBuild | smallint | signed | YES | 0 |
For trainer, this field signifies a unique trainer ID. It is to this ID that all spells are tied to in trainer_spell.
The trainer type dictates the requirement (if any).
Requirement is a ChrClass ID (or 0 for no requirement)
| Requirement | Description |
|---|---|
| 1 | Warrior |
| 2 | Paladin |
| 3 | Hunter |
| 4 | Rogue |
| 5 | Priest |
| 6 | Death Knight |
| 7 | Shaman |
| 8 | Mage |
| 9 | Warlock |
| 11 | Druid |
Requirement is a ChrRace ID (or 0 for no requirement)
| Requirement | Description |
|---|---|
| 1 | Human |
| 2 | Orc |
| 3 | Dwarf |
| 4 | Night Elf |
| 5 | Undead |
| 6 | Tauren |
| 7 | Gnome |
| 8 | Troll |
| 10 | Blood Elf |
| 11 | Draenei |
Requirement is a Spell ID (or 0 for no requirement)
The player must know this spell to learn from this trainer.
This is the text shown, once a trainer window has been opened in the top.
Note: This is not the gossip text.
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.
Back to 'spelldifficulty_dbc' Return to world Go to 'trainer_locale'