From ff896145c9d48bde0b112ddc35973ca6b6c8ff08 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Tue, 26 Apr 2016 03:46:18 +0200 Subject: DB/Creature: add few missing flag_extra (cherry picked from commit f9582ed09d224265977ff62d25bdf0257b589af8) --- .../world/master/2017_01_07_04_world_2016_04_26_00_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/master/2017_01_07_04_world_2016_04_26_00_world.sql (limited to 'sql/updates/world') 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); -- cgit v1.2.3