diff options
| author | offl <offl@users.noreply.github.com> | 2020-06-17 22:48:10 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2020-06-17 22:48:10 +0200 |
| commit | 359b4712e2cb4d7b2a1ecf4c1507a0c4902e11b4 (patch) | |
| tree | 13efe7d0d6146cc4a879d03e1674812c1244b849 | |
| parent | 4a460554f49306a2bafa38a08a2a33d01ba96614 (diff) | |
DB/Creature: Add missing text & conditions to Sahaak's gossip
Closes #24769
| -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'"); |