aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2016-09-06 15:53:25 +0200
committerGitHub <noreply@github.com>2016-09-06 15:53:25 +0200
commit741e0c757fa8184405cbdc03e452ad00fb3e2859 (patch)
treefd1cf277bb3292d8a4375f1e960fae11852b1cda /sql/updates
parenta994f92eb95d94eed42d8d524b5cd55151498fc3 (diff)
DB/Creature: Link more heroic modes
Cherry pick from https://gitlab.com/trinitycore/TrinityCore_434/commit/3c2da4159e032301b27ac3a3aa14f59d302a1215
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/6.x/2016_09_06_03_world.sql26
1 files changed, 26 insertions, 0 deletions
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;