aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZenoX92 <ZenoX92@users.noreply.github.com>2017-10-10 18:03:39 +0200
committerShauren <shauren.trinity@gmail.com>2020-12-31 23:23:50 +0100
commit9c30ffa672164a5f11aee0b90f4fcbafd8fb3d83 (patch)
treee195094a0008260dfb4f13d02ab6d508df612b59
parentf7cf46af7587cd5ed13b1044919809c10aa3d195 (diff)
DB/Gossip: Geologist Larksbane
Closes #20578 (cherry picked from commit 28afc13b179a7db0ed3ac121cba14529985ddf3c)
-rw-r--r--sql/updates/world/master/2020_11_06_02_world_2017_10_10_06_world_335.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_11_06_02_world_2017_10_10_06_world_335.sql b/sql/updates/world/master/2020_11_06_02_world_2017_10_10_06_world_335.sql
new file mode 100644
index 00000000000..3ef162f0ded
--- /dev/null
+++ b/sql/updates/world/master/2020_11_06_02_world_2017_10_10_06_world_335.sql
@@ -0,0 +1,9 @@
+-- Geologist Larksbane
+-- DELETE FROM `gossip_menu` WHERE `MenuID`=6532 AND `TextID`=7748;
+-- INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+-- (6532,7748,0);
+-- gossip_menu already exists in master
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`= 14 AND `SourceGroup`= 6532;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(14,6532,7748,0,0,28,0,8285,0,0,0,0,0,"","Show Gossip Menu Text 7748 if Quest 'The Deserter' is completed");