diff options
| author | Shauren <none@none> | 2010-08-09 22:08:03 +0200 |
|---|---|---|
| committer | Shauren <none@none> | 2010-08-09 22:08:03 +0200 |
| commit | 5709c8be0d88a134a25ca28d1cc77203d7666799 (patch) | |
| tree | 1624f43a9d8da710fbb90b8493ccfb0b5bd8aefb | |
| parent | 4b5c9552cb42064b037799ddf8c248e495dab166 (diff) | |
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
| -rw-r--r-- | sql/scripts/world_scripts_full.sql | 9 | ||||
| -rw-r--r-- | sql/updates/9240_world_achievement_criteria_data.sql | 9 |
2 files changed, 14 insertions, 4 deletions
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'); |