DB/Instance/The Mechanar: Update positions, waypoints & misc fixes

(cherry picked from commit aff9cf40dcf52f686c27b7abe20ae0eda5779800)

1 files changed, 135 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_02_28_47_world_2020_10_23_00_world.sql b/sql/updates/world/master/2022_02_28_47_world_2020_10_23_00_world.sql
new file mode 100644
index 00000000000..828b2fe117e
--- /dev/null
+++ b/sql/updates/world/master/2022_02_28_47_world_2020_10_23_00_world.sql
@@ -0,0 +1,135 @@
+--
+UPDATE `creature` SET `position_x` = 85.5275, `position_y` = 20.2005, `position_z` = 15.0044, `orientation` = 0.66322, `VerifiedBuild` = 14545 WHERE `guid` = 83239 AND `id` = 19218;
+UPDATE `creature` SET `position_x` = 30.2196, `position_y` = 2.91536, `position_z` = 0.08239, `orientation` = 3.29867, `VerifiedBuild` = 14545 WHERE `guid` = 83198 AND `id` = 19166;
+UPDATE `creature` SET `position_x` = 37.4106, `position_y` = 54.8214, `position_z` = 0.24639, `orientation` = 2.39110, `VerifiedBuild` = 14545 WHERE `guid` = 83187 AND `id` = 20990;
+UPDATE `creature` SET `position_x` = 37.1750, `position_y` = -51.8689, `position_z` = 0.24639, `orientation` = 4.11897, `VerifiedBuild` = 14545 WHERE `guid` = 83228 AND `id` = 19167;
+UPDATE `creature` SET `position_x` = 37.4608, `position_y` = -60.7909, `position_z` = 0.24639, `orientation` = 2.65290, `VerifiedBuild` = 14545 WHERE `guid` = 83227 AND `id` = 20990;
+UPDATE `creature` SET `position_x` = 37.3979, `position_y` = 64.6460, `position_z` = 0.24639, `orientation` = 4.13643, `VerifiedBuild` = 14545 WHERE `guid` = 83188 AND `id` = 19167;
+UPDATE `creature` SET `position_x` = 77.9032, `position_y` = -51.9802, `position_z` = 15.0079, `orientation` = 3.31612, `VerifiedBuild` = 14545 WHERE `guid` = 83226 AND `id` = 19167;
+UPDATE `creature` SET `position_x` = 77.5822, `position_y` = 55.4031, `position_z` = 15.0079, `orientation` = 3.19395, `VerifiedBuild` = 14545 WHERE `guid` = 83186 AND `id` = 20990;
+UPDATE `creature` SET `position_x` = 77.9449, `position_y` = -60.8388, `position_z` = 15.0079, `orientation` = 3.47320, `VerifiedBuild` = 14545 WHERE `guid` = 83225 AND `id` = 20990;
+UPDATE `creature` SET `position_x` = 77.8173, `position_y` = 64.1236, `position_z` = 15.0079, `orientation` = 3.26376, `VerifiedBuild` = 14545 WHERE `guid` = 83185 AND `id` = 19167;
+UPDATE `creature` SET `position_x` = 108.423, `position_y` = -42.7796, `position_z` = 15.0079, `orientation` = 5.16617, `VerifiedBuild` = 14545 WHERE `guid` = 83223 AND `id` = 19712;
+UPDATE `creature` SET `position_x` = 99.9307, `position_y` = -77.9516, `position_z` = 15.0107, `orientation` = 3.92699, `VerifiedBuild` = 14545 WHERE `guid` = 83219 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 120.598, `position_y` = -65.5736, `position_z` = 15.0079, `orientation` = 3.24631, `VerifiedBuild` = 14545 WHERE `guid` = 83217 AND `id` = 19167;
+UPDATE `creature` SET `position_x` = 92.3547, `position_y` = -79.2986, `position_z` = 15.0079, `orientation` = 5.18362, `VerifiedBuild` = 14545 WHERE `guid` = 83220 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 109.620, `position_y` = -55.2713, `position_z` = 15.0070, `orientation` = 0.68067, `VerifiedBuild` = 14545 WHERE `guid` = 83222 AND `id` = 19712;
+UPDATE `creature` SET `position_x` = 131.219, `position_y` = -37.1083, `position_z` = 0.08333, `orientation` = 3.99680, `wander_distance` = 5, `MovementType` = 1, `VerifiedBuild` = 14545 WHERE `guid` = 83161 AND `id` = 20988;
+UPDATE `creature` SET `position_x` = 133.418, `position_y` = -40.7441, `position_z` = 0.08333, `orientation` = 5.67231, `wander_distance` = 5, `MovementType` = 1, `VerifiedBuild` = 14545 WHERE `guid` = 83163 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 120.378, `position_y` = -82.3033, `position_z` = 15.0098, `orientation` = 3.21140, `VerifiedBuild` = 14545 WHERE `guid` = 83218 AND `id` = 20990;
+UPDATE `creature` SET `position_x` = 165.639, `position_y` = -19.8589, `position_z` = 0.08333, `orientation` = 5.88175, `VerifiedBuild` = 14545 WHERE `guid` = 83202 AND `id` = 19713;
+UPDATE `creature` SET `position_x` = 165.843, `position_y` = -73.6566, `position_z` = 1.72646, `orientation` = 3.24631, `VerifiedBuild` = 14545 WHERE `guid` = 83216 AND `id` = 19510;
+UPDATE `creature` SET `position_x` = 168.960, `position_y` = -87.2767, `position_z` = 0.78982, `orientation` = 3.19395, `VerifiedBuild` = 14545 WHERE `guid` = 83214 AND `id` = 20990;
+UPDATE `creature` SET `position_x` = 160.689, `position_y` = -16.6626, `position_z` = 0.08333, `orientation` = 2.09439, `wander_distance` = 5, `MovementType` = 1, `VerifiedBuild` = 14545 WHERE `guid` = 83204 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 138.291, `position_y` = -33.3403, `position_z` = 0, `orientation` = 1.59634, `wander_distance` = 5, `MovementType` = 1, `VerifiedBuild` = 14545 WHERE `guid` = 83199 AND `id` = 20988;
+UPDATE `creature` SET `position_x` = 140.139, `position_y` = -41.2415, `position_z` = 0, `orientation` = 6.06182, `wander_distance` = 5, `MovementType` = 1, `VerifiedBuild` = 0 WHERE `guid` = 83162 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 168.528, `position_y` = -11.8861, `position_z` = 0.08333, `orientation` = 0.48869, `wander_distance` = 5, `MovementType` = 1, `VerifiedBuild` = 14545 WHERE `guid` = 83205 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 169.257, `position_y` = -68.0939, `position_z` = 0.66528, `orientation` = 3.26376, `VerifiedBuild` = 14545 WHERE `guid` = 83215 AND `id` = 20059;
+UPDATE `creature` SET `position_x` = 174.124, `position_y` = -17.4885, `position_z` = 0.08333, `orientation` = 3.96189, `VerifiedBuild` = 14545 WHERE `guid` = 83203 AND `id` = 19713;
+UPDATE `creature` SET `position_x` = 207.592, `position_y` = -91.1401, `position_z` = 0.08977, `orientation` = 3.80481, `wander_distance` = 5, `MovementType` = 1, `VerifiedBuild` = 14545 WHERE `guid` = 83207 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 214.792, `position_y` = -83.1537, `position_z` = 0.08905, `orientation` = 5.51524, `VerifiedBuild` = 14545 WHERE `guid` = 83210 AND `id` = 19712;
+UPDATE `creature` SET `position_x` = 216.178, `position_y` = -95.2041, `position_z` = 0.08916, `orientation` = 0.20943, `VerifiedBuild` = 14545 WHERE `guid` = 83209 AND `id` = 19712;
+UPDATE `creature` SET `position_x` = 223.733, `position_y` = -62.9848, `position_z` = 0.08568, `orientation` = 5.04400, `VerifiedBuild` = 14545 WHERE `guid` = 83212 AND `id` = 19712;
+UPDATE `creature` SET `position_x` = 227.934, `position_y` = -52.0849, `position_z` = 0.08384, `orientation` = 0.05235, `id` = 19713, `VerifiedBuild` = 14545 WHERE `guid` = 83211 AND `id` = 19712;
+UPDATE `creature` SET `position_x` = 274.134, `position_y` = -28.7062, `position_z` = 26.4117, `orientation` = 0, `VerifiedBuild` = 14545 WHERE `guid` = 83236 AND `id` = 19510;
+UPDATE `creature` SET `position_x` = 272.154, `position_y` = -24.6583, `position_z` = 26.4117, `orientation` = 6.16101, `VerifiedBuild` = 14545 WHERE `guid` = 67872 AND `id` = 19168;
+UPDATE `creature` SET `position_x` = 272.077, `position_y` = -20.9663, `position_z` = 26.4117, `orientation` = 6.19591, `VerifiedBuild` = 14545 WHERE `guid` = 88276 AND `id` = 19168;
+UPDATE `creature` SET `position_x` = 274.302, `position_y` = -17.8063, `position_z` = 26.4117, `orientation` = 0.15707, `VerifiedBuild` = 14545 WHERE `guid` = 83235 AND `id` = 19510;
+UPDATE `creature` SET `position_x` = 185.819, `position_y` = 35.8239, `position_z` = 0.07753, `orientation` = 4.76474, `VerifiedBuild` = 14545 WHERE `guid` = 83201 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 180.164, `position_y` = 34.5334, `position_z` = 0.07693, `orientation` = 4.45058, `VerifiedBuild` = 14545 WHERE `guid` = 83171 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 192.838, `position_y` = 35.6950, `position_z` = 0.07763, `orientation` = 4.85201, `VerifiedBuild` = 14545 WHERE `guid` = 83170 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 293.057, `position_y` = -13.0294, `position_z` = 25.4694, `orientation` = 4.86946, `wander_distance` = 5, `MovementType` = 1, `VerifiedBuild` = 14545 WHERE `guid` = 83233 AND `id` = 19735;
+UPDATE `creature` SET `position_x` = 290.618, `position_y` = 29.1205, `position_z` = 25.4694, `orientation` = 1.69296, `wander_distance` = 5, `MovementType` = 1, `VerifiedBuild` = 14545 WHERE `guid` = 83234 AND `id` = 19735;
+UPDATE `creature` SET `position_x` = 226.571, `position_y` = 60.2797, `position_z` = 0.07918, `orientation` = 3.08923, `VerifiedBuild` = 14545 WHERE `guid` = 83172 AND `id` = 19168;
+UPDATE `creature` SET `position_x` = 152.632, `position_y` = 53.3561, `position_z` = 0.07940, `orientation` = 2.68780, `VerifiedBuild` = 14545 WHERE `guid` = 83167 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 226.594, `position_y` = 45.0895, `position_z` = 0.07682, `orientation` = 3.17649, `VerifiedBuild` = 14545 WHERE `guid` = 83169 AND `id` = 19168;
+UPDATE `creature` SET `position_x` = 131.680, `position_y` = 40.4787, `position_z` = 0.08333, `orientation` = 0.17453, `wander_distance` = 5, `MovementType` = 1, `VerifiedBuild` = 14545 WHERE `guid` = 83164 AND `id` = 20988;
+UPDATE `creature` SET `position_x` = 140.176, `position_y` = 50.3652, `position_z` = 0.08119, `orientation` = 0.90757, `VerifiedBuild` = 14545 WHERE `guid` = 83166 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 134.556, `position_y` = 45.1142, `position_z` = 0.08333, `orientation` = 1.32645, `VerifiedBuild` = 14545 WHERE `guid` = 83200 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 112.692, `position_y` = 45.9757, `position_z` = 15.0079, `orientation` = 1.01229, `VerifiedBuild` = 14545 WHERE `guid` = 83183 AND `id` = 19713;
+UPDATE `creature` SET `position_x` = 106.643, `position_y` = 51.5013, `position_z` = 15.0079, `orientation` = 3.92699, `wander_distance` = 3, `MovementType` = 1, `VerifiedBuild` = 14545 WHERE `guid` = 87087 AND `id` = 19716;
+UPDATE `creature` SET `position_x` = 165.699, `position_y` = 85.5581, `position_z` = 1.76883, `orientation` = 3.21140, `VerifiedBuild` = 14545 WHERE `guid` = 83175 AND `id` = 19510;
+UPDATE `creature` SET `position_x` = 165.422, `position_y` = 77.9690, `position_z` = 1.84253, `orientation` = 3.29867, `VerifiedBuild` = 14545 WHERE `guid` = 83176 AND `id` = 20990;
+UPDATE `creature` SET `position_x` = 109.459, `position_y` = 58.5752, `position_z` = 15.0079, `orientation` = 5.28834, `VerifiedBuild` = 14545 WHERE `guid` = 83182 AND `id` = 19713;
+UPDATE `creature` SET `position_x` = 119.439, `position_y` = 69.1739, `position_z` = 15.0079, `orientation` = 3.29867, `VerifiedBuild` = 14545 WHERE `guid` = 83179 AND `id` = 20990;
+UPDATE `creature` SET `position_x` = 169.372, `position_y` = 92.1162, `position_z` = 0.65951, `orientation` = 3.35103, `VerifiedBuild` = 14545 WHERE `guid` = 83174 AND `id` = 20059;
+UPDATE `creature` SET `position_x` = 119.344, `position_y` = 85.9118, `position_z` = 15.0163, `orientation` = 3.45575, `VerifiedBuild` = 14545 WHERE `guid` = 83178 AND `id` = 19167;
+UPDATE `creature` SET `position_x` = 309.243, `position_y` = 10.2549, `position_z` = 25.4695, `orientation` = 3.17649, `VerifiedBuild` = 14545 WHERE `guid` = 83232 AND `id` = 19510;
+UPDATE `creature` SET `position_x` = 309.388, `position_y` = 5.29271, `position_z` = 25.5154, `orientation` = 3.29867, `VerifiedBuild` = 14545 WHERE `guid` = 83245 AND `id` = 19168;
+UPDATE `creature` SET `position_x` = 309.331, `position_y` = 15.1339, `position_z` = 25.4695, `orientation` = 3.07177, `VerifiedBuild` = 14545 WHERE `guid` = 75951 AND `id` = 19168;
+UPDATE `creature` SET `position_x` = 309.518, `position_y` = 20.2796, `position_z` = 25.4735, `orientation` = 2.70526, `VerifiedBuild` = 14545 WHERE `guid` = 83231 AND `id` = 19510;
+UPDATE `creature` SET `position_x` = 326.516, `position_y` = 13.1959, `position_z` = 27.9198, `orientation` = 3.22885, `VerifiedBuild` = 14545 WHERE `guid` = 83230 AND `id` = 19221;
+UPDATE `creature` SET `position_x` = 139.542, `position_y` = 149.319, `position_z` = 25.6590, `orientation` = 4.59021, `VerifiedBuild` = 14545 WHERE `guid` = 83241 AND `id` = 19220;
+
+-- These are two packs with intro movement. Unfortunately player entered dungeon not first and movement was already loaded
+-- so they should be sniffed again
+UPDATE `creature` SET `position_x` = 28.5941, `position_y` = 45.7435, `position_z` = 0.04330, `orientation` = 3.81885, `VerifiedBuild` = 14545 WHERE `guid` = 83192 AND `id` = 20990;
+UPDATE `creature` SET `position_x` = 34.3992, `position_y` = 44.3312, `position_z` = -0, `orientation` = 5.32653, `VerifiedBuild` = 14545 WHERE `guid` = 83190 AND `id` = 19510;
+UPDATE `creature` SET `position_x` = 29.5669, `position_y` = 37.1785, `position_z` = 0.01430, `orientation` = 4.47002, `MovementType` = 2, `VerifiedBuild` = 14545 WHERE `guid` = 83191 AND `id` = 20059;
+UPDATE `creature` SET `position_x` = 33.9527, `position_y` = -44.7567, `position_z` = 0.14382, `orientation` = 0.58541, `VerifiedBuild` = 14545 WHERE `guid` = 83193 AND `id` = 20990;
+UPDATE `creature` SET `position_x` = 27.9988, `position_y` = -45.4943, `position_z` = 0.15389, `orientation` = 2.33215, `VerifiedBuild` = 14545 WHERE `guid` = 83196 AND `id` = 19167;
+UPDATE `creature` SET `position_x` = 29.9796, `position_y` = -37.0793, `position_z` = 0.00971, `orientation` = 1.69392, `MovementType` = 2, `VerifiedBuild` = 14545 WHERE `guid` = 83194 AND `id` = 20059;
+
+DELETE FROM `waypoint_data` WHERE `id` IN (831910,831940);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(831910,1,28.83408,34.214123,0.0092436075,0,0,0,0,0,0),
+(831910,2,22.140232,20.44575,-0.0001794661,0,0,0,0,0,0),
+(831910,3,22.140232,20.44575,-0.0001794661,3.17649,55555555,0,0,0,0),
+(831940,1,29.230213,-31.023266,0.006834209,0,0,0,0,0,0),
+(831940,2,23.20878,-18.283445,-0.000110802706,0,0,0,0,0,0),
+(831940,3,23.20878,-18.283445,-0.000110802706,3.08923,55555555,0,0,0,0);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (83191,83194);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(83191,83191,0,0,515,0,0),
+(83191,83192,3,90,515,0,0), -- 100 to match retail final positions (something is not implemented correctly)
+(83191,83190,3,270,515,0,0), -- 285
+(83194,83194,0,0,515,0,0),
+(83194,83193,3,90,515,0,0), -- 75
+(83194,83196,3,270,515,0,0); -- 260
+
+DELETE FROM `creature_addon` WHERE `guid` IN (83191,83194);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
+(83191,831910,0,0,1,0,0,""),
+(83194,831940,0,0,1,0,0,"");
+
+-- No waypoints for Tempest-Forge Destroyer on second floor
+DELETE FROM `creature_addon` WHERE `guid` IN (83233,83234);
+DELETE FROM `waypoint_data` WHERE `id` IN (832330,832340);
+
+-- One Mechanar Tinkerer should run
+UPDATE `waypoint_data` SET `move_type` = 1 WHERE `id` IN (832080);
+
+-- Fix addon data
+
+-- Fix sheath
+UPDATE `creature_addon` SET `bytes2` = 1 WHERE `guid` IN (83165,83239);
+UPDATE `creature_template_addon` SET `bytes2` = 1 WHERE `entry` IN (19218,19219,19220,19710,21525,21526,21533,21537);
+-- Empty / not needed
+DELETE FROM `creature_template_addon` WHERE `entry` IN (20405,21534);
+
+-- Missing emotes
+DELETE FROM `creature_addon` WHERE `guid` IN (83223,83222,83219,83220,83210,83209,83212,83211,83203,83202,83200,83166,83167,83170,83201,83171,83182,83183);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
+(83223,0,0,0,1,173,0,""),
+(83222,0,0,0,1,173,0,""),
+(83219,0,0,0,1,173,0,""),
+(83220,0,0,0,1,173,0,""),
+(83210,0,0,0,1,173,0,""),
+(83209,0,0,0,1,173,0,""),
+(83212,0,0,0,1,173,0,""),
+(83211,0,0,0,1,173,0,""),
+(83203,0,0,0,1,173,0,""),
+(83202,0,0,0,1,173,0,""),
+(83200,0,0,0,1,173,0,""),
+(83166,0,0,0,1,173,0,""),
+(83167,0,0,0,1,173,0,""),
+(83170,0,0,0,1,173,0,""),
+(83201,0,0,0,1,173,0,""),
+(83171,0,0,0,1,173,0,""),
+(83182,0,0,0,1,173,0,""),
+(83183,0,0,0,1,173,0,"");
+
+-- Standardize respawn time
+UPDATE `creature` SET `spawntimesecs` = 7200 WHERE `id` IN (19168,19510);
+UPDATE `creature` SET `spawntimesecs` = 86400 WHERE `id` IN (19218,19219,19220,19221,19710);