diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_09_06_00_world.sql | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_09_06_00_world.sql b/sql/updates/world/6.x/2016_09_06_00_world.sql new file mode 100644 index 00000000000..711a65fdce4 --- /dev/null +++ b/sql/updates/world/6.x/2016_09_06_00_world.sql @@ -0,0 +1,53 @@ +-- +UPDATE `creature_template` SET `difficulty_entry_1`=57975, `difficulty_entry_2`=58135, `difficulty_entry_3`=58136 WHERE `entry`=56263; +UPDATE `creature_template` SET `difficulty_entry_1`=57973, `difficulty_entry_2`=58131, `difficulty_entry_3`=58132 WHERE `entry`=56167; +UPDATE `creature_template` SET `difficulty_entry_1`=57974, `difficulty_entry_2`=58133, `difficulty_entry_3`=58134 WHERE `entry`=56846; +UPDATE `creature_template` SET `difficulty_entry_1`=57972, `difficulty_entry_2`=58129, `difficulty_entry_3`=58130 WHERE `entry`=56168; +UPDATE `creature_template` SET `difficulty_entry_1`=57971, `difficulty_entry_2`=58127, `difficulty_entry_3`=58128 WHERE `entry`=56710; +UPDATE `creature_template` SET `difficulty_entry_1`=57937, `difficulty_entry_2`=57938, `difficulty_entry_3`=57939, `unit_flags2`=2048 WHERE `entry`=56781; +UPDATE `creature_template` SET `difficulty_entry_1`=57866 WHERE `entry`=49481; +UPDATE `creature_template` SET `difficulty_entry_1`=57868 WHERE `entry`=57867; +UPDATE `creature_template` SET `difficulty_entry_1`=57870 WHERE `entry`=57869; +UPDATE `creature_template` SET `difficulty_entry_1`=57813, `difficulty_entry_2`=57832, `difficulty_entry_3`=57833 WHERE `entry`=56136; +UPDATE `creature_template` SET `difficulty_entry_1`=57704, `difficulty_entry_2`=57717, `difficulty_entry_3`=57718 WHERE `entry`=56923; +UPDATE `creature_template` SET `difficulty_entry_1`=57703, `difficulty_entry_2`=57843, `difficulty_entry_3`=57844 WHERE `entry`=56848; + +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=57975; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=58135; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=58136; + +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=134250496 WHERE `entry`=57973; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=134250496 WHERE `entry`=58131; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=134250496 WHERE `entry`=58132; + +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=134250496 WHERE `entry`=57974; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=134250496 WHERE `entry`=58133; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=134250496 WHERE `entry`=58134; + +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=134250496 WHERE `entry`=57972; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=134250496 WHERE `entry`=58129; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14, `unit_flags2`=134250496 WHERE `entry`=58130; + +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=57971; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=58127; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14 WHERE `entry`=58128; + +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14 WHERE `entry`=57937; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14 WHERE `entry`=57938; +UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `exp`=3, `faction`=14 WHERE `entry`=57939; + +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16 WHERE `entry`=57866; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16 WHERE `entry`=57868; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16 WHERE `entry`=57870; + +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14 WHERE `entry`=57813; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14 WHERE `entry`=57832; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14 WHERE `entry`=57833; + +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=16, `unit_flags`=32832 WHERE `entry`=57704; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=16, `unit_flags`=32832 WHERE `entry`=57717; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=16, `unit_flags`=32832 WHERE `entry`=57718; + +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=16, `unit_flags`=32832 WHERE `entry`=57703; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=16, `unit_flags`=32832 WHERE `entry`=57843; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=16, `unit_flags`=32832 WHERE `entry`=57844; |