Cheapgamer at 06:23, 6 July 2012

2012-07-06T06:23:02Z

← Older revision		Revision as of 01:23, 6 July 2012
Line 153:		Line 153:
	====entry====		====entry====

	The template ID of the creature. See [[~~creature_template_tc2~~#entry\|creature_template.entry]]		The template ID of the creature. See [[creature_template_SF#entry\|creature_template.entry]]


Line 172:		Line 172:


	The required skill the player needs to have in order to be able to learn the spell. See ID in [[SkillLine.dbc ~~tc2~~\|SkillLine.dbc]])		The required skill the player needs to have in order to be able to learn the spell. See ID in [[SkillLine.dbc SF\|SkillLine.dbc]])

Marqin at 21:00, 4 September 2011

2011-09-04T21:00:50Z

← Older revision		Revision as of 16:00, 4 September 2011
Line 5:		Line 5:
	\|}		\|}

	[[Category: ~~TrinityCore2~~ World database tables]]		[[Category: SkyFire World database tables]]

	{{Back-to:World}}		{{Back-to:World}}

Marqin: moved from old wiki

2011-09-03T19:40:59Z

moved from old wiki

New page

{| align="right"

| __TOC__

|}

[[Category: TrinityCore2 World database tables]]

{{Back-to:World}}

<big>'''The `npc_trainer` table'''</big>

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

<big>'''Structure'''</big>

{| border="1"

|'''Field'''

|'''Type'''

|'''Attributes'''

|'''Key'''

|'''Null'''

|'''Default'''

|'''Extra'''

|'''Comment'''

|-

|[[#entry|entry]]

|mediumint(8)

|unsigned

|PRI

|NO

|0

|

|

|-

|[[#spell|spell]]

|mediumint(8)

|signed

|PRI

|NO

|0

|

|

|-

|[[#spellcost|spellcost]]

|int(10)

|unsigned

|

|NO

|0

|

|

|-

|[[#reqskill|reqskill]]

|smallint(5)

|unsigned

|

|NO

|0

|

|

|-

|[[#reqskillvalue|reqskillvalue]]

|smallint(5)

|unsigned

|

|NO

|0

|

|

|-

|[[#reqlevel|reqlevel]]

|tinyint(3)

|unsigned

|

|NO

|0

|

|

|}

<big>'''Description of the fields'''</big>

====entry====

The template ID of the creature. See [[creature_template_tc2#entry|creature_template.entry]]

333a: Entry can also be used as a reference, Biohazard referenced all the trainers for more information see [[Trainer_reference_tdb|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 tc2|SkillLine.dbc]])

====reqskillvalue====

The proficiency in the skill from [[#reqskill|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.

Npc trainer SF - Revision history

Cheapgamer at 06:23, 6 July 2012

Marqin at 21:00, 4 September 2011

Marqin: moved from old wiki