aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDr-J <daniel.jarrott0@gmail.com>2014-09-15 13:18:05 +0100
committerDr-J <daniel.jarrott0@gmail.com>2014-09-15 13:18:05 +0100
commit38200f83606c95b54947ba49dcbaf5fbf7bb96b8 (patch)
treee2d76f3d702e1d2c89beb89f95f9f3e0a758d834
parentd4703319abe30151c29336464487eb3d16b6b103 (diff)
Addition to https://github.com/TrinityCore/TrinityCore/commit/43e209e3203fcbc83f81fdc0047a5a560f8d698e
I could have sworn I already added broadcast texts to original sql but seems where missing,
-rw-r--r--sql/updates/world/2014_09_15_02_world_misc.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2014_09_15_02_world_misc.sql b/sql/updates/world/2014_09_15_02_world_misc.sql
new file mode 100644
index 00000000000..adcd7b8a9f2
--- /dev/null
+++ b/sql/updates/world/2014_09_15_02_world_misc.sql
@@ -0,0 +1,11 @@
+UPDATE `creature_text` SET `BroadcastTextID`=31261 WHERE `entry`=31283 AND `groupid`=1;
+UPDATE `creature_text` SET `BroadcastTextID`=31962 WHERE `entry`=31283 AND `groupid`=2;
+UPDATE `creature_text` SET `BroadcastTextID`=31963 WHERE `entry`=31283 AND `groupid`=3;
+UPDATE `creature_text` SET `BroadcastTextID`=31966 WHERE `entry`=31283 AND `groupid`=4;
+UPDATE `creature_text` SET `BroadcastTextID`=31967 WHERE `entry`=31283 AND `groupid`=5;
+UPDATE `creature_text` SET `BroadcastTextID`=31964 WHERE `entry`=31283 AND `groupid`=6;
+UPDATE `creature_text` SET `BroadcastTextID`=31259 WHERE `entry`=31283 AND `groupid`=0;
+UPDATE `creature_text` SET `BroadcastTextID`=31975 WHERE `entry`=31290 AND `groupid`=0;
+UPDATE `creature_text` SET `BroadcastTextID`=31977 WHERE `entry`=31290 AND `groupid`=1;
+UPDATE `creature_text` SET `BroadcastTextID`=31978 WHERE `entry`=31290 AND `groupid`=3;
+UPDATE `creature_text` SET `BroadcastTextID`=31983 WHERE `entry`=31290 AND `groupid`=2;