diff options
| author | Killyana <morphone1@gmail.com> | 2018-09-24 00:28:44 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2018-09-24 00:28:44 +0200 |
| commit | 38e4eb0668c942b4427dbfed3b8cb3cde0c95811 (patch) | |
| tree | f86a967a0a00685fb6dfcfcc40a33f13662e7a8d | |
| parent | 2965c915c67426af1bb81391046d8058254acff5 (diff) | |
DB/Gossip: Update Olga gossip
| -rw-r--r-- | sql/updates/world/3.3.5/2018_09_23_05_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_09_23_05_world.sql b/sql/updates/world/3.3.5/2018_09_23_05_world.sql new file mode 100644 index 00000000000..cc2fffbda65 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_09_23_05_world.sql @@ -0,0 +1,9 @@ +-- +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`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(9014, 0, 0, "Here's a gold,, buy yourself something nice.", 23829, 1, 1, 0, 0, 0, 10000, "Do you really want to bribe Olga?", 25743, 0); +UPDATE `smart_scripts` SET `event_param1`=9014 WHERE `entryorguid`=24639 AND `source_type`=0 AND `id`=0; |