DB/Gossip: Fix and add some gossips

(cherry picked from commit f74973e175855687850ea96e009292ae41d2445f)

1 files changed, 24 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_11_14_05_world_2018_10_10_06_world.sql b/sql/updates/world/master/2021_11_14_05_world_2018_10_10_06_world.sql
new file mode 100644
index 00000000000..a13e6b29076
--- /dev/null
+++ b/sql/updates/world/master/2021_11_14_05_world_2018_10_10_06_world.sql
@@ -0,0 +1,24 @@
+-- 
+DELETE FROM `gossip_menu` WHERE `MenuID` IN (55000, 54000);
+-- UPDATE `creature_template` SET `gossip_menu_id`=10274 WHERE `entry`=29319;
+-- UPDATE `creature_template` SET `gossip_menu_id`=10273 WHERE `entry`=29327;
+UPDATE `gossip_menu_option` SET `OptionType`=1,`OptionNpcFlag`=1 WHERE `MenuId` IN (10273,10274);
+DELETE FROM `gossip_menu_option` WHERE `MenuId` IN (54000, 55000);
+-- INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`) VALUES
+-- (10160, 0, 0, "The Alliance Quarter", 32103, 1, 1, 10054, 129),
+-- (10160, 1, 0, "The Horde Quarter", 32104, 1, 1, 10053, 130),
+-- (10273, 0, 0, "Lift the frost leopard's tail to check if it's a male or a female.", 33190, 1, 1, 0, 0),
+-- (10274, 0, 0, "Lift the icepaw bear's tail to check if it's a male or a female.", 33194, 1, 1, 0, 0);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (55000,54000,10273,10274);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(15,10273,0,0,9,13549,0,0,0,'',"Only show gossip if player is on quest Tails Up"),
+(15,10274,0,0,9,13549,0,0,0,'',"Only show gossip if player is on quest Tails Up");
+
+UPDATE `smart_scripts` SET `event_param1`=10274 WHERE `entryorguid`=29319 AND `source_type`=0 AND `id`=3; 
+UPDATE `smart_scripts` SET `event_param1`=10273 WHERE `entryorguid`=29327 AND `source_type`=0 AND `id`=3; 
+
+-- DELETE FROM `npc_text` WHERE `ID` IN (12568, 13944);
+-- INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `BroadcastTextID0`, `lang0`, `Probability0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`) VALUES
+-- (12568,"Here you are, $n.$b$bDo be more careful, won't you?","",25370,0,1,0,0,0,0,0,0),
+-- (13944,"","You must defeat Prince Sandoval. It is your only hope for survival, $c.",32011,0,1,0,0,0,0,0,0);