From edf511a55123a7e0cf5fd8c8a45d5164889c21a8 Mon Sep 17 00:00:00 2001
From: Houston <69751143+HoustonCore@users.noreply.github.com>
Date: Tue, 8 Sep 2020 22:52:53 +0300
Subject: Scripts/Icecrown: Small event of the down Nerub'ar Broodkeep (#25410)

Updates #25193
Co-authored-by: Keader
Co-authored-by: Ovahlord (sucker)

(cherry picked from commit f8db738e8da008ccb48f79f5dd10ebbd81750f5f)
---
 .../world/master/2022_02_05_04_world_2020_09_08_01_world.sql  | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 sql/updates/world/master/2022_02_05_04_world_2020_09_08_01_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/master/2022_02_05_04_world_2020_09_08_01_world.sql b/sql/updates/world/master/2022_02_05_04_world_2020_09_08_01_world.sql
new file mode 100644
index 00000000000..1449331f8a3
--- /dev/null
+++ b/sql/updates/world/master/2022_02_05_04_world_2020_09_08_01_world.sql
@@ -0,0 +1,11 @@
+-- Nerub'ar broodkeep
+DELETE FROM `areatrigger_scripts` WHERE `entry` IN (5611,5612);
+INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES
+(5611, 'at_icc_nerubar_broodkeeper'),
+(5612, 'at_icc_nerubar_broodkeeper');
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=36725;
+UPDATE `creature_template` SET `AIName` = '', `ScriptName` = 'npc_icc_nerubar_broodkeeper' WHERE `entry`=36725;
+UPDATE `creature_template` SET `flags_extra`=512 WHERE `entry` IN (36725,38058);
+UPDATE `creature_template_addon` SET `bytes1`=0 WHERE `entry` IN (36725,38058);
+UPDATE `creature_template_movement` SET `Flight`=0, `Ground`=1 WHERE `CreatureId` IN (36725,38058);
-- 
cgit v1.2.3