diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2016-09-05 13:38:04 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-09-05 13:38:04 +0200 |
| commit | 8eb244bab8d12e8bf36d785f08a7c50afb12a47a (patch) | |
| tree | 5b65b4a38a99b9343682bc5c164a10ab6f475098 | |
| parent | 40ed026537fca4b9ca1a11f3457fb9d8443dfbd3 (diff) | |
DB/Creature: Link more Throne of the Tides creatures
Cherry pick from https://gitlab.com/trinitycore/TrinityCore_434/commit/e7618fd7e691b8d58946b197fe4cb8ef0e5cb2b8
| -rw-r--r-- | sql/updates/world/6.x/2016_09_05_03_world.sql | 26 |
1 files changed, 26 insertions, 0 deletions
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; |