aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2014_02_07_00_world_misc.sql37
1 files changed, 37 insertions, 0 deletions
diff --git a/sql/updates/world/2014_02_07_00_world_misc.sql b/sql/updates/world/2014_02_07_00_world_misc.sql
new file mode 100644
index 00000000000..b240bb2b0be
--- /dev/null
+++ b/sql/updates/world/2014_02_07_00_world_misc.sql
@@ -0,0 +1,37 @@
+UPDATE `smart_scripts` SET `action_type`=11,`action_param1`=46377 WHERE `entryorguid`=24601 AND `source_type`=0 AND `id`=2;
+
+DELETE FROM `achievement_criteria_data` WHERE IN (5597,5599,5600,6789,7408,7412,7415,7416,7418,7419,9058,9718,9719,9720,9721,10718,10878,10879,10881,10898,11238,11402,12562,12912,12999,13000,13001,13002,13003,13004,13005,13006,13007);
+INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES
+(5597, 0, 0, 0, ''),
+(5599, 0, 0, 0, ''),
+(5600, 0, 0, 0, ''),
+(6789, 0, 0, 0, ''),
+(7408, 0, 0, 0, ''),
+(7412, 0, 0, 0, ''),
+(7415, 0, 0, 0, ''),
+(7416, 0, 0, 0, ''),
+(7418, 0, 0, 0, ''),
+(7419, 0, 0, 0, ''),
+(9058, 0, 0, 0, ''),
+(9718, 0, 0, 0, ''),
+(9719, 0, 0, 0, ''),
+(9720, 0, 0, 0, ''),
+(9721, 0, 0, 0, ''),
+(10718, 0, 0, 0, ''),
+(10878, 0, 0, 0, ''),
+(10879, 0, 0, 0, ''),
+(10881, 0, 0, 0, ''),
+(10898, 0, 0, 0, ''),
+(11238, 0, 0, 0, ''),
+(11402, 0, 0, 0, ''),
+(12562, 0, 0, 0, ''),
+(12912, 0, 0, 0, ''),
+(12999, 0, 0, 0, ''),
+(13000, 0, 0, 0, ''),
+(13001, 0, 0, 0, ''),
+(13002, 0, 0, 0, ''),
+(13003, 0, 0, 0, ''),
+(13004, 0, 0, 0, ''),
+(13005, 0, 0, 0, ''),
+(13006, 0, 0, 0, ''),
+(13007, 0, 0, 0, '');