aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorLopin <davca.hr@seznam.cz>2011-06-25 16:40:10 +0200
committerLopin <davca.hr@seznam.cz>2011-06-25 16:40:10 +0200
commit6fd2bc4f288817c128f9bf09bfed9fc42eb26bf2 (patch)
tree6ca2f0102b46afb34ca85bbaa72d187c59a9f3a1 /sql/updates
parent88e53f978ec7b2daf648811e4bb890bf52e7124d (diff)
Scripts/Nexus: Properly fixed achievement Intense Cold
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2011_06_25_10_world_achievement_criteria_data.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2011_06_25_10_world_achievement_criteria_data.sql b/sql/updates/world/2011_06_25_10_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..1fddea0ad52
--- /dev/null
+++ b/sql/updates/world/2011_06_25_10_world_achievement_criteria_data.sql
@@ -0,0 +1,11 @@
+DELETE FROM `disables` WHERE `entry`=7315 AND `sourceType`=4;
+
+DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=7315 AND `type`=11;
+INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`)
+VALUES
+(7315,11,0,0,'achievement_intense_cold');
+
+DELETE FROM `spell_script_names` WHERE `spell_id`=48095;
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`)
+VALUES
+(48095,'spell_intense_cold');