From ec508fbdba0beaf33684f5aa5fa64d30bdcd9815 Mon Sep 17 00:00:00 2001 From: Xyventh Date: Mon, 24 Apr 2017 18:56:08 +0200 Subject: DB/Gossip: Apprentice Shatharia and Magister Quallestis Closes #19509 (cherry picked from commit c423b37143f09080c15682fadd88941e35895e73) --- .../2020_04_27_04_world_2017_04_24_08_world.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/updates/world/master/2020_04_27_04_world_2017_04_24_08_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2020_04_27_04_world_2017_04_24_08_world.sql b/sql/updates/world/master/2020_04_27_04_world_2017_04_24_08_world.sql new file mode 100644 index 00000000000..c261528ce0e --- /dev/null +++ b/sql/updates/world/master/2020_04_27_04_world_2017_04_24_08_world.sql @@ -0,0 +1,19 @@ +-- +DELETE FROM `gossip_menu` WHERE `MenuId`=7192 AND `textid`=8473; +DELETE FROM `gossip_menu` WHERE `MenuId`=7194 AND `textid`=8475; +INSERT INTO `gossip_menu` (`MenuId`, `textid`, `VerifiedBuild`) VALUES +(7192, 8473, 0), +(7194, 8475, 0); + +DELETE FROM `npc_text` WHERE `ID`=8473; +INSERT INTO `npc_text` (`ID`, `Probability0`,`BroadcastTextID0`) VALUES +(8473, 100, 12182); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup` IN (7192, 7194); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `comment`) VALUES +(14, 7192, 8472, 0, 0, 8, 0, 9207, 0, 0, 1, 0, 0, "", "Gossip text requires quest Underlight Ore Samples NOT rewarded"), +(14, 7192, 8473, 0, 0, 8, 0, 9207, 0, 0, 0, 0, 0, "", "Gossip text requires quest Underlight Ore Samples rewarded"), +(14, 7194, 8474, 0, 0, 8, 0, 9207, 0, 0, 1, 0, 0, "", "Gossip text requires quest Underlight Ore Samples NOT rewarded"), +(14, 7194, 8475, 0, 0, 8, 0, 9207, 0, 0, 0, 0, 0, "", "Gossip text requires quest Underlight Ore Samples rewarded"); + +UPDATE `quest_offer_reward` SET `RewardText`="My apprentice was unable to take care of this herself? I shall have a word with her when she returns then, gnolls or not. Speaking of which, why didn't she return with you?$B$B$B$BThat one is a handful, and is going to be quite a challenge to properly train. Thank you, for bringing these samples to me. We are hoping that we can uncover some special property from them that will help in the fight against the Scourge.$B$BPlease take this coin as a token of my appreciation." WHERE `ID`=9207; -- cgit v1.2.3