diff options
| author | Killyana <morphone1@gmail.com> | 2016-07-04 00:05:39 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2016-07-04 00:05:39 +0200 |
| commit | f191471a8af92169e15d3429d1db52faef774e93 (patch) | |
| tree | 7a184a21a9d5601ca00840dda6c702ccf2ad02bb | |
| parent | d9755c637c39e600f145f5ecb7ff0ccf3724b1ad (diff) | |
DB/Object: Add a missing spawn for Pure Saronite Deposit and fix spawnmask and respawn time
| -rw-r--r-- | sql/updates/world/3.3.5/2016_07_04_00_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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); |