aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-01-23 23:48:28 +0200
committeroffl <offl@users.noreply.github.com>2021-01-23 23:48:28 +0200
commita06a755f4c52da3b4ad07da08f8303fb8517ab2d (patch)
tree47af4a1204a07380f59ac3091a9f1acf83b2cefe
parent10d08d56b3dd6ab87934ae1a18bb6104e53c0b46 (diff)
DB/Creature: Remove UNIT_FLAG_NON_ATTACKABLE in few cases
Ref #25764
-rw-r--r--sql/updates/world/3.3.5/2021_01_23_03_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_01_23_03_world.sql b/sql/updates/world/3.3.5/2021_01_23_03_world.sql
new file mode 100644
index 00000000000..57c5039ca37
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_01_23_03_world.sql
@@ -0,0 +1,6 @@
+--
+UPDATE `creature` SET `unit_flags` = 33024, `dynamicflags` = 0 WHERE `guid` = 116778 AND `id` = 29402;
+UPDATE `creature` SET `unit_flags` = 33587456, `dynamicflags` = 0 WHERE `guid` IN (116956,116957,116958,116959) AND `id` = 29404;
+
+UPDATE `creature` SET `unit_flags` = 320 WHERE `unit_flags` = 768 AND `id` = 26620;
+-- UPDATE `creature` SET `unit_flags` = 33554496 WHERE `unit_flags` = 33570818 AND `id` = 26620;