From dde454198a9cb8f43edbb9ef36a54aabd318c711 Mon Sep 17 00:00:00 2001 From: offl <11556157+offl@users.noreply.github.com> Date: Tue, 10 Jun 2025 15:07:46 +0300 Subject: Scripts/Magisters Terrace: Update scripts (#31036) * rewrite Kalec's event * unique enum names, comments for scriptnames for Kael * new register model for Delrissa * new register model for Selin and one missing spell added * several changes for Vexallus --- sql/updates/world/3.3.5/2025_06_10_00_world.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 sql/updates/world/3.3.5/2025_06_10_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2025_06_10_00_world.sql b/sql/updates/world/3.3.5/2025_06_10_00_world.sql new file mode 100644 index 00000000000..5c48f998c07 --- /dev/null +++ b/sql/updates/world/3.3.5/2025_06_10_00_world.sql @@ -0,0 +1,17 @@ +-- Kalec +UPDATE `creature_template` SET `unit_flags` = 0 WHERE `entry` = 24844; +UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` = 24848; +UPDATE `waypoint_data` SET `orientation` = NULL WHERE `id` = 248440 AND `point` = 8; +UPDATE `waypoint_data` SET `move_type` = 1 WHERE `id` = 248440; + +-- Vexallus +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( +'spell_vexallus_clear_energy_feedback', +'spell_vexallus_energy_feedback'); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(47108, 'spell_vexallus_clear_energy_feedback'), +(44328, 'spell_vexallus_energy_feedback'); + +DELETE FROM `creature_text` WHERE `CreatureID` = 24744 AND `GroupID` = 5; +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(24744,5,0,"Vexallus overloads!",41,0,100,0,0,0,23781,0,"vexallus EMOTE_OVERLOAD"); -- cgit v1.2.3