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
Now spawn the updated trainers ANY WHERE U WANT =DCode: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');
-Mage Spells Updated-
-Priest 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');
-Rouges Spell 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');
-Druids Spells 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');
-Warrior 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');
Mage trainer - .npc add 5582Code: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');
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


LinkBack URL
About LinkBacks
Reply With Quote
i'm, lazy too 


