aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZenoX92 <ZenoX92@users.noreply.github.com>2018-05-15 17:07:19 +0200
committerShauren <shauren.trinity@gmail.com>2021-09-26 21:16:27 +0200
commit0a5e3cdcdc597a7bc69fec11a8061dc56f9d383a (patch)
treee96ceea15e9f7630c21569bb0568721f04ba9864
parent50f7cad10d3fc2bcfecf4f4ec244b0c8e300008d (diff)
DB/Gossip: Quintis Jonespyre
Closes #21937 (cherry picked from commit 3572bba5c04c8e5d9f827592ce7644ea8176f901)
-rw-r--r--sql/updates/world/master/2021_09_26_19_world_2018_05_15_03_world_335.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_09_26_19_world_2018_05_15_03_world_335.sql b/sql/updates/world/master/2021_09_26_19_world_2018_05_15_03_world_335.sql
new file mode 100644
index 00000000000..145fead7480
--- /dev/null
+++ b/sql/updates/world/master/2021_09_26_19_world_2018_05_15_03_world_335.sql
@@ -0,0 +1,7 @@
+--
+-- Quintis Jonespyre --> Add Gossip Text
+UPDATE `creature_template` SET `gossip_menu_id`=1922 WHERE `entry`=7879;
+
+DELETE FROM `gossip_menu_option` WHERE `MenuId`=1922;
+INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `VerifiedBuild`) VALUES
+(1922,0,1,"I'd like to purchase more Tharlendris seeds.",4851,3,128,0);