Stuff

// blood elves
INSERT INTO npc_trainer
  (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel)
VALUES
  (16280, 33389, 900000, 0, 0, 40);

INSERT INTO npc_trainer
  (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel)
VALUES
  (16280, 33392, 9000000, 762, 75, 60);
// draenai
INSERT INTO npc_trainer
  (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel)
VALUES
  (20914, 33389, 900000, 0, 0, 40);

INSERT INTO npc_trainer
  (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel)
VALUES
  (20914, 33392, 9000000, 762, 75, 60);
DELETE FROM `creature`template` WHERE `entry` IN (16280, 20914);
INSERT INTO creature_template
  (entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, mount, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, ScriptName)
VALUES
  (16280, 16712, 0, "Perascamin", "Riding Instructor", 45, 45, 300, 300, 0, 0, 20, 35, 16, "1,48", 0, 0, 0, 100, 1400, 1900, 0, 0, 0, 1, 0, 2, 1, 0, 0, 10, 0, 0, 100, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16280, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 1, "");
INSERT INTO creature_template
  (entry, modelid_m, modelid_f, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg, maxdmg, attackpower, baseattacktime, rangeattacktime, flags, mount, dynamicflags, size, family, bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2, equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, ScriptName)
VALUES
  (20914, 16726, 0, "Aalun", "Riding Instructor", 45, 45, 300, 300, 0, 0, 20, 1638, 19, "1,48", 0, 0, 0, 100, 1400, 1900, 0, 0, 0, 1, 0, 2, 1, 0, 0, 11, 0, 0, 100, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20914, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 1, "");