DB/Creature: Fix some spawns on top of Shadow Vault

(cherry picked from commit d1a6546ff78d273d1759f9af5a2d26424739710c)

1 files changed, 64 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_11_09_00_world_2018_09_17_01_world.sql b/sql/updates/world/master/2021_11_09_00_world_2018_09_17_01_world.sql
new file mode 100644
index 00000000000..8a00bfec973
--- /dev/null
+++ b/sql/updates/world/master/2021_11_09_00_world_2018_09_17_01_world.sql
@@ -0,0 +1,64 @@
+-- 
+DELETE FROM `creature_addon` WHERE `guid` IN (209098);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `auras`) VALUES  
+(209098, 2090980, 0, 0, '');
+UPDATE `creature` SET `position_x`=8442.81, `position_y`=2738.87, `position_z`=759.958, `MovementType` = 2 WHERE `guid` IN (209098);
+DELETE FROM `waypoint_data` WHERE `id`=2090980;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(2090980, 1, 8456.4687, 2752.330, 759.957, 3.946624, 0, 0, 0, 100, 0),
+(2090980, 2, 8439.2714, 2732.363, 759.957, 4.013381, 0, 0, 0, 100, 0),
+(2090980, 3, 8417.5234, 2690.753, 759.958, 4.384489, 0, 0, 0, 100, 0),
+(2090980, 4, 8413.6376, 2661.341, 759.958, 4.700219, 0, 0, 0, 100, 0),
+(2090980, 5, 8417.5410, 2633.386, 759.958, 4.881646, 0, 0, 0, 100, 0),
+(2090980, 6, 8428.3886, 2606.724, 759.958, 5.237431, 0, 0, 0, 100, 0),
+(2090980, 7, 8449.9873, 2582.967, 759.958, 5.513106, 0, 0, 0, 100, 0),
+(2090980, 8, 8471.9550, 2568.648, 759.958, 5.788781, 0, 0, 0, 100, 0),
+(2090980, 9, 8498.3876, 2557.482, 759.958, 6.026756, 0, 0, 0, 100, 0),
+(2090980, 10, 8520.1494, 2554.612, 759.958, 6.219965, 0, 0, 0, 100, 0),
+(2090980, 11, 8544.6005, 2553.064, 759.958, 6.219965, 0, 0, 0, 100, 0),
+(2090980, 12, 8566.8173, 2561.380, 759.958, 0.417443, 0, 0, 0, 100, 0),
+(2090980, 13, 8592.1015, 2574.674, 759.958, 0.886326, 0, 0, 0, 100, 0),
+(2090980, 14, 8608.0019, 2588.354, 759.958, 0.964080, 0, 0, 0, 100, 0),
+(2090980, 15, 8622.9794, 2611.412, 759.958, 1.081890, 0, 0, 0, 100, 0),
+(2090980, 16, 8632.0664, 2637.304, 759.958, 1.277454, 0, 0, 0, 100, 0),
+(2090980, 17, 8635.7812, 2655.978, 759.958, 1.395264, 0, 0, 0, 100, 0),
+(2090980, 18, 8638.5332, 2680.815, 759.958, 1.513074, 0, 0, 0, 100, 0),
+(2090980, 19, 8631.7646, 2702.789, 759.958, 1.958395, 0, 0, 0, 100, 0),
+(2090980, 20, 8620.1142, 2727.315, 759.958, 2.238782, 0, 0, 0, 100, 0),
+(2090980, 21, 8602.6484, 2743.659, 759.958, 2.408428, 0, 0, 0, 100, 0),
+(2090980, 22, 8585.5878, 2756.740, 759.958, 2.507388, 0, 0, 0, 100, 0),
+(2090980, 23, 8547.3623, 2771.712, 759.958, 2.820762, 0, 0, 0, 100, 0),
+(2090980, 24, 8585.5878, 2756.740, 759.958, 2.507388, 0, 0, 0, 100, 0),
+(2090980, 25, 8602.6484, 2743.659, 759.958, 2.408428, 0, 0, 0, 100, 0),
+(2090980, 26, 8620.1142, 2727.315, 759.958, 2.238782, 0, 0, 0, 100, 0),
+(2090980, 27, 8631.7646, 2702.789, 759.958, 1.958395, 0, 0, 0, 100, 0),
+(2090980, 28, 8638.5332, 2680.815, 759.958, 1.513074, 0, 0, 0, 100, 0),
+(2090980, 29, 8635.7812, 2655.978, 759.958, 1.395264, 0, 0, 0, 100, 0),
+(2090980, 30, 8632.0664, 2637.304, 759.958, 1.277454, 0, 0, 0, 100, 0),
+(2090980, 31, 8622.9794, 2611.412, 759.958, 1.081890, 0, 0, 0, 100, 0),
+(2090980, 32, 8608.0019, 2588.354, 759.958, 0.964080, 0, 0, 0, 100, 0),
+(2090980, 33, 8592.1015, 2574.674, 759.958, 0.886326, 0, 0, 0, 100, 0),
+(2090980, 34, 8566.8173, 2561.380, 759.958, 0.417443, 0, 0, 0, 100, 0),
+(2090980, 35, 8544.6005, 2553.064, 759.958, 6.219965, 0, 0, 0, 100, 0),
+(2090980, 36, 8520.1494, 2554.612, 759.958, 6.219965, 0, 0, 0, 100, 0),
+(2090980, 37, 8498.3876, 2557.482, 759.958, 6.026756, 0, 0, 0, 100, 0),
+(2090980, 38, 8471.9550, 2568.648, 759.958, 5.788781, 0, 0, 0, 100, 0),
+(2090980, 39, 8449.9873, 2582.967, 759.958, 5.513106, 0, 0, 0, 100, 0),
+(2090980, 40, 8428.3886, 2606.724, 759.958, 5.237431, 0, 0, 0, 100, 0),
+(2090980, 41, 8417.5410, 2633.386, 759.958, 4.881646, 0, 0, 0, 100, 0),
+(2090980, 42, 8413.6376, 2661.341, 759.958, 4.700219, 0, 0, 0, 100, 0),
+(2090980, 43, 8417.5234, 2690.753, 759.958, 4.384489, 0, 0, 0, 100, 0),
+(2090980, 44, 8439.2714, 2732.363, 759.957, 4.013381, 0, 0, 0, 100, 0),
+(2090980, 45, 8456.4687, 2752.330, 759.957, 3.946624, 0, 0, 0, 100, 0);
+
+UPDATE `creature` SET `position_x`=8492.125977, `position_y`=2555.663818, `position_z`=759.957397, `orientation`=2.473193 WHERE `guid`=209085;
+UPDATE `creature` SET `position_x`=8536.571289, `position_y`=2547.800781, `position_z`=759.959534, `orientation`=2.673477 WHERE `guid`=152127;
+UPDATE `creature` SET `position_x`=8601.501953, `position_y`=2577.823486, `position_z`=759.956787, `orientation`=0.242651 WHERE `guid`=209081;
+
+DELETE FROM `creature` WHERE `guid` IN (86511,86512,86513);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
+(86511, 29719, 571, 0, 0, '', 170, 0, 0, 8562.84, 2770.26, 759.957, 1.48907, 300, 0, 0, 12175, 0, 0, 0, 0, 0),
+(86512, 29720, 571, 0, 0, '', 170, 0, 0, 8631.7, 2624.14, 759.958, 1.15527, 300, 0, 0, 12600, 0, 0, 0, 0, 0),
+(86513, 29722, 571, 0, 0, '', 170, 0, 0, 8633.92, 2700.02, 759.958, 2.72212, 300, 0, 0, 12175, 0, 0, 0, 0, 0);
+
+UPDATE `creature` SET `MovementType`=1, `spawndist`=5 WHERE `guid` IN (86511,86512,86513,209085,152127,209081,152137,209080,152160,152131);