diff options
| author | Machiavelli <machiavelli.trinity@gmail.com> | 2011-02-25 15:17:15 +0100 |
|---|---|---|
| committer | Machiavelli <machiavelli.trinity@gmail.com> | 2011-02-25 15:17:15 +0100 |
| commit | 02d8d7c2a6cf30d21e18a2f1798ccc81d0dc18a6 (patch) | |
| tree | 7fae6ee14f69192d2561f4ac48c24cfffff2db81 /sql/updates | |
| parent | 154b11461543d89429f313dc9725d98112448bc1 (diff) | |
Scripts/Ulduar: Kologarn (90% complete)
- Kologarn is unable to parry (correct spellID used)
- Fix Arm respawning
- Correct Arm despawn animation
- Only cast Arm Sweep if left arm is alive
- Remove minimum required range for Focused Eyebeams
- Fix possible crash in Rubble despawn
- Correct gameobject handling
- Fix bridge visual
- Correct instance load operations for this encounter
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2011_02_25_0_world_creatures.sql | 8 | ||||
| -rw-r--r-- | sql/updates/world/2011_02_25_1_world_spell_script_names.sql | 2 |
2 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2011_02_25_0_world_creatures.sql b/sql/updates/world/2011_02_25_0_world_creatures.sql new file mode 100644 index 00000000000..e790c6b7273 --- /dev/null +++ b/sql/updates/world/2011_02_25_0_world_creatures.sql @@ -0,0 +1,8 @@ +-- Correct bounding radius and combat reach for Right Arm and Left Arm +UPDATE `creature_model_info` SET `bounding_radius`=0.31, `combat_reach`=25 WHERE `modelid` IN(28821,28822); + +-- Remove static spawns that are spawned by the encounter script and vehicle_accessory table +DELETE FROM `creature` WHERE `id` IN(32933,32934); + +-- Update spawn data +UPDATE `creature` SET `unit_flags`=33554432, `deathstate`= 1, `MovementType`=0 WHERE `id`=34297;
\ No newline at end of file diff --git a/sql/updates/world/2011_02_25_1_world_spell_script_names.sql b/sql/updates/world/2011_02_25_1_world_spell_script_names.sql new file mode 100644 index 00000000000..1e4e89b15fd --- /dev/null +++ b/sql/updates/world/2011_02_25_1_world_spell_script_names.sql @@ -0,0 +1,2 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=64702; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (64702, 'spell_ulduar_squeezed_lifeless');
\ No newline at end of file |