From 7c67a9568308f3e92dfd1ff36afde09f1d1ceb15 Mon Sep 17 00:00:00 2001 From: offl <11556157+offl@users.noreply.github.com> Date: Tue, 27 May 2025 19:03:22 +0300 Subject: Scripts/Underbog: Rewrite Musel'ek (#30987) --- sql/updates/world/3.3.5/2025_05_27_01_world.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/updates/world/3.3.5/2025_05_27_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2025_05_27_01_world.sql b/sql/updates/world/3.3.5/2025_05_27_01_world.sql new file mode 100644 index 00000000000..e20d44ecebf --- /dev/null +++ b/sql/updates/world/3.3.5/2025_05_27_01_world.sql @@ -0,0 +1,19 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid` = 17826 AND `source_type` = 0; +UPDATE `creature_template` SET `AIName` = '', `ScriptName` = 'boss_swamplord_muselek' WHERE `entry` = 17826; + +DELETE FROM `smart_scripts` WHERE `entryorguid` = 17827 AND `source_type` = 0; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 1782700 AND `source_type` = 9; +UPDATE `creature_template` SET `AIName` = '', `ScriptName` = 'npc_claw' WHERE `entry` = 17827; + +DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_swamplord_muselek_move_away_primer'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(31564, 'spell_swamplord_muselek_move_away_primer'); + +DELETE FROM `creature_formations` WHERE `leaderGUID` = 103246; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(103246,103246,0,0,3,0,0), +(103246,103431,0,0,3,0,0); + +UPDATE `creature_template` SET `gossip_menu_id` = 0, `npcflag` = 0 WHERE `entry` IN (17827,20165); +UPDATE `creature_template` SET `gossip_menu_id` = 7525 WHERE `entry` = 17894; -- cgit v1.2.3