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