aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZenoX92 <ZenoX92@users.noreply.github.com>2017-10-10 18:03:39 +0200
committerKillyana <morphone1@gmail.com>2017-10-10 18:03:39 +0200
commit28afc13b179a7db0ed3ac121cba14529985ddf3c (patch)
tree7ab2974cfddce69c849aefb0e747dcbe0d7cefa1
parent8e935aa2c03924856919a354684ed8774d04b845 (diff)
DB/Gossip: Geologist Larksbane
Closes #20578
-rw-r--r--sql/updates/world/3.3.5/2017_10_10_06_world_335.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_10_10_06_world_335.sql b/sql/updates/world/3.3.5/2017_10_10_06_world_335.sql
new file mode 100644
index 00000000000..472a745839d
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_10_10_06_world_335.sql
@@ -0,0 +1,8 @@
+-- Geologist Larksbane
+DELETE FROM `gossip_menu` WHERE `MenuID`=6532 AND `TextID`=7748;
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(6532,7748,0);
+
+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");