DB/Creature: Update Private Weeks with the correct gossip menu ID

(cherry picked from commit 9530ce4a2e140efe878a00e0ac1b904e9daa3882)

1 files changed, 5 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_11_15_01_world_2018_10_17_03_world_335.sql b/sql/updates/world/master/2021_11_15_01_world_2018_10_17_03_world_335.sql
new file mode 100644
index 00000000000..efb4c1992ec
--- /dev/null
+++ b/sql/updates/world/master/2021_11_15_01_world_2018_10_17_03_world_335.sql
@@ -0,0 +1,5 @@
+-- 
+DELETE FROM `gossip_menu` WHERE `MenuId` IN (21253) AND `TextId` IN (9520);
+UPDATE `gossip_menu_option` SET `OptionType`=1, `OptionNpcFlag`=1 WHERE `MenuId` IN (7771);
+UPDATE `creature_template` SET `gossip_menu_id`=7771 WHERE `entry`=18715;
+UPDATE `smart_scripts` SET `event_param1`=7771 WHERE `entryorguid` IN (18715) AND `source_type`=0 AND `id`=2;