Hillsbrad Foreman

Creature

General

Creature model for display ID 3633
Field Value
entry 2503
display_id1 3633
level_min 27
faction 11: Human, Stormwind
npc_flags None
health_multiplier 1.05
mana_multiplier 1

Spawn points — Eastern Kingdoms (10)

-717.893 46.2339 29.823 0 [Random: 3 yards]
-808.738 149.834 1.739 0 [Random: 5 yards]
-827.802 204.545 17.314 0 [Random: 5 yards]
-827.768 143.352 -0.472 0 [Random: 3 yards]
-831.456 128.705 0.779 0 [Random: 5 yards]
-812.38 127.538 1.059 0 [Random: 3 yards]
-734.512 123.472 8.505 0 [Random: 3 yards]
-745.569 182.463 14.127 0 [Random: 3 yards]
-780.465 118.392 -0.016 0 [Random: 3 yards]
-865.553 186.77 16.0791 0 [Waypoints]

Spells they cast (1)

Loot (50)

4306 Silk Cloth 23.57% 2592 Wool Cloth 9.72% 422 Dwarven Mild 4.76% 1205 Melon Juice 2.26% 929 Healing Potion 1.14% 3385 Lesser Mana Potion 0.66% 1712 Scroll of Spirit II 0.62% 1478 Scroll of Protection II 0.52% 2290 Scroll of Intellect II 0.42% 1711 Scroll of Stamina II 0.4% 4633 Heavy Bronze Lockbox 0.19% 2771 Tin Ore 0.14% 1206 Moss Agate 0.12% 1705 Lesser Moonstone 0.1% 2836 Coarse Stone 0.08% 2775 Silver Ore 0.04% 2453 Bruiseweed 0.02% 2838 Heavy Stone 0.02% 5575 Large Green Sack 0.02% 858 Lesser Healing Potion 0.02% 2455 Minor Mana Potion 0.02% 4542 Moist Cornbread 0.02% 3770 Mutton Chop 0.02% 4297 Pattern: Barbaric Gloves 0.02% 5972 Pattern: Fine Leather Pants 0.02% 5774 Pattern: Green Silk Pack 0.02% 4298 Pattern: Guardian Belt 0.02% 4348 Pattern: Phoenix Gloves 0.02% 4347 Pattern: Reinforced Woolen Shoulders 0.02% 6390 Pattern: Stylish Blue Shirt 0.02% 3611 Plans: Green Iron Boots 0.02% 3612 Plans: Green Iron Gauntlets 0.02% 3870 Plans: Green Iron Shoulders 0.02% 5543 Plans: Iridescent Hammer 0.02% 6044 Plans: Iron Shield Spike 0.02% 3866 Plans: Jade Serpentblade 0.02% 2882 Plans: Silvered Bronze Shoulders 0.02% 3830 Recipe: Elixir of Fortitude 0.02% 6211 Recipe: Elixir of Ogre's Strength 0.02% 4412 Schematic: Moonsight Rifle 0.02% 4410 Schematic: Shadow Goggles 0.02% 4538 Snapvine Watermelon 0.02% 4606 Spongy Morel 0.02% 2452 Swiftthistle 0.02% 5504 Tangy Clam Meat 0.02% 1529 Jade 0.02% 857 Large Red Sack 0.02% 2997 Bolt of Wool Cloth 0.01% 804 Large Blue Sack 0.01% 5576 Large Brown Sack 0.01%

Reference loot (127)

