diff options
| author | Houston <69751143+HoustonCore@users.noreply.github.com> | 2020-09-08 22:52:53 +0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-02-05 15:50:46 +0100 |
| commit | edf511a55123a7e0cf5fd8c8a45d5164889c21a8 (patch) | |
| tree | d04081e68b0b337a09fb5f74c886b0523f8b43c0 /sql/updates | |
| parent | ee620856ad2918ae7ce91a37a980d9f2129a074a (diff) | |
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)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2022_02_05_04_world_2020_09_08_01_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
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); |