Paladin and Warlock - Lvl 30-61

public sql v1 · immutable
#1531913
·published 2009-08-16 22:39 UTC
--CleanupDELETE FROM `spell_learn_spell` WHERE `entry` IN (5784,13819,23161,23214,34767,34769);DELETE FROM `npc_trainer` WHERE `spell` IN (5784,13819,23161,23214,34767,34769);--Paladin--BloodElf--Lvl 30INSERT 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 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 30INSERT 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 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 30INSERT 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 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);