diff options
| author | offl <11556157+offl@users.noreply.github.com> | 2021-09-04 02:13:45 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-09-04 02:13:45 +0300 |
| commit | 0e12e23f7784b4a80d3515cb094342cb677e35b2 (patch) | |
| tree | 61d053f6f56f87d1cdb570e0c2bf6a2704e02b27 /sql | |
| parent | 5a60082e5d3a5290f142168c3142c54b000cb2b0 (diff) | |
DB/Creature: Remove remaining non-static flags from DB, finally (#26884)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2021_09_04_00_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_09_04_00_world.sql b/sql/updates/world/3.3.5/2021_09_04_00_world.sql new file mode 100644 index 00000000000..9b6018789fc --- /dev/null +++ b/sql/updates/world/3.3.5/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; |