From 102c089ab8ac87c278a546edfd6a9225dfa5cc6f Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Wed, 23 Feb 2011 18:17:20 +0100 Subject: Scripts/Kologarn: - Correct target limitation for Focused Eyebeam - Correct target selection and limitation for Stone Grip ** Fixes random teleports to the "safe spot" caused by aura unapply when that player wasn't intended as target. ** Stone Grip will only target the main tank if there's no one else in range. - Despawn Rubbles on encounter reset/complete - Use elegant MotionMaster::MoveJump instead of NearTeleportTo when releasing Stone Grip target DB/NPC Templates: - Add civilian flag for Armsweep Stalker and Rubble Stalker Other: - Fix 2011_02_23_2_world_conditions.sql to comply to standards - Cleanup affected code --- sql/scripts/world_scripts_full.sql | 1 - sql/updates/world/2011_02_23_2_world_conditions.sql | 1 + sql/updates/world/2011_02_23_4_world_spell_script_names.sql | 4 ++++ sql/updates/world/2011_02_23_5_world_creature_template.sql | 1 + 4 files changed, 6 insertions(+), 1 deletion(-) create mode 100644 sql/updates/world/2011_02_23_4_world_spell_script_names.sql create mode 100644 sql/updates/world/2011_02_23_5_world_creature_template.sql (limited to 'sql') diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index 5196757abee..58a90f99a36 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1535,7 +1535,6 @@ UPDATE `creature_template` SET `ScriptName`='mob_lightning_elemental' WHERE `ent UPDATE `creature_template` SET `ScriptName`='mob_rune_of_summoning' WHERE `entry`=33051; UPDATE `creature_template` SET `ScriptName`= 'mob_rune_of_power' WHERE entry = 33705; UPDATE `creature_template` SET `ScriptName`='boss_kologarn' WHERE `entry`=32930; -UPDATE `creature_template` SET `AIName`='NullAI' WHERE `entry` IN(33742,33809,33942); UPDATE `creature_template` SET `ScriptName`='boss_general_vezax' WHERE `entry`=33271; UPDATE `creature_template` SET `ScriptName`='npc_saronite_vapors' WHERE `entry`=33488; UPDATE `creature_template` SET `ScriptName`='npc_saronite_animus' WHERE `entry`=33524; diff --git a/sql/updates/world/2011_02_23_2_world_conditions.sql b/sql/updates/world/2011_02_23_2_world_conditions.sql index 4b80454e162..1819855eced 100644 --- a/sql/updates/world/2011_02_23_2_world_conditions.sql +++ b/sql/updates/world/2011_02_23_2_world_conditions.sql @@ -1,3 +1,4 @@ +DELETE FROM `conditions` WHERE `SourceEntry` IN(63676,63702,63629,63979,63766,63983) AND `ConditionTypeOrReference`=18; INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`Comment`) VALUES (13,0,63676,18,1,32930,'Focused Eyebeam Visual (Left) Target'), (13,0,63702,18,1,32930,'Focused Eyebeam Visual (Right) Target'), diff --git a/sql/updates/world/2011_02_23_4_world_spell_script_names.sql b/sql/updates/world/2011_02_23_4_world_spell_script_names.sql new file mode 100644 index 00000000000..2812c89024d --- /dev/null +++ b/sql/updates/world/2011_02_23_4_world_spell_script_names.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN(62166,63981); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(62166, 'spell_ulduar_stone_grip_cast_target'), +(63981, 'spell_ulduar_stone_grip_cast_target'); diff --git a/sql/updates/world/2011_02_23_5_world_creature_template.sql b/sql/updates/world/2011_02_23_5_world_creature_template.sql new file mode 100644 index 00000000000..8066d1da438 --- /dev/null +++ b/sql/updates/world/2011_02_23_5_world_creature_template.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `AIName`='', `flags_extra`=`flags_extra`|2 WHERE `entry` IN(33742,33809,33942); -- cgit v1.2.3