diff options
| author | Shauren <shauren.trinity@gmail.com> | 2011-04-30 15:39:58 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2011-04-30 15:39:58 +0200 |
| commit | 83989e49f84484f06b33a53ccfe556df60d6edfb (patch) | |
| tree | deff12c47b14b32cacd41c3483a8fcaad8ca0585 /sql/updates | |
| parent | 92ab83b232a1f9559e54ba12863d9bbd107dbca2 (diff) | |
Scripts/Achievements: Removed unneeded script, its now handled by auras
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2011_04_30_01_world_misc.txt | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/world/2011_04_30_01_world_misc.txt b/sql/updates/world/2011_04_30_01_world_misc.txt new file mode 100644 index 00000000000..90cbae41a0e --- /dev/null +++ b/sql/updates/world/2011_04_30_01_world_misc.txt @@ -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'); |