Npc trainer

From OregonCore Wiki
Jump to: navigation, search

Back to world database list of tables.


The `npc_trainer` table

This table holds all the spells that each trainer can teach.

Schema Last Modified: TC1-1828 - Schema Verified: Rev 665


Structure

Field Type Attributes Key Null Default Extra Comment
entry mediumint(8) unsigned PRI NO 0
spell mediumint(8) unsigned PRI NO 0
spellcost int(10) unsigned NO 0
reqskill smallint(5) unsigned NO 0
reqskillvalue smallint(5) unsigned NO 0
reqlevel tinyint(3) unsigned NO 0


Description of the fields

entry

The template ID of the creature. See creature_template.entry

spell

The learning spell ID.

spellcost

The cost that the player needs to pay in order to learn the spell.

reqskill

The required skill the player needs to have in order to be able to learn the spell. See ID in SkillLine.dbc

reqskillvalue

The proficiency in the skill from reqskill that the player needs to meet in order to learn the spell.

reqlevel

The level the player needs to be in order to learn the spell.