diff options
| author | Killyana <morphone1@gmail.com> | 2015-12-29 16:57:10 +0100 |
|---|---|---|
| committer | MitchesD <majklprofik@seznam.cz> | 2016-01-17 13:57:13 +0100 |
| commit | 5d7cc696b83f058c440e287d731df286e191f8d6 (patch) | |
| tree | b93278e5d0a381804a859db2059c0f803a8bffde | |
| parent | c9f6bea60d0c93af7a329148994cc5d077fb4d1f (diff) | |
DB: Fix spawn position and equipment for Coilfang Engineers
By @Saben65
Closes #16104
(cherry picked from commit 17b57453c1082659f28f2bf3d20678f842f9c953)
| -rw-r--r-- | sql/updates/world/2016_01_17_07_world_2015_12_29_03.sql | 4 |
1 files changed, 4 insertions, 0 deletions
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; |