From 548a4877215c71b201229a5718577706f7eb7e4d Mon Sep 17 00:00:00 2001 From: thesensei Date: Sat, 15 Sep 2012 17:31:57 +0300 Subject: Scripts/Oculus: Support for achievements Ruby, Emerald and Amber Void * Add instance achievement criteria scripts and remove from disables. Based on retail data. * A lot more compact style and specify only for heroic, thanks to Vincent-Michael. Tested. This involves everything needed by the achievement, however the dungeon still needs majour fixes/rewrite. --- sql/updates/world/2012_09_15_00_achievement_criteria_data.sql | 6 ++++++ sql/updates/world/2012_09_15_00_disables.sql | 4 ++++ 2 files changed, 10 insertions(+) create mode 100644 sql/updates/world/2012_09_15_00_achievement_criteria_data.sql create mode 100644 sql/updates/world/2012_09_15_00_disables.sql (limited to 'sql') 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 -- cgit v1.2.3