General
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
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 | Engineeringx |
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 |