DB/Gossip: Earthcaller Franzahl

Closes #22608

(cherry picked from commit 486f241a58e33b4bfbbef9b46a850e596c5316c7)

1 files changed, 31 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_11_13_23_world_2018_10_09_17_world_335.sql b/sql/updates/world/master/2021_11_13_23_world_2018_10_09_17_world_335.sql
new file mode 100644
index 00000000000..1b94fe62984
--- /dev/null
+++ b/sql/updates/world/master/2021_11_13_23_world_2018_10_09_17_world_335.sql
@@ -0,0 +1,31 @@
+-- Earthcaller Franzahl
+UPDATE `creature_template` SET `gossip_menu_id`=5812 WHERE `entry`=14348;
+
+DELETE FROM `gossip_menu` WHERE `MenuID` IN (5812,5813,5814,5815,5816);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(5812,6985,0),
+(5813,6986,0),
+(5814,6987,0),
+(5815,6988,0),
+(5816,6989,0);
+
+DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (5812,5813,5814,5815);
+INSERT INTO `gossip_menu_option` (`MenuID`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `VerifiedBuild`) VALUES
+(5812,0,0,"Are you the Earthshaper capable of creating Elementium?",9576,1,1,0),
+(5813,0,0,"What do you know of it, Franzahl?",9578,1,1,0),
+(5814,0,0,"A fissure?",9580,1,1,0),
+(5815,0,0,"So what happened?",9582,1,1,0);
+
+DELETE FROM `gossip_menu_option_action` WHERE `MenuID` IN (5812,5813,5814,5815);
+INSERT INTO `gossip_menu_option_action` (`MenuID`, `OptionIndex`, `ActionMenuID`, `ActionPoiID`) VALUES
+(5812,0,5813,0),
+(5813,0,5814,0),
+(5814,0,5815,0),
+(5815,0,5816,0);
+
+DELETE FROM `npc_text` WHERE `ID` IN (6986,6987,6988,6989);
+INSERT INTO `npc_text` (`ID`, `BroadcastTextID0`, `Probability0`) VALUES
+(6986,9577,1),
+(6987,9579,1),
+(6988,9581,1),
+(6989,9583,1);