aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2014-04-28 09:58:44 +0200
committerAokromes <Aokromes@users.noreply.github.com>2014-04-28 09:58:44 +0200
commitdf9255aa0e4aafcbe0f8d251a5a63c8b3f9876f2 (patch)
tree58e013a118ee3467768a328a88d2796f9f0ba678
parent221fde571154ee2b62f376da1b2967c5577d806b (diff)
DB/Creature: Fix even more creature templates
-rw-r--r--sql/updates/world/2014_04_28_01_world_creature_template.sql24
1 files changed, 24 insertions, 0 deletions
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;