General
Field | Value |
---|---|
entry | 3858 |
class | Trade_goods |
display_id | 4691 |
sell_price | 2s 50c |
inventory_type | 0: Cannot Equip |
spellid_1 | 0 |
In-game view
Mithril Ore
Trade_goods
Cannot Equip
Level 40
Buy price: 10s
Stackable: 10
Item dropped by (297)
5389
Prospector Gunstan
100%
4645
Magram Mauler
97.29%
4661
Gelkis Rumbler
10.52%
2453
Lo'Grosh
7.32%
5347
Antilus the Soarer
2.72%
4132
Silithid Ravager
2.34%
680
Mosh'Ogg Lord
2.14%
5453
Hazzali Tunneler
2.1%
5454
Hazzali Sandreaver
1.96%
4131
Silithid Invader
1.66%
5343
Lady Szallah
1.44%
2719
Dustbelcher Lord
1.4%
818
Mai'Zoth
1.34%
2580
Elder Mesa Buzzard
1.14%
2720
Dustbelcher Ogre Mage
1.12%
5452
Hazzali Worker
1.1%
5450
Hazzali Stinger
1.06%
2730
Rabid Crag Coyote
1%
5247
Zukk'ash Tunneler
0.96%
5459
Centipaar Tunneler
0.74%
5458
Centipaar Worker
0.7%
5460
Centipaar Sandreaver
0.68%
5451
Hazzali Swarmer
0.66%
813
Colonel Kurzen
0.62%
2686
Witherbark Broodguard
0.62%
1492
Gorlash
0.56%
2736
Greater Rock Elemental
0.56%
710
Mosh'Ogg Spellcrafter
0.52%
5333
Hatecrest Serpent Guard
0.48%
5441
Hazzali Wasp
0.46%
679
Mosh'Ogg Shaman
0.42%
4133
Silithid Hive Drone
0.4%
5336
Hatecrest Sorceress
0.36%
92
Rock Elemental
0.36%
2726
Scorched Guardian
0.36%
4850
Stonevault Cave Lurker
0.36%
1550
Thrashtail Basilisk
0.34%
2656
Jade Ooze
0.3%
4658
Maraudine Stormer
0.3%
2659
Razorbeak Skylord
0.3%
2521
Skymane Gorilla
0.3%
2522
Jaguero Stalker
0.28%
4685
Ley Hunter
0.28%
4856
Stonevault Cave Hunter
0.28%
5299
Ferocious Rage Scar
0.26%
2655
Green Sludge
0.26%
2654
Witherbark Caller
0.26%
2253
Crushridge Brute
0.24%
2595
Daggerspine Raider
0.24%
2574
Drywhisker Digger
0.24%
5244
Zukk'ash Stinger
0.23%
4686
Deepstrider Giant
0.22%
5457
Centipaar Swarmer
0.2%
978
Kurzen Subchief
0.2%
4676
Lesser Infernal
0.2%
4657
Maraudine Windchaser
0.2%
751
Marsh Flesheater
0.2%
752
Marsh Oracle
0.2%
2645
Vilebranch Shadow Hunter
0.2%
2640
Vilebranch Witch Doctor
0.2%
1551
Ironjaw Basilisk
0.18%
2573
Drywhisker Surveyor
0.18%
5293
Hulking Feral Scar
0.18%
4699
Scorpashi Venomlash
0.18%
5297
Elder Rage Scar
0.17%
2791
Enraged Rock Elemental
0.16%
4681
Mage Hunter
0.16%
2926
Silvermane Stalker
0.16%
4855
Stonevault Brawler
0.16%
4465
Vilebranch Warrior
0.16%
5421
Glasshide Petrifier
0.14%
979
Kurzen Shadow Hunter
0.14%
4656
Maraudine Mauler
0.14%
4655
Maraudine Wrangler
0.14%
5296
Rage Scar Yeti
0.14%
2734
Ridge Stalker Patriarch
0.14%
4130
Silithid Searcher
0.14%
4719
Slitherblade Sea Witch
0.14%
2653
Witherbark Sadist
0.14%
1821
Carrion Lurker
0.12%
2731
Ridge Stalker
0.12%
2752
Rumbler
0.12%
783
Skullsplitter Berserker
0.12%
4718
Slitherblade Oracle
0.12%
4715
Slitherblade Razortail
0.12%
4852
Stonevault Oracle
0.12%
2927
Vicious Owlbeast
0.12%
2557
Witherbark Shadow Hunter
0.12%
5456
Centipaar Stinger
0.1%
5455
Centipaar Wasp
0.1%
2718
Dustbelcher Shaman
0.1%
2716
Dustbelcher Wyrmhunter
0.1%
4727
Elder Thunder Lizard
0.1%
2732
Ridge Huntress
0.1%
2725
Scalding Whelp
0.1%
2924
Silvermane Wolf
0.1%
4714
Slitherblade Myrmidon
0.1%
4853
Stonevault Geomancer
0.1%
2646
Vilebranch Blood Drinker
0.1%
2644
Vilebranch Hideskinner
0.1%
2651
Witherbark Hideskinner
0.1%
4032
Young Chimaera
0.09%
678
Mosh'Ogg Mauler
0.09%
4029
Blackened Ancient
0.08%
2252
Crushridge Ogre
0.08%
2596
Daggerspine Sorceress
0.08%
1815
Diseased Black Bear
0.08%
2715
Dustbelcher Brute
0.08%
4034
Enraged Stone Spirit
0.08%
5490
Gnarled Thistleshrub
0.08%
5272
Grizzled Ironfur Bear
0.08%
1559
King Mukla
0.08%
4662
Magram Bonepaw
0.08%
1907
Naga Explorer
0.08%
5424
Scorpid Dunestalker
0.08%
5430
Searing Roc
0.08%
2925
Silvermane Howler
0.08%
781
Skullsplitter Headhunter
0.08%
4716
Slitherblade Tidehunter
0.08%
4851
Stonevault Rockchewer
0.08%
950
Swamp Talker
0.08%
5485
Thistleshrub Rootshaper
0.08%
2944
Boss Tho'grun
0.07%
2728
Feral Crag Coyote
0.07%
4037
Burning Ravager
0.06%
2717
Dustbelcher Mauler
0.06%
2249
Ferocious Yeti
0.06%
1805
Flesh Golem
0.06%
4099
Galak Marauder
0.06%
5419
Glasshide Basilisk
0.06%
2735
Lesser Rock Elemental
0.06%
4654
Maraudine Scout
0.06%
2928
Primitive Owlbeast
0.06%
5427
Rabid Blisterpaw
0.06%
2658
Razorbeak Gryphon
0.06%
2929
Savage Owlbeast
0.06%
858
Sorrow Spinner
0.06%
2544
Southern Sand Crawler
0.06%
5425
Starving Blisterpaw
0.06%
730
Tethis
0.06%
2643
Vilebranch Berserker
0.06%
4466
Vilebranch Scalper
0.06%
2556
Witherbark Headhunter
0.06%
4863
Jadespine Basilisk
0.05%
1563
Bloodsail Swashbuckler
0.04%
2248
Cave Yeti
0.04%
1817
Diseased Wolf
0.04%
2701
Dustbelcher Ogre
0.04%
5295
Enraged Feral Scar
0.04%
4097
Galak Stormer
0.04%
2831
Giant Buzzard
0.04%
4107
Highperch Wyvern
0.04%
5274
Ironfur Patriarch
0.04%
2536
Jon-Jon the Crow
0.04%
939
Kurzen Elite
0.04%
5357
Land Walker
0.04%
2932
Magregan Deepshadow
0.04%
4659
Maraudine Marauder
0.04%
4679
Nether Maiden
0.04%
4682
Nether Sister
0.04%
4684
Nether Sorceress
0.04%
4036
Rogue Flame Spirit
0.04%
768
Shadow Panther
0.04%
1788
Skeletal Warlord
0.04%
4712
Slitherblade Sorceress
0.04%
767
Swamp Jaguar
0.04%
5481
Thistleshrub Dew Collector
0.04%
1822
Venom Mist Lurker
0.04%
2680
Vilebranch Wolf Pup
0.04%
5254
Woodpaw Mystic
0.04%
4027
Bloodfury Storm Witch
0.03%
4109
Highperch Consort
0.03%
942
Kurzen Witch Doctor
0.03%
1795
Searing Ghoul
0.03%
1787
Skeletal Executioner
0.03%
4475
Blighted Zombie
0.02%
5426
Blisterpaw Hyena
0.02%
4025
Bloodfury Ambusher
0.02%
4022
Bloodfury Harpy
0.02%
4023
Bloodfury Roguefeather
0.02%
4024
Bloodfury Slayer
0.02%
4026
Bloodfury Windcaller
0.02%
1562
Bloodsail Mage
0.02%
1561
Bloodsail Raider
0.02%
4506
Bloodsail Swabby
0.02%
1564
Bloodsail Warlock
0.02%
193
Blue Dragonspawn
0.02%
2566
Boulderfist Brute
0.02%
2567
Boulderfist Magus
0.02%
4668
Burning Blade Summoner
0.02%
4038
Burning Destroyer
0.02%
2830
Buzzard
0.02%
1809
Carrion Vulture
0.02%
5358
Cliff Giant
0.02%
2727
Crag Coyote
0.02%
2255
Crushridge Mage
0.02%
4680
Doomwarder Captain
0.02%
2572
Drywhisker Kobold
0.02%
5474
Dunemaul Brute
0.02%
5472
Dunemaul Enforcer
0.02%
5471
Dunemaul Ogre
0.02%
5473
Dunemaul Ogre Mage
0.02%
5475
Dunemaul Warlock
0.02%
2907
Dustbelcher Mystic
0.02%
2729
Elder Crag Coyote
0.02%
5292
Feral Scar Yeti
0.02%
5306
Frayfeather Patriarch
0.02%
5305
Frayfeather Skystormer
0.02%
4095
Galak Mauler
0.02%
4646
Gelkis Outrunner
0.02%
4648
Gelkis Stamper
0.02%
4649
Gelkis Windchaser
0.02%
2251
Giant Yeti
0.02%
5420
Glasshide Gazer
0.02%
5238
Gordunni Battlemaster
0.02%
5232
Gordunni Brute
0.02%
5239
Gordunni Mage-Lord
0.02%
5236
Gordunni Shaman
0.02%
5240
Gordunni Warlock
0.02%
5262
Groddoc Thunderer
0.02%
4673
Hatefury Betrayer
0.02%
4672
Hatefury Felsworn
0.02%
4674
Hatefury Shadowstalker
0.02%
4671
Hatefury Trickster
0.02%
2561
Highland Fleshstalker
0.02%
2560
Highland Thrasher
0.02%
2693
Highvale Marksman
0.02%
2691
Highvale Outrunner
0.02%
1802
Hungering Wraith
0.02%
5268
Ironfur Bear
0.02%
687
Jungle Stalker
0.02%
5287
Longtooth Howler
0.02%
4638
Magram Scout
0.02%
4642
Magram Stormer
0.02%
4641
Magram Windchaser
0.02%
4640
Magram Wrangler
0.02%
750
Marsh Inkspewer
0.02%
747
Marsh Murloc
0.02%
2579
Mesa Buzzard
0.02%
2250
Mountain Yeti
0.02%
5364
Northspring Slayer
0.02%
5288
Rabid Longtooth
0.02%
5428
Roc
0.02%
5308
Rogue Vale Screecher
0.02%
1793
Rotting Ghoul
0.02%
2592
Rumbling Exile
0.02%
2505
Saltwater Snapjaw
0.02%
5646
Sandfury Axe Thrower
0.02%
5645
Sandfury Hideskinner
0.02%
1833
Scarlet Knight
0.02%
1884
Scarlet Lumberjack
0.02%
1826
Scarlet Mage
0.02%
4494
Scarlet Spellbinder
0.02%
4041
Scorched Basilisk
0.02%
5422
Scorpid Hunter
0.02%
5423
Scorpid Tail Lasher
0.02%
4846
Shadowforge Digger
0.02%
4844
Shadowforge Surveyor
0.02%
4861
Shrike Bat
0.02%
1558
Silverback Patriarch
0.02%
4042
Singed Basilisk
0.02%
1789
Skeletal Acolyte
0.02%
1783
Skeletal Flayer
0.02%
1784
Skeletal Sorcerer
0.02%
1785
Skeletal Terror
0.02%
784
Skullsplitter Beastmaster
0.02%
780
Skullsplitter Mystic
0.02%
672
Skullsplitter Spiritchaser
0.02%
667
Skullsplitter Warrior
0.02%
1791
Slavering Ghoul
0.02%
4713
Slitherblade Warrior
0.02%
1794
Soulless Ghoul
0.02%
4860
Stone Steward
0.02%
5431
Surf Glider
0.02%
674
Venture Co. Strip Miner
0.02%
676
Venture Co. Surveyor
0.02%
2648
Vilebranch Aman'zasi Guard
0.02%
2639
Vilebranch Axe Thrower
0.02%
4467
Vilebranch Soothsayer
0.02%
2647
Vilebranch Soul Eater
0.02%
5623
Wastewander Assassin
0.02%
5618
Wastewander Bandit
0.02%
5615
Wastewander Rogue
0.02%
5617
Wastewander Shadow Mage
0.02%
5616
Wastewander Thief
0.02%
2554
Witherbark Axe Thrower
0.02%
2649
Witherbark Scalper
0.02%
2652
Witherbark Venomblood
0.02%
2555
Witherbark Witch Doctor
0.02%
2650
Witherbark Zealot
0.02%
5258
Woodpaw Alpha
0.02%
5249
Woodpaw Mongrel
0.02%
5255
Woodpaw Reaver
0.02%
5251
Woodpaw Trapper
0.02%
1489
Zanzil Hunter
0.02%
1488
Zanzil Zombie
0.02%
2254
Crushridge Mauler
0.02%
Item is a reagent for spell (1)
Item is a quest reward (1)
5386
(not found)
Item details
UPDATE `item_template` SET `field`
= xxxx WHERE (`entry` = 3858);
Field | Value |
---|---|
entry | 3858 |
class | Trade_goods |
subclass | -1x |
name | Mithril Ore |
description | |
display_id | 4691 |
quality | 1 |
flags | None |
buy_count | 1 |
buy_price | 10s |
sell_price | 2s 50c |
inventory_type | 0: Cannot Equip |
allowable_class | -1 |
allowable_race | -1 |
item_level | 40 |
required_level | 0 |
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 | 10 |
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 | 0 |
range_mod | 0 |
ammo_type | 0 |
dmg_min1 | 0 |
dmg_max1 | 0 |
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 | 0 |
spellcategory_5 | 0 |
spellcategorycooldown_5 | 0 |
bonding | 0: No bind |
page_text | 0 |
page_language | 0 |
page_material | 0 |
start_quest | - |
lock_id | 0 |
material | 1 |
sheath | 0 |
random_property | 0 |
set_id | 0 |
max_durability | 0 |
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 | 0 |
ignored | 0 |