Database

Alpha 0.5.3

Stonesplinter Skullthumper

Creature

General

Creature model for display ID 160
Field Value
entry 1163
display_id1 160
level_min 13
faction 59: Trogg
npc_flags None
health_multiplier 1
mana_multiplier 1

Spawn points — Eastern Kingdoms (78)

-5985.84 -2762.76 401.388 0 [Idle]
-5980.93 -2765.49 400.062 0 [Idle]
-6159.63 -2958.6 400.458 0 [Random: 2 yards]
-6139.04 -2947.42 396.833 0 [Random: 2 yards]
-4922.77 -3407.41 304.863 0 [Random: 10 yards]
-4916.49 -3401.62 305.363 0 [Random: 10 yards]
-6024.35 -2801.76 386.103 0 [Idle]
-6031.38 -2802.72 386.452 0 [Random: 3 yards]
-6028.79 -2811.21 387.715 0 [Idle]
-4928.6 -3387.28 304.436 0 [Random: 3 yards]
-4929.85 -3397 303.936 0 [Random: 10 yards]
-5029.35 -3340.53 299.371 0 [Idle]
-5037.87 -3342.51 299.51 0 [Idle]
-4948.31 -3389.18 306.929 0 [Random: 5 yards]
-5038.03 -3334.71 299.51 0 [Idle]
-4875.31 -3309.27 306.629 0 [Random: 10 yards]
-4867.4 -3324.54 305.129 0 [Idle]
-4891.53 -3346.09 309.352 0 [Random: 5 yards]
-4872.61 -3321.07 305.504 0 [Idle]
-5038.67 -3361.67 298.385 0 [Random: 3 yards]
-4877.12 -3326.42 305.754 0 [Idle]
-4873.57 -3335.92 307.102 0 [Idle]
-4877.43 -3276.4 304.3 0 [Random: 5 yards]
-4912.14 -3313.35 305.66 0 [Random: 5 yards]
-4921.02 -3371.95 304.264 0 [Random: 10 yards]
-5022.75 -3321.28 300.781 0 [Random: 5 yards]
-4839 -3318.81 300.853 0 [Random: 5 yards]
-6022.19 -2802.23 386.512 0 [Idle]
-6016.31 -2815.41 387.002 0 [Idle]
-5978.63 -2809.9 382.321 0 [Idle]
-6022.88 -2768.41 410.204 0 [Idle]
-6088.56 -2774.65 414.63 0 [Idle]
-6021.62 -2764.05 410.318 0 [Idle]
-6147.75 -2964.46 400.401 0 [Random: 2 yards]
-6073.62 -2785.56 411.893 0 [Random: 5 yards]
-6122.82 -2987.97 399.943 0 [Random: 3 yards]
-6118.25 -3010.98 397.898 0 [Random: 2 yards]
-5977.46 -2793.28 382.043 0 [Random: 5 yards]
-6085.73 -2951.27 400.304 0 [Random: 2 yards]
-6096.8 -2972 402.061 0 [Random: 2 yards]
-6032.59 -2823.83 411.258 0 [Random: 2 yards]
-6124.08 -2908.14 402.757 0 [Random: 2 yards]
-6044.86 -2986.07 402.595 0 [Random: 5 yards]
-6156.97 -3022.65 392.731 0 [Random: 2 yards]
-6036.36 -2984.18 401.835 0 [Idle]
-6036.23 -3004.81 401.22 0 [Random: 3 yards]
-6057.66 -3017.69 403.47 0 [Random: 2 yards]
-6014.02 -2995.8 400.396 0 [Idle]
-6025.89 -2995.16 401.646 0 [Idle]
-6024.48 -2989.89 401.646 0 [Idle]
-5986.07 -2809.8 382.277 0 [Random: 5 yards]
-6003.05 -2819.97 385.207 0 [Random: 3 yards]
-5981.69 -2794.35 383.541 0 [Idle]
-6049.89 -2791.67 406.34 0 [Random: 3 yards]
-5975.48 -2794.96 383.067 0 [Idle]
-4988.61 -3376.03 302.026 0 [Random: 5 yards]
-5011.51 -3311.96 301.656 0 [Random: 5 yards]
-5018.78 -3336.18 299.371 0 [Random: 3 yards]
-6007.93 -3000.11 402.218 0 [Random: 3 yards]
-6044.59 -2925.79 400.713 0 [Random: 2 yards]
-5975.02 -2976.78 387.773 0 [Idle]
-6108.57 -2953.16 401.841 0 [Random: 5 yards]
-6017.38 -2971.03 402.506 0 [Random: 2 yards]
-5960.94 -2971.57 386.767 0 [Random: 5 yards]
-6013.09 -2968.57 400.02 0 [Idle]
-6010.45 -2973.01 402.639 0 [Random: 3 yards]
-6033.33 -2963.31 403.613 0 [Random: 3 yards]
-6048.75 -2948.88 402.644 0 [Idle]
-6051.26 -2931.99 401.721 0 [Random: 2 yards]
-6067.83 -2935.77 402.321 0 [Random: 2 yards]
-6096.31 -2965.64 401.277 0 [Random: 3 yards]
-6140.52 -2897.49 403.497 0 [Random: 2 yards]
-6119.81 -2956.39 397.416 0 [Random: 2 yards]
-6125.86 -2924.74 401.462 0 [Random: 2 yards]
-6099.55 -2942.16 401.196 0 [Random: 3 yards]
-6133.97 -2976.72 399.963 0 [Random: 3 yards]
-6144.05 -2955.71 396.622 0 [Random: 2 yards]
-6112.89 -2996.46 399.343 0 [Random: 3 yards]

