From 981777197307cbdb63a5f212319890ecf8760c90 Mon Sep 17 00:00:00 2001 From: kaelima Date: Thu, 5 Jan 2012 21:56:18 +0100 Subject: DB: - Corrected the name of one recently pushed sql file. - Added some stuff to 728c07b888f0c5ade0806f688b65e0a47234c125 (for The Etymidian) --- sql/updates/world/2012_01_05_06_world_spel_script_names.sql | 2 -- sql/updates/world/2012_01_05_06_world_spell_script_names.sql | 2 ++ sql/updates/world/2012_01_05_14_world_creature_template.sql | 9 +++++++++ 3 files changed, 11 insertions(+), 2 deletions(-) delete mode 100644 sql/updates/world/2012_01_05_06_world_spel_script_names.sql create mode 100644 sql/updates/world/2012_01_05_06_world_spell_script_names.sql create mode 100644 sql/updates/world/2012_01_05_14_world_creature_template.sql (limited to 'sql') diff --git a/sql/updates/world/2012_01_05_06_world_spel_script_names.sql b/sql/updates/world/2012_01_05_06_world_spel_script_names.sql deleted file mode 100644 index 1a22c2916bb..00000000000 --- a/sql/updates/world/2012_01_05_06_world_spel_script_names.sql +++ /dev/null @@ -1,2 +0,0 @@ --- add voices for Currupted Ashbringer -UPDATE `spell_script_names` SET `spell_id`=28414 WHERE `ScriptName`= 'spell_item_ashbringer'; diff --git a/sql/updates/world/2012_01_05_06_world_spell_script_names.sql b/sql/updates/world/2012_01_05_06_world_spell_script_names.sql new file mode 100644 index 00000000000..1a22c2916bb --- /dev/null +++ b/sql/updates/world/2012_01_05_06_world_spell_script_names.sql @@ -0,0 +1,2 @@ +-- add voices for Currupted Ashbringer +UPDATE `spell_script_names` SET `spell_id`=28414 WHERE `ScriptName`= 'spell_item_ashbringer'; 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); -- cgit v1.2.3