1825 Bulky Bludgeon 2.5% 3380 Cross-stitched Belt 2.5% 1780 Cross-stitched Boots 2.5% 3381 Cross-stitched Bracers 2.5% 1782 Cross-stitched Cloak 2.5% 1783 Cross-stitched Gloves 2.5% 1784 Cross-stitched Pants 2.5% 1785 Cross-stitched Shoulderpads 2.5% 1786 Cross-stitched Vest 2.5% 2766 Deft Stiletto 2.5% 1809 Hardened Leather Shoulderpads 2.5% 1830 Long Bastard Sword 2.5% 1827 Meat Cleaver 2.5% 1831 Oaken War Staff 2.5% 2786 Oiled Blunderbuss 2.5% 1754 Reinforced Chain Belt 2.5% 1755 Reinforced Chain Boots 2.5% 1756 Reinforced Chain Bracers 2.5% 1757 Reinforced Chain Cloak 2.5% 1758 Reinforced Chain Gloves 2.5% 1759 Reinforced Chain Pants 2.5% 1760 Reinforced Chain Shoulderpads 2.5% 1761 Reinforced Chain Vest 2.5% 1826 Rock Maul 2.5% 1829 Short Cutlass 2.5% 2785 Stiff Recurve Bow 2.5% 1828 Stone War Axe 2.5% 2221 Targe Shield 2.5% 3778 Taut Compound Bow 2.5% 1806 Tough Cloak 2.5% 1810 Tough Leather Armor 2.5% 1803 Tough Leather Belt 2.5% 1804 Tough Leather Boots 2.5% 1805 Tough Leather Bracers 2.5% 1807 Tough Leather Gloves 2.5% 1808 Tough Leather Pants 2.5% 2222 Tower Shield 2.5% 3041 "Mage-Eye" Blunderbuss 0.5% 3042 BKP "Sparrow" Smallbore 0.5% 5007 Band of Thorns 0.5% 4998 Blood Ring 0.5% 3210 Brutal War Axe 0.5% 2819 Cross Dagger 0.5% 5003 Crystal Starfire Medallion 0.5% 4719 Darkweave Cloak 0.5% 6407 Darkweave Cuffs 0.5% 4720 Darkweave Sash 0.5% 3740 Decapitating Sword 0.5% 2077 Dwarven War Staff 0.5% 3186 Ebon Scimitar 0.5% 6398 Emblazoned Belt 0.5% 4051 Emblazoned Boots 0.5% 4049 Emblazoned Bracers 0.5% 6396 Emblazoned Chestpiece 0.5% 6397 Emblazoned Gloves 0.5% 4048 Emblazoned Helm 0.5% 4050 Emblazoned Pants 0.5% 6399 Emblazoned Shoulders 0.5% 4708 Flameweave Belt 0.5% 3066 Flameweave Gloves 0.5% 3057 Forest Leather Boots 0.5% 3202 Forest Leather Bracers 0.5% 3058 Forest Leather Gloves 0.5% 4709 Forest Leather Mantle 0.5% 6393 Frostweave Gloves 0.5% 6395 Frostweave Mantle 0.5% 4037 Frostweave Pants 0.5% 4035 Frostweave Robe 0.5% 3201 Gladiator War Axe 0.5% 4064 Glimmering Buckler 0.5% 4073 Glimmering Mail Boots 0.5% 6387 Glimmering Mail Bracers 0.5% 4071 Glimmering Mail Chestpiece 0.5% 4711 Glimmering Mail Cloak 0.5% 6389 Glimmering Mail Coif 0.5% 4072 Glimmering Mail Gauntlets 0.5% 4712 Glimmering Mail Girdle 0.5% 6386 Glimmering Mail Leggings 0.5% 6388 Glimmering Mail Pauldrons 0.5% 6400 Glimmering Shield 0.5% 6383 Glinting Buckler 0.5% 4706 Glinting Scale Cloak 0.5% 5002 Glowing Green Talisman 0.5% 6410 Insignia Bracers 0.5% 4722 Insignia Cloak 0.5% 865 Leaden Mace 0.5% 6403 Mail Combat Armguards 0.5% 4716 Mail Combat Cloak 0.5% 3206 Two-handed Cavalier Sword 0.5% 5214 Wand of Eventide 0.5% 4999 Azora's Will 0.05% 5001 Band of Vitality 0.05% 2072 Dwarven Magestaff 0.05% 4715 Emblazoned Cloak 0.05% 4661 Flameweave Mantle 0.05% 3067 Flameweave Pants 0.05% 3069 Flameweave Robe 0.05% 3055 Forest Leather Breastplate 0.05% 3056 Forest Leather Pants 0.05% 6394 Frostweave Boots 0.05% 4036 Frostweave Bracers 0.05% 4713 Frostweave Cloak 0.05% 4714 Frostweave Sash 0.05% 3045 Glinting Scale Boots 0.05% 3212 Glinting Scale Bracers 0.05% 3049 Glinting Scale Breastplate 0.05% 4707 Glinting Scale Girdle 0.05% 3047 Glinting Scale Gloves 0.05% 3048 Glinting Scale Pants 0.05% 4705 Glinting Scale Pauldrons 0.05% 3656 Glinting Shield 0.05% 2878 Bearded Axe 0.01% 2800 Black Velvet Robes 0.01% 2236 Blackfang 0.01% 720 Brawler Gloves 0.01% 3203 Dense Triangle Mace 0.01% 2194 Diamond Hammer 0.01% 1717 Double Link Mail Tunic 0.01% 2098 Double-barreled Shotgun 0.01% 2278 Forest Tracker Epaulets 0.01% 791 Gnarled Ash Staff 0.01% 3021 Ranger Bow 0.01% 2059 Sentry Cloak 0.01% 2256 Skeletal Club of Pain 0.01% 1121 Thick-soled Boots 0.01% 890 Twisted Chanter's Staff 0.01% 2011 Twisted Sabre 0.01%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 2503);
Field Value
entry 2503
display_id1 3633
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Hillsbrad Foreman
subname
static_flags 0x80000: Amphibious
gossip_menu_id 0
level_min 27
level_max 28
faction 11: Human, Stormwind
npc_flags None
speed_walk 1
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.1
health_multiplier 1.05
mana_multiplier 1
armor_multiplier 1
base_attack_time 2.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 2503
pickpocket_loot_id 2503
skinning_loot_id 0
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 5115: Efficient Work
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 25030
pet_spell_list_id 0
auras
gold_min 27c
gold_max 1s 45c
ai_name EventAI
movement_type 0: Idle
inhabit_type Ground, Water
civilian 0
racial_leader 0
regeneration 3
equipment_id 2503
trainer_id 0
vendor_id 0
mechanic_immune_mask None
school_immune_mask 0
flags_extra None
script_name