Paladin, Warlock and Druid mount

public sql v1 · immutable
#1544985
·published 2009-08-27 19:36 UTC
-- CleanupDELETE 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 61INSERT 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 61INSERT 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 61INSERT 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);-- DruidDELETE 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 68INSERT 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 71INSERT 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);