Github Discord Change this page

trainer_properties

This table defines which creature can train. (Link from creature entry to spell templates)

Structure

Field	Type	Default
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
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	’’

The creature entry ID from creature_properties table.

The build number the trainer was introduced to the game.

The required skill ID. (always 0)

The tequired value of skill linked to required_skill. (always 0)

Required class.

Required race. (always 0)

ID of faction that certain standing with it is required. (always 0)

Amount of reputation required to train. (always 0)

42000 - Exalted

0 = class trainer 1 = riding trainer 2 = profession trainer

(we have creature flags for this?)

The message Text for the trainer window.

The TextID shown if trainer can train this spell from npc_gossip_textid table.

The TextID shown if trainer can not train this spell from npc_gossip_textid table.

ID to the spellset defined in trainer_properties_spellset table.

Defines which level of spell can be trained. 0 = all levels in the spellset. trainer_properties_spellset

Defines which skill value of spell can be trained. 0 = no minimum skill values in the spellset. trainer_properties_spellset

Defines which skill value of spell can be trained. 0 = no maximum skill values in the spellset. trainer_properties_spellset

Internal comment for database devs.

This table is not in production.