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/updates/world/2011_04_21_00_world_achievement.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/2011_04_21_00_world_achievement.sql (limited to 'sql/updates') 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