Plans: Jade Serpentblade

Item

General

Item model

Field Value
entry 3866
class Book
display_id 1102
sell_price 10s
inventory_type 0: Cannot Equip
spellid_1 3526: Plans: Jade Serpentblade

In-game view

Plans: Jade Serpentblade

Item icon

Book
Blacksmithing
Cannot Equip
Level 35
Requires Blacksmithing (175)

Casts:
3526: Plans: Jade Serpentblade

Buy price: 40s

Stackable: 1

Item dropped by (321)

412 Stitches 0.18% 235 Salma Saldean 0.13% 2597 Lord Falconcrest 0.12% 4619 Geltharis 0.1% 1364 Balgaras the Foul 0.08% 3985 Grandpa Vishas 0.08% 4427 Ward Guardian 0.08% 5622 Ongeku 0.06% 1097 Venture Co. Mechanic 0.06% 1054 Dark Iron Demolitionist 0.04% 2421 Muckrake 0.04% 4531 Razorfen Beast Trainer 0.04% 4296 Scarlet Adept 0.04% 4291 Scarlet Diviner 0.04% 4283 Scarlet Sentry 0.04% 3784 Shadethicket Bark Ripper 0.04% 4718 Slitherblade Oracle 0.04% 4689 Starving Bonepaw 0.04% 2553 Witherbark Shadowcaster 0.04% 4413 Darkfang Spider 0.03% 5477 Noboru the Cudgel 0.03% 4404 Muckshell Scrabbler 0.03% 4519 Death's Head Seer 0.02% 740 Adolescent Whelp 0.02% 4700 Aged Kodo 0.02% 4825 Aku'mai Snapjaw 0.02% 2318 Argus Shadow Mage 0.02% 3378 Bael'dun Officer 0.02% 3771 Bleakheart Hellcaller 0.02% 3770 Bleakheart Shadowstalker 0.02% 3767 Bleakheart Trickster 0.02% 4541 Blood of Agamaggan 0.02% 4023 Bloodfury Roguefeather 0.02% 4024 Bloodfury Slayer 0.02% 1562 Bloodsail Mage 0.02% 1561 Bloodsail Raider 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% 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% 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% 949 Carrion Recluse 0.02% 2248 Cave Yeti 0.02% 4052 Cenarion Druid 0.02% 2727 Crag Coyote 0.02% 2761 Cresting Exile 0.02% 2253 Crushridge Brute 0.02% 2256 Crushridge Enforcer 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% 2369 Daggerspine Shorehunter 0.02% 2371 Daggerspine Siren 0.02% 2358 Dalaran Summoner 0.02% 1051 Dark Iron Dwarf 0.02% 1052 Dark Iron Saboteur 0.02% 1053 Dark Iron Tunneler 0.02% 4515 Death's Head Acolyte 0.02% 4516 Death's Head Adept 0.02% 4517 Death's Head Priest 0.02% 1715 Defias Insurgent 0.02% 909 Defias Night Blade 0.02% 1057 Dragonmaw Bonewarder 0.02% 1034 Dragonmaw Raider 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% 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% 3762 Felmusk Felsworn 0.02% 3759 Felmusk Rogue 0.02% 3758 Felmusk Satyr 0.02% 2249 Ferocious Yeti 0.02% 1270 Fetid Corpse 0.02% 1159 First Mate Snellig 0.02% 1044 Flamesnorting Whelp 0.02% 2721 Forsaken Bodyguard 0.02% 3804 Forsaken Intruder 0.02% 4095 Galak Mauler 0.02% 4093 Galak Wrangler 0.02% 4651 Gelkis Earthcaller 0.02% 4646 Gelkis Outrunner 0.02% 4649 Gelkis Windchaser 0.02% 3825 Ghostpaw Alpha 0.02% 2565 Giant Plains Creeper 0.02% 2089 Giant Wetlands Crocilisk 0.02% 2251 Giant Yeti 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% 4670 Hatefury Rogue 0.02% 4674 Hatefury Shadowstalker 0.02% 4671 Hatefury Trickster 0.02% 2561 Highland Fleshstalker 0.02% 1018 Highland Razormaw 0.02% 2559 Highland Strider 0.02% 2560 Highland Thrasher 0.02% 4109 Highperch Consort 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% 4863 Jadespine Basilisk 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% 4635 Kolkar Windchaser 0.02% 4538 Kraul Bat 0.02% 2474 Kurdros 0.02% 938 Kurzen Commando 0.02% 941 Kurzen Headshrinker 0.02% 937 Kurzen Jungle Fighter 0.02% 940 Kurzen Medicine Man 0.02% 943 Kurzen Wrangler 0.02% 686 Lashtail Raptor 0.02% 4676 Lesser Infernal 0.02% 2735 Lesser Rock Elemental 0.02% 5286 Longtooth Runner 0.02% 757 Lost One Fisherman 0.02% 760 Lost One Muckdweller 0.02% 4681 Mage Hunter 0.02% 4644 Magram Marauder 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% 2579 Mesa Buzzard 0.02% 1108 Mistvale Gorilla 0.02% 1033 Monstrous Ooze 0.02% 522 Mor'Ladim 0.02% 1142 Mosh'Ogg Brute 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% 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% 4248 Pesterhide Hyena 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% 4532 Razorfen Beastmaster 0.02% 4442 Razorfen Defender 0.02% 4523 Razorfen Groundshaker 0.02% 4436 Razorfen Quilguard 0.02% 4440 Razorfen Totemic 0.02% 2411 Ricter 0.02% 2732 Ridge Huntress 0.02% 2731 Ridge Stalker 0.02% 1150 River Crocilisk 0.02% 92 Rock Elemental 0.02% 948 Rotted One 0.02% 4512 Rotting Agam'ar 0.02% 2592 Rumbling Exile 0.02% 4154 Salt Flats Scavenger 0.02% 4158 Salt Flats Vulture 0.02% 879 Saltscale Hunter 0.02% 4147 Saltstone Basilisk 0.02% 4151 Saltstone Crystalhide 0.02% 4150 Saltstone Gazer 0.02% 1151 Saltwater Crocilisk 0.02% 1082 Sawtooth Crocilisk 0.02% 4303 Scarlet Abbot 0.02% 4284 Scarlet Augur 0.02% 4288 Scarlet Beastmaster 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% 4287 Scarlet Gallant 0.02% 4290 Scarlet Guardsman 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% 4286 Scarlet Soldier 0.02% 4294 Scarlet Sorcerer 0.02% 4306 Scarlet Torturer 0.02% 4304 Scarlet Tracking Hound 0.02% 4300 Scarlet Wizard 0.02% 4697 Scorpashi Lasher 0.02% 4696 Scorpashi Snapper 0.02% 5422 Scorpid Hunter 0.02% 4140 Scorpid Reaver 0.02% 4139 Scorpid Terror 0.02% 4100 Screeching Harpy 0.02% 4101 Screeching Roguefeather 0.02% 3803 Severed Keeper 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% 2743 Shadowforge Warrior 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% 780 Skullsplitter Mystic 0.02% 667 Skullsplitter Warrior 0.02% 4714 Slitherblade Myrmidon 0.02% 4712 Slitherblade Sorceress 0.02% 4713 Slitherblade Warrior 0.02% 2408 Snapjaw 0.02% 1152 Snapjaw Crocilisk 0.02% 4144 Sparkleshell Borer 0.02% 4143 Sparkleshell Snapper 0.02% 4142 Sparkleshell Tortoise 0.02% 1487 Splinter Fist Enslaver 0.02% 212 Splinter Fist Warrior 0.02% 2893 Stonevault Bonesnapper 0.02% 4850 Stonevault Cave Lurker 0.02% 4852 Stonevault Oracle 0.02% 4851 Stonevault Rockchewer 0.02% 2894 Stonevault Shaman 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% 2585 Stromgarde Vindicator 0.02% 767 Swamp Jaguar 0.02% 2246 Syndicate Assassin 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% 2242 Syndicate Spy 0.02% 2319 Syndicate Wizard 0.02% 4120 Thundering Boulderkin 0.02% 2762 Thundering Exile 0.02% 2375 Torn Fin Coastrunner 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% 4118 Venomous Cloud Serpent 0.02% 1096 Venture Co. Geologist 0.02% 1094 Venture Co. Miner 0.02% 674 Venture Co. Strip Miner 0.02% 5616 Wastewander Thief 0.02% 3821 Wildthorn Lurker 0.02% 2554 Witherbark Axe Thrower 0.02% 2556 Witherbark Headhunter 0.02% 2649 Witherbark Scalper 0.02% 2557 Witherbark Shadow Hunter 0.02% 2555 Witherbark Witch Doctor 0.02% 5249 Woodpaw Mongrel 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% 4379 Darkmist Silkspinner 0.02% 2581 Dabyrie Militia 0.02% 4343 Drywallow Snapper 0.01% 4539 Greater Kraul Bat 0.01% 4376 Darkmist Spider 0.01% 4352 Bloodfen Screecher 0.01%

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 3866);
Field Value
entry 3866
class Book
subclass Engineeringx
name Plans: Jade Serpentblade
description
display_id 1102
quality 2
flags 0x40: Player Cast
buy_count 1
buy_price 40s
sell_price 10s
inventory_type 0: Cannot Equip
allowable_class -1
allowable_race -1
item_level 35
required_level 0
required_skill 164: Blacksmithing
required_skill_rank 175
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 3526: Plans: Jade Serpentblade
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