aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorMachiavelli <machiavelli.trinity@gmail.com>2011-02-23 18:17:20 +0100
committerMachiavelli <machiavelli.trinity@gmail.com>2011-02-23 18:17:20 +0100
commit102c089ab8ac87c278a546edfd6a9225dfa5cc6f (patch)
treeef0544e780f02126dd5aec8de5fc3842e49782f5 /sql
parent550f59e05f81f9b898c463b4379ff72a4d7b0fa6 (diff)
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
Diffstat (limited to 'sql')
-rw-r--r--sql/scripts/world_scripts_full.sql1
-rw-r--r--sql/updates/world/2011_02_23_2_world_conditions.sql1
-rw-r--r--sql/updates/world/2011_02_23_4_world_spell_script_names.sql4
-rw-r--r--sql/updates/world/2011_02_23_5_world_creature_template.sql1
4 files changed, 6 insertions, 1 deletions
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);