From 1f8067e354db31156e6338e4bc545007163b2266 Mon Sep 17 00:00:00 2001
From: offl <offl@users.noreply.github.com>
Date: Sun, 2 Aug 2020 19:03:48 +0300
Subject: DB/Gossip: Add correct broadcast texts and language to some gossip
 texts part 3

Closes #25106
---
 .../world/3.3.5/2020_08_02_10_world_335.sql        | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2020_08_02_10_world_335.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2020_08_02_10_world_335.sql b/sql/updates/world/3.3.5/2020_08_02_10_world_335.sql
new file mode 100644
index 00000000000..2f13430d9c1
--- /dev/null
+++ b/sql/updates/world/3.3.5/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;
-- 
cgit v1.2.3