aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorAqua Deus <95978183+aquadeus@users.noreply.github.com>2025-09-07 20:05:47 +0200
committerGitHub <noreply@github.com>2025-09-07 20:05:47 +0200
commitce6a1b7b913120cafc7e8825f688a9f3de9e8b6a (patch)
tree7a0593a63264f48bb088abdddaa23e18aaaccdb2 /sql/updates
parent62e2eb1dfcc440ae182acefc995bd95c0a39bd4a (diff)
Scripts/ReturnToKarazhan: Implement Mana Devourer encounter (#31166)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/master/2025_09_07_03_world.sql22
1 files changed, 22 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_09_07_03_world.sql b/sql/updates/world/master/2025_09_07_03_world.sql
new file mode 100644
index 00000000000..a5be6bbebc6
--- /dev/null
+++ b/sql/updates/world/master/2025_09_07_03_world.sql
@@ -0,0 +1,22 @@
+UPDATE `creature_template` SET `ScriptName`='boss_mana_devourer' WHERE `entry`=114252; -- Mana Devourer
+
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_mana_devourer_coalesce_power', 'spell_mana_devourer_energize', 'spell_mana_devourer_energy_discharge', 'spell_mana_devourer_energy_void');
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(227297, 'spell_mana_devourer_coalesce_power'),
+(227451, 'spell_mana_devourer_energize'),
+(227457, 'spell_mana_devourer_energy_discharge'),
+(227524, 'spell_mana_devourer_energy_void');
+
+DELETE FROM `areatrigger_create_properties` WHERE (`IsCustom`=0 AND `Id` IN (8791,8754));
+INSERT INTO `areatrigger_create_properties` (`Id`, `IsCustom`, `AreaTriggerId`, `IsAreatriggerCustom`, `Flags`, `MoveCurveId`, `ScaleCurveId`, `MorphCurveId`, `FacingCurveId`, `AnimId`, `AnimKitId`, `DecalPropertiesId`, `SpellForVisuals`, `TimeToTargetScale`, `Speed`, `Shape`, `ShapeData0`, `ShapeData1`, `ShapeData2`, `ShapeData3`, `ShapeData4`, `ShapeData5`, `ShapeData6`, `ShapeData7`, `ScriptName`, `VerifiedBuild`) VALUES
+(8791, 0, 12858, 0, 2, 0, 2294, 0, 0, -1, 0, 85, NULL, 120000, 0, 0, 10, 10, 0, 0, 0, 0, 0, 0, 'at_mana_devourer_energy_void', 61967), -- Spell: 227523 (Energy Void)
+(8754, 0, 12831, 0, 0, 0, 0, 0, 0, -1, 0, 0, NULL, 0, 14.09541225433349609, 0, 3, 3, 0, 0, 0, 0, 0, 0, 'at_mana_devourer_loose_mana', 61967); -- Spell: 227296 (Loose Mana)
+
+DELETE FROM `areatrigger_template` WHERE (`IsCustom`=0 AND `Id` IN (12858,12831));
+INSERT INTO `areatrigger_template` (`Id`, `IsCustom`, `Flags`, `VerifiedBuild`) VALUES
+(12858, 0, 0, 61967),
+(12831, 0, 0, 61967);
+
+DELETE FROM `spell_target_position` WHERE `ID` = 231499;
+INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `OrderIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES
+(231499, 0, 0, 1651, 4151.8818359375, -2030.8836669921875, 730.5565185546875, 61967); -- Spell: 231499 (Teleport)