diff options
author | offl <offl@users.noreply.github.com> | 2021-10-21 19:15:35 +0300 |
---|---|---|
committer | Shauren <shauren.trinity@gmail.com> | 2022-03-20 16:44:54 +0100 |
commit | d5ee84de7aabea584c0919c93e8d0981e6055e50 (patch) | |
tree | 225f8909d67aa13647dbd8624c31b9e447644c7d | |
parent | e302cf03bae6357f714a6821b1bd40f9830b46cc (diff) |
DB/Quest: Fix 'Redemption' (5742) gossips
Closes #27137
(cherry picked from commit e615b71509c018cb856680698f28bcdf83cde032)
-rw-r--r-- | sql/updates/world/master/2022_03_20_15_world_2021_10_21_02_world_335.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_20_15_world_2021_10_21_02_world_335.sql b/sql/updates/world/master/2022_03_20_15_world_2021_10_21_02_world_335.sql new file mode 100644 index 00000000000..7462c7dbbdb --- /dev/null +++ b/sql/updates/world/master/2022_03_20_15_world_2021_10_21_02_world_335.sql @@ -0,0 +1,9 @@ +-- +UPDATE `smart_scripts` SET `event_param1` = 3681 WHERE `entryorguid` = 1855 AND `source_type` = 0 AND `id` = 0; + +DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (3502,3683,3682,3681); +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(3502,0,0,"I am ready to hear your tale, Tirion.",7219,1,1,3683,0,0,0,'',0,0), +(3683,0,0,"Thank you, Tirion. What of your identity?",7221,1,1,3682,0,0,0,'',0,0), +(3682,0,0,"That is terrible.",7223,1,1,3681,0,0,0,'',0,0), +(3681,0,0,"I will, Tirion.",7225,1,1,0,0,0,0,'',0,0); |