diff options
| author | offl <offl@users.noreply.github.com> | 2020-08-04 02:03:51 +0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-26 13:42:20 +0100 |
| commit | afcb13cd44cf77d6599805f7160d9255c0a6ca4c (patch) | |
| tree | e90854925fb37e4ed8702ffb6889bad53f5f7e7b /sql | |
| parent | 9482a2f8c900cbc97b24b9333f917552146a8f05 (diff) | |
DB/Texts: Remove mismatches between texts in creature_text and texts in broadcast_text
(cherry picked from commit bc6137d08c08ef2fb29e871cf5659c4d1c5c41ab)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_01_26_07_world_2020_08_04_01_world_335.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_26_07_world_2020_08_04_01_world_335.sql b/sql/updates/world/master/2022_01_26_07_world_2020_08_04_01_world_335.sql new file mode 100644 index 00000000000..9c0d571c328 --- /dev/null +++ b/sql/updates/world/master/2022_01_26_07_world_2020_08_04_01_world_335.sql @@ -0,0 +1,19 @@ +-- Texts with wrong broadcast texts (typos, both texts are completely different) +-- Disobedient Dragonmaw Peon, these texts are related to another quest +DELETE FROM `creature_text` WHERE `CreatureID` = 23311 AND `GroupID` = 0 AND `ID` IN (6,7); +-- Moodle +UPDATE `creature_text` SET `BroadcastTextId` = 28395 WHERE `CreatureID` = 28122 AND `GroupID` = 3 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 28394 WHERE `CreatureID` = 28122 AND `GroupID` = 3 AND `ID` = 1; +-- Text https://www.wowhead.com/npc=28122/moodle#comments:id=914017:reply=436172 will be just replaced by text +-- from broadcast_text, since there's no such text and never was +-- And another https://www.wowhead.com/npc=28122/moodle#comments:id=914017:reply=436172 +UPDATE `creature_text` SET `BroadcastTextId` = 28401 WHERE `CreatureID` = 28122 AND `GroupID` = 4 AND `ID` = 1; +UPDATE `creature_text` SET `BroadcastTextId` = 28402 WHERE `CreatureID` = 28122 AND `GroupID` = 4 AND `ID` = 2; +UPDATE `creature_text` SET `BroadcastTextId` = 28399 WHERE `CreatureID` = 28122 AND `GroupID` = 4 AND `ID` = 3; +UPDATE `creature_text` SET `BroadcastTextId` = 28397 WHERE `CreatureID` = 28122 AND `GroupID` = 4 AND `ID` = 4; +UPDATE `creature_text` SET `BroadcastTextId` = 28398 WHERE `CreatureID` = 28122 AND `GroupID` = 4 AND `ID` = 5; +-- Instructor Hroegar +UPDATE `creature_text` SET `BroadcastTextId` = 30576 WHERE `CreatureID` = 29915 AND `GroupID` = 0 AND `ID` = 7; + +-- UPDATE `creature_text` a LEFT JOIN `broadcast_text` b ON a.`BroadcastTextId` = b.`ID` SET a.`Text` = b.`Text` WHERE b.`Text1` = '' AND a.`Text` != b.`Text`; +-- UPDATE `creature_text` a LEFT JOIN `broadcast_text` b ON a.`BroadcastTextId` = b.`ID` SET a.`Text` = b.`Text1` WHERE b.`Text` = '' AND a.`Text` != b.`Text1`; |