aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2016-04-26 03:46:18 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-01-07 02:12:17 +0100
commitff896145c9d48bde0b112ddc35973ca6b6c8ff08 (patch)
treec382087c38b6cb1ec7f5d9e8ab7000779a3ed7c5
parent5dd183b1646cdde4f139de6d93acf75075df9734 (diff)
DB/Creature: add few missing flag_extra
(cherry picked from commit f9582ed09d224265977ff62d25bdf0257b589af8)
-rw-r--r--sql/updates/world/master/2017_01_07_04_world_2016_04_26_00_world.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_01_07_04_world_2016_04_26_00_world.sql b/sql/updates/world/master/2017_01_07_04_world_2016_04_26_00_world.sql
new file mode 100644
index 00000000000..72201221944
--- /dev/null
+++ b/sql/updates/world/master/2017_01_07_04_world_2016_04_26_00_world.sql
@@ -0,0 +1,9 @@
+--
+UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry` IN (33395,14031,22586,22585,14030,22584,14027,22583,14028,14029,22581,14026,33402,31878,33691,33942,34189,31462,37634,34153,39011,39012,39013,20654,31461,31670,33907,33906,33353,33352,34228,31875,30757,21584,34131,26337);
+UPDATE `creature_template` SET `flags_extra`=`flags_extra`|2 WHERE `entry`=30777;
+
+UPDATE `creature_template` SET `flags_extra`=`flags_extra`|130 WHERE `entry` IN (21625,31874);
+
+UPDATE `creature_template` SET `flags_extra`=`flags_extra`|256 WHERE `entry` IN (20596,20745);
+
+UPDATE `creature_template` SET `flags_extra`=`flags_extra`&~1 WHERE `entry` IN (27309,27308,27307,27303);