Defias Worker

Creature

General

Creature model for display ID 341
Field Value
entry 1727
display_id1 341
level_min 16
faction 17: Defias (Azeroth)
npc_flags None
health_multiplier 1
mana_multiplier 1

Spawn points — Eastern Kingdoms (28)

-11232.7 1597.98 32.4094 0 [Idle]
-11238 1538.91 28.1736 0 [Idle]
-11176.2 1622.23 27.1787 0 [Idle]
-11271 1542.75 29.0529 0 [Idle]
-11261.7 1644.11 33.3916 0 [Idle]
-11173.9 1636.76 25.7854 0 [Idle]
-11240.4 1588.7 34.2185 0 [Idle]
-11209 1624.12 28.4209 0 [Idle]
-11263.7 1559.31 34.4233 0 [Idle]
-11249.8 1476.44 24.141 0 [Idle]
-11233.1 1514.79 28.65 0 [Idle]
-11277.4 1505.73 39.0168 0 [Idle]
-11261.4 1572.71 34.6407 0 [Idle]
-11228.7 1504.32 26.4833 0 [Idle]
-11221.4 1607.43 33.11 0 [Idle]
-11208.6 1648.46 27.5595 0 [Idle]
-11218 1640.98 27.4693 0 [Idle]
-11232.9 1627.22 26.9836 0 [Idle]
-11241.8 1666.51 33.6692 0 [Idle]
-11252.8 1593.14 33.9067 0 [Idle]
-11258.5 1654.6 33.6242 0 [Idle]
-11266.7 1533.88 30.5158 0 [Idle]
-11240 1509.02 37.8079 0 [Idle]
-11245.1 1492.22 23.8821 0 [Idle]
-11194.8 1630.83 28.1775 0 [Idle]
-11255.3 1518.75 31.698 0 [Idle]
-11242 1635.24 27.6542 0 [Idle]
-11257.5 1502.36 38.0122 0 [Idle]

Quest item loot (1)

Loot (68)

2592 Wool Cloth 18.91% 2589 Linen Cloth 18.82% 414 Dalaran Sharp 5.13% 2771 Tin Ore 5.1% 2836 Coarse Stone 5.02% 2770 Copper Ore 3.9% 2838 Heavy Stone 2.59% 1179 Ice Cold Milk 2.4% 858 Lesser Healing Potion 1.39% 2772 Iron Ore 0.88% 2455 Minor Mana Potion 0.68% 955 Scroll of Intellect 0.52% 1180 Scroll of Stamina 0.52% 1210 Shadowgem 0.48% 3012 Scroll of Agility 0.34% 954 Scroll of Strength 0.32% 1206 Moss Agate 0.14% 2835 Rough Stone 0.14% 818 Tigerseye 0.14% 2775 Silver Ore 0.08% 6348 Formula: Enchant Weapon - Minor Beastslayer 0.04% 2409 Pattern: Dark Leather Tunic 0.04% 4346 Pattern: Heavy Woolen Cloak 0.04% 2996 Bolt of Linen Cloth 0.02% 2453 Bruiseweed 0.02% 5503 Clam Meat 0.02% 785 Common Magebloom 0.02% 6375 Formula: Enchant Bracer - Lesser Spirit 0.02% 6344 Formula: Enchant Bracer - Minor Spirit 0.02% 6347 Formula: Enchant Bracer - Minor Strength 0.02% 6342 Formula: Enchant Chest - Minor Mana 0.02% 4541 Freshly Baked Bread 0.02% 2287 Haunch of Meat 0.02% 1529 Jade 0.02% 1705 Lesser Moonstone 0.02% 774 Malachite 0.02% 2406 Pattern: Fine Leather Boots 0.02% 2408 Pattern: Fine Leather Gloves 0.02% 5972 Pattern: Fine Leather Pants 0.02% 2601 Pattern: Gray Woolen Robe 0.02% 4292 Pattern: Green Woolen Bag 0.02% 4294 Pattern: Hillman's Belt 0.02% 4348 Pattern: Phoenix Gloves 0.02% 4349 Pattern: Phoenix Pants 0.02% 6271 Pattern: Red Linen Vest 0.02% 4345 Pattern: Red Woolen Boots 0.02% 4347 Pattern: Reinforced Woolen Shoulders 0.02% 6390 Pattern: Stylish Blue Shirt 0.02% 6391 Pattern: Stylish Green Shirt 0.02% 2407 Pattern: White Leather Jerkin 0.02% 2883 Plans: Deadly Bronze Poniard 0.02% 3610 Plans: Gemmed Copper Gauntlets 0.02% 4408 Plans: Mechanical Squirrel 0.02% 2881 Plans: Runed Copper Breastplate 0.02% 5578 Plans: Silvered Bronze Breastplate 0.02% 2882 Plans: Silvered Bronze Shoulders 0.02% 2553 Recipe: Elixir of Minor Agility 0.02% 2555 Recipe: Swiftness Potion 0.02% 4605 Red-speckled Mushroom 0.02% 4410 Schematic: Shadow Goggles 0.02% 4409 Schematic: Small Seaforium Charge 0.02% 765 Silverleaf 0.02% 2452 Swiftthistle 0.02% 4537 Tel'Abim Banana 0.02% 856 Blue Leather Bag 0.02% 2657 Red Leather Bag 0.02% 5573 Green Leather Bag 0.01% 5574 White Leather Bag 0.01%

