DB/Gossip: Use original gossip ids in some cases

(cherry picked from commit 1e76fc7a5dd4993ef00fc6b90cce3221b03751a3)

1 files changed, 78 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_07_23_world_2021_03_23_01_world.sql b/sql/updates/world/master/2022_03_07_23_world_2021_03_23_01_world.sql
new file mode 100644
index 00000000000..338ed5c958d
--- /dev/null
+++ b/sql/updates/world/master/2022_03_07_23_world_2021_03_23_01_world.sql
@@ -0,0 +1,78 @@
+--
+UPDATE `gossip_menu` SET `MenuID` = 1061 WHERE `MenuID` = 57000;
+UPDATE `gossip_menu` SET `MenuID` = 1062 WHERE `MenuID` = 57001;
+UPDATE `gossip_menu` SET `MenuID` = 1063 WHERE `MenuID` = 57002;
+UPDATE `gossip_menu` SET `MenuID` = 1064 WHERE `MenuID` = 57003;
+UPDATE `gossip_menu` SET `MenuID` = 1065 WHERE `MenuID` = 57004;
+UPDATE `gossip_menu` SET `MenuID` = 1066 WHERE `MenuID` = 57005;
+UPDATE `gossip_menu_option` SET `MenuID` = 1061, `ActionMenuID` = 1062 WHERE `MenuID` = 57000 AND `OptionID` = 0;
+UPDATE `gossip_menu_option` SET `MenuID` = 1062, `ActionMenuID` = 1063 WHERE `MenuID` = 57001 AND `OptionID` = 0;
+UPDATE `gossip_menu_option` SET `MenuID` = 1063, `ActionMenuID` = 1064 WHERE `MenuID` = 57002 AND `OptionID` = 0;
+UPDATE `gossip_menu_option` SET `MenuID` = 1064, `ActionMenuID` = 1065 WHERE `MenuID` = 57003 AND `OptionID` = 0;
+UPDATE `gossip_menu_option` SET `MenuID` = 1065, `ActionMenuID` = 1066 WHERE `MenuID` = 57004 AND `OptionID` = 0;
+UPDATE `gossip_menu_option` SET `MenuID` = 1066 WHERE `MenuID` = 57005 AND `OptionID` = 0;
+UPDATE `conditions` SET `SourceGroup` = 1061 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 57000;
+UPDATE `creature_template` SET `gossip_menu_id` = 1061 WHERE `entry` = 7918;
+UPDATE `smart_scripts` SET `event_param1` = 1066 WHERE `entryorguid` = 7918 AND `source_type` = 0 AND `event_type` = 62;
+
+UPDATE `creature_template` SET `gossip_menu_id` = 6833 WHERE `entry` = 15562;
+UPDATE `gossip_menu` SET `VerifiedBuild` = 11159 WHERE `MenuID` = 6833;
+DELETE FROM `gossip_menu` WHERE `MenuID` = 21021;
+UPDATE `gossip_menu_option` SET `MenuID` = 6833, `OptionID` = 0 WHERE `MenuID` = 21021 AND `OptionID` = 1 AND `OptionBroadcastTextID` = 11554;
+UPDATE `gossip_menu_option` SET `MenuID` = 6833, `OptionID` = 1 WHERE `MenuID` = 21021 AND `OptionID` = 2 AND `OptionBroadcastTextID` = 11512;
+UPDATE `gossip_menu_option` SET `MenuID` = 6833, `OptionID` = 2 WHERE `MenuID` = 21021 AND `OptionID` = 3 AND `OptionBroadcastTextID` = 11534;
+UPDATE `gossip_menu_option` SET `MenuID` = 6833, `OptionID` = 3 WHERE `MenuID` = 21021 AND `OptionID` = 4 AND `OptionBroadcastTextID` = 11542;
+UPDATE `conditions` SET `SourceGroup` = 6833, `SourceEntry` = 0 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21021 AND `ConditionValue1` = 8718;
+UPDATE `conditions` SET `SourceGroup` = 6833, `SourceEntry` = 1 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21021 AND `ConditionValue1` = 8866;
+UPDATE `conditions` SET `SourceGroup` = 6833, `SourceEntry` = 2 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21021 AND `ConditionValue1` = 8636;
+UPDATE `conditions` SET `SourceGroup` = 6833, `SourceEntry` = 3 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21021 AND `ConditionValue1` = 8649;
+
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6876 WHERE `ActionMenuID` = 21080;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6858 WHERE `ActionMenuID` = 21084;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6865 WHERE `ActionMenuID` = 21121;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6868 WHERE `ActionMenuID` = 21138;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6842 WHERE `ActionMenuID` = 21093;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6843 WHERE `ActionMenuID` = 21106;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6854 WHERE `ActionMenuID` = 21100;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6867 WHERE `ActionMenuID` = 21133;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6873 WHERE `ActionMenuID` = 21096;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6877 WHERE `ActionMenuID` = 21127;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6878 WHERE `ActionMenuID` = 21078;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6879 WHERE `ActionMenuID` = 21134;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6895 WHERE `ActionMenuID` = 21143;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 6896 WHERE `ActionMenuID` = 21087;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 9930 WHERE `ActionMenuID` = 21075;
+UPDATE `gossip_menu_option` SET `ActionMenuID` = 9934 WHERE `ActionMenuID` = 21113;
+DELETE FROM `gossip_menu` WHERE `MenuID` IN (21080,21084,21121,21138,21093,21106,21100,21133,21096,21127,21078,21134,21143,21087,21075,21113);
+
+UPDATE `creature_template` SET `gossip_menu_id` = 6828 WHERE `entry` = 15582;
+UPDATE `gossip_menu` SET `VerifiedBuild` = 12340 WHERE `MenuID` = 6828;
+DELETE FROM `gossip_menu` WHERE `MenuID` = 21072;
+UPDATE `gossip_menu_option` SET `MenuID` = 6828, `OptionID` = 0 WHERE `MenuID` = 21072 AND `OptionID` = 1 AND `OptionBroadcastTextID` = 11574;
+UPDATE `gossip_menu_option` SET `MenuID` = 6828, `OptionID` = 1 WHERE `MenuID` = 21072 AND `OptionID` = 2 AND `OptionBroadcastTextID` = 11584;
+UPDATE `gossip_menu_option` SET `MenuID` = 6828, `OptionID` = 2 WHERE `MenuID` = 21072 AND `OptionID` = 3 AND `OptionBroadcastTextID` = 11578;
+UPDATE `gossip_menu_option` SET `MenuID` = 6828, `OptionID` = 3 WHERE `MenuID` = 21072 AND `OptionID` = 4 AND `OptionBroadcastTextID` = 11580;
+UPDATE `gossip_menu_option` SET `MenuID` = 6828, `OptionID` = 4 WHERE `MenuID` = 21072 AND `OptionID` = 5 AND `OptionBroadcastTextID` = 11586;
+UPDATE `gossip_menu_option` SET `MenuID` = 6828, `OptionID` = 5 WHERE `MenuID` = 21072 AND `OptionID` = 6 AND `OptionBroadcastTextID` = 11582;
+UPDATE `gossip_menu_option` SET `MenuID` = 6828, `OptionID` = 6 WHERE `MenuID` = 21072 AND `OptionID` = 7 AND `OptionBroadcastTextID` = 11588;
+UPDATE `conditions` SET `SourceGroup` = 6828, `SourceEntry` = 0 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21072 AND `ConditionValue1` = 8673;
+UPDATE `conditions` SET `SourceGroup` = 6828, `SourceEntry` = 1 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21072 AND `ConditionValue1` = 8677;
+UPDATE `conditions` SET `SourceGroup` = 6828, `SourceEntry` = 2 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21072 AND `ConditionValue1` = 8686;
+UPDATE `conditions` SET `SourceGroup` = 6828, `SourceEntry` = 3 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21072 AND `ConditionValue1` = 8717;
+UPDATE `conditions` SET `SourceGroup` = 6828, `SourceEntry` = 4 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21072 AND `ConditionValue1` = 8724;
+UPDATE `conditions` SET `SourceGroup` = 6828, `SourceEntry` = 5 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21072 AND `ConditionValue1` = 8678;
+UPDATE `conditions` SET `SourceGroup` = 6828, `SourceEntry` = 6 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21072 AND `ConditionValue1` = 8670;
+
+UPDATE `creature_template` SET `gossip_menu_id` = 6816 WHERE `entry` = 15568;
+UPDATE `gossip_menu` SET `VerifiedBuild` = 11723 WHERE `MenuID` = 6816;
+DELETE FROM `gossip_menu` WHERE `MenuID` = 21018;
+UPDATE `gossip_menu_option` SET `MenuID` = 6816, `OptionID` = 0 WHERE `MenuID` = 21018 AND `OptionID` = 1 AND `OptionBroadcastTextID` = 11493;
+UPDATE `gossip_menu_option` SET `MenuID` = 6816, `OptionID` = 1 WHERE `MenuID` = 21018 AND `OptionID` = 2 AND `OptionBroadcastTextID` = 11653;
+UPDATE `gossip_menu_option` SET `MenuID` = 6816, `OptionID` = 2 WHERE `MenuID` = 21018 AND `OptionID` = 3 AND `OptionBroadcastTextID` = 11491;
+UPDATE `gossip_menu_option` SET `MenuID` = 6816, `OptionID` = 3 WHERE `MenuID` = 21018 AND `OptionID` = 4 AND `OptionBroadcastTextID` = 11497;
+UPDATE `gossip_menu_option` SET `MenuID` = 6816, `OptionID` = 4 WHERE `MenuID` = 21018 AND `OptionID` = 5 AND `OptionBroadcastTextID` = 11499;
+UPDATE `conditions` SET `SourceGroup` = 6816, `SourceEntry` = 0 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21018 AND `ConditionValue1` = 8648;
+UPDATE `conditions` SET `SourceGroup` = 6816, `SourceEntry` = 1 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21018 AND `ConditionValue1` = 8722;
+UPDATE `conditions` SET `SourceGroup` = 6816, `SourceEntry` = 2 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21018 AND `ConditionValue1` = 8714;
+UPDATE `conditions` SET `SourceGroup` = 6816, `SourceEntry` = 3 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21018 AND `ConditionValue1` = 8645;
+UPDATE `conditions` SET `SourceGroup` = 6816, `SourceEntry` = 4 WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 21018 AND `ConditionValue1` = 8650;