diff options
| author | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-03-21 21:54:46 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-03-21 21:54:46 +0100 |
| commit | dde6f2703a208a13fc0feed390db3fdfdc18559c (patch) | |
| tree | 64ca95124bf4b888ecea34d3d63776feab2c3830 | |
| parent | 15f7697284197f8cf3a7f06736a2fa7d833b048f (diff) | |
DB/Achievement: Trial of Crusader Criteria updated
| -rw-r--r-- | sql/updates/world/2011_03_21_3_world_achievement_criteria_data.sql | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/sql/updates/world/2011_03_21_3_world_achievement_criteria_data.sql b/sql/updates/world/2011_03_21_3_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..942207d6d9d --- /dev/null +++ b/sql/updates/world/2011_03_21_3_world_achievement_criteria_data.sql @@ -0,0 +1,32 @@ +-- Fix Achievements related to Trial of the Crusader +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN ( +11684,11685,11686,11687,11688, -- 10 Player +11679,11680,11681,11682,11683, -- 25 Player +11689,11690,11691,11692,11693, -- 10 Player +11542,11546,11547,11549,11678 -- 25 Player +) AND `type` IN (0,12); +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +-- Call of the Crusade (10 player) +(11684,12,0,0, ''), +(11685,12,0,0, ''), +(11686,12,0,0, ''), +(11687,12,0,0, ''), +(11688,12,0,0, ''); +-- Call of the Crusade (25 player) +(11679,12,1,0, ''), +(11680,12,1,0, ''), +(11681,12,1,0, ''), +(11682,12,1,0, ''), +(11683,12,1,0, ''); +-- Call of the Grand Crusade (10 player) +(11689,12,2,0, ''), +(11690,12,2,0, ''), +(11691,12,2,0, ''), +(11692,12,2,0, ''), +(11693,12,2,0, ''); +-- Call of the Grand Crusade (25 player) +(11542,12,3,0, ''), +(11546,12,3,0, ''), +(11547,12,3,0, ''), +(11549,12,3,0, ''), +(11678,12,3,0, ''); |