diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2021_01_15_01_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_01_15_01_world.sql b/sql/updates/world/3.3.5/2021_01_15_01_world.sql new file mode 100644 index 00000000000..d0344515d13 --- /dev/null +++ b/sql/updates/world/3.3.5/2021_01_15_01_world.sql @@ -0,0 +1,14 @@ +-- Sniff +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ 2 WHERE `entry` = 21316; -- Deathforged Infernal +UPDATE `creature_template` SET `npcflag` = 3, `speed_walk` = 1, `BaseAttackTime` = 2000, `RangeAttackTime` = 2000, `unit_flags` = 33536 WHERE `entry` = 22421; -- Skar'this the Heretic +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ 2 WHERE `entry` = 31131; -- Containment Crystal +UPDATE `creature_template` SET `unit_flags` = 33554432+768 WHERE `entry` = 1921; -- Combat Dummy +DELETE FROM `creature_template_addon` WHERE `entry` = 1921; +INSERT INTO `creature_template_addon` (`entry`,`auras`) VALUES +(1921,'7056'); + +-- CreatureDifficulty +UPDATE `creature_template` SET `unit_flags` = 33554432+256 WHERE `entry` = 23968; -- Hanes Fire Trigger +UPDATE `creature_template` SET `unit_flags` = 33554432+256 WHERE `entry` = 23310; -- Fel Portal Alarm +UPDATE `creature_template` SET `unit_flags` = 33536 WHERE `entry` = 22073; -- Marcus Auralion +UPDATE `creature_template` SET `unit_flags` = 32768 WHERE `entry` = 22941; -- Mog'dorg the Wizened |