aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorLopin <davca.hr@seznam.cz>2011-06-22 18:30:50 +0200
committerLopin <davca.hr@seznam.cz>2011-06-22 18:30:50 +0200
commit5bf8102b9ca967c06d7b2eba6dd14d7a1511cc74 (patch)
tree93cfd39b6b39a6c4c14b05f0d88d765033ab1fd1 /sql/updates
parent9b17b9c3baac9e8eed9b5d0775c8609aedfbf614 (diff)
Scripts/Ulduar: Fixed achievements Knock on Wood & Knock, Knock on Wood & Knock, Knock, Knock on Wood in Freya's encounter
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2011_06_22_02_world_achievement_criteria_data.sql20
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/2011_06_22_02_world_achievement_criteria_data.sql b/sql/updates/world/2011_06_22_02_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..9834ca79932
--- /dev/null
+++ b/sql/updates/world/2011_06_22_02_world_achievement_criteria_data.sql
@@ -0,0 +1,20 @@
+DELETE FROM `spell_dbc` WHERE `id`=65074;
+INSERT INTO `spell_dbc` (`Id`,`Effect1`,`EffectRadiusIndex1`,`EffectImplicitTargetA1`,`EffectImplicitTargetB1`,`comment`)
+VALUES
+(65074,3,28,22,30,'Knock on Wood Achievements - Criteria Marker');
+
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (10447,10448,10449,10459,10460,10461);
+INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`)
+VALUES
+(10447,11,0,0,'achievement_knock_on_wood'),
+(10447,12,0,0,''),
+(10448,11,0,0,'achievement_knock_knock_on_wood'),
+(10448,12,0,0,''),
+(10449,11,0,0,'achievement_knock_knock_knock_on_wood'),
+(10449,12,0,0,''),
+(10459,11,0,0,'achievement_knock_on_wood'),
+(10459,12,1,0,''),
+(10460,11,0,0,'achievement_knock_knock_on_wood'),
+(10460,12,1,0,''),
+(10461,11,0,0,'achievement_knock_knock_knock_on_wood'),
+(10461,12,1,0,'');