diff options
-rw-r--r-- | sql/updates/world/3.3.5/2020_06_17_05_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
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'"); |