aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZenoX92 <ZenoX92@users.noreply.github.com>2017-10-10 18:08:55 +0200
committerShauren <shauren.trinity@gmail.com>2020-12-31 23:23:50 +0100
commitb020740b92899ed7f5c94231bb37ed809417919c (patch)
treecf5710b302cc32599c588007e5fd67e01557fa4c
parent9c30ffa672164a5f11aee0b90f4fcbafd8fb3d83 (diff)
DB/Gossip: Hermit Ortell
Closes #20579 (cherry picked from commit 96f7c70228be667c460bef8edbde18e3e1b1a6eb)
-rw-r--r--sql/updates/world/master/2020_11_06_03_world_2017_10_10_07_world_335.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_11_06_03_world_2017_10_10_07_world_335.sql b/sql/updates/world/master/2020_11_06_03_world_2017_10_10_07_world_335.sql
new file mode 100644
index 00000000000..d69f55130a6
--- /dev/null
+++ b/sql/updates/world/master/2020_11_06_03_world_2017_10_10_07_world_335.sql
@@ -0,0 +1,9 @@
+-- Hermit Ortell
+-- DELETE FROM `gossip_menu` WHERE `MenuID`=6596 AND `TextID`=7817;
+-- INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+-- (6596,7817,0);
+-- gossip_menu already exists in master
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`= 14 AND `SourceGroup`= 6596;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(14,6596,7817,0,0,8,0,8285,0,0,0,0,0,"","Show Gossip Menu Text 7817 if Quest 'The Deserter' is rewarded");