diff options
-rw-r--r-- | sql/updates/world/master/2021_11_21_13_world_2019_01_12_04_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_21_13_world_2019_01_12_04_world.sql b/sql/updates/world/master/2021_11_21_13_world_2019_01_12_04_world.sql new file mode 100644 index 00000000000..e9eaca1b7db --- /dev/null +++ b/sql/updates/world/master/2021_11_21_13_world_2019_01_12_04_world.sql @@ -0,0 +1,16 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (78261,78316,95044,95045,95046,95047,95048,95050,95054,95055,95075,95095,95096); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(78261, 23076, 530, '0', 0, 0, 0, 1715.417, 7374.241, 370.0128, 5.81194600, 300, 0, 0, 22140, 0, 0), +(78316, 23076, 530, '0', 0, 0, 0, 1694.253, 7338.044, 369.5446, 5.65486700, 300, 0, 0, 22140, 0, 0), +(95044, 23076, 530, '0', 0, 0, 0, 1636.504, 7245.440, 369.8836, 0.50614550, 300, 0, 0, 22140, 0, 0), +(95045, 23076, 530, '0', 0, 0, 0, 1656.308, 7199.548, 368.9315, 6.26573200, 300, 0, 0, 22140, 0, 0), +(95046, 23076, 530, '0', 0, 0, 0, 1528.355, 7304.675, 367.1246, 0.80285140, 300, 0, 0, 22140, 0, 0), +(95047, 23076, 530, '0', 0, 0, 0, 1523.460, 7212.831, 370.0293, 5.65486700, 300, 0, 0, 22140, 0, 0), +(95048, 23076, 530, '0', 0, 0, 0, 1442.228, 7297.830, 374.5757, 2.19911500, 300, 0, 0, 22140, 0, 0), +(95050, 23076, 530, '0', 0, 0, 0, 1443.995, 7222.110, 369.9049, 2.94960600, 300, 0, 0, 22140, 0, 0), +(95054, 23076, 530, '0', 0, 0, 0, 1412.815, 7367.326, 370.1187, 2.42600800, 300, 0, 0, 22140, 0, 0), +(95055, 23076, 530, '0', 0, 0, 0, 1339.129, 7305.414, 369.4936, 3.17649900, 300, 0, 0, 22140, 0, 0), +(95075, 23076, 530, '0', 0, 0, 0, 1348.385, 7216.743, 375.0200, 1.04719800, 300, 0, 0, 22140, 0, 0), +(95095, 23076, 530, '0', 0, 0, 0, 1362.472, 7166.314, 371.3114, 5.96902600, 300, 0, 0, 22140, 0, 0), +(95096, 23076, 530, '0', 0, 0, 0, 1311.723, 7175.860, 371.9400, 3.57792500, 300, 0, 0, 22140, 0, 0); |