From 3258e4cecdcfcf3b2ff0bae3f8aee9804fcef34f Mon Sep 17 00:00:00 2001 From: offl Date: Fri, 15 Jan 2021 01:49:42 +0200 Subject: DB/Creature: Remove UNIT_FLAG_NON_ATTACKABLE part 2 Ref #25764 --- sql/updates/world/3.3.5/2021_01_15_01_world.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/3.3.5/2021_01_15_01_world.sql (limited to 'sql') 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 -- cgit v1.2.3