From 35c238050af6af5c2681839606922c9b84b03ba0 Mon Sep 17 00:00:00 2001 From: Supabad Date: Sun, 17 Apr 2011 11:11:40 +0200 Subject: Scripts/Achievements: add multiple achievement scripts for Strand Of The Ancients. add kill counter reset related to Battleground achievements. --- sql/scripts/world_scripts_full.sql | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'sql/scripts') diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index aa9af08f23d..4fac2b8b212 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1781,7 +1781,7 @@ UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_si' WHERE `TypeId`=5; UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_ep' WHERE `TypeId`=6; /* ACHIEVEMENTS */ -DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3693,6641,6642,6643,6644,3804,3805,3806,3807,3808,3809,3810,3811,3812,3813,1234,1239,5605,5606,12778,13036,13035,13037,12977,12967,12986,12982,12993,12780,13012,13011,13013,12062,12063,12064,12065,12183,12068,12060,12061,12822,12996,12972,12989,10062,10063,10054,10055,10046,10047,10048,10049,10050,10051,10044,10045) AND `type` IN (0,11); +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3693,6641,6642,6643,6644,3804,3805,3806,3807,3808,3809,3810,3811,3812,3813,1234,1239,5605,5606,12778,13036,13035,13037,12977,12967,12986,12982,12993,12780,13012,13011,13013,12062,12063,12064,12065,12183,12068,12060,12061,12822,12996,12972,12989,10062,10063,10054,10055,10046,10047,10048,10049,10050,10051,10044,10045,6446,7625,7628) AND `type` IN (0,11); INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES (3693,11,0,0, 'achievement_storm_glory'), (6641,11,0,0, 'achievement_school_of_hard_knocks'), @@ -1838,8 +1838,10 @@ INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`, (10050,11,0,0, 'achievement_three_car_garage_siege'), (10051,11,0,0, 'achievement_three_car_garage_demolisher'), (10062,11,0,0, 'achievement_quick_shave'), -(10063,11,0,0, 'achievement_quick_shave'); - +(10063,11,0,0, 'achievement_quick_shave'), +(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'); /* SPELLS */ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -- generic -- cgit v1.2.3