diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_09_05_10_world.sql | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_09_05_10_world.sql b/sql/updates/world/6.x/2016_09_05_10_world.sql new file mode 100644 index 00000000000..5862ca3e63c --- /dev/null +++ b/sql/updates/world/6.x/2016_09_05_10_world.sql @@ -0,0 +1,36 @@ +-- +UPDATE `creature_template` SET `difficulty_entry_1`=58862, `difficulty_entry_2`=58863, `difficulty_entry_3`=58864 WHERE `entry`=53879; +UPDATE `creature_template` SET `difficulty_entry_1`=57970, `difficulty_entry_2`=58125, `difficulty_entry_3`=58126 WHERE `entry`=57962; +UPDATE `creature_template` SET `difficulty_entry_1`=57969, `difficulty_entry_2`=58000, `difficulty_entry_3`=58001 WHERE `entry`=56173; +UPDATE `creature_template` SET `difficulty_entry_1`=57978, `difficulty_entry_2`=58142, `difficulty_entry_3`=58143 WHERE `entry`=56188; +UPDATE `creature_template` SET `difficulty_entry_1`=57977, `difficulty_entry_2`=58140, `difficulty_entry_3`=58141 WHERE `entry`=56724; + +UPDATE `creature_template` SET `difficulty_entry_1`=58034 WHERE `entry`=57479; +UPDATE `creature_template` SET `difficulty_entry_1`=57989 WHERE `entry`=56350; +UPDATE `creature_template` SET `difficulty_entry_1`=57980 WHERE `entry`=57798; + +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=67141632 WHERE `entry`=58862; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=67141632 WHERE `entry`=58863; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=67141632 WHERE `entry`=58864; + +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags`=33554432, `unit_flags2`=134250496 WHERE `entry`=57970; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags`=33554432, `unit_flags2`=134250496 WHERE `entry`=58125; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags`=33554432, `unit_flags2`=134250496 WHERE `entry`=58126; + +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=134250496 WHERE `entry`=57969; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=134250496 WHERE `entry`=58000; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=134250496 WHERE `entry`=58001; + +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=57978; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=57978; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=57978; + +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=57977; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=58140; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=58141; + +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=90, `unit_flags`=32768 WHERE `entry`=57989; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=58034; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=57980; + +UPDATE `creature_template` SET `unit_class`=2 WHERE `entry`=49072; |