aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDr-J <daniel.jarrott0@gmail.com>2017-08-28 15:32:55 +0100
committerGitHub <noreply@github.com>2017-08-28 15:32:55 +0100
commit420732e961e2577c8a5b0053ab0169142f0b47ec (patch)
treeb76a1bf9324066e61dc83b2d899d7768152693b3
parent72aa03441f451c05f1a24415124e1ed32519fdde (diff)
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
-rw-r--r--sql/updates/world/3.3.5/2017_08_28_00_world.sql6
1 files changed, 6 insertions, 0 deletions
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);