diff options
| -rw-r--r-- | sql/updates/world/2012_01_05_06_world_spell_script_names.sql (renamed from sql/updates/world/2012_01_05_06_world_spel_script_names.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/world/2012_01_05_14_world_creature_template.sql | 9 |
2 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2012_01_05_06_world_spel_script_names.sql b/sql/updates/world/2012_01_05_06_world_spell_script_names.sql index 1a22c2916bb..1a22c2916bb 100644 --- a/sql/updates/world/2012_01_05_06_world_spel_script_names.sql +++ b/sql/updates/world/2012_01_05_06_world_spell_script_names.sql diff --git a/sql/updates/world/2012_01_05_14_world_creature_template.sql b/sql/updates/world/2012_01_05_14_world_creature_template.sql new file mode 100644 index 00000000000..331a533812d --- /dev/null +++ b/sql/updates/world/2012_01_05_14_world_creature_template.sql @@ -0,0 +1,9 @@ +-- Added equipment template, corrected unit_flags and fixed model bounding for The Etymidian +SET @EQUIP := 2477; + +UPDATE `creature_template` SET `unit_flags`=`unit_flags`|8,`equipment_id`=@EQUIP WHERE `entry`=28222; +UPDATE `creature_model_info` SET `bounding_radius`=0.42,`combat_reach`=2.4 WHERE `modelid`=25928; + +DELETE FROM `creature_equip_template` WHERE `entry`=@EQUIP; +INSERT INTO `creature_equip_template` (`entry`,`itemEntry1`,`itemEntry2`,`itemEntry3`) VALUES +(@EQUIP,25316,0,0); |