DELETE FROM npc_trainer WHERE (`spell`=20252);
DELETE FROM npc_trainer WHERE (`spell`=71);
DELETE FROM npc_trainer WHERE (`spell`=2458);

INSERT INTO `npc_trainer` SELECT `entry`, '20252', '3000', '0', '0', '30' FROM `creature_template` WHERE `subname`='Warrior Trainer'; -- intercept
INSERT INTO `npc_trainer` SELECT `entry`, '71', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Warrior Trainer'; -- Defensive Stance
INSERT INTO `npc_trainer` SELECT `entry`, '2458', '3000', '0', '0', '30' FROM `creature_template` WHERE `subname`='Warrior Trainer'; -- Berserker Stance

-- Druid
DELETE FROM npc_trainer WHERE (`spell`=5487);
DELETE FROM npc_trainer WHERE (`spell`=1066);
DELETE FROM npc_trainer WHERE (`spell`=40120);
DELETE FROM npc_trainer WHERE (`spell`=6807);
DELETE FROM npc_trainer WHERE (`spell`=6795);

INSERT INTO `npc_trainer` SELECT `entry`, '5487', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Druid Trainer'; -- Bear Form
INSERT INTO `npc_trainer` SELECT `entry`, '6807', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Druid Trainer'; -- Maul
INSERT INTO `npc_trainer` SELECT `entry`, '6795', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Druid Trainer'; -- Growl
INSERT INTO `npc_trainer` SELECT `entry`, '1066', '1600', '0', '0', '16' FROM `creature_template` WHERE `subname`='Druid Trainer'; -- Aquatic Form
INSERT INTO `npc_trainer` SELECT `entry`, '40120', '200000', '0', '0', '70' FROM `creature_template` WHERE `subname`='Druid Trainer'; -- Swift Flight Form

-- Paladin
DELETE FROM npc_trainer WHERE (`spell`=7328);

INSERT INTO `npc_trainer` SELECT `entry`, '7328', '1200', '0', '0', '12' FROM `creature_template` WHERE `subname`='Paladin Trainer'; -- Redemption

-- Rogue
DELETE FROM npc_trainer WHERE (`spell`=2842);
DELETE FROM npc_trainer WHERE (`spell`=8681);
DELETE FROM npc_trainer WHERE (`spell`=3420);

INSERT INTO `npc_trainer` SELECT `entry`, '2842', '2000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Rogue Trainer'; -- Poisons
INSERT INTO `npc_trainer` SELECT `entry`, '8681', '2000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Rogue Trainer'; -- Instant Poison
INSERT INTO `npc_trainer` SELECT `entry`, '3420', '2000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Rogue Trainer'; -- Crippling Poison

-- Hunter
DELETE FROM npc_trainer WHERE (`spell`=5149);
DELETE FROM npc_trainer WHERE (`spell`=883);
DELETE FROM npc_trainer WHERE (`spell`=6991);
DELETE FROM npc_trainer WHERE (`spell`=2641);
DELETE FROM npc_trainer WHERE (`spell`=982);
DELETE FROM npc_trainer WHERE (`spell`=1515);

INSERT INTO `npc_trainer` SELECT `entry`, '5149', '2000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Hunter Trainer'; -- Beast Training
INSERT INTO `npc_trainer` SELECT `entry`, '883', '2000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Hunter Trainer'; -- Call Pet
INSERT INTO `npc_trainer` SELECT `entry`, '6991', '2000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Hunter Trainer'; -- Feed Pet
INSERT INTO `npc_trainer` SELECT `entry`, '2641', '2000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Hunter Trainer'; -- Dismiss Pet
INSERT INTO `npc_trainer` SELECT `entry`, '982', '2000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Hunter Trainer'; -- Revive Pet
INSERT INTO `npc_trainer` SELECT `entry`, '1515', '2000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Hunter Trainer'; -- Tame Beast

-- Warlock
DELETE FROM npc_trainer WHERE (`spell`=688);
DELETE FROM npc_trainer WHERE (`spell`=697);
DELETE FROM npc_trainer WHERE (`spell`=712);
DELETE FROM npc_trainer WHERE (`spell`=691);
DELETE FROM npc_trainer WHERE (`spell`=5784);
DELETE FROM npc_trainer WHERE (`spell`=1122);
DELETE FROM npc_trainer WHERE (`spell`=23161);

INSERT INTO `npc_trainer` SELECT `entry`, '688', '100', '0', '0', '4' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Summon Imp
INSERT INTO `npc_trainer` SELECT `entry`, '697', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Summon Voidwalker
INSERT INTO `npc_trainer` SELECT `entry`, '712', '2000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Summon Succubus
INSERT INTO `npc_trainer` SELECT `entry`, '691', '3000', '0', '0', '30' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Summon Felhunter
INSERT INTO `npc_trainer` SELECT `entry`, '5784', '4000', '0', '0', '40' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Summon Felsteed
INSERT INTO `npc_trainer` SELECT `entry`, '1122', '5000', '0', '0', '50' FROM `creature_template` WHERE `subname`='Warlock Trainer'; -- Summon Inferno

-- Shaman
DELETE FROM npc_trainer WHERE (`spell`=8071);
DELETE FROM npc_trainer WHERE (`spell`=3599);
DELETE FROM npc_trainer WHERE (`spell`=5394);

INSERT INTO `npc_trainer` SELECT `entry`, '8071', '100', '0', '0', '4' FROM `creature_template` WHERE `subname`='Shaman Trainer'; -- Stoneskin Totem
INSERT INTO `npc_trainer` SELECT `entry`, '3599', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Shaman Trainer'; -- Searing Totem
INSERT INTO `npc_trainer` SELECT `entry`, '5394', '2000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Shaman Trainer'; -- Healing Stream Totem

-- Priest
DELETE FROM npc_trainer WHERE (`spell`=2652);
DELETE FROM npc_trainer WHERE (`spell`=9035);
DELETE FROM npc_trainer WHERE (`spell`=10797);
DELETE FROM npc_trainer WHERE (`spell`=13908);
DELETE FROM npc_trainer WHERE (`spell`=13896);
DELETE FROM npc_trainer WHERE (`spell`=2944);
DELETE FROM npc_trainer WHERE (`spell`=18137);
DELETE FROM npc_trainer WHERE (`spell`=2651);
DELETE FROM npc_trainer WHERE (`spell`=6346);

INSERT INTO `npc_trainer` SELECT `entry`, '2652', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Priest Trainer'; -- Touch of Weakness
INSERT INTO `npc_trainer` SELECT `entry`, '9035', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Priest Trainer'; -- Hex of Weakness
INSERT INTO `npc_trainer` SELECT `entry`, '10797', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Priest Trainer'; -- Starshards
INSERT INTO `npc_trainer` SELECT `entry`, '13908', '1000', '0', '0', '10' FROM `creature_template` WHERE `subname`='Priest Trainer'; -- Desperate Prayer
INSERT INTO `npc_trainer` SELECT `entry`, '13896', '5000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Priest Trainer'; -- Feedback
INSERT INTO `npc_trainer` SELECT `entry`, '2944', '5000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Priest Trainer'; -- Devouring Plague
INSERT INTO `npc_trainer` SELECT `entry`, '18137', '5000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Priest Trainer'; -- Shadowguard
INSERT INTO `npc_trainer` SELECT `entry`, '2651', '5000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Priest Trainer'; -- Elune's Grace
INSERT INTO `npc_trainer` SELECT `entry`, '6346', '5000', '0', '0', '20' FROM `creature_template` WHERE `subname`='Priest Trainer'; -- Fear Ward