diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2016-06-20 21:53:53 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-06-20 21:53:53 +0200 |
| commit | 5f2c62392cadc3b87816a5330bbd573e95c9326c (patch) | |
| tree | c83b9e7b6dc9cd92273782fb05acf6d88c4ded7c | |
| parent | 688635ff9280ebece98d74ded5ed1f3c618718c0 (diff) | |
Update 2016_06_20_01_world.sql
| -rw-r--r-- | sql/updates/world/6.x/2016_06_20_01_world.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/updates/world/6.x/2016_06_20_01_world.sql b/sql/updates/world/6.x/2016_06_20_01_world.sql index 6782bf7bfd5..35c5bf01c16 100644 --- a/sql/updates/world/6.x/2016_06_20_01_world.sql +++ b/sql/updates/world/6.x/2016_06_20_01_world.sql @@ -12,7 +12,7 @@ SET @TIMER := 30; -- Respawn timer in seconds DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID1 AND @OGUID1+@LASTGUID; DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID2 AND @OGUID2+@LASTGUID; DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID3 AND @OGUID3+@LASTGUID; -INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES -- Mithril Deposits (@OGUID1+0,2040,1,1,1,0,3518.36,-1096.71,230.29,4.485497,0,0,0,1, @TIMER, 255, 1), (@OGUID1+1,2040,1,1,1,0,3532.12,-1080.09,234.065,4.485497,0,0,0,1, @TIMER, 255, 1), @@ -1427,3 +1427,5 @@ INSERT INTO `pool_pool` (`pool_id`,`mother_pool`,`chance`,`description`) VALUES (@POOL+171,@MOTHER,0, 'Felwood Ore Spawnpoint'), (@POOL+172,@MOTHER,0, 'Felwood Ore Spawnpoint'), (@POOL+173,@MOTHER,0, 'Felwood Ore Spawnpoint'); + +UPDATE `gameobject` SET `PhaseId`=169 WHERE `PhaseId`=1; |