diff options
| author | Killyana <morphone1@gmail.com> | 2019-03-08 17:41:24 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-11-24 21:16:45 +0100 |
| commit | 211dd34d1e780f78e89731d66745bad782babe96 (patch) | |
| tree | a6e38d4ead13a31364b3c7760643680ba5b158d6 | |
| parent | e61266815ff0b30d3aa6c6df9b1282bb45321061 (diff) | |
DB/GameObjects: Add missing gobs to Molten Core
(cherry picked from commit 63c12c1babfe7843e9487557934005490bbc9a27)
| -rw-r--r-- | sql/updates/world/master/2021_11_24_27_world_2019_03_08_01_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_24_27_world_2019_03_08_01_world.sql b/sql/updates/world/master/2021_11_24_27_world_2019_03_08_01_world.sql new file mode 100644 index 00000000000..1ac2fbd1c39 --- /dev/null +++ b/sql/updates/world/master/2021_11_24_27_world_2019_03_08_01_world.sql @@ -0,0 +1,7 @@ +-- +UPDATE `gameobject` SET `position_x`= 756.897, `position_y`= -1180.7, `position_z`= -118.596, `orientation`= 2.91469, `rotation2`=0.993571, `rotation3`=0.113208 WHERE `id`= 179703; +DELETE FROM `gameobject` WHERE `guid` IN (7085,7091,7098); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(7085, 178194, 409, '9,18', 0, 765.562, -995.398, -197.221, 2.19912, 0, 0, 0.891008, 0.453988, 604800, 255, 1), +(7091, 178107, 409, '9,18', 0, 838.951, -830.383, -230.206, 0.837757, 0, 0, 0.406736, 0.913546, 604800, 255, 1), +(7098, 178108, 409, '9,18', 0, 839.279, -831.058, -230.202, -1.37881, 0, 0, -0.636078, 0.771625, 604800, 255, 1); |