From 3b99e173f0becba0979e78a50387a2bbf7941ba7 Mon Sep 17 00:00:00 2001 From: Supabad Date: Thu, 21 Apr 2011 23:38:15 +0200 Subject: Scripts/Achievements: Move some achievement scripts to database. Add database support for Ancient Protector and Ancient Courtyard Protector. --- sql/scripts/world_scripts_full.sql | 5 ++--- sql/updates/world/2011_04_21_00_world_achievement.sql | 9 +++++++++ 2 files changed, 11 insertions(+), 3 deletions(-) create mode 100644 sql/updates/world/2011_04_21_00_world_achievement.sql (limited to 'sql') 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'); -- cgit v1.2.3