aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2020_02_14_00_world_335.sql14
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);