aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2014_04_27_06_world_creature_template.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/2014_04_27_06_world_creature_template.sql b/sql/updates/world/2014_04_27_06_world_creature_template.sql
new file mode 100644
index 00000000000..19711483634
--- /dev/null
+++ b/sql/updates/world/2014_04_27_06_world_creature_template.sql
@@ -0,0 +1,14 @@
+--
+UPDATE `creature_template` SET `faction_A`=2209, `faction_H`=2209 WHERE `entry` IN (38137,38134);
+UPDATE `creature_template` SET `faction_A`=1770, `faction_H`=1770 WHERE `entry` IN (37653,37654);
+UPDATE `creature_template` SET `faction_A`=1534, `faction_H`=1534 WHERE `entry` IN (31903,37467);
+UPDATE `creature_template` SET `faction_A`=29, `faction_H`=29 WHERE `entry` IN (31937,31928);
+UPDATE `creature_template` SET `faction_A`=32, `faction_H`=32 WHERE `entry` IN (32127,37452);
+UPDATE `creature_template` SET `faction_A`=11, `faction_H`=11 WHERE `entry` IN (32074,37395);
+UPDATE `creature_template` SET `faction_A`=55, `faction_H`=55 WHERE `entry` IN (32070,37391);
+UPDATE `creature_template` SET `faction_A`=83, `faction_H`=83 WHERE `entry` IN (38094);
+UPDATE `creature_template` SET `faction_A`=1771, `faction_H`=1771 WHERE `entry` IN (37657);
+UPDATE `creature_template` SET `faction_A`=1217, `faction_H`=1217 WHERE `entry` IN (32092);
+UPDATE `creature_template` SET `faction_A`=1215, `faction_H`=1215 WHERE `entry` IN (37482);
+UPDATE `creature_template` SET `faction_A`=85, `faction_H`=85 WHERE `entry` IN (32075);
+UPDATE `creature_template` SET `faction_A`=26, `faction_H`=26 WHERE `entry` IN (37471);