aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-10-31 20:53:15 +0100
committerGitHub <noreply@github.com>2016-10-31 20:53:15 +0100
commit06d658fe67a09ad62864f64818eba64605974379 (patch)
treedb5b4d3bddf4f990932126a91ba2dfa4429fd28a
parent189edc0f23a2935747eb5eb3555607f4edc15480 (diff)
DB/CreatureText: swap wrong faction texts for Commoners during Hallow's End.
-rw-r--r--sql/updates/world/3.3.5/2016_10_31_00_world.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_10_31_00_world.sql b/sql/updates/world/3.3.5/2016_10_31_00_world.sql
new file mode 100644
index 00000000000..4b610eab05a
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_10_31_00_world.sql
@@ -0,0 +1,9 @@
+--
+UPDATE `creature_text` SET `text`="For the Alliance!", `BroadcastTextId`=23351 WHERE `entry`=18927 AND `groupid`=6 AND `id`=4;
+UPDATE `creature_text` SET `text`="For the Alliance!", `BroadcastTextId`=23351 WHERE `entry`=19171 AND `groupid`=6 AND `id`=2;
+UPDATE `creature_text` SET `text`="For the Alliance!", `BroadcastTextId`=23351 WHERE `entry`=19173 AND `groupid`=6 AND `id`=3;
+
+UPDATE `creature_text` SET `text`="For the Horde!", `BroadcastTextId`=23357 WHERE `entry`=19178 AND `groupid`=6 AND `id`=2;
+UPDATE `creature_text` SET `text`="For the Horde!", `BroadcastTextId`=23357 WHERE `entry`=19175 AND `groupid`=6 AND `id`=6;
+UPDATE `creature_text` SET `text`="For the Horde!", `BroadcastTextId`=23357 WHERE `entry`=19169 AND `groupid`=6 AND `id`=7;
+UPDATE `creature_text` SET `text`="For the Horde!", `BroadcastTextId`=23357 WHERE `entry`=19176 AND `groupid`=6 AND `id`=2;