aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-10-15 21:23:43 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-10-03 17:26:23 +0200
commit2e79e206af4d0a269936827cb7083f77320baead (patch)
tree23451b39e55518a5abc8a9f06c14f7bdb9d2895a /sql
parent5c7b821e17b6a51a5adf1f3180a3bea66b4c7602 (diff)
Script/Quest: Arelion's Mistress.
(cherry picked from commit 94c41c92b35e20c47462113ad88b3d382dd9c44d) Fix warning. Also, the quest's name is Arelion's Secret, not Arelion's Mistress. (cherry picked from commit 79acb9fa71bb3016f5aa8f92b257346ed6c17dd7)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2017_10_03_10_world_2016_10_15_10_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_10_03_10_world_2016_10_15_10_world.sql b/sql/updates/world/master/2017_10_03_10_world_2016_10_15_10_world.sql
new file mode 100644
index 00000000000..9c3be9d00df
--- /dev/null
+++ b/sql/updates/world/master/2017_10_03_10_world_2016_10_15_10_world.sql
@@ -0,0 +1,5 @@
+--
+UPDATE `conditions` SET `ConditionTypeOrReference`=28, `Comment`="Show gossip option 0 if player has quest Arelion's Secret completed OR" WHERE `SourceGroup`=8081 AND `ElseGroup`=0;
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8081 AND `ElseGroup`=1;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(15, 8081, 0, 0, 1, 8, 0, 10286, 0, 0, 0, 0, 0, "", "Show gossip option 0 if player has quest Arelion's Secret rewarded");