From f3462659f006a9c515c2ccdc1dabcdec21497a17 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sat, 7 Jan 2017 14:14:53 +0100 Subject: DB: At The Enemy's Gates - Phasing Closes #18751 Closes #15540 By Rushor --- sql/updates/world/3.3.5/2017_01_07_01_world.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_01_07_01_world.sql (limited to 'sql/updates') 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); -- cgit v1.2.3