From df9255aa0e4aafcbe0f8d251a5a63c8b3f9876f2 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Mon, 28 Apr 2014 09:58:44 +0200 Subject: DB/Creature: Fix even more creature templates --- .../2014_04_28_01_world_creature_template.sql | 24 ++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 sql/updates/world/2014_04_28_01_world_creature_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_04_28_01_world_creature_template.sql b/sql/updates/world/2014_04_28_01_world_creature_template.sql new file mode 100644 index 00000000000..0bdd9657c65 --- /dev/null +++ b/sql/updates/world/2014_04_28_01_world_creature_template.sql @@ -0,0 +1,24 @@ +UPDATE `creature_template` SET `difficulty_entry_3`=37292 WHERE `entry`=13446; +UPDATE `creature_template` SET `difficulty_entry_3`=37276 WHERE `entry`=13153; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37279; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37299; +UPDATE `creature_template` SET `npcflag`=3 WHERE `entry`=37279; +UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`=37299; +UPDATE `creature_template` SET `faction`=29 WHERE `entry`=37248; +UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`=37248; +UPDATE `creature_template` SET `faction`=85 WHERE `entry`=37261; +UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`=37261; +UPDATE `creature_template` SET `faction`=29 WHERE `entry`=37365; +UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`=37365; +UPDATE `creature_template` SET `faction`=1216 WHERE `entry`=37271; +UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`=37271; +UPDATE `creature_template` SET `faction`=85 WHERE `entry`=37280; +UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`=37280; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37273; +UPDATE `creature_template` SET `npcflag`=3 WHERE `entry`=37273; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37270; +UPDATE `creature_template` SET `npcflag`=1 WHERE `entry`=37270; +UPDATE `creature_template` SET `faction`=1214 WHERE `entry`=37276; +UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`=37276; +UPDATE `creature_template` SET `faction`=14 WHERE `entry`=37292; +UPDATE `creature_template` SET `npcflag`=2 WHERE `entry`=37292; -- cgit v1.2.3