From 38200f83606c95b54947ba49dcbaf5fbf7bb96b8 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Mon, 15 Sep 2014 13:18:05 +0100 Subject: 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, --- sql/updates/world/2014_09_15_02_world_misc.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/2014_09_15_02_world_misc.sql (limited to 'sql') 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; -- cgit v1.2.3