Plans: Portable Bronze Mortar

Item

General

Item model

Field Value
entry 4414
class Book
display_id 1102
sell_price 4s 62c
inventory_type 0: Cannot Equip
spellid_1 4032: Plans: Portable Bronze Mortar

In-game view

Plans: Portable Bronze Mortar

Item icon

Book
Cannot Equip
Level 33
Requires Engineering (165)

Casts:
4032: Plans: Portable Bronze Mortar

Buy price: 18s 50c

Stackable: 1

Item dropped by (335)

3984 Nancy Vishas 0.2% 235 Salma Saldean 0.18% 503 Lord Malathrom 0.12% 4619 Geltharis 0.1% 875 Saltscale Tide Lord 0.08% 4541 Blood of Agamaggan 0.06% 412 Stitches 0.06% 4978 Aku'mai Servant 0.04% 1364 Balgaras the Foul 0.04% 2091 Chieftain Nek'rosh 0.04% 813 Colonel Kurzen 0.04% 2368 Daggerspine Shorestalker 0.04% 2272 Dalaran Theurgist 0.04% 1054 Dark Iron Demolitionist 0.04% 2597 Lord Falconcrest 0.04% 2599 Otto 0.04% 2411 Ricter 0.04% 4288 Scarlet Beastmaster 0.04% 4291 Scarlet Diviner 0.04% 4287 Scarlet Gallant 0.04% 4304 Scarlet Tracking Hound 0.04% 905 Sharptooth Frenzy 0.04% 4341 Drywallow Crocilisk 0.03% 4351 Bloodfen Raptor 0.02% 740 Adolescent Whelp 0.02% 4825 Aku'mai Snapjaw 0.02% 4823 Barbed Crustacean 0.02% 1716 Bazil Thredd 0.02% 4029 Blackened Ancient 0.02% 3767 Bleakheart Trickster 0.02% 4024 Bloodfury Slayer 0.02% 4027 Bloodfury Storm Witch 0.02% 694 Bloodscalp Axe Thrower 0.02% 597 Bloodscalp Berserker 0.02% 671 Bloodscalp Headhunter 0.02% 595 Bloodscalp Hunter 0.02% 701 Bloodscalp Mystic 0.02% 702 Bloodscalp Scavenger 0.02% 588 Bloodscalp Scout 0.02% 697 Bloodscalp Shaman 0.02% 587 Bloodscalp Warrior 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% 2569 Boulderfist Mauler 0.02% 2562 Boulderfist Ogre 0.02% 2570 Boulderfist Shaman 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% 2760 Burning Exile 0.02% 2830 Buzzard 0.02% 4695 Carrion Horror 0.02% 2248 Cave Yeti 0.02% 4052 Cenarion Druid 0.02% 690 Cold Eye Basilisk 0.02% 2727 Crag Coyote 0.02% 4126 Crag Stalker 0.02% 2761 Cresting Exile 0.02% 1069 Crimson Whelp 0.02% 2253 Crushridge Brute 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% 2369 Daggerspine Shorehunter 0.02% 2371 Daggerspine Siren 0.02% 2271 Dalaran Shield Guard 0.02% 2628 Dalaran Worker 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% 910 Defias Enchanter 0.02% 1715 Defias Insurgent 0.02% 4680 Doomwarder Captain 0.02% 1057 Dragonmaw Bonewarder 0.02% 1034 Dragonmaw Raider 0.02% 4693 Dread Flyer 0.02% 4692 Dread Swoop 0.02% 741 Dreaming Whelp 0.02% 2574 Drywhisker Digger 0.02% 2572 Drywhisker Kobold 0.02% 2573 Drywhisker Surveyor 0.02% 2344 Dun Garok Mountaineer 0.02% 2345 Dun Garok Rifleman 0.02% 2701 Dustbelcher Ogre 0.02% 2906 Dustbelcher Warrior 0.02% 2716 Dustbelcher Wyrmhunter 0.02% 4119 Elder Cloud Serpent 0.02% 1557 Elder Mistvale Gorilla 0.02% 2348 Elder Moss Creeper 0.02% 1019 Elder Razormaw 0.02% 2635 Elder Saltwater Crocilisk 0.02% 3818 Elder Shadowhorn Stag 0.02% 1085 Elder Stranglethorn Tiger 0.02% 4727 Elder Thunder Lizard 0.02% 2359 Elemental Slave 0.02% 2728 Feral Crag Coyote 0.02% 2385 Feral Mountain Lion 0.02% 2249 Ferocious Yeti 0.02% 1270 Fetid Corpse 0.02% 1044 Flamesnorting Whelp 0.02% 3807 Forsaken Assassin 0.02% 2721 Forsaken Bodyguard 0.02% 3806 Forsaken Infiltrator 0.02% 3804 Forsaken Intruder 0.02% 4099 Galak Marauder 0.02% 4095 Galak Mauler 0.02% 4097 Galak Stormer 0.02% 4093 Galak Wrangler 0.02% 4651 Gelkis Earthcaller 0.02% 4646 Gelkis Outrunner 0.02% 4647 Gelkis Scout 0.02% 4648 Gelkis Stamper 0.02% 4649 Gelkis Windchaser 0.02% 2831 Giant Buzzard 0.02% 2565 Giant Plains Creeper 0.02% 2089 Giant Wetlands Crocilisk 0.02% 2251 Giant Yeti 0.02% 4113 Gravelsnout Digger 0.02% 4114 Gravelsnout Forager 0.02% 4539 Greater Kraul Bat 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% 4670 Hatefury Rogue 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% 4107 Highperch Wyvern 0.02% 2269 Hillsbrad Miner 0.02% 4729 Hulking Gritjaw Basilisk 0.02% 2407 Hulking Mountain Lion 0.02% 4863 Jadespine Basilisk 0.02% 687 Jungle Stalker 0.02% 1114 Jungle Thunderer 0.02% 4636 Kolkar Battle Lord 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% 937 Kurzen Jungle Fighter 0.02% 940 Kurzen Medicine Man 0.02% 686 Lashtail Raptor 0.02% 2735 Lesser Rock Elemental 0.02% 5286 Longtooth Runner 0.02% 759 Lost One Hunter 0.02% 4681 Mage Hunter 0.02% 4645 Magram Mauler 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% 4655 Maraudine Wrangler 0.02% 2579 Mesa Buzzard 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% 2373 Mudsnout Shaman 0.02% 4457 Murkgill Forager 0.02% 4461 Murkgill Warrior 0.02% 4124 Needles Cougar 0.02% 205 Nightbane Dark Runner 0.02% 533 Nightbane Shadow Weaver 0.02% 206 Nightbane Vile Fang 0.02% 898 Nightbane Worgen 0.02% 4872 Obsidian Golem 0.02% 736 Panther 0.02% 4249 Pesterhide Snarler 0.02% 604 Plague Spreader 0.02% 2563 Plains Creeper 0.02% 4623 Quilguard Champion 0.02% 4726 Raging Thunder Lizard 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% 4523 Razorfen Groundshaker 0.02% 4436 Razorfen Quilguard 0.02% 4438 Razorfen Spearhide 0.02% 4440 Razorfen Totemic 0.02% 2732 Ridge Huntress 0.02% 2731 Ridge Stalker 0.02% 2734 Ridge Stalker Patriarch 0.02% 1150 River Crocilisk 0.02% 92 Rock Elemental 0.02% 948 Rotted One 0.02% 2592 Rumbling Exile 0.02% 4154 Salt Flats Scavenger 0.02% 4158 Salt Flats Vulture 0.02% 877 Saltscale Forager 0.02% 4147 Saltstone Basilisk 0.02% 4151 Saltstone Crystalhide 0.02% 4150 Saltstone Gazer 0.02% 1082 Sawtooth Crocilisk 0.02% 4303 Scarlet Abbot 0.02% 4296 Scarlet Adept 0.02% 4284 Scarlet Augur 0.02% 4301 Scarlet Centurion 0.02% 4302 Scarlet Champion 0.02% 4299 Scarlet Chaplain 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% 4280 Scarlet Preserver 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% 4697 Scorpashi Lasher 0.02% 4696 Scorpashi Snapper 0.02% 4699 Scorpashi Venomlash 0.02% 4140 Scorpid Reaver 0.02% 4139 Scorpid Terror 0.02% 4100 Screeching Harpy 0.02% 4101 Screeching Roguefeather 0.02% 3802 Severed Dreamer 0.02% 3803 Severed Keeper 0.02% 4846 Shadowforge Digger 0.02% 4847 Shadowforge Relic Hunter 0.02% 4845 Shadowforge Ruffian 0.02% 4844 Shadowforge Surveyor 0.02% 2739 Shadowforge Tunneler 0.02% 2743 Shadowforge Warrior 0.02% 684 Shadowmaw Panther 0.02% 4861 Shrike Bat 0.02% 4133 Silithid Hive Drone 0.02% 4131 Silithid Invader 0.02% 787 Skeletal Healer 0.02% 1110 Skeletal Raider 0.02% 696 Skullsplitter Axe Thrower 0.02% 780 Skullsplitter Mystic 0.02% 667 Skullsplitter Warrior 0.02% 4711 Slitherblade Naga 0.02% 4719 Slitherblade Sea Witch 0.02% 4712 Slitherblade Sorceress 0.02% 4713 Slitherblade Warrior 0.02% 2408 Snapjaw 0.02% 1152 Snapjaw Crocilisk 0.02% 858 Sorrow Spinner 0.02% 4144 Sparkleshell Borer 0.02% 4143 Sparkleshell Snapper 0.02% 4142 Sparkleshell Tortoise 0.02% 1487 Splinter Fist Enslaver 0.02% 892 Splinter Fist Taskmaster 0.02% 212 Splinter Fist Warrior 0.02% 4689 Starving Bonepaw 0.02% 2829 Starving Buzzard 0.02% 861 Stonard Scout 0.02% 4850 Stonevault Cave Lurker 0.02% 4852 Stonevault Oracle 0.02% 4851 Stonevault Rockchewer 0.02% 2892 Stonevault Seer 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% 767 Swamp Jaguar 0.02% 764 Swampwalker 0.02% 765 Swampwalker Elder 0.02% 2590 Syndicate Conjuror 0.02% 2240 Syndicate Footpad 0.02% 2586 Syndicate Highwayman 0.02% 2589 Syndicate Mercenary 0.02% 2587 Syndicate Pathstalker 0.02% 2588 Syndicate Prowler 0.02% 2242 Syndicate Spy 0.02% 2241 Syndicate Thief 0.02% 2319 Syndicate Wizard 0.02% 3791 Terrowulf Shadow Weaver 0.02% 4120 Thundering Boulderkin 0.02% 2762 Thundering Exile 0.02% 2376 Torn Fin Oracle 0.02% 2377 Torn Fin Tidehunter 0.02% 2657 Trained Razorbeak 0.02% 4811 Twilight Aquamancer 0.02% 4814 Twilight Elementalist 0.02% 4810 Twilight Reaver 0.02% 4813 Twilight Shadowmage 0.02% 4308 Unfettered Spirit 0.02% 1096 Venture Co. Geologist 0.02% 4260 Venture Co. Shredder 0.02% 674 Venture Co. Strip Miner 0.02% 2554 Witherbark Axe Thrower 0.02% 2556 Witherbark Headhunter 0.02% 2557 Witherbark Shadow Hunter 0.02% 2553 Witherbark Shadowcaster 0.02% 2555 Witherbark Witch Doctor 0.02% 3755 Xavian Felsworn 0.02% 3752 Xavian Rogue 0.02% 2578 Young Mesa Buzzard 0.02% 683 Young Panther 0.02% 1084 Young Sawtooth Crocilisk 0.02% 681 Young Stranglethorn Tiger 0.02% 4413 Darkfang Spider 0.02% 4519 Death's Head Seer 0.01% 4360 Mirefin Warrior 0.01% 4397 Mudrock Spikeshell 0.01% 5184 Theramore Sentry 0.01%

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 4414);
Field Value
entry 4414
class Book
subclass -1x
name Plans: Portable Bronze Mortar
description
display_id 1102
quality 2
flags 0x40: Player Cast
buy_count 1
buy_price 18s 50c
sell_price 4s 62c
inventory_type 0: Cannot Equip
allowable_class -1
allowable_race -1
item_level 33
required_level 0
required_skill 202: Engineering
required_skill_rank 165
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 4032: Plans: Portable Bronze Mortar
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 -1
spellcategory_5 0
spellcategorycooldown_5 -1
bonding 0: No bind
page_text 0
page_language 0
page_material 0
start_quest -
lock_id 0
material -1
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