diff options
| author | Killyana <morphone1@gmail.com> | 2019-03-08 17:41:24 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2019-03-08 17:41:24 +0100 |
| commit | 63c12c1babfe7843e9487557934005490bbc9a27 (patch) | |
| tree | 6e1d895c7abe26e8817401b7302f7a788cb003aa | |
| parent | a00636261570c7e053ec4ed0844c196b10529978 (diff) | |
DB/GameObjects: Add missing gobs to Molten Core
| -rw-r--r-- | sql/updates/world/3.3.5/2019_03_08_01_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_03_08_01_world.sql b/sql/updates/world/3.3.5/2019_03_08_01_world.sql new file mode 100644 index 00000000000..c7bb55140b3 --- /dev/null +++ b/sql/updates/world/3.3.5/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`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(7085, 178194, 409, 1, 1, 765.562, -995.398, -197.221, 2.19912, 0, 0, 0.891008, 0.453988, 604800, 255, 1), +(7091, 178107, 409, 1, 1, 838.951, -830.383, -230.206, 0.837757, 0, 0, 0.406736, 0.913546, 604800, 255, 1), +(7098, 178108, 409, 1, 1, 839.279, -831.058, -230.202, -1.37881, 0, 0, -0.636078, 0.771625, 604800, 255, 1); |