Stonesplinter Digger

Creature

General

Creature model for display ID 722
Field Value
entry 1167
display_id1 722
level_min 18
faction 59: Trogg
npc_flags None
health_multiplier 1
mana_multiplier 1

Spawn points — Eastern Kingdoms (31)

-5697.53 -3869.47 331.662 0 [Idle]
-5702.59 -3869.02 331.645 0 [Idle]
-5627.92 -3998.87 324.25 0 [Random: 5 yards]
-5702.67 -3898.59 328.454 0 [Waypoints]
-5710.49 -3923.7 345.97 0 [Idle]
-5703.36 -3927.25 347.21 0 [Idle]
-5702.33 -3903.39 329.172 0 [Random: 2 yards]
-5635.5 -3888.33 330.057 0 [Idle]
-5639.52 -3876.94 328.173 0 [Random: 2 yards]
-5574.65 -3865.8 327.849 0 [Random: 5 yards]
-5638.17 -3875.81 330.045 0 [Idle]
-5590.77 -3941.31 325.722 0 [Random: 3 yards]
-5578.88 -3914.01 330.469 0 [Random: 5 yards]
-5586.21 -3898.31 329.254 0 [Random: 3 yards]
-5656.39 -3947.77 319.839 0 [Random: 3 yards]
-5669.92 -3948.64 319.831 0 [Random: 3 yards]
-5679.24 -3942.09 325.242 0 [Random: 3 yards]
-5640.51 -3925.52 324.62 0 [Random: 3 yards]
-5723.6 -3907.66 322.167 0 [Idle]
-5701.61 -3950.38 327.559 0 [Random: 3 yards]
-5748.18 -3957.81 324.184 0 [Random: 5 yards]
-5716.1 -3996.91 330.267 0 [Random: 2 yards]
-5742.98 -3987.34 329.758 0 [Random: 5 yards]
-5668.78 -3992.98 326.047 0 [Waypoints]
-5677.81 -3996.1 327.197 0 [Random: 5 yards]
-5651.99 -3996.89 325.447 0 [Random: 5 yards]
-5727 -3928.46 318.931 0 [Random: 5 yards]
-5652.04 -3897.33 322.784 0 [Random: 5 yards]
-5748.5 -3970.06 326.133 0 [Random: 3 yards]
-5651.75 -3899.96 322.93 0 [Waypoints]
-5580.44 -3842.25 322.863 0 [Random: 5 yards]

Spells they cast (1)

Loot (75)

2592 Wool Cloth 19.48% 2589 Linen Cloth 18.33% 2287 Haunch of Meat 5.12% 1179 Ice Cold Milk 2.33% 5109 Stonesplinter Rags 2% 858 Lesser Healing Potion 1.51% 2771 Tin Ore 1.06% 2836 Coarse Stone 1.02% 2838 Heavy Stone 0.92% 856 Blue Leather Bag 0.75% 2770 Copper Ore 0.74% 2455 Minor Mana Potion 0.57% 1180 Scroll of Stamina 0.54% 955 Scroll of Intellect 0.5% 1210 Shadowgem 0.44% 3012 Scroll of Agility 0.38% 954 Scroll of Strength 0.38% 2772 Iron Ore 0.18% 1206 Moss Agate 0.12% 818 Tigerseye 0.1% 2700 Recipe: Succulent Pork Ribs 0.06% 5573 Green Leather Bag 0.04% 4700 Inscribed Leather Spaulders 0.04% 4346 Pattern: Heavy Woolen Cloak 0.04% 4293 Pattern: Hillman's Leather Vest 0.04% 2835 Rough Stone 0.04% 4409 Schematic: Small Seaforium Charge 0.04% 2657 Red Leather Bag 0.03% 2996 Bolt of Linen Cloth 0.02% 4694 Burnished Chain Spaulders 0.02% 785 Common Magebloom 0.02% 414 Dalaran Sharp 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% 6348 Formula: Enchant Weapon - Minor Beastslayer 0.02% 4541 Freshly Baked Bread 0.02% 1529 Jade 0.02% 1705 Lesser Moonstone 0.02% 4592 Longjaw Mud Snapper 0.02% 774 Malachite 0.02% 2409 Pattern: Dark Leather Tunic 0.02% 2406 Pattern: Fine Leather Boots 0.02% 2408 Pattern: Fine Leather Gloves 0.02% 5972 Pattern: Fine Leather Pants 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% 2447 Peacebloom 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% 2553 Recipe: Elixir of Minor Agility 0.02% 3394 Recipe: Elixir of Poison Resistance 0.02% 3393 Recipe: Minor Magic Resistance Potion 0.02% 2555 Recipe: Swiftness Potion 0.02% 4605 Red-speckled Mushroom 0.02% 4410 Schematic: Shadow Goggles 0.02% 4698 Seer's Mantle 0.02% 2775 Silver Ore 0.02% 765 Silverleaf 0.02% 2449 Snakeroot 0.02% 2452 Swiftthistle 0.02% 4537 Tel'Abim Banana 0.02% 5574 White Leather Bag 0.02%

Reference loot (94)

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% 3039 Archer's Longbow 0.5% 3195 Barbaric Battle Axe 0.5% 3198 Battering Hammer 0.5% 3199 Battle Slayer 0.5% 5212 Blazing Wand 0.5% 3305 Brackwater Leggings 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% 3315 Ceremonial Leather Pants 0.5% 3313 Ceremonial Leather Tunic 0.5% 3196 Edged Bastard Sword 0.5% 3065 Flameweave Boots 0.5% 3647 Flameweave Bracers 0.5% 6381 Flameweave Cloak 0.5% 6382 Forest Leather Belt 0.5% 4710 Forest Leather Cloak 0.5% 790 Forester's Axe 0.5% 4568 Grunt Axe 0.5% 3040 Hunter's Muzzle Loader 0.5% 2974 Hunting Pants 0.5% 2973 Hunting Vest 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% 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% 4567 Short Bastard Sword 0.5% 789 Stout Battlehammer 0.5% 5207 Twilight Wand 0.5% 2977 Veteran Armor 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` = 1167);
Field Value
entry 1167
display_id1 722
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Stonesplinter Digger
subname
static_flags 0x80000: Amphibious
gossip_menu_id 0
level_min 18
level_max 19
faction 59: Trogg
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
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 1167
pickpocket_loot_id 1167
skinning_loot_id 0
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 7386: Sundering Strike
spell_id2 7164: Defensive Stance
spell_id3 -
spell_id4 -
spell_list_id 11670
pet_spell_list_id 0
auras
gold_min 8c
gold_max 60c
ai_name EventAI
movement_type 0: Idle
inhabit_type Ground
civilian 0
racial_leader 0
regeneration 3
equipment_id 1167
trainer_id 0
vendor_id 0
mechanic_immune_mask None
school_immune_mask 0
flags_extra None
script_name