DB/Creature: Storm Giant

Closes #22688

(cherry picked from commit ba61590b9809de61a3597b12810f5036d966887e)

1 files changed, 81 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_11_15_25_world_2018_10_20_17_world.sql b/sql/updates/world/master/2021_11_15_25_world_2018_10_20_17_world.sql
new file mode 100644
index 00000000000..e9df0b003bd
--- /dev/null
+++ b/sql/updates/world/master/2021_11_15_25_world_2018_10_20_17_world.sql
@@ -0,0 +1,81 @@
+-- 
+UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 24812;
+DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 24812);
+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`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(24812, 0, 0, 0, 0, 0, 100, 0, 10000, 20000, 13000, 13000, 11, 50084, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Storm Giant - In Combat - Cast \'Hulking Uppercut\''),
+(24812, 0, 1, 0, 0, 0, 100, 0, 30000, 45000, 30000, 30000, 11, 50105, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Storm Giant - In Combat - Cast \'Violent Hurricane\''),
+(24812, 0, 2, 0, 0, 0, 100, 0, 60000, 180000, 60000, 60000, 11, 50100, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Storm Giant - In Combat - Cast \'Stormbolt\'');
+
+-- Fix missing "Floor shaking aura"
+UPDATE `creature_addon` SET `auras` = '44385' WHERE `guid` = 118191;
+
+-- Fix spawn location
+UPDATE `creature` SET `position_x` = 304.510, `position_y` = -4106.474, `position_z` = 268.54007, `orientation` = 5.976871 WHERE `guid` = 118191;
+
+-- Add missing waypoints
+
+DELETE FROM `waypoint_data` WHERE id = 1181910;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(1181910,1,304.510,-4106.474,268.54007,0,125000,0,1160,100,0),-- pause
+(1181910,2,304.510,-4106.474,268.54007,0,0,0,1161,100,0),
+(1181910,3,383.914,-4133.710,259.40900,0,0,0,0,100,0),
+(1181910,4,446.378,-4176.542,246.20914,0,0,0,0,100,0),
+(1181910,5,475.062,-4178.960,242.488,0,0,0,0,100,0),
+(1181910,6,580.991,-4179.122,223.997,0,0,0,0,100,0),
+(1181910,7,689.275,-4156.549,204.987,0,0,0,0,100,0),
+(1181910,8,724.411,-4159.911,201.069,0,0,0,0,100,0),
+(1181910,9,745.911,-4176.706,197.546,0,0,0,0,100,0),
+(1181910,10,816.215,-4192.905,180.047,0,0,0,0,100,0),
+(1181910,11,899.616,-4183.908,168.778,0,0,0,0,100,0),
+(1181910,12,937.891,-4198.534,162.800,0,0,0,0,100,0),
+(1181910,13,1043.220,-4213.536,163.288,0,0,0,0,100,0),
+(1181910,14,1110.894,-4198.615,155.797,0,0,0,0,100,0),
+(1181910,15,1148.987,-4194.373,141.916,0,0,0,0,100,0),
+(1181910,16,1179.702,-4232.540,149.580,0,0,0,0,100,0),
+(1181910,17,1197.951,-4304.097,154.472,0,90000,0,1160,100,0),-- pause
+(1181910,18,1197.951,-4304.097,154.472,0,0,0,1161,100,0),
+(1181910,19,1111.77,-4265.56,158.432,0,0,0,0,100,0),
+(1181910,20,1062.48,-4241.65,161.884,0,0,0,0,100,0),
+(1181910,21,1034.18,-4230.82,163.087,0,0,0,0,100,0),
+(1181910,22,1002.35,-4223.36,161.401,0,0,0,0,100,0),
+(1181910,23,951.425,-4201.92,161.89871,0,0,0,0,100,0),
+(1181910,24,898.738,-4179.98,169.10231,0,0,0,0,100,0),
+(1181910,25,829.567,-4168.01,177.38510,0,0,0,0,100,0),
+(1181910,26,785.056,-4161.68,192.59770,0,0,0,0,100,0),
+(1181910,27,748.261,-4200.37,193.64116,0,0,0,0,100,0),
+(1181910,28,724.342,-4217.84,194.88362,0,0,0,0,100,0),
+(1181910,29,673.389,-4202.66,203.40955,0,0,0,0,100,0),
+(1181910,30,646.720,-4205.43,211.30154,0,0,0,0,100,0),
+(1181910,31,606.431,-4254.27,215.42845,0,0,0,0,100,0),
+(1181910,32,563.004,-4275.79,213.84859,0,0,0,0,100,0),
+(1181910,33,510.775,-4298.60,216.11797,0,0,0,0,100,0),
+(1181910,34,466.352,-4319.00,222.03955,0,0,0,0,100,0),
+(1181910,35,362.060,-4354.63,234.52129,0,0,0,0,100,0),
+(1181910,36,317.677,-4369.28,237.23949,0,0,0,0,100,0),
+(1181910,37,279.331,-4432.36,243.73000,0,0,0,0,100,0),
+(1181910,38,260.301,-4482.54,244.50500,0,0,0,0,100,0),
+(1181910,39,243.717,-4532.50,249.36800,0,0,0,0,100,0),
+(1181910,40,224.597,-4610.57,242.43600,0,0,0,0,100,0),
+(1181910,41,226.232,-4654.71,242.51400,0,0,0,0,100,0),
+(1181910,42,236.078,-4695.39,247.60700,0,0,0,0,100,0),
+(1181910,43,270.498,-4748.665,240.95520,0,0,0,0,100,0),
+(1181910,44,310.688,-4814.151,245.17343,0,0,0,0,100,0),
+(1181910,45,362.946,-4889.690,244.67287,0,0,0,0,100,0),
+(1181910,46,380.519,-4924.783,248.31841,0,0,0,0,100,0),
+(1181910,47,390.393,-4973.824,250.92967,0,65000,0,1160,100,0),-- pause
+(1181910,48,390.393,-4973.824,250.92967,0,0,0,1161,100,0),
+(1181910,49,379.158,-4919.933,248.06503,0,0,0,0,100,0),
+(1181910,50,325.294,-4827.436,246.96730,0,0,0,0,100,0),
+(1181910,51,265.105,-4748.503,242.77686,0,0,0,0,100,0),
+(1181910,52,236.325,-4692.475,247.00789,0,0,0,0,100,0),
+(1181910,53,223.527,-4641.811,241.62323,0,0,0,0,100,0),
+(1181910,54,231.690,-4582.306,245.28857,0,0,0,0,100,0),
+(1181910,55,243.814,-4532.446,249.33992,0,0,0,0,100,0),
+(1181910,56,260.593,-4482.634,244.47821,0,0,0,0,100,0),
+(1181910,57,279.424,-4432.530,243.73056,0,0,0,0,100,0),
+(1181910,58,318.645,-4369.747,236.96910,0,0,0,0,100,0),
+(1181910,59,369.245,-4333.913,235.99368,0,0,0,0,100,0),
+(1181910,60,426.953,-4298.037,234.05560,0,0,0,0,100,0),
+(1181910,61,453.207,-4255.896,235.71815,0,0,0,0,100,0),
+(1181910,62,428.847,-4187.052,247.21219,0,0,0,0,100,0),
+(1181910,63,393.653,-4142.399,256.36652,0,0,0,0,100,0);