aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2014_01_27_11_world_creature_model_info.sql (renamed from sql/updates/world/2014_01_27_10_world_creature_model_info.sql)0
-rw-r--r--sql/updates/world/2014_01_27_14_world_creature_template.sql3
-rw-r--r--sql/updates/world/2014_01_27_15_world_creature_template.sql3
-rw-r--r--sql/updates/world/2014_01_27_16_world_creature_template.sql3
-rw-r--r--sql/updates/world/2014_01_27_17_world_creature_template.sql3
5 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/2014_01_27_10_world_creature_model_info.sql b/sql/updates/world/2014_01_27_11_world_creature_model_info.sql
index adb94260fb9..adb94260fb9 100644
--- a/sql/updates/world/2014_01_27_10_world_creature_model_info.sql
+++ b/sql/updates/world/2014_01_27_11_world_creature_model_info.sql
diff --git a/sql/updates/world/2014_01_27_14_world_creature_template.sql b/sql/updates/world/2014_01_27_14_world_creature_template.sql
new file mode 100644
index 00000000000..97aa6fe0fbb
--- /dev/null
+++ b/sql/updates/world/2014_01_27_14_world_creature_template.sql
@@ -0,0 +1,3 @@
+--
+UPDATE `creature_template` SET `faction_A` = 514, `faction_H` = 514 WHERE `entry` IN (13326,22714,32062,37383,37402,37404);
+UPDATE `creature_template` SET `faction_A` = 1534, `faction_H` = 1534 WHERE `entry` IN (37407);
diff --git a/sql/updates/world/2014_01_27_15_world_creature_template.sql b/sql/updates/world/2014_01_27_15_world_creature_template.sql
new file mode 100644
index 00000000000..d4ac82122c5
--- /dev/null
+++ b/sql/updates/world/2014_01_27_15_world_creature_template.sql
@@ -0,0 +1,3 @@
+--
+UPDATE `creature_template` SET `faction_A` = 26, `faction_H` = 26 WHERE `entry` IN (37469,37470,37473);
+UPDATE `creature_template` SET `faction_A` = 1214, `faction_H` = 1214 WHERE `entry` IN (13397,22745,32016);
diff --git a/sql/updates/world/2014_01_27_16_world_creature_template.sql b/sql/updates/world/2014_01_27_16_world_creature_template.sql
new file mode 100644
index 00000000000..cf928d315d7
--- /dev/null
+++ b/sql/updates/world/2014_01_27_16_world_creature_template.sql
@@ -0,0 +1,3 @@
+--
+UPDATE `creature_template` SET `faction_A` = 59, `faction_H` = 59 WHERE `entry` IN (13099,22741,32012,37331,37340,37337,37366);
+UPDATE `creature_template` SET `faction_A` = 39, `faction_H` = 39 WHERE `entry` IN (37475);
diff --git a/sql/updates/world/2014_01_27_17_world_creature_template.sql b/sql/updates/world/2014_01_27_17_world_creature_template.sql
new file mode 100644
index 00000000000..a2ab1383b61
--- /dev/null
+++ b/sql/updates/world/2014_01_27_17_world_creature_template.sql
@@ -0,0 +1,3 @@
+--
+UPDATE `creature_template` SET `faction_A` = 83, `faction_H` = 83 WHERE `entry` IN (35405,37323);
+UPDATE `creature_template` SET `faction_A` = 1215, `faction_H` = 1215 WHERE `entry` IN (37481);