diff options
| author | Killyana <morphone1@gmail.com> | 2016-07-04 00:05:39 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-04 20:17:45 +0100 |
| commit | 530177b32e40ced74238555c7c432d54aec7ca08 (patch) | |
| tree | 649a6fdef8b19dcfd752356e10c40d14e3c9a7bc | |
| parent | d205c8805918e17b98182ef977dc820b69b9fcfc (diff) | |
DB/Object: Add a missing spawn for Pure Saronite Deposit and fix spawnmask and respawn time
(cherry picked from commit f191471a8af92169e15d3429d1db52faef774e93)
| -rw-r--r-- | sql/updates/world/master/2017_02_04_12_world_2016_07_04_00_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_04_12_world_2016_07_04_00_world.sql b/sql/updates/world/master/2017_02_04_12_world_2016_07_04_00_world.sql new file mode 100644 index 00000000000..963381006fb --- /dev/null +++ b/sql/updates/world/master/2017_02_04_12_world_2016_07_04_00_world.sql @@ -0,0 +1,6 @@ +-- +SET @GUID =6028; +UPDATE `gameobject` SET `spawnMask`=24, `spawntimesecs`=604800 WHERE `guid`=55974; +DELETE FROM `gameobject` WHERE `guid`=@GUID; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`PhaseId`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`)VALUES +(@GUID, 195036, 603, 24, 0, 1757.896, 87.201, 342.384, 0.649495, 0, 0, 0, 1, 604800, 255, 1); |