General
| Field | Value |
|---|---|
| entry | 3687 |
| class | Weapon |
| display_id | 3092 |
| sell_price | 5g 77s 18c |
| inventory_type | 17: Two Handed Weapon |
| spellid_1 | 172: Corruption |
In-game view
Unholy Avenger
Weapon
Twohanded sword
Two Handed Weapon
Level 40 (Min 35)
97 – 146 Damage
Speed: 3
Casts:
172: Corruption
3140: Fireball
1096: Firebolt IV
Buy price: 28g 85s 92c
Stackable: 1
Item dropped by (1)
Item details
UPDATE `item_template` SET `field`
= xxxx WHERE (`entry` = 3687);
| Field | Value |
|---|---|
| entry | 3687 |
| class | Weapon |
| subclass | Swordx |
| name | Unholy Avenger |
| description | |
| display_id | 3092 |
| quality | 6 |
| flags | None |
| buy_count | 1 |
| buy_price | 28g 85s 92c |
| sell_price | 5g 77s 18c |
| inventory_type | 17: Two Handed Weapon |
| allowable_class | -1 |
| allowable_race | -1 |
| item_level | 40 |
| required_level | 35 |
| 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 | 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 | 3000 |
| range_mod | 0 |
| ammo_type | 0 |
| dmg_min1 | 97 |
| dmg_max1 | 146 |
| 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 | 172: Corruption |
| spelltrigger_1 | 2 |
| spellcharges_1 | 0 |
| spellppmrate_1 | 0 |
| spellcooldown_1 | -1 |
| spellcategory_1 | 0 |
| spellcategorycooldown_1 | -1 |
| spellid_2 | 3140: Fireball |
| spelltrigger_2 | 2 |
| spellcharges_2 | 0 |
| spellppmrate_2 | 0 |
| spellcooldown_2 | -1 |
| spellcategory_2 | 0 |
| spellcategorycooldown_2 | -1 |
| spellid_3 | 1096: Firebolt IV |
| spelltrigger_3 | 2 |
| 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 | 1 |
| 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 | 0x4 |
| ignored | 0 |