General
| Field | Value |
|---|---|
| entry | 6680 |
| class | Weapon |
| display_id | 7978 |
| sell_price | 2c |
| inventory_type | 17: Two Handed Weapon |
| spellid_1 | 0 |
In-game view
Monster - Spear, Sharp Thin
Weapon
Polearm
Two Handed Weapon
Level 1 (Min 1)
1 – 2 Damage
Speed: 2
Buy price: 14c
Stackable: 1
Item is equipped by (17)
193
Blue Dragonspawn
1233
Shaethis Darkoak
2421
Muckrake
2743
Shadowforge Warrior
2775
Daggerspine Marauder
2995
Tal
3052
Skorn Whitecloud
3389
Regthar Deathgate
3624
Zudd
4312
Tharm
4317
Nyse
4362
Mirefin Coastrunner
4438
Razorfen Spearhide
4656
Maraudine Mauler
5283
Nightmare Wanderer
5331
Hatecrest Warrior
5394
Neeka Bloodscar
Item details
UPDATE `item_template` SET `field`
= xxxx WHERE (`entry` = 6680);
| Field | Value |
|---|---|
| entry | 6680 |
| class | Weapon |
| subclass | Polearm |
| name | Monster - Spear, Sharp Thin |
| description | |
| display_id | 7978 |
| quality | 0 |
| flags | None |
| buy_count | 1 |
| buy_price | 14c |
| sell_price | 2c |
| inventory_type | 17: Two Handed Weapon |
| allowable_class | -1 |
| allowable_race | -1 |
| item_level | 1 |
| required_level | 1 |
| 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 | 2000 |
| range_mod | 0 |
| ammo_type | 0 |
| dmg_min1 | 1 |
| dmg_max1 | 2 |
| 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 | 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 | -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 | 2 |
| random_property | 0 |
| set_id | 0 |
| max_durability | 20 |
| 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 |