From 5709c8be0d88a134a25ca28d1cc77203d7666799 Mon Sep 17 00:00:00 2001 From: Shauren Date: Mon, 9 Aug 2010 22:08:03 +0200 Subject: achievement_criteria_data data type 11 is now handled by core team (as its purpose is scriptname only) Reimporting of SQL is not needed --HG-- branch : trunk --- sql/scripts/world_scripts_full.sql | 9 +++++++-- sql/updates/9240_world_achievement_criteria_data.sql | 9 +++++++-- 2 files changed, 14 insertions(+), 4 deletions(-) (limited to 'sql') diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index 12cdba24a79..d57ef5f6cdd 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1654,7 +1654,12 @@ UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_si' WHERE `TypeId`=5; UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_ep' WHERE `TypeId`=6; /* ACHIEVEMENTS */ -UPDATE `achievement_criteria_data` SET `ScriptName`='achievement_school_of_hard_knocks' WHERE `criteria_id` IN (6641,6642,6643,6644); -UPDATE `achievement_criteria_data` SET `ScriptName`='achievement_storm_glory' WHERE `criteria_id`=3693; +DELETE FROM `type`=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'); /* EOF */ diff --git a/sql/updates/9240_world_achievement_criteria_data.sql b/sql/updates/9240_world_achievement_criteria_data.sql index 0c8ab862b8b..0102c70db86 100644 --- a/sql/updates/9240_world_achievement_criteria_data.sql +++ b/sql/updates/9240_world_achievement_criteria_data.sql @@ -1,2 +1,7 @@ -UPDATE `achievement_criteria_data` SET `ScriptName`='achievement_school_of_hard_knocks' WHERE `criteria_id` IN (6641,6642,6643,6644) AND `type`=11; -UPDATE `achievement_criteria_data` SET `ScriptName`='achievement_storm_glory' WHERE `criteria_id`=3693 AND `type`=11; +DELETE FROM `achievement_criteria_data` WHERE `entry` IN (3693,6641,6642,6643,6644) AND `type`=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'); -- cgit v1.2.3