DB/Creature: Hemathion

(cherry picked from commit 233259b69da51d42ef9eec0ccba66dccd2a81cbe)

1 files changed, 69 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_11_21_11_world_2019_01_12_02_world.sql b/sql/updates/world/master/2021_11_21_11_world_2019_01_12_02_world.sql
new file mode 100644
index 00000000000..3ed71aab673
--- /dev/null
+++ b/sql/updates/world/master/2021_11_21_11_world_2019_01_12_02_world.sql
@@ -0,0 +1,69 @@
+-- 
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=18692;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=18692 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`,`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
+(18692, 0, 0, 0, 0, 0, 100, 0, 5000, 8000, 5000, 10000, 11, 9573, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Hemathion - IC - cast Flame Breath'),
+(18692, 0, 1, 0, 0, 0, 100, 0, 6000, 12000, 12000, 15000, 11, 14100, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Hemathion - IC - cast Terrifying Roar');
+
+UPDATE `creature` SET `position_x`=2807.900, `position_y`=7239.049, `position_z`=365.2419,`MovementType`=2 WHERE `guid` IN (151919);
+UPDATE `creature` SET `position_x`=1837.670, `position_y`=7158.534, `position_z`=364.3977,`MovementType`=2 WHERE `guid` IN (151920);
+DELETE FROM `creature_addon` WHERE guid IN (151919,151920);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(151919, 1519190, 0, 0, 0, ""),
+(151920, 1519200, 0, 0, 0, "");
+
+DELETE FROM `waypoint_data` WHERE `id` IN (1519190,1519200);
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`action`, `action_chance`) VALUES
+(1519190, 1, 2808.937, 7233.487, 365.1280, 0, 0, 100),
+(1519190, 2, 2779.206, 7215.696, 365.2142, 0, 0, 100),
+(1519190, 3, 2743.240, 7205.846, 366.0741, 0, 0, 100),
+(1519190, 4, 2716.312, 7203.940, 366.7350, 0, 0, 100),
+(1519190, 5, 2682.064, 7222.730, 365.6341, 0, 0, 100),
+(1519190, 6, 2650.470, 7236.354, 365.0051, 0, 0, 100),
+(1519190, 7, 2616.386, 7251.049, 364.5808, 0, 0, 100),
+(1519190, 8, 2582.671, 7240.968, 364.7489, 0, 0, 100),
+(1519190, 9, 2555.349, 7214.797, 366.1460, 0, 0, 100),
+(1519190, 10, 2539.965, 7186.032, 364.5946, 0, 0, 100),
+(1519190, 11, 2522.817, 7155.446, 366.4109, 0, 0, 100),
+(1519190, 12, 2494.828, 7120.387, 364.4929, 0, 0, 100),
+(1519190, 13, 2464.073, 7095.245, 364.7017, 0, 0, 100),
+(1519190, 14, 2422.045, 7101.150, 365.7449, 0, 0, 100),
+(1519190, 15, 2378.711, 7121.377, 365.6288, 0, 0, 100),
+(1519190, 16, 2422.045, 7101.150, 365.7449, 0, 0, 100),
+(1519190, 17, 2464.073, 7095.245, 364.7017, 0, 0, 100),
+(1519190, 18, 2494.828, 7120.387, 364.4929, 0, 0, 100),
+(1519190, 19, 2522.817, 7155.446, 366.4109, 0, 0, 100),
+(1519190, 20, 2539.965, 7186.032, 364.5946, 0, 0, 100),
+(1519190, 21, 2555.349, 7214.797, 366.1460, 0, 0, 100),
+(1519190, 22, 2582.671, 7240.968, 364.7489, 0, 0, 100),
+(1519190, 23, 2616.386, 7251.049, 364.5808, 0, 0, 100),
+(1519190, 24, 2650.470, 7236.354, 365.0051, 0, 0, 100),
+(1519190, 25, 2682.064, 7222.730, 365.6341, 0, 0, 100),
+(1519190, 26, 2716.312, 7203.940, 366.7350, 0, 0, 100),
+(1519190, 27, 2743.240, 7205.846, 366.0741, 0, 0, 100),
+(1519190, 28, 2779.206, 7215.696, 365.2142, 0, 0, 100),
+(1519190, 29, 2808.937, 7233.487, 365.1280, 0, 0, 100),
+(1519190, 30, 2837.030, 7252.176, 364.4406, 0, 0, 100),
+(1519200, 1, 1809.325, 7172.158, 364.5686, 0, 0, 100),
+(1519200, 2, 1815.444, 7204.853, 364.6613, 0, 0, 100),
+(1519200, 3, 1842.546, 7242.146, 364.5812, 0, 0, 100),
+(1519200, 4, 1879.159, 7258.352, 363.8606, 0, 0, 100),
+(1519200, 5, 1915.919, 7275.401, 364.0877, 0, 0, 100),
+(1519200, 6, 1943.618, 7285.081, 364.2040, 0, 0, 100),
+(1519200, 7, 1976.632, 7309.147, 364.5445, 0, 0, 100),
+(1519200, 8, 2014.215, 7319.441, 364.4143, 0, 0, 100),
+(1519200, 9, 2045.852, 7317.113, 364.7148, 0, 0, 100),
+(1519200, 10, 2081.956, 7308.120, 363.9342, 0, 0, 100),
+(1519200, 11, 2098.479, 7283.070, 364.5551, 0, 0, 100),
+(1519200, 12, 2110.944, 7263.135, 364.3823, 0, 0, 100),
+(1519200, 13, 2088.668, 7240.715, 364.6110, 0, 0, 100),
+(1519200, 14, 2083.661, 7218.630, 364.0789, 0, 0, 100),
+(1519200, 15, 2051.243, 7208.448, 363.9794, 0, 0, 100),
+(1519200, 16, 2021.537, 7208.532, 364.3810, 0, 0, 100),
+(1519200, 17, 1995.106, 7195.223, 364.1332, 0, 0, 100),
+(1519200, 18, 1970.707, 7173.648, 364.2836, 0, 0, 100),
+(1519200, 19, 1943.431, 7162.605, 364.5651, 0, 0, 100),
+(1519200, 20, 1918.514, 7157.143, 364.2846, 0, 0, 100),
+(1519200, 21, 1883.808, 7154.668, 364.4753, 0, 0, 100),
+(1519200, 22, 1850.349, 7146.592, 364.0842, 0, 0, 100),
+(1519200, 23, 1835.888, 7151.592, 364.6274, 0, 0, 100);