From c537580b843184bc317eda1e0a7c2fd633faeb68 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 30 Apr 2011 16:05:38 +0200 Subject: Fixed file name --- sql/updates/world/2011_04_30_01_world_misc.sql | 27 ++++++++++++++++++++++++++ sql/updates/world/2011_04_30_01_world_misc.txt | 27 -------------------------- 2 files changed, 27 insertions(+), 27 deletions(-) create mode 100644 sql/updates/world/2011_04_30_01_world_misc.sql delete mode 100644 sql/updates/world/2011_04_30_01_world_misc.txt (limited to 'sql') diff --git a/sql/updates/world/2011_04_30_01_world_misc.sql b/sql/updates/world/2011_04_30_01_world_misc.sql new file mode 100644 index 00000000000..90cbae41a0e --- /dev/null +++ b/sql/updates/world/2011_04_30_01_world_misc.sql @@ -0,0 +1,27 @@ +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (6641,6642,6643,6644,6651,6652,6653,6654,6655,6656,6657,6659,10391,12398) AND `type`!=16; +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES +(6641,5,58818,0,''), -- School of Hard Knocks +(6642,5,58818,0,''), -- School of Hard Knocks +(6643,5,58818,0,''), -- School of Hard Knocks +(6644,5,58818,0,''), -- School of Hard Knocks +(6651,5,58818,0,''), -- Bad Example +(6652,5,58818,0,''), -- Bad Example +(6653,5,58818,0,''), -- Bad Example +(6654,5,58818,0,''), -- Bad Example +(6655,5,58818,0,''), -- Bad Example +(6656,5,58818,0,''), -- Bad Example +(6657,5,58818,0,''), -- Bad Example +(6659,5,58818,0,''), -- Hail To The King, Baby +(10391,5,58818,0,''), -- Home Alone +(12398,5,58818,0,''); -- Daily Chores + +UPDATE `creature_template` SET `speed_walk`=1,`speed_run`=1.14286,`faction_A`=35,`faction_H`=35,`unit_flags`=`unit_flags`|768,`dynamicflags`=0,`npcflag`=`npcflag`|3,`baseattacktime`=2000,`scale`=1 WHERE `entry` IN (14305,14444,22817,22818,33532,33533); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (14305,14444,22817,22818,33532,33533); +INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(14305,0,0,0,1,0,'58818'), +(14444,0,0,0,1,0,'58818'), +(22817,0,0,0,1,0,'58818'), +(22818,0,0,0,1,0,'58818'), +(33532,0,0,0,1,0,'58818'), +(33533,0,0,0,1,0,'58818'); diff --git a/sql/updates/world/2011_04_30_01_world_misc.txt b/sql/updates/world/2011_04_30_01_world_misc.txt deleted file mode 100644 index 90cbae41a0e..00000000000 --- a/sql/updates/world/2011_04_30_01_world_misc.txt +++ /dev/null @@ -1,27 +0,0 @@ -DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (6641,6642,6643,6644,6651,6652,6653,6654,6655,6656,6657,6659,10391,12398) AND `type`!=16; -INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES -(6641,5,58818,0,''), -- School of Hard Knocks -(6642,5,58818,0,''), -- School of Hard Knocks -(6643,5,58818,0,''), -- School of Hard Knocks -(6644,5,58818,0,''), -- School of Hard Knocks -(6651,5,58818,0,''), -- Bad Example -(6652,5,58818,0,''), -- Bad Example -(6653,5,58818,0,''), -- Bad Example -(6654,5,58818,0,''), -- Bad Example -(6655,5,58818,0,''), -- Bad Example -(6656,5,58818,0,''), -- Bad Example -(6657,5,58818,0,''), -- Bad Example -(6659,5,58818,0,''), -- Hail To The King, Baby -(10391,5,58818,0,''), -- Home Alone -(12398,5,58818,0,''); -- Daily Chores - -UPDATE `creature_template` SET `speed_walk`=1,`speed_run`=1.14286,`faction_A`=35,`faction_H`=35,`unit_flags`=`unit_flags`|768,`dynamicflags`=0,`npcflag`=`npcflag`|3,`baseattacktime`=2000,`scale`=1 WHERE `entry` IN (14305,14444,22817,22818,33532,33533); - -DELETE FROM `creature_template_addon` WHERE `entry` IN (14305,14444,22817,22818,33532,33533); -INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES -(14305,0,0,0,1,0,'58818'), -(14444,0,0,0,1,0,'58818'), -(22817,0,0,0,1,0,'58818'), -(22818,0,0,0,1,0,'58818'), -(33532,0,0,0,1,0,'58818'), -(33533,0,0,0,1,0,'58818'); -- cgit v1.2.3