From 30468a106feeeba17f5d33ab0275b579d178715e Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 13 Aug 2010 13:48:59 +0200 Subject: Moved battleground achievement scripted checks into scripts Call ACHIEVEMENT_CRITERIA_TYPE_SPECIAL_PVP_KILL updates in code Implemented achievements: Save the Day, Quick Cap, Warsong Expedience --HG-- branch : trunk --- sql/scripts/world_scripts_full.sql | 18 ++++++++++++++++-- 1 file changed, 16 insertions(+), 2 deletions(-) (limited to 'sql/scripts') diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index c782ef22f00..ca91bfdd43b 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1654,12 +1654,26 @@ 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) AND `type`=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) 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'), (6642,11,0,0, 'achievement_school_of_hard_knocks'), (6643,11,0,0, 'achievement_school_of_hard_knocks'), -(6644,11,0,0, 'achievement_school_of_hard_knocks'); +(6644,11,0,0, 'achievement_school_of_hard_knocks'), +(3804,11,0,0, 'achievement_resilient_victory'), +(3805,11,0,0, 'achievement_resilient_victory'), +(3806,11,0,0, 'achievement_resilient_victory'), +(3807,11,0,0, 'achievement_resilient_victory'), +(3808,11,0,0, 'achievement_resilient_victory'), +(3809,11,0,0, 'achievement_resilient_victory'), +(3810,11,0,0, 'achievement_resilient_victory'), +(3811,11,0,0, 'achievement_resilient_victory'), +(3812,11,0,0, 'achievement_resilient_victory'), +(3813,11,0,0, 'achievement_resilient_victory'), +(1234,11,0,0, 'achievement_bg_control_all_nodes'), +(1239,11,0,0, 'achievement_bg_control_all_nodes'), +(5605,11,0,0, 'achievement_save_the_day'), +(5606,11,0,0, 'achievement_save_the_day'); /* EOF */ -- cgit v1.2.3