aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2025-04-12 14:06:36 +0200
committerGitHub <noreply@github.com>2025-04-12 14:06:36 +0200
commitd5110eed48a18f74eba98a5fb0c044e063f5d654 (patch)
treeba254999e676767b4768d75c7e43bf03403c7af2
parentba2760647572fd1f5c56ac91476cd89b560c83db (diff)
DB/Condition: Teldrassil, Arch Druid Fandral Staghelm gossip menu option
closes #30845 by Jonne733
-rw-r--r--sql/updates/world/3.3.5/2025_04_12_06_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2025_04_12_06_world.sql b/sql/updates/world/3.3.5/2025_04_12_06_world.sql
new file mode 100644
index 00000000000..8e99f2a70c6
--- /dev/null
+++ b/sql/updates/world/3.3.5/2025_04_12_06_world.sql
@@ -0,0 +1,5 @@
+-- Arch Druid Fandral Staghelm, gossip menu option requires the quest "Un' Goro Soil" rewarded and player to have herbalism skill below 75
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=1630;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(15,1630,0,0,1,8,0,3764,0,0,0,0,0,"","Gossip option 0 requires players have quest Un'Goro Soil rewarded AND"),
+(15,1630,0,0,1,7,0,182,75,0,1,0,0,"","Requires player skill in herbalism lower than 75");