From 359b4712e2cb4d7b2a1ecf4c1507a0c4902e11b4 Mon Sep 17 00:00:00 2001 From: offl Date: Wed, 17 Jun 2020 22:48:10 +0200 Subject: DB/Creature: Add missing text & conditions to Sahaak's gossip Closes #24769 --- sql/updates/world/3.3.5/2020_06_17_05_world.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_06_17_05_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2020_06_17_05_world.sql b/sql/updates/world/3.3.5/2020_06_17_05_world.sql new file mode 100644 index 00000000000..7b1b97b8db4 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_06_17_05_world.sql @@ -0,0 +1,13 @@ +-- https://www.youtube.com/watch?v=1yKt1V5Qnk8 +DELETE FROM `gossip_menu` WHERE `MenuID` = 8683 AND `TextID` = 10930; +INSERT INTO `gossip_menu` (`MenuID`,`TextID`,`VerifiedBuild`) VALUES +(8683,10930,0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 14 AND `SourceGroup` = 8683; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(14,8683,10930,0,0,1,0,41181,0,0,1,0,0,"","Group 0: Show gossip text 10930 if player does not have aura 'Shabby Arakkoa Disguise'"), +(14,8683,10953,0,0,1,0,41181,0,0,0,0,0,"","Group 0: Show gossip text 10953 if player does have aura 'Shabby Arakkoa Disguise'"); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 8683; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,8683,0,0,0,1,0,41181,0,0,0,0,0,"","Group 0: Show Gossip Option 0 if player does have aura 'Shabby Arakkoa Disguise'"); -- cgit v1.2.3