diff options
| author | offl <offl@users.noreply.github.com> | 2021-01-15 01:49:42 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-06 00:04:14 +0100 |
| commit | 09a4bb48375188acc0d29f7a40cc0190d3421988 (patch) | |
| tree | 01bcd80f16a9bd514be31e0c9e883514128a60ec | |
| parent | 24b9d8015901b9165550c6813c0cd0c018a85a46 (diff) | |
DB/Creature: Remove UNIT_FLAG_NON_ATTACKABLE part 2
Ref #25764
(cherry picked from commit 3258e4cecdcfcf3b2ff0bae3f8aee9804fcef34f)
| -rw-r--r-- | sql/updates/world/master/2022_03_05_77_world_2021_01_15_01_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_05_77_world_2021_01_15_01_world.sql b/sql/updates/world/master/2022_03_05_77_world_2021_01_15_01_world.sql new file mode 100644 index 00000000000..d0344515d13 --- /dev/null +++ b/sql/updates/world/master/2022_03_05_77_world_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 |