From 5d7cc696b83f058c440e287d731df286e191f8d6 Mon Sep 17 00:00:00 2001 From: Killyana Date: Tue, 29 Dec 2015 16:57:10 +0100 Subject: DB: Fix spawn position and equipment for Coilfang Engineers By @Saben65 Closes #16104 (cherry picked from commit 17b57453c1082659f28f2bf3d20678f842f9c953) --- sql/updates/world/2016_01_17_07_world_2015_12_29_03.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/2016_01_17_07_world_2015_12_29_03.sql (limited to 'sql') diff --git a/sql/updates/world/2016_01_17_07_world_2015_12_29_03.sql b/sql/updates/world/2016_01_17_07_world_2015_12_29_03.sql new file mode 100644 index 00000000000..f928061c269 --- /dev/null +++ b/sql/updates/world/2016_01_17_07_world_2015_12_29_03.sql @@ -0,0 +1,4 @@ +-- +UPDATE `creature` SET `position_x`=-5.298958, `position_y`=-131.3911, `position_z`=-21.17339, `orientation`=4.817109 WHERE `guid`= 12686 AND `id`=17721; +UPDATE `creature` SET `position_x`=-21.93356, `position_y`=-126.7303, `position_z`=-21.71569, `orientation`=4.939282 WHERE `guid`= 12687 AND `id`=17721; +UPDATE `creature_equip_template` SET `ItemID1`=1903 WHERE `CreatureID`=17721; -- cgit v1.2.3