From 3f28fd304d833eadefff8d343ab45caf8d0575c2 Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 30 Jan 2015 23:58:16 +0100 Subject: Core/Spells: Reimplemented automatic spell learning * Fixed learning/unlearning talents --- sql/updates/world/2015_01_30_01_world.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/updates/world/2015_01_30_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2015_01_30_01_world.sql b/sql/updates/world/2015_01_30_01_world.sql new file mode 100644 index 00000000000..0b88e0d01d4 --- /dev/null +++ b/sql/updates/world/2015_01_30_01_world.sql @@ -0,0 +1,19 @@ +DELETE FROM `playercreateinfo_skills` WHERE `skill` IN (795,796,798,800,804,829,840,849,904,921,924); +INSERT INTO `playercreateinfo_skills` (`raceMask`,`classMask`,`skill`,`rank`,`comment`) VALUES +(0, 4, 795, 0, "Hunter skills."), +(0, 32, 796, 0, "Death Knight skills."), +(0, 1024, 798, 0, "Druid skills."), +(0, 2, 800, 0, "Paladin skills."), +(0, 16, 804, 0, "Priest skills."), +(0, 512, 829, 0, "Monk skills."), +(0, 1, 840, 0, "Warrior skills."), +(0, 256, 849, 0, "Warlock skills."), +(0, 128, 904, 0, "Mage skills."), +(0, 8, 921, 0, "Rogue skills."), +(0, 64, 924, 0, "Shaman skills."); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=127650; +INSERT INTO `spell_ranks` (`first_spell_id`,`spell_id`,`rank`) VALUES +(127650,127650,1), -- Remove Talent: Vanishing Powder +(127650,127649,2), -- Remove Talent: Dust of Disappearance +(127650,113873,3); -- Remove Talent: Tome of the Clear Mind -- cgit v1.2.3