[Ascent Rev2527]-[NCDB Rev700] Class spell fixes for whom needed.

[yanivkalfa]

well here i am gonna post fixes i have made to the Data base bugs (warrios doesnt start with all his stances druid with his forms warlock with his pets mages with portal trains and so on).
i will post here what i have fixed so far:

[COLOR="DarkOrange"][B]warrior fixes[/B][/COLOR]
trainers skills fixes:
---------------------------------------------------
UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '5113' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '5113' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '5113' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('5113','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('5113','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '17120' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '17120' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '17120' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('17120','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('17120','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '16771' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '16771' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '16771' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('16771','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('16771','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '17504' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '17504' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '17504' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('17504','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('17504','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '4087' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '4087' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '4087' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('4087','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('4087','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '7315' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '7315' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '7315' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('7315','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('7315','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '5479' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '5479' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '5479' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('5479','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('5479','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '5480' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '5480' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '5480' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('5480','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('5480','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '914' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '914' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '914' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('914','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('914','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '3353' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '3353' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '3353' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('3353','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('3353','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '3354' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '3354' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '3354' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('3354','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('3354','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '3408' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '3408' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '3408' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('3408','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('3408','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '3043' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '3043' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '3043' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('3043','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('3043','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '3041' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '3041' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '3041' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('3041','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('3041','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '3042' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '3042' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '3042' and cast_spell = '33368';
UPDATE trainer_spells
SET spellcost = '60000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '3042' and cast_spell = '30068';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('3042','3196','3000','0','0','10','0','0','0');

UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '4593' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '4593' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '4593' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('4593','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('4593','3196','3000','0','0','10','0','0','0');


UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '4595' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '4595' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '4595' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('4595','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('4595','3196','3000','0','0','10','0','0','0');


UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '48', deletespell = '0', is_prof = '0'
WHERE entry = '4594' and cast_spell = '21555';
UPDATE trainer_spells
SET spellcost = '50000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '60', deletespell = '0', is_prof = '0'
WHERE entry = '4594' and cast_spell = '30067';
UPDATE trainer_spells
SET reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '70', deletespell = '0', is_prof = '0'
WHERE entry = '4594' and cast_spell = '33368';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('4594','30068','60000','0','0','0','70','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) 
values('4594','3196','3000','0','0','10','0','0','0');
---------------------------------------------------

on start skills
---------------------------------------------------
INSERT INTO `playercreateinfo_spells` VALUES('1','71');
INSERT INTO `playercreateinfo_spells` VALUES('1','23922');
INSERT INTO `playercreateinfo_spells` VALUES('1','2458');
INSERT INTO `playercreateinfo_spells` VALUES('1','20252');
INSERT INTO `playercreateinfo_spells` VALUES('2','71');
INSERT INTO `playercreateinfo_spells` VALUES('2','23922');
INSERT INTO `playercreateinfo_spells` VALUES('2','2458');
INSERT INTO `playercreateinfo_spells` VALUES('2','20252');
INSERT INTO `playercreateinfo_spells` VALUES('3','71');
INSERT INTO `playercreateinfo_spells` VALUES('3','23922');
INSERT INTO `playercreateinfo_spells` VALUES('3','2458');
INSERT INTO `playercreateinfo_spells` VALUES('3','20252');
INSERT INTO `playercreateinfo_spells` VALUES('4','71');
INSERT INTO `playercreateinfo_spells` VALUES('4','23922');
INSERT INTO `playercreateinfo_spells` VALUES('4','2458');
INSERT INTO `playercreateinfo_spells` VALUES('4','20252');
INSERT INTO `playercreateinfo_spells` VALUES('5','71');
INSERT INTO `playercreateinfo_spells` VALUES('5','23922');
INSERT INTO `playercreateinfo_spells` VALUES('5','2458');
INSERT INTO `playercreateinfo_spells` VALUES('5','20252');
INSERT INTO `playercreateinfo_spells` VALUES('6','71');
INSERT INTO `playercreateinfo_spells` VALUES('6','23922');
INSERT INTO `playercreateinfo_spells` VALUES('6','2458');
INSERT INTO `playercreateinfo_spells` VALUES('6','20252');
INSERT INTO `playercreateinfo_spells` VALUES('7','71');
INSERT INTO `playercreateinfo_spells` VALUES('7','23922');
INSERT INTO `playercreateinfo_spells` VALUES('7','2458');
INSERT INTO `playercreateinfo_spells` VALUES('7','20252');
INSERT INTO `playercreateinfo_spells` VALUES('8','71');
INSERT INTO `playercreateinfo_spells` VALUES('8','23922');
INSERT INTO `playercreateinfo_spells` VALUES('8','2458');
INSERT INTO `playercreateinfo_spells` VALUES('8','20252');
INSERT INTO `playercreateinfo_spells` VALUES('44','71');
INSERT INTO `playercreateinfo_spells` VALUES('44','23922');
INSERT INTO `playercreateinfo_spells` VALUES('44','2458');
INSERT INTO `playercreateinfo_spells` VALUES('44','20252');
INSERT INTO `playercreateinfo_spells` VALUES('56','71');
INSERT INTO `playercreateinfo_spells` VALUES('56','23922');
INSERT INTO `playercreateinfo_spells` VALUES('56','2458');
INSERT INTO `playercreateinfo_spells` VALUES('56','20252');
---------------------------------------------------
[COLOR="DarkOrange"][B]this are all warrior fixes[/B][/COLOR]

just execute this onto your data base and you have you warrior problems fixed.

 

[francosa]

Works perfect!
Thank you.

 

[yanivkalfa]

well you gonna need to re enter al the trainer spell fixes couse the first one was only for Ironforge trainers the new list is for all trainers

 

[Mikylol]

plz if you could do one for druids forms and locks pets if possible

 

[yanivkalfa]

Mage fixes - alliances
trainers skills:
---------------------------------------------------
insert into `trainer_defs` (`entry`, `required_skill`, `required_skillvalue`, `req_class`, `trainer_type`, `trainer_ui_window_message`, `can_train_gossip_textid`, `cannot_train_gossip_textid`)
values('16755','0','0','0','2','Hi $N, how can I help you?','0','0');

---------------------------------------------------
thats all for mages.
---------------------------------------------------

pala fixes - alliances
trainers skills:
---------------------------------------------------
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('928','7329','90','0','0','0','12','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5492','7329','90','0','0','0','12','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5491','7329','90','0','0','0','12','0','0');

insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5147','7329','90','0','0','0','12','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5149','7329','90','0','0','0','12','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5148','7329','90','0','0','0','12','0','0');

insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('17509','7329','90','0','0','0','12','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('16761','7329','90','0','0','0','12','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('17121','7329','90','0','0','0','12','0','0');

---------------------------------------------------
thats all for pala.
---------------------------------------------------

rogue fixes - alliances
trainers skills:
---------------------------------------------------
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('13283','8700','120','0','0','0','20','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('918','8700','120','0','0','0','20','0','0');

insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5167','8700','120','0','0','0','20','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5166','8700','120','0','0','0','20','0','0');
UPDATE trainer_spells
SET spellcost = '42000', reqspell = '0', reqskill = '0', reqskillvalue = '0', reqlevel = '20', deletespell = '0', is_prof = '0'
WHERE entry = '5167' and cast_spell = '8700';
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5167','8700','120','0','0','0','20','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5165','8700','120','0','0','0','20','0','0');

insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('4163','8700','120','0','0','0','20','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('4215','8700','120','0','0','0','20','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('4214','8700','120','0','0','0','20','0','0');

---------------------------------------------------
thats all for rogue.
---------------------------------------------------

priest fixes - alliances
trainers skills:
---------------------------------------------------
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('376','19338','20','0','0','0','10','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5489','19338','20','0','0','0','10','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5484','19338','20','0','0','0','10','0','0');

insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5143','19338','20','0','0','0','10','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5142','19338','20','0','0','0','10','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('11406','19338','20','0','0','0','10','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('5141','19338','20','0','0','0','10','0','0');

insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('4091','19338','20','0','0','0','10','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('4092','19338','20','0','0','0','10','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('11401','19338','20','0','0','0','10','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('4090','19338','20','0','0','0','10','0','0');

insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('17510','19338','20','0','0','0','10','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('17511','19338','20','0','0','0','10','0','0');
insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`)
values('16756','19338','20','0','0','0','10','0','0');
---------------------------------------------------
thats all for priest.
---------------------------------------------------

will do Warlock/Hunter/Druids/Shammans laters todays and will finsh the hord side as well

 

[Mikylol]

Thanks man keep up the good work ^^

 

[Paco44]

NCDB needs to do this, give them the suggestion of putting these in.

 

[yanivkalfa]

well i thinks they dont give this purpsly couse they want it to be a bit buggy so people learn how to work with the data bases for harder cases. but who knows .

 

[Germo]

This is good mojo :flag_schw Nice work. Keep up the good work

Germo

I found a tiny little thing that needs to be fixed with the warrior class . Itsl warriors made from Alliance, all races have all 3 battle icons, but human only gets 2. Battle stance and Berserker stance, rest of the races get all 3. Maybe you could look into this, if you have the time, maybe repost a fix for it

Germo

 

[yanivkalfa]

will do

 

[Recklezz]

lol these Files suck xD they dun even work... ( YES I KNOW HOW TO USE THEM)


..well gl

 

[yanivkalfa]

yes they work to the correct revision of the data base it will only work good for rev700 so dont be noob and check

 

[aavaria]

Hey great work !

Possible to post the other fixes so I can complie everything into one database fix

 

[Paco44]

He probably hasn't made the other fixes yet.

 

[aavaria]

*** bump to possible kept update

 

[aavaria]

bump