diff options
| author | Wyreth <Wyreth@users.noreply.github.com> | 2017-10-03 18:54:08 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-10-03 18:54:08 +0200 |
| commit | a2b620e3c99d9bfcb82ccd8d9639bf75a373f498 (patch) | |
| tree | beb480ef03dd973a3fec1689243d2c3bcf9183f2 | |
| parent | bc481da6a08585086ac3ae5cf933bda4163d9906 (diff) | |
DB/Gossip: fix gossip text for Old Icefin
Closes #20516
| -rw-r--r-- | sql/updates/world/3.3.5/2017_10_03_03_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_10_03_03_world.sql b/sql/updates/world/3.3.5/2017_10_03_03_world.sql new file mode 100644 index 00000000000..53e6d63138c --- /dev/null +++ b/sql/updates/world/3.3.5/2017_10_03_03_world.sql @@ -0,0 +1,9 @@ +-- +DELETE FROM `gossip_menu` WHERE `MenuID`=8985 AND `TextID`=12124; +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(8985, 12124, 0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=8985; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14, 8985, 12124, 0, 0, 8, 0, 11422, 0, 0, 1, 0, 0, "", "Show gossip text if quest 'Trident of the Son' is NOT rewarded"), +(14, 8985, 12130, 0, 0, 8, 0, 11422, 0, 0, 0, 0, 0, "", "Show gossip text if quest 'Trident of the Son' is rewarded"); |