From ba6e62fd6ec00dcd03ae1fa5332a8499ec139ca0 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sat, 10 Aug 2013 16:35:06 +0200 Subject: Scripted/BaradinHold: Implemented Pit Lord Argaloth Note: Need some update with sniff --- sql/updates/world/2013_08_10_00_world_argaloth_434.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/2013_08_10_00_world_argaloth_434.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2013_08_10_00_world_argaloth_434.sql b/sql/updates/world/2013_08_10_00_world_argaloth_434.sql new file mode 100644 index 00000000000..e9b8188e174 --- /dev/null +++ b/sql/updates/world/2013_08_10_00_world_argaloth_434.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (88954,95173,88942,95172); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(88954,'spell_argaloth_consuming_darkness'), +(95173,'spell_argaloth_consuming_darkness'), +(88942,'spell_argaloth_meteor_slash'), +(95172,'spell_argaloth_meteor_slash'); + +UPDATE `creature_template` SET `ScriptName`='boss_pit_lord_argaloth' WHERE `entry`=47120; +UPDATE `creature_template` SET `faction_A`=85,`faction_H`=85,`faction_A`=16,`faction_H`=16,`flags_extra`=128 WHERE `entry`=47829; + +DELETE FROM `creature_template_addon` WHERE `entry`=47829; +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(47829, 0, 0x0, 0x1, '88999'); -- cgit v1.2.3