aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2019-03-19 18:39:54 +0100
committerShauren <shauren.trinity@gmail.com>2021-11-24 22:38:37 +0100
commit5594be74b2259e81772eab686774fa0960b7393d (patch)
treef04fec7ca125bcaa22395f20545f08eb9fddb38e
parent32f51f30ece78894d0fc657e320676ef46c6522a (diff)
DB/GameObjects: Fix some WinterGrasp Banner position
(cherry picked from commit e1e3a9cab81b20dc87882e911c6bc6748640fa5f)
-rw-r--r--sql/updates/world/master/2021_11_24_40_world_2019_03_19_01_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_24_40_world_2019_03_19_01_world.sql b/sql/updates/world/master/2021_11_24_40_world_2019_03_19_01_world.sql
new file mode 100644
index 00000000000..4d6ed103c44
--- /dev/null
+++ b/sql/updates/world/master/2021_11_24_40_world_2019_03_19_01_world.sql
@@ -0,0 +1,4 @@
+--
+UPDATE `gameobject` SET `position_x`=4387.62, `position_y`=2719.57, `position_z`=389.935, `orientation`=-1.54462, `rotation2`=-0.697792, `rotation3`=0.716301, `state`=1 WHERE `guid`=75191 AND `id`=192450;
+UPDATE `gameobject` SET `position_y`=2717.070068, `orientation`=-1.54462, `rotation2`=-0.697792, `rotation3`=0.716301, `state`=1 WHERE `guid` IN (75179,75190);
+UPDATE `gameobject` SET `orientation`=-1.54462, `rotation2`=-0.704015, `state`=1 WHERE `guid`=75186 AND `id`=192441;