diff options
| author | CraftedRO <CraftedRO@users.noreply.github.com> | 2022-11-04 18:39:53 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2022-11-04 18:39:53 +0100 |
| commit | c65ba30fa48d98dd798ec0a1911709db93334f9c (patch) | |
| tree | 727c874b84f922a284f43adee5bc5aab255ffd12 | |
| parent | f2fcd6746c72930dc0a951521e2f0fe78ce02690 (diff) | |
DB/GameObject: Fix position and rotation of some signs
Coloses #27119
| -rw-r--r-- | sql/updates/world/3.3.5/2022_11_04_06_world.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2022_11_04_06_world.sql b/sql/updates/world/3.3.5/2022_11_04_06_world.sql new file mode 100644 index 00000000000..1d01d9086b8 --- /dev/null +++ b/sql/updates/world/3.3.5/2022_11_04_06_world.sql @@ -0,0 +1,22 @@ +-- Windshear Crag +UPDATE `gameobject` SET `position_x` = 603.94183, `position_y` = 326.38608, `position_z` = 47.201893, `rotation0` = -0.005131, `rotation1` = 0.078291, `rotation2` = 0.994783, `rotation3` = -0.065202 WHERE `guid` = 47454 AND `id` = 19563; +-- Sun Rock Retreat +UPDATE `gameobject` SET `position_x` = 602.85767, `position_y` = 327.26562, `position_z` = 45.518078, `rotation0` = 0.118016, `rotation1` = -0.007345, `rotation2` = 0.049178, `rotation3` = 0.991766 WHERE `guid` = 47456 AND `id` = 19565; +-- Desolace +UPDATE `gameobject` SET `position_x` = 602.7847, `position_y` = 327.06598, `position_z` = 44.975803, `rotation0` = 0.082431, `rotation1` = 0.015208, `rotation2` = 0.025001, `rotation3` = 0.996167 WHERE `guid` = 47457 AND `id` = 19566; +-- Greatwood Vale +UPDATE `gameobject` SET `position_x` = 603.01935, `position_y` = 325.8764, `position_z` = 46.724716, `rotation0` = 0.081867, `rotation1` = 0.084447, `rotation2` = 0.73833, `rotation3` = 0.664105 WHERE `guid` = 47455 AND `id` = 19564; +-- The Barrens +UPDATE `gameobject` SET `position_x` = 603.3596, `position_y` = 325.83636, `position_z` = 46.054432, `rotation0` = 0.034697, `rotation1` = 0.045045, `rotation2` = 0.741777, `rotation3` = 0.668232 WHERE `guid` = 47465 AND `id` = 19568; +-- Stonetalon Peak +UPDATE `gameobject` SET `position_x` = 602.7691, `position_y` = 327.69965, `position_z` = 44.49972, `rotation0` = 0.177768, `rotation1` = 0.00895, `rotation2` = 0.024983, `rotation3` = 0.983715 WHERE `guid` = 47459 AND `id` = 19567; +-- The Barrens +UPDATE `gameobject` SET `position_x` = 92.13162, `position_y` = -57.32769, `position_z` = 19.424181, `rotation0` = 0.063403, `rotation1` = 0.166318, `rotation2` = 0.910467, `rotation3` = 0.373321 WHERE `guid` = 47452 AND `id` = 19562; +-- Greatwood Vale +UPDATE `gameobject` SET `position_x` = 92.58941, `position_y` = -56.886936, `position_z` = 19.967966, `rotation0` = 0.019279, `rotation1` = 0.081575, `rotation2` = 0.921872, `rotation3` = 0.378319 WHERE `guid` = 47451 AND `id` = 19561; +-- Stonetalon Peak +UPDATE `gameobject` SET `position_x` = 92.43924, `position_y` = -55.479656, `position_z` = 21.116617, `rotation0` = 0.095253, `rotation1` = -0.043904, `rotation2` = -0.339276, `rotation3` = 0.934821 WHERE `guid` = 47450 AND `id` = 19560; +-- Sun Rock Retreat +UPDATE `gameobject` SET `position_x` = 92.32943, `position_y` = -55.554092, `position_z` = 21.601717, `rotation0` = 0.073728, `rotation1` = -0.026835, `rotation2` = -0.340966, `rotation3` = 0.936796 WHERE `guid` = 47449 AND `id` = 19559; +-- Windshear Crag +UPDATE `gameobject` SET `position_x` = 92.3087, `position_y` = -55.574978, `position_z` = 22.152306, `rotation0` = 0.073728, `rotation1` = -0.026835, `rotation2` = -0.340966, `rotation3` = 0.936796 WHERE `guid` = 47447 AND `id` = 19558; |