From 7c498a0cf960b43b6974d99f0cf265911c296711 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Sun, 27 Jul 2014 15:03:22 +0100 Subject: DB/Misc: Fix some spell area issues Add spell area entries so some spells get removed when players leaves zone where its intended to be used: - Closes #12669 Also fixes imbued scourge shroud http://www.wowhead.com/item=34782/imbued-scourge-shroud so the aura gets removed when player leaves the Temple City of En'kilah. --- sql/updates/world/2014_07_27_03_world_misc.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/2014_07_27_03_world_misc.sql diff --git a/sql/updates/world/2014_07_27_03_world_misc.sql b/sql/updates/world/2014_07_27_03_world_misc.sql new file mode 100644 index 00000000000..6acbe68e67f --- /dev/null +++ b/sql/updates/world/2014_07_27_03_world_misc.sql @@ -0,0 +1,8 @@ +DELETE FROM `spell_area` WHERE `spell` IN(48763,48761, 45614); +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES +(48763, 4180, 12274, 0, 0, 0, 0, 0, 74, 11), +(48761, 4180, 12274, 0, 0, 0, 1, 0, 74, 11), +(45614, 4125, 11633, 0, 0, 0, 2, 0, 74, 11), +(45614, 4135, 11633, 0, 0, 0, 2, 0, 74, 11), +(45614, 4136, 11633, 0, 0, 0, 2, 0, 74, 11), +(45614, 4137, 11633, 0, 0, 0, 2, 0, 74, 11); -- cgit v1.2.3