Well this is a very short guide, but helpful. I've had problems with trainers and can be kind of frustrating when you install your new db and trainers don't work :banghead:.
1.Download this file and execute the sql query:
Run Me First.sql - 2.4 Mb
DOWNLOAD NOW!
2.Then open a notepad copy and paste this query and save it as all files and execute into your db:
Code:
ALTER TABLE `trainer_spells` change `cast_spell` `learn_spell` int(10);
ALTER TABLE `trainer_spells` ADD column `cast_spell` int(11) UNSIGNED NOT NULL after `entry`;
Your trainers should be working now. Good luck
Advice: always make back up's of your db before you make changes to it, im not reponsible for any loss or else, for not using this the proper way and with an up to date db.
Note:
This will NOT fix custom trainers you find on a repack. This is meant for db's like it was NCDB and so on. 2.4.x updated Blizzlike db's that don't have the tables altered (that don't have custom trainers to be more specific).
If the trainers are not working on the repack you got, you probably did something wrong, or you didn't run an update provided with the repack or the ascent core you are using is not compatible with the tables of the db you are using or maybe the tables are screwed(which i don't think so).
Read your repack instruction's first. READ, READ. When you Read things, you less likely have chances of doing things wrong.
If this is not the case. what you can do is this. Fix the default trainers first by using this queries i provided, then when the default ones are working you can go ahead and make your custom ones.