From f68c9b7afdc2e3efff1bcb826115262e78f28183 Mon Sep 17 00:00:00 2001 From: offl 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 (cherry picked from commit 1f8067e354db31156e6338e4bc545007163b2266) --- ...2022_01_25_08_world_2020_08_02_10_world_335.sql | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 sql/updates/world/master/2022_01_25_08_world_2020_08_02_10_world_335.sql (limited to 'sql') 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; -- cgit v1.2.3