[RELEASE] trainer fix

NOT MY RELEASE all credits to the guy who posted/made
i think u need 4335 at least and new db

from ascentemu site

Quote:

---

by syntaxbr on Fri Apr 18, 2008 4:51 pm
use this trainer_spells.sql and all problems are soved.

no need patch. i test from Rev 4335 + moomscripts an work perfect.

Aply the lastast patchs in characters and world database before swap trainer_spells from this atachament.

sory my bad english

---

trainer_spells_fix.rar

ive tersted on my server and trainer works perfect
im using 4335 with moon++ and ncdb 23/26

I'll make a compatability check now to check if it works on any older versions/repacks

"Good job." I used it with NCDB23 and before it didnt crash, it showed errors and let me run the server but now it shows errors and closes the server.

Nice i was Wayting for it :)

this ****** my db :)

DO NOT use this fix. Causes an access violation and crashes the server at startup.

Quote:

---

Originally Posted by Carcenagin

DO NOT use this fix. Causes an access violation and crashes the server at startup.

---

Worked for me. Got Build 4330 with NCDB23.

Only a few trainers worked, but after this it seems like all the trainer works.
The bug was that learn_spell and cast_spell data contained the other ones data.

Did however get a few errors on trainers missing spells. So I extracted those trainer spells from my old DB, fixed the learn_spell<-->cast_spell bug.

I assume this fix works with the newest builds. From build 4308.
Check out the DB fix: 4308_world_trainer_spells_learnspell.sql from the svn.

Quote:

---

ALTER TABLE `trainer_spells` ADD `learn_spell` INT( 11 ) UNSIGNED NOT NULL AFTER `cast_spell` ;

---

Error Log:
15:57 E LoadTrainers: Trainer with no spells, entry 16740.
15:57 E LoadTrainers: Trainer with no spells, entry 16741.
15:57 E LoadTrainers: Trainer with no spells, entry 16742.
15:57 E LoadTrainers: Trainer with no spells, entry 16743.
15:57 E LoadTrainers: Trainer with no spells, entry 16745.
15:57 E LoadTrainers: Trainer with no spells, entry 16746.
15:57 E LoadTrainers: Trainer with no spells, entry 24868.
15:57 E LoadTrainers: Trainer with no spells, entry 25099.

Here is a script to insert the missing trainers:

Code:

---

