How to set training costs to zero :)

[metehan]

1.Open up what ever DB editor you got (Navicat HeidiSQL) enter your world DB (often called "Ascent" or "World")
2.Then open the table trainer_spells.
Edit: Here is a pic of me using navicat to help you find the right table

3.Go to the column that says spellcost. There will be some numbers in this column that show, how much it costs to train this spell. A "1" in this column will mean the spell costs 1 copper. So a 10,000 in this column will mean it will cost 10,000 copper or 1 gold.
4. In the column called "entry" that will show you what spell is in that row. To find a spell just search it up on thottbot then look at the URL of the page the spell is on and find the last 4 or 5 numbers and that will be your "entry". Example: Hamstring is the link to hamstring rank 1. Find the row that has that number as the entry. Go to spellcost column and set it to 0. Bam! Its free to train hamstring rank one .
Edit: Pic to help you find the spell ID easier.

5. You can set the spells to custom prices if you want. Just get how much gold you want it to cost * 10000 and enter that into the spellcost column of its entry ID.
6. If you all training to be free. Change all the values in that column to 0 or run this query.
Take a backup before running this query!!

UPDATE trainer_spells SET spellcost=0 where spellcost >0

Hope it was easy to understand!

[Meef]

Great Post, helped me alot. If I could give REP, I would!

[Lich King]

Nice guide, maybe you could post some pics?

[metehan]

Updated with pics!

[Lich King]

Nice, much better +Rep