diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2024-03-31 14:40:56 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-03-31 14:40:56 +0200 |
| commit | ab7c8ef50349fd13ad29c2edf2560a3b95d425d1 (patch) | |
| tree | 83e47d35aa3a6aedfb341c151bf59b471a49932f | |
| parent | 20f2f0aed9731d087c1f80d933cf8b18ac20e633 (diff) | |
DB/Gossip: Farstrider Solanna's gossip text
closes #29867 by Jonne733
| -rw-r--r-- | sql/updates/world/3.3.5/2024_03_31_06_world.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_03_31_06_world.sql b/sql/updates/world/3.3.5/2024_03_31_06_world.sql new file mode 100644 index 00000000000..540765bd573 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_03_31_06_world.sql @@ -0,0 +1,15 @@ +-- Farstrider Solanna's gossip menu text changes when the quest "Attack on Zeb'Tela" is active and changes again after it has been turned in. It allso changes when the quest "Assault on Zeb'Nowa" is rewarded +-- Gossip Menu +DELETE FROM `gossip_menu` WHERE `MenuID`=7253 AND `TextID` IN (8570,8571,8572); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(7253,8570,0), +(7253,8571,0), +(7253,8572,0); + +-- Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=7253; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14,7253,8569,0,0,47,0,9276,10,0,1,0,0,"","Show gossip dialog text 8569 if quest 'Attack on Zeb'Tela' (9276) is NOT taken"), +(14,7253,8570,0,0,47,0,9276,10,0,0,0,0,"","Show gossip dialog text 8570 if quest 'Attack on Zeb'Tela' (9276) is taken (active)"), +(14,7253,8571,0,0,8,0,9276,0,0,0,0,0,"","Gossip text 8571 requires quest 'Attack on Zeb'Tela' (9276) rewarded"), +(14,7253,8572,0,0,8,0,9277,0,0,0,0,0,"","Gossip text 8572 requires quest 'Attack on Zeb'Nowa' (9277) rewarded"); |