From 642ac152ec4932b53b467d984cbb716156ba9509 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sat, 8 Feb 2020 21:04:33 +0100 Subject: DB/npc_text: Sync npc_text data with broadcast_text Ref #22282 --- sql/updates/world/3.3.5/2020_02_08_03_world_335.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_02_08_03_world_335.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2020_02_08_03_world_335.sql b/sql/updates/world/3.3.5/2020_02_08_03_world_335.sql new file mode 100644 index 00000000000..1a0cdbba8b9 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_02_08_03_world_335.sql @@ -0,0 +1,9 @@ +-- +UPDATE `npc_text` AS a INNER JOIN `broadcast_text` AS b ON a.`BroadcastTextID0` = b.`ID` SET a.`lang0`= b.`LanguageID`, a.`text0_0` = b.`Text`, a.`text0_1` = b.`Text1`, a.`EmoteDelay0_0` = b.`EmoteDelay1`, a.`Emote0_0` = b.`EmoteID1`, a.`EmoteDelay0_1` = b.`EmoteDelay2`, a.`Emote0_1` = b.`EmoteID2`, a.`EmoteDelay0_2` = b.`EmoteDelay3`, a.`Emote0_2` = b.`EmoteID3`; +UPDATE `npc_text` AS a INNER JOIN `broadcast_text` AS b ON a.`BroadcastTextID1` = b.`ID` SET a.`lang1`= b.`LanguageID`, a.`text1_0` = b.`Text`, a.`text1_1` = b.`Text1`, a.`EmoteDelay1_0` = b.`EmoteDelay1`, a.`Emote1_0` = b.`EmoteID1`, a.`EmoteDelay1_1` = b.`EmoteDelay2`, a.`Emote1_1` = b.`EmoteID2`, a.`EmoteDelay1_2` = b.`EmoteDelay3`, a.`Emote1_2` = b.`EmoteID3`; +UPDATE `npc_text` AS a INNER JOIN `broadcast_text` AS b ON a.`BroadcastTextID2` = b.`ID` SET a.`lang2`= b.`LanguageID`, a.`text2_0` = b.`Text`, a.`text2_1` = b.`Text1`, a.`EmoteDelay2_0` = b.`EmoteDelay1`, a.`Emote2_0` = b.`EmoteID1`, a.`EmoteDelay2_1` = b.`EmoteDelay2`, a.`Emote2_1` = b.`EmoteID2`, a.`EmoteDelay2_2` = b.`EmoteDelay3`, a.`Emote2_2` = b.`EmoteID3`; +UPDATE `npc_text` AS a INNER JOIN `broadcast_text` AS b ON a.`BroadcastTextID3` = b.`ID` SET a.`lang3`= b.`LanguageID`, a.`text3_0` = b.`Text`, a.`text3_1` = b.`Text1`, a.`EmoteDelay3_0` = b.`EmoteDelay1`, a.`Emote3_0` = b.`EmoteID1`, a.`EmoteDelay3_1` = b.`EmoteDelay2`, a.`Emote3_1` = b.`EmoteID2`, a.`EmoteDelay3_2` = b.`EmoteDelay3`, a.`Emote3_2` = b.`EmoteID3`; +UPDATE `npc_text` AS a INNER JOIN `broadcast_text` AS b ON a.`BroadcastTextID4` = b.`ID` SET a.`lang4`= b.`LanguageID`, a.`text4_0` = b.`Text`, a.`text4_1` = b.`Text1`, a.`EmoteDelay4_0` = b.`EmoteDelay1`, a.`Emote4_0` = b.`EmoteID1`, a.`EmoteDelay4_1` = b.`EmoteDelay2`, a.`Emote4_1` = b.`EmoteID2`, a.`EmoteDelay4_2` = b.`EmoteDelay3`, a.`Emote4_2` = b.`EmoteID3`; +UPDATE `npc_text` AS a INNER JOIN `broadcast_text` AS b ON a.`BroadcastTextID5` = b.`ID` SET a.`lang5`= b.`LanguageID`, a.`text5_0` = b.`Text`, a.`text5_1` = b.`Text1`, a.`EmoteDelay5_0` = b.`EmoteDelay1`, a.`Emote5_0` = b.`EmoteID1`, a.`EmoteDelay5_1` = b.`EmoteDelay2`, a.`Emote5_1` = b.`EmoteID2`, a.`EmoteDelay5_2` = b.`EmoteDelay3`, a.`Emote5_2` = b.`EmoteID3`; +UPDATE `npc_text` AS a INNER JOIN `broadcast_text` AS b ON a.`BroadcastTextID6` = b.`ID` SET a.`lang6`= b.`LanguageID`, a.`text6_0` = b.`Text`, a.`text6_1` = b.`Text1`, a.`EmoteDelay6_0` = b.`EmoteDelay1`, a.`Emote6_0` = b.`EmoteID1`, a.`EmoteDelay6_1` = b.`EmoteDelay2`, a.`Emote6_1` = b.`EmoteID2`, a.`EmoteDelay6_2` = b.`EmoteDelay3`, a.`Emote6_2` = b.`EmoteID3`; +UPDATE `npc_text` AS a INNER JOIN `broadcast_text` AS b ON a.`BroadcastTextID7` = b.`ID` SET a.`lang7`= b.`LanguageID`, a.`text7_0` = b.`Text`, a.`text7_1` = b.`Text1`, a.`EmoteDelay7_0` = b.`EmoteDelay1`, a.`Emote7_0` = b.`EmoteID1`, a.`EmoteDelay7_1` = b.`EmoteDelay2`, a.`Emote7_1` = b.`EmoteID2`, a.`EmoteDelay7_2` = b.`EmoteDelay3`, a.`Emote7_2` = b.`EmoteID3`; -- cgit v1.2.3