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 | |
| 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')
| -rw-r--r-- | sql/scripts/world_scripts_full.sql | 3 | ||||
| -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 |
3 files changed, 13 insertions, 0 deletions
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index 2f9db2e0654..3e787da3b0a 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -2067,6 +2067,9 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 63985, 'spell_ulduar_stone_grip'), ( 64224, 'spell_ulduar_stone_grip_absorb'), ( 64225, 'spell_ulduar_stone_grip_absorb'), +( 62166, 'spell_ulduar_stone_grip_cast_target'), +( 63981, 'spell_ulduar_stone_grip_cast_target'), +( 64702, 'spell_ulduar_squeezed_lifeless'), -- quest ( 8913, 'spell_q55_sacred_cleansing'), ( 17271, 'spell_q5206_test_fetid_skull'), 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 |