aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorkaelima <kaelima@live.se>2012-01-05 21:56:18 +0100
committerkaelima <kaelima@live.se>2012-01-05 21:56:18 +0100
commit981777197307cbdb63a5f212319890ecf8760c90 (patch)
treec76b8c028f04c23497e28c2389fd366c493bef90
parentd5e740c6a73f71962b51054f3a563efb12926f3b (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.sql9
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);