diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_09_06_02_world.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_09_06_02_world.sql b/sql/updates/world/6.x/2016_09_06_02_world.sql new file mode 100644 index 00000000000..a15932933e4 --- /dev/null +++ b/sql/updates/world/6.x/2016_09_06_02_world.sql @@ -0,0 +1,28 @@ +-- +UPDATE `creature_template` SET `difficulty_entry_1`=57702, `difficulty_entry_2`=57841, `difficulty_entry_3`=57842 WHERE `entry`=56854; +UPDATE `creature_template` SET `difficulty_entry_1`=57700, `difficulty_entry_2`=57837, `difficulty_entry_3`=57838 WHERE `entry`=56587; +UPDATE `creature_template` SET `difficulty_entry_1`=57701, `difficulty_entry_2`=57839, `difficulty_entry_3`=57840 WHERE `entry`=56855; +UPDATE `creature_template` SET `difficulty_entry_1`=57699, `difficulty_entry_2`=57847, `difficulty_entry_3`=57848 WHERE `entry`=56427; +UPDATE `creature_template` SET `difficulty_entry_1`=57698, `difficulty_entry_2`=57845, `difficulty_entry_3`=57846 WHERE `entry`=56598; + +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=16, `unit_flags`=32832 WHERE `entry`=57702; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=16, `unit_flags`=32832 WHERE `entry`=57841; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=16, `unit_flags`=32832 WHERE `entry`=57842; + +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=14 WHERE `entry`=57700; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=14 WHERE `entry`=57701; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=14 WHERE `entry`=57837; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=14 WHERE `entry`=57838; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=14 WHERE `entry`=57839; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=14 WHERE `entry`=57840; + +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags`=32832 WHERE `entry`=57699; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags`=32832 WHERE `entry`=57847; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags`=32832 WHERE `entry`=57848; + +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `unit_flags2`=67108864 WHERE `entry`=57698; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `unit_flags2`=67108864 WHERE `entry`=57845; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `unit_flags2`=67108864 WHERE `entry`=57846; + +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=56587; +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=56855; |