--Cleanup
DELETE FROM `spell_learn_spell` WHERE `entry` IN (5784,13819,23161,23214,34767,34769,33943,33950,40120);
DELETE FROM `npc_trainer` WHERE `spell` IN (5784,13819,23161,23214,34767,34769,33943,33950,40120);
DELETE FROM `spell_required` WHERE `spell_id` IN (34767,23214,23161);

--Paladin

--BloodElf

--Lvl 30
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(16275, 34769, 100000, 762, 75, 30),
(16679, 34769, 100000, 762, 75, 30),
(16680, 34769, 100000, 762, 75, 30),
(16681, 34769, 100000, 762, 75, 30),
(20406, 34769, 100000, 762, 75, 30),
(23128, 34769, 100000, 762, 75, 30);

--Lvl 61
INSERT INTO `spell_required` (`spell_id`,`req_spell`) VALUES ('34767', '34769');
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES
(16275, 34767, 200000, 762, 150, 61),
(16679, 34767, 200000, 762, 150, 61),
(16680, 34767, 200000, 762, 150, 61),
(16681, 34767, 200000, 762, 150, 61),
(20406, 34767, 200000, 762, 150, 61),
(23128, 34767, 200000, 762, 150, 61);


--Human, Dwarf, Draenei

--Lvl 30
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(927, 13819, 100000, 762, 75, 30),
(928, 13819, 100000, 762, 75, 30),
(1232, 13819, 100000, 762, 75, 30),
(5147, 13819, 100000, 762, 75, 30),
(5148, 13819, 100000, 762, 75, 30),
(5149, 13819, 100000, 762, 75, 30),
(5491, 13819, 100000, 762, 75, 30),
(5492, 13819, 100000, 762, 75, 30),
(8140, 13819, 100000, 762, 75, 30),
(16761, 13819, 100000, 762, 75, 30),
(17121, 13819, 100000, 762, 75, 30),
(17483, 13819, 100000, 762, 75, 30),
(17509, 13819, 100000, 762, 75, 30),
(17844, 13819, 100000, 762, 75, 30);

--Lvl 61
INSERT INTO `spell_required` (`spell_id`,`req_spell`) VALUES ('23214', '13819');
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(927, 23214, 200000, 762, 150, 61),
(928, 23214, 200000, 762, 150, 61),
(1232, 23214, 200000, 762, 150, 61),
(5147, 23214, 200000, 762, 150, 61),
(5148, 23214, 200000, 762, 150, 61),
(5149, 23214, 200000, 762, 150, 61),
(5491, 23214, 200000, 762, 150, 61),
(5492, 23214, 200000, 762, 150, 61),
(8140, 23214, 200000, 762, 150, 61),
(16761, 23214, 200000, 762, 150, 61),
(17121, 23214, 200000, 762, 150, 61),
(17483, 23214, 200000, 762, 150, 61),
(17509, 23214, 200000, 762, 150, 61),
(17844, 23214, 200000, 762, 150, 61);

--Warlock

--Lvl 30
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(461, 5784, 100000, 762, 75, 30),
(906, 5784, 100000, 762, 75, 30),
(988, 5784, 100000, 762, 75, 30),
(2127, 5784, 100000, 762, 75, 30),
(3172, 5784, 100000, 762, 75, 30),
(3324, 5784, 100000, 762, 75, 30),
(3325, 5784, 100000, 762, 75, 30),
(3326, 5784, 100000, 762, 75, 30),
(4563, 5784, 100000, 762, 75, 30),
(4564, 5784, 100000, 762, 75, 30),
(4565, 5784, 100000, 762, 75, 30),
(5171, 5784, 100000, 762, 75, 30),
(5612, 5784, 100000, 762, 75, 30),
(5495, 5784, 100000, 762, 75, 30),
(5496, 5784, 100000, 762, 75, 30),
(5172, 5784, 100000, 762, 75, 30),
(5173, 5784, 100000, 762, 75, 30),
(16266, 5784, 100000, 762, 75, 30),
(16647, 5784, 100000, 762, 75, 30),
(16646, 5784, 100000, 762, 75, 30),
(16648, 5784, 100000, 762, 75, 30),
(23534, 5784, 100000, 762, 75, 30);

