aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2014_04_24_04_world_creature_template.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/2014_04_24_04_world_creature_template.sql b/sql/updates/world/2014_04_24_04_world_creature_template.sql
new file mode 100644
index 00000000000..50fb9d77624
--- /dev/null
+++ b/sql/updates/world/2014_04_24_04_world_creature_template.sql
@@ -0,0 +1,12 @@
+--
+UPDATE `creature_template` SET `faction_A`=14, `faction_H`=14 WHERE `entry`=40142;
+UPDATE `creature_template` SET `faction_A`=974, `faction_H`=974 WHERE `entry`=37813;
+UPDATE `creature_template` SET `faction_A`=714, `faction_H`=714 WHERE `entry`=37581;
+UPDATE `creature_template` SET `faction_A`=1078, `faction_H`=1078 WHERE `entry`=34705;
+
+UPDATE `creature_template` SET `faction_A`=21, `faction_H`=21 WHERE `entry` IN (37232,38362);
+UPDATE `creature_template` SET `faction_A`=534, `faction_H`=534 WHERE `entry` IN (37591,37606);
+UPDATE `creature_template` SET `faction_A`=1770, `faction_H`=1770 WHERE `entry` IN (37580,37606);
+UPDATE `creature_template` SET `faction_A`=534, `faction_H`=534 WHERE `entry` IN (37498,37605);
+UPDATE `creature_template` SET `faction_A`=875, `faction_H`=875 WHERE `entry` IN (34702,36082);
+UPDATE `creature_template` SET `faction_A`=55, `faction_H`=55 WHERE `entry` IN (34703,36087);