DB/Instance/Sunwell Plateau: Overhaul part 1

(cherry picked from commit 382f612444fb6b023dbdb5c144a74a26ed365ae2)

1 files changed, 233 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_05_02_world_2020_12_18_02_world.sql b/sql/updates/world/master/2022_03_05_02_world_2020_12_18_02_world.sql
new file mode 100644
index 00000000000..730ef58324e
--- /dev/null
+++ b/sql/updates/world/master/2022_03_05_02_world_2020_12_18_02_world.sql
@@ -0,0 +1,233 @@
+-- Shattered Sun Soldier
+-- In comments HP from sniffs and HP I got in MoP
+-- Weirdly enough some values repeats even in single sniff
+-- Some means 20% from total HP, some 15 but other are 'different': 26.99, 23.99 32.99, 32, 38, 38.99, 24.99, 46, 50.99, 44.99, 18.99
+-- For second spell 3.99% and 3%
+-- Doesn't look like they are just random
+UPDATE `creature_template` SET `AIName` = "SmartAI", `RegenHealth` = 0 WHERE `entry` = 25661;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-48399,-53027,-53028,-53029,-53030,-53031,-53032,-53033,-53034,-53037) AND `source_type` = 0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(-48399,0,0,0,11,0,100,0,0,0,0,0,0,11,46577,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shattered Sun Soldier - On Respawn - Cast 'Wounded'"), -- 1760, 3740
+(-53027,0,0,0,11,0,100,0,0,0,0,0,0,11,46577,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shattered Sun Soldier - On Respawn - Cast 'Wounded'"), -- 1100, 3300
+(-53028,0,0,0,11,0,100,0,0,0,0,0,0,11,46577,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shattered Sun Soldier - On Respawn - Cast 'Wounded'"), -- 1760, 1100 
+(-53029,0,0,0,11,0,100,0,0,0,0,0,0,11,46577,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shattered Sun Soldier - On Respawn - Cast 'Wounded'"), -- 2420, 3300
+(-53030,0,0,0,11,0,100,0,0,0,0,0,0,11,46577,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shattered Sun Soldier - On Respawn - Cast 'Wounded'"), -- 2787, 1467
+(-53031,0,0,0,11,0,100,0,0,0,0,0,0,11,46577,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shattered Sun Soldier - On Respawn - Cast 'Wounded'"), -- 1980, 1467
+(-53032,0,0,0,11,0,100,0,0,0,0,0,0,11,46577,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shattered Sun Soldier - On Respawn - Cast 'Wounded'"), -- 1833, 2347
+(-53033,0,0,0,11,0,100,0,0,0,0,0,0,11,46586,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shattered Sun Soldier - On Respawn - Cast 'Almost Dead'"), -- 293, 220
+(-53034,0,0,0,11,0,100,0,0,0,0,0,0,11,46577,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shattered Sun Soldier - On Respawn - Cast 'Wounded'"), -- 3374, 2860
+(-53037,0,0,0,11,0,100,0,0,0,0,0,0,11,46577,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shattered Sun Soldier - On Respawn - Cast 'Wounded'"); -- 1980, 1393
+
+-- Positions
+UPDATE `creature` SET `VerifiedBuild` = 15354 WHERE `map` = 580 AND `id` IN (25597,25632,25638,25661,25953,25770,25795,25796,25741,23472,25368,22515,19871,24850,24882,25165,25166,24892,25509,25640,25591,25593,25358);
+UPDATE `creature` SET `VerifiedBuild` = 15354 WHERE `guid` != 55375 AND `id` = 25592;
+UPDATE `creature` SET `VerifiedBuild` = 15354 WHERE `MovementType` = 0 AND `id` = 25507;
+
+UPDATE `creature` SET `position_x` = 1849.58, `position_y` = 683.481, `position_z` = 32.1138, `orientation` = 1.76278 WHERE `guid` = 44328 AND `id` = 25597;
+UPDATE `creature` SET `position_x` = 1830.81, `position_y` = 692.599, `position_z` = 32.1155, `orientation` = 6.12611 WHERE `guid` = 44465 AND `id` = 25597;
+UPDATE `creature` SET `position_x` = 1816.4, `position_y` = 625.894, `position_z` = 69.6886, `orientation` = 5.58505 WHERE `guid` = 53705 AND `id` = 25741;
+UPDATE `creature` SET `position_x` = 1814.27, `position_y` = 626.452, `position_z` = 33.487, `orientation` = 2.58309 WHERE `guid` = 53687 AND `id` = 25165;
+UPDATE `creature` SET `position_x` = 1818.21, `position_y` = 625.044, `position_z` = 33.487, `orientation` = 5.61996 WHERE `guid` = 53668 AND `id` = 25166;
+UPDATE `creature` SET `position_x` = 1699.91, `position_y` = 929.021, `position_z` = -74.2836, `orientation` = 6.16101 WHERE `guid` = 53645 AND `id` = 24892;
+UPDATE `creature` SET `position_z` = 28.2086 WHERE `guid` = 113534 AND `id` = 25640;
+UPDATE `creature` SET `position_z` = 28.2507 WHERE `guid` = 113539 AND `id` = 25640;
+UPDATE `creature` SET `position_x` = 1843.34, `position_y` = 693.506, `position_z` = 32.1155, `orientation` = 3.97935 WHERE `guid` = 43742 AND `id` = 25592;
+UPDATE `creature` SET `wander_distance` = 15, `MovementType` = 1 WHERE `guid` = 55375 AND `id` = 25592;
+UPDATE `creature` SET `position_x` = 1764.88, `position_y` = 945.375, `position_z` = 16.9082, `orientation` = 1.6057 WHERE `guid` = 54994 AND `id` = 25507;
+
+-- Errors
+UPDATE `creature` SET `MovementType` = 0 WHERE `id` IN (25367,25370,25371);
+
+-- Sunblade Dragonhawk
+DELETE FROM `creature` WHERE `guid` IN (55421,55422,55105) AND `id` = 25867;
+DELETE FROM `linked_respawn` WHERE `guid` IN (55421,55422,55105);
+
+UPDATE `creature` SET `position_x` = 1649.55, `position_y` = 1054.83, `position_z` = 16.1107, `orientation` = 5.55015, `MovementType` = 2 WHERE `guid` = 56686 AND `id` = 25867;
+
+DELETE FROM `creature_addon` WHERE `guid` = 56686;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
+(56686,566860,0,0,1,0,0,"45769");
+
+DELETE FROM `waypoint_data` WHERE `id` = 566860;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(566860,1,1642.1364,1049.9846,16.110676,0,0,0,0,0,0),
+(566860,2,1636.4596,1050.7524,16.110676,0,0,0,0,0,0),
+(566860,3,1630.6578,1054.6174,16.099121,0,0,0,0,0,0),
+(566860,4,1629.0513,1064.1732,16.099121,0,0,0,0,0,0),
+(566860,5,1632.7871,1071.5505,16.06526,0,0,0,0,0,0),
+(566860,6,1640.0778,1074.7561,16.110676,0,0,0,0,0,0),
+(566860,7,1647.1919,1072.9384,16.110676,0,0,0,0,0,0),
+(566860,8,1651.853,1067.7501,16.110676,0,0,0,0,0,0), -- may be not correct
+(566860,9,1651.871,1058.9955,16.110676,0,0,0,0,0,0), -- may be not correct
+(566860,10,1649.5647,1054.8075,16.110676,5.602506637573242187,8000,0,0,0,0);
+
+-- Chaos Gazer
+UPDATE `creature` SET `position_x` = 1927.0338, `position_y` = 564.501, `position_z` = 32.014595, `MovementType` = 2 WHERE `guid` = 55474 AND `id` = 25595;
+UPDATE `creature` SET `position_x` = 1938.0377, `position_y` = 499.297, `position_z` = 32.032207, `MovementType` = 2 WHERE `guid` = 48402 AND `id` = 25595;
+
+DELETE FROM `creature_addon` WHERE `guid` = 55474;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
+(55474,554740,0,0,1,0,0,"45769");
+
+DELETE FROM `waypoint_data` WHERE `id` IN (554740,484020);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(554740,1,1927.0338,564.501,32.014595,0,0,0,0,0,0),
+(554740,2,1907.3876,579.3162,32.016743,0,0,0,0,0,0),
+(554740,3,1927.0338,564.501,32.014595,0,0,0,0,0,0),
+(554740,4,1935.3365,541.041,32.015278,0,0,0,0,0,0),
+(484020,1,1938.0377,499.297,32.032207,0,0,0,0,0,0),
+(484020,2,1944.0404,517.6599,32.016167,0,0,0,0,0,0),
+(484020,3,1938.0377,499.297,32.032207,0,0,0,0,0,0),
+(484020,4,1912.3802,472.64807,32.032177,0,0,0,0,0,0);
+
+-- Cataclysm Hound
+UPDATE `creature` SET `position_x` = 1842.3381, `position_y` = 534.44916, `position_z` = 39.9556 WHERE `guid` = 48404 AND `id` = 25599;
+UPDATE `creature` SET `position_x` = 1917.4501, `position_y` = 537.6804, `position_z` = 71.310104 WHERE `guid` = 48403 AND `id` = 25599;
+
+DELETE FROM `waypoint_data` WHERE `id` IN (484040,484030);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(484040,1,1842.3381,534.44916,39.9556,0,0,0,0,0,0),
+(484040,2,1843.7213,513.75275,43.49995,0,0,0,0,0,0),
+(484040,3,1852.2487,497.1709,47.16501,0,0,0,0,0,0),
+(484040,4,1868.9247,485.38443,51.60663,0,0,0,0,0,0),
+(484040,5,1852.2487,497.1709,47.16501,0,0,0,0,0,0),
+(484040,6,1843.7213,513.75275,43.49995,0,0,0,0,0,0),
+(484040,7,1842.3381,534.44916,39.9556,0,0,0,0,0,0),
+(484040,8,1847.7205,551.5335,35.1374,0,0,0,0,0,0),
+(484030,1,1917.4501,537.6804,71.310104,0,0,0,0,0,0),
+(484030,2,1920.5786,524.655,68.57313,0,0,0,0,0,0),
+(484030,3,1919.8396,512.06934,65.00435,0,0,0,0,0,0),
+(484030,4,1914.3881,499.3655,62.06977,0,0,0,0,0,0),
+(484030,5,1905.492,489.5805,59.42706,0,0,0,0,0,0),
+(484030,6,1893.4755,483.82736,56.604534,0,0,0,0,0,0),
+(484030,7,1905.492,489.5805,59.42706,0,0,0,0,0,0),
+(484030,8,1914.3881,499.3655,62.06977,0,0,0,0,0,0),
+(484030,9,1919.8396,512.06934,65.00435,0,0,0,0,0,0),
+(484030,10,1920.5786,524.655,68.57313,0,0,0,0,0,0);
+
+-- Sunblade Scout
+UPDATE `creature` SET `position_x` = 1751.56, `position_y` = 988.494, `position_z` = 16.8296, `orientation` = 1.08653, `VerifiedBuild` = 15354 WHERE `guid` = 48360 AND `id` = 25372;
+UPDATE `creature` SET `position_x` = 1743.4205, `position_y` = 1035.359, `position_z` = 16.109913 WHERE `guid` = 48162 AND `id` = 25372;
+UPDATE `creature` SET `position_x` = 1636.5447, `position_y` = 977.0506, `position_z` = 16.465023 WHERE `guid` = 48372 AND `id` = 25372;
+UPDATE `creature` SET `position_x` = 1671.9303, `position_y` = 1027.017, `position_z` = 16.534538 WHERE `guid` = 48160 AND `id` = 25372;
+
+DELETE FROM `waypoint_data` WHERE `id` IN (483600,481620,483720,481600);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(483600,1,1752.1964,1003.4746,16.110786,0,0,0,0,0,0),
+(483600,2,1750.652,1007.7948,16.47004,0,0,0,0,0,0),
+(483600,3,1746.192,1010.403,16.485786,0,0,0,0,0,0),
+(483600,4,1742.4349,1013.364,16.610786,0,0,0,0,0,0),
+(483600,5,1737.445,1014.1033,16.735786,0,0,0,0,0,0),
+(483600,6,1728.3539,1015.2274,16.67807,0,0,0,0,0,0),
+(483600,7,1725.0339,1013.8353,16.5383,0,0,0,0,0,0),
+(483600,8,1721.4014,1010.1552,16.319427,0,0,0,0,0,0),
+(483600,9,1717.5725,1004.5712,16.326452,0,0,0,0,0,0),
+(483600,10,1717.9601,997.6887,16.326233,0,0,0,0,0,0),
+(483600,11,1719.632,991.1544,16.4804,0,0,0,0,0,0),
+(483600,12,1721.1771,983.3319,16.9804,0,0,0,0,0,0),
+(483600,13,1724.7378,977.2932,17.136528,0,0,0,0,0,0),
+(483600,14,1730.0508,970.61536,17.3554,0,0,0,0,0,0),
+(483600,15,1731.9943,964.3101,17.422771,0,0,0,0,0,0),
+(483600,16,1739.1793,961.0293,17.436886,0,0,0,0,0,0),
+(483600,17,1747.8761,962.55646,17.186886,0,0,0,0,0,0),
+(483600,18,1749.0599,970.68774,17.36079,0,0,0,0,0,0),
+(483600,19,1749.8236,977.07684,17.465282,0,0,0,0,0,0),
+(483600,20,1751.3768,982.8675,17.229198,0,0,0,0,0,0),
+(483600,21,1752.5315,987.4033,16.926098,0,0,0,0,0,0),
+(483600,22,1752.9827,991.1971,16.479565,0,0,0,0,0,0),
+(483600,23,1752.8726,997.4159,16.11079,0,0,0,0,0,0),
+(483600,24,1752.1964,1003.4746,16.110786,0,0,0,0,0,0),
+(481620,1,1743.4205,1035.359,16.109913,0,0,0,0,0,0),
+(481620,2,1738.5787,1041.1777,16.109913,0,0,0,0,0,0),
+(481620,3,1733.7025,1045.9755,16.109913,0,0,0,0,0,0),
+(481620,4,1730.9531,1049.6191,16.110506,0,0,0,0,0,0),
+(481620,5,1730.8784,1056.5469,16.110506,0,0,0,0,0,0),
+(481620,6,1732.2365,1063.6373,16.110506,0,0,0,0,0,0),
+(481620,7,1739.6266,1071.504,16.092762,0,0,0,0,0,0),
+(481620,8,1738.2421,1065.4066,16.109913,0,0,0,0,0,0),
+(481620,9,1742.066,1060.755,16.109913,0,0,0,0,0,0),
+(481620,10,1740.9332,1052.7489,16.109913,0,0,0,0,0,0),
+(481620,11,1747.839,1049.0979,16.109913,0,0,0,0,0,0),
+(481620,12,1750.9983,1046.2767,16.109913,0,0,0,0,0,0),
+(481620,13,1749.7476,1041.2535,16.109913,0,0,0,0,0,0),
+(483720,1,1636.5447,977.0506,16.465023,0,0,0,0,0,0),
+(483720,2,1635.6846,985.32306,16.583431,0,0,0,0,0,0),
+(483720,3,1636.6278,994.7483,16.27142,0,0,0,0,0,0),
+(483720,4,1640.7041,1002.1281,16.163044,0,0,0,0,0,0),
+(483720,5,1647.3643,996.0251,16.104305,0,0,0,0,0,0),
+(483720,6,1652.4547,986.1442,16.104305,0,0,0,0,0,0),
+(483720,7,1657.9362,985.8649,16.104305,0,0,0,0,0,0),
+(483720,8,1663.8134,986.7366,16.104305,0,0,0,0,0,0),
+(483720,9,1669.3163,989.0823,16.105,0,0,0,0,0,0),
+(483720,10,1673.7723,991.66125,16.105,0,0,0,0,0,0),
+(483720,11,1679.0463,989.0131,16.105,0,0,0,0,0,0),
+(483720,12,1679.7242,981.82794,16.105,0,0,0,0,0,0),
+(483720,13,1676.1891,979.7906,16.105,0,0,0,0,0,0),
+(483720,14,1671.0084,982.4798,16.105,0,0,0,0,0,0),
+(483720,15,1665.338,983.6517,16.104305,0,0,0,0,0,0),
+(483720,16,1659.5758,983.65137,16.104305,0,0,0,0,0,0),
+(483720,17,1654.1362,983.30945,16.104305,0,0,0,0,0,0),
+(483720,18,1647.4425,977.48157,16.104305,0,0,0,0,0,0),
+(483720,19,1640.1444,973.1131,16.104305,0,0,0,0,0,0),
+(481600,1,1671.9303,1027.017,16.534538,0,0,0,0,0,0),
+(481600,2,1667.4977,1021.2459,16.252556,0,0,0,0,0,0),
+(481600,3,1663.4264,1027.5798,16.110065,0,0,0,0,0,0),
+(481600,4,1659.6307,1033.7073,16.110676,0,0,0,0,0,0),
+(481600,5,1664.0616,1040.9528,16.110676,0,0,0,0,0,0),
+(481600,6,1669.3726,1048.8733,16.11073,0,0,0,0,0,0),
+(481600,7,1672.8024,1053.7302,16.11073,0,0,0,0,0,0),
+(481600,8,1683.6189,1061.3365,16.11073,0,0,0,0,0,0),
+(481600,9,1683.8113,1052.4606,16.11073,0,0,0,0,0,0),
+(481600,10,1684.5265,1042.5327,16.319225,0,0,0,0,0,0),
+(481600,11,1677.6179,1034.8367,16.362438,0,0,0,0,0,0);
+
+-- Shadowsword Guardian
+UPDATE `creature` SET `position_x` = 1668.3055, `position_y` = 703.78326, `position_z` = 59.23651 WHERE `guid` = 48401 AND `id` = 25508;
+UPDATE `creature` SET `position_x` = 1633.0812, `position_y` = 585.6543, `position_z` = 33.321102, `MovementType` = 2 WHERE `guid` = 55066 AND `id` = 25508;
+
+DELETE FROM `creature_addon` WHERE `guid` = 55066;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
+(55066,550660,0,0,1,0,3,"45769");
+
+DELETE FROM `waypoint_data` WHERE `id` IN (484010,550660);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(484010,1,1668.3055,703.78326,59.23651,0,0,0,0,0,0),
+(484010,2,1648.4697,691.6264,51.47285,0,0,0,0,0,0),
+(484010,3,1635.7311,679.5251,45.54032,0,0,0,0,0,0),
+(484010,4,1628.7792,666.8651,41.772865,0,0,0,0,0,0),
+(484010,5,1635.7311,679.5251,45.54032,0,0,0,0,0,0),
+(484010,6,1648.4697,691.6264,51.47285,0,0,0,0,0,0),
+(550660,1,1633.0812,585.6543,33.321102,0,0,0,0,0,0),
+(550660,2,1624.1404,608.2837,33.32114,0,0,0,0,0,0),
+(550660,3,1619.8248,631.8298,32.90169,0,0,0,0,0,0),
+(550660,4,1624.1404,608.2837,33.32114,0,0,0,0,0,0),
+(550660,5,1633.0812,585.6543,33.321102,0,0,0,0,0,0),
+(550660,6,1650.4883,567.7746,33.32105,0,0,0,0,0,0),
+(550660,7,1673.0859,556.555,33.32102,0,0,0,0,0,0),
+(550660,8,1650.4883,567.7746,33.32105,0,0,0,0,0,0);
+
+-- Sunblade Protector
+UPDATE `creature` SET `position_x` = 1667.4684, `position_y` = 898.40625, `position_z` = 14.626317 WHERE `guid` = 48394 AND `id` = 25507;
+UPDATE `creature` SET `position_x` = 1704.8262, `position_y` = 986.7211, `position_z` = 53.016705 WHERE `guid` = 48400 AND `id` = 25507;
+
+DELETE FROM `waypoint_data` WHERE `id` IN (483940,484000);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(483940,1,1667.4684,898.40625,14.626317,0,0,0,0,0,0),
+(483940,2,1656.9585,904.95776,14.621348,0,0,0,0,0,0),
+(483940,3,1643.9731,906.4864,14.624736,0,0,0,0,0,0),
+(483940,4,1634.5303,900.7702,14.621458,0,0,0,0,0,0),
+(483940,5,1630.1981,888.22943,14.62316,0,0,0,0,0,0),
+(483940,6,1637.0072,872.7303,14.620774,0,0,0,0,0,0),
+(483940,7,1649.1978,865.3496,14.621768,0,0,0,0,0,0),
+(483940,8,1660.8893,865.8581,14.617406,0,0,0,0,0,0),
+(483940,9,1670.3221,870.1398,14.622309,0,0,0,0,0,0),
+(483940,10,1675.4259,877.5245,14.627379,0,0,0,0,0,0),
+(483940,11,1674.8668,887.4402,14.625486,0,0,0,0,0,0),
+(484000,1,1704.8262,986.7211,53.016705,0,0,0,0,0,0),
+(484000,2,1705.2845,1005.8503,53.000538,0,0,0,0,0,0),
+(484000,3,1705.858,1030.087,52.980053,0,0,0,0,0,0),
+(484000,4,1706.8403,1066.1394,52.84465,0,0,0,0,0,0),
+(484000,5,1705.858,1030.087,52.980053,0,0,0,0,0,0),
+(484000,6,1705.2845,1005.8503,53.000538,0,0,0,0,0,0),
+(484000,7,1704.8262,986.7211,53.016705,0,0,0,0,0,0),
+(484000,8,1704.3972,970.1668,53.030697,0,0,0,0,0,0);