DB/Gossip: Jorn Skyseer

Closes #22743

(cherry picked from commit 5eaaa3aca094ad8a082ba50a5d7a09a10e9b12d8)

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_11_16_18_world_2018_12_08_30_world_335.sql b/sql/updates/world/master/2021_11_16_18_world_2018_12_08_30_world_335.sql
new file mode 100644
index 00000000000..00cc7dd6ff0
--- /dev/null
+++ b/sql/updates/world/master/2021_11_16_18_world_2018_12_08_30_world_335.sql
@@ -0,0 +1,17 @@
+--
+-- Jorn Skyseer
+DELETE FROM `gossip_menu` WHERE `MenuID`=1241;
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(1241,1874,0);
+
+DELETE FROM `gossip_menu_option` WHERE `MenuID`=1242;
+INSERT INTO `gossip_menu_option` (`MenuID`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `VerifiedBuild`) VALUES
+(1242,0,0,"Where does my path now lead, Jorn?",4348,1,1,0);
+
+DELETE FROM `gossip_menu_option_action` WHERE `MenuID`=1242;
+INSERT INTO `gossip_menu_option_action` (`MenuID`, `OptionIndex`, `ActionMenuID`, `ActionPoiID`) VALUES
+(1242,0,1241,0);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=1242;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(15,1242,0,0,0,8,0,913,0,0,0,0,0,"","Show gossip option if quest 'Cry of the Thunderhawk' is rewarded");