diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/scripts/world_scripts_full.sql | 5 | ||||
| -rw-r--r-- | sql/updates/world/2011_04_21_00_world_achievement.sql | 9 |
2 files changed, 11 insertions, 3 deletions
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index ed801b2a860..408474bd0f7 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1839,9 +1839,8 @@ INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`, (10051,11,0,0, 'achievement_three_car_garage_demolisher'), (10062,11,0,0, 'achievement_quick_shave'), (10063,11,0,0, 'achievement_quick_shave'), -(6446,11,0,0, 'achievement_bg_sa_drop_it'), -(7625,11,0,0, 'achievement_bg_sa_artillery_veteran'), -(7628,11,0,0, 'achievement_bg_sa_artillery_expert'); +(7625,11,0,0, 'achievement_bg_sa_artillery'), +(7628,11,0,0, 'achievement_bg_sa_artillery'); /* SPELLS */ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -- generic diff --git a/sql/updates/world/2011_04_21_00_world_achievement.sql b/sql/updates/world/2011_04_21_00_world_achievement.sql new file mode 100644 index 00000000000..3a3892c279e --- /dev/null +++ b/sql/updates/world/2011_04_21_00_world_achievement.sql @@ -0,0 +1,9 @@ +DELETE FROM `disables`WHERE `entry` IN(7631,7630,7629,6446,7625,7628,7626); +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN(7631,7630,7629,6446,7625,7628,7626); +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(7631,6,4609,0, ''), +(7630,6,4609,0, ''), +(7629,7,52418,0, ''), +(6446,7,52418,0, ''), +(7625,11,0,0, 'achievement_bg_sa_artillery'), +(7628,11,0,0, 'achievement_bg_sa_artillery'); |