Icemail Jerkin

Item

General

Item model

Field Value
entry 1981
class Armor
display_id 8668
sell_price 1g 41s 13c
inventory_type 5: Chest
spellid_1 0

In-game view

Icemail Jerkin

Item icon

Armor
Mail
Chest
Level 44 (Min 39)

+24 Spirit
+15 Stamina
+5 Agility
+10 frost resistance

118 Armor

Buy price: 7g 5s 66c

Stackable: 1

NPCs that drop this as reference loot (133)

5269 Atal'ai Priest 0.01% 5426 Blisterpaw Hyena 0% 4505 Bloodsail Deckhand 0% 1653 Bloodsail Elder Magus 0% 1561 Bloodsail Raider 0% 1565 Bloodsail Sea Dog 0% 1563 Bloodsail Swashbuckler 0% 1564 Bloodsail Warlock 0% 5459 Centipaar Tunneler 0% 5243 Cursed Atal'ai 0.01% 5474 Dunemaul Brute 0% 5472 Dunemaul Enforcer 0% 5471 Dunemaul Ogre 0% 2719 Dustbelcher Lord 0% 2717 Dustbelcher Mauler 0% 2720 Dustbelcher Ogre Mage 0% 2718 Dustbelcher Shaman 0% 1557 Elder Mistvale Gorilla 0% 5295 Enraged Feral Scar 0% 2791 Enraged Rock Elemental 0% 5261 Enthralled Atal'ai 0.01% 5292 Feral Scar Yeti 0% 5299 Ferocious Rage Scar 0% 5429 Fire Roc 0% 4334 Firemane Flamecaller 0.01% 4328 Firemane Scalebane 0.01% 4329 Firemane Scout 0.01% 5300 Frayfeather Hippogryph 0% 5305 Frayfeather Skystormer 0% 5304 Frayfeather Stagwing 0% 5235 Fungal Ooze 0.01% 5419 Glasshide Basilisk 0% 5420 Glasshide Gazer 0% 5238 Gordunni Battlemaster 0% 5232 Gordunni Brute 0% 5239 Gordunni Mage-Lord 0% 5234 Gordunni Mauler 0% 5237 Gordunni Ogre Mage 0% 5236 Gordunni Shaman 0% 5240 Gordunni Warlock 0% 5241 Gordunni Warlord 0% 1492 Gorlash 0.01% 2736 Greater Rock Elemental 0% 2655 Green Sludge 0% 5272 Grizzled Ironfur Bear 0% 5260 Groddoc Ape 0% 5334 Hatecrest Myrmidon 0% 5335 Hatecrest Screamer 0% 5333 Hatecrest Serpent Guard 0% 5337 Hatecrest Siren 0% 5336 Hatecrest Sorceress 0% 5331 Hatecrest Warrior 0% 5332 Hatecrest Wave Rider 0% 5452 Hazzali Worker 0% 2693 Highvale Marksman 0% 2694 Highvale Ranger 0% 2692 Highvale Scout 0% 5293 Hulking Feral Scar 0% 5268 Ironfur Bear 0% 1551 Ironjaw Basilisk 0% 2656 Jade Ooze 0% 687 Jungle Stalker 0% 5465 Land Rager 0% 5287 Longtooth Howler 0% 5286 Longtooth Runner 0% 2923 Mangy Silvermane 0% 751 Marsh Flesheater 0% 750 Marsh Inkspewer 0% 752 Marsh Oracle 0% 1088 Monstrous Crawler 0% 678 Mosh'Ogg Mauler 0.01% 679 Mosh'Ogg Shaman 0.01% 710 Mosh'Ogg Spellcrafter 0.01% 709 Mosh'Ogg Warmonger 0.01% 5263 Mummified Atal'ai 0.01% 5224 Murk Slitherer 0.01% 5225 Murk Spitter 0.01% 1907 Naga Explorer 0% 2928 Primitive Owlbeast 0% 5296 Rage Scar Yeti 0% 5646 Sandfury Axe Thrower 0.01% 5649 Sandfury Blood Drinker 0.01% 5647 Sandfury Firecaller 0.01% 5645 Sandfury Hideskinner 0.01% 5648 Sandfury Shadowcaster 0.01% 5650 Sandfury Witch Doctor 0.01% 2929 Savage Owlbeast 0% 2725 Scalding Whelp 0% 1552 Scale Belly 0.01% 745 Scalebane Captain 0.01% 2726 Scorched Guardian 0.01% 5424 Scorpid Dunestalker 0% 5423 Scorpid Tail Lasher 0% 5462 Sea Spray 0% 1558 Silverback Patriarch 0% 2925 Silvermane Howler 0% 2924 Silvermane Wolf 0% 783 Skullsplitter Berserker 0% 781 Skullsplitter Headhunter 0% 672 Skullsplitter Spiritchaser 0% 5278 Sprite Darter 0% 5425 Starving Blisterpaw 0% 4857 Stone Keeper 0.01% 4860 Stone Steward 0.01% 4855 Stonevault Brawler 0.01% 4853 Stonevault Geomancer 0.01% 2763 Thenan 0.01% 5481 Thistleshrub Dew Collector 0% 2639 Vilebranch Axe Thrower 0% 2641 Vilebranch Headhunter 0.01% 4467 Vilebranch Soothsayer 0% 4465 Vilebranch Warrior 0.01% 2680 Vilebranch Wolf Pup 0% 5623 Wastewander Assassin 0% 5618 Wastewander Bandit 0% 5615 Wastewander Rogue 0% 5617 Wastewander Shadow Mage 0% 2686 Witherbark Broodguard 0% 2654 Witherbark Caller 0% 2651 Witherbark Hideskinner 0% 2653 Witherbark Sadist 0% 2652 Witherbark Venomblood 0% 2650 Witherbark Zealot 0% 5253 Woodpaw Brute 0% 5254 Woodpaw Mystic 0% 5255 Woodpaw Reaver 0% 5251 Woodpaw Trapper 0% 1489 Zanzil Hunter 0% 1488 Zanzil Zombie 0% 5244 Zukk'ash Stinger 0% 5247 Zukk'ash Tunneler 0% 5245 Zukk'ash Wasp 0% 5246 Zukk'ash Worker 0%

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 1981);
Field Value
entry 1981
class Armor
subclass Mail
name Icemail Jerkin
description
display_id 8668
quality 4
flags None
buy_count 1
buy_price 7g 5s 66c
sell_price 1g 41s 13c
inventory_type 5: Chest
allowable_class -1
allowable_race -1
item_level 44
required_level 39
required_skill 0: None
required_skill_rank 0
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 6: Spirit
stat_value1 24
stat_type2 7: Stamina
stat_value2 15
stat_type3 3: Agility
stat_value3 5
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 118
holy_res 0
fire_res 0
nature_res 0
frost_res 10
shadow_res 0
arcane_res 0
spellid_1 0
spelltrigger_1 0
spellcharges_1 0
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 5
sheath 0
random_property 0
set_id 0
max_durability 140
area_bound 0
map_bound 0
duration 0
bag_family 0
disenchant_id 61
food_type 0
min_money_loot 0
max_money_loot 0
extra_flags 0
ignored 0