From 741e0c757fa8184405cbdc03e452ad00fb3e2859 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Tue, 6 Sep 2016 15:53:25 +0200 Subject: DB/Creature: Link more heroic modes Cherry pick from https://gitlab.com/trinitycore/TrinityCore_434/commit/3c2da4159e032301b27ac3a3aa14f59d302a1215 --- sql/updates/world/6.x/2016_09_06_03_world.sql | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 sql/updates/world/6.x/2016_09_06_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/6.x/2016_09_06_03_world.sql b/sql/updates/world/6.x/2016_09_06_03_world.sql new file mode 100644 index 00000000000..61469a5f5bb --- /dev/null +++ b/sql/updates/world/6.x/2016_09_06_03_world.sql @@ -0,0 +1,26 @@ +-- +UPDATE `creature_template` SET `difficulty_entry_1`=57481 WHERE `entry`=55476; +UPDATE `creature_template` SET `difficulty_entry_1`=57472 WHERE `entry`=57398; +UPDATE `creature_template` SET `difficulty_entry_1`=57469 WHERE `entry`=57348; +UPDATE `creature_template` SET `difficulty_entry_1`=57471 WHERE `entry`=57334; +UPDATE `creature_template` SET `difficulty_entry_1`=57468 WHERE `entry`=57380; +UPDATE `creature_template` SET `difficulty_entry_1`=57463, `difficulty_entry_2`=58250, `difficulty_entry_3`=58251 WHERE `entry`=56700; +UPDATE `creature_template` SET `difficulty_entry_1`=57462, `difficulty_entry_2`=57955, `difficulty_entry_3`=57956 WHERE `entry`=55689; + +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `unit_flags`=33536, `unit_flags2`=33556480 WHERE `entry`=57472; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=2041, `unit_flags`=32768, `unit_flags2`=33556480 WHERE `entry`=57481; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=2041, `unit_flags`=32768, `unit_flags2`=33556480 WHERE `entry`=57469; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=2041, `unit_flags`=32768, `unit_flags2`=33556480 WHERE `entry`=57471; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=2041, `unit_flags`=32768, `unit_flags2`=33556480 WHERE `entry`=57468; + +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14, `unit_flags`=32768 WHERE `entry`=57463; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14, `unit_flags`=32768 WHERE `entry`=58250; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14, `unit_flags`=32768 WHERE `entry`=58251; + +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14, `unit_flags`=32768 WHERE `entry`=57463; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14, `unit_flags`=32768 WHERE `entry`=58250; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14, `unit_flags`=32768 WHERE `entry`=58251; + +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags`=33587264 WHERE `entry`=57462; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags`=33587264 WHERE `entry`=57955; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags`=33587264 WHERE `entry`=57956; -- cgit v1.2.3