Код:

-- PALADIN
--   Summon Warhorse
REPLACE INTO `npc_trainer` SELECT `entry`, '13819', '200000', '0', '0', '40'  FROM `creature_template` WHERE   

`subname`='Paladin Trainer' AND NOT `faction_A`='1604';
REPLACE INTO `npc_trainer` SELECT `entry`, '13819', '200000', '0', '0', '40'  FROM `creature_template` WHERE   

`subname`='Paladin Trainer' AND `faction_A`='1604';
--   Summon Charger
REPLACE INTO `npc_trainer` SELECT `entry`, '23214', '1000000', '0', '0', '60'  FROM `creature_template` WHERE   

`subname`='Paladin Trainer' AND NOT `faction_A`='1604';
REPLACE INTO `npc_trainer` SELECT `entry`, '23214', '1000000', '0', '0', '60'  FROM `creature_template` WHERE   

`subname`='Paladin Trainer' AND `faction_A`='1604';
--   Redemption RANK1
REPLACE INTO `npc_trainer` SELECT `entry`, '7328', '250', '0', '0', '12'  FROM `creature_template` WHERE   

`subname`='Paladin Trainer';
--   Sense Undead
REPLACE INTO `npc_trainer` SELECT `entry`, '5502', '2500', '0', '0', '20'  FROM `creature_template` WHERE   

`subname`='Paladin Trainer';

-- DRUID
--   Bear Form
REPLACE INTO `npc_trainer` SELECT `entry`, '5487', '200', '0', '0', '10'  FROM `creature_template` WHERE   

`subname`='Druid Trainer';
--   Maul RANK1
REPLACE INTO `npc_trainer` SELECT `entry`, '6807', '200', '0', '0', '10'  FROM `creature_template` WHERE   

`subname`='Druid Trainer';
--   Enrage
REPLACE INTO `npc_trainer` SELECT `entry`, '5229', '200', '0', '0', '10'  FROM `creature_template` WHERE   

`subname`='Druid Trainer';
--   Aquatic Form
REPLACE INTO `npc_trainer` SELECT `entry`, '1446', '200', '0', '0', '16'  FROM `creature_template` WHERE   

`subname`='Druid Trainer';

-- WARLOCK
--   Summon Imp
REPLACE INTO `npc_trainer` SELECT `entry`, '688', '1', '0', '0', '1'  FROM `creature_template` WHERE `subname`='Warlock   

Trainer';
--   Summon Voidwalker
REPLACE INTO `npc_trainer` SELECT `entry`, '697', '200', '0', '0', '10'  FROM `creature_template` WHERE   

`subname`='Warlock Trainer';
--   Summon Succubus
REPLACE INTO `npc_trainer` SELECT `entry`, '712', '3000', '0', '0', '20'  FROM `creature_template` WHERE   

`subname`='Warlock Trainer';
--   Summon Felhunter
REPLACE INTO `npc_trainer` SELECT `entry`, '691', '40000', '0', '0', '30'  FROM `creature_template` WHERE   

`subname`='Warlock Trainer';
--   Summon Felsteed
REPLACE INTO `npc_trainer` SELECT `entry`, '5784', '200000', '0', '0', '40'  FROM `creature_template` WHERE   

`subname`='Warlock Trainer';
--   Summon Infernal
REPLACE INTO `npc_trainer` SELECT `entry`, '1122', '60000', '0', '0', '50'  FROM `creature_template` WHERE   

`subname`='Warlock Trainer';
--   Ritual of Doom
REPLACE INTO `npc_trainer` SELECT `entry`, '18540', '70000', '0', '0', '60'  FROM `creature_template` WHERE   

`subname`='Warlock Trainer';
--   Summon Dreadsteed
REPLACE INTO `npc_trainer` SELECT `entry`, '23161', '1000000', '0', '0', '60'  FROM `creature_template` WHERE   

`subname`='Warlock Trainer';

-- WARRIOR
--   Defencive Stance
REPLACE INTO `npc_trainer` SELECT `entry`, '71', '200', '0', '0', '10'  FROM `creature_template` WHERE   

`subname`='Warrior Trainer';
--   Berserker Stance
REPLACE INTO `npc_trainer` SELECT `entry`, '2458', '20000', '0', '0', '40'  FROM `creature_template` WHERE   

`subname`='Warrior Trainer';
--   Intercept RANK1
REPLACE INTO `npc_trainer` SELECT `entry`, '20252', '20000', '0', '0', '40'  FROM `creature_template` WHERE   

`subname`='Warrior Trainer';

-- Rogue
--   Poisons
REPLACE INTO `npc_trainer` SELECT `entry`, '2842', '20000', '0', '0', '10'  FROM `creature_template` WHERE   

`subname`='Rogue Trainer';
--   Instant Poison
REPLACE INTO `npc_trainer` SELECT `entry`, '8681', '20000', '0', '0', '10'  FROM `creature_template` WHERE   

`subname`='Rogue Trainer';

-- Hunter
--   Tame Beast
REPLACE INTO `npc_trainer` SELECT `entry`, '1515', '20000', '0', '0', '10'  FROM `creature_template` WHERE   

`subname`='Hunter Trainer';
--   Feed Pet
REPLACE INTO `npc_trainer` SELECT `entry`, '6991', '20000', '0', '0', '10'  FROM `creature_template` WHERE   

`subname`='Hunter Trainer';
--   Call Pet
REPLACE INTO `npc_trainer` SELECT `entry`, '883', '20000', '0', '0', '10'  FROM `creature_template` WHERE   

`subname`='Hunter Trainer';
--   Dismiss Pet
REPLACE INTO `npc_trainer` SELECT `entry`, '2641', '20000', '0', '0', '10'  FROM `creature_template` WHERE   

`subname`='Hunter Trainer';
--   Beast Training
REPLACE INTO `npc_trainer` SELECT `entry`, '5149', '20000', '0', '0', '10'  FROM `creature_template` WHERE   

`subname`='Hunter Trainer';

-- Mage

-- Priest

-- Shaman
--   Healing Stream Totem
REPLACE INTO `npc_trainer` SELECT `entry`, '5394', '20000', '0', '0', '70'  FROM `creature_template` WHERE   

`subname`='Shaman Trainer';
--   Searing Totem
REPLACE INTO `npc_trainer` SELECT `entry`, '3599', '20000', '0', '0', '70'  FROM `creature_template` WHERE   

`subname`='Shaman Trainer';
--   Stoneskin Totem
REPLACE INTO `npc_trainer` SELECT `entry`, '8071', '20000', '0', '0', '70'  FROM `creature_template` WHERE   
`subname`='Shaman Trainer';