diff options
| author | offl <offl@users.noreply.github.com> | 2020-06-17 22:48:10 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-06 22:28:32 +0100 |
| commit | 4099f96a74854231251f88ef88b0ae6a31475bb6 (patch) | |
| tree | f2272e2379aef04849ef746db9c01c38f311fc6e /sql | |
| parent | 665f3c10556bf3cc909eb8d2a064b9394f35b264 (diff) | |
DB/Creature: Add missing text & conditions to Sahaak's gossip
Closes #24769
(cherry picked from commit 359b4712e2cb4d7b2a1ecf4c1507a0c4902e11b4)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_01_06_56_world_2020_06_17_05_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_06_56_world_2020_06_17_05_world.sql b/sql/updates/world/master/2022_01_06_56_world_2020_06_17_05_world.sql new file mode 100644 index 00000000000..7b1b97b8db4 --- /dev/null +++ b/sql/updates/world/master/2022_01_06_56_world_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'"); |