diff options
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 |