DB/Creature: Link more heroic modes

Cherry pick from https://gitlab.com/trinitycore/TrinityCore_434/commit/d86697656165ece13628c7866fe53a9a10b2b5cd

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;