diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2014-02-20 05:02:59 +0100 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2014-02-20 05:02:59 +0100 |
| commit | 28484a15762a908228bb155765cebd113be5fdba (patch) | |
| tree | eaf3c162810daeb17bdfcda3f7b768a0f53dae9f | |
| parent | 6d9bd3dfd8559be17394f64e1d7a0a2eab92e331 (diff) | |
DB/Creature: Misc fixes to Thomas Yance and guards around
Updates: #3905
| -rw-r--r-- | sql/updates/world/2014_02_20_04_world_creature.sql | 21 |
1 files changed, 21 insertions, 0 deletions
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 |