diff options
| author | Meji <alvaro.megias@outlook.com> | 2025-11-12 12:56:04 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-11-12 12:56:04 +0100 |
| commit | 7ccc2d4f6b972800f96f1631da1ff52542710d72 (patch) | |
| tree | 2d298c70c655eb68a9c46c851a5355d4a7f17d75 /sql/updates | |
| parent | 07e9f3e75ec6b382fa58e0b23619d96748bd9af7 (diff) | |
Core/Creatures: Add UNIT_FLAG2_AI_WILL_ONLY_SWIM_IF_TARGET_SWIMS for creatures using CREATURE_STATIC_FLAG_4_PREVENT_SWIM (#31389)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2025_11_12_00_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_11_12_00_world.sql b/sql/updates/world/master/2025_11_12_00_world.sql new file mode 100644 index 00000000000..8476583c765 --- /dev/null +++ b/sql/updates/world/master/2025_11_12_00_world.sql @@ -0,0 +1,8 @@ +-- CREATURE_STATIC_FLAG_4_PREVENT_SWIM +UPDATE `creature_template_difficulty` ctd +LEFT JOIN `creature_template` AS ct ON ct.`entry`=ctd.`Entry` +SET ctd.`StaticFlags4`= ctd.`StaticFlags4` | 0x01000000 +WHERE (ct.`unit_flags2` & 0x01000000) != 0 AND ct.`entry` != 48182; + +UPDATE `creature_template` SET `unit_flags2`= `unit_flags2` &~ 0x01000000; +UPDATE `creature_template_difficulty` SET `StaticFlags4`=`StaticFlags4` | 0x01000000 WHERE `Entry` IN (60292,55996,54470,54199,54192,53772,53740,50748,50741,50051,39943,42102,41610,41595,63172,63201,63356,64055,67057,73166); |