diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2014-07-27 15:03:22 +0100 |
|---|---|---|
| committer | Dr-J <daniel.jarrott0@gmail.com> | 2014-07-27 15:03:22 +0100 |
| commit | 7c498a0cf960b43b6974d99f0cf265911c296711 (patch) | |
| tree | fda19e66cd716943891e94c5289476a3cb3660e9 | |
| parent | e77c0b6ed4516c09c648a6443b054b8b9e1edcf1 (diff) | |
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.
| -rw-r--r-- | sql/updates/world/2014_07_27_03_world_misc.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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); |