From d07a0769971c8b5d5d695ed31b973bafc2b9688d Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 4 Apr 2024 19:10:13 +0200 Subject: DB/Gossip: Ambassador Dawnsinger's gossip text closes #29888 by Jonne733 --- sql/updates/world/3.3.5/2024_04_04_00_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/3.3.5/2024_04_04_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2024_04_04_00_world.sql b/sql/updates/world/3.3.5/2024_04_04_00_world.sql new file mode 100644 index 00000000000..601a5b656ae --- /dev/null +++ b/sql/updates/world/3.3.5/2024_04_04_00_world.sql @@ -0,0 +1,10 @@ +-- Ambassador Dawnsinger's gossip text should be different if player is blood elf. +-- Gossip Menu +DELETE FROM `gossip_menu` WHERE `MenuID`=7359 AND `TextID`=8791; +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(7359,8791,0); + +-- Condition +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=7359; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14,7359,8791,0,0,16,0,512,0,0,0,0,0,"","Show gossip text 8791 if player is a blood elf"); -- cgit v1.2.3