diff options
| -rw-r--r-- | sql/updates/world/master/2020_04_27_04_world_2017_04_24_08_world.sql | 19 |
1 files changed, 19 insertions, 0 deletions
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<The magister sighs.>$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; |