aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorjoschiwald <joschiwald@online.de>2013-08-28 18:59:27 +0200
committerjoschiwald <joschiwald@online.de>2013-08-28 18:59:27 +0200
commit4fc292cee843d56c5f40664210c443ad0f60206c (patch)
tree0101eac6d5f5d43e77206e736228013aaf7ef2ed
parent5eeed14c2ce04931fc1c5691ff34b65a82e40c25 (diff)
DB/Conditions: fix startup error
-rw-r--r--sql/updates/world/2013_08_28_04_world_conditions.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2013_08_28_04_world_conditions.sql b/sql/updates/world/2013_08_28_04_world_conditions.sql
new file mode 100644
index 00000000000..b164b4f0dd1
--- /dev/null
+++ b/sql/updates/world/2013_08_28_04_world_conditions.sql
@@ -0,0 +1,4 @@
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceGroup` IN (23980,31674,23954,31673);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(1,23954,43228,0,0,1,0,57940,0,0,0,0,0,'','Can loot Stone Keeper''s Shard only with aura Essence of Wintergrasp'),
+(1,31673,43228,0,0,1,0,57940,0,0,0,0,0,'','Can loot Stone Keeper''s Shard only with aura Essence of Wintergrasp');