DB/Misc: Death knights area rework part6

Original work done by Grz3s on Cmangos

(cherry picked from commit 123e8a95ba60b4706617da03eb047efadc32e0e9)

1 files changed, 140 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_02_18_02_world_2017_11_29_00_world.sql b/sql/updates/world/master/2021_02_18_02_world_2017_11_29_00_world.sql
new file mode 100644
index 00000000000..b4bef22d966
--- /dev/null
+++ b/sql/updates/world/master/2021_02_18_02_world_2017_11_29_00_world.sql
@@ -0,0 +1,140 @@
+-- Spawns that req. phaseMask (PhaseId)
+UPDATE `creature` SET `PhaseId` = 170 WHERE `id` IN (28559,28560, 28660,28662);  -- Citizen of Havenshire and Citizen of New Avalon
+UPDATE `creature` SET `PhaseId` = 170 WHERE `guid` = 128752; -- High General Abbendis
+UPDATE `creature` SET `PhaseId` = 170 WHERE `guid` IN (128796,129321); -- High Abbot Landgren
+UPDATE `creature` SET `PhaseId` = 170 WHERE `id` IN (28530, 28594);  -- Scarlet Commander Scarlet Preacher
+
+-- Havenshire Colt -- Havenshire Mare -- Havenshire Stallion
+DELETE FROM `creature` WHERE `guid` IN (84229,84234,84235,84239,84240,84257,84264,84265,84277,84279,84280,84281,84297,84315,84316,84317,84322,84336,84341,84342,84346,84347,84348,84349,84392,84393,84406);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `curhealth`, `curmana`, `MovementType`) VALUES
+(84229, 28605, 609, '0', 170, 2177.534, -5806.438, 101.4173, 3.543018, 120, 0, 2453, 0, 0),
+(84234, 28605, 609, '0', 170, 2221.63, -5881.24, 101.211, 4.74729, 120, 0, 2453, 0, 0),
+(84235, 28605, 609, '0', 170, 2206.62, -5840.55, 101.48, 1.43117, 120, 0, 2453, 0, 0),
+(84239, 28605, 609, '0', 170, 2209.9, -5840.27, 101.428, 2.35619, 120, 0, 2453, 0, 0),
+(84240, 28605, 609, '0', 170, 2204.79, -5840.43, 101.576, 1.13446, 120, 0, 2453, 0, 0),
+(84257, 28605, 609, '0', 170, 2199.98, -5871.52, 101.408, 4.34587, 120, 0, 2453, 0, 0),
+(84264, 28605, 609, '0', 170, 2228.12, -5818.03, 101.445, 1.43117, 120, 0, 2453, 0, 0),
+(84265, 28605, 609, '0', 170, 2232.95, -5814.65, 101.368, 2.35619, 120, 0, 2453, 0, 0),
+(84277, 28606, 609, '0', 170, 2172.505, -5810.831, 101.4043, 1.082104, 120, 0, 2453, 0, 0),
+(84279, 28606, 609, '0', 170, 2237.33, -5860.84, 101.292, 5.42797, 120, 0, 2453, 0, 0),
+(84280, 28606, 609, '0', 170, 2235.99, -5863.17, 101.269, 0.017453, 120, 0, 2453, 0, 0),
+(84281, 28606, 609, '0', 170, 2221.94, -5888.14, 101.022, 1.69297, 120, 0, 2453, 0, 0),
+(84297, 28606, 609, '0', 170, 2218.83, -5888.31, 100.995, 1.58825, 120, 0, 2453, 0, 0),
+(84315, 28606, 609, '0', 170, 2203.25, -5833.98, 101.44, 5.70723, 120, 0, 2453, 0, 0),
+(84316, 28606, 609, '0', 170, 2206.26, -5833.58, 101.435, 5.044, 120, 0, 2453, 0, 0),
+(84317, 28606, 609, '0', 170, 2185.22, -5867.83, 101.395, 4.85202, 120, 0, 2453, 0, 0),
+(84322, 28606, 609, '0', 170, 2197.14, -5870.83, 101.403, 4.57276, 120, 0, 2453, 0, 0),
+(84336, 28606, 609, '0', 170, 2225.69, -5815.68, 101.445, 0.488692, 120, 0, 2453, 0, 0),
+(84341, 28607, 609, '0', 170, 2212.25, -5881.55, 101.11, 4.59022, 120, 0, 2062, 0, 0),
+(84342, 28607, 609, '0', 170, 2176, -5810.381, 101.4176, 2.094395, 120, 0, 2062, 0, 0),
+(84346, 28607, 609, '0', 170, 2208.6, -5833.48, 101.428, 4.7822, 120, 0, 2062, 0, 0),
+(84347, 28607, 609, '0', 170, 2202.68, -5838.43, 101.498, 0.069813, 120, 0, 2062, 0, 0),
+(84348, 28607, 609, '0', 170, 2186.6, -5868.27, 101.39, 4.90438, 120, 0, 2062, 0, 0),
+(84349, 28607, 609, '0', 170, 2189.17, -5870.81, 101.378, 2.00713, 120, 0, 2062, 0, 0),
+(84392, 28607, 609, '0', 170, 2187.83, -5868.67, 101.387, 4.03171, 120, 0, 2062, 0, 0),
+(84393, 28607, 609, '0', 170, 2224.77, -5811.89, 101.434, 0.820305, 120, 0, 2062, 0, 0),
+(84406, 28607, 609, '0', 170, 2232.4, -5818.69, 101.392, 2.26893, 120, 0, 2062, 0, 0);
+
+-- Scarlet Preacher
+UPDATE `creature` SET `position_x`=1390.558, `position_y`=-5703.662, `position_z`=136.3209, `Orientation`=2.282122, `MovementType`=0, `spawndist`=0 WHERE `guid`=129171 AND `id`=28594;
+UPDATE `creature` SET `position_x`=1390.572, `position_y`=-5703.678, `position_z`=136.3188, `Orientation`=5.372028, `MovementType`=2, `spawndist`=0 WHERE `guid`=129170 AND `id`=28594;
+UPDATE `creature` SET `position_x`=1360.449, `position_y`=-5683.808, `position_z`=138.7448, `Orientation`=5.587841, `MovementType`=0, `spawndist`=0 WHERE `guid`=129169 AND `id`=28594;
+UPDATE `creature` SET `position_x`=1488.340, `position_y`=-5813.331, `position_z`=131.3350, `Orientation`=1.720976, `MovementType`=2, `spawndist`=0 WHERE `guid`=129165 AND `id`=28594;
+UPDATE `creature` SET `position_x`=1484.236, `position_y`=-5850.959, `position_z`=131.3351, `Orientation`=3.808080, `MovementType`=2, `spawndist`=0 WHERE `guid`=129168 AND `id`=28594;
+
+DELETE FROM `creature_addon` WHERE `guid` IN (129170,129165,129168);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(129170, 1291700,0,0,1, 0,''),
+(129165, 1291650,0,0,1, 0,''),
+(129168, 1291680,0,0,1, 0,'');
+
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (128736,129170);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(128736, 128736, 0, 0, 515, 0, 0),
+(128736, 128709, 6, 280, 515, 0, 0),
+(128736, 128712, 6, 300, 515, 0, 0),
+(128736, 128710, 6, 320, 515, 0, 0),
+(128736, 128713, 6, 340, 515, 0, 0),
+(128736, 128705, 6, 360, 515, 0, 0),
+(128736, 128707, 6, 20, 515, 0, 0),
+(128736, 128711, 6, 40, 515, 0, 0),
+(128736, 128708, 6, 60, 515, 0, 0),
+(128736, 128706, 6, 80, 515, 0, 0),
+(129170, 129170, 0, 0, 515, 0, 0),
+(129170, 129171, 3, 270, 515, 0, 0);
+
+-- waypoints
+DELETE FROM `waypoint_data` WHERE `id` IN (1291700,1291650,1291680,1287360);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `action`, `orientation`, `action_chance`, `move_type`) VALUES
+-- Scarlet Preacher
+(1291700,1,1402.94,-5716.94,133.387,0,0,5.27582,100,0),
+(1291700,2,1423.3,-5747.93,131.208,0,0,5.27415,100,0),
+(1291700,3,1402.68,-5716.63,133.475,0,0,2.18361,100,0),
+(1291700,4,1397.68,-5710.01,135.097,0,0,2.44907,100,0),
+(1291700,5,1389.76,-5704.78,136.089,0,0,2.54489,100,0),
+(1291700,6,1386.06,-5702.27,138.002,0,0,2.54489,100,0),
+(1291700,7,1366.41,-5688.04,137.968,3000,0,2.54489,100,0),
+(1291700,8,1386.36,-5702.1,138.001,0,0,5.66684,100,0),
+(1291700,9,1390.1,-5704.74,136.054,0,0,5.66684,100,0),
+(1291650,1,1484.85,-5802.34,131.228,0,0,2.09093,100,0),
+(1291650,2,1474.38,-5788.07,131.232,0,0,2.24565,100,0),
+(1291650,3,1451.5,-5759.41,131.232,0,0,2.40901,100,0),
+(1291650,4,1438.17,-5750.76,131.21,0,0,2.77606,100,0),
+(1291650,5,1425.59,-5747.92,131.21,0,0,3.33919,100,0),
+(1291650,6,1416.48,-5752.81,131.263,0,0,3.84342,100,0),
+(1291650,7,1410.85,-5760.42,131.447,0,0,4.38253,100,0),
+(1291650,8,1397.58,-5797.64,131.217,0,0,4.52391,100,0),
+(1291650,9,1398.15,-5805.79,131.242,0,0,5.00299,100,0),
+(1291650,10,1402.93,-5815.12,131.215,0,0,5.33678,100,0),
+(1291650,11,1431.32,-5846.87,131.209,0,0,5.47815,100,0),
+(1291650,12,1439.07,-5853.76,131.21,0,0,5.82529,100,0),
+(1291650,13,1449.41,-5855.99,131.22,0,0,0.0101976,100,0),
+(1291650,14,1478.43,-5856.03,131.237,0,0,0.0438187,100,0),
+(1291650,15,1487.95,-5854.48,131.214,0,0,0.642292,100,0),
+(1291650,16,1491.59,-5851.32,131.214,0,0,1.09625,100,0),
+(1291650,17,1493.68,-5843.79,131.213,0,0,1.60511,100,0),
+(1291650,18,1488.45,-5813.26,131.21,0,0,1.81953,100,0),
+(1291680,1,1451.43,-5852.32,131.316,0,0,2.97292,100,0),
+(1291680,2,1441.34,-5848.45,131.214,0,0,2.31868,100,0),
+(1291680,3,1415.71,-5822.71,131.208,0,0,2.34224,100,0),
+(1291680,4,1402.84,-5805.23,131.217,0,0,1.9087,100,0),
+(1291680,5,1403.41,-5795.93,131.212,0,0,1.30316,100,0),
+(1291680,6,1414.64,-5764.5,131.301,0,0,1.2741,100,0),
+(1291680,7,1421.97,-5754.72,131.213,0,0,0.747881,100,0),
+(1291680,8,1431.54,-5753.59,131.21,0,0,6.13021,100,0),
+(1291680,9,1440.86,-5758.25,131.21,0,0,5.51839,100,0),
+(1291680,10,1465.74,-5787.2,131.213,0,0,5.4532,100,0),
+(1291680,11,1479.13,-5805.14,131.211,0,0,5.30005,100,0),
+(1291680,12,1485.4,-5822.49,131.219,0,0,4.99375,100,0),
+(1291680,13,1487.73,-5844.53,131.216,0,0,4.72279,100,0),
+(1291680,14,1486.62,-5849.06,131.214,0,0,4.1039,100,0),
+(1291680,15,1482.41,-5851.55,131.217,0,0,3.45988,100,0),
+(1287360,1,1554.09, -5787.14, 119.562,0,0,3.1587,100,0), -- Scarlet Commander
+(1287360,2,1525.3,-5788.32,127.109,0,0,3.34719,100,0),
+(1287360,3,1501.55,-5795.64,131.149,0,0,3.56318,100,0),
+(1287360,4,1488.25,-5802.89,131.248,0,0,4.43889,100,0),
+(1287360,5,1486.45,-5811.1,131.213,0,0,4.81274,100,0),
+(1287360,6,1491.52,-5862.06,131.213,0,0,5.16067,100,0),
+(1287360,7,1504.88,-5884.58,131.182,0,0,5.78506,100,0),
+(1287360,8,1535.07,-5893.31,129.066,0,0,6.08743,100,0),
+(1287360,9,1601.17,-5910.01,116.303,0,0,6.00342,100,0),
+(1287360,10,1643.02,-5910.12,116.266,0,0,0.520555,100,0),
+(1287360,11,1656.36,-5899.57,116.124,0,0,0.587314,100,0),
+(1287360,12,1692.02,-5884.95,116.142,0,0,6.01834,100,0),
+(1287360,13,1702.86,-5887.94,116.138,0,0,5.62172,100,0),
+(1287360,14,1736.57,-5907.02,116.123,0,0,5.80629,100,0),
+(1287360,15,1798.79,-5933.78,115.968,0,0,6.01049,100,0),
+(1287360,16,1809.37,-5933.87,115.297,0,0,0.343049,100,0),
+(1287360,17,1864.98,-5914.6,104.226,0,0,0.331268,100,0),
+(1287360,18,1885.84,-5907.43,102.989,0,0,0.778945,100,0),
+(1287360,19,1894.42,-5891.76,102.687,0,0,1.25411,100,0),
+(1287360,20,1895.85,-5875.9,101.466,0,0,1.51329,100,0),
+(1287360,21,1881.66,-5850.79,102.244,0,0,2.27513,100,0),
+(1287360,22,1852.78,-5819.59,99.8482,0,0,3.03697,100,0),
+(1287360,23,1815.8,-5818.1,105.145,0,0,3.12336,100,0),
+(1287360,24,1749.11,-5822.59,116.12,0,0,3.13514,100,0),
+(1287360,25,1731.1,-5820.91,116.122,0,0,2.228,100,0),
+(1287360,26,1707.71, -5788.65, 114.503,0,0,2.55002,100,0),
+(1287360,27,1688.41, -5781.75, 114.617,0,0,2.96235,100,0),
+(1287360,28,1652.1, -5780.44, 116.135,0,0,3.13514,100,0),
+(1287360,29,1604.93, -5783.24, 116.183,0,0,3.20583,100,0);