aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZenoX92 <ZenoX92@users.noreply.github.com>2018-10-09 22:46:00 +0200
committerKillyana <morphone1@gmail.com>2018-10-09 22:46:00 +0200
commit486f241a58e33b4bfbbef9b46a850e596c5316c7 (patch)
treea02fa32dd7e1b9b16e3bb78f2828826ee6818a9b
parent9a87d5b3002a9ba96d1ac7933f6d636ec6da7413 (diff)
DB/Gossip: Earthcaller Franzahl
Closes #22608
-rw-r--r--sql/updates/world/3.3.5/2018_10_09_17_world_335.sql24
1 files changed, 24 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_10_09_17_world_335.sql b/sql/updates/world/3.3.5/2018_10_09_17_world_335.sql
new file mode 100644
index 00000000000..22944c60d45
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_09_17_world_335.sql
@@ -0,0 +1,24 @@
+-- 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`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES
+(5812,0,0,"Are you the Earthshaper capable of creating Elementium?",9576,1,1,5813,0,0,0,"",0,0),
+(5813,0,0,"What do you know of it, Franzahl?",9578,1,1,5814,0,0,0,"",0,0),
+(5814,0,0,"A fissure?",9580,1,1,5815,0,0,0,"",0,0),
+(5815,0,0,"So what happened?",9582,1,1,5816,0,0,0,"",0,0);
+
+DELETE FROM `npc_text` WHERE `ID` IN (6986,6987,6988,6989);
+INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `BroadcastTextID0`, `lang0`, `Probability0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`) VALUES
+(6986,"Elementium? I have not heard that word uttered from the mouth of a mortal in decades.","",9577,0,1,0,1,0,0,0,0),
+(6987,"A former student of mine by the name of Krixix spent a lifetime attempting to make contact with the chained Gods of the underworld. He pursued that which would spring up from the ravaged earth... That which would form only as a result of the elements clashing in titanic conflict.$B$BElementium as it would be known to mortals.$B$BOne day, nearly a decade ago, Krixix's pursuit lead to a fissure forming in this very gorge.","",9579,0,1,0,1,0,1,0,0),
+(6988,"Aye, he had done what was thought to be impossible. Out from the fissure sprung an agent of Therazane!$B$BFrom my vantage point, I could see the goblin holding conversation with the agent of the Old God. What happened after that was terrible...","",9581,0,1,0,1,0,1,0,0),
+(6989,"The fissure closed and Krixix was gone! Swallowed whole!$B$BBe warned, $r, what you wish for could very well become that which you do not want. You play with beings and arcana that are older than time itself!$B$BShould Krixix be alive and should he have the information which you seek, you can be certain that he will not give up said information. He has faced terrors far worse than you could ever dream to perpetrate.","",9583,0,1,0,1,0,5,0,0);