diff options
| author | Killyana <morphone1@gmail.com> | 2019-05-24 00:27:33 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2019-05-24 00:27:33 +0200 |
| commit | 142cefdfd703045a11c1130e4b525602583e63f8 (patch) | |
| tree | 7af7b9860c7bd29dbb02992edd429b0407498002 | |
| parent | e06521a9b550048d5437334482a1026e83b9fd29 (diff) | |
DB/GameObject: Fix wrong rotations
Closes #23306
| -rw-r--r-- | sql/updates/world/3.3.5/2019_05_23_01_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_05_23_01_world.sql b/sql/updates/world/3.3.5/2019_05_23_01_world.sql new file mode 100644 index 00000000000..16a6dc23b0b --- /dev/null +++ b/sql/updates/world/3.3.5/2019_05_23_01_world.sql @@ -0,0 +1,9 @@ +-- +UPDATE `gameobject_addon` SET `parent_rotation0`=0.022059, `parent_rotation1`=0.255141, `parent_rotation2`=-0.804415, `parent_rotation3`=0.536035 WHERE `guid`=33382; +UPDATE `gameobject` SET `orientation`=-2.03331, `rotation0`=0.022059, `rotation1`=0.255141, `rotation2`=-0.804415, `rotation3`=0.536035 WHERE `guid`=33382; +UPDATE `gameobject` SET `rotation2`=0.588741, `rotation3`=0.808322 WHERE `id` IN (1620,1621,1622,1623,1624,1628,2041,2042,2043,2044,2045,2046,142140,142144,181280,181281,185966,186221,186234,186615,186614) AND `rotation1`=0 AND `rotation2`=0; +UPDATE `gameobject` SET `rotation2`=-0.0348994, `rotation3`=0.999391 WHERE `guid` IN (66913, 66922, 43071,91,93,97,99,101,103,111,113,115,390,392,388,407); +UPDATE `gameobject` SET `rotation2`=-0.308554, `rotation3`=0.951207 WHERE `guid` IN (5255); +UPDATE `gameobject` SET `rotation2`=-0.726538, `rotation3`=0.687126 WHERE `guid` IN (80); +UPDATE `gameobject` SET `orientation`=5.121037, `rotation0`=0.5910511, `rotation1`=-0.3881464, `rotation2`=-0.3881464, `rotation3`=0.5910528 WHERE `guid` IN (25025); +UPDATE `gameobject_addon` SET `parent_rotation0`=0, `parent_rotation1`=0, `parent_rotation2`=-0.5489231, `parent_rotation3`=0.8358729 WHERE `guid`=25025; |