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