aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKittnz <frederik156@hotmail.com>2015-11-11 01:22:54 +0100
committerMitchesD <majklprofik@seznam.cz>2016-01-13 11:36:05 +0100
commiteb5d8d0da231d688bdefc4170fbe866ce7d879fd (patch)
tree40dff5d1cac502089433809af279f2c77a352339
parent7b17f0a3d65458f058da439256e6fc9ed1c18b64 (diff)
DB/Object: Add general spawns missing in Northrend
(cherry picked from commit 9e2330f5756917720685fe29c9a65da843227917)
-rw-r--r--sql/updates/world/2016_01_13_00_world_2015_11_11_00.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2016_01_13_00_world_2015_11_11_00.sql b/sql/updates/world/2016_01_13_00_world_2015_11_11_00.sql
new file mode 100644
index 00000000000..b4c8989c213
--- /dev/null
+++ b/sql/updates/world/2016_01_13_00_world_2015_11_11_00.sql
@@ -0,0 +1,6 @@
+SET @OGUID:=6354;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+2;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
+(@OGUID+0, 185454, 571, 1, 169, 5491.154, -2652.184, 303.9539, 2.460913, 0, 0, 0, 1, 120, 255, 1), -- 185454 (Area: 4275)
+(@OGUID+1, 185456, 571, 1, 169, 3393.345, -2801.472, 211.3246, 5.410522, 0, 0, 0, 1, 120, 255, 1), -- 185456 (Area: 0)
+(@OGUID+2, 185434, 571, 1, 169, 5527.56, -2646.927, 303.9539, 2.600535, 0, 0, 0, 1, 120, 255, 1); -- 185434 (Area: 4275)