From 420732e961e2577c8a5b0053ab0169142f0b47ec Mon Sep 17 00:00:00 2001 From: Dr-J Date: Mon, 28 Aug 2017 15:32:55 +0100 Subject: DB/Misc: Kirin Tor Spirits force reaction Abjurist Belmara, Cohlien Frostweaver, Conjurer Luminrath and Battle-Mage Dathric each should become neutral to players once there associated quest is rewarded --- sql/updates/world/3.3.5/2017_08_28_00_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_08_28_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2017_08_28_00_world.sql b/sql/updates/world/3.3.5/2017_08_28_00_world.sql new file mode 100644 index 00000000000..931a9c44513 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_08_28_00_world.sql @@ -0,0 +1,6 @@ +DELETE FROM `spell_area` WHERE `spell` BETWEEN 36216 AND 36219; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES +(36217, 3934, 10305, 0, 0, 0, 2, 1, 64, 11), +(36218, 3934, 10306, 0, 0, 0, 2, 1, 64, 11), +(36219, 3934, 10307, 0, 0, 0, 2, 1, 64, 11), +(36216, 3924, 10182, 0, 0, 0, 2, 1, 64, 11); -- cgit v1.2.3