Need help - Class spells!

[cryzie]

Hello everyone!
I really need someones help now, I've been trying to search it everywhere but i cant find it..

- How do i change the cost on Class spells to free? . So a new player without money, can learn all hes spells?

[Harambeqt]

This query will erase the cost on ALL spells. Not just class spells.

UPDATE trainer_spells SET spellcost = 0;

This could work, make backups b4.

UPDATE    trainer_spells 
JOIN    creature_proto
SET    trainer_spells.spellcost=0
WHERE    npc_vendor.npcflags = 32;