aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-01-06 19:49:24 +0200
committeroffl <offl@users.noreply.github.com>2021-01-06 19:49:24 +0200
commit8e8e67f38ce45f496142cfd7749961902337347d (patch)
tree21b1aa319942b586e64d20d74440978ee62da22a
parentabe8fb01e066a2021fd8b67e1dbaad4759e57f6d (diff)
DB/Creature: Remove serverside unit flags from creature table
Ref 1f4b5c2f5646c6eaae336b54a762868a71cddb67
-rw-r--r--sql/updates/world/3.3.5/2021_01_06_05_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_01_06_05_world.sql b/sql/updates/world/3.3.5/2021_01_06_05_world.sql
new file mode 100644
index 00000000000..2ebf1cbbdae
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_01_06_05_world.sql
@@ -0,0 +1,3 @@
+--
+UPDATE `creature` SET `unit_flags` = `unit_flags` &~ 0x00000008 WHERE `guid` IN (81085,3431);
+UPDATE `creature` SET `unit_flags` = `unit_flags` &~ 0x08000000 WHERE `guid` IN (145494,145495);