diff options
| author | Machiavelli <machiavelli.trinity@gmail.com> | 2011-02-23 01:45:22 +0100 |
|---|---|---|
| committer | Machiavelli <machiavelli.trinity@gmail.com> | 2011-02-23 01:45:22 +0100 |
| commit | 0ec88a642c664da6b4d89fe48925bcde90390d12 (patch) | |
| tree | a6825774865c84c3579a4cb5453c071a359f2c4b /sql | |
| parent | 44fc35bb07e72e9991b930692ed5f84a397a4807 (diff) | |
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
Diffstat (limited to 'sql')
4 files changed, 14 insertions, 0 deletions
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; |