From 80006a275f890be065f69a1696fa265bc5f54af2 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sat, 15 Sep 2012 20:45:51 +0200 Subject: SQL: Rename SQL --- sql/updates/world/2012_09_15_00_achievement_criteria_data.sql | 6 ------ sql/updates/world/2012_09_15_00_disables.sql | 4 ---- sql/updates/world/2012_09_15_00_world_achievement_criteria_data.sql | 6 ++++++ sql/updates/world/2012_09_15_00_world_disables.sql | 4 ++++ 4 files changed, 10 insertions(+), 10 deletions(-) delete mode 100644 sql/updates/world/2012_09_15_00_achievement_criteria_data.sql delete mode 100644 sql/updates/world/2012_09_15_00_disables.sql create mode 100644 sql/updates/world/2012_09_15_00_world_achievement_criteria_data.sql create mode 100644 sql/updates/world/2012_09_15_00_world_disables.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 deleted file mode 100644 index a30eff7024e..00000000000 --- a/sql/updates/world/2012_09_15_00_achievement_criteria_data.sql +++ /dev/null @@ -1,6 +0,0 @@ --- 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 deleted file mode 100644 index 371315b5be7..00000000000 --- a/sql/updates/world/2012_09_15_00_disables.sql +++ /dev/null @@ -1,4 +0,0 @@ --- 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 diff --git a/sql/updates/world/2012_09_15_00_world_achievement_criteria_data.sql b/sql/updates/world/2012_09_15_00_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..a30eff7024e --- /dev/null +++ b/sql/updates/world/2012_09_15_00_world_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_world_disables.sql b/sql/updates/world/2012_09_15_00_world_disables.sql new file mode 100644 index 00000000000..371315b5be7 --- /dev/null +++ b/sql/updates/world/2012_09_15_00_world_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