aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2024-02-24 16:32:15 +0100
committerGitHub <noreply@github.com>2024-02-24 16:32:15 +0100
commite28c2b2844434d60d88afaeb27ae76704fd61eb9 (patch)
treef36761bc1e1b31c2a09a96b114b5f1f96387e7eb
parentfc03a92f9575228bfb26f90b497e4d4c21f53b1f (diff)
DB/Conditions: King Varian Wrynn gossip menu text
closes #29316 by Jonne733
-rw-r--r--sql/updates/world/3.3.5/2024_02_24_05_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_02_24_05_world.sql b/sql/updates/world/3.3.5/2024_02_24_05_world.sql
new file mode 100644
index 00000000000..dffe8e4d6fb
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_02_24_05_world.sql
@@ -0,0 +1,10 @@
+-- King Varian Wrynn gossip menu changes when quest "Where Kings Walk" (13188) is active
+-- Gossip Menu
+DELETE FROM `gossip_menu` WHERE `MenuID`=9834 AND `TextID`=13905;
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(9834,13905,0);
+
+-- Condition
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9834;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(14,9834,13905,0,0,47,0,13188,10,0,0,0,0,"","Show gossip dialog text 13905 if Quest 'Where Kings Walk' is taken (active)");