--Lvl 61
INSERT INTO `spell_required` (`spell_id`,`req_spell`) VALUES ('23161', '5784');
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(461, 23161, 200000, 762, 150, 61),
(906, 23161, 200000, 762, 150, 61),
(988, 23161, 200000, 762, 150, 61),
(2127, 23161, 200000, 762, 150, 61),
(3172, 23161, 200000, 762, 150, 61),
(3324, 23161, 200000, 762, 150, 61),
(3325, 23161, 200000, 762, 150, 61),
(3326, 23161, 200000, 762, 150, 61),
(4563, 23161, 200000, 762, 150, 61),
(4564, 23161, 200000, 762, 150, 61),
(4565, 23161, 200000, 762, 150, 61),
(5171, 23161, 200000, 762, 150, 61),
(5173, 23161, 200000, 762, 150, 61),
(5172, 23161, 200000, 762, 150, 61),
(5495, 23161, 200000, 762, 150, 61),
(5496, 23161, 200000, 762, 150, 61),
(5612, 23161, 200000, 762, 150, 61),
(16266, 23161, 200000, 762, 150, 61),
(16646, 23161, 200000, 762, 150, 61),
(16647, 23161, 200000, 762, 150, 61),
(16648, 23161, 200000, 762, 150, 61),
(23534, 23161, 200000, 762, 150, 61);


--Druid
DELETE FROM `spell_learn_spell` WHERE `entry` IN (33943,33950,40120);
DELETE FROM `npc_trainer` WHERE `spell` IN (33943,33950,40120);
DELETE FROM `spell_required` WHERE `spell_id` IN (40120);

-- Lvl 68
INSERT INTO `spell_learn_spell` (`entry`, `SpellID`, `Active`) VALUES (33943, 34090, 1); 
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3033, 33943, 81000, 762, 150, 68),
(3034, 33943, 81000, 762, 150, 68),
(3036, 33943, 81000, 762, 150, 68),
(3064, 33943, 81000, 762, 150, 68),
(3602, 33943, 81000, 762, 150, 68),
(4217, 33943, 81000, 762, 150, 68),
(4218, 33943, 81000, 762, 150, 68),
(4219, 33943, 81000, 762, 150, 68),
(5504, 33943, 81000, 762, 150, 68),
(5505, 33943, 81000, 762, 150, 68),
(5506, 33943, 81000, 762, 150, 68),
(8142, 33943, 81000, 762, 150, 68),
(9465, 33943, 81000, 762, 150, 68),
(12042, 33943, 81000, 762, 150, 68),
(16655, 33943, 81000, 762, 150, 68),
(16721, 33943, 81000, 762, 150, 68);

--Lvl 71
INSERT INTO `spell_required` (`spell_id`,`req_spell`) VALUES ('40120', '33943');
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(3033, 40120, 200000, 762, 300, 71),
(3034, 40120, 200000, 762, 300, 71),
(3036, 40120, 200000, 762, 300, 71),
(3064, 40120, 200000, 762, 300, 71),
(3602, 40120, 200000, 762, 300, 71),
(4217, 40120, 200000, 762, 300, 71),
(4218, 40120, 200000, 762, 300, 71),
(4219, 40120, 200000, 762, 300, 71),
(5504, 40120, 200000, 762, 300, 71),
(5505, 40120, 200000, 762, 300, 71),
(5506, 40120, 200000, 762, 300, 71),
(8142, 40120, 200000, 762, 300, 71),
(9465, 40120, 200000, 762, 300, 71),
(12042, 40120, 200000, 762, 300, 71),
(16655, 40120, 200000, 762, 300, 71),
(16721, 40120, 200000, 762, 300, 71);