Plans: Green Iron Shoulders

Item

General

Item model

Field Value
entry 3870
class Book
display_id 1102
sell_price 7s 50c
inventory_type 0: Cannot Equip
spellid_1 3531: Plans: Green Iron Shoulders

In-game view

Plans: Green Iron Shoulders

Item icon

Book
Blacksmithing
Cannot Equip
Level 32
Requires Blacksmithing (160)

Casts:
3531: Plans: Green Iron Shoulders

Buy price: 30s

Stackable: 1

Item dropped by (318)

235 Salma Saldean 0.2% 1106 Lost One Cook 0.12% 3984 Nancy Vishas 0.12% 4504 Frostmaw 0.1% 3414 General Twinbraid 0.1% 4978 Aku'mai Servant 0.08% 1364 Balgaras the Foul 0.08% 3985 Grandpa Vishas 0.08% 4158 Salt Flats Vulture 0.08% 877 Saltscale Forager 0.08% 875 Saltscale Tide Lord 0.08% 4398 Mudrock Burrower 0.06% 2306 Baron Vardus 0.06% 4459 Murkgill Oracle 0.06% 4699 Scorpashi Venomlash 0.06% 2404 Blacksmith Verringtan 0.04% 2091 Chieftain Nek'rosh 0.04% 4110 Highperch Patriarch 0.04% 4457 Murkgill Forager 0.04% 4461 Murkgill Warrior 0.04% 4522 Razorfen Dustweaver 0.04% 4291 Scarlet Diviner 0.04% 4287 Scarlet Gallant 0.04% 4304 Scarlet Tracking Hound 0.04% 4697 Scorpashi Lasher 0.04% 4686 Deepstrider Giant 0.03% 4396 Mudrock Tortoise 0.02% 740 Adolescent Whelp 0.02% 4825 Aku'mai Snapjaw 0.02% 2733 Apothecary Jorell 0.02% 1258 Black Ravager Mastiff 0.02% 3771 Bleakheart Hellcaller 0.02% 3770 Bleakheart Shadowstalker 0.02% 3767 Bleakheart Trickster 0.02% 4027 Bloodfury Storm Witch 0.02% 694 Bloodscalp Axe Thrower 0.02% 597 Bloodscalp Berserker 0.02% 595 Bloodscalp Hunter 0.02% 701 Bloodscalp Mystic 0.02% 702 Bloodscalp Scavenger 0.02% 697 Bloodscalp Shaman 0.02% 587 Bloodscalp Warrior 0.02% 660 Bloodscalp Witch Doctor 0.02% 1418 Bluegill Raider 0.02% 210 Bone Chewer 0.02% 2566 Boulderfist Brute 0.02% 2564 Boulderfist Enforcer 0.02% 2571 Boulderfist Lord 0.02% 2567 Boulderfist Magus 0.02% 2569 Boulderfist Mauler 0.02% 2562 Boulderfist Ogre 0.02% 2570 Boulderfist Shaman 0.02% 570 Brain Eater 0.02% 4665 Burning Blade Adept 0.02% 4663 Burning Blade Augur 0.02% 4666 Burning Blade Felsworn 0.02% 4664 Burning Blade Reaver 0.02% 4668 Burning Blade Summoner 0.02% 4038 Burning Destroyer 0.02% 2760 Burning Exile 0.02% 4695 Carrion Horror 0.02% 2248 Cave Yeti 0.02% 2448 Clerk Horrace Whitesteed 0.02% 690 Cold Eye Basilisk 0.02% 2727 Crag Coyote 0.02% 4126 Crag Stalker 0.02% 3834 Crazed Ancient 0.02% 2761 Cresting Exile 0.02% 1069 Crimson Whelp 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% 689 Crystal Spine Basilisk 0.02% 1158 Cursed Marine 0.02% 1157 Cursed Sailor 0.02% 2582 Dabyrie Laborer 0.02% 2581 Dabyrie Militia 0.02% 2369 Daggerspine Shorehunter 0.02% 2368 Daggerspine Shorestalker 0.02% 2371 Daggerspine Siren 0.02% 2271 Dalaran Shield Guard 0.02% 2272 Dalaran Theurgist 0.02% 1051 Dark Iron Dwarf 0.02% 1052 Dark Iron Saboteur 0.02% 1053 Dark Iron Tunneler 0.02% 4516 Death's Head Adept 0.02% 4517 Death's Head Priest 0.02% 4518 Death's Head Sage 0.02% 4519 Death's Head Seer 0.02% 1715 Defias Insurgent 0.02% 1057 Dragonmaw Bonewarder 0.02% 1034 Dragonmaw Raider 0.02% 1038 Dragonmaw Shadowwarder 0.02% 1035 Dragonmaw Swamprunner 0.02% 4693 Dread Flyer 0.02% 4692 Dread Swoop 0.02% 2574 Drywhisker Digger 0.02% 2572 Drywhisker Kobold 0.02% 2573 Drywhisker Surveyor 0.02% 2346 Dun Garok Priest 0.02% 2345 Dun Garok Rifleman 0.02% 2906 Dustbelcher Warrior 0.02% 4701 Dying Kodo 0.02% 3810 Elder Ashenvale Bear 0.02% 2729 Elder Crag Coyote 0.02% 2356 Elder Gray Bear 0.02% 1557 Elder Mistvale Gorilla 0.02% 1085 Elder Stranglethorn Tiger 0.02% 4727 Elder Thunder Lizard 0.02% 2359 Elemental Slave 0.02% 314 Eliza 0.02% 3759 Felmusk Rogue 0.02% 3763 Felmusk Shadowstalker 0.02% 2728 Feral Crag Coyote 0.02% 2249 Ferocious Yeti 0.02% 1270 Fetid Corpse 0.02% 4093 Galak Wrangler 0.02% 4646 Gelkis Outrunner 0.02% 4648 Gelkis Stamper 0.02% 4649 Gelkis Windchaser 0.02% 3825 Ghostpaw Alpha 0.02% 2831 Giant Buzzard 0.02% 2565 Giant Plains Creeper 0.02% 2251 Giant Yeti 0.02% 4111 Gravelsnout Kobold 0.02% 4539 Greater Kraul Bat 0.02% 2417 Grel'borg the Miser 0.02% 4728 Gritjaw Basilisk 0.02% 2619 Hammerfall Grunt 0.02% 2618 Hammerfall Peon 0.02% 4673 Hatefury Betrayer 0.02% 4672 Hatefury Felsworn 0.02% 4675 Hatefury Hellcaller 0.02% 4674 Hatefury Shadowstalker 0.02% 4671 Hatefury Trickster 0.02% 2561 Highland Fleshstalker 0.02% 2559 Highland Strider 0.02% 2560 Highland Thrasher 0.02% 4109 Highperch Consort 0.02% 2268 Hillsbrad Footman 0.02% 2503 Hillsbrad Foreman 0.02% 2269 Hillsbrad Miner 0.02% 2270 Hillsbrad Sentry 0.02% 4729 Hulking Gritjaw Basilisk 0.02% 2407 Hulking Mountain Lion 0.02% 687 Jungle Stalker 0.02% 1114 Jungle Thunderer 0.02% 4636 Kolkar Battle Lord 0.02% 4632 Kolkar Centaur 0.02% 4637 Kolkar Destroyer 0.02% 4634 Kolkar Mauler 0.02% 4633 Kolkar Scout 0.02% 4635 Kolkar Windchaser 0.02% 4538 Kraul Bat 0.02% 938 Kurzen Commando 0.02% 939 Kurzen Elite 0.02% 941 Kurzen Headshrinker 0.02% 940 Kurzen Medicine Man 0.02% 978 Kurzen Subchief 0.02% 686 Lashtail Raptor 0.02% 2735 Lesser Rock Elemental 0.02% 691 Lesser Water Elemental 0.02% 5286 Longtooth Runner 0.02% 1754 Lord Gregor Lescovar 0.02% 759 Lost One Hunter 0.02% 755 Lost One Mudlurker 0.02% 4645 Magram Mauler 0.02% 4639 Magram Outrunner 0.02% 4638 Magram Scout 0.02% 4642 Magram Stormer 0.02% 4641 Magram Windchaser 0.02% 4640 Magram Wrangler 0.02% 4654 Maraudine Scout 0.02% 4657 Maraudine Windchaser 0.02% 2579 Mesa Buzzard 0.02% 4061 Mirkfallon Dryad 0.02% 4056 Mirkfallon Keeper 0.02% 1108 Mistvale Gorilla 0.02% 1023 Mottled Razormaw 0.02% 1066 Mottled Riptooth 0.02% 1022 Mottled Scytheclaw 0.02% 2406 Mountain Lion 0.02% 2250 Mountain Yeti 0.02% 2372 Mudsnout Gnoll 0.02% 4124 Needles Cougar 0.02% 4684 Nether Sorceress 0.02% 205 Nightbane Dark Runner 0.02% 533 Nightbane Shadow Weaver 0.02% 920 Nightbane Tainted One 0.02% 206 Nightbane Vile Fang 0.02% 898 Nightbane Worgen 0.02% 736 Panther 0.02% 4249 Pesterhide Snarler 0.02% 2563 Plains Creeper 0.02% 4623 Quilguard Champion 0.02% 4726 Raging Thunder Lizard 0.02% 4532 Razorfen Beastmaster 0.02% 4442 Razorfen Defender 0.02% 4525 Razorfen Earthbreaker 0.02% 4523 Razorfen Groundshaker 0.02% 4436 Razorfen Quilguard 0.02% 4440 Razorfen Totemic 0.02% 2731 Ridge Stalker 0.02% 2734 Ridge Stalker Patriarch 0.02% 92 Rock Elemental 0.02% 948 Rotted One 0.02% 2592 Rumbling Exile 0.02% 4154 Salt Flats Scavenger 0.02% 879 Saltscale Hunter 0.02% 4147 Saltstone Basilisk 0.02% 4151 Saltstone Crystalhide 0.02% 4150 Saltstone Gazer 0.02% 1353 Sarltooth 0.02% 4303 Scarlet Abbot 0.02% 4296 Scarlet Adept 0.02% 4284 Scarlet Augur 0.02% 4288 Scarlet Beastmaster 0.02% 4301 Scarlet Centurion 0.02% 4302 Scarlet Champion 0.02% 4297 Scarlet Conjuror 0.02% 4298 Scarlet Defender 0.02% 4285 Scarlet Disciple 0.02% 4289 Scarlet Evoker 0.02% 4290 Scarlet Guardsman 0.02% 4282 Scarlet Magician 0.02% 4540 Scarlet Monk 0.02% 4295 Scarlet Myrmidon 0.02% 4292 Scarlet Protector 0.02% 4281 Scarlet Scout 0.02% 4293 Scarlet Scryer 0.02% 4283 Scarlet Sentry 0.02% 4286 Scarlet Soldier 0.02% 4294 Scarlet Sorcerer 0.02% 4306 Scarlet Torturer 0.02% 4300 Scarlet Wizard 0.02% 4041 Scorched Basilisk 0.02% 4696 Scorpashi Snapper 0.02% 4140 Scorpid Reaver 0.02% 4139 Scorpid Terror 0.02% 4101 Screeching Roguefeather 0.02% 4104 Screeching Windcaller 0.02% 3801 Severed Sleeper 0.02% 2742 Shadowforge Chanter 0.02% 2740 Shadowforge Darkweaver 0.02% 4846 Shadowforge Digger 0.02% 4845 Shadowforge Ruffian 0.02% 4844 Shadowforge Surveyor 0.02% 2739 Shadowforge Tunneler 0.02% 684 Shadowmaw Panther 0.02% 4861 Shrike Bat 0.02% 4133 Silithid Hive Drone 0.02% 4130 Silithid Searcher 0.02% 787 Skeletal Healer 0.02% 1110 Skeletal Raider 0.02% 785 Skeletal Warder 0.02% 780 Skullsplitter Mystic 0.02% 667 Skullsplitter Warrior 0.02% 4714 Slitherblade Myrmidon 0.02% 4711 Slitherblade Naga 0.02% 4718 Slitherblade Oracle 0.02% 4715 Slitherblade Razortail 0.02% 2408 Snapjaw 0.02% 1152 Snapjaw Crocilisk 0.02% 4143 Sparkleshell Snapper 0.02% 892 Splinter Fist Taskmaster 0.02% 212 Splinter Fist Warrior 0.02% 315 Stalvan Mistmantle 0.02% 2829 Starving Buzzard 0.02% 4856 Stonevault Cave Hunter 0.02% 4850 Stonevault Cave Lurker 0.02% 4852 Stonevault Oracle 0.02% 4851 Stonevault Rockchewer 0.02% 685 Stranglethorn Raptor 0.02% 682 Stranglethorn Tiger 0.02% 772 Stranglethorn Tigress 0.02% 2584 Stromgarde Defender 0.02% 2583 Stromgarde Troll Hunter 0.02% 2590 Syndicate Conjuror 0.02% 2240 Syndicate Footpad 0.02% 2586 Syndicate Highwayman 0.02% 2591 Syndicate Magus 0.02% 2589 Syndicate Mercenary 0.02% 2587 Syndicate Pathstalker 0.02% 2588 Syndicate Prowler 0.02% 2241 Syndicate Thief 0.02% 2319 Syndicate Wizard 0.02% 2762 Thundering Exile 0.02% 2376 Torn Fin Oracle 0.02% 2377 Torn Fin Tidehunter 0.02% 4814 Twilight Elementalist 0.02% 4813 Twilight Shadowmage 0.02% 4308 Unfettered Spirit 0.02% 4118 Venomous Cloud Serpent 0.02% 1096 Venture Co. Geologist 0.02% 1097 Venture Co. Mechanic 0.02% 677 Venture Co. Tinkerer 0.02% 5616 Wastewander Thief 0.02% 2554 Witherbark Axe Thrower 0.02% 2558 Witherbark Berserker 0.02% 2556 Witherbark Headhunter 0.02% 2649 Witherbark Scalper 0.02% 2557 Witherbark Shadow Hunter 0.02% 2555 Witherbark Witch Doctor 0.02% 3754 Xavian Betrayer 0.02% 3752 Xavian Rogue 0.02% 683 Young Panther 0.02% 1084 Young Sawtooth Crocilisk 0.02% 681 Young Stranglethorn Tiger 0.02% 4299 Scarlet Chaplain 0.01% 4096 Galak Windchaser 0.01% 3715 Wrathtail Sea Witch 0.01% 4357 Bloodfen Lashtail 0.01% 4342 Drywallow Vicejaw 0.01% 4397 Mudrock Spikeshell 0.01% 4834 Theramore Infiltrator 0.01%

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 3870);
Field Value
entry 3870
class Book
subclass Blacksmithing
name Plans: Green Iron Shoulders
description
display_id 1102
quality 2
flags 0x40: Player Cast
buy_count 1
buy_price 30s
sell_price 7s 50c
inventory_type 0: Cannot Equip
allowable_class -1
allowable_race -1
item_level 32
required_level 0
required_skill 164: Blacksmithing
required_skill_rank 160
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 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 3531: Plans: Green Iron Shoulders
spelltrigger_1 0
spellcharges_1 -1
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 0
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