diff options
| author | offl <offl@users.noreply.github.com> | 2021-01-15 01:49:42 +0200 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2021-01-15 01:49:42 +0200 |
| commit | 3258e4cecdcfcf3b2ff0bae3f8aee9804fcef34f (patch) | |
| tree | 1a03cb2bec9bffbaa10444ad8e1d421f37b5d2f7 | |
| parent | 793e6ae4ae3d4806df9976b30eb64c87c6adda04 (diff) | |
DB/Creature: Remove UNIT_FLAG_NON_ATTACKABLE part 2
Ref #25764
| -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 |