From f191471a8af92169e15d3429d1db52faef774e93 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Mon, 4 Jul 2016 00:05:39 +0200
Subject: DB/Object: Add a missing spawn for Pure Saronite Deposit and fix
 spawnmask and respawn time

---
 sql/updates/world/3.3.5/2016_07_04_00_world.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2016_07_04_00_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2016_07_04_00_world.sql b/sql/updates/world/3.3.5/2016_07_04_00_world.sql
new file mode 100644
index 00000000000..d5c0e5fc05d
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_07_04_00_world.sql
@@ -0,0 +1,6 @@
+-- 
+SET @GUID  =6028;
+UPDATE `gameobject` SET `spawnMask`=3, `spawntimesecs`=604800 WHERE `guid`=55974;
+DELETE FROM `gameobject` WHERE `guid`=@GUID;
+INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`)VALUES 
+(@GUID, 195036, 603, 3, 1, 1757.896, 87.201, 342.384, 0.649495, 0, 0, 0, 1, 604800, 255, 1);
-- 
cgit v1.2.3