aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorLopin <davca.hr@seznam.cz>2011-06-24 22:03:14 +0200
committerLopin <davca.hr@seznam.cz>2011-06-24 22:03:14 +0200
commit29cacd96b2968d43f9bc6b27615377f2f848f2b9 (patch)
tree544f359aff5808e2b2945e8d59f5533725fc5eab /sql
parent9c70f586e0a30a57c78bd62929b807e8fd222a8a (diff)
Scripts/Halls Of Stone: Properly fixed achievement Brann Sparklin' News
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2011_06_24_07_world_achievement_criteria_data.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2011_06_24_07_world_achievement_criteria_data.sql b/sql/updates/world/2011_06_24_07_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..e228625014e
--- /dev/null
+++ b/sql/updates/world/2011_06_24_07_world_achievement_criteria_data.sql
@@ -0,0 +1,9 @@
+DELETE FROM `spell_dbc` WHERE `id`=59046;
+INSERT INTO `spell_dbc` (`Id`,`Effect1`,`EffectRadiusIndex1`,`EffectImplicitTargetA1`,`EffectImplicitTargetB1`,`comment`)
+VALUES
+(59046,3,28,22,30,'Tribunal of Ages - Criteria Marker');
+
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=7590 AND `type`=11;
+INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`)
+VALUES
+(7590,11,0,0,'achievement_brann_sparklin_news');