Class trainers updated for wotlk (mangos) Here is the Horde updated trainer for the new class spells for Wotlk. i'm going to keep adding the classes new Abilities ranks asap when i get them coded.
change their faction ID to make them for both Ailli and Horde the ID is 994 b/c the trainer will kill the Alli people =P
this is for the New Trained Abilities
insert in the database =D Code: INSERT INTO `npc_trainer` VALUES ('5882', '44745', '38000', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('5882', '44614', '38000', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('5882', '47610', '38000', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('3406', '53351', '38000', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('3406', '53309', '38000', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('12042', '52610', '38000', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('12042', '50464', '38000', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('12042', '50763', '38000', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('20406', '53601', '38000', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('20406', '53600', '38000', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('20406', '53736', '38000', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('20406', '53720', '38000', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('4593', '46870', '38000', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('4593', '47297', '38000', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('3325', '48018', '38000', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('3325', '48020', '38000', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('3325', '47897', '38000', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('3344', '51514', '38000', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('3344', '51505', '38000', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('3344', '51730', '38000', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('3327', '51723', '38000', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('3327', '51722', '38000', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('6018', '47951', '38000', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('6018', '47695', '38000', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('6018', '53023', '38000', '0', '0', '76');
Now spawn the updated trainers ANY WHERE U WANT =D
-Mage Spells Updated- Code:
INSERT INTO `npc_trainer` VALUES ('5882', '43017', '0', '0', '0', '77');
INSERT INTO `npc_trainer` VALUES ('5882', '44780', '0', '44425', '0', '70');
INSERT INTO `npc_trainer` VALUES ('5882', '44781', '0', '44780', '0', '80');
INSERT INTO `npc_trainer` VALUES ('5882', '42894', '0', '0', '0', '71');
INSERT INTO `npc_trainer` VALUES ('5882', '42896', '0', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('5882', '42897', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('5882', '43002', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('5882', '42920', '0', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('5882', '42921', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('5882', '42995', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('5882', '42843', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('5882', '42846', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('5882', '42955', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('5882', '42956', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('5882', '42985', '0', '0', '0', '77');
INSERT INTO `npc_trainer` VALUES ('5882', '42975', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('5882', '42977', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('5882', '43015', '0', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('5882', '43023', '0', '0', '0', '71');
INSERT INTO `npc_trainer` VALUES ('5882', '43024', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('5882', '43019', '0', '0', '0', '73');
INSERT INTO `npc_trainer` VALUES ('5882', '43020', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('5882', '42944', '0', '33933', '0', '75');
INSERT INTO `npc_trainer` VALUES ('5882', '42945', '0', '42944', '0', '80');
INSERT INTO `npc_trainer` VALUES ('5882', '42949', '0', '33043', '0', '75');
INSERT INTO `npc_trainer` VALUES ('5882', '42950', '0', '42949', '0', '80');
INSERT INTO `npc_trainer` VALUES ('5882', '42872', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('5882', '42873', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('5882', '43010', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('5882', '38692', '0', '0', '0', '70');
INSERT INTO `npc_trainer` VALUES ('5882', '42832', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('5882', '42833', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('5882', '42925', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('5882', '42926', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('5882', '49419', '0', '0', '0', '70');
INSERT INTO `npc_trainer` VALUES ('5882', '49420', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('5882', '43043', '0', '0', '0', '71');
INSERT INTO `npc_trainer` VALUES ('5882', '43044', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('5882', '42890', '0', '33938', '0', '73');
INSERT INTO `npc_trainer` VALUES ('5882', '42891', '0', '42890', '0', '78');
INSERT INTO `npc_trainer` VALUES ('5882', '42858', '0', '0', '0', '73');
INSERT INTO `npc_trainer` VALUES ('5882', '42859', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('5882', '42938', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('5882', '42930', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('5882', '42931', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('5882', '42917', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('5882', '43012', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('5882', '42841', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('5882', '42842', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('5882', '43038', '0', '33405', '0', '75');
INSERT INTO `npc_trainer` VALUES ('5882', '43039', '0', '43039', '0', '80');
INSERT INTO `npc_trainer` VALUES ('5882', '42913', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('5882', '42914', '0', '0', '0', '78');
-Priest Spells Updated- Code: INSERT INTO `npc_trainer` VALUES ('6018', '48073', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('6018', '48040', '0', '0', '0', '71');
INSERT INTO `npc_trainer` VALUES ('6018', '48168', '0', '0', '0', '77');
INSERT INTO `npc_trainer` VALUES ('6018', '48161', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('6018', '48065', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('6018', '48066', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('6018', '48162', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('6018', '48074', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('6018', '48119', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('6018', '48120', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('6018', '48088', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('6018', '48089', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('6018', '48070', '0', '0', '0', '73');
INSERT INTO `npc_trainer` VALUES ('6018', '48071', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('6018', '48062', '0', '0', '0', '73');
INSERT INTO `npc_trainer` VALUES ('6018', '48063', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('6018', '48134', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('6018', '48135', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('6018', '48077', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('6018', '48078', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('6018', '48072', '0', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('6018', '48112', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('6018', '48113', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('6018', '48067', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('6018', '48068', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('6018', '48122', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('6018', '48123', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('6018', '48166', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('6018', '78167', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('6018', '48128', '0', '0', '0', '77');
INSERT INTO `npc_trainer` VALUES ('6018', '48426', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('6018', '48127', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('6018', '48155', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('6018', '48156', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('6018', '48170', '0', '0', '0', '77');
INSERT INTO `npc_trainer` VALUES ('6018', '48169', '0', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('6018', '48157', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('6018', '48158', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('6018', '48124', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('6018', '48125', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('6018', '48159', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('6018', '48160', '0', '0', '0', '80');
-Rouges Spell Updated- Code: INSERT INTO `npc_trainer` VALUES ('3327', '48689', '0', '0', '0', '70');
INSERT INTO `npc_trainer` VALUES ('3327', '48690', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('3327', '48691', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('3327', '48673', '0', '0', '0', '70');
INSERT INTO `npc_trainer` VALUES ('3327', '48674', '0', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('3327', '48667', '0', '0', '0', '73');
INSERT INTO `npc_trainer` VALUES ('3327', '48668', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('3327', '48669', '0', '0', '0', '77');
INSERT INTO `npc_trainer` VALUES ('3327', '48675', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('3327', '48676', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('3327', '48663', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('3327', '48666', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('3327', '48671', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('3327', '48672', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('3327', '48656', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('3327', '48657', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('3327', '48658', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('3327', '48659', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('3327', '48637', '0', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('3327', '48638', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('3327', '48660', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('3327', '51724', '0', '0', '0', '71');
-Druids Spells Updated- Code: INSERT INTO `npc_trainer` VALUES ('12042', '53308', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('12042', '48476', '0', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('12042', '48467', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('12042', '48468', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('12042', '48462', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('12042', '48463', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('12042', '53312', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('12042', '48464', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('12042', '48465', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('12042', '53307', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('12042', '53323', '0', '0', '0', '60');
INSERT INTO `npc_trainer` VALUES ('12042', '53325', '0', '0', '0', '70');
INSERT INTO `npc_trainer` VALUES ('12042', '53326', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('12042', '53327', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('12042', '48459', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('12042', '48461', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('12042', '48569', '0', '0', '0', '73');
INSERT INTO `npc_trainer` VALUES ('12042', '48570', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('12042', '48575', '0', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('12042', '48559', '0', '0', '0', '71');
INSERT INTO `npc_trainer` VALUES ('12042', '48560', '0', '0', '0', '77');
INSERT INTO `npc_trainer` VALUES ('12042', '48576', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('12042', '48577', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('12042', '48567', '0', '0', '0', '73');
INSERT INTO `npc_trainer` VALUES ('12042', '48568', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('12042', '49802', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('12042', '48563', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('12042', '48564', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('12042', '48565', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('12042', '48566', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('12042', '48479', '0', '0', '0', '73');
INSERT INTO `npc_trainer` VALUES ('12042', '48480', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('12042', '49803', '0', '0', '0', '77');
INSERT INTO `npc_trainer` VALUES ('12042', '48573', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('12042', '48574', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('12042', '48578', '0', '0', '0', '73');
INSERT INTO `npc_trainer` VALUES ('12042', '48579', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('12042', '49799', '0', '0', '0', '71');
INSERT INTO `npc_trainer` VALUES ('12042', '49800', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('12042', '48571', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('12042', '48572', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('12042', '48561', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('12042', '48562', '0', '0', '0', '77');
INSERT INTO `npc_trainer` VALUES ('12042', '50212', '0', '0', '0', '71');
INSERT INTO `npc_trainer` VALUES ('12042', '50213', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('12042', '53251', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('12042', '48470', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('12042', '48377', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('12042', '48378', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('12042', '48450', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('12042', '48451', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('12042', '48469', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('12042', '48477', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('12042', '48442', '0', '0', '0', '71');
INSERT INTO `npc_trainer` VALUES ('12042', '48443', '0', '0', '0', '77');
INSERT INTO `npc_trainer` VALUES ('12042', '48440', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('12042', '48441', '0', '0', '0', '80');
-Warrior Spells Updated- Code: INSERT INTO `npc_trainer` VALUES ('4593', '47449', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('4593', '47450', '0', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('4593', '47485', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('4593', '47486', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('4593', '46845', '0', '0', '0', '71');
INSERT INTO `npc_trainer` VALUES ('4593', '47465', '0', '0', '0', '76');
INSERT INTO `npc_trainer` VALUES ('4593', '47501', '0', '0', '0', '73');
INSERT INTO `npc_trainer` VALUES ('4593', '47502', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('4593', '47436', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('4593', '47519', '0', '0', '0', '72');
INSERT INTO `npc_trainer` VALUES ('4593', '47520', '0', '0', '0', '77');
INSERT INTO `npc_trainer` VALUES ('4593', '47439', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('4593', '47440', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('4593', '47437', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('4593', '47470', '0', '0', '0', '73');
INSERT INTO `npc_trainer` VALUES ('4593', '47471', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('4593', '47500', '0', '0', '0', '78');
INSERT INTO `npc_trainer` VALUES ('4593', '47474', '0', '0', '0', '74');
INSERT INTO `npc_trainer` VALUES ('4593', '47475', '0', '0', '0', '79');
INSERT INTO `npc_trainer` VALUES ('4593', '48497', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('4593', '47498', '0', '0', '0', '80');
INSERT INTO `npc_trainer` VALUES ('4593', '47467', '0', '0', '0', '77');
INSERT INTO `npc_trainer` VALUES ('4593', '47487', '0', '0', '0', '75');
INSERT INTO `npc_trainer` VALUES ('4593', '47488', '0', '0', '0', '80');
Mage trainer - .npc add 5582
Priest trainer - .npc add 6018
Rouge trainer - .npc add 3327
Warlock trainer - .npc add 3325
Shammy trainer - .npc add 3344
Pally trainer - .npc add 20406
Warrior trainer - .npc add 4593
Druid trainer - .npc add 12042
Hunter trainer - .npc add 3406
Last edited by omgbbq34; 07-27-2008 at 05:54 AM.
|