aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorSupabad <supabad.trinity@gmail.com>2011-04-21 23:38:15 +0200
committerSupabad <supabad.trinity@gmail.com>2011-04-21 23:38:15 +0200
commit3b99e173f0becba0979e78a50387a2bbf7941ba7 (patch)
tree71e09aff8b901df85021f226d654002ff47e6f78 /sql/updates
parent97f482cd825f57b6a39d9bc9ad6d5fef169cf909 (diff)
Scripts/Achievements: Move some achievement scripts to database.
Add database support for Ancient Protector and Ancient Courtyard Protector.
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2011_04_21_00_world_achievement.sql9
1 files changed, 9 insertions, 0 deletions
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');