diff options
| author | thesensei <aconstantgoal@abv.bg> | 2012-09-15 17:31:57 +0300 |
|---|---|---|
| committer | thesensei <aconstantgoal@abv.bg> | 2012-09-15 17:31:57 +0300 |
| commit | 548a4877215c71b201229a5718577706f7eb7e4d (patch) | |
| tree | 3c3201fa9a47e5070fcc0f716e9b0fb26890c25d /sql/updates | |
| parent | 01139ecd38da6ab11caf017e874d5bea9f45e3f6 (diff) | |
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.
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2012_09_15_00_achievement_criteria_data.sql | 6 | ||||
| -rw-r--r-- | sql/updates/world/2012_09_15_00_disables.sql | 4 |
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 |