Spells they cast (1)

5703 Stunning Strike

Quest item loot (1)

2536 Trogg Stone Tooth 80%

Loot (72)

2589 Linen Cloth 38.28% 2265 Stonesplinter Axe 5.71% 2287 Haunch of Meat 5.09% 1179 Ice Cold Milk 2.38% 5109 Stonesplinter Rags 2% 858 Lesser Healing Potion 1.44% 2455 Minor Mana Potion 0.65% 818 Tigerseye 0.64% 1181 Scroll of Spirit 0.5% 3013 Scroll of Spirit Armor 0.48% 1180 Scroll of Stamina 0.36% 955 Scroll of Intellect 0.34% 2770 Copper Ore 0.32% 774 Malachite 0.2% 1210 Shadowgem 0.18% 2835 Rough Stone 0.16% 4689 Hunting Cloak 0.13% 3643 Magister's Bracers 0.13% 2700 Recipe: Succulent Pork Ribs 0.12% 4690 Hunting Belt 0.11% 2975 Hunting Boots 0.11% 2972 Magister's Gloves 0.11% 3213 Veteran Bracers 0.11% 2971 Magister's Shoes 0.1% 4678 Veteran Girdle 0.1% 4683 Magister's Cloak 0.09% 2979 Veteran Boots 0.07% 4684 Magister's Sash 0.06% 3207 Hunting Bracers 0.05% 2598 Pattern: Red Linen Robe 0.04% 3609 Plans: Copper Chain Vest 0.04% 3610 Plans: Gemmed Copper Gauntlets 0.04% 4677 Veteran Cloak 0.03% 5573 Green Leather Bag 0.03% 5574 White Leather Bag 0.03% 2996 Bolt of Linen Cloth 0.02% 2450 Briarthorn 0.02% 2836 Coarse Stone 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% 6342 Formula: Enchant Chest - Minor Mana 0.02% 6348 Formula: Enchant Weapon - Minor Beastslayer 0.02% 4541 Freshly Baked Bread 0.02% 4592 Longjaw Mud Snapper 0.02% 118 Minor Healing Potion 0.02% 1206 Moss Agate 0.02% 2409 Pattern: Dark Leather Tunic 0.02% 2406 Pattern: Fine Leather Boots 0.02% 2408 Pattern: Fine Leather Gloves 0.02% 4292 Pattern: Green Woolen Bag 0.02% 4346 Pattern: Heavy Woolen Cloak 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% 2447 Peacebloom 0.02% 4408 Plans: Mechanical Squirrel 0.02% 2881 Plans: Runed Copper Breastplate 0.02% 2553 Recipe: Elixir of Minor Agility 0.02% 2555 Recipe: Swiftness Potion 0.02% 4605 Red-speckled Mushroom 0.02% 4409 Schematic: Small Seaforium Charge 0.02% 2775 Silver Ore 0.02% 765 Silverleaf 0.02% 2449 Snakeroot 0.02% 5504 Tangy Clam Meat 0.02% 4537 Tel'Abim Banana 0.02% 2771 Tin Ore 0.02% 856 Blue Leather Bag 0.01% 2657 Red Leather Bag 0.01%

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%

Pickpocketing loot (3)

2287 Haunch of Meat 5.56% 858 Lesser Healing Potion 3.17% 4541 Freshly Baked Bread 1.59%

NPC equips (1)

1901 Monster - Mace, Basic Stone Hammer

Database entry for NPC

UPDATE `creature_template` SET `field` = xxxx WHERE (`entry` = 1163);
Field Value
entry 1163
display_id1 160
display_id2 0
display_id3 0
display_id4 0
mount_display_id 0
name Stonesplinter Skullthumper
subname
static_flags 0x80000: Amphibious
gossip_menu_id 0
level_min 13
level_max 14
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 1163
pickpocket_loot_id 1163
skinning_loot_id 0
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spell_id1 1776: Gouge
spell_id2 -
spell_id3 -
spell_id4 -
spell_list_id 11630
pet_spell_list_id 0
auras
gold_min 5c
gold_max 29c
ai_name EventAI
movement_type 1: Random
inhabit_type Ground
civilian 0
racial_leader 0
regeneration 3
equipment_id 1163
trainer_id 0
vendor_id 0
mechanic_immune_mask None
school_immune_mask 0
flags_extra None
script_name