diff options
| author | kaelima <kaelima@live.se> | 2012-01-05 21:56:18 +0100 |
|---|---|---|
| committer | kaelima <kaelima@live.se> | 2012-01-05 21:56:18 +0100 |
| commit | 981777197307cbdb63a5f212319890ecf8760c90 (patch) | |
| tree | c76b8c028f04c23497e28c2389fd366c493bef90 | |
| parent | d5e740c6a73f71962b51054f3a563efb12926f3b (diff) | |
DB:
- Corrected the name of one recently pushed sql file.
- Added some stuff to 728c07b888f0c5ade0806f688b65e0a47234c125 (for The Etymidian)
| -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); |
