Scripts/Achievements: add multiple achievement scripts for Strand Of The Ancients.

add kill counter reset related to Battleground achievements.

1 files changed, 7 insertions, 0 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
new file mode 100644
index 00000000000..e82c5772f90
--- /dev/null
+++ b/sql/updates/world/2011_04_17_00_world_achievement.sql
@@ -0,0 +1,7 @@
+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,'');