[Question] Spell Cost Trainer

[Strupantwn]

What is the Query to remove all Spell Cost from the trainers in the DB
in table " trainer_spells "

[Power of Illuminati]

UPDATE trainer_spells SET spellcost = '0';

[marcojoao]

Hey and can i add new spells? =)

[orion5814]

Yes, just put the trainer id that you want to train the spell and the spell ID, however some spell ID's don't always work . I got 5 (Deathtouch) to work, but I can't seem to get my custom spells to work, however the random leatherworking spell I put into my GM trainer on accident works, yay?

[Power of Illuminati]

You can't add any... random spell as they checking what tab the spell is in. You can't for example put a warrior spell in the mage trainer, no mage would see the warrior spell as they don't have the right tab.

Why deathtouch worked, is beacuse that is a GM spell and has a own tab.