Reference loot (119)

1814 Battered Mallet 2.5% 1811 Blunt Claymore 2.5% 3376 Canvas Belt 2.5% 1764 Canvas Boots 2.5% 3377 Canvas Bracers 2.5% 1766 Canvas Cloak 2.5% 1767 Canvas Gloves 2.5% 1768 Canvas Pants 2.5% 1769 Canvas Shoulderpads 2.5% 1770 Canvas Vest 2.5% 1813 Chipped Quarterstaff 2.5% 2781 Dirty Blunderbuss 2.5% 1738 Laced Mail Belt 2.5% 1739 Laced Mail Boots 2.5% 1740 Laced Mail Bracers 2.5% 1741 Laced Mail Cloak 2.5% 1742 Laced Mail Gloves 2.5% 1743 Laced Mail Pants 2.5% 1744 Laced Mail Shoulderpads 2.5% 1745 Laced Mail Vest 2.5% 2780 Light Hunting Bow 2.5% 1815 Ornamental Mace 2.5% 1794 Patched Leather Jerkin 2.5% 1792 Patched Leather Pants 2.5% 1787 Rawhide Belt 2.5% 1788 Rawhide Boots 2.5% 1789 Rawhide Bracers 2.5% 1790 Rawhide Cloak 2.5% 1791 Rawhide Gloves 2.5% 1793 Rawhide Shoulderpads 2.5% 2217 Rectangular Shield 2.5% 1817 Short Cutlass 2.5% 1812 Short-handled Battle Axe 2.5% 2216 Simple Buckler 2.5% 2764 Small Dagger 2.5% 1816 Unbalanced Axe 2.5% 3291 Ancestral Leggings 0.5% 3292 Ancestral Tunic 0.5% 3195 Barbaric Battle Axe 0.5% 3282 Battle Chain Pants 0.5% 3283 Battle Chain Tunic 0.5% 5069 Bent Fire Wand 0.5% 4570 Birchwood Maul 0.5% 5212 Blazing Wand 0.5% 3302 Brackwater Boots 0.5% 3653 Brackwater Buckler 0.5% 3305 Brackwater Leggings 0.5% 3654 Brackwater Shield 0.5% 3306 Brackwater Vest 0.5% 6380 Burnished Buckler 0.5% 2991 Burnished Chain Boots 0.5% 3211 Burnished Chain Bracers 0.5% 4695 Burnished Chain Cloak 0.5% 4697 Burnished Chain Girdle 0.5% 2992 Burnished Chain Gloves 0.5% 2990 Burnished Chain Leggings 0.5% 2989 Burnished Chain Tunic 0.5% 3655 Burnished Shield 0.5% 3314 Ceremonial Leather Gloves 0.5% 3315 Ceremonial Leather Pants 0.5% 3313 Ceremonial Leather Tunic 0.5% 4577 Compact Shotgun 0.5% 2632 Curved Dagger 0.5% 6267 Disciple's Pants 0.5% 6266 Disciple's Vest 0.5% 2073 Dwarven Hatchet 0.5% 3196 Edged Bastard Sword 0.5% 4568 Grunt Axe 0.5% 3036 Heavy Shortbow 0.5% 3040 Hunter's Muzzle Loader 0.5% 2976 Hunting Gloves 0.5% 2974 Hunting Pants 0.5% 2973 Hunting Vest 0.5% 6337 Infantry Leggings 0.5% 6336 Infantry Tunic 0.5% 6379 Inscribed Leather Belt 0.5% 2987 Inscribed Leather Boots 0.5% 3205 Inscribed Leather Bracers 0.5% 2985 Inscribed Leather Breastplate 0.5% 4701 Inscribed Leather Cloak 0.5% 2988 Inscribed Leather Gloves 0.5% 2986 Inscribed Leather Pants 0.5% 4576 Light Bow 0.5% 2970 Magister's Pants 0.5% 2969 Magister's Vest 0.5% 4575 Medicine Staff 0.5% 2078 Northern Shortsword 0.5% 3193 Oak Mallet 0.5% 6269 Pioneer Trousers 0.5% 6268 Pioneer Tunic 0.5% 2075 Priest's Mace 0.5% 3307 Runic Cloth Boots 0.5% 3308 Runic Cloth Gloves 0.5% 3310 Runic Cloth Vest 0.5% 3309 Runic Loin Cloth 0.5% 2983 Seer's Boots 0.5% 3645 Seer's Bracers 0.5% 6378 Seer's Cape 0.5% 2984 Seer's Gloves 0.5% 2982 Seer's Pants 0.5% 2981 Seer's Robe 0.5% 4699 Seer's Sash 0.5% 2079 Sergeant's Warhammer 0.5% 5071 Shadow Wand 0.5% 4567 Short Bastard Sword 0.5% 4564 Spiked Club 0.5% 4569 Staunch Mace 0.5% 4566 Sturdy Quarterstaff 0.5% 3192 Training Sword 0.5% 3287 Tribal Pants 0.5% 3288 Tribal Vest 0.5% 5207 Twilight Wand 0.5% 2977 Veteran Armor 0.5% 3652 Veteran Buckler 0.5% 2980 Veteran Gloves 0.5% 2978 Veteran Leggings 0.5% 3651 Veteran Shield 0.5% 4571 War Knife 0.5% 3184 Wavy Blladed Knife 0.5%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 1727);
Field Value
entry 1727
display_id1 341
display_id2 2528
display_id3 0
display_id4 0
mount_display_id 0
name Defias Worker
subname
static_flags None
gossip_menu_id 0
level_min 16
level_max 17
faction 17: Defias (Azeroth)
npc_flags None
speed_walk 0.666668
speed_run 1.14286
scale 0
detection_range 18
call_for_help_range 5
leash_range 0
rank 0: Normal
xp_multiplier 1
damage_school 0: Normal
damage_variance 0.14
damage_multiplier 1
health_multiplier 1
mana_multiplier 1
armor_multiplier 1
base_attack_time 2 sec
ranged_attack_time 2 sec
unit_class 1
unit_flags 0
dynamic_flags 0
beast_family 0
trainer_type 0
trainer_spell 0
trainer_class 0
trainer_race 0
type 7: Humanoid
type_flags 0
loot_id 1727
pickpocket_loot_id 1727
skinning_loot_id 0
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 731: zzOLDLearn Unholy Armor
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 0
pet_spell_list_id 0
auras
gold_min 17c
gold_max 33c
ai_name EventAI
movement_type 0: Idle
inhabit_type Ground, Water
civilian 0
racial_leader 0
regeneration 3
equipment_id 1727
trainer_id 0
vendor_id 0
mechanic_immune_mask None
school_immune_mask 0
flags_extra None
script_name