DB/Creature: Exodar's Elementals & Seer Skaltesh

(cherry picked from commit 1c799e5ff23b3349b4c8bc587f0116f126956fdd)

1 files changed, 124 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_12_05_16_world_2019_05_12_00_world.sql b/sql/updates/world/master/2021_12_05_16_world_2019_05_12_00_world.sql
new file mode 100644
index 00000000000..0a87cd09986
--- /dev/null
+++ b/sql/updates/world/master/2021_12_05_16_world_2019_05_12_00_world.sql
@@ -0,0 +1,124 @@
+-- 
+UPDATE `creature_template` SET `unit_flags`=`unit_flags`|33587968 WHERE `entry` IN (18823,18823, 18824, 18825, 18826);
+DELETE FROM `creature` WHERE `guid` IN (104837, 104854, 104855, 104856, 104857, 104858, 104859, 104860, 104861, 104863, 104865, 104866, 104880, 104881, 104882, 104883, 104884, 104888, 104896, 104914, 104923, 104924, 104926, 104930, 104931, 104933, 104934, 104935, 104939, 104940, 104942, 104943, 104951, 104954, 104989, 105015, 105021, 105031, 105033, 105046, 105049, 105050, 105086, 105087, 105088, 105096, 105107, 105110, 105111, 105112, 105129, 105133, 105134, 105142, 105152, 105161,105204);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES
+(104837, 18823, 530, '0', 0, 0, 0, -3799.4, -11423, -139.624, 4.27587, 300, 1, 0, 300, 0, 1),
+(104854, 18823, 530, '0', 0, 0, 0, -3791.95, -11451.5, -139.644, 4.1464, 300, 1, 0, 300, 0, 1),
+(104855, 18823, 530, '0', 0, 0, 0, -3803.1, -11434.9, -139.712, 4.46371, 300, 1, 0, 300, 0, 1),
+(104856, 18823, 530, '0', 0, 0, 0, -3814.3, -11421.2, -139.792, 4.36003, 300, 1, 0, 300, 0, 1),
+(104857, 18823, 530, '0', 0, 0, 0, -3806.98, -11442.9, -139.788, 4.36003, 300, 1, 0, 300, 0, 1),
+(104858, 18823, 530, '0', 0, 0, 0, -3751.3, -11399.1, -138.968, 1.08963, 300, 1, 0, 300, 0, 1),
+(104859, 18823, 530, '0', 0, 0, 0, -3792.68, -11420.2, -138.557, 3.78736, 300, 0, 0, 300, 0, 0),
+(104860, 18823, 530, '0', 0, 0, 0, -3815.35, -11400.1, -139.725, 4.06538, 300, 1, 0, 300, 0, 1),
+(104861, 18823, 530, '0', 0, 0, 0, -3778.16, -11433.2, -139.413, 4.04731, 300, 1, 0, 300, 0, 1),
+(104863, 18823, 530, '0', 0, 0, 0, -3780.37, -11426.2, -138.328, 4.72984, 300, 0, 0, 300, 0, 0),
+(104865, 18823, 530, '0', 0, 0, 0, -3768.58, -11439.6, -139.324, 4.67406, 300, 1, 0, 300, 0, 1),
+(104866, 18823, 530, '0', 0, 0, 0, -3783.15, -11401.4, -137.973, 4.64258, 300, 0, 0, 300, 0, 0),
+(104880, 18823, 530, '0', 0, 0, 0, -3771.51, -11408.2, -137.862, 3.7001, 300, 0, 0, 300, 0, 0),
+(104881, 18823, 530, '0', 0, 0, 0, -3793.62, -11376.6, -139.38, 1.08963, 300, 1, 0, 300, 0, 1),
+(104882, 18823, 530, '0', 0, 0, 0, -3752.58, -11424.6, -139.08, 1.08963, 300, 1, 0, 300, 0, 1),
+(104883, 18823, 530, '0', 0, 0, 0, -3769.76, -11378.4, -139.107, 1.08963, 300, 1, 0, 300, 0, 1),
+(104884, 18823, 530, '0', 0, 0, 0, -3785.69, -11443.6, -139.541, 4.27587, 300, 1, 0, 300, 0, 1),
+(104888, 18823, 530, '0', 0, 0, 0, -3815.24, -11468.2, -138.403, 2.40253, 300, 0, 0, 300, 0, 0),
+(104896, 18824, 530, '0', 0, 0, 0, -3650.66, -11440.7, -110.804, 2.96706, 300, 0, 0, 300, 0, 0),
+(104914, 18824, 530, '0', 0, 0, 0, -3665.57, -11456.6, -118.752, 2.7217, 300, 0, 0, 300, 0, 0),
+(104923, 18824, 530, '0', 0, 0, 0, -3670.37, -11416.3, -118.546, 3.49066, 300, 0, 0, 300, 0, 0),
+(104924, 18824, 530, '0', 0, 0, 0, -3675.12, -11453, -118.939, 4.18879, 300, 0, 0, 300, 0, 0),
+(104926, 18824, 530, '0', 0, 0, 0, -3676.88, -11458.5, -118.957, 3.63029, 300, 0, 0, 300, 0, 0),
+(104930, 18824, 530, '0', 0, 0, 0, -3679.27, -11422.7, -118.851, 2.96706, 300, 0, 0, 300, 0, 0),
+(104931, 18824, 530, '0', 0, 0, 0, -3683.25, -11418.4, -119.13, 2.63545, 300, 0, 0, 300, 0, 0),
+(104933, 18824, 530, '0', 0, 0, 0, -3681.91, -11444.2, -118.99, 3.47321, 300, 0, 0, 300, 0, 0),
+(104934, 18824, 530, '0', 0, 0, 0, -3683.51, -11432.6, -119.004, 3.38594, 300, 0, 0, 300, 0, 0),
+(104935, 18824, 530, '0', 0, 0, 0, -3689.21, -11439.8, -119.22, 3.31613, 300, 0, 0, 300, 0, 0),
+(104939, 18824, 530, '0', 0, 0, 0, -3816.36, -11469.7, -138.424, 2.36386, 300, 0, 0, 300, 0, 0),
+(104940, 18825, 530, '0', 0, 0, 0, -3849.95, -11342.6, -109.201, 2.02458, 300, 0, 0, 300, 0, 0),
+(104942, 18825, 530, '0', 0, 0, 0, -3825.61, -11349, -104.244, 0.593412, 300, 0, 0, 300, 0, 0),
+(104943, 18825, 530, '0', 0, 0, 0, -3873.94, -11360.3, -106.234, 2.18166, 300, 0, 0, 300, 0, 0),
+(104951, 18825, 530, '0', 0, 0, 0, -3796.38, -11375.1, -99.6143, 0.558505, 300, 0, 0, 300, 0, 0),
+(104954, 18825, 530, '0', 0, 0, 0, -3839.92, -11369.9, -103.693, 5.20108, 300, 0, 0, 300, 0, 0),
+(104989, 18825, 530, '0', 0, 0, 0, -3791.31, -11388.5, -100.429, 6.23082, 300, 0, 0, 300, 0, 0),
+(105015, 18825, 530, '0', 0, 0, 0, -3877.07, -11377.9, -106.957, 3.19395, 300, 0, 0, 300, 0, 0),
+(105021, 18825, 530, '0', 0, 0, 0, -3854.28, -11374.9, -103.88, 4.64258, 300, 0, 0, 300, 0, 0),
+(105031, 18825, 530, '0', 0, 0, 0, -3811.24, -11380.8, -101.466, 0.331613, 300, 0, 0, 300, 0, 0),
+(105033, 18825, 530, '0', 0, 0, 0, -3796.22, -11400.7, -100.619, 5.98648, 300, 0, 0, 300, 0, 0),
+(105046, 18825, 530, '0', 0, 0, 0, -3825.24, -11382.2, -103.835, 0.953903, 300, 0, 0, 300, 0, 2),
+(105049, 18825, 530, '0', 0, 0, 0, -3826.09, -11385.7, -103.875, 0.365378, 300, 0, 0, 300, 0, 0),
+(105050, 18825, 530, '0', 0, 0, 0, -3857.96, -11392.2, -104.294, 5.15458, 300, 0, 0, 300, 0, 0),
+(105086, 18825, 530, '0', 0, 0, 0, -3854.63, -11392.7, -104.031, 0.204574, 300, 0, 0, 300, 0, 2),
+(105087, 18825, 530, '0', 0, 0, 0, -3870.16, -11400.6, -106.541, 3.36848, 300, 0, 0, 300, 0, 0),
+(105088, 18825, 530, '0', 0, 0, 0, -3809.35, -11414.3, -102.707, 4.95674, 300, 0, 0, 300, 0, 0),
+(105096, 18825, 530, '0', 0, 0, 0, -3829.95, -11419.9, -101.061, 5.20108, 300, 0, 0, 300, 0, 0),
+(105107, 18825, 530, '0', 0, 0, 0, -3849.59, -11420.4, -107.021, 4.88692, 300, 0, 0, 300, 0, 0),
+(105110, 18825, 530, '0', 0, 0, 0, -3820.53, -11470.3, -138.476, 2.17402, 300, 0, 0, 300, 0, 0),
+(105111, 18826, 530, '0', 0, 0, 0, -3885.67, -11348.1, -127.217, 0.130845, 300, 0, 0, 300, 0, 0),
+(105112, 18826, 530, '0', 0, 0, 0, -3877.06, -11345.6, -127.105, 0.386885, 300, 0, 0, 300, 0, 2),
+(105129, 18826, 530, '0', 0, 0, 0, -3880.88, -11347.4, -127.159, 0.0798266, 300, 0, 0, 300, 0, 0),
+(105133, 18826, 530, '0', 0, 0, 0, -3851.5, -11324, -126.725, 2.12434, 300, 1, 0, 300, 0, 1),
+(105134, 18826, 530, '0', 0, 0, 0, -3881.08, -11320, -126.183, 4.99164, 300, 0, 0, 300, 0, 0),
+(105142, 18826, 530, '0', 0, 0, 0, -3896.84, -11324.8, -126.386, 4.18879, 300, 0, 0, 300, 0, 0),
+(105152, 18826, 530, '0', 0, 0, 0, -3866.22, -11351.7, -127.003, 0.125503, 300, 1, 0, 300, 0, 1),
+(105161, 18826, 530, '0', 0, 0, 0, -3891.67, -11362.7, -127.343, 1.85966, 300, 1, 0, 300, 0, 1),
+(105204, 18826, 530, '0', 0, 0, 0, -3818.11, -11470.5, -138.448, 2.03399, 300, 0, 0, 300, 0, 0);
+
+DELETE FROM `creature_addon` WHERE `guid` IN (105046, 105086, 105112);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`, `visibilityDistanceType`) VALUES
+(105046, 1050460, 0, 0, 0, 0, '8203', 0),
+(105086, 1050860, 0, 0, 0, 0, '8203', 0),
+(105112, 1051120, 0, 0, 0, 0, '8203', 0);
+
+DELETE FROM `waypoint_data` WHERE `id` IN (1050460,1050860,1051120);
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`action`,`move_type`,`action_chance`,`wpguid`) VALUES
+(1050860, 1, -3852.19, -11391.7, -103.918, 0.902298, 0, 0, 0, 100, 0),
+(1050860, 2, -3851.33, -11388.3, -103.897, 1.82907, 0, 0, 0, 100, 0),
+(1050860, 3, -3852.27, -11386.1, -103.899, 2.51001, 0, 0, 0, 100, 0),
+(1050860, 4, -3858.35, -11386.5, -103.973, 3.72659, 0, 0, 0, 100, 0),
+(1050860, 5, -3860.23, -11389.4, -104.027, 4.91307, 0, 0, 0, 100, 0),
+(1050860, 6, -3858.07, -11393.2, -104.626, 5.5728, 0, 0, 0, 100, 0),
+(1050860, 7, -3854.56, -11393.7, -103.954, 0.145696, 0, 0, 0, 100, 0),
+(1050460, 1, -3825.29, -11378.4, -103.603, 2.06599, 0, 0, 0, 100, 0),
+(1050460, 2, -3828.12, -11376, -103.578, 2.85218, 0, 0, 0, 100, 0),
+(1050460, 3, -3831.58, -11377, -103.621, 3.6532, 0, 0, 0, 100, 0),
+(1050460, 4, -3834.34, -11380.3, -103.664, 4.24539, 0, 0, 0, 100, 0),
+(1050460, 5, -3833.97, -11382.9, -103.673, 5.28604, 0, 0, 0, 100, 0),
+(1050460, 6, -3830.73, -11385.4, -103.646, 5.89472, 0, 0, 0, 100, 0),
+(1050460, 7, -3826.61, -11384.8, -103.595, 0.689098, 0, 0, 0, 100, 0),
+(1050460, 8, -3824.3, -11382.2, -104.172, 1.2426, 0, 0, 0, 100, 0),
+(1051120, 1, -3870.65, -11340.3, -127.013, 0.803124, 0, 0, 0, 100, 0),
+(1051120, 2, -3864.55, -11332.1, -126.908, 1.24295, 0, 0, 0, 100, 0),
+(1051120, 3, -3863.37, -11320.3, -126.851, 1.63643, 0, 0, 0, 100, 0),
+(1051120, 4, -3869.07, -11308.3, -126.871, 2.35664, 0, 0, 0, 100, 0),
+(1051120, 5, -3879.48, -11300.7, -126.965, 2.86479, 0, 0, 0, 100, 0),
+(1051120, 6, -3890.15, -11299.5, -127.084, 3.22137, 0, 0, 0, 100, 0),
+(1051120, 7, -3900.41, -11302.1, -127.215, 3.49233, 0, 0, 0, 100, 0),
+(1051120, 8, -3908.78, -11308.3, -127.337, 4.02247, 0, 0, 0, 100, 0),
+(1051120, 9, -3914.22, -11320, -127.446, 4.3814, 0, 0, 0, 100, 0),
+(1051120, 10, -3912.62, -11334.1, -127.481, 5.17857, 0, 0, 0, 100, 0),
+(1051120, 11, -3906.07, -11343.2, -127.44, 5.62467, 0, 0, 0, 100, 0),
+(1051120, 12, -3896.62, -11349, -127.351, 6.01658, 0, 0, 0, 100, 0),
+(1051120, 13, -3884.77, -11349.9, -127.211, 0.122168, 0, 0, 0, 100, 0),
+(1051120, 14, -3876.87, -11346, -127.105, 0.616969, 0, 0, 0, 100, 0);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (105046, 105086, 105112);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(105112, 105112, 0, 0, 515),
+(105112, 105129, 3, 0, 515),
+(105112, 105111, 6, 0, 515),
+(105086, 105086, 0, 0, 515),
+(105086, 105050, 3, 0, 515),
+(105046, 105046, 0, 0, 515),
+(105046, 105049, 3, 0, 515);
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (18823, 18824, 18825, 18826);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES
+(18823, 0, 0, 0, 0, "8203"),
+(18824, 0, 0, 0, 0, "8203"),
+(18825, 0, 0, 0, 0, "8203"),
+(18826, 0, 0, 0, 0, "8203");
+
+DELETE FROM `gossip_menu_option_action` WHERE `MenuId`=7859;
+INSERT INTO `gossip_menu_option_action` (`MenuId`,`OptionIndex`,`ActionMenuId`,`ActionPoiId`) VALUES
+(7859,0,7858,0);
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=18985;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=18985 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
+(18985,0,0,0,62,0,100,0,7859,0,0,0,0,11,33137,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Seer Skaltesh - On gossip select - cast Serverside - Create Elemental Sapta");