aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMachiavelli <machiaveltman@gmail.com>2011-12-13 04:18:19 -0800
committerMachiavelli <machiaveltman@gmail.com>2011-12-13 04:18:19 -0800
commit99c0a7c970d476193cf0ed6890de12c75c97556b (patch)
tree7877a949c13f3119044d86615eeca2637840189e
parent31ce840444ef4900ea2c93613b734dd28498258e (diff)
parent1e75e53cef6e5bd467b74819734775c757b7f1b8 (diff)
Merge pull request #4305 from w1sht0l1v3/master
DB/Achievements: adding criteria data for Experienced Drake Rider
-rw-r--r--sql/updates/world/2011_12_13_01_world_achievement_criteria_data.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/2011_12_13_01_world_achievement_criteria_data.sql b/sql/updates/world/2011_12_13_01_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..4f32a915234
--- /dev/null
+++ b/sql/updates/world/2011_12_13_01_world_achievement_criteria_data.sql
@@ -0,0 +1,12 @@
+-- Experienced Drake Rider Achiev
+
+DELETE FROM `disables` WHERE `entry` IN (7177,7178,7179);
+
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (7177,7178,7179);
+INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES
+(7177,5,49460,1,''), -- Amber Drake
+(7177,12,1,0, ''), -- hc mode only
+(7178,5,49346,1,''), -- Emerald Drake
+(7178,12,1,0, ''), -- hc mode only
+(7179,5,49464,1,''); -- Ruby Drake
+(7179,12,1,0, ''); -- hc mode only \ No newline at end of file