Skeletal Miner

Creature

General

Creature model for display ID 158
Field Value
entry 623
display_id1 158
level_min 17
faction 21: Undead, Scourge
npc_flags None
health_multiplier 3
mana_multiplier 1

Spawn points — Eastern Kingdoms (9)

-11308.8 1591.97 36.365 0 [Random: 3 yards]
-11298.1 1563.58 35.8481 0 [Random: 3 yards]
-11305.7 1560.36 36.4148 0 [Random: 3 yards]
-11292.3 1573.64 36.3852 0 [Random: 3 yards]
-11343.3 1564.1 31.9432 0 [Random: 3 yards]
-11320.1 1592.46 35.7475 0 [Random: 3 yards]
-11285.5 1586.7 36.6121 0 [Random: 3 yards]
-11341.5 1573.82 33.4517 0 [Random: 3 yards]
-11294.7 1590.64 34.135 0 [Random: 3 yards]

Spells they cast (1)

Quest item loot (1)

Loot (69)

2592 Wool Cloth 17.78% 2589 Linen Cloth 12.47% 1959 Cold Iron Pick 5% 4605 Red-speckled Mushroom 4.82% 1179 Ice Cold Milk 2.72% 1210 Shadowgem 1.74% 2771 Tin Ore 1.44% 2836 Coarse Stone 1.32% 2770 Copper Ore 1.16% 2838 Heavy Stone 1.08% 858 Lesser Healing Potion 1.02% 2455 Minor Mana Potion 0.93% 1206 Moss Agate 0.54% 955 Scroll of Intellect 0.52% 818 Tigerseye 0.5% 1180 Scroll of Stamina 0.34% 3012 Scroll of Agility 0.32% 2772 Iron Ore 0.3% 954 Scroll of Strength 0.3% 6344 Formula: Enchant Bracer - Minor Spirit 0.12% 4345 Pattern: Red Woolen Boots 0.12% 2881 Plans: Runed Copper Breastplate 0.12% 6348 Formula: Enchant Weapon - Minor Beastslayer 0.08% 2409 Pattern: Dark Leather Tunic 0.08% 4346 Pattern: Heavy Woolen Cloak 0.08% 4293 Pattern: Hillman's Leather Vest 0.08% 2835 Rough Stone 0.08% 5574 White Leather Bag 0.06% 6347 Formula: Enchant Bracer - Minor Strength 0.06% 4409 Schematic: Small Seaforium Charge 0.06% 4541 Freshly Baked Bread 0.04% 2287 Haunch of Meat 0.04% 3393 Recipe: Minor Magic Resistance Potion 0.04% 4698 Seer's Mantle 0.04% 856 Blue Leather Bag 0.02% 414 Dalaran Sharp 0.02% 5573 Green Leather Bag 0.02% 2657 Red Leather Bag 0.02% 2453 Bruiseweed 0.02% 6375 Formula: Enchant Bracer - Lesser Spirit 0.02% 6342 Formula: Enchant Chest - Minor Mana 0.02% 4700 Inscribed Leather Spaulders 0.02% 4592 Longjaw Mud Snapper 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% 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% 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% 4410 Schematic: Shadow Goggles 0.02% 2775 Silver Ore 0.02% 765 Silverleaf 0.02% 2452 Swiftthistle 0.02% 4537 Tel'Abim Banana 0.02%

Reference loot (84)

