diff options
| author | offl <11556157+offl@users.noreply.github.com> | 2021-09-04 02:13:45 +0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-14 23:56:38 +0100 |
| commit | 0506f21f5ee16b5cdf5f02d5fae22a32a2b1f63e (patch) | |
| tree | d28b076f768e9075c02768007757b05906ffb30c /sql | |
| parent | c50c877bdbbce4453fee6ef756822c96988a60df (diff) | |
DB/Creature: Remove remaining non-static flags from DB, finally (#26884)
(cherry picked from commit 0e12e23f7784b4a80d3515cb094342cb677e35b2)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_03_14_03_world_2021_09_04_00_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_14_03_world_2021_09_04_00_world.sql b/sql/updates/world/master/2022_03_14_03_world_2021_09_04_00_world.sql new file mode 100644 index 00000000000..9b6018789fc --- /dev/null +++ b/sql/updates/world/master/2022_03_14_03_world_2021_09_04_00_world.sql @@ -0,0 +1,5 @@ +-- +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ 2 WHERE `entry` IN (18374,20308,21466,21467,21600,21601,17651,21823,29281,30809,33651,34108); +-- They're only unselectable, their faction is hostile, they don't have auras +-- For now leaving feign death aura, later it should be replaced by passive react state, there's no other option +UPDATE `creature` SET `unit_flags` = 33554496 WHERE `id` = 26620 AND `unit_flags` & 33554432; |