aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2016-06-27 16:46:56 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-02-04 18:01:31 +0100
commit6aa4804dac9fdae81276c52417ac5331f81efa05 (patch)
treeb3a061ce689905a097236b889757b0cb41cc8131
parent48480f63fe8ef971fd6fd1ea355b81a45bfdf9e0 (diff)
DB/Object: Remove double spawns related to Midsummer Fire Festival
(cherry picked from commit 832ed3bcfcf30cfb8ccd0cc0bd915329dddb9753)
-rw-r--r--sql/updates/world/master/2017_02_04_07_world_2016_06_27_00_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_04_07_world_2016_06_27_00_world.sql b/sql/updates/world/master/2017_02_04_07_world_2016_06_27_00_world.sql
new file mode 100644
index 00000000000..d84c8158542
--- /dev/null
+++ b/sql/updates/world/master/2017_02_04_07_world_2016_06_27_00_world.sql
@@ -0,0 +1,3 @@
+--
+DELETE FROM `gameobject` WHERE `guid` IN (165009,165010,165012,165013,165014,165015,165016,165019,165020,165021,165022,165023,165024,165025,165026,165027,165028,165029,165030,165031,165032,165033);
+UPDATE `gameobject` SET `position_x`=2019.6999, `position_y`=6587.1401, `position_z`=134.985001, `orientation`=6.237050 WHERE `guid`=70594;