Trainers Broken?

[EmuX]

Hey gues my trainers arnt working, so I downloaded the newest NCDB and put the trainer_spells and trainer_defs and put it into my server, and they still don't work, I get some weird major error thing when the server starts. Anyone got some SQL updates that will fix this?


+rep who ever can.

[livingbones]

Hey

Run this query

DELETE FROM trainer_spells WHERE entry NOT IN (SELECT entry FROM trainer_defs WHERE 1=1);
DELETE FROM trainer_defs WHERE entry NOT IN (SELECT entry FROM trainer_spells WHERE 1=1);

[EmuX]

Tryed that. It still doesn't work. Can you send me your trainer_spells and trainer_defs?

[Corosive720]

I made this mistake.. make sure you haven enough gold when you try to buy the skills :P i was freaking out too when i thought my trainers didnt work then i just added money to my inventory and bam they were there :P Hope this helps.

[Job For a Cowboy]

No, It's a repack that just turned into 2.4 someone has to make the trainers train spells. so you gotta wait =(

[EmuX]

Dam.......

[EmuX]

Anyone able to send me working trainer_spells and trainer_defs.

[livingbones]

delete your current Trainer_defs & Trainer_spells table

then download Filebeam - Free Fast File Hosting

execute that into your DB

Then run

DELETE FROM trainer_spells WHERE entry NOT IN (SELECT entry FROM trainer_defs WHERE 1=1);
DELETE FROM trainer_defs WHERE entry NOT IN (SELECT entry FROM trainer_spells WHERE 1=1);

then it should be fine

[Krilio]

i also have a quite easy fix aswell at this post your free to try it out seems to have qorked for me and others...

http://www.mmowned.com/forums/emulat...de-easy-2.html