diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2016-04-26 03:46:18 +0200 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2016-04-26 03:46:18 +0200 |
| commit | f9582ed09d224265977ff62d25bdf0257b589af8 (patch) | |
| tree | 7be5fcb4b1a025406e89e679ec5773562a4ad474 | |
| parent | 61999b125a5509b1941f144089bf1c333af72c93 (diff) | |
DB/Creature: add few missing flag_extra
| -rw-r--r-- | sql/updates/world/3.3.5/2016_04_26_00_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_04_26_00_world.sql b/sql/updates/world/3.3.5/2016_04_26_00_world.sql new file mode 100644 index 00000000000..72201221944 --- /dev/null +++ b/sql/updates/world/3.3.5/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); |