aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-01-06 19:49:24 +0200
committerShauren <shauren.trinity@gmail.com>2022-03-05 21:52:12 +0100
commit7b0ce99b8429b7452f3e3ef6969e98c2e51925bd (patch)
treeaaa4dbea4c3d34754a71212e803ccaa1dfbd8c0d
parentaa29703438e920c1c52f04f1741489b097b89787 (diff)
DB/Creature: Remove serverside unit flags from creature table
Ref 1f4b5c2f5646c6eaae336b54a762868a71cddb67 (cherry picked from commit 8e8e67f38ce45f496142cfd7749961902337347d)
-rw-r--r--sql/updates/world/master/2022_03_05_51_world_2021_01_06_05_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_05_51_world_2021_01_06_05_world.sql b/sql/updates/world/master/2022_03_05_51_world_2021_01_06_05_world.sql
new file mode 100644
index 00000000000..2ebf1cbbdae
--- /dev/null
+++ b/sql/updates/world/master/2022_03_05_51_world_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);