DB/Gossip: Add correct broadcast texts and language to some gossip texts part 3

Closes #25106

(cherry picked from commit 1f8067e354db31156e6338e4bc545007163b2266)

1 files changed, 22 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_01_25_08_world_2020_08_02_10_world_335.sql b/sql/updates/world/master/2022_01_25_08_world_2020_08_02_10_world_335.sql
new file mode 100644
index 00000000000..6e0eb0f6fee
--- /dev/null
+++ b/sql/updates/world/master/2022_01_25_08_world_2020_08_02_10_world_335.sql
@@ -0,0 +1,22 @@
+--
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 32320 WHERE `ID` = 14040;
+UPDATE `npc_text` SET `BroadcastTextID0` = 32695 WHERE `ID` = 14115;
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 32778 WHERE `ID` = 14125;
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 32779 WHERE `ID` = 14126;
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 32780 WHERE `ID` = 14128;
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 33410 WHERE `ID` = 14327;
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 33513 WHERE `ID` = 14344;
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 33548, `lang0` = 0 WHERE `ID` = 14347;
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 33692 WHERE `ID` = 14375;
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 34095 WHERE `ID` = 14454;
+-- UPDATE `npc_text` SET `BroadcastTextID1` = 32778 WHERE `ID` = 14128;
+-- UPDATE `npc_text` SET `BroadcastTextID2` = 32779 WHERE `ID` = 14128;
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 34641 WHERE `ID` = 14549;
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 34959 WHERE `ID` = 14605;
+UPDATE `npc_text` SET `BroadcastTextID0` = 36370 WHERE `ID` = 14955;
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 36886 WHERE `ID` = 15081;
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 38398 WHERE `ID` = 15347;
+
+-- UPDATE `npc_text` SET `text0_0` = "" WHERE `ID` = 14327;
+-- UPDATE `npc_text` SET `text0_0` = "" WHERE `ID` = 14347;
+-- UPDATE `npc_text` SET `text0_1` = "" WHERE `ID` = 14375;