Free Trainer Spells

[kaotik]

Here is an sql to very easily make all spells that are given by any trainer free. Be careful though be cause this make all class, profession, and pet trainer spells free.

[color="DeepSkyBlue"]ALTER TABLE[/color] npc_trainer [color="DeepSkyBlue"]DROP COLUMN[/color] spellcost; 
[color="DeepSkyBlue"]ALTER TABLE[/color] npc_trainer [color="DeepSkyBlue"]ADD[/color] spellcost [color="DeepSkyBlue"]VARCHAR[/color][color="DarkRed"](60)[/color] [color="DeepSkyBlue"]AFTER[/color] spell;

[Diablox]

Whats wrong with

UPDATE `npc_trainer` SET `spellcost` = 0;

[kaotik]

That works too