aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorQAston <qaston@gmail.com>2012-02-16 13:16:43 +0100
committerQAston <qaston@gmail.com>2012-02-16 13:16:43 +0100
commite47ec04b4d58a4a080918aef57a35509ad69f0ca (patch)
treeb75a8dbfb8eadf584e8a958980ba6dfc231fa71e /sql
parentad6613261cb3a9561faf96a5bcbed72cedde2d16 (diff)
Core/Db/Conditions: Drop CONDITION_CREATURE_TARGET, CONDITION_TARGET_HEALTH_BELOW_PCT, CONDITION_TARGET_RANGE and 3rd parameter for CONDITION_AURA. Instead of those use other available conditions, which are not limited to player's selection only.
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2012_16_02_01_world_conditions.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/2012_16_02_01_world_conditions.sql b/sql/updates/world/2012_16_02_01_world_conditions.sql
new file mode 100644
index 00000000000..4bcf997b8e4
--- /dev/null
+++ b/sql/updates/world/2012_16_02_01_world_conditions.sql
@@ -0,0 +1,3 @@
+UPDATE `conditions` SET ConditionValue3 = 0, ConditionTarget = 1 WHERE ConditionTypeOrReference = 1 AND ConditionValue3 = 1;
+UPDATE `conditions` SET ConditionTypeOrReference = 31, ConditionValue2 = ConditionValue1, ConditionValue1 = 3, ConditionTarget = 1 WHERE ConditionTypeOrReference = 19;
+UPDATE `conditions` SET ConditionTypeOrReference = 38, ConditionValue2 = 4, ConditionTarget = 1 WHERE ConditionTypeOrReference = 20;