General
| Field | Value |
|---|---|
| entry | 1910 |
| class | Weapon |
| display_id | 7493 |
| sell_price | 3c |
| inventory_type | 13: Weapon |
| spellid_1 | 0 |
In-game view
Monster - Item, Pick
Weapon
Weapon
Level 1 (Min 1)
1 – 2 Damage
Speed: 2
Buy price: 17c
Stackable: 1
Item is equipped by (60)
40
Kobold Miner
80
Kobold Laborer
598
Defias Miner
623
Skeletal Miner
626
Foreman Thistlenettle
656
Wilder Thistlenettle
674
Venture Co. Strip Miner
824
Defias Digger
1053
Dark Iron Tunneler
1078
Ormer Ironbraid
1094
Venture Co. Miner
1167
Stonesplinter Digger
1175
Tunnel Rat Digger
1236
Kobold Digger
1255
Prospector Gehn
1356
Prospector Stormpike
1358
Miner Grothor
1360
Miner Grumnal
1424
Master Digger
1426
Riverpaw Miner
1701
Dank Drizzlecut
1727
Defias Worker
2269
Hillsbrad Miner
2393
Christoph Jeffcoat
2574
Drywhisker Digger
2739
Shadowforge Tunneler
2909
Hammertoe Grez
2917
Prospector Remtravel
2976
Venture Co. Laborer
2978
Venture Co. Worker
3001
Brek Stonehoof
3002
Kurm Stonehoof
3051
Supervisor Fizsprocket
3081
Wunna Darkmane
3137
Matt Johnson
3175
Krunn
3187
Tai'tasi
3357
Makaru
3374
Bael'dun Excavator
3392
Prospector Khazgorm
3421
Feegly the Exiled
3482
Tari'qa
3555
Johan Focht
3578
Dalaran Miner
3586
Miner Johnson
3999
Windshear Digger
4254
Geofram Bouldertoe
4256
Golnir Bouldertoe
4276
Piznik
4416
Defias Strip Miner
4598
Brom Killian
4846
Shadowforge Digger
4847
Shadowforge Relic Hunter
4856
Stonevault Cave Hunter
4877
Jandia
5388
Ingo Woolybush
5389
Prospector Gunstan
5392
Yarr Hammerstone
5513
Gelman Stonehand
5514
Brooke Stonebraid
Item details
UPDATE `item_template` SET `field`
= xxxx WHERE (`entry` = 1910);
| Field | Value |
|---|---|
| entry | 1910 |
| class | Weapon |
| subclass | -1x |
| name | Monster - Item, Pick |
| description | |
| display_id | 7493 |
| quality | 0 |
| flags | None |
| buy_count | 1 |
| buy_price | 17c |
| sell_price | 3c |
| inventory_type | 13: Weapon |
| allowable_class | -1 |
| allowable_race | -1 |
| item_level | 1 |
| required_level | 1 |
| required_skill | 0: None |
| required_skill_rank | 0 |
| required_spell | 0 |
| required_honor_rank | 0 |
| required_city_rank | 0 |
| required_reputation_faction | 0 |
| required_reputation_rank | 0 |
| max_count | 0 |
| stackable | 1 |
| container_slots | 0 |
| stat_type1 | 0 |
| stat_value1 | 0 |
| stat_type2 | 0 |
| stat_value2 | 0 |
| stat_type3 | 0 |
| stat_value3 | 0 |
| stat_type4 | 0 |
| stat_value4 | 0 |
| stat_type5 | 0 |
| stat_value5 | 0 |
| stat_type6 | 0 |
| stat_value6 | 0 |
| stat_type7 | 0 |
| stat_value7 | 0 |
| stat_type8 | 0 |
| stat_value8 | 0 |
| stat_type9 | 0 |
| stat_value9 | 0 |
| stat_type10 | 0 |
| stat_value10 | 0 |
| delay | 2000 |
| range_mod | 0 |
| ammo_type | 0 |
| dmg_min1 | 1 |
| dmg_max1 | 2 |
| dmg_type1 | 0 |
| dmg_min2 | 0 |
| dmg_max2 | 0 |
| dmg_type2 | 0 |
| dmg_min3 | 0 |
| dmg_max3 | 0 |
| dmg_type3 | 0 |
| dmg_min4 | 0 |
| dmg_max4 | 0 |
| dmg_type4 | 0 |
| dmg_min5 | 0 |
| dmg_max5 | 0 |
| dmg_type5 | 0 |
| block | 0 |
| armor | 0 |
| holy_res | 0 |
| fire_res | 0 |
| nature_res | 0 |
| frost_res | 0 |
| shadow_res | 0 |
| arcane_res | 0 |
| spellid_1 | 0 |
| spelltrigger_1 | 0 |
| spellcharges_1 | 0 |
| spellppmrate_1 | 0 |
| spellcooldown_1 | -1 |
| spellcategory_1 | 0 |
| spellcategorycooldown_1 | -1 |
| spellid_2 | 0 |
| spelltrigger_2 | 0 |
| spellcharges_2 | 0 |
| spellppmrate_2 | 0 |
| spellcooldown_2 | -1 |
| spellcategory_2 | 0 |
| spellcategorycooldown_2 | -1 |
| spellid_3 | 0 |
| spelltrigger_3 | 0 |
| spellcharges_3 | 0 |
| spellppmrate_3 | 0 |
| spellcooldown_3 | -1 |
| spellcategory_3 | 0 |
| spellcategorycooldown_3 | -1 |
| spellid_4 | 0 |
| spelltrigger_4 | 0 |
| spellcharges_4 | 0 |
| spellppmrate_4 | 0 |
| spellcooldown_4 | -1 |
| spellcategory_4 | 0 |
| spellcategorycooldown_4 | -1 |
| spellid_5 | 0 |
| spelltrigger_5 | 0 |
| spellcharges_5 | 0 |
| spellppmrate_5 | 0 |
| spellcooldown_5 | -1 |
| spellcategory_5 | 0 |
| spellcategorycooldown_5 | -1 |
| bonding | 0: No bind |
| page_text | 0 |
| page_language | 0 |
| page_material | 0 |
| start_quest | - |
| lock_id | 0 |
| material | 1 |
| sheath | 3 |
| random_property | 0 |
| set_id | 0 |
| max_durability | 20 |
| area_bound | 0 |
| map_bound | 0 |
| duration | 0 |
| bag_family | 0 |
| disenchant_id | 0 |
| food_type | 0 |
| min_money_loot | 0 |
| max_money_loot | 0 |
| extra_flags | 0x4 |
| ignored | 0 |