From ecb24097e549179ca03e62f1e94bd48ffd1509f8 Mon Sep 17 00:00:00 2001 From: Killyana Date: Mon, 24 Sep 2018 00:28:44 +0200 Subject: DB/Gossip: Update Olga gossip (cherry picked from commit 38e4eb0668c942b4427dbfed3b8cb3cde0c95811) --- .../master/2021_11_10_01_world_2018_09_23_05_world.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/master/2021_11_10_01_world_2018_09_23_05_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_11_10_01_world_2018_09_23_05_world.sql b/sql/updates/world/master/2021_11_10_01_world_2018_09_23_05_world.sql new file mode 100644 index 00000000000..e2b54c9af2a --- /dev/null +++ b/sql/updates/world/master/2021_11_10_01_world_2018_09_23_05_world.sql @@ -0,0 +1,14 @@ +-- +DELETE FROM `gossip_menu` WHERE `MenuId`=9014 AND `TextId`=12180; +INSERT INTO `gossip_menu` (`MenuId`, `TextId`) VALUES (9014,12180); +-- UPDATE `gossip_menu_option` SET `ActionMenuID`=9014 WHERE `MenuID`=9015; + +DELETE FROM `gossip_menu_option` WHERE `MenuID`=9014; +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `VerifiedBuild`) VALUES +(9014, 0, 0, "Here's a gold, buy yourself something nice.", 23829, 1, 1, 0); + +DELETE FROM `gossip_menu_option_box` WHERE `MenuID`=9014; +INSERT INTO `gossip_menu_option_box` (`MenuID`, `OptionIndex`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextId`) VALUES +(9014, 0, 0, 10000, "Do you really want to bribe Olga?", 25743); + +UPDATE `smart_scripts` SET `event_param1`=9014 WHERE `entryorguid`=24639 AND `source_type`=0 AND `id`=0; -- cgit v1.2.3