diff options
| author | offl <offl@users.noreply.github.com> | 2020-08-02 19:03:48 +0300 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2020-08-02 19:03:48 +0300 |
| commit | 1f8067e354db31156e6338e4bc545007163b2266 (patch) | |
| tree | af9b305d535c4976e1f1e570ca2f18e7d556c958 | |
| parent | 0b09f60ca3049e318934e5268dd9f72855d59ad2 (diff) | |
DB/Gossip: Add correct broadcast texts and language to some gossip texts part 3
Closes #25106
| -rw-r--r-- | sql/updates/world/3.3.5/2020_08_02_10_world_335.sql | 22 |
1 files changed, 22 insertions, 0 deletions
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; |