Riverpaw Miner

Creature

General

Creature model for display ID 174
Field Value
entry 1426
display_id1 174
level_min 14
faction 20: Gnoll (Riverpaw)
npc_flags None
health_multiplier 1
mana_multiplier 1

Spawn points — Eastern Kingdoms (8)

-10536.6 2003.7 -8.76479 0 [Random: 3 yards]
-10458.9 1954.29 8.32358 0 [Idle]
-10474.9 1990.84 9.42142 0 [Idle]
-10581.5 2003.62 -6.388 0 [Random: 3 yards]
-10580.1 1979.05 -4.34703 0 [Random: 3 yards]
-10509.5 1957.69 6.82292 0 [Random: 3 yards]
-10477.8 1939.67 8.05988 0 [Idle]
-10558.5 1957.18 -3.27676 0 [Random: 3 yards]

Quest item loot (1)

Loot (66)

2589 Linen Cloth 38.3% 2287 Haunch of Meat 4.75% 1179 Ice Cold Milk 2.26% 2770 Copper Ore 2.18% 2771 Tin Ore 1.86% 2836 Coarse Stone 1.76% 2835 Rough Stone 1.68% 858 Lesser Healing Potion 1.1% 2455 Minor Mana Potion 1.05% 856 Blue Leather Bag 0.75% 818 Tigerseye 0.62% 1181 Scroll of Spirit 0.54% 3013 Scroll of Spirit Armor 0.5% 1180 Scroll of Stamina 0.38% 955 Scroll of Intellect 0.34% 774 Malachite 0.22% 1210 Shadowgem 0.2% 2698 Recipe: Cooked Crab Claw 0.18% 4690 Hunting Belt 0.13% 3207 Hunting Bracers 0.11% 3643 Magister's Bracers 0.11% 2971 Magister's Shoes 0.09% 2979 Veteran Boots 0.09% 2598 Pattern: Red Linen Robe 0.08% 3609 Plans: Copper Chain Vest 0.08% 2975 Hunting Boots 0.07% 2972 Magister's Gloves 0.07% 3213 Veteran Bracers 0.07% 4683 Magister's Cloak 0.06% 4689 Hunting Cloak 0.04% 4678 Veteran Girdle 0.04% 6342 Formula: Enchant Chest - Minor Mana 0.04% 5573 Green Leather Bag 0.04% 118 Minor Healing Potion 0.04% 2408 Pattern: Fine Leather Gloves 0.04% 4346 Pattern: Heavy Woolen Cloak 0.04% 2555 Recipe: Swiftness Potion 0.04% 2657 Red Leather Bag 0.04% 2775 Silver Ore 0.04% 4684 Magister's Sash 0.02% 5503 Clam Meat 0.02% 785 Common Magebloom 0.02% 414 Dalaran Sharp 0.02% 6344 Formula: Enchant Bracer - Minor Spirit 0.02% 6347 Formula: Enchant Bracer - Minor Strength 0.02% 6348 Formula: Enchant Weapon - Minor Beastslayer 0.02% 4541 Freshly Baked Bread 0.02% 1529 Jade 0.02% 1705 Lesser Moonstone 0.02% 1206 Moss Agate 0.02% 2409 Pattern: Dark Leather Tunic 0.02% 2406 Pattern: Fine Leather Boots 0.02% 4293 Pattern: Hillman's Leather Vest 0.02% 6271 Pattern: Red Linen Vest 0.02% 4345 Pattern: Red Woolen Boots 0.02% 2407 Pattern: White Leather Jerkin 0.02% 3610 Plans: Gemmed Copper Gauntlets 0.02% 4408 Plans: Mechanical Squirrel 0.02% 2881 Plans: Runed Copper Breastplate 0.02% 2553 Recipe: Elixir of Minor Agility 0.02% 4605 Red-speckled Mushroom 0.02% 4409 Schematic: Small Seaforium Charge 0.02% 765 Silverleaf 0.02% 2449 Snakeroot 0.02% 4537 Tel'Abim Banana 0.02% 5574 White Leather Bag 0.02%

Reference loot (111)

3374 Calico Belt 2.5% 1495 Calico Boots 2.5% 3375 Calico Bracers 2.5% 1497 Calico Cloak 2.5% 1498 Calico Gloves 2.5% 1499 Calico Pants 2.5% 1501 Calico Vest 2.5% 2778 Cheap Blunderbuss 2.5% 1512 Crude Battle Axe 2.5% 2777 Feeble Shortbow 2.5% 2763 Fisherman Knife 2.5% 1510 Heavy Club 2.5% 1513 Old Greatsword 2.5% 1502 Patched Leather Belt 2.5% 1503 Patched Leather Boots 2.5% 1504 Patched Leather Bracers 2.5% 1505 Patched Leather Cloak 2.5% 1506 Patched Leather Gloves 2.5% 1507 Patched Leather Pants 2.5% 1509 Patched Leather Vest 2.5% 1515 Rough Wooden Staff 2.5% 1514 Rusty Warhammer 2.5% 1511 Warped Shortsword 2.5% 2214 Wooden Buckler 2.5% 2215 Wooden Shield 2.5% 1516 Worn Hatchet 2.5% 1730 Worn Mail Belt 2.5% 1731 Worn Mail Boots 2.5% 1732 Worn Mail Bracers 2.5% 1733 Worn Mail Cloak 2.5% 1734 Worn Mail Gloves 2.5% 1735 Worn Mail Pants 2.5% 1737 Worn Mail Vest 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% 3211 Burnished Chain Bracers 0.5% 4695 Burnished Chain Cloak 0.5% 2962 Burnt Leather Pants 0.5% 2961 Burnt Leather Vest 0.5% 2140 Carving Knife 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% 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% 4701 Inscribed Leather Cloak 0.5% 2988 Inscribed Leather Gloves 0.5% 2958 Journeyman's Pants 0.5% 2957 Journeyman's Vest 0.5% 2970 Magister's Pants 0.5% 2969 Magister's Vest 0.5% 4575 Medicine Staff 0.5% 2078 Northern Shortsword 0.5% 727 Notched Shortsword 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% 4561 Scalping Tomahawk 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% 4699 Seer's Sash 0.5% 2079 Sergeant's Warhammer 0.5% 4562 Severing Axe 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% 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% 2966 Warrior's Pants 0.5% 2965 Warrior's Tunic 0.5%

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 1426);
Field Value
entry 1426
display_id1 174
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Riverpaw Miner
subname
static_flags 0x80000: Amphibious
gossip_menu_id 0
level_min 14
level_max 15
faction 20: Gnoll (Riverpaw)
npc_flags None
speed_walk 1
speed_run 1.19048
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 0.95
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 1426
pickpocket_loot_id 1426
skinning_loot_id 0
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 11971 (not found)
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 0
pet_spell_list_id 0
auras
gold_min 4c
gold_max 33c
ai_name EventAI
movement_type 1: Random
inhabit_type Ground
civilian 0
racial_leader 0
regeneration 3
equipment_id 1426
trainer_id 0
vendor_id 0
mechanic_immune_mask None
school_immune_mask 0
flags_extra None
script_name