aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-01-07 14:14:53 +0100
committerShauren <shauren.trinity@gmail.com>2019-07-21 21:06:54 +0200
commite51550b1eb394fd608b86a28d559d4af8c57e6f5 (patch)
tree929c35ed9ad75ce82e8948f31be2cb0d1a97f72b
parent80545b1a8454b78a2f61c6ce3a1b89de91b5de43 (diff)
DB: At The Enemy's Gates - Phasing
Closes #18751 Closes #15540 By Rushor (cherrypicked from f3462659f006a9c515c2ccdc1dabcdec21497a17)
-rw-r--r--sql/updates/world/master/2019_06_20_03_world_2017_01_07_01_world.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2019_06_20_03_world_2017_01_07_01_world.sql b/sql/updates/world/master/2019_06_20_03_world_2017_01_07_01_world.sql
new file mode 100644
index 00000000000..605958a7e4e
--- /dev/null
+++ b/sql/updates/world/master/2019_06_20_03_world_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`, `flags`, `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);