trainer_properties
This table defines which creature can train. (Link from creature entry to spell templates)
Structure
| Field | Type | Default | Comment |
|---|---|---|---|
| entry | int(11) | 0 | |
| build | int(11) | 0 | |
| required_skill | int(11) | 0 | |
| required_skillvalue | int(11) | 0 | |
| req_class | int(11) | 0 | |
| RequiredRace | int(11) | 0 | |
| RequiredReputation | int(11) | 0 | |
| RequiredReputationValue | int(11) | 0 | |
| trainer_type | int(11) | 0 | |
| trainer_ui_window_message | text | 0 | |
| can_train_gossip_textid | int(11) | 0 | |
| cannot_train_gossip_textid | int | NULL | |
| spellset_id | int | 0 | |
| can_train_max_level | int | 0 | |
| can_train_min_skill_value | int | 0 | |
| can_train_max_skill_value | int | 0 | |
| comment | varchar | ’’ |
entry
The creature entry ID from creature_properties table.
build
The build the row applies from. A creature keeps one row for all builds; a further row for a later build is only needed where one of the other columns changes. The spells of a build live in trainer_properties_spellset.
required_skill
The required skill ID. (always 0)
required_skillvalue
The tequired value of skill linked to required_skill. (always 0)
req_class
Required class.
RequiredRace
Required race. (always 0)
RequiredReputation
ID of faction that certain standing with it is required. (always 0)
RequiredReputationValue
Amount of reputation required to train. (always 0)
42000 - Exalted
trainer_type
0 = class trainer 1 = riding trainer 2 = profession trainer
(we have creature flags for this?)
trainer_ui_window_message
The message Text for the trainer window.
can_train_gossip_textid
The TextID shown if trainer can train this spell from npc_gossip_texts table.
cannot_train_gossip_textid
The TextID shown if trainer can not train this spell from npc_gossip_texts table.
spellset_id
ID to the spellset defined in trainer_properties_spellset table. The same id over all builds of the creature, the rows of the set carry the build ranges.
can_train_max_level
Defines which level of spell can be trained. 0 = all levels in the spellset. trainer_properties_spellset
can_train_min_skill_value
Defines which skill value of spell can be trained. 0 = no minimum skill values in the spellset. trainer_properties_spellset
can_train_max_skill_value
Defines which skill value of spell can be trained. 0 = no maximum skill values in the spellset. trainer_properties_spellset
comment
Internal comment for database devs.
under development
This table is not in production.