From 3ea582998ba377ccb9fc88c1e4a8a1ae78f8faaf Mon Sep 17 00:00:00 2001 From: Aokromes Date: Mon, 5 Sep 2016 12:49:18 +0200 Subject: DB/Misc: Fix startup errors Cherry pick from https://gitlab.com/trinitycore/TrinityCore_434/commit/e03640a4200009d952381d43d50b8373a7cf1081 --- sql/updates/world/6.x/2016_09_05_02_world.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/6.x/2016_09_05_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/6.x/2016_09_05_02_world.sql b/sql/updates/world/6.x/2016_09_05_02_world.sql new file mode 100644 index 00000000000..79c0cc24915 --- /dev/null +++ b/sql/updates/world/6.x/2016_09_05_02_world.sql @@ -0,0 +1,11 @@ +-- +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=14, `speed_walk`=20, `speed_run`=7.14286, `unit_flags`=33554752, `unit_flags2`=34816 WHERE `entry`=49101; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=14, `speed_walk`=20, `speed_run`=7.14286, `unit_flags`=33554752, `unit_flags2`=34816 WHERE `entry`=49100; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=14, `speed_walk`=20, `speed_run`=7.14286, `unit_flags`=64, `unit_flags2`=134250496' WHERE `entry`=49097; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=14, `speed_walk`=20, `speed_run`=7.14286, `unit_flags`=64, `unit_flags2`=34816 WHERE `entry`=49096; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=14, `unit_flags`=33554432 WHERE `entry`=49099; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14, `unit_flags`=32832 WHERE `entry`=49080; +UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=87, `exp`=3, `faction`=14, `unit_flags`=33088 WHERE `entry`=49079; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=14 WHERE `entry`=49063; +UPDATE `creature_template` SET `minlevel`=86, `maxlevel`=86, `exp`=3, `faction`=14 WHERE `entry`=49062; +UPDATE `creature_template` SET `unit_flags2`=2048 WHERE `entry`=39959; -- cgit v1.2.3