aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMachiavelli <machiavelli.trinity@gmail.com>2012-03-01 00:42:18 +0100
committerMachiavelli <machiavelli.trinity@gmail.com>2012-03-01 00:42:18 +0100
commitb9b8f27e455ec91aaf842e2ebdfc972f0b230ccc (patch)
treeceee29ad8ba78813a1e03b35dd057448bbd3c074
parente3e958e293b7b7b27b187dfd9d417897c408f19d (diff)
DB/Conditions: *Proper* conditions for The Scarlet Harvest. Saving the file before committing works.
-rw-r--r--sql/updates/world/2012_02_29_02_world_conditions.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2012_02_29_02_world_conditions.sql b/sql/updates/world/2012_02_29_02_world_conditions.sql
new file mode 100644
index 00000000000..a28e6d6424f
--- /dev/null
+++ b/sql/updates/world/2012_02_29_02_world_conditions.sql
@@ -0,0 +1,5 @@
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceGroup`=29488 AND `SourceEntry`=54568;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,
+`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`Comment`) VALUES
+(18,29488,54568,1,8,0,12670,0,0,0,'Required quest rewarded for spellclick'),
+(18,29488,54568,2,9,0,12670,0,0,0,'Required quest active for spellclick');