DB/Gossip: Fix gossips for Neill Ramstein & Ram Master Ray

1 files changed, 14 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_02_14_00_world_335.sql b/sql/updates/world/3.3.5/2020_02_14_00_world_335.sql
new file mode 100644
index 00000000000..003c2a87f7d
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_02_14_00_world_335.sql
@@ -0,0 +1,14 @@
+-- 
+UPDATE `creature_template_addon` SET `mount`=0 WHERE `entry`=24497; 
+UPDATE `gossip_menu_option` SET `OptionText`="Do you still need some help shipping kegs from Kharanos?", `OptionBroadcastTextID`=23245, `ActionMenuID`= 8953 WHERE `MenuID`=8934 AND `OptionID`=4;
+UPDATE `smart_scripts` SET `event_param1`=8953, `event_param2`=0 WHERE `entryorguid` IN (23558) AND `source_type`=0 AND `id`=6; 
+UPDATE `smart_scripts` SET `event_param1`=8973, `event_param2`=0 WHERE `entryorguid` IN (24497) AND `source_type`=0 AND `id`=8; 
+
+UPDATE `gossip_menu_option` SET `OptionText`="Do you still need some help moving kegs from the crash site near Razor Hill?", `OptionBroadcastTextID`=23546, `ActionMenuID`=8973 WHERE `MenuID`=8976 AND `OptionID`=4;
+DELETE FROM `gossip_menu` WHERE `MenuID`=8973 AND `TextID`=12113;
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`) VALUES
+(8973, 12113);
+
+DELETE FROM `gossip_menu_option` WHERE `MenuId`=8973 AND `OptionID`=0;
+INSERT INTO `gossip_menu_option` (`MenuId`, `OptionID`, `OptionIcon`, `OptionText`, `OptionType`, `OptionNpcFlag`, `OptionBroadcastTextId`) VALUES
+(8973, 0, 0, "I'm ready to work for you today!  Give me that ram!", 1, 1, 23545);