From 0ec88a642c664da6b4d89fe48925bcde90390d12 Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Wed, 23 Feb 2011 01:45:22 +0100 Subject: Scripts/Ulduar: - Fix Focused Eyebeams - Fix Arm Sweep - Fix respawning and re-entering of arms DB/Templates: - Fix speed, modelId and trigger state of Focused Eyebeams - Set NullAI to semi-triggers; Rubble Stalker, Kologarn Pit Kill Bunny --- sql/scripts/world_scripts_full.sql | 1 + sql/updates/world/2011_02_23_1_world_creature_template.sql | 5 +++++ sql/updates/world/2011_02_23_2_world_conditions.sql | 7 +++++++ sql/updates/world/2011_02_23_3_world_vehicle_accessory.sql | 1 + 4 files changed, 14 insertions(+) create mode 100644 sql/updates/world/2011_02_23_1_world_creature_template.sql create mode 100644 sql/updates/world/2011_02_23_2_world_conditions.sql create mode 100644 sql/updates/world/2011_02_23_3_world_vehicle_accessory.sql (limited to 'sql') diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index 58a90f99a36..5196757abee 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1535,6 +1535,7 @@ 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_1_world_creature_template.sql b/sql/updates/world/2011_02_23_1_world_creature_template.sql new file mode 100644 index 00000000000..95e366cc962 --- /dev/null +++ b/sql/updates/world/2011_02_23_1_world_creature_template.sql @@ -0,0 +1,5 @@ +-- Correct run speed, models, and trigger flag +UPDATE `creature_template` SET `speed_run`=5.5/7, `modelid1`=1126, `modelid2`=11686, `flags_extra`= `flags_extra`|128 WHERE `entry` IN(33632,33802); + +-- NullAI for semi-triggers (flags_extra|128 would make them unattackable by certain spells needed for the encounter) +UPDATE `creature_template` SET `AIName`='NullAI' WHERE `entry` IN(33742,33809,33942); \ No newline at end of file diff --git a/sql/updates/world/2011_02_23_2_world_conditions.sql b/sql/updates/world/2011_02_23_2_world_conditions.sql new file mode 100644 index 00000000000..4b80454e162 --- /dev/null +++ b/sql/updates/world/2011_02_23_2_world_conditions.sql @@ -0,0 +1,7 @@ +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'), +(13,0,63629,18,1,32930,'Arm Dead Damage Kologarn (10m) Target'), +(13,0,63979,18,1,32930,'Arm Dead Damage Kologarn (25m) Target'), +(13,0,63766,18,1,33661,'Arm Sweep (10m) Target'), +(13,0,63983,18,1,33661,'Arm Sweep (25m) Target'); diff --git a/sql/updates/world/2011_02_23_3_world_vehicle_accessory.sql b/sql/updates/world/2011_02_23_3_world_vehicle_accessory.sql new file mode 100644 index 00000000000..5d56e0c4fab --- /dev/null +++ b/sql/updates/world/2011_02_23_3_world_vehicle_accessory.sql @@ -0,0 +1 @@ +UPDATE `vehicle_accessory` SET `summontype`=8, `summontimer`=0 WHERE `entry`=32930; -- cgit v1.2.3