aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2016-09-06 14:42:54 +0200
committerGitHub <noreply@github.com>2016-09-06 14:42:54 +0200
commita994f92eb95d94eed42d8d524b5cd55151498fc3 (patch)
treef7aa28cd6afd5147e81aa12c1be3dacf50fb62ad
parentad4d6e60a1277140bec1c806e70baff5350acc8c (diff)
DB/Creature: Link more heroic modes
Cherry pick from https://gitlab.com/trinitycore/TrinityCore_434/commit/a85579b83e059292a57138d2b907ded01df77dc3
-rw-r--r--sql/updates/world/6.x/2016_09_06_02_world.sql28
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;