diff options
| author | Houston <69751143+HoustonCore@users.noreply.github.com> | 2020-09-08 22:52:53 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-09-08 16:52:53 -0300 |
| commit | f8db738e8da008ccb48f79f5dd10ebbd81750f5f (patch) | |
| tree | bdbe760b8d70e0eed003ad3ca07692ae4797d8e7 /sql | |
| parent | bb3d3a82d79bce68f82478a8f5b944d2c715ce84 (diff) | |
Scripts/Icecrown: Small event of the down Nerub'ar Broodkeep (#25410)
Updates #25193
Co-authored-by: Keader
Co-authored-by: Ovahlord (sucker)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2020_09_08_00_world.sql (renamed from sql/updates/world/3.3.5/2020_09_08_00_world) | 0 | ||||
| -rw-r--r-- | sql/updates/world/3.3.5/2020_09_08_01_world.sql | 11 |
2 files changed, 11 insertions, 0 deletions
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.sql index 97bfb0b992d..97bfb0b992d 100644 --- a/sql/updates/world/3.3.5/2020_09_08_00_world +++ b/sql/updates/world/3.3.5/2020_09_08_00_world.sql 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); |