aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/master/2021_11_21_13_world_2019_01_12_04_world.sql16
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);