Plans: Iron Shield Spike

Item

General

Item model

Field Value
entry 6044
class Book
display_id 1102
sell_price 4s 50c
inventory_type 0: Cannot Equip
spellid_1 7226: Plans: Iron Shield Spike

In-game view

Plans: Iron Shield Spike

Item icon

Book
Blacksmithing
Cannot Equip
Level 30
Requires Blacksmithing (150)

Casts:
7226: Plans: Iron Shield Spike

Buy price: 18s

Stackable: 1

Item dropped by (361)

1054 Dark Iron Demolitionist 0.1% 235 Salma Saldean 0.07% 4462 Blackrock Hunter 0.06% 4523 Razorfen Groundshaker 0.06% 4822 Snapping Crustacean 0.06% 4803 Blackfathom Oracle 0.04% 4052 Cenarion Druid 0.04% 2575 Dark Iron Supplier 0.04% 1053 Dark Iron Tunneler 0.04% 4515 Death's Head Acolyte 0.04% 4516 Death's Head Adept 0.04% 3818 Elder Shadowhorn Stag 0.04% 2403 Farmer Getz 0.04% 3476 Isha Awak 0.04% 4815 Murkshallow Snapclaw 0.04% 4522 Razorfen Dustweaver 0.04% 4437 Razorfen Warden 0.04% 4499 Rok'Alim the Pounder 0.04% 4280 Scarlet Preserver 0.04% 4281 Scarlet Scout 0.04% 3857 Shadowfang Glutton 0.04% 4814 Twilight Elementalist 0.04% 3992 Venture Co. Engineer 0.04% 1097 Venture Co. Mechanic 0.04% 4004 Windshear Overlord 0.04% 4096 Galak Windchaser 0.03% 3715 Wrathtail Sea Witch 0.03% 4978 Aku'mai Servant 0.03% 740 Adolescent Whelp 0.02% 4511 Agam'ar 0.02% 4824 Aku'mai Fisher 0.02% 4825 Aku'mai Snapjaw 0.02% 4018 Antlered Courser 0.02% 4627 Arugal's Voidwalker 0.02% 3809 Ashenvale Bear 0.02% 3374 Bael'dun Excavator 0.02% 3378 Bael'dun Officer 0.02% 3377 Bael'dun Rifleman 0.02% 3376 Bael'dun Soldier 0.02% 4823 Barbed Crustacean 0.02% 3917 Befouled Water Elemental 0.02% 1032 Black Ooze 0.02% 628 Black Ravager 0.02% 1258 Black Ravager Mastiff 0.02% 930 Black Widow Hatchling 0.02% 4807 Blackfathom Myrmidon 0.02% 4805 Blackfathom Sea Witch 0.02% 4802 Blackfathom Tide Priestess 0.02% 435 Blackrock Champion 0.02% 4464 Blackrock Gladiator 0.02% 485 Blackrock Outrunner 0.02% 4064 Blackrock Scout 0.02% 4065 Blackrock Sentry 0.02% 436 Blackrock Shadowcaster 0.02% 4463 Blackrock Summoner 0.02% 615 Blackrock Tracker 0.02% 3771 Bleakheart Hellcaller 0.02% 3765 Bleakheart Satyr 0.02% 3767 Bleakheart Trickster 0.02% 4819 Blindlight Muckdweller 0.02% 4818 Blindlight Murloc 0.02% 4820 Blindlight Oracle 0.02% 3815 Blink Dragon 0.02% 4022 Bloodfury Harpy 0.02% 4023 Bloodfury Roguefeather 0.02% 4024 Bloodfury Slayer 0.02% 4027 Bloodfury Storm Witch 0.02% 4026 Bloodfury Windcaller 0.02% 694 Bloodscalp Axe Thrower 0.02% 595 Bloodscalp Hunter 0.02% 701 Bloodscalp Mystic 0.02% 588 Bloodscalp Scout 0.02% 697 Bloodscalp Shaman 0.02% 587 Bloodscalp Warrior 0.02% 1028 Bluegill Muckdweller 0.02% 1024 Bluegill Murloc 0.02% 1025 Bluegill Puddlejumper 0.02% 1027 Bluegill Warrior 0.02% 210 Bone Chewer 0.02% 2564 Boulderfist Enforcer 0.02% 2562 Boulderfist Ogre 0.02% 570 Brain Eater 0.02% 4666 Burning Blade Felsworn 0.02% 4664 Burning Blade Reaver 0.02% 4038 Burning Destroyer 0.02% 949 Carrion Recluse 0.02% 2248 Cave Yeti 0.02% 4051 Cenarion Botanist 0.02% 4028 Charred Ancient 0.02% 4117 Cloud Serpent 0.02% 2727 Crag Coyote 0.02% 4126 Crag Stalker 0.02% 1069 Crimson Whelp 0.02% 2253 Crushridge Brute 0.02% 2252 Crushridge Ogre 0.02% 689 Crystal Spine Basilisk 0.02% 1158 Cursed Marine 0.02% 1157 Cursed Sailor 0.02% 2582 Dabyrie Laborer 0.02% 2369 Daggerspine Shorehunter 0.02% 2371 Daggerspine Siren 0.02% 2271 Dalaran Shield Guard 0.02% 2358 Dalaran Summoner 0.02% 4062 Dark Iron Bombardier 0.02% 1051 Dark Iron Dwarf 0.02% 1052 Dark Iron Saboteur 0.02% 2337 Dark Strand Voidcaller 0.02% 4517 Death's Head Priest 0.02% 4518 Death's Head Sage 0.02% 4519 Death's Head Seer 0.02% 1707 Defias Captive 0.02% 1711 Defias Convict 0.02% 910 Defias Enchanter 0.02% 1708 Defias Inmate 0.02% 1715 Defias Insurgent 0.02% 909 Defias Night Blade 0.02% 215 Defias Night Runner 0.02% 1706 Defias Prisoner 0.02% 5056 Deviate Dreadfang 0.02% 5756 Deviate Venomwing 0.02% 1057 Dragonmaw Bonewarder 0.02% 1036 Dragonmaw Centurion 0.02% 1034 Dragonmaw Raider 0.02% 1035 Dragonmaw Swamprunner 0.02% 4692 Dread Swoop 0.02% 741 Dreaming Whelp 0.02% 2572 Drywhisker Kobold 0.02% 2344 Dun Garok Mountaineer 0.02% 2346 Dun Garok Priest 0.02% 2345 Dun Garok Rifleman 0.02% 4119 Elder Cloud Serpent 0.02% 2356 Elder Gray Bear 0.02% 2348 Elder Moss Creeper 0.02% 1019 Elder Razormaw 0.02% 1085 Elder Stranglethorn Tiger 0.02% 4799 Fallenroot Hellcaller 0.02% 4789 Fallenroot Rogue 0.02% 4788 Fallenroot Satyr 0.02% 4798 Fallenroot Shadowstalker 0.02% 3759 Felmusk Rogue 0.02% 1040 Fen Creeper 0.02% 1039 Fen Dweller 0.02% 2249 Ferocious Yeti 0.02% 1270 Fetid Corpse 0.02% 1044 Flamesnorting Whelp 0.02% 3 Flesh Eater 0.02% 2350 Forest Moss Creeper 0.02% 3808 Forsaken Dark Stalker 0.02% 3806 Forsaken Infiltrator 0.02% 3746 Foulweald Den Watcher 0.02% 3750 Foulweald Totemic 0.02% 3743 Foulweald Warrior 0.02% 4099 Galak Marauder 0.02% 4095 Galak Mauler 0.02% 4094 Galak Scout 0.02% 4093 Galak Wrangler 0.02% 3825 Ghostpaw Alpha 0.02% 3811 Giant Ashenvale Bear 0.02% 2089 Giant Wetlands Crocilisk 0.02% 2251 Giant Yeti 0.02% 4113 Gravelsnout Digger 0.02% 4111 Gravelsnout Kobold 0.02% 2351 Gray Bear 0.02% 4728 Gritjaw Basilisk 0.02% 2618 Hammerfall Peon 0.02% 4670 Hatefury Rogue 0.02% 4671 Hatefury Trickster 0.02% 3875 Haunted Servitor 0.02% 4128 Hecklefang Stalker 0.02% 1018 Highland Razormaw 0.02% 2559 Highland Strider 0.02% 4109 Highperch Consort 0.02% 4107 Highperch Wyvern 0.02% 2266 Hillsbrad Farmer 0.02% 2360 Hillsbrad Farmhand 0.02% 2268 Hillsbrad Footman 0.02% 2503 Hillsbrad Foreman 0.02% 2269 Hillsbrad Miner 0.02% 2267 Hillsbrad Peasant 0.02% 2270 Hillsbrad Sentry 0.02% 4729 Hulking Gritjaw Basilisk 0.02% 2407 Hulking Mountain Lion 0.02% 4636 Kolkar Battle Lord 0.02% 4632 Kolkar Centaur 0.02% 4634 Kolkar Mauler 0.02% 4538 Kraul Bat 0.02% 938 Kurzen Commando 0.02% 941 Kurzen Headshrinker 0.02% 686 Lashtail Raptor 0.02% 4054 Laughing Sister 0.02% 1111 Leech Stalker 0.02% 1043 Lost Whelp 0.02% 3863 Lupine Horror 0.02% 4644 Magram Marauder 0.02% 4639 Magram Outrunner 0.02% 4641 Magram Windchaser 0.02% 4640 Magram Wrangler 0.02% 4061 Mirkfallon Dryad 0.02% 4056 Mirkfallon Keeper 0.02% 1033 Monstrous Ooze 0.02% 1010 Mosshide Fenrunner 0.02% 1007 Mosshide Gnoll 0.02% 1008 Mosshide Mongrel 0.02% 1011 Mosshide Trapper 0.02% 1020 Mottled Raptor 0.02% 1023 Mottled Razormaw 0.02% 1066 Mottled Riptooth 0.02% 1021 Mottled Screecher 0.02% 1022 Mottled Scytheclaw 0.02% 2406 Mountain Lion 0.02% 2250 Mountain Yeti 0.02% 2372 Mudsnout Gnoll 0.02% 2373 Mudsnout Shaman 0.02% 4124 Needles Cougar 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% 4248 Pesterhide Hyena 0.02% 4249 Pesterhide Snarler 0.02% 604 Plague Spreader 0.02% 2563 Plains Creeper 0.02% 4012 Pridewing Wyvern 0.02% 4623 Quilguard Champion 0.02% 565 Rabid Dire Wolf 0.02% 434 Rabid Shadowhide Gnoll 0.02% 4514 Raging Agam'ar 0.02% 4531 Razorfen Beast Trainer 0.02% 4532 Razorfen Beastmaster 0.02% 4442 Razorfen Defender 0.02% 4525 Razorfen Earthbreaker 0.02% 4520 Razorfen Geomancer 0.02% 4530 Razorfen Handler 0.02% 4436 Razorfen Quilguard 0.02% 4440 Razorfen Totemic 0.02% 4435 Razorfen Warrior 0.02% 3458 Razormane Seer 0.02% 3457 Razormane Stalker 0.02% 3459 Razormane Warfrenzy 0.02% 1042 Red Whelp 0.02% 445 Redridge Alpha 0.02% 1150 River Crocilisk 0.02% 4036 Rogue Flame Spirit 0.02% 948 Rotted One 0.02% 4512 Rotting Agam'ar 0.02% 3928 Rotting Slime 0.02% 4154 Salt Flats Scavenger 0.02% 4147 Saltstone Basilisk 0.02% 4151 Saltstone Crystalhide 0.02% 4150 Saltstone Gazer 0.02% 4020 Sap Beast 0.02% 4296 Scarlet Adept 0.02% 4284 Scarlet Augur 0.02% 4288 Scarlet Beastmaster 0.02% 4299 Scarlet Chaplain 0.02% 4297 Scarlet Conjuror 0.02% 4285 Scarlet Disciple 0.02% 4291 Scarlet Diviner 0.02% 4287 Scarlet Gallant 0.02% 4282 Scarlet Magician 0.02% 4540 Scarlet Monk 0.02% 4293 Scarlet Scryer 0.02% 4283 Scarlet Sentry 0.02% 4286 Scarlet Soldier 0.02% 4306 Scarlet Torturer 0.02% 4304 Scarlet Tracking Hound 0.02% 4041 Scorched Basilisk 0.02% 4696 Scorpashi Snapper 0.02% 4140 Scorpid Reaver 0.02% 4100 Screeching Harpy 0.02% 4101 Screeching Roguefeather 0.02% 4104 Screeching Windcaller 0.02% 819 Servant of Ilgalar 0.02% 3803 Severed Keeper 0.02% 3782 Shadethicket Stone Mover 0.02% 3855 Shadowfang Darksoul 0.02% 3859 Shadowfang Ragetooth 0.02% 4846 Shadowforge Digger 0.02% 4844 Shadowforge Surveyor 0.02% 2739 Shadowforge Tunneler 0.02% 579 Shadowhide Assassin 0.02% 432 Shadowhide Brute 0.02% 429 Shadowhide Darkweaver 0.02% 433 Shadowhide Gnoll 0.02% 431 Shadowhide Slayer 0.02% 568 Shadowhide Warrior 0.02% 3817 Shadowhorn Stag 0.02% 200 Shambling Skeleton 0.02% 3250 Silithid Creeper 0.02% 4133 Silithid Hive Drone 0.02% 4131 Silithid Invader 0.02% 4130 Silithid Searcher 0.02% 4042 Singed Basilisk 0.02% 725 Skeletal Enforcer 0.02% 531 Skeletal Fiend 0.02% 202 Skeletal Horror 0.02% 203 Skeletal Mage 0.02% 1110 Skeletal Raider 0.02% 785 Skeletal Warder 0.02% 48 Skeletal Warrior 0.02% 4821 Skittering Crustacean 0.02% 4714 Slitherblade Myrmidon 0.02% 4718 Slitherblade Oracle 0.02% 2408 Snapjaw 0.02% 2529 Son of Arugal 0.02% 4143 Sparkleshell Snapper 0.02% 4142 Sparkleshell Tortoise 0.02% 1251 Splinter Fist Firemonger 0.02% 889 Splinter Fist Ogre 0.02% 892 Splinter Fist Taskmaster 0.02% 212 Splinter Fist Warrior 0.02% 2384 Starving Mountain Lion 0.02% 3238 Stormhide 0.02% 682 Stranglethorn Tiger 0.02% 2590 Syndicate Conjuror 0.02% 2586 Syndicate Highwayman 0.02% 2589 Syndicate Mercenary 0.02% 2587 Syndicate Pathstalker 0.02% 2260 Syndicate Rogue 0.02% 2244 Syndicate Shadow Mage 0.02% 2242 Syndicate Spy 0.02% 2261 Syndicate Watchman 0.02% 3791 Terrowulf Shadow Weaver 0.02% 3925 Thistlefur Avenger 0.02% 3921 Thistlefur Ursa 0.02% 3424 Thunderhawk Cloudscraper 0.02% 3873 Tormented Officer 0.02% 2375 Torn Fin Coastrunner 0.02% 2374 Torn Fin Muckdweller 0.02% 2376 Torn Fin Oracle 0.02% 2377 Torn Fin Tidehunter 0.02% 4809 Twilight Acolyte 0.02% 4811 Twilight Aquamancer 0.02% 4812 Twilight Loreseeker 0.02% 4810 Twilight Reaver 0.02% 4067 Twilight Runner 0.02% 4813 Twilight Shadowmage 0.02% 4308 Unfettered Spirit 0.02% 217 Venom Web Spider 0.02% 4118 Venomous Cloud Serpent 0.02% 1096 Venture Co. Geologist 0.02% 2354 Vicious Gray Bear 0.02% 3877 Wailing Guardsman 0.02% 1400 Wetlands Crocilisk 0.02% 3819 Wildthorn Stalker 0.02% 3820 Wildthorn Venomspitter 0.02% 2554 Witherbark Axe Thrower 0.02% 2556 Witherbark Headhunter 0.02% 2552 Witherbark Troll 0.02% 2555 Witherbark Witch Doctor 0.02% 3755 Xavian Felsworn 0.02% 3757 Xavian Hellcaller 0.02% 923 Young Black Ravager 0.02% 683 Young Panther 0.02% 681 Young Stranglethorn Tiger 0.02% 1417 Young Wetlands Crocilisk 0.02% 3466 Zhevra Courser 0.02% 4057 Son of Cenarius 0.02% 4359 Mirefin Murloc 0%

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 6044);
Field Value
entry 6044
class Book
subclass Engineeringx
name Plans: Iron Shield Spike
description
display_id 1102
quality 2
flags 0x40: Player Cast
buy_count 1
buy_price 18s
sell_price 4s 50c
inventory_type 0: Cannot Equip
allowable_class -1
allowable_race -1
item_level 30
required_level 0
required_skill 164: Blacksmithing
required_skill_rank 150
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 7226: Plans: Iron Shield Spike
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