From 8eb244bab8d12e8bf36d785f08a7c50afb12a47a Mon Sep 17 00:00:00 2001 From: Aokromes Date: Mon, 5 Sep 2016 13:38:04 +0200 Subject: DB/Creature: Link more Throne of the Tides creatures Cherry pick from https://gitlab.com/trinitycore/TrinityCore_434/commit/e7618fd7e691b8d58946b197fe4cb8ef0e5cb2b8 --- sql/updates/world/6.x/2016_09_05_03_world.sql | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 sql/updates/world/6.x/2016_09_05_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/6.x/2016_09_05_03_world.sql b/sql/updates/world/6.x/2016_09_05_03_world.sql new file mode 100644 index 00000000000..edf9fd8a9a8 --- /dev/null +++ b/sql/updates/world/6.x/2016_09_05_03_world.sql @@ -0,0 +1,26 @@ +-- +UPDATE `creature_template` SET `difficulty_entry_1`=49066 WHERE `entry`=39960; +UPDATE `creature_template` SET `difficulty_entry_1`=49082 WHERE `entry`=40788; +UPDATE `creature_template` SET `difficulty_entry_1`=49083 WHERE `entry`=40860; +UPDATE `creature_template` SET `difficulty_entry_1`=49085 WHERE `entry`=39616; +UPDATE `creature_template` SET `difficulty_entry_1`=49086 WHERE `entry`=40584; +UPDATE `creature_template` SET `difficulty_entry_1`=50279 WHERE `entry`=50278; +UPDATE `creature_template` SET `difficulty_entry_1`=49087 WHERE `entry`=40577; +UPDATE `creature_template` SET `difficulty_entry_1`=49090 WHERE `entry`=41096; +UPDATE `creature_template` SET `difficulty_entry_1`=49091 WHERE `entry`=41139; +UPDATE `creature_template` SET `difficulty_entry_1`=50277 WHERE `entry`=50276; + +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=14, `speed_walk`=2, `speed_run`=1.42857, `unit_flags`=32768 WHERE `entry`=49066; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14, `speed_run`=1.42857, `unit_flags`=33587264, `unit_flags2`=133120, `HoverHeight`=7.7 WHERE `entry`=49082; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `unit_flags`=33088 WHERE `entry`=49085; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `unit_flags`=33088 WHERE `entry`=49086; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `unit_flags`=570721088, `unit_flags2`=2049, `dynamicflags`=32 WHERE `entry`=50279; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=16, `unit_flags`=32832 WHERE `entry`=49087; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `unit_flags`=33088 WHERE `entry`=49090; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `unit_flags`=33088 WHERE `entry`=49091; +UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=85, `exp`=3, `faction`=16, `unit_flags`=570721088, `unit_flags2`=2049 WHERE `entry`=50277; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3 WHERE `entry`=49083; + +UPDATE `creature_template` SET `unit_class`=2 WHERE `entry`=49091; +UPDATE `creature_template` SET `unit_class`=2 WHERE `entry`=49090; +UPDATE `creature_template` SET `unit_class`=2 WHERE `entry`=50277; -- cgit v1.2.3