Secondary Profession Trainer ent

DELETE FROM `npc_trainer` WHERE `spell` IN ('7733', '7734', '54083', '18249', '54084', '51293');  INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES  -- Fishing: Apprentice  (1651, 7733, 100, 0, 0, 5),   (17101, 7733, 100, 0, 0, 5),   (1680, 7733, 100, 0, 0, 5),   (1700, 7733, 100, 0, 0, 5),   (5941, 7733, 100, 0, 0, 5),   (5938, 7733, 100, 0, 0, 5),   (1683, 7733, 100, 0, 0, 5),   (5690, 7733, 100, 0, 0, 5),   (3179, 7733, 100, 0, 0, 5),   (16780, 7733, 100, 0, 0, 5),   (16774, 7733, 100, 0, 0, 5),   (12961, 7733, 100, 0, 0, 5),   (12032, 7733, 100, 0, 0, 5),   (2367, 7733, 100, 0, 0, 5),   (4573, 7733, 100, 0, 0, 5),   (5493, 7733, 100, 0, 0, 5),   (4156, 7733, 100, 0, 0, 5),   (5161, 7733, 100, 0, 0, 5),   (3332, 7733, 100, 0, 0, 5),   (3607, 7733, 100, 0, 0, 5),   (14740, 7733, 100, 0, 0, 5),   (2834, 7733, 100, 0, 0, 5),   (3028, 7733, 100, 0, 0, 5),   (7946, 7733, 100, 0, 0, 5),   (33623, 7733, 100, 0, 0, 5),   (18911, 7733, 100, 0, 0, 5),   (18018, 7733, 100, 0, 0, 5),   (26957, 7733, 100, 0, 0, 5),   (26909, 7733, 100, 0, 0, 5),   (32474, 7733, 100, 0, 0, 5),   (26993, 7733, 100, 0, 0, 5),   (28742, 7733, 100, 0, 0, 5), -- Fishing: Journeyman  (1651, 7734, 500, 356, 50, 10),    (17101, 7734, 500, 356, 50, 10),    (1680, 7734, 500, 356, 50, 10),    (1700, 7734, 500, 356, 50, 10),    (5941, 7734, 500, 356, 50, 10),    (5938, 7734, 500, 356, 50, 10),    (1683, 7734, 500, 356, 50, 10),    (5690, 7734, 500, 356, 50, 10),    (3179, 7734, 500, 356, 50, 10),    (16780, 7734, 500, 356, 50, 10),    (16774, 7734, 500, 356, 50, 10),    (12961, 7734, 500, 356, 50, 10),    (12032, 7734, 500, 356, 50, 10),    (2367, 7734, 500, 356, 50, 10),    (4573, 7734, 500, 356, 50, 10),    (5493, 7734, 500, 356, 50, 10),    (4156, 7734, 500, 356, 50, 10),    (5161, 7734, 500, 356, 50, 10),    (3332, 7734, 500, 356, 50, 10),    (3607, 7734, 500, 356, 50, 10),    (14740, 7734, 500, 356, 50, 10),    (2834, 7734, 500, 356, 50, 10),    (3028, 7734, 500, 356, 50, 10),    (7946, 7734, 500, 356, 50, 10),    (33623, 7734, 500, 356, 50, 10),    (18911, 7734, 500, 356, 50, 10),    (18018, 7734, 500, 356, 50, 10),    (26957, 7734, 500, 356, 50, 10),    (26909, 7734, 500, 356, 50, 10),    (32474, 7734, 500, 356, 50, 10),    (26993, 7734, 500, 356, 50, 10),    (28742, 7734, 500, 356, 50, 10),    -- Fishing: Expert  (1651, 54083, 10000, 356, 125, 30),    (17101, 54083, 10000, 356, 125, 30),    (1680, 54083, 10000, 356, 125, 30),    (1700, 54083, 10000, 356, 125, 30),    (5941, 54083, 10000, 356, 125, 30),    (5938, 54083, 10000, 356, 125, 30),    (1683, 54083, 10000, 356, 125, 30),    (5690, 54083, 10000, 356, 125, 30),    (3179, 54083, 10000, 356, 125, 30),    (16780, 54083, 10000, 356, 125, 30),    (16774, 54083, 10000, 356, 125, 30),    (12961, 54083, 10000, 356, 125, 30),    (12032, 54083, 10000, 356, 125, 30),    (2367, 54083, 10000, 356, 125, 30),    (4573, 54083, 10000, 356, 125, 30),    (5493, 54083, 10000, 356, 125, 30),    (4156, 54083, 10000, 356, 125, 30),    (5161, 54083, 10000, 356, 125, 30),    (3332, 54083, 10000, 356, 125, 30),    (3607, 54083, 10000, 356, 125, 30),    (14740, 54083, 10000, 356, 125, 30),    (2834, 54083, 10000, 356, 125, 30),    (3028, 54083, 10000, 356, 125, 30),    (7946, 54083, 10000, 356, 125, 30),    (33623, 54083, 10000, 356, 125, 30),    (18911, 54083, 10000, 356, 125, 30),    (18018, 54083, 10000, 356, 125, 30),    (26957, 54083, 10000, 356, 125, 30),    (26909, 54083, 10000, 356, 125, 30),    (32474, 54083, 10000, 356, 125, 30),    (26993, 54083, 10000, 356, 125, 30),    (28742, 54083, 10000, 356, 125, 30),  -- Fishing: Artisan  (1651, 18249, 25000, 356, 200, 35),    (17101, 18249, 25000, 356, 200, 35),    (1680, 18249, 25000, 356, 200, 35),    (1700, 18249, 25000, 356, 200, 35),    (5941, 18249, 25000, 356, 200, 35),    (5938, 18249, 25000, 356, 200, 35),    (1683, 18249, 25000, 356, 200, 35),    (5690, 18249, 25000, 356, 200, 35),    (3179, 18249, 25000, 356, 200, 35),    (16780, 18249, 25000, 356, 200, 35),    (16774, 18249, 25000, 356, 200, 35),    (12961, 18249, 25000, 356, 200, 35),    (12032, 18249, 25000, 356, 200, 35),    (2367, 18249, 25000, 356, 200, 35),    (4573, 18249, 25000, 356, 200, 35),    (5493, 18249, 25000, 356, 200, 35),    (4156, 18249, 25000, 356, 200, 35),    (5161, 18249, 25000, 356, 200, 35),    (3332, 18249, 25000, 356, 200, 35),    (3607, 18249, 25000, 356, 200, 35),    (14740, 18249, 25000, 356, 200, 35),    (2834, 18249, 25000, 356, 200, 35),    (3028, 18249, 25000, 356, 200, 35),    (7946, 18249, 25000, 356, 200, 35),    (33623, 18249, 25000, 356, 200, 35),    (18911, 18249, 25000, 356, 200, 35),    (18018, 18249, 25000, 356, 200, 35),    (26957, 18249, 25000, 356, 200, 35),    (26909, 18249, 25000, 356, 200, 35),    (32474, 18249, 25000, 356, 200, 35),    (26993, 18249, 25000, 356, 200, 35),    (28742, 18249, 25000, 356, 200, 35),  -- Fishing: Master  (18911, 54084, 100000, 356, 275, 55),    (26957, 54084, 100000, 356, 275, 55),    (26909, 54084, 100000, 356, 275, 55),    (32474, 54084, 100000, 356, 275, 55),    (26993, 54084, 100000, 356, 275, 55),    (28742, 54084, 100000, 356, 275, 55),  -- Fishing: Grand Master  (26957, 51293, 350000, 356, 350, 1),    (26909, 51293, 350000, 356, 350, 1),    (32474, 51293, 350000, 356, 350, 1),    (26993, 51293, 350000, 356, 350, 1),    (28742, 51293, 350000, 356, 350, 1);  DELETE FROM `npc_trainer` WHERE `spell` IN ('3279', '3280', '54254', '10847', '54255', '50299'); INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES  -- First Aid: Apprentice  (17214, 3279, 100, 0, 0, 0),   (17424, 3279, 100, 0, 0, 0),   (23734, 3279, 100, 0, 0, 0),   (26992, 3279, 100, 0, 0, 0),   (18990, 3279, 100, 0, 0, 0),   (6094, 3279, 100, 0, 0, 0),   (4211, 3279, 100, 0, 0, 0),   (3181, 3279, 100, 0, 0, 0),   (2329, 3279, 100, 0, 0, 0),   (5150, 3279, 100, 0, 0, 0),   (16731, 3279, 100, 0, 0, 0),   (2327, 3279, 100, 0, 0, 0),   (2326, 3279, 100, 0, 0, 0),   (16662, 3279, 100, 0, 0, 0),   (3373, 3279, 100, 0, 0, 0),   (18991, 3279, 100, 0, 0, 0),   (19478, 3279, 100, 0, 0, 0),   (16272, 3279, 100, 0, 0, 0),   (4591, 3279, 100, 0, 0, 0),   (29233, 3279, 100, 0, 0, 0),   (5759, 3279, 100, 0, 0, 0),   (2798, 3279, 100, 0, 0, 0),   (5943, 3279, 100, 0, 0, 0),   (26956, 3279, 100, 0, 0, 0),   (5939, 3279, 100, 0, 0, 0),   (22477, 3279, 100, 0, 0, 0),   (19184, 3279, 100, 0, 0, 0),   (28706, 3279, 100, 0, 0, 0),   (33589, 3279, 100, 0, 0, 0), -- First Aid: Journeymen  (17214, 3280, 500, 129, 50, 0),   (17424, 3280, 500, 129, 50, 0),   (23734, 3280, 500, 129, 50, 0),   (26992, 3280, 500, 129, 50, 0),   (18990, 3280, 500, 129, 50, 0),   (6094, 3280, 500, 129, 50, 0),   (4211, 3280, 500, 129, 50, 0),   (3181, 3280, 500, 129, 50, 0),   (2329, 3280, 500, 129, 50, 0),   (5150, 3280, 500, 129, 50, 0),   (16731, 3280, 500, 129, 50, 0),   (2327, 3280, 500, 129, 50, 0),   (2326, 3280, 500, 129, 50, 0),   (16662, 3280, 500, 129, 50, 0),   (3373, 3280, 500, 129, 50, 0),   (18991, 3280, 500, 129, 50, 0),   (19478, 3280, 500, 129, 50, 0),   (16272, 3280, 500, 129, 50, 0),   (4591, 3280, 500, 129, 50, 0),   (29233, 3280, 500, 129, 50, 0),   (5759, 3280, 500, 129, 50, 0),   (2798, 3280, 500, 129, 50, 0),   (5943, 3280, 500, 129, 50, 0),   (26956, 3280, 500, 129, 50, 0),   (5939, 3280, 500, 129, 50, 0),   (22477, 3280, 500, 129, 50, 0),   (19184, 3280, 500, 129, 50, 0),   (28706, 3280, 500, 129, 50, 0),   (33589, 3280, 500, 129, 50, 0), -- First Aid: Expert  (17214, 54254, 1000, 129, 125, 0),   (17424, 54254, 1000, 129, 125, 0),   (23734, 54254, 1000, 129, 125, 0),   (26992, 54254, 1000, 129, 125, 0),   (18990, 54254, 1000, 129, 125, 0),   (6094, 54254, 1000, 129, 125, 0),   (4211, 54254, 1000, 129, 125, 0),   (3181, 54254, 1000, 129, 125, 0),   (2329, 54254, 1000, 129, 125, 0),   (5150, 54254, 1000, 129, 125, 0),   (16731, 54254, 1000, 129, 125, 0),   (2327, 54254, 1000, 129, 125, 0),   (2326, 54254, 1000, 129, 125, 0),   (16662, 54254, 1000, 129, 125, 0),   (3373, 54254, 1000, 129, 125, 0),   (18991, 54254, 1000, 129, 125, 0),   (19478, 54254, 1000, 129, 125, 0),   (16272, 54254, 1000, 129, 125, 0),   (4591, 54254, 1000, 129, 125, 0),   (29233, 54254, 1000, 129, 125, 0),   (5759, 54254, 1000, 129, 125, 0),   (2798, 54254, 1000, 129, 125, 0),   (5943, 54254, 1000, 129, 125, 0),   (26956, 54254, 1000, 129, 125, 0),   (5939, 54254, 1000, 129, 125, 0),   (22477, 54254, 1000, 129, 125, 0),   (19184, 54254, 1000, 129, 125, 0),   (28706, 54254, 1000, 129, 125, 0),   (33589, 54254, 1000, 129, 125, 0), -- First Aid: Artisan  (17214, 10847, 25000, 129, 200, 35),   (17424, 10847, 25000, 129, 200, 35),   (23734, 10847, 25000, 129, 200, 35),   (26992, 10847, 25000, 129, 200, 35),   (18990, 10847, 25000, 129, 200, 35),   (6094, 10847, 25000, 129, 200, 35),   (4211, 10847, 25000, 129, 200, 35),   (3181, 10847, 25000, 129, 200, 35),   (2329, 10847, 25000, 129, 200, 35),   (5150, 10847, 25000, 129, 200, 35),   (16731, 10847, 25000, 129, 200, 35),   (2327, 10847, 25000, 129, 200, 35),   (2326, 10847, 25000, 129, 200, 35),   (16662, 10847, 25000, 129, 200, 35),   (3373, 10847, 25000, 129, 200, 35),   (18991, 10847, 25000, 129, 200, 35),   (19478, 10847, 25000, 129, 200, 35),   (16272, 10847, 25000, 129, 200, 35),   (4591, 10847, 25000, 129, 200, 35),   (29233, 10847, 25000, 129, 200, 35),   (5759, 10847, 25000, 129, 200, 35),   (2798, 10847, 25000, 129, 200, 35),   (5943, 10847, 25000, 129, 200, 35),   (26956, 10847, 25000, 129, 200, 35),   (5939, 10847, 25000, 129, 200, 35),   (22477, 10847, 25000, 129, 200, 35),   (19184, 10847, 25000, 129, 200, 35),   (28706, 10847, 25000, 129, 200, 35),   (33589, 10847, 25000, 129, 200, 35), -- First Aid: Master  (23734, 54255, 100000, 129, 300, 50),   (26992, 54255, 100000, 129, 300, 50),   (18990, 54255, 100000, 129, 300, 50),   (18991, 54255, 100000, 129, 300, 50),   (29233, 54255, 100000, 129, 300, 50),   (26956, 54255, 100000, 129, 300, 50),   (28706, 54255, 100000, 129, 300, 50),   (33589, 54255, 100000, 129, 300, 50), -- First Aid: Grand Master  (23734, 50299, 350000, 129, 350, 0),   (26992, 50299, 350000, 129, 350, 0),  (29233, 50299, 350000, 129, 350, 0),  (26956, 50299, 350000, 129, 350, 0),  (28706, 50299, 350000, 129, 350, 0),  (33589, 50299, 350000, 129, 350, 0);DELETE FROM `npc_trainer` WHERE `spell` IN ('2551', '3412', '54257', '18261', '54256', '51295');  INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES  -- Cooking: Apprentice  (4210, 2551, 100, 0, 0, 0),   (26905, 2551, 100, 0, 0, 0),   (19369, 2551, 100, 0, 0, 0),   (1355, 2551, 100, 0, 0, 0),   (17246, 2551, 100, 0, 0, 0),   (3087, 2551, 100, 0, 0, 0),   (5159, 2551, 100, 0, 0, 0),   (18987, 2551, 100, 0, 0, 0),   (1699, 2551, 100, 0, 0, 0),   (28705, 2551, 100, 0, 0, 0),   (16719, 2551, 100, 0, 0, 0),   (26989, 2551, 100, 0, 0, 0),   (5482, 2551, 100, 0, 0, 0),   (1430, 2551, 100, 0, 0, 0),   (6286, 2551, 100, 0, 0, 0),   (3026, 2551, 100, 0, 0, 0),   (29631, 2551, 100, 0, 0, 0),   (18988, 2551, 100, 0, 0, 0),   (8306, 2551, 100, 0, 0, 0),   (4552, 2551, 100, 0, 0, 0),   (16253, 2551, 100, 0, 0, 0),   (1382, 2551, 100, 0, 0, 0),   (26972, 2551, 100, 0, 0, 0),   (3067, 2551, 100, 0, 0, 0),   (16277, 2551, 100, 0, 0, 0),   (2818, 2551, 100, 0, 0, 0),   (16676, 2551, 100, 0, 0, 0),   (26953, 2551, 100, 0, 0, 0),   (3399, 2551, 100, 0, 0, 0),   (33587, 2551, 100, 0, 0, 0),   (8696, 2551, 100, 0, 0, 0),   (19185, 2551, 100, 0, 0, 0),   (18993, 2551, 100, 0, 0, 0), -- Cooking: Journeymen  (4210, 3412, 500, 185, 50, 0),   (26905, 3412, 500, 185, 50, 0),   (19369, 3412, 500, 185, 50, 0),   (1355, 3412, 500, 185, 50, 0),   (17246, 3412, 500, 185, 50, 0),   (3087, 3412, 500, 185, 50, 0),   (5159, 3412, 500, 185, 50, 0),   (18987, 3412, 500, 185, 50, 0),   (1699, 3412, 500, 185, 50, 0),   (28705, 3412, 500, 185, 50, 0),   (16719, 3412, 500, 185, 50, 0),   (26989, 3412, 500, 185, 50, 0),   (5482, 3412, 500, 185, 50, 0),   (1430, 3412, 500, 185, 50, 0),   (6286, 3412, 500, 185, 50, 0),   (3026, 3412, 500, 185, 50, 0),   (29631, 3412, 500, 185, 50, 0),   (18988, 3412, 500, 185, 50, 0),   (8306, 3412, 500, 185, 50, 0),   (4552, 3412, 500, 185, 50, 0),   (16253, 3412, 500, 185, 50, 0),   (1382, 3412, 500, 185, 50, 0),   (26972, 3412, 500, 185, 50, 0),   (3067, 3412, 500, 185, 50, 0),   (16277, 3412, 500, 185, 50, 0),   (2818, 3412, 500, 185, 50, 0),   (16676, 3412, 500, 185, 50, 0),   (26953, 3412, 500, 185, 50, 0),   (3399, 3412, 500, 185, 50, 0),   (33587, 3412, 500, 185, 50, 0),   (8696, 3412, 500, 185, 50, 0),   (19185, 3412, 500, 185, 50, 0),   (18993, 3412, 500, 185, 50, 0), -- Cooking: Expert  (4210, 54257, 1000, 185, 125, 10),   (26905, 54257, 1000, 185, 125, 10),  (19369, 54257, 1000, 185, 125, 10),  (1355, 54257, 1000, 185, 125, 10),  (17246, 54257, 1000, 185, 125, 10),  (3087, 54257, 1000, 185, 125, 10),  (5159, 54257, 1000, 185, 125, 10),  (18987, 54257, 1000, 185, 125, 10),  (1699, 54257, 1000, 185, 125, 10),  (28705, 54257, 1000, 185, 125, 10),  (16719, 54257, 1000, 185, 125, 10),  (26989, 54257, 1000, 185, 125, 10),  (5482, 54257, 1000, 185, 125, 10),  (1430, 54257, 1000, 185, 125, 10),  (6286, 54257, 1000, 185, 125, 10),  (3026, 54257, 1000, 185, 125, 10),  (29631, 54257, 1000, 185, 125, 10),  (18988, 54257, 1000, 185, 125, 10),  (8306, 54257, 1000, 185, 125, 10),  (4552, 54257, 1000, 185, 125, 10),  (16253, 54257, 1000, 185, 125, 10),  (1382, 54257, 1000, 185, 125, 10),  (26972, 54257, 1000, 185, 125, 10),  (3067, 54257, 1000, 185, 125, 10),  (16277, 54257, 1000, 185, 125, 10),  (2818, 54257, 1000, 185, 125, 10),  (16676, 54257, 1000, 185, 125, 10),  (26953, 54257, 1000, 185, 125, 10),  (3399, 54257, 1000, 185, 125, 10),  (33587, 54257, 1000, 185, 125, 10),  (8696, 54257, 1000, 185, 125, 10),  (19185, 54257, 1000, 185, 125, 10),  (18993, 54257, 1000, 185, 125, 10),-- Cooking: Artisan  (4210, 18261, 25000, 185, 200, 25),   (26905, 18261, 25000, 185, 200, 25),   (19369, 18261, 25000, 185, 200, 25),   (1355, 18261, 25000, 185, 200, 25),   (17246, 18261, 25000, 185, 200, 25),   (3087, 18261, 25000, 185, 200, 25),   (5159, 18261, 25000, 185, 200, 25),   (18987, 18261, 25000, 185, 200, 25),   (1699, 18261, 25000, 185, 200, 25),   (28705, 18261, 25000, 185, 200, 25),   (16719, 18261, 25000, 185, 200, 25),   (26989, 18261, 25000, 185, 200, 25),   (5482, 18261, 25000, 185, 200, 25),   (1430, 18261, 25000, 185, 200, 25),   (6286, 18261, 25000, 185, 200, 25),   (3026, 18261, 25000, 185, 200, 25),   (29631, 18261, 25000, 185, 200, 25),   (18988, 18261, 25000, 185, 200, 25),   (8306, 18261, 25000, 185, 200, 25),   (4552, 18261, 25000, 185, 200, 25),   (16253, 18261, 25000, 185, 200, 25),   (1382, 18261, 25000, 185, 200, 25),   (26972, 18261, 25000, 185, 200, 25),   (3067, 18261, 25000, 185, 200, 25),   (16277, 18261, 25000, 185, 200, 25),   (2818, 18261, 25000, 185, 200, 25),   (16676, 18261, 25000, 185, 200, 25),   (26953, 18261, 25000, 185, 200, 25),   (3399, 18261, 25000, 185, 200, 25),   (33587, 18261, 25000, 185, 200, 25),   (8696, 18261, 25000, 185, 200, 25),   (19185, 18261, 25000, 185, 200, 25),   (18993, 18261, 25000, 185, 200, 25), -- Cooking: Master  (26905, 54256, 100000, 185, 300, 40),   (18987, 54256, 100000, 185, 300, 40),   (28705, 54256, 100000, 185, 300, 40),   (26989, 54256, 100000, 185, 300, 40),   (29631, 54256, 100000, 185, 300, 40),   (18988, 54256, 100000, 185, 300, 40),   (26972, 54256, 100000, 185, 300, 40),   (26953, 54256, 100000, 185, 300, 40),   (33587, 54256, 100000, 185, 300, 40),   (18993, 54256, 100000, 185, 300, 40), -- Cooking: Grand Master  (26905, 51295, 350000, 185, 350, 55),   (28705, 51295, 350000, 185, 350, 55),  (26989, 51295, 350000, 185, 350, 55),  (29631, 51295, 350000, 185, 350, 55),  (26972, 51295, 350000, 185, 350, 55),  (26953, 51295, 350000, 185, 350, 55),  (33587, 51295, 350000, 185, 350, 55);