aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorWyreth <Wyreth@users.noreply.github.com>2017-10-03 18:54:08 +0200
committerShauren <shauren.trinity@gmail.com>2020-09-14 23:29:27 +0200
commite9eadc446a5101f330450986c565cb9864aa94d7 (patch)
tree91325fe1dcc3e6cb2cbdb87bfc5ae9114b735244
parentc9eb82c67b1cc182695a9572d2f637fe4c593573 (diff)
DB/Gossip: fix gossip text for Old Icefin
Closes #20516 (cherry picked from commit a2b620e3c99d9bfcb82ccd8d9639bf75a373f498)
-rw-r--r--sql/updates/world/master/2020_09_14_07_world_2017_10_03_03_world.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_09_14_07_world_2017_10_03_03_world.sql b/sql/updates/world/master/2020_09_14_07_world_2017_10_03_03_world.sql
new file mode 100644
index 00000000000..53e6d63138c
--- /dev/null
+++ b/sql/updates/world/master/2020_09_14_07_world_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");