[SOLVED] npc_trainer Pre-Defined Spell Template

[Visa]

In `npc_trainer` is where you set spellids for a trainer flag'd NPC to learn.

However there is a pre-defined template of spells used for a specific set of class spells/professions.

http://collab.kpsn.org/display/tc/Trainer+reference

What I need help with is finding where this pre-defined 'template' or 'reference' is located?

I have checked numerous amount of .dbc files but no luck.

If anyone knows whereabouts to edit such a template any help is appreciated!

Thanks

 

[Rochet2]

http://collab.kpsn.org/display/tc/npc_trainer

entry
Usually, this would be an entry of a creature referring to creature_template.entry. However, Biohazard included several trainer lists by refering to their id. For more information, see Reference_list.

References are almost always handled with negative value in TC. (Example: spell = -200001)
The referenced templates are in the same table, but with positive value. (Example: entry = 200001)

This means that you can find all the templates by doing
Select * from npc_trainer WHERE entry >= 200000;

 

[Visa]

Oh jesus I feel retarded. I could've sworn negative values were always defined in like a dbc file or something lol oops thank you though!

 

[Rochet2]

Oh jesus I feel retarded. I could've sworn negative values were always defined in like a dbc file or something lol oops thank you though!

The negative and positive values of quest_template zoneorsort is in DBC, thats true.
But references are internal ( TC side stuff) so they "cant" be in the DBC.