aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2016-05-31 16:19:01 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-01-11 22:55:08 +0100
commit0778bed81ca134988dc88177ee12944e581d0b57 (patch)
tree23bf7118fffd4385541bc2e3f45338f8daf1d550
parent08970429986882690b94975d1e8940e9ca16e28e (diff)
DB/Creature: Fix positions and movements type for Explorers' League Researcher and Chief Archaeologist Letoll
(cherry picked from commit ebb4cca6d33d25f7e52e0595dc67a07efe05d173)
-rw-r--r--sql/updates/world/master/2017_01_11_05_world_2016_05_31_00_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_01_11_05_world_2016_05_31_00_world.sql b/sql/updates/world/master/2017_01_11_05_world_2016_05_31_00_world.sql
new file mode 100644
index 00000000000..29a29413167
--- /dev/null
+++ b/sql/updates/world/master/2017_01_11_05_world_2016_05_31_00_world.sql
@@ -0,0 +1,6 @@
+--
+UPDATE `creature` SET `position_x`= -3739.09, `position_y`= 5405.21, `position_z`=-3.33350, `orientation`=2.70103, `MovementType`=0, `spawndist`=0 WHERE `guid`=78837 AND `id`=22464;
+UPDATE `creature` SET `position_x`= -3743.46, `position_y`= 5403.87, `position_z`=-3.33635, `orientation`=1.16950, `MovementType`=0, `spawndist`=0 WHERE `guid`=78838 AND `id`=22464;
+UPDATE `creature` SET `position_x`= -3746.42, `position_y`= 5405.33, `position_z`=-3.33737, `orientation`=0.39587, `MovementType`=0, `spawndist`=0 WHERE `guid`=78839 AND `id`=22464;
+UPDATE `creature` SET `position_x`= -3750.65, `position_y`= 5408.94, `position_z`=-3.33391, `orientation`=2.54786, `MovementType`=0, `spawndist`=0 WHERE `guid`=78840 AND `id`=22464;
+UPDATE `creature` SET `position_x`= -3741.11, `position_y`= 5403.61, `position_z`=-3.33493, `orientation`=1.9117 WHERE `guid`=78818 AND `id`=22458;