From 8161bce524d4efd3bb30ee15fdce720215c66cc9 Mon Sep 17 00:00:00 2001 From: Teleqraph Date: Fri, 11 Aug 2023 10:59:39 +0200 Subject: Scripts/Spells: Implement Atonement (Passive, pet), Power Leech (Passive, pet) and Essence Devourer (#29170) --- sql/updates/world/master/2023_08_11_01_world.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 sql/updates/world/master/2023_08_11_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2023_08_11_01_world.sql b/sql/updates/world/master/2023_08_11_01_world.sql new file mode 100644 index 00000000000..ad4ccbb8e4b --- /dev/null +++ b/sql/updates/world/master/2023_08_11_01_world.sql @@ -0,0 +1,15 @@ +UPDATE `creature_template` SET `ScriptName`="npc_pet_pri_shadowfiend_mindbender" WHERE `entry` IN (19668, 62982); + +DELETE FROM `creature_template_addon` WHERE `entry`=62982; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(62982, 0, 0, 0, 0, 0, 0, 1, 40, 0, 0, 0, 0, 0, '34429 63623 284621'); -- 34429 - Shadowform | 63623 - Avoidance (Passive) | 284621 - Power Leech (Passive) + +UPDATE `creature_template_addon` SET `auras`='34429 63623 262484' WHERE `entry`=19668; -- 34429 - Shadowform | 63623 - Avoidance (Passive) | 262484 - Power Leech (Passive) + +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_pri_atonement_passive', 'spell_pri_power_leech_passive', 'spell_pri_essence_devourer_heal'); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(195178, 'spell_pri_atonement_passive'), +(262484, 'spell_pri_power_leech_passive'), +(284621, 'spell_pri_power_leech_passive'), +(415673, 'spell_pri_essence_devourer_heal'), +(415676, 'spell_pri_essence_devourer_heal'); -- cgit v1.2.3