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