diff options
3 files changed, 9 insertions, 7 deletions
diff --git a/sql/updates/world/2011_04_17_00_world_achievement.sql b/sql/updates/world/2011_04_17_00_world_achievement.sql deleted file mode 100644 index e82c5772f90..00000000000 --- a/sql/updates/world/2011_04_17_00_world_achievement.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `disables` WHERE `sourceType` = 4 AND `entry` in (7625,6446,7628); -DELETE FROM `achievement_criteria_data` WHERE `criteria_id` in(6446,7625) AND `type`=11; -INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES -(6446,11,0,0,'achievement_bg_sa_drop_it'), -(7625,11,0,0,'achievement_bg_sa_artillery_veteran'), -(7628,11,0,0,'achievement_bg_sa_artillery_expert'), -(7628,3,607,0,''); diff --git a/sql/updates/world/2011_04_17_00_world_achievement_criteria_data.sql b/sql/updates/world/2011_04_17_00_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..d75764507e7 --- /dev/null +++ b/sql/updates/world/2011_04_17_00_world_achievement_criteria_data.sql @@ -0,0 +1,8 @@ +DELETE FROM `disables` WHERE `sourceType` = 4 AND `entry` IN (7625,6446,7628); +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (6446,7625) AND `type`=11; +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=7628 AND `type`!=0; +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES +(6446,11,0,0,'achievement_bg_sa_drop_it'), +(7625,11,0,0,'achievement_bg_sa_artillery_veteran'), +(7628,11,0,0,'achievement_bg_sa_artillery_expert'), +(7628,3,607,0,''); diff --git a/sql/updates/world/2011_04_17_02_world_achievement_criteria_data.sql b/sql/updates/world/2011_04_17_02_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..cc1580de2c2 --- /dev/null +++ b/sql/updates/world/2011_04_17_02_world_achievement_criteria_data.sql @@ -0,0 +1 @@ +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=7628 AND `type`=3; |