Npc trainer SF

From Project Skyfire
Revision as of 14:40, 3 September 2011 by Marqin (talk | contribs) (moved from old wiki)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Back to world database list of tables.


The `npc_trainer` table


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


Structure

Field Type Attributes Key Null Default Extra Comment
entry mediumint(8) unsigned PRI NO 0
spell mediumint(8) signed 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


333a: Entry can also be used as a reference, Biohazard referenced all the trainers for more information see Reference_list


spell

The spell ID from Spell.dbc


spellcost

The cost that the player needs to pay in order to learn the spell in copper. If you get this information from a data site such as Wowhead, be sure to take into account that they usually post the discounted prices based on friendly to exalted with a given faction.


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.