[Guide] Add missing or custom spells to trainer

[bulletzaredeadly]

Hi all. In this guide i will tell you all how to add spells to a trainer. This is very useful for hunters-tame beast, and druid shapeshift forms.

1) Do .npc info on your vendor and write down or remember the entry id.

2) Go to navicat and go to your world database. Go into the table called trainer_spells.


3) Find your vendors entry id in there and add new line by pushing the small + sign on the bottom of the navicat screen.

4) Go to www.wowhead.com and search the spell you want. Get the spell ID


5) Under the new line you made in trainer_spells,

-under the column entry, put the vendors entry id.


-leave cast spell blank.

-under learn_spell put your spell id.


-under spellcost put the amount of gold if any you want your spell to cost


-under req_skill and req_spell put the required skill or spell if you want, otherwise leave blank.


-under req_level put the required level to learn your spell.


-under reqskillvalue put the level of skill you need to get the spell- usually 0 unless profession


-under deletespell put the spell it deletes from you(if any). (such as when you get dire bear form it deletes bear form)


-leave is_profblank unless its a profession. profession = 1


restart your server and your trainer will have the spells you added!

hope this helped alot of people!

reply if you need help with something!

[Appled]

Nice one rep

[bulletzaredeadly]

thank you. actually taught this to myself and tested this my self for my actual server haha.

[dude45342]

Very nice! I always thought you did this in-game, so this helps me a bit. Thanks!

[bulletzaredeadly]

Yes you used to be able to do it in game. It has been bugged for a while now. Not sure if it has been fixed or not.

[dragonowner]

Good Guide it will help out the newbies. +Rep.

[Sounddead]

Nice guide.

[chaoticd35]

Nice guide! 2 +Rep

[kevhed]

nice, this helped me on a few missing spells thanks