From bfc04b4adf2cb7cf232fc66851e73a8f06c25db5 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 8 Sep 2016 07:49:16 +0200 Subject: DB/Misc: Link more difficulties Cherry pick from https://gitlab.com/trinitycore/TrinityCore_434/commit/2afb2131c5c047c90bb9c837668f0dce6498b21a --- sql/updates/world/6.x/2016_09_08_00_world.sql | 71 +++++++++++++++++++++++++++ 1 file changed, 71 insertions(+) create mode 100644 sql/updates/world/6.x/2016_09_08_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/6.x/2016_09_08_00_world.sql b/sql/updates/world/6.x/2016_09_08_00_world.sql new file mode 100644 index 00000000000..76ba3007f96 --- /dev/null +++ b/sql/updates/world/6.x/2016_09_08_00_world.sql @@ -0,0 +1,71 @@ +-- +UPDATE `creature_template` SET `difficulty_entry_1`=57437, `difficulty_entry_2`=57438, `difficulty_entry_3`=57439 WHERE `entry`=56231; +UPDATE `creature_template` SET `difficulty_entry_1`=57434, `difficulty_entry_2`=57435, `difficulty_entry_3`=57436 WHERE `entry`=56265; +UPDATE `creature_template` SET `difficulty_entry_1`=57374, `difficulty_entry_2`=57375, `difficulty_entry_3`=57376 WHERE `entry`=55863; +UPDATE `creature_template` SET `difficulty_entry_1`=57368, `difficulty_entry_2`=57369, `difficulty_entry_3`=57370 WHERE `entry`=55865; +UPDATE `creature_template` SET `difficulty_entry_1`=57365, `difficulty_entry_2`=57366, `difficulty_entry_3`=57367 WHERE `entry`=55866; +UPDATE `creature_template` SET `difficulty_entry_1`=57362, `difficulty_entry_2`=57363, `difficulty_entry_3`=57364 WHERE `entry`=55867; +UPDATE `creature_template` SET `difficulty_entry_1`=57359, `difficulty_entry_2`=57360, `difficulty_entry_3`=57361 WHERE `entry`=55862; + +UPDATE `creature_template` SET `difficulty_entry_1`=57430 WHERE `entry`=57388; +UPDATE `creature_template` SET `difficulty_entry_1`=57428 WHERE `entry`=57386; +UPDATE `creature_template` SET `difficulty_entry_1`=57427 WHERE `entry`=57384; +UPDATE `creature_template` SET `difficulty_entry_1`=57426 WHERE `entry`=57382; +UPDATE `creature_template` SET `difficulty_entry_1`=57425 WHERE `entry`=57333; + +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14 WHERE `entry`=57437; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14 WHERE `entry`=57438; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14 WHERE `entry`=57439; + +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57434; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57435; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57436; + +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57374; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57375; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57376; + +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57368; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57369; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57370; + +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57365; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57366; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57367; + +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57362; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57363; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57364; + +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57359; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57360; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57361; + +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57430; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57428; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57427; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57426; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=16 WHERE `entry`=57425; + +UPDATE `creature_template` SET `unit_class`=2 WHERE `entry`=57463; +UPDATE `creature_template` SET `unit_class`=2 WHERE `entry`=57462; +UPDATE `creature_template` SET `faction`=2041 WHERE `entry`=57472; + +UPDATE `creature_template` SET `npcflag`=`npcflag`|3 WHERE `entry`=57481; + +UPDATE `creature_template` SET `unit_class`=2 WHERE `entry`=57955; +UPDATE `creature_template` SET `unit_class`=2 WHERE `entry`=58250; +UPDATE `creature_template` SET `unit_class`=2 WHERE `entry`=58251; +UPDATE `creature_template` SET `unit_class`=2 WHERE `entry`=57956; + +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|526336 WHERE `entry`=55866; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|526336 WHERE `entry`=55865; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|526336 WHERE `entry`=55863; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|526336 WHERE `entry`=55867; + +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57430; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57427; + +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57359; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57360; +UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|524288 WHERE `entry`=57361; -- cgit v1.2.3