diff options
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); |