DB/Gossip: Arcanist Vandril's gossip text

closes #29873 by Jonne733

1 files changed, 16 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2024_04_01_02_world.sql b/sql/updates/world/3.3.5/2024_04_01_02_world.sql
new file mode 100644
index 00000000000..7afc9ae4c19
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_04_01_02_world.sql
@@ -0,0 +1,16 @@
+-- Arcanist Vandril gossip menu changes when quest "Delivery to Tranquillien" is active, when "Suncrown Village" is active, when Goldenmist Village is active and when "Windrunner Village" is active and after it is completed.
+-- Gossip Menu
+DELETE FROM `gossip_menu` WHERE `MenuID`=7153 AND `TextID` IN (8561,8425,8426);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(7153,8425,0),
+(7153,8426,0),
+(7153,8561,0);
+
+-- Conditions
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=7153;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(14,7153,8561,0,0,47,0,9148,10,0,0,0,0,"","Show gossip dialog text 8561 if Quest 'Delivery to Tranquillien' is taken (active)"),
+(14,7153,8426,0,0,8,0,9140,0,0,0,0,0,"","Gossip text 8226 requires quest 'Windrunner Village' rewarded"),
+(14,7153,8425,0,0,47,0,9138,10,0,0,0,0,"","Show gossip dialog text 8425 if Quest 'Suncrown Village' is taken (active)"),
+(14,7153,8425,0,1,47,0,9139,10,0,0,0,0,"","Show gossip dialog text 8425 if Quest 'Goldenmist Village' is taken (active)"),
+(14,7153,8425,0,2,47,0,9140,10,0,0,0,0,"","Show gossip dialog text 8425 if Quest 'Windrunner Village' is taken (active)");