Goldthorn

Item

General

Item model

Field Value
entry 3821
class Trade_goods
display_id 6524
sell_price 1s 50c
inventory_type 0: Cannot Equip
spellid_1 0

In-game view

Goldthorn

Item icon

Trade_goods
Cannot Equip
Level 34

Buy price: 6s

Stackable: 20

Item dropped by (231)

698 Bloodscalp Tiger 16.67% 2817 Rigglefuzz 4.4% 5354 Gnarl Leafbrother 1.76% 2860 Sigrun Ironhew 1.7% 1837 Scarlet Judge 1.64% 1081 Mire Lord 1.3% 1812 Rotting Behemoth 1.1% 5490 Gnarled Thistleshrub 0.98% 5485 Thistleshrub Rootshaper 0.92% 5481 Thistleshrub Dew Collector 0.9% 763 Lost One Chieftain 0.46% 1839 Scarlet High Clerist 0.4% 1813 Decaying Horror 0.32% 2530 Yenniku 0.18% 730 Tethis 0.16% 5361 Wave Strider 0.16% 1492 Gorlash 0.14% 4294 Scarlet Sorcerer 0.12% 5359 Shore Strider 0.12% 2423 Lord Aliden Perenolde 0.1% 818 Mai'Zoth 0.08% 679 Mosh'Ogg Shaman 0.08% 2732 Ridge Huntress 0.08% 858 Sorrow Spinner 0.08% 2944 Boss Tho'grun 0.06% 769 Deathstrike Tarantula 0.06% 709 Mosh'Ogg Warmonger 0.06% 684 Shadowmaw Panther 0.06% 5307 Vale Screecher 0.06% 2578 Young Mesa Buzzard 0.06% 5308 Rogue Vale Screecher 0.06% 2565 Giant Plains Creeper 0.05% 728 Bhag'thera 0.04% 2717 Dustbelcher Mauler 0.04% 2718 Dustbelcher Shaman 0.04% 2716 Dustbelcher Wyrmhunter 0.04% 2580 Elder Mesa Buzzard 0.04% 1713 Elder Shadowmaw Panther 0.04% 5306 Frayfeather Patriarch 0.04% 5262 Groddoc Thunderer 0.04% 5357 Land Walker 0.04% 2579 Mesa Buzzard 0.04% 2421 Muckrake 0.04% 4301 Scarlet Centurion 0.04% 4295 Scarlet Myrmidon 0.04% 4300 Scarlet Wizard 0.04% 2740 Shadowforge Darkweaver 0.04% 772 Stranglethorn Tigress 0.04% 767 Swamp Jaguar 0.04% 2686 Witherbark Broodguard 0.04% 5246 Zukk'ash Worker 0.04% 2611 Fozruk 0.03% 740 Adolescent Whelp 0.02% 2318 Argus Shadow Mage 0.02% 4505 Bloodsail Deckhand 0.02% 1561 Bloodsail Raider 0.02% 4506 Bloodsail Swabby 0.02% 1563 Bloodsail Swashbuckler 0.02% 694 Bloodscalp Axe Thrower 0.02% 699 Bloodscalp Beastmaster 0.02% 597 Bloodscalp Berserker 0.02% 671 Bloodscalp Headhunter 0.02% 588 Bloodscalp Scout 0.02% 697 Bloodscalp Shaman 0.02% 660 Bloodscalp Witch Doctor 0.02% 2566 Boulderfist Brute 0.02% 2567 Boulderfist Magus 0.02% 2562 Boulderfist Ogre 0.02% 2760 Burning Exile 0.02% 2830 Buzzard 0.02% 1821 Carrion Lurker 0.02% 5358 Cliff Giant 0.02% 690 Cold Eye Basilisk 0.02% 2727 Crag Coyote 0.02% 2761 Cresting Exile 0.02% 2253 Crushridge Brute 0.02% 2256 Crushridge Enforcer 0.02% 2255 Crushridge Mage 0.02% 2254 Crushridge Mauler 0.02% 2252 Crushridge Ogre 0.02% 2287 Crushridge Warmonger 0.02% 504 Defias Trapper 0.02% 741 Dreaming Whelp 0.02% 2572 Drywhisker Kobold 0.02% 5474 Dunemaul Brute 0.02% 5472 Dunemaul Enforcer 0.02% 5473 Dunemaul Ogre Mage 0.02% 2719 Dustbelcher Lord 0.02% 2907 Dustbelcher Mystic 0.02% 2720 Dustbelcher Ogre Mage 0.02% 2729 Elder Crag Coyote 0.02% 1557 Elder Mistvale Gorilla 0.02% 1085 Elder Stranglethorn Tiger 0.02% 2728 Feral Crag Coyote 0.02% 5305 Frayfeather Skystormer 0.02% 1796 Freezing Ghoul 0.02% 2831 Giant Buzzard 0.02% 2251 Giant Yeti 0.02% 2422 Glommus 0.02% 5238 Gordunni Battlemaster 0.02% 5232 Gordunni Brute 0.02% 5234 Gordunni Mauler 0.02% 5229 Gordunni Ogre 0.02% 5237 Gordunni Ogre Mage 0.02% 5240 Gordunni Warlock 0.02% 2736 Greater Rock Elemental 0.02% 2655 Green Sludge 0.02% 5272 Grizzled Ironfur Bear 0.02% 5260 Groddoc Ape 0.02% 5334 Hatecrest Myrmidon 0.02% 5333 Hatecrest Serpent Guard 0.02% 5336 Hatecrest Sorceress 0.02% 2561 Highland Fleshstalker 0.02% 2559 Highland Strider 0.02% 2560 Highland Thrasher 0.02% 2407 Hulking Mountain Lion 0.02% 5268 Ironfur Bear 0.02% 5274 Ironfur Patriarch 0.02% 1551 Ironjaw Basilisk 0.02% 2656 Jade Ooze 0.02% 687 Jungle Stalker 0.02% 1114 Jungle Thunderer 0.02% 731 King Bangalash 0.02% 938 Kurzen Commando 0.02% 937 Kurzen Jungle Fighter 0.02% 940 Kurzen Medicine Man 0.02% 686 Lashtail Raptor 0.02% 2735 Lesser Rock Elemental 0.02% 5287 Longtooth Howler 0.02% 5286 Longtooth Runner 0.02% 759 Lost One Hunter 0.02% 760 Lost One Muckdweller 0.02% 761 Lost One Seer 0.02% 751 Marsh Flesheater 0.02% 750 Marsh Inkspewer 0.02% 752 Marsh Oracle 0.02% 678 Mosh'Ogg Mauler 0.02% 710 Mosh'Ogg Spellcrafter 0.02% 2250 Mountain Yeti 0.02% 5225 Murk Spitter 0.02% 1907 Naga Explorer 0.02% 5364 Northspring Slayer 0.02% 5366 Northspring Windcaller 0.02% 736 Panther 0.02% 2563 Plains Creeper 0.02% 2928 Primitive Owlbeast 0.02% 5288 Rabid Longtooth 0.02% 5296 Rage Scar Yeti 0.02% 2734 Ridge Stalker Patriarch 0.02% 92 Rock Elemental 0.02% 1793 Rotting Ghoul 0.02% 2592 Rumbling Exile 0.02% 2505 Saltwater Snapjaw 0.02% 5647 Sandfury Firecaller 0.02% 2929 Savage Owlbeast 0.02% 1087 Sawtooth Snapper 0.02% 4303 Scarlet Abbot 0.02% 4302 Scarlet Champion 0.02% 4298 Scarlet Defender 0.02% 1884 Scarlet Lumberjack 0.02% 4494 Scarlet Spellbinder 0.02% 5462 Sea Spray 0.02% 1795 Searing Ghoul 0.02% 1558 Silverback Patriarch 0.02% 2925 Silvermane Howler 0.02% 2926 Silvermane Stalker 0.02% 2924 Silvermane Wolf 0.02% 729 Sin'Dall 0.02% 1789 Skeletal Acolyte 0.02% 696 Skullsplitter Axe Thrower 0.02% 784 Skullsplitter Beastmaster 0.02% 781 Skullsplitter Headhunter 0.02% 669 Skullsplitter Hunter 0.02% 780 Skullsplitter Mystic 0.02% 782 Skullsplitter Scout 0.02% 672 Skullsplitter Spiritchaser 0.02% 667 Skullsplitter Warrior 0.02% 2521 Skymane Gorilla 0.02% 1152 Snapjaw Crocilisk 0.02% 1794 Soulless Ghoul 0.02% 2893 Stonevault Bonesnapper 0.02% 2894 Stonevault Shaman 0.02% 682 Stranglethorn Tiger 0.02% 764 Swampwalker 0.02% 765 Swampwalker Elder 0.02% 2246 Syndicate Assassin 0.02% 2247 Syndicate Enforcer 0.02% 2586 Syndicate Highwayman 0.02% 2589 Syndicate Mercenary 0.02% 2245 Syndicate Saboteur 0.02% 2243 Syndicate Sentry 0.02% 2242 Syndicate Spy 0.02% 1550 Thrashtail Basilisk 0.02% 2762 Thundering Exile 0.02% 2657 Trained Razorbeak 0.02% 675 Venture Co. Foreman 0.02% 1096 Venture Co. Geologist 0.02% 4260 Venture Co. Shredder 0.02% 674 Venture Co. Strip Miner 0.02% 2927 Vicious Owlbeast 0.02% 1806 Vile Slime 0.02% 2639 Vilebranch Axe Thrower 0.02% 2643 Vilebranch Berserker 0.02% 4466 Vilebranch Scalper 0.02% 2645 Vilebranch Shadow Hunter 0.02% 2642 Vilebranch Shadowcaster 0.02% 4467 Vilebranch Soothsayer 0.02% 2647 Vilebranch Soul Eater 0.02% 4465 Vilebranch Warrior 0.02% 2640 Vilebranch Witch Doctor 0.02% 2680 Vilebranch Wolf Pup 0.02% 1804 Wailing Death 0.02% 5623 Wastewander Assassin 0.02% 5618 Wastewander Bandit 0.02% 5617 Wastewander Shadow Mage 0.02% 5616 Wastewander Thief 0.02% 2651 Witherbark Hideskinner 0.02% 2653 Witherbark Sadist 0.02% 2553 Witherbark Shadowcaster 0.02% 2652 Witherbark Venomblood 0.02% 5258 Woodpaw Alpha 0.02% 5249 Woodpaw Mongrel 0.02% 5254 Woodpaw Mystic 0.02% 5255 Woodpaw Reaver 0.02% 854 Young Jungle Stalker 0.02% 1084 Young Sawtooth Crocilisk 0.02% 1489 Zanzil Hunter 0.02% 1491 Zanzil Naga 0.02% 1490 Zanzil Witch Doctor 0.02% 1488 Zanzil Zombie 0.02% 5244 Zukk'ash Stinger 0.02%

Item is a reagent for spell (1)

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 3821);
Field Value
entry 3821
class Trade_goods
subclass -1x
name Goldthorn
description
display_id 6524
quality 1
flags None
buy_count 1
buy_price 6s
sell_price 1s 50c
inventory_type 0: Cannot Equip
allowable_class -1
allowable_race -1
item_level 34
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 20
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 7
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