trainer_properties_spells

This table defines the trainable spells for a trainer.

Structure

Field	Type	Default	Comment
id	int(11)	0	Unique Key
min_build	int(11)	0	Unique Key
max_build	int(11)	0
cast_spell	int(11)	0	Unique Key
learn_spell	int(11)	0	Unique Key
spellcost	int(11)	0
reqspell	int(11)	0
reqskill	int(11)	0
reqskillvalue	int(11)	0
reqlevel	int(11)	0
deletespell	int(11)	0
static	int(11)	0

id

The Id for defining a set of spells for a trainer.

min_build

The first build this row is valid to train. A set holds the rows of every build, the server loads the rows whose range contains its build.

max_build

The last build this row is valid to train.

cast_spell

The spell ID which would be cast by the trainer.

learn_spell

The spell ID which would be teached by the trainer.

spellcost

The cost to learn this spell.

reqspell

The spell entry ID which is required to learn the new spell.

reqskill

The required skill entry ID.

reqskillvalue

The required skill value of the required skill.

reqlevel

The required level of the player to learn this spell.

deletespell

The spell entry ID which would be removed.

static

1 = this spell is always visible in this spell set.

under development

This table is not in production.