1814 Battered Mallet 5% 1811 Blunt Claymore 5% 3376 Canvas Belt 5% 1764 Canvas Boots 5% 3377 Canvas Bracers 5% 1766 Canvas Cloak 5% 1767 Canvas Gloves 5% 1768 Canvas Pants 5% 1769 Canvas Shoulderpads 5% 1770 Canvas Vest 5% 1813 Chipped Quarterstaff 5% 2781 Dirty Blunderbuss 5% 1738 Laced Mail Belt 5% 1739 Laced Mail Boots 5% 1740 Laced Mail Bracers 5% 1741 Laced Mail Cloak 5% 1742 Laced Mail Gloves 5% 1743 Laced Mail Pants 5% 1744 Laced Mail Shoulderpads 5% 1745 Laced Mail Vest 5% 2780 Light Hunting Bow 5% 1815 Ornamental Mace 5% 1794 Patched Leather Jerkin 5% 1792 Patched Leather Pants 5% 1787 Rawhide Belt 5% 1788 Rawhide Boots 5% 1789 Rawhide Bracers 5% 1790 Rawhide Cloak 5% 1791 Rawhide Gloves 5% 1793 Rawhide Shoulderpads 5% 2217 Rectangular Shield 5% 1817 Short Cutlass 5% 1812 Short-handled Battle Axe 5% 2216 Simple Buckler 5% 2764 Small Dagger 5% 1816 Unbalanced Axe 5% 3195 Barbaric Battle Axe 1% 5212 Blazing Wand 1% 3305 Brackwater Leggings 1% 3306 Brackwater Vest 1% 6380 Burnished Buckler 1% 2991 Burnished Chain Boots 1% 3211 Burnished Chain Bracers 1% 4695 Burnished Chain Cloak 1% 4697 Burnished Chain Girdle 1% 2992 Burnished Chain Gloves 1% 2990 Burnished Chain Leggings 1% 2989 Burnished Chain Tunic 1% 3655 Burnished Shield 1% 3315 Ceremonial Leather Pants 1% 3313 Ceremonial Leather Tunic 1% 3196 Edged Bastard Sword 1% 4568 Grunt Axe 1% 3040 Hunter's Muzzle Loader 1% 2974 Hunting Pants 1% 2973 Hunting Vest 1% 6379 Inscribed Leather Belt 1% 2987 Inscribed Leather Boots 1% 3205 Inscribed Leather Bracers 1% 2985 Inscribed Leather Breastplate 1% 4701 Inscribed Leather Cloak 1% 2988 Inscribed Leather Gloves 1% 2986 Inscribed Leather Pants 1% 4576 Light Bow 1% 2970 Magister's Pants 1% 2969 Magister's Vest 1% 4575 Medicine Staff 1% 2078 Northern Shortsword 1% 3193 Oak Mallet 1% 3310 Runic Cloth Vest 1% 3309 Runic Loin Cloth 1% 2983 Seer's Boots 1% 3645 Seer's Bracers 1% 6378 Seer's Cape 1% 2984 Seer's Gloves 1% 2982 Seer's Pants 1% 2981 Seer's Robe 1% 4699 Seer's Sash 1% 2079 Sergeant's Warhammer 1% 4567 Short Bastard Sword 1% 5207 Twilight Wand 1% 2977 Veteran Armor 1% 4571 War Knife 1% 3184 Wavy Blladed Knife 1%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 623);
Field Value
entry 623
display_id1 158
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Skeletal Miner
subname
static_flags None
gossip_menu_id 0
level_min 17
level_max 18
faction 21: Undead, Scourge
npc_flags None
speed_walk 1
speed_run 1.14286
scale 0
detection_range 20
call_for_help_range 5
leash_range 0
rank 1: Elite
xp_multiplier 1
damage_school 0: Normal
damage_variance 0.14
damage_multiplier 2.8
health_multiplier 3
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 6: Undead
type_flags 0
loot_id 623
pickpocket_loot_id 0
skinning_loot_id 0
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 11976 (not found)
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 6230
pet_spell_list_id 0
auras
gold_min 77c
gold_max 1s 5c
ai_name
movement_type 0: Idle
inhabit_type Ground, Water
civilian 0
racial_leader 0
regeneration 3
equipment_id 623
trainer_id 0
vendor_id 0
mechanic_immune_mask 0x834213: Charm, Disoriented, Fear, Sleep, Bleed, Polymorph, Banish, Horror
school_immune_mask 0
flags_extra None
script_name