diff options
| author | Shauren <shauren.trinity@gmail.com> | 2011-04-17 14:55:32 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2011-04-17 14:55:32 +0200 |
| commit | 19721514c3899153f6c58b234b4ba8e85d906b05 (patch) | |
| tree | c574dc7cfc1f208f8a0e0ba5f940bf45324f226a | |
| parent | 472027c3e0ec8b4741a3e70d2df8765c9fd37d91 (diff) | |
DB/Achievements: Fixed startup erros and rerunning possibility for previous achievement sql
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; |