DB/Creature: Ethereum Avenger

(cherry picked from commit c99193325bf403dee392c8d1048b3e4a7cbb7cea)

1 files changed, 43 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_12_08_14_world_2019_05_29_00_world.sql b/sql/updates/world/master/2021_12_08_14_world_2019_05_29_00_world.sql
new file mode 100644
index 00000000000..9ec150d242f
--- /dev/null
+++ b/sql/updates/world/master/2021_12_08_14_world_2019_05_29_00_world.sql
@@ -0,0 +1,43 @@
+-- 
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (22821);
+DELETE FROM `smart_scripts` WHERE `entryorguid`=22821 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
+(22821, 0, 0, 0, 0, 0, 100, 0, 6000, 6000, 15000, 25000, 11, 32064, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ethereum Avenger - IC - Cast Battle Shout'),
+(22821, 0, 1, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 12980, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ethereum Avenger - On respawn - Cast Simple Teleport'),
+(22821, 0, 2, 0, 0, 0, 100, 0, 8000, 10000, 30000, 35000, 11, 39489, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Ethereum Avenger - IC - Cast Enchanted Weapons'),
+(22821, 0, 3, 0, 9, 0, 100, 0, 8, 25, 5000, 5000, 11, 36509, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Ethereum Avenger - In Range - Cast Enchanted Weapons');
+
+DELETE FROM `creature` WHERE `guid` IN (106838, 106853, 106887, 106888, 106889, 106890, 106891, 106892, 106893, 106894, 106904, 106905, 106906, 106907, 106920, 106921, 106922, 106923, 106924, 106926, 106927, 106928, 106929, 106954, 106955, 106956, 106957, 106958, 106962, 107014, 107015, 107016)  AND `id` IN (22821);
+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`, `VerifiedBuild`) VALUES
+(106838, 22821, 530, 0, 0, '0', 0, 0, 1, 3674.26, 2234.01, 118.465, 4.35719,  600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106853, 22821, 530, 0, 0, '0', 0, 0, 1, 3600.89, 2116.04, 87.5405, 3.14355, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106887, 22821, 530, 0, 0, '0', 0, 0, 1, 3582.71, 2010.47, 93.8184, 1.92591, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106888, 22821, 530, 0, 0, '0', 0, 0, 1, 3522.36, 1953.91, 82.9403, 5.05508, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106889, 22821, 530, 0, 0, '0', 0, 0, 1, 3599.56, 1913.4, 108.562, 4.1363, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106890, 22821, 530, 0, 0, '0', 0, 0, 1, 3549.5, 1902.92, 95.3952, 3.17088, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106891, 22821, 530, 0, 0, '0', 0, 0, 1, 3508.35, 1796.49, 85.835, 4.72255, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106892, 22821, 530, 0, 0, '0', 0, 0, 1, 3697.59, 1731.95, 130.395, 3.70982, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106893, 22821, 530, 0, 0, '0', 0, 0, 1, 3647.64, 1753.84, 119.972, 2.79265, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106894, 22821, 530, 0, 0, '0', 0, 0, 1, 3725.69, 1688.82, 134.715, 1.72775, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106904, 22821, 530, 0, 0, '0', 0, 0, 1, 3703.41, 2274.09, 118.276, 5.11702, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106905, 22821, 530, 0, 0, '0', 0, 0, 1, 3712.99, 1638.35, 128.08, 0.0625406, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106906, 22821, 530, 0, 0, '0', 0, 0, 1, 3750.77, 1579.95, 118.431, 2.35619, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106907, 22821, 530, 0, 0, '0', 0, 0, 1, 3789.25, 1599.69, 127.425, 5.26302, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106920, 22821, 530, 0, 0, '0', 0, 0, 1, 3844.97, 1605.52, 124.019, 0.905721, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106921, 22821, 530, 0, 0, '0', 0, 0, 1, 3873.39, 1643.44, 127.472, 4.65375, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106922, 22821, 530, 0, 0, '0', 0, 0, 1, 3926.7, 1658.54, 129.413, 4.06205, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106923, 22821, 530, 0, 0, '0', 0, 0, 1, 3954.14, 1642.08, 122.924, 2.37553, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106924, 22821, 530, 0, 0, '0', 0, 0, 1, 3636.43, 2305.56, 93.5198, 1.64412, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106926, 22821, 530, 0, 0, '0', 0, 0, 1, 4077.69, 1694.81, 137.102, 1.40693, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106927, 22821, 530, 0, 0, '0', 0, 0, 1, 4079.29, 1726.17, 142.084, 4.75537, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106928, 22821, 530, 0, 0, '0', 0, 0, 1, 4137.91, 1711.12, 125.781, 4.65868, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106929, 22821, 530, 0, 0, '0', 0, 0, 1, 4185.7, 1844.18, 150.349, 0.830289, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106954, 22821, 530, 0, 0, '0', 0, 0, 1, 4279.41, 1756.12, 117.167, 4.13847, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106955, 22821, 530, 0, 0, '0', 0, 0, 1, 4160.81, 2233.26, 171.829, 4.34652, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106956, 22821, 530, 0, 0, '0', 0, 0, 1, 4337.63, 1800.96, 109.496, 4.914, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106957, 22821, 530, 0, 0, '0', 0, 0, 1, 4356.15, 1835.81, 104.489, 0.433499, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106958, 22821, 530, 0, 0, '0', 0, 0, 1, 4300.48, 1847.64, 126.17, 1.84469, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(106962, 22821, 530, 0, 0, '0', 0, 0, 1, 4268.9, 2368.24, 120.335, 0.614006, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(107014, 22821, 530, 0, 0, '0', 0, 0, 1, 4229.52, 1928.51, 144.285, 2.6325, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(107015, 22821, 530, 0, 0, '0', 0, 0, 1, 4152.53, 2178.28, 167.079, 1.2166, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0),
+(107016, 22821, 530, 0, 0, '0', 0, 0, 1, 4127.54, 2191.2, 180.159, 1.2302, 600, 0, 0, 6761, 0, 0, 0, 0, 0, 0);