diff options
| -rw-r--r-- | sql/updates/world/master/2022_01_25_06_world_2020_08_02_07_world_335.sql | 78 |
1 files changed, 78 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_25_06_world_2020_08_02_07_world_335.sql b/sql/updates/world/master/2022_01_25_06_world_2020_08_02_07_world_335.sql new file mode 100644 index 00000000000..f6eab5dd577 --- /dev/null +++ b/sql/updates/world/master/2022_01_25_06_world_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; |