Core/Achievements: fix City Defender kill credit bugs

1 files changed, 23 insertions, 0 deletions

diff --git a/sql/updates/world/2011_06_02_01_world_achievement_criteria_data.sql b/sql/updates/world/2011_06_02_01_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..d98174cb07d
--- /dev/null
+++ b/sql/updates/world/2011_06_02_01_world_achievement_criteria_data.sql
@@ -0,0 +1,23 @@
+DELETE FROM `achievement_criteria_data` WHERE `type` = 6 AND `criteria_id` IN
+(5020,5021,5022,5023,5024,5025,5026,5027,5028,5029,5030,5031,5032,5033,5034,5035,5036,5037,5038,5039);
+INSERT INTO `achievement_criteria_data` values
+(5020,6,1519,0,''),
+(5021,6,1537,0,''),
+(5022,6,1657,0,''),
+(5023,6,1658,0,''),
+(5024,6,1659,0,''),
+(5025,6,1661,0,''),
+(5026,6,1662,0,''),
+(5027,6,1660,0,''),
+(5028,6,3557,0,''),
+(5029,6,1617,0,''),
+(5030,6,4411,0,''),
+(5031,6,1637,0,''),
+(5032,6,3487,0,''),
+(5033,6,3704,0,''),
+(5034,6,1638,0,''),
+(5035,6,1639,0,''),
+(5036,6,1641,0,''),
+(5037,6,1640,0,''),
+(5038,6,2197,0,''),
+(5039,6,1497,0,'');