aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoroffl <11556157+offl@users.noreply.github.com>2025-06-10 15:07:46 +0300
committerGitHub <noreply@github.com>2025-06-10 14:07:46 +0200
commitdde454198a9cb8f43edbb9ef36a54aabd318c711 (patch)
tree6b9508c417ace130fb91bd16c88bb2350356cf37 /sql
parent5dfec1dc03d9b56fcf73cedf8f0f5d8c00f8b154 (diff)
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
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2025_06_10_00_world.sql17
1 files changed, 17 insertions, 0 deletions
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");