From f8db738e8da008ccb48f79f5dd10ebbd81750f5f 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)
---
 sql/updates/world/3.3.5/2020_09_08_00_world     | 15 ---------------
 sql/updates/world/3.3.5/2020_09_08_00_world.sql | 15 +++++++++++++++
 sql/updates/world/3.3.5/2020_09_08_01_world.sql | 11 +++++++++++
 3 files changed, 26 insertions(+), 15 deletions(-)
 delete mode 100644 sql/updates/world/3.3.5/2020_09_08_00_world
 create mode 100644 sql/updates/world/3.3.5/2020_09_08_00_world.sql
 create mode 100644 sql/updates/world/3.3.5/2020_09_08_01_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2020_09_08_00_world b/sql/updates/world/3.3.5/2020_09_08_00_world
deleted file mode 100644
index 97bfb0b992d..00000000000
--- a/sql/updates/world/3.3.5/2020_09_08_00_world
+++ /dev/null
@@ -1,15 +0,0 @@
--- Disable movement flag updates for Grauf and let script handle them
-UPDATE `creature_template` SET `flags_extra` = `flags_extra`| 0x200 WHERE `entry`=26893;
--- Disable movement flag updates for Blood-Queen Lana'thel
-UPDATE `creature_template_movement` SET `Ground`= 1, `Flight`= 0 WHERE `CreatureId` IN (37955, 38434, 38435, 38436);
-UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (37955, 38434, 38435, 38436);
--- Disable movement flag updates for Malygos
-UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (28859, 31734);
--- Disable movement flag updates for Razorscale
-UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (33186, 33724);
-UPDATE `creature_template_movement` SET `Ground`= 1 WHERE `CreatureId` IN (33186, 33724);
--- Disable movement flag updates for Enslaved Proto-Drake
-UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (24083, 31669);
-UPDATE `creature_template_movement` SET `Ground`= 1 WHERE `CreatureId` IN (24083, 31669);
--- Disable movement flag updates for Enslaved Netherwing Drake
-UPDATE `creature_template` SET `flags_extra` = `flags_extra`| 0x200 WHERE `entry`=21722;
diff --git a/sql/updates/world/3.3.5/2020_09_08_00_world.sql b/sql/updates/world/3.3.5/2020_09_08_00_world.sql
new file mode 100644
index 00000000000..97bfb0b992d
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_09_08_00_world.sql
@@ -0,0 +1,15 @@
+-- Disable movement flag updates for Grauf and let script handle them
+UPDATE `creature_template` SET `flags_extra` = `flags_extra`| 0x200 WHERE `entry`=26893;
+-- Disable movement flag updates for Blood-Queen Lana'thel
+UPDATE `creature_template_movement` SET `Ground`= 1, `Flight`= 0 WHERE `CreatureId` IN (37955, 38434, 38435, 38436);
+UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (37955, 38434, 38435, 38436);
+-- Disable movement flag updates for Malygos
+UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (28859, 31734);
+-- Disable movement flag updates for Razorscale
+UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (33186, 33724);
+UPDATE `creature_template_movement` SET `Ground`= 1 WHERE `CreatureId` IN (33186, 33724);
+-- Disable movement flag updates for Enslaved Proto-Drake
+UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (24083, 31669);
+UPDATE `creature_template_movement` SET `Ground`= 1 WHERE `CreatureId` IN (24083, 31669);
+-- Disable movement flag updates for Enslaved Netherwing Drake
+UPDATE `creature_template` SET `flags_extra` = `flags_extra`| 0x200 WHERE `entry`=21722;
diff --git a/sql/updates/world/3.3.5/2020_09_08_01_world.sql b/sql/updates/world/3.3.5/2020_09_08_01_world.sql
new file mode 100644
index 00000000000..1449331f8a3
--- /dev/null
+++ b/sql/updates/world/3.3.5/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