aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-07-15 14:31:55 +0200
committerGitHub <noreply@github.com>2016-07-15 14:31:55 +0200
commit3314c8f11308df6c411801afcd2d74fb84b14d0d (patch)
treee14f16dbe616b72846caa94dba7bec9e4f23237b
parentab0c7f745cb4ae97de7018ed379f7ca8fa4b7855 (diff)
DB/SpellArea: prevent access to Hyjal
By dr-j, closes #17467
-rw-r--r--sql/updates/world/3.3.5/2016_07_15_03_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_07_15_03_world.sql b/sql/updates/world/3.3.5/2016_07_15_03_world.sql
new file mode 100644
index 00000000000..b7a19638541
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_07_15_03_world.sql
@@ -0,0 +1,8 @@
+--
+DELETE FROM `spell_target_position` WHERE `ID`=42200;
+INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `VerifiedBuild`) VALUES
+(42200, 0, 1, 5010.165039, -4554.938965, 852.146362, 0.883979, 0);
+
+DELETE FROM `spell_area` WHERE `spell`=42202;
+INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES
+(42202, 616, 0, 0, 0, 0, 2, 1, 64, 11);