DB/Instance/Botanica: Overhaul part 2: Positions & misc

1 files changed, 226 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2021_05_04_02_world.sql b/sql/updates/world/3.3.5/2021_05_04_02_world.sql
new file mode 100644
index 00000000000..16bfcce110b
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_05_04_02_world.sql
@@ -0,0 +1,226 @@
+--
+UPDATE `creature` SET `position_x` = -6.33425, `position_y` = 59.407, `position_z` = -5.55881, `orientation` = 0.030197, `VerifiedBuild` = 15595 WHERE `guid` = 83151 AND `id` = 17993; -- CreateObject2, default position before waypoint was loaded
+UPDATE `creature` SET `position_x` = 3.70889, `position_y` = 59.1549, `position_z` = -5.55738, `orientation` = 3.20157, `VerifiedBuild` = 15595 WHERE `guid` = 83152 AND `id` = 17993; -- CreateObject2, default position before waypoint was loaded
+UPDATE `creature` SET `position_x` = -5.041232, `position_y` = 89.27867, `position_z` = -5.666417, `orientation` = 4.8171086 WHERE `guid` = 83155 AND `id` = 17993; -- CreateObject1, not default, position after waypoint was finished
+UPDATE `creature` SET `position_x` = 2.6413941, `position_y` = 89.34601, `position_z` = -5.6321697, `orientation` = 4.8171086 WHERE `guid` = 83154 AND `id` = 17993; -- CreateObject1, not default, position after waypoint was finished
+UPDATE `creature` SET `position_x` = -8.37349, `position_y` = 150.827, `position_z` = -5.45702, `orientation` = 0.191986, `VerifiedBuild` = 15595 WHERE `guid` = 82984 AND `id` = 17993; -- CreateObject1, default position before waypoint was loaded
+UPDATE `creature` SET `position_x` = 6.78807, `position_y` = 151.432, `position_z` = -5.45704, `orientation` = 5.51524, `VerifiedBuild` = 15595 WHERE `guid` = 83156 AND `id` = 17993; -- CreateObject1, default position before waypoint was loaded
+UPDATE `creature` SET `position_x` = -3.43691, `position_y` = 163.531, `position_z` = -5.45704, `orientation` = 1.15192, `VerifiedBuild` = 15595 WHERE `guid` = 83150 AND `id` = 18419;
+UPDATE `creature` SET `position_x` = 15.8812, `position_y` = 195.363, `position_z` = -5.45708, `orientation` = 0.244346, `VerifiedBuild` = 15595 WHERE `guid` = 82978 AND `id` = 18419;
+UPDATE `creature` SET `position_x` = 5.66246, `position_y` = 166.799, `position_z` = -5.45705, `orientation` = 5.3058, `VerifiedBuild` = 15595, `wander_distance` = 3, `MovementType` = 1 WHERE `guid` = 127286 AND `id` = 19633;
+UPDATE `creature` SET `position_x` = -11.2663, `position_y` = 201.123, `position_z` = -5.45702, `orientation` = 5.51524, `VerifiedBuild` = 15595 WHERE `guid` = 82980 AND `id` = 19633;
+UPDATE `creature` SET `position_x` = 10.6196, `position_y` = 202.391, `position_z` = -5.45705, `orientation` = 4.13643, `VerifiedBuild` = 15595 WHERE `guid` = 82979 AND `id` = 19633;
+UPDATE `creature` SET `position_x` = -14.2483, `position_y` = 197.646, `position_z` = -5.45702, `orientation` = 2.49582, `VerifiedBuild` = 15595 WHERE `guid` = 82982 AND `id` = 18419;
+UPDATE `creature` SET `position_x` = -8.30962, `position_y` = 231.934, `position_z` = -5.45701, `orientation` = 0.349066, `VerifiedBuild` = 15595 WHERE `guid` = 82991 AND `id` = 17993; -- CreateObject1, default position before waypoint was loaded
+UPDATE `creature` SET `position_x` = 6.90713, `position_y` = 230.813, `position_z` = -5.45704, `orientation` = 3.45575, `VerifiedBuild` = 15595 WHERE `guid` = 82985 AND `id` = 17993; -- CreateObject1, default position before waypoint was loaded
+UPDATE `creature` SET `position_x` = -0.755704, `position_y` = 255.12, `position_z` = -5.40764, `orientation` = 1.67552, `VerifiedBuild` = 15595 WHERE `guid` = 83000 AND `id` = 19633;
+UPDATE `creature` SET `orientation` = 2.14675, `VerifiedBuild` = 15595 WHERE `guid` = 82994 AND `id` = 18419;
+UPDATE `creature` SET `orientation` = 0.977384, `VerifiedBuild` = 15595 WHERE `guid` = 82993 AND `id` = 18419;
+UPDATE `creature` SET `position_x` = 32.3466, `position_y` = 283.21, `position_z` = -5.56045, `orientation` = 1.8326, `VerifiedBuild` = 15595 WHERE `guid` = 83001 AND `id` = 17993; -- CreateObject1, default position before waypoint was loaded
+UPDATE `creature` SET `position_x` = 32.7476, `position_y` = 292.832, `position_z` = -5.56217, `orientation` = 5.32325, `VerifiedBuild` = 15595 WHERE `guid` = 83002 AND `id` = 17993; -- CreateObject1, default position before waypoint was loaded
+UPDATE `creature` SET `position_x` = -35.5817, `position_y` = 287.674, `position_z` = -1.76399, `orientation` = 1.5708, `VerifiedBuild` = 15595 WHERE `guid` = 82995 AND `id` = 17994;
+UPDATE `creature` SET `position_x` = 63.8407, `position_y` = 391.882, `position_z` = -27.8938, `orientation` = 3.21141, `VerifiedBuild` = 15595 WHERE `guid` = 82990 AND `id` = 17977;
+UPDATE `creature` SET `position_x` = 75.0124, `position_y` = 283.882, `position_z` = -5.39203, `orientation` = 1.76278, `VerifiedBuild` = 15595 WHERE `guid` = 83004 AND `id` = 17993; -- CreateObject1, default position before waypoint was loaded
+UPDATE `creature` SET `position_x` = 75.302, `position_y` = 292.336, `position_z` = -5.38124, `orientation` = 4.95674, `VerifiedBuild` = 15595 WHERE `guid` = 83005 AND `id` = 17993; -- CreateObject1, default position before waypoint was loaded
+UPDATE `creature` SET `position_x` = 76.7734, `position_y` = 282.637, `position_z` = -5.33021, `orientation` = 1.81514, `VerifiedBuild` = 15595, `MovementType` = 0 WHERE `guid` = 83006 AND `id` = 18404; -- CreateObject1, default position before waypoint was loaded
+DELETE FROM `waypoint_data` WHERE `id` IN (830060);
+DELETE FROM `creature_addon` WHERE `guid` IN (83006);
+
+UPDATE `creature` SET `position_x` = 161.403, `position_y` = 285.599, `position_z` = -3.09818, `orientation` = 2.68781, `VerifiedBuild` = 15595, `id` = 17993 WHERE `guid` = 83013 AND `id` = 18404;
+UPDATE `creature` SET `position_x` = 159.136, `position_y` = 283.813, `position_z` = -3.27211, `orientation` = 2.3911, `VerifiedBuild` = 15595, `id` = 18404 WHERE `guid` = 127287 AND `id` = 17993;
+UPDATE `creature` SET `position_x` = 165.165, `position_y` = 295.535, `position_z` = -4.37166, `orientation` = 3.10985, `VerifiedBuild` = 15595 WHERE `guid` = 127289 AND `id` = 17993;
+UPDATE `creature` SET `position_x` = 153.757, `position_y` = 281.744, `position_z` = -4.0086, `orientation` = 2.17694, `VerifiedBuild` = 15595 WHERE `guid` = 83012 AND `id` = 17993;
+UPDATE `creature` SET `position_x` = 163.108, `position_y` = 287.899, `position_z` = -3.3132, `orientation` = 2.23402, `VerifiedBuild` = 15595 WHERE `guid` = 83015 AND `id` = 17993;
+UPDATE `creature` SET `position_x` = 164.969, `position_y` = 292.952, `position_z` = -4.00805, `orientation` = 2.37285, `VerifiedBuild` = 15595 WHERE `guid` = 127288 AND `id` = 17993;
+UPDATE `creature` SET `position_x` = 149.565, `position_y` = 281.787, `position_z` = -4.65385, `orientation` = 1.01615, `VerifiedBuild` = 15595 WHERE `guid` = 83011 AND `id` = 18404;
+UPDATE `creature` SET `position_x` = 165.194, `position_y` = 298.208, `position_z` = -4.77445, `orientation` = 3.85268, `VerifiedBuild` = 15595 WHERE `guid` = 127290 AND `id` = 18404;
+UPDATE `creature` SET `position_x` = 151.661, `position_y` = 281.789, `position_z` = -4.33475, `orientation` = 1.61228, `VerifiedBuild` = 15595 WHERE `guid` = 83014 AND `id` = 17993;
+
+UPDATE `creature` SET `position_x` = 152.061, `position_y` = 369.717, `position_z` = -5.30307, `orientation` = 0.785398, `VerifiedBuild` = 15595, `id` = 19486 WHERE `guid` = 83016 AND `id` = 18421;
+UPDATE `creature` SET `position_x` = 160.619, `position_y` = 371.029, `position_z` = -5.30307, `orientation` = 3.24631, `VerifiedBuild` = 15595 WHERE `guid` = 83018 AND `id` = 19557;
+UPDATE `creature` SET `position_x` = 152.396, `position_y` = 375.262, `position_z` = -5.30307, `orientation` = 5.42797, `VerifiedBuild` = 15595, `id` = 18421 WHERE `guid` = 83019 AND `id` = 19486;
+UPDATE `creature` SET `position_x` = 198.131, `position_y` = 373.662, `position_z` = -5.42373, `orientation` = 0.471239, `VerifiedBuild` = 15595 WHERE `guid` = 83033 AND `id` = 18421;
+UPDATE `creature` SET `position_x` = 199.583, `position_y` = 372.112, `position_z` = -5.43548, `orientation` = 0.663225, `VerifiedBuild` = 15595 WHERE `guid` = 83032 AND `id` = 18421;
+UPDATE `creature` SET `position_x` = 175.843, `position_y` = 387.166, `position_z` = -5.30306, `orientation` = 2.23402, `VerifiedBuild` = 15595 WHERE `guid` = 83020 AND `id` = 19486;
+UPDATE `creature` SET `position_x` = 197.545, `position_y` = 377.96, `position_z` = -5.40067, `orientation` = 5.63741, `VerifiedBuild` = 15595 WHERE `guid` = 83034 AND `id` = 19486;
+UPDATE `creature` SET `position_x` = 170.202, `position_y` = 387.448, `position_z` = -5.30306, `orientation` = 0.541052, `VerifiedBuild` = 15595 WHERE `guid` = 83029 AND `id` = 18421;
+UPDATE `creature` SET `position_x` = 194.849, `position_y` = 380.179, `position_z` = -5.3831, `orientation` = 1.67552, `VerifiedBuild` = 15595 WHERE `guid` = 83031 AND `id` = 19557;
+UPDATE `creature` SET `position_x` = 161.187, `position_y` = 408.951, `position_z` = -5.30312, `orientation` = 6.26573, `VerifiedBuild` = 15595 WHERE `guid` = 83024 AND `id` = 18422;
+UPDATE `creature` SET `position_x` = 158.615, `position_y` = 411.407, `position_z` = -5.30312, `orientation` = 3.78736, `VerifiedBuild` = 15595 WHERE `guid` = 83021 AND `id` = 19486;
+UPDATE `creature` SET `position_x` = 152.395, `position_y` = 406.044, `position_z` = -5.30312, `orientation` = 0.855211, `VerifiedBuild` = 15595, `id` = 19486 WHERE `guid` = 83048 AND `id` = 18421;
+UPDATE `creature` SET `position_x` = 163.089, `position_y` = 409.039, `position_z` = -5.30312, `orientation` = 2.60054, `VerifiedBuild` = 15595 WHERE `guid` = 83025 AND `id` = 19557;
+UPDATE `creature` SET `position_x` = 152.883, `position_y` = 411.747, `position_z` = -5.30312, `orientation` = 5.37561, `VerifiedBuild` = 15595 WHERE `guid` = 83028 AND `id` = 18421;
+UPDATE `creature` SET `position_x` = 174.261, `position_y` = 496.247, `position_z` = -2.47682, `orientation` = 2.21657, `VerifiedBuild` = 15595 WHERE `guid` = 83049 AND `id` = 18422;
+UPDATE `creature` SET `position_x` = 172.615, `position_y` = 498.358, `position_z` = -2.31229, `orientation` = 4.43314, `VerifiedBuild` = 15595 WHERE `guid` = 83050 AND `id` = 19557;
+UPDATE `creature` SET `position_x` = 170.102, `position_y` = 499.288, `position_z` = -2.20102, `orientation` = 1.29154, `VerifiedBuild` = 15595 WHERE `guid` = 83051 AND `id` = 18421;
+UPDATE `creature` SET `position_x` = 161.825, `position_y` = 508.441, `position_z` = -2.50882, `orientation` = 5.48033, `VerifiedBuild` = 15595 WHERE `guid` = 83055 AND `id` = 18422;
+UPDATE `creature` SET `position_x` = 165.405, `position_y` = 504.418, `position_z` = -2.20859, `orientation` = 0.10472, `VerifiedBuild` = 15595 WHERE `guid` = 83053 AND `id` = 19486;
+UPDATE `creature` SET `position_x` = 163.761, `position_y` = 507.106, `position_z` = -2.36096, `orientation` = 3.50811, `VerifiedBuild` = 15595 WHERE `guid` = 83054 AND `id` = 19557;
+UPDATE `creature` SET `position_x` = 4.9486, `position_y` = 596.578, `position_z` = -15.0783, `orientation` = 4.69494, `VerifiedBuild` = 15595 WHERE `guid` = 83076 AND `id` = 17978;
+
+UPDATE `creature` SET `position_x` = 1.54828, `position_y` = 505.512, `position_z` = -5.23187, `orientation` = 2.28638, `VerifiedBuild` = 15595 WHERE `guid` = 83070 AND `id` = 19505;
+UPDATE `creature` SET `position_x` = 22.3027, `position_y` = 579.251, `position_z` = -17.8083, `orientation` = 2.25147, `VerifiedBuild` = 15595 WHERE `guid` = 83085 AND `id` = 19512;
+UPDATE `creature` SET `position_x` = 20.6579, `position_y` = 570.267, `position_z` = -17.9328, `orientation` = 2.04204, `VerifiedBuild` = 15595 WHERE `guid` = 83084 AND `id` = 19512;
+UPDATE `creature` SET `position_x` = -15.0387, `position_y` = 479.981, `position_z` = -5.40512, `orientation` = 1.39626, `VerifiedBuild` = 15595 WHERE `guid` = 127291 AND `id` = 19509;
+UPDATE `creature` SET `position_x` = -17.3213, `position_y` = 485.099, `position_z` = -5.36875, `orientation` = 2.96706, `VerifiedBuild` = 15595, `id` = 19508 WHERE `guid` = 83159 AND `id` = 18419;
+UPDATE `creature` SET `position_x` = -4.28845, `position_y` = 505.214, `position_z` = -5.22576, `orientation` = 0.820305, `VerifiedBuild` = 15595 WHERE `guid` = 83071 AND `id` = 19505;
+UPDATE `creature` SET `VerifiedBuild` = 15595 WHERE `id` = 19555;
+UPDATE `creature` SET `position_x` = -20.1536, `position_y` = 505.03, `position_z` = -5.22962, `orientation` = 1.27409, `VerifiedBuild` = 15595 WHERE `guid` = 83075 AND `id` = 19505;
+UPDATE `creature` SET `position_x` = -15.6348, `position_y` = 505.633, `position_z` = -5.2228, `orientation` = 2.47837, `VerifiedBuild` = 15595 WHERE `guid` = 83074 AND `id` = 19505;
+UPDATE `creature` SET `position_x` = 13.1327, `position_y` = 569.824, `position_z` = -17.9185, `orientation` = 1.79769, `VerifiedBuild` = 15595 WHERE `guid` = 83083 AND `id` = 19511;
+UPDATE `creature` SET `position_x` = -16.2608, `position_y` = 482.706, `position_z` = -5.38576, `orientation` = 3.94444, `VerifiedBuild` = 15595, `id` = 19508 WHERE `guid` = 83158 AND `id` = 18419;
+UPDATE `creature` SET `position_x` = -9.7173, `position_y` = 588.702, `position_z` = -17.6519, `orientation` = 1.55334, `VerifiedBuild` = 15595 WHERE `guid` = 83077 AND `id` = 19505;
+UPDATE `creature` SET `position_x` = 13.7186, `position_y` = 579.122, `position_z` = -17.7867, `orientation` = 1.98968, `VerifiedBuild` = 15595 WHERE `guid` = 83082 AND `id` = 19511;
+UPDATE `creature` SET `position_x` = -9.98952, `position_y` = 577.369, `position_z` = -17.7983, `orientation` = 1.13446, `VerifiedBuild` = 15595 WHERE `guid` = 83078 AND `id` = 19511;
+UPDATE `creature` SET `position_x` = -8.29304, `position_y` = 568.918, `position_z` = -17.9035, `orientation` = 1.25664, `VerifiedBuild` = 15595 WHERE `guid` = 83079 AND `id` = 19512;
+UPDATE `creature` SET `position_x` = -0.867442, `position_y` = 569.955, `position_z` = -17.8747, `orientation` = 1.44862, `VerifiedBuild` = 15595 WHERE `guid` = 83080 AND `id` = 19511;
+UPDATE `creature` SET `position_x` = 0.125824, `position_y` = 576.989, `position_z` = -17.7821, `orientation` = 1.41372, `VerifiedBuild` = 15595 WHERE `guid` = 83081 AND `id` = 19512;
+UPDATE `creature` SET `position_x` = 20, `position_y` = 588.383, `position_z` = -17.6722, `orientation` = 1.58825, `VerifiedBuild` = 15595 WHERE `guid` = 82988 AND `id` = 19505;
+
+UPDATE `creature` SET `position_x` = -129.174, `position_y` = 503.963, `position_z` = -17.7416, `orientation` = 3.38594, `VerifiedBuild` = 15595 WHERE `guid` = 83091 AND `id` = 19508;
+UPDATE `creature` SET `position_x` = -131.527, `position_y` = 507.604, `position_z` = -17.7416, `orientation` = 4.15388, `VerifiedBuild` = 15595 WHERE `guid` = 83093 AND `id` = 19507;
+UPDATE `creature` SET `position_x` = -150.399, `position_y` = 526.537, `position_z` = -17.7416, `orientation` = 3.63028, `VerifiedBuild` = 15595 WHERE `guid` = 83097 AND `id` = 19507;
+UPDATE `creature` SET `position_x` = -135.687, `position_y` = 508.005, `position_z` = -17.7416, `orientation` = 4.7822, `VerifiedBuild` = 15595 WHERE `guid` = 83094 AND `id` = 19509;
+UPDATE `creature` SET `position_x` = -154.478, `position_y` = 529.907, `position_z` = -17.7416, `orientation` = 3.75246, `VerifiedBuild` = 15595 WHERE `guid` = 83095 AND `id` = 19509;
+UPDATE `creature` SET `position_x` = -161.771, `position_y` = 495.03, `position_z` = -17.7416, `orientation` = 2.93215, `VerifiedBuild` = 15595 WHERE `guid` = 83104 AND `id` = 19509;
+UPDATE `creature` SET `position_x` = -160.49, `position_y` = 499.152, `position_z` = -17.7416, `orientation` = 3.19395, `VerifiedBuild` = 15595 WHERE `guid` = 83103 AND `id` = 19507;
+UPDATE `creature` SET `position_x` = -163.527, `position_y` = 504.29, `position_z` = -17.7416, `orientation` = 3.90954, `VerifiedBuild` = 15595 WHERE `guid` = 83102 AND `id` = 19508;
+
+UPDATE `creature` SET `position_x` = -204.125, `position_y` = 391.249, `position_z` = -11.1943, `orientation` = 0.0174533, `VerifiedBuild` = 15595 WHERE `guid` = 82989 AND `id` = 17980;
+UPDATE `creature` SET `position_x` = -157.669, `position_y` = 471.719, `position_z` = -17.7416, `orientation` = 1.76278, `VerifiedBuild` = 15595 WHERE `guid` = 83106 AND `id` = 17993;
+UPDATE `creature` SET `position_x` = -164.989, `position_y` = 473.034, `position_z` = -17.7416, `orientation` = 1.5708, `VerifiedBuild` = 15595 WHERE `guid` = 83105 AND `id` = 17993;
+UPDATE `creature` SET `position_x` = -151.525, `position_y` = 413.861, `position_z` = -17.6048, `orientation` = 3.735, `VerifiedBuild` = 15595 WHERE `guid` = 83113 AND `id` = 19865;
+UPDATE `creature` SET `position_x` = -172.983, `position_y` = 418.549, `position_z` = -17.631, `orientation` = 2.54818, `VerifiedBuild` = 15595 WHERE `guid` = 83107 AND `id` = 19865;
+UPDATE `creature` SET `position_x` = -158.333, `position_y` = 409.194, `position_z` = -17.6105, `orientation` = 5.95157, `VerifiedBuild` = 15595 WHERE `guid` = 83110 AND `id` = 19513;
+UPDATE `creature` SET `position_x` = -174.267, `position_y` = 401.28, `position_z` = -17.6078, `orientation` = 5.37561, `VerifiedBuild` = 15595 WHERE `guid` = 83112 AND `id` = 19865;
+UPDATE `creature` SET `position_x` = -170.727, `position_y` = 408.12, `position_z` = -17.6117, `orientation` = 0.680678, `VerifiedBuild` = 15595 WHERE `guid` = 83109 AND `id` = 19513;
+UPDATE `creature` SET `position_x` = -155.913, `position_y` = 404.689, `position_z` = -17.6097, `orientation` = 1.11701, `VerifiedBuild` = 15595 WHERE `guid` = 83111 AND `id` = 19513;
+UPDATE `creature` SET `position_x` = -157.645, `position_y` = 396.704, `position_z` = -17.6893, `orientation` = 5.75959, `VerifiedBuild` = 15595 WHERE `guid` = 83114 AND `id` = 19865;
+UPDATE `creature` SET `position_x` = -178.098, `position_y` = 414.293, `position_z` = -17.6069, `orientation` = 5.61996, `VerifiedBuild` = 15595 WHERE `guid` = 83108 AND `id` = 19513;
+UPDATE `creature` SET `position_x` = -173.101, `position_y` = 371.972, `position_z` = -17.6119, `orientation` = 0.698132, `VerifiedBuild` = 15595 WHERE `guid` = 83117 AND `id` = 19513;
+UPDATE `creature` SET `position_x` = -164.314, `position_y` = 371.267, `position_z` = -17.6188, `orientation` = 5.89921, `VerifiedBuild` = 15595 WHERE `guid` = 83115 AND `id` = 19865;
+UPDATE `creature` SET `position_x` = -168.994, `position_y` = 383.447, `position_z` = -17.6124, `orientation` = 4.7822, `VerifiedBuild` = 15595 WHERE `guid` = 83116 AND `id` = 19865;
+UPDATE `creature` SET `position_x` = -157.757, `position_y` = 376.544, `position_z` = -17.6102, `orientation` = 2.07694, `VerifiedBuild` = 15595 WHERE `guid` = 83118 AND `id` = 19513;
+
+-- More adjustments
+DELETE FROM `creature` WHERE
+(`guid` = 131124 AND `id` = 18421) OR
+(`guid` = 131126 AND `id` = 18422) OR
+(`guid` = 131132 AND `id` = 18422);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `MovementType`, `VerifiedBuild`) VALUES
+(131124,18421,553,3,1,0,1,176.38,392.68,-5.30307,3.76991,7200,0,0,15595),
+(131126,18422,553,3,1,0,1,158.949,369.891,-5.30307,0.471239,7200,0,0,15595),
+(131132,18422,553,3,1,0,1,194.021,381.961,-5.3712,5.16617,7200,0,0,15595);
+
+UPDATE `creature` SET `VerifiedBuild` = 15595 WHERE `id` = 19507;
+UPDATE `creature` SET `position_x` = -149.586, `position_y` = 522.217, `position_z` = -17.7416, `orientation` = 2.82743, `VerifiedBuild` = 15595 WHERE `guid` = 83096 AND `id` = 19509;
+
+-- Respawn Frayer Wildling
+DELETE FROM `creature` WHERE `guid` BETWEEN 83119 AND 83149 AND `id` = 19608;
+DELETE FROM `linked_respawn` WHERE `guid` BETWEEN 83139 AND 83149;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `MovementType`, `VerifiedBuild`) VALUES
+(83119,19608,553,3,1,0,0,-13.0343,405.199,-29.0148,0.754147,7200,4,1,15595),
+(83120,19608,553,3,1,0,0,-9.15638,410.512,-28.879,3.49303,7200,4,1,15595),
+(83121,19608,553,3,1,0,0,-7.46136,407.352,-28.8392,3.94953,7200,4,1,15595),
+(83122,19608,553,3,1,0,0,-4.29018,420.944,-28.9792,2.42871,7200,4,1,15595),
+(83123,19608,553,3,1,0,0,-2.72937,402.959,-28.9336,3.16398,7200,4,1,15595),
+(83124,19608,553,3,1,0,0,0.36823,413.128,-28.3446,3.4308,7200,4,1,15595),
+(83125,19608,553,3,1,0,0,1.94827,374.676,-27.4315,4.68567,7200,4,1,15595),
+(83126,19608,553,3,1,0,0,3.88827,367.242,-27.6313,2.74297,7200,4,1,15595),
+(83127,19608,553,3,1,0,0,5.83997,422.016,-28.3754,1.48052,7200,4,1,15595),
+(83128,19608,553,3,1,0,0,6.92837,411.186,-27.3235,5.55949,7200,4,1,15595),
+(83129,19608,553,3,1,0,0,7.79818,408.346,-27.0241,0.317146,7200,4,1,15595),
+(83130,19608,553,3,1,0,0,10.7342,357.139,-28.2445,4.30588,7200,4,1,15595),
+(83131,19608,553,3,1,0,0,11.0021,382.701,-28.2761,2.90529,7200,4,1,15595),
+(83132,19608,553,3,1,0,0,13.8306,404.832,-27.4205,2.30582,7200,4,1,15595),
+(83133,19608,553,3,1,0,0,14.6576,369.384,-26.5336,5.87225,7200,4,1,15595),
+(83134,19608,553,3,1,0,0,17.1652,361.942,-27.0135,2.88033,7200,4,1,15595),
+(83135,19608,553,3,1,0,0,17.9931,370.624,-26.3525,5.40723,7200,4,1,15595),
+(83136,19608,553,3,1,0,0,24.3246,380.767,-27.7211,6.23499,7200,4,1,15595),
+(83137,19608,553,3,1,0,0,28.5972,370.136,-25.8552,0.312821,7200,4,1,15595),
+(83138,19608,553,3,1,0,0,32.8181,363.01,-25.8477,5.16346,7200,4,1,15595);
+
+-- Respawn Mutate Fleshlasher
+DELETE FROM `creature` WHERE `guid` IN (83090,83092,83098,83099,83100,83101) AND `id` = 19598;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `MovementType`, `VerifiedBuild`) VALUES
+(83090,19598,553,3,1,0,0,-144.33441162109375, 524.8846435546875, -17.7415676116943359, 3.560471534729003906,7200,4,1,14007),
+(83092,19598,553,3,1,0,0,-127.187538146972656, 508.097076416015625, -17.7416114807128906, 0.680678427219390869,7200,4,1,14007),
+(83098,19598,553,3,1,0,0,-130.891815185546875, 514.10919189453125, -17.7415962219238281, 0.628318548202514648,7200,4,1,14007),
+(83099,19598,553,3,1,0,0,-148.280593872070312, 533.2904052734375, -17.741546630859375, 2.862339973449707031,7200,4,1,14007),
+(83100,19598,553,3,1,0,0,-158.111770629882812, 507.402069091796875, -17.7415695190429687, 5.497786998748779296,7200,4,1,14007),
+(83101,19598,553,3,1,0,0,-153.206161499023437, 499.780181884765625, -17.7415809631347656, 4.398229598999023437,7200,4,1,14007);
+
+-- Respawn Frayer
+DELETE FROM `creature` WHERE `guid` BETWEEN 83036 AND 83047 AND `id` = 18587;
+DELETE FROM `creature` WHERE `guid` BETWEEN 83057 AND 83069 AND `id` = 18587;
+DELETE FROM `linked_respawn` WHERE `guid` BETWEEN 83061 AND 83069;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `MovementType`, `VerifiedBuild`) VALUES
+(83036,18587,553,3,1,0,0,97.2243,494.32,-6.82091,4.44147,7200,4,1,15595),
+(83037,18587,553,3,1,0,0,98.0451,486.493,-6.73539,1.70497,7200,4,1,15595),
+(83038,18587,553,3,1,0,0,100.366,510.296,-7.01317,0.735936,7200,4,1,15595),
+(83039,18587,553,3,1,0,0,102.725,479.804,-6.56232,5.46288,7200,4,1,15595),
+(83040,18587,553,3,1,0,0,103.053,501.294,-6.92121,1.65004,7200,4,1,15595),
+(83041,18587,553,3,1,0,0,104.58,488.162,-6.77827,1.29549,7200,4,1,15595),
+(83042,18587,553,3,1,0,0,107.958,497.657,-6.89808,1.33652,7200,4,1,15595),
+(83043,18587,553,3,1,0,0,110.008,504.183,-6.97943,5.87513,7200,4,1,15595),
+(83044,18587,553,3,1,0,0,146.464,430.336,-6.55964,3.50811,7200,4,1,15595),
+(83045,18587,553,3,1,0,0,151.994,440.242,-6.74947,1.02761,7200,4,1,15595),
+(83046,18587,553,3,1,0,0,155.634,431.37,-6.6656,4.64258,7200,4,1,15595),
+(83047,18587,553,3,1,0,0,159.291,434.146,-6.7877,3.61906,7200,4,1,15595),
+(83057,18587,553,3,1,0,0,159.47,441.289,-6.81508,3.55823,7200,4,1,15595),
+(83058,18587,553,3,1,0,0,167.6,437.41,-6.8888,3.54838,7200,4,1,15595),
+(83059,18587,553,3,1,0,0,167.787,432.951,-6.80661,2.70526,7200,4,1,15595),
+(83060,18587,553,3,1,0,0,169.468,441.26,-6.92263,5.31778,7200,4,1,15595);
+
+-- Nethervine Trickster
+DELETE FROM `waypoint_data` WHERE `id` IN (830870);
+DELETE FROM `creature_addon` WHERE `guid` IN (83087);
+DELETE FROM `linked_respawn` WHERE `guid` = 83087;
+DELETE FROM `creature` WHERE `guid` = 83087 AND `id` = 19843;
+UPDATE `creature` SET `position_x` = -75.0092, `position_y` = 555.413, `position_z` = -17.8047, `orientation` = 0.292141, `VerifiedBuild` = 15595, `wander_distance` = 5, `MovementType` = 1 WHERE `guid` = 83088 AND `id` = 19843;
+UPDATE `creature` SET `position_x` = -66.3435, `position_y` = 559.584, `position_z` = -17.7857, `orientation` = 6.09604, `VerifiedBuild` = 15595, `wander_distance` = 5, `MovementType` = 1 WHERE `guid` = 83089 AND `id` = 19843;
+
+-- Greater Frayer
+DELETE FROM `creature` WHERE `guid` IN (131133,131135) AND `id` = 19557;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `MovementType`, `VerifiedBuild`) VALUES
+(131133,19557,553,3,1,0,0,185.393,384.42,-5.39148,5.41142,7200,0,0,0),
+(131135,19557,553,3,1,0,0,161.327,377.632,-5.38641,6.28087,7200,0,0,0);
+
+DELETE FROM `creature_formations` WHERE `memberGUID` IN (83030,131133,83017,131135);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(83030,83030,0,0,515,0,0),
+(83030,131133,3,0,515,0,0),
+(83017,83017,0,0,515,0,0),
+(83017,131135,3,0,515,0,0);
+
+-- Nethervine Reaper & Nethervine Inciter
+DELETE FROM `creature` WHERE `guid` IN (131136) AND `id` = 19512;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `MovementType`, `VerifiedBuild`) VALUES
+(131136,19512,553,3,1,0,1,-37.1817,524.029,-10.1643,3.0654,7200,0,0,0);
+
+DELETE FROM `creature_formations` WHERE `memberGUID` IN (83086,131136);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(83086,83086,0,0,515,0,0),
+(83086,131136,3,270,515,0,0);
+
+-- Excess Bloodfalcon
+DELETE FROM `linked_respawn` WHERE `guid` = 82999;
+DELETE FROM `creature` WHERE `guid` = 82999 AND `id` = 18155;
+
+-- Some of missing states
+DELETE FROM `creature_addon` WHERE `guid` IN (83150,82978,82982,83000,83024,131132,131126);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
+(83150,0,0,0,1,69,0,""),
+(82978,0,0,8,1,0,0,""),
+(82982,0,0,8,1,0,0,""),
+(83000,0,0,8,1,0,0,""),
+(83024,0,0,8,1,0,0,""),
+(131126,0,0,8,1,0,0,""),
+(131132,0,0,8,1,0,0,"");
+
+UPDATE `creature_addon` SET `emote` = 69 WHERE `guid` = 82983;
+
+-- Standardize respawn time
+UPDATE `creature` SET `spawntimesecs` = 86400 WHERE `id` IN (17975,17976,17977,17978,17980) AND `map` = 553;
+UPDATE `creature` SET `spawntimesecs` = 7200 WHERE `id` IN (19511) AND `map` = 553;
+UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (19555) AND `map` = 553;