aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2024-03-29 19:02:27 +0100
committerGitHub <noreply@github.com>2024-03-29 19:02:27 +0100
commitf12d18a06f28e03daf7c4f18db0d1a51b730288f (patch)
treec1ae7ba14a2c4106d7177b517a2ebf43facb3921
parentf4f0925e7e47cfc4f754e30f5e064c1de6eb9e30 (diff)
DB/Gossip: Vindicator Aesom gossip text
closes #29841 by Jonne733
-rw-r--r--sql/updates/world/3.3.5/2024_03_29_05_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_03_29_05_world.sql b/sql/updates/world/3.3.5/2024_03_29_05_world.sql
new file mode 100644
index 00000000000..cc5af925dcc
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_03_29_05_world.sql
@@ -0,0 +1,10 @@
+-- Vindicator Aesom gossip menu text changes after turning in quest "The Sun Gate"
+-- Gossip menu
+DELETE FROM `gossip_menu` WHERE `MenuID`=7517 AND `TextID`=9130;
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(7517,9130,0);
+
+-- Condition
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=7517;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(14,7517,9130,0,0,8,0,9740,0,0,0,0,0,"","Gossip text 9130 requires quest The Sun Gate (9740) rewarded");