aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-01-07 14:14:53 +0100
committerKillyana <morphone1@gmail.com>2017-01-07 14:14:53 +0100
commitf3462659f006a9c515c2ccdc1dabcdec21497a17 (patch)
tree65fbd124230b0e7eee948dfe9186ad0fc20812c4
parentebfa8d1648266a37152c95ee8558f90178e90939 (diff)
DB: At The Enemy's Gates - Phasing
Closes #18751 Closes #15540 By Rushor
-rw-r--r--sql/updates/world/3.3.5/2017_01_07_01_world.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_01_07_01_world.sql b/sql/updates/world/3.3.5/2017_01_07_01_world.sql
new file mode 100644
index 00000000000..aab0fa7d962
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_01_07_01_world.sql
@@ -0,0 +1,13 @@
+-- At The Enemy's Gates - Phasing for Icecrown -- http://www.wowhead.com/quest=13847/at-the-enemys-gates
+DELETE FROM `spell_area` WHERE `quest_start` IN (13847, 13851, 13852, 13854, 13855, 13856, 13857, 13858, 13859, 13860) AND `area`=4522;
+INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES
+(64576, 4522, 13847, 13847, 0, 0, 2, 1, 74, 11),
+(64576, 4522, 13851, 13851, 0, 0, 2, 1, 74, 11),
+(64576, 4522, 13852, 13852, 0, 0, 2, 1, 74, 11),
+(64576, 4522, 13854, 13854, 0, 0, 2, 1, 74, 11),
+(64576, 4522, 13855, 13855, 0, 0, 2, 1, 74, 11),
+(64576, 4522, 13856, 13856, 0, 0, 2, 1, 74, 11),
+(64576, 4522, 13857, 13857, 0, 0, 2, 1, 74, 11),
+(64576, 4522, 13858, 13858, 0, 0, 2, 1, 74, 11),
+(64576, 4522, 13859, 13859, 0, 0, 2, 1, 74, 11),
+(64576, 4522, 13860, 13860, 0, 0, 2, 1, 74, 11);