INSERT INTO `trainer_spells` (`entry`, `learn_spell`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) VALUES
('16740','2020','0','10','0','0','0','5','0','1'),
('16740','2743','0','50','0','164','1','0','0','0'),
('16740','2744','0','100','0','164','35','0','0','0'),
('16740','2746','0','280','0','164','65','0','0','0'),
('16740','2747','0','310','0','164','70','0','0','0'),
('16740','2754','0','50','0','164','15','0','0','0'),
('16740','2755','0','100','0','164','20','0','0','0'),
('16740','2756','0','100','0','164','25','0','0','0'),
('16740','3118','0','280','0','164','65','0','0','0'),
('16740','3299','0','100','0','164','35','0','0','0'),
('16740','3300','0','310','0','164','70','0','0','0'),
('16740','3340','0','100','0','164','20','0','0','0'),
('16740','3341','0','100','0','164','25','0','0','0'),
('16740','3342','0','100','0','164','40','0','0','0'),
('16740','3343','0','250','0','164','45','0','0','0'),
('16740','3344','0','320','0','164','75','0','0','0'),
('16740','7409','0','280','0','164','65','0','0','0'),
('16740','8881','0','100','0','164','30','0','0','0'),
('16740','9984','0','100','0','164','30','0','0','0'),
('16741','2275','0','10','0','0','0','5','0','1'),
('16741','2339','0','100','0','171','25','0','0','0'),
('16741','2340','0','100','0','171','40','0','0','0'),
('16741','2341','0','250','0','171','55','0','0','0'),
('16741','3184','0','50','0','171','15','0','0','0'),
('16741','11536','0','225','0','171','50','0','0','0'),
('16742','7414','0','10','0','0','0','5','0','1'),
('16742','7422','0','50','0','333','15','0','0','0'),
('16742','7441','0','100','0','333','40','0','0','0'),
('16742','7459','0','250','0','333','50','0','0','0'),
('16742','7749','0','250','0','333','60','0','0','0'),
('16742','7772','0','200','0','333','70','0','0','0'),
('16742','13373','0','100','0','333','40','0','0','0'),
('16742','14805','0','50','0','333','10','0','0','0'),
('16742','14808','0','200','0','333','70','0','0','0'),
('16743','3984','0','115','0','202','30','0','0','0'),
('16743','3985','0','130','0','202','30','0','0','0'),
('16743','3986','0','150','0','202','50','0','0','0'),
('16743','3987','0','150','0','202','50','0','0','0'),
('16743','3988','0','200','0','202','60','0','0','0'),
('16743','3991','0','225','0','202','65','0','0','0'),
('16743','3992','0','250','0','202','75','0','0','0'),
('16743','3993','0','250','0','202','75','0','0','0'),
('16743','3994','0','250','0','202','75','0','0','0'),
('16743','4039','0','10','0','0','0','5','0','1'),
('16743','7431','0','150','0','202','50','0','0','0'),
('16744','25245','0','10','0','0','0','5','0','1'),
('16744','25326','0','100','0','755','30','0','0','0'),
('16744','25327','0','400','0','755','60','0','0','0'),
('16744','25330','0','400','0','755','70','0','0','0'),
('16744','25491','0','200','0','755','50','0','0','0'),
('16744','25492','0','300','0','755','50','0','0','0'),
('16744','25647','0','200','0','755','50','0','0','0'),
('16744','26929','0','50','0','755','20','0','0','0'),
('16744','26930','0','300','0','755','50','0','0','0'),
('16744','26931','0','100','0','755','30','0','0','0'),
('16744','32177','0','100','0','755','20','0','0','0'),
('16744','32180','0','100','0','755','20','0','0','0'),
('16744','32181','0','100','0','755','20','0','0','0'),
('16744','32821','0','200','0','755','50','0','0','0'),
('16745','2155','0','10','0','0','0','5','0','1'),
('16745','2177','0','100','0','165','55','0','0','0'),
('16745','2178','0','100','0','165','60','0','0','0'),
('16745','2338','0','50','0','165','15','0','0','0'),
('16745','2883','0','100','0','165','40','0','0','0'),
('16745','3782','0','75','0','165','25','0','0','0'),
('16745','3784','0','150','0','165','55','0','0','0'),
('16745','3786','0','200','0','165','75','0','0','0'),
('16745','3821','0','50','0','165','35','0','0','0'),
('16745','9061','0','100','0','165','30','0','0','0'),
('16745','9063','0','100','0','165','30','0','0','0'),
('16745','9066','0','150','0','165','70','0','0','0'),
('16746','2414','0','120','0','197','40','0','0','0'),
('16746','2415','0','25','0','197','1','0','0','0'),
('16746','2416','0','120','0','197','40','0','0','0'),
('16746','2417','0','220','0','197','70','0','0','0'),
('16746','2418','0','220','0','197','70','0','0','0'),
('16746','2419','0','150','0','197','60','0','0','0'),
('16746','2423','0','250','0','197','75','0','0','0'),
('16746','2966','0','100','0','197','75','0','0','0'),
('16746','2967','0','200','0','197','65','0','0','0'),
('16746','2996','0','50','0','197','10','0','0','0'),
('16746','3783','0','120','0','197','45','0','0','0'),
('16746','3876','0','110','0','197','35','0','0','0'),
('16746','3877','0','150','0','197','60','0','0','0'),
('16746','3878','0','220','0','197','70','0','0','0'),
('16746','3911','0','10','0','0','0','5','0','1'),
('16746','3916','0','100','0','197','30','0','0','0'),
('16746','3917','0','25','0','197','1','0','0','0'),
('16746','7626','0','100','0','197','30','0','0','0'),
('16746','7627','0','100','0','197','30','0','0','0'),
('16746','8466','0','120','0','197','40','0','0','0'),
('16746','8777','0','50','0','197','15','0','0','0'),
('16746','12118','0','30','0','197','1','0','0','0'),
('16746','12119','0','50','0','197','20','0','0','0'),
('16746','12120','0','300','0','197','75','0','0','0'),
('24868','44154','0','120000','0','202','350','70','0','0'),
('24868','44158','0','180000','0','202','375','70','0','0'),
('25099','44154','0','120000','0','202','350','70','0','0'),
('25099','44158','0','180000','0','202','375','70','0','0');

---

i also got a problem! can somebody help

MySQL Command Line Client

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe: Character set 'macroman' is not a compiled character set and is not specified in the

I used the fix, but it still crashes my server on start-up, any ideas?

nice job, it works perfectly, 3 days 14 hours no crash with 70+ players :)