Monster - Sword, Long Basic

Item

General

Item model

Field Value
entry 1899
class Weapon
display_id 7483
sell_price 3c
inventory_type 13: Weapon
spellid_1 0

In-game view

Monster - Sword, Long Basic

Item icon

Weapon
Sword
Weapon
Level 1 (Min 1)

1 – 2 Damage

Speed: 2

Buy price: 18c

Stackable: 1

Item is equipped by (95)

68 Stormwind City Guard 197 Marshal McBride 435 Blackrock Champion 464 Guard Parker 487 Protector Bialon 663 Calor 733 Sergeant Yohwa 738 Private Thorsen 745 Scalebane Captain 751 Marsh Flesheater 793 Kara Adams 859 Guard Berton 903 Guard Howe 913 Lyria Du Lac 932 Guard Ashlock 933 Guard Hiett 934 Guard Clarke 935 Guard Pearce 936 Guard Adams 937 Kurzen Jungle Fighter 963 Deputy Rainer 1070 Deputy Feldon 1273 Grawn Thromwyn 1421 Private Merle 1423 Stormwind Guard 1434 Menethil Sentry 1475 Menethil Guard 1479 Timothy Clark 1483 Murphy West 1520 Rattlecage Soldier 1535 Scarlet Warrior 1540 Scarlet Vanguard 1570 Executor Arren 1642 Northshire Guard 1660 Scarlet Bodyguard 1667 Meven Korgal 1694 Loslor Rudge 1756 Stormwind Royal Guard 1833 Scarlet Knight 1890 Rattlecage Skeleton 1894 Pyrewood Sentry 1976 Stormwind City Patroller 2104 Captain Stoutfist 2119 Dannal Stern 2131 Austil de Mon 2386 Southshore Guard 2589 Syndicate Mercenary 2694 Highvale Ranger 2700 Captain Nials 2721 Forsaken Bodyguard 2770 Tallow 2843 Jutak 3129 Kul Tiras Marine 3169 Tarshaw Jaggedscar 3232 Bristleback Interloper 3274 Kolkar Pack Runner 3385 Theramore Marine 3394 Barak Kodobane 3414 General Twinbraid 3593 Alyissia 3712 Wrathtail Razortail 3749 Foulweald Ursa 3849 Deathstalker Adamant 3891 Teronis' Corpse 3921 Thistlefur Ursa 4171 Merelyssa 4203 Ariyell Skyshadow 4286 Scarlet Soldier 4331 Firemane Ash Tail 4442 Razorfen Defender 4600 Geoffrey Hartwell 4643 Magram Pack Runner 4714 Slitherblade Myrmidon 4921 Guard Byron 4922 Guard Edward 4923 Guard Jarad 4951 Theramore Practicing Guard 4966 Private Hendel 4972 Kagoro 4979 Theramore Guard 5044 Theramore Skirmisher 5085 Sentry Point Guard 5088 Falgran Hastil 5091 Guard Kahil 5092 Guard Lana 5093 Guard Narrisha 5094 Guard Tark 5120 Brenwyn Wintersteel 5184 Theramore Sentry 5659 Andrew Hartwell 5663 Travist Bosk 5664 Eldin Partridge 5665 Alyssa Blaye 5668 Mattie Alred 5695 Vance Undergloom

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 1899);
Field Value
entry 1899
class Weapon
subclass Polearmx
name Monster - Sword, Long Basic
description
display_id 7483
quality 0
flags None
buy_count 1
buy_price 18c
sell_price 3c
inventory_type 13: 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 3
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