diff options
| -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'); |