diff options
| -rw-r--r-- | sql/updates/world/master/2021_12_20_20_world_2020_01_18_01_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_20_20_world_2020_01_18_01_world.sql b/sql/updates/world/master/2021_12_20_20_world_2020_01_18_01_world.sql new file mode 100644 index 00000000000..4aeaa1354bf --- /dev/null +++ b/sql/updates/world/master/2021_12_20_20_world_2020_01_18_01_world.sql @@ -0,0 +1,8 @@ +-- +DELETE FROM `creature` WHERE `guid` IN(200010,200008) AND `id` IN (29057,29069); +DELETE FROM `spawn_group` WHERE `spawnId` IN (200010,200008) AND `spawnType`=0; +UPDATE `creature` SET `position_x`=6232.26, `position_y`=4944.96, `position_z`=-98.8431, `orientation`=3.43397, `spawndist`=0, `MovementType`=0 WHERE `guid`=115122; +UPDATE `creature` SET `position_x`=6241.88, `position_y`=4953.22, `position_z`=-98.7876, `orientation`=3.57534, `spawndist`=0, `MovementType`=0 WHERE `guid`=115126; +UPDATE `creature` SET `position_x`=6222.05, `position_y`=4943.04, `position_z`=-98.8662, `orientation`=3.62246, `spawndist`=0, `MovementType`=0 WHERE `guid`=115196; +UPDATE `creature` SET `position_x`=6203.99, `position_y`=4966.64, `position_z`=-98.9068, `orientation`=4.27041, `spawndist`=0, `MovementType`=0 WHERE `guid`=115136; +UPDATE `creature` SET `position_x`=6212.96, `position_y`=4974.03, `position_z`=-98.8272, `orientation`=4.08192, `spawndist`=0, `MovementType`=0 WHERE `guid`=115192; |