From 24a8cc24da62e2a5712fbfc2da48ca036cfb0707 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 14 May 2011 12:26:49 +0200 Subject: Core/Achievements: Implemented ACHIEVEMENT_CRITERIA_TYPE_GET_KILLING_BLOWS --- sql/scripts/world_scripts_full.sql | 10 ++++- ...011_05_14_00_world_achievment_criteria_data.sql | 49 ++++++++++++++++++++++ 2 files changed, 57 insertions(+), 2 deletions(-) create mode 100644 sql/updates/world/2011_05_14_00_world_achievment_criteria_data.sql (limited to 'sql') diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index 09d3001aa93..6e8e2d4a36e 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1790,7 +1790,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,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); +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3693,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,5541,5542,5543,7573,7574) AND `type` IN (0,11); INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES (3693,11,0,0, 'achievement_storm_glory'), (3804,11,0,0, 'achievement_resilient_victory'), @@ -1845,7 +1845,13 @@ INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`, (10062,11,0,0, 'achievement_quick_shave'), (10063,11,0,0, 'achievement_quick_shave'), (7625,11,0,0, 'achievement_bg_sa_artillery'), -(7628,11,0,0, 'achievement_bg_sa_artillery'); +(7628,11,0,0, 'achievement_bg_sa_artillery'), +(5541,11,0,0,'achievement_arena_2v2_kills'), +(5542,11,0,0,'achievement_arena_3v3_kills'), +(5543,11,0,0,'achievement_arena_5v5_kills'), +(7573,11,0,0,'achievement_denyin_the_scion'), +(7574,11,0,0,'achievement_denyin_the_scion'); + /* SPELLS */ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -- generic diff --git a/sql/updates/world/2011_05_14_00_world_achievment_criteria_data.sql b/sql/updates/world/2011_05_14_00_world_achievment_criteria_data.sql new file mode 100644 index 00000000000..fb5c609aca4 --- /dev/null +++ b/sql/updates/world/2011_05_14_00_world_achievment_criteria_data.sql @@ -0,0 +1,49 @@ +DELETE FROM `disables` WHERE `entry` IN (3368,3369,3370,3371,7623,12578,3684,5529,5512,5530,5531,5532,5533,5534,5535,9165,9166,5536,5537,5538,5539,5540,13254,5541,5542,5543,5544,5545,5546,5547,5548,7573,7574,10619,10620,11497,11498,11500,11501,12178,12179,12181,12182,13255) AND `sourceType`=4; +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3368,3369,3370,3371,7623,12578,3684,5529,5512,5530,5531,5532,5533,5534,5535,9165,9166,5536,5537,5538,5539,5540,13254,5541,5542,5543,5544,5545,5546,5547,5548,7573,7574,10619,10620,11497,11498,11500,11501,12178,12179,12181,12182,13255); +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES +(3368,0,0,0,''), -- Alterac Valley +(3369,0,0,0,''), -- Arathi Basin +(3370,0,0,0,''), -- Eye of the Storm +(3371,0,0,0,''), -- Warsong Gulch +(7623,0,0,0,''), -- Strand of the Ancients +(12578,0,0,0,''), -- Isle of Conquest +(3684,7,23505,0,''), -- Berserking killing blow +(5529,0,0,0,''), -- Total Killing Blows +(5512,20,0,0,''), -- Eastern Kingdoms +(5530,20,1,0,''), -- Kalimdor +(5531,20,530,0,''), -- Burning Crusade Areas +(5532,20,571,0,''), -- Northrend +(5533,20,559,0,''), -- Nagrand Arena +(5534,20,562,0,''), -- Blade's Edge Arena +(5535,20,572,0,''), -- Ruind of Lordaeron +(9165,20,617,0,''), -- Dalaran Sewers +(9166,20,618,0,''), -- Ring of Valor +(5536,20,30,0,''), -- Alterac Valley +(5537,20,529,0,''), -- Arathi Basin +(5538,20,489,0,''), -- Warsong Gulch +(5539,20,566,0,''), -- Eye of the Storm +(5540,20,607,0,''), -- Strand of the Ancients +(13254,20,628,0,''), -- Isle of Conquest +(5541,11,0,0,'achievement_arena_2v2_kills'), -- 2v2 Arena Killing Blows +(5542,11,0,0,'achievement_arena_3v3_kills'), -- 3v3 Arena Killing Blows +(5543,11,0,0,'achievement_arena_5v5_kills'), -- 5v5 Arena Killing Blows +(5544,20,30,0,''), -- Alterac Valley Killing Blows +(5545,20,529,0,''), -- Arathi Basin Killing Blows +(5546,20,489,0,''), -- Warsong Gulch Killing Blows +(5547,20,566,0,''), -- Eye of the Storm Killing Blows +(5548,20,607,0,''), -- Strand of the Ancients Killing Blows +(7573,1,30249,0,''), -- Deliver a killing blow to a Scion of Eternity while riding on a hover disk +(7573,11,0,0,'achievement_denyin_the_scion'), -- Deliver a killing blow to a Scion of Eternity while riding on a hover disk +(7574,1,30249,0,''), -- Deliver a killing blow to a Scion of Eternity while riding on a hover disk +(7574,11,0,0,'achievement_denyin_the_scion'), -- Deliver a killing blow to a Scion of Eternity while riding on a hover disk +(10619,1,33142,0,''), -- Leviathan Turret +(10620,1,33142,0,''), -- Leviathan Turret +(11497,1,35273,0,''), -- Glaive Thrower +(11498,1,34775,0,''), -- Demolisher +(11500,1,34793,0,''), -- Catapult +(11501,1,35069,0,''), -- Siege Engine +(12178,1,34802,0,''), -- Glaive Thrower +(12179,1,34775,0,''), -- Demolisher +(12181,1,34793,0,''), -- Catapult +(12182,1,34776,0,''), -- Siege Engine +(13255,20,628,0,''); -- Isle of Conquest Killing Blows -- cgit v1.2.3