From 3314c8f11308df6c411801afcd2d74fb84b14d0d Mon Sep 17 00:00:00 2001 From: SnapperRy Date: Fri, 15 Jul 2016 14:31:55 +0200 Subject: DB/SpellArea: prevent access to Hyjal By dr-j, closes #17467 --- sql/updates/world/3.3.5/2016_07_15_03_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_07_15_03_world.sql (limited to 'sql/updates/world') 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); -- cgit v1.2.3