diff options
| author | Spp <spp@jorge.gr> | 2010-08-10 10:00:57 +0200 |
|---|---|---|
| committer | Spp <spp@jorge.gr> | 2010-08-10 10:00:57 +0200 |
| commit | 719f770a563b07cbf56984d644b9d40ea540da89 (patch) | |
| tree | 06b9afc13eafea97101bbaee4b61206935151200 | |
| parent | edf9fe17d2fcd0bd39a58507d3a5fc948d13c8e4 (diff) | |
*Fix typo in 9240 sql file
*Fix typo in my previous commit
Note to self: next time review the changes, not just C&P the delete from 9240*.sql
--HG--
branch : trunk
| -rw-r--r-- | sql/scripts/world_scripts_full.sql | 2 | ||||
| -rw-r--r-- | sql/updates/9240_world_achievement_criteria_data.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index 3c8c29ece37..c782ef22f00 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1654,7 +1654,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 `entry` IN (3693,6641,6642,6643,6644) AND `type`=11; +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` 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'), diff --git a/sql/updates/9240_world_achievement_criteria_data.sql b/sql/updates/9240_world_achievement_criteria_data.sql index 0102c70db86..f5d8eda4613 100644 --- a/sql/updates/9240_world_achievement_criteria_data.sql +++ b/sql/updates/9240_world_achievement_criteria_data.sql @@ -1,4 +1,4 @@ -DELETE FROM `achievement_criteria_data` WHERE `entry` IN (3693,6641,6642,6643,6644) AND `type`=11; +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` 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'), |