Re: [RELEASE] trainer fix
I'll make a compatability check now to check if it works on any older versions/repacks
Re: [RELEASE] trainer fix
"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.
Re: [RELEASE] trainer fix
Nice i was Wayting for it :)
Re: [RELEASE] trainer fix
Re: [RELEASE] trainer fix
DO NOT use this fix. Causes an access violation and crashes the server at startup.
Re: [RELEASE] trainer fix
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');
Re: [RELEASE] trainer fix
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
Re: [RELEASE] trainer fix
I used the fix, but it still crashes my server on start-up, any ideas?
Re: [RELEASE] trainer fix
nice job, it works perfectly, 3 days 14 hours no crash with 70+ players :)