aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorNay <dnpd.dd@gmail.com>2012-09-15 07:44:49 -0700
committerNay <dnpd.dd@gmail.com>2012-09-15 07:44:49 -0700
commit7b3ea36c8c9973f8fffd9896661d4b16795cb375 (patch)
tree91f6fccd8b5674110b74fd0113e819a86aab371d /sql
parent0b2fb4a5a8e2ace8045d77165a987161d4903e53 (diff)
parent548a4877215c71b201229a5718577706f7eb7e4d (diff)
Merge pull request #7777 from Trista/master
Scripts/Oculus: Support for achievements Ruby, Emerald and Amber Void
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2012_09_15_00_achievement_criteria_data.sql6
-rw-r--r--sql/updates/world/2012_09_15_00_disables.sql4
2 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2012_09_15_00_achievement_criteria_data.sql b/sql/updates/world/2012_09_15_00_achievement_criteria_data.sql
new file mode 100644
index 00000000000..a30eff7024e
--- /dev/null
+++ b/sql/updates/world/2012_09_15_00_achievement_criteria_data.sql
@@ -0,0 +1,6 @@
+-- Insert achievement instance criteria data scripts
+DELETE FROM `achievement_criteria_data` WHERE `type`=11 and `criteria_id` IN (7323,7324,7325);
+INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES
+(7323,11,0,0,'achievement_ruby_void'),
+(7324,11,0,0,'achievement_emerald_void'),
+(7325,11,0,0,'achievement_amber_void');
diff --git a/sql/updates/world/2012_09_15_00_disables.sql b/sql/updates/world/2012_09_15_00_disables.sql
new file mode 100644
index 00000000000..371315b5be7
--- /dev/null
+++ b/sql/updates/world/2012_09_15_00_disables.sql
@@ -0,0 +1,4 @@
+-- Remove achievements from disables
+DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=7323; -- Ruby Void
+DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=7324; -- Emerald Void
+DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=7325; -- Amber Void