General
| Field | Value |
|---|---|
| entry | 2023 |
| class | Weapon |
| display_id | 7481 |
| sell_price | 2c |
| inventory_type | 17: Two Handed Weapon |
| spellid_1 | 0 |
In-game view
Monster - Spear, Rusty
Weapon
Polearm
Two Handed Weapon
Level 1 (Min 1)
1 – 2 Damage
Speed: 2
Buy price: 14c
Stackable: 1
Item is equipped by (62)
171
Murloc Warrior
300
Zzarc' Vul
513
Murloc Netter
615
Blackrock Tracker
714
Talin Keeneye
853
Coldridge Mountaineer
861
Stonard Scout
863
Stonard Hunter
871
Saltscale Warrior
875
Saltscale Tide Lord
879
Saltscale Hunter
943
Kurzen Wrangler
1025
Bluegill Puddlejumper
1083
Murloc Shorestriker
1123
Frostmane Headhunter
1242
Karl Boran
1487
Splinter Fist Enslaver
1489
Zanzil Hunter
1545
Vile Fin Muckdweller
1768
Vile Fin Tidehunter
2181
Stormscale Myrmidon
2206
Greymist Hunter
2369
Daggerspine Shorehunter
2375
Torn Fin Coastrunner
2377
Torn Fin Tidehunter
2641
Vilebranch Headhunter
2703
Zengu
2878
Peria Lamenur
2980
Grull Hawkwind
2987
Eyahn Eagletalon
3189
Kor'ghan
3209
Brave Windfeather
3210
Brave Proudsnout
3211
Brave Lightninghorn
3212
Brave Ironhorn
3213
Brave Running Wolf
3214
Brave Greathoof
3215
Brave Strongbash
3217
Brave Dawneagle
3218
Brave Swiftwind
3219
Brave Leaping Deer
3220
Brave Darksky
3221
Brave Rockhorn
3222
Brave Wildrunner
3223
Brave Rainchaser
3224
Brave Cloudmane
3275
Kolkar Marauder
3341
Gann Stonespire
3737
Saltspittle Puddlejumper
3740
Saltspittle Muckdweller
3746
Foulweald Den Watcher
4053
Daughter of Cenarius
4080
Kaela Shadowspear
4197
Ken'zigla
4458
Murkgill Hunter
4460
Murkgill Lord
4461
Murkgill Warrior
4462
Blackrock Hunter
4639
Magram Outrunner
4983
Ogron
5334
Hatecrest Myrmidon
5600
Khan Dez'hepah
Item details
UPDATE `item_template` SET `field`
= xxxx WHERE (`entry` = 2023);
| Field | Value |
|---|---|
| entry | 2023 |
| class | Weapon |
| subclass | Two handed macex |
| name | Monster - Spear, Rusty |
| description | |
| display_id | 7481 |
| 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 |