From 28484a15762a908228bb155765cebd113be5fdba Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 20 Feb 2014 05:02:59 +0100 Subject: DB/Creature: Misc fixes to Thomas Yance and guards around Updates: #3905 --- sql/updates/world/2014_02_20_04_world_creature.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 sql/updates/world/2014_02_20_04_world_creature.sql (limited to 'sql') diff --git a/sql/updates/world/2014_02_20_04_world_creature.sql b/sql/updates/world/2014_02_20_04_world_creature.sql new file mode 100644 index 00000000000..4fbc704a839 --- /dev/null +++ b/sql/updates/world/2014_02_20_04_world_creature.sql @@ -0,0 +1,21 @@ +-- +UPDATE `creature_template` SET `unit_flags`=`unit_flags`|512 WHERE `entry`=18672; -- Thomas Yance +UPDATE `creature_template` SET `unit_flags`=`unit_flags`|33600 WHERE `entry`=18093; -- Tarren Mill Protector +UPDATE `creature_template` SET `unit_flags`=`unit_flags`|33600 WHERE `entry`=18092; -- Tarren Mill Guardsman + +DELETE FROM `creature_equip_template` WHERE `entry`=18672; +DELETE FROM `creature_equip_template` WHERE `entry`=18093; +INSERT INTO `creature_equip_template` (`entry`,`id`,`itemEntry1`,`itemEntry2`,`itemEntry3`) VALUES +(18672,1,1903,0,0), -- Equipment of 18672 (Thomas Yance) +(18093,1,5491,0,0), -- Equipment of 18093 (Tarren Mill Protector) +(18092,1,1899,1984,0); -- Equipment of 18092 (Tarren Mill Guardsman) + +-- Model data 18064 (creature 18672 (Thomas Yance)) +UPDATE `creature_model_info` SET `bounding_radius`=0.306,`combat_reach`=1.5 WHERE `modelid`=18064; -- Thomas Yance + +-- Addon data for creature 18672 (Thomas Yance) +DELETE FROM `creature_template_addon` WHERE `entry`=18672; +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(18672,0,0,257,0, NULL), -- Thomas Yance +(18093,0,0,1,0, NULL), -- Tarren Mill Protector +(18092,0,0,1,0, NULL); -- Tarren Mill Guardsman -- cgit v1.2.3