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

Closes #25097

1 files changed, 78 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_08_02_07_world_335.sql b/sql/updates/world/3.3.5/2020_08_02_07_world_335.sql
new file mode 100644
index 00000000000..edecba77cfd
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_08_02_07_world_335.sql
@@ -0,0 +1,78 @@
+--
+UPDATE `npc_text` SET `BroadcastTextID0` = 10058 WHERE `ID` = 7354;
+UPDATE `npc_text` SET `BroadcastTextID0` = 10101 WHERE `ID` = 7374;
+UPDATE `npc_text` SET `BroadcastTextID1` = 10102 WHERE `ID` = 7374;
+UPDATE `npc_text` SET `BroadcastTextID2` = 10103 WHERE `ID` = 7374;
+UPDATE `npc_text` SET `BroadcastTextID3` = 10104 WHERE `ID` = 7374;
+UPDATE `npc_text` SET `BroadcastTextID0` = 10117 WHERE `ID` = 7381;
+UPDATE `npc_text` SET `BroadcastTextID2` = 10147 WHERE `ID` = 7390;
+UPDATE `npc_text` SET `BroadcastTextID0` = 10780 WHERE `ID` = 7796;
+UPDATE `npc_text` SET `BroadcastTextID0` = 10782 WHERE `ID` = 7799;
+UPDATE `npc_text` SET `BroadcastTextID0` = 11380 WHERE `ID` = 8103;
+UPDATE `npc_text` SET `BroadcastTextID0` = 11381 WHERE `ID` = 8104;
+UPDATE `npc_text` SET `BroadcastTextID0` = 11383 WHERE `ID` = 8106;
+UPDATE `npc_text` SET `BroadcastTextID0` = 11384 WHERE `ID` = 8107;
+UPDATE `npc_text` SET `BroadcastTextID0` = 11759 WHERE `ID` = 8263;
+UPDATE `npc_text` SET `BroadcastTextID0` = 11793 WHERE `ID` = 8285;
+UPDATE `npc_text` SET `BroadcastTextID0` = 11794 WHERE `ID` = 8286;
+UPDATE `npc_text` SET `BroadcastTextID0` = 11796 WHERE `ID` = 8288;
+UPDATE `npc_text` SET `BroadcastTextID0` = 11797 WHERE `ID` = 8289;
+UPDATE `npc_text` SET `BroadcastTextID0` = 11798 WHERE `ID` = 8290;
+UPDATE `npc_text` SET `BroadcastTextID0` = 12119 WHERE `ID` = 8439;
+UPDATE `npc_text` SET `BroadcastTextID0` = 12130 WHERE `ID` = 8446;
+UPDATE `npc_text` SET `BroadcastTextID0` = 12177 WHERE `ID` = 8469;
+UPDATE `npc_text` SET `BroadcastTextID2` = 11359 WHERE `ID` = 8081;
+UPDATE `npc_text` SET `BroadcastTextID0` = 13306 WHERE `ID` = 8753;
+UPDATE `npc_text` SET `BroadcastTextID0` = 13554 WHERE `ID` = 8828;
+UPDATE `npc_text` SET `BroadcastTextID0` = 13644 WHERE `ID` = 8850;
+UPDATE `npc_text` SET `BroadcastTextID0` = 14190 WHERE `ID` = 9006;
+-- Can't use it with language because it's used by neutral NPCs
+-- UPDATE `npc_text` SET `BroadcastTextID0` = 14352, `lang0` = 7 WHERE `ID` = 9051;
+UPDATE `npc_text` SET `BroadcastTextID0` = 14757 WHERE `ID` = 9179;
+UPDATE `npc_text` SET `BroadcastTextID0` = 14190 WHERE `ID` = 9184;
+UPDATE `npc_text` SET `BroadcastTextID0` = 14763 WHERE `ID` = 9185;
+UPDATE `npc_text` SET `BroadcastTextID0` = 14765 WHERE `ID` = 9186;
+UPDATE `npc_text` SET `BroadcastTextID0` = 14766 WHERE `ID` = 9187;
+UPDATE `npc_text` SET `BroadcastTextID0` = 14773 WHERE `ID` = 9193;
+UPDATE `npc_text` SET `BroadcastTextID2` = 14721 WHERE `ID` = 9172;
+UPDATE `npc_text` SET `BroadcastTextID0` = 16176 WHERE `ID` = 9686;
+UPDATE `npc_text` SET `BroadcastTextID0` = 16174 WHERE `ID` = 9688;
+UPDATE `npc_text` SET `BroadcastTextID0` = 16191 WHERE `ID` = 9702;
+UPDATE `npc_text` SET `BroadcastTextID0` = 16289 WHERE `ID` = 9749;
+UPDATE `npc_text` SET `BroadcastTextID0` = 17961 WHERE `ID` = 10024;
+UPDATE `npc_text` SET `BroadcastTextID0` = 19261 WHERE `ID` = 10405;
+UPDATE `npc_text` SET `BroadcastTextID0` = 19646 WHERE `ID` = 10519;
+UPDATE `npc_text` SET `BroadcastTextID0` = 19791 WHERE `ID` = 10598;
+UPDATE `npc_text` SET `BroadcastTextID0` = 20139 WHERE `ID` = 10655;
+UPDATE `npc_text` SET `BroadcastTextID0` = 20456 WHERE `ID` = 10732;
+UPDATE `npc_text` SET `BroadcastTextID0` = 20902 WHERE `ID` = 10835;
+UPDATE `npc_text` SET `BroadcastTextID0` = 21279 WHERE `ID` = 10887;
+UPDATE `npc_text` SET `BroadcastTextID2` = 20683 WHERE `ID` = 10734;
+UPDATE `npc_text` SET `BroadcastTextID0` = 21829 WHERE `ID` = 11064;
+UPDATE `npc_text` SET `BroadcastTextID0` = 22141, `lang0` = 0 WHERE `ID` = 11209;
+UPDATE `npc_text` SET `BroadcastTextID0` = 22523 WHERE `ID` = 11469;
+UPDATE `npc_text` SET `BroadcastTextID0` = 23157 WHERE `ID` = 11912;
+UPDATE `npc_text` SET `BroadcastTextID1` = 22298 WHERE `ID` = 11287;
+UPDATE `npc_text` SET `BroadcastTextID0` = 23339 WHERE `ID` = 12049;
+UPDATE `npc_text` SET `BroadcastTextID0` = 23850 WHERE `ID` = 12185;
+UPDATE `npc_text` SET `BroadcastTextID0` = 24256 WHERE `ID` = 12315;
+UPDATE `npc_text` SET `BroadcastTextID1` = 24257 WHERE `ID` = 12315;
+UPDATE `npc_text` SET `BroadcastTextID2` = 24258 WHERE `ID` = 12315;
+UPDATE `npc_text` SET `BroadcastTextID0` = 25309 WHERE `ID` = 12554;
+UPDATE `npc_text` SET `BroadcastTextID0` = 25561 WHERE `ID` = 12606;
+UPDATE `npc_text` SET `BroadcastTextID0` = 26950 WHERE `ID` = 12916;
+UPDATE `npc_text` SET `BroadcastTextID0` = 29493 WHERE `ID` = 13458;
+UPDATE `npc_text` SET `BroadcastTextID1` = 28923 WHERE `ID` = 13365;
+UPDATE `npc_text` SET `BroadcastTextID1` = 28913 WHERE `ID` = 13366;
+UPDATE `npc_text` SET `BroadcastTextID0` = 30147 WHERE `ID` = 13548;
+UPDATE `npc_text` SET `BroadcastTextID0` = 30864 WHERE `ID` = 13702;
+UPDATE `npc_text` SET `BroadcastTextID0` = 30959 WHERE `ID` = 13738;
+UPDATE `npc_text` SET `BroadcastTextID0` = 31359 WHERE `ID` = 13841;
+UPDATE `npc_text` SET `BroadcastTextID0` = 31370 WHERE `ID` = 13845;
+UPDATE `npc_text` SET `BroadcastTextID0` = 31371 WHERE `ID` = 13846;
+UPDATE `npc_text` SET `BroadcastTextID0` = 31717 WHERE `ID` = 13911;
+UPDATE `npc_text` SET `BroadcastTextID0` = 31742 WHERE `ID` = 13918;
+
+UPDATE `npc_text` a LEFT JOIN `broadcast_text` b ON a.`BroadcastTextID0` = b.`ID` SET a.`text0_0` = b.`Text` WHERE a.`ID` IN (8285,8286,12606,12916,13548,7381,8263,8288,8289,10405,11064,12185,12554,12916,13458,13548,13738,13841);
+UPDATE `npc_text` a LEFT JOIN `broadcast_text` b ON a.`BroadcastTextID0` = b.`ID` SET a.`text0_1` = b.`Text1` WHERE a.`ID` IN (8285,8286,12606,12916,13548,7381,8263,8288,8289,10405,11064,12185,12554,12916,13458,13548,13738,13841);
+UPDATE `npc_text` a LEFT JOIN `broadcast_text` b ON a.`BroadcastTextID2` = b.`ID` SET a.`text2_1` = b.`Text1` WHERE a.`ID` = 9172;