General
Field | Value |
---|---|
entry | 4017 |
class | Weapon |
display_id | 5129 |
sell_price | 69s 10c |
inventory_type | 21: Weapon Main Hand |
spellid_1 | 0 |
In-game view
Sharp Shortsword
Weapon
Sword
Weapon Main Hand
Level 46 (Min 41)
20 – 39 Damage
Speed: 1.8
Buy price: 3g 45s 50c
Stackable: 1
NPCs that drop this as reference loot (285)
4393
Acidic Swamp Ooze
2.5%
1059
Ana'thek the Cruel
2.5%
2754
Anathemus
5%
1852
Araj the Summoner
5%
5270
Atal'ai Corpse Eater
5%
5271
Atal'ai Deathwalker
5%
5273
Atal'ai High Priest
5%
5269
Atal'ai Priest
5%
5256
Atal'ai Warrior
5%
5259
Atal'ai Witch Doctor
5%
4475
Blighted Zombie
2.5%
1801
Blood Wraith
5%
5346
Bloodroar the Stalker
5%
4505
Bloodsail Deckhand
2.5%
1653
Bloodsail Elder Magus
2.5%
1562
Bloodsail Mage
2.5%
1561
Bloodsail Raider
2.5%
1565
Bloodsail Sea Dog
2.5%
4506
Bloodsail Swabby
2.5%
1563
Bloodsail Swashbuckler
2.5%
1564
Bloodsail Warlock
2.5%
193
Blue Dragonspawn
5%
2944
Boss Tho'grun
2.5%
2551
Brutus
2.5%
4394
Bubbling Swamp Ooze
2.5%
2548
Captain Keelhaul
2.5%
2550
Captain Stillwater
2.5%
2782
Caretaker Alaric
5%
2780
Caretaker Nevlin
5%
2781
Caretaker Weston
5%
2537
Chucky "Ten Thumbs"
2.5%
5358
Cliff Giant
5%
5328
Coast Crawl Deepseer
2.5%
5327
Coast Crawl Snapclaw
2.5%
5466
Coast Strider
5%
1800
Cold Wraith
5%
2608
Commander Amaren
2.5%
5243
Cursed Atal'ai
5%
2937
Dagun the Ravenous
5%
769
Deathstrike Tarantula
2.5%
1813
Decaying Horror
2.5%
5467
Deep Dweller
5%
5360
Deep Strider
5%
1808
Devouring Ooze
2.5%
5345
Diamond Head
5%
5469
Dune Smasher
5%
5474
Dunemaul Brute
2.5%
5472
Dunemaul Enforcer
2.5%
5471
Dunemaul Ogre
2.5%
5473
Dunemaul Ogre Mage
2.5%
5475
Dunemaul Warlock
2.5%
2719
Dustbelcher Lord
2.5%
2717
Dustbelcher Mauler
2.5%
2720
Dustbelcher Ogre Mage
2.5%
2718
Dustbelcher Shaman
2.5%
2716
Dustbelcher Wyrmhunter
2.5%
746
Elder Dragonkin
5%
5297
Elder Rage Scar
2.5%
4469
Emerald Ooze
5%
5295
Enraged Feral Scar
2.5%
5261
Enthralled Atal'ai
5%
5292
Feral Scar Yeti
2.5%
5299
Ferocious Rage Scar
2.5%
4331
Firemane Ash Tail
5%
4334
Firemane Flamecaller
5%
4328
Firemane Scalebane
5%
4329
Firemane Scout
5%
2546
Fleet Master Firallon
2.5%
1805
Flesh Golem
5%
2601
Foulbelly
5%
2611
Fozruk
5%
1796
Freezing Ghoul
2.5%
5235
Fungal Ooze
5%
1061
Gan'zulah
2.5%
2549
Garr Salthoof
2.5%
5354
Gnarl Leafbrother
5%
5490
Gnarled Thistleshrub
2.5%
5238
Gordunni Battlemaster
2.5%
5232
Gordunni Brute
2.5%
5239
Gordunni Mage-Lord
2.5%
5234
Gordunni Mauler
2.5%
5229
Gordunni Ogre
2.5%
5237
Gordunni Ogre Mage
2.5%
5236
Gordunni Shaman
2.5%
5240
Gordunni Warlock
2.5%
5241
Gordunni Warlord
2.5%
1492
Gorlash
5%
1840
Grand Inquisitor Isillien
5%
744
Green Scalebane
5%
2655
Green Sludge
2.5%
742
Green Wyrmkin
5%
1064
Grom'gol Grunt
2.5%
5334
Hatecrest Myrmidon
2.5%
5335
Hatecrest Screamer
2.5%
5333
Hatecrest Serpent Guard
2.5%
5337
Hatecrest Siren
2.5%
5336
Hatecrest Sorceress
2.5%
5331
Hatecrest Warrior
2.5%
5332
Hatecrest Wave Rider
2.5%
4472
Haunting Vision
2.5%
2433
Helcular's Remains
5%
1846
High Protector Lorik
5%
1845
High Protector Tarsen
2.5%
2693
Highvale Marksman
2.5%
2691
Highvale Outrunner
2.5%
2694
Highvale Ranger
2.5%
2692
Highvale Scout
2.5%
5293
Hulking Feral Scar
2.5%
1802
Hungering Wraith
2.5%
1551
Ironjaw Basilisk
2.5%
2547
Ironpatch
2.5%
2656
Jade Ooze
2.5%
4468
Jade Sludge
5%
5320
Jademir Boughguard
5%
5317
Jademir Oracle
5%
2522
Jaguero Stalker
2.5%
2536
Jon-Jon the Crow
2.5%
5401
Kazkaz the Unholy
5%
5402
Khan Hratha
5%
1559
King Mukla
5%
5343
Lady Szallah
5%
5357
Land Walker
5%
2423
Lord Aliden Perenolde
2.5%
2541
Lord Sakrasis
5%
818
Mai'Zoth
5%
751
Marsh Flesheater
2.5%
750
Marsh Inkspewer
2.5%
747
Marsh Murloc
2.5%
752
Marsh Oracle
2.5%
2535
Maury "Club Foot" Wilkins
2.5%
1434
Menethil Sentry
2.5%
1081
Mire Lord
2.5%
1060
Mogh the Undying
5%
1493
Mok'rash
5%
1088
Monstrous Crawler
2.5%
723
Mosh'Ogg Butcher
5%
680
Mosh'Ogg Lord
5%
678
Mosh'Ogg Mauler
5%
679
Mosh'Ogg Shaman
5%
710
Mosh'Ogg Spellcrafter
5%
709
Mosh'Ogg Warmonger
5%
4403
Muckshell Pincer
2.5%
4405
Muckshell Razorclaw
2.5%
4404
Muckshell Scrabbler
2.5%
4402
Muckshell Snapclaw
2.5%
2257
Mug'thol
5%
5263
Mummified Atal'ai
5%
2945
Murdaloc
2.5%
1907
Naga Explorer
2.5%
1494
Negolash
40%
5277
Nightmare Scalebane
5%
5283
Nightmare Wanderer
5%
5280
Nightmare Wyrmkin
5%
5362
Northspring Harpy
2.5%
5363
Northspring Roguefeather
2.5%
5364
Northspring Slayer
2.5%
5366
Northspring Windcaller
2.5%
2928
Primitive Owlbeast
2.5%
2607
Prince Galen Trollbane
5%
2779
Prince Nazjak
5%
5296
Rage Scar Yeti
2.5%
5470
Raging Dune Smasher
5%
1045
Red Dragonspawn
5%
1047
Red Scalebane
5%
1046
Red Wyrmkin
5%
1812
Rotting Behemoth
2.5%
4474
Rotting Cadaver
2.5%
1793
Rotting Ghoul
2.5%
5646
Sandfury Axe Thrower
5%
5649
Sandfury Blood Drinker
5%
5647
Sandfury Firecaller
5%
5645
Sandfury Hideskinner
5%
5648
Sandfury Shadowcaster
5%
5650
Sandfury Witch Doctor
5%
5228
Saturated Ooze
5%
2929
Savage Owlbeast
2.5%
745
Scalebane Captain
5%
1048
Scalebane Lieutenant
5%
1050
Scalebane Royal Guard
5%
4493
Scarlet Avenger
2.5%
1836
Scarlet Cavalier
5%
1841
Scarlet Executioner
5%
1831
Scarlet Hunter
2.5%
1835
Scarlet Invoker
2.5%
1833
Scarlet Knight
2.5%
1884
Scarlet Lumberjack
2.5%
1826
Scarlet Mage
2.5%
1832
Scarlet Magus
5%
1834
Scarlet Paladin
5%
1827
Scarlet Sentinel
5%
4494
Scarlet Spellbinder
2.5%
1883
Scarlet Worker
2.5%
1795
Searing Ghoul
2.5%
768
Shadow Panther
2.5%
4849
Shadowforge Archaeologist
5%
4848
Shadowforge Darkcaster
5%
5359
Shore Strider
5%
922
Silt Crawler
2.5%
2926
Silvermane Stalker
2.5%
1789
Skeletal Acolyte
2.5%
1787
Skeletal Executioner
2.5%
1783
Skeletal Flayer
2.5%
1784
Skeletal Sorcerer
2.5%
1785
Skeletal Terror
2.5%
1788
Skeletal Warlord
5%
784
Skullsplitter Beastmaster
2.5%
783
Skullsplitter Berserker
2.5%
781
Skullsplitter Headhunter
2.5%
669
Skullsplitter Hunter
2.5%
756
Skullsplitter Panther
2.5%
782
Skullsplitter Scout
2.5%
672
Skullsplitter Spiritchaser
2.5%
670
Skullsplitter Witch Doctor
2.5%
2521
Skymane Gorilla
2.5%
1791
Slavering Ghoul
2.5%
1794
Soulless Ghoul
2.5%
2386
Southshore Guard
2.5%
863
Stonard Hunter
2.5%
864
Stonard Orc
2.5%
4857
Stone Keeper
5%
4860
Stone Steward
5%
4855
Stonevault Brawler
5%
4853
Stonevault Geomancer
5%
2894
Stonevault Shaman
2.5%
4368
Strashaz Myrmidon
5%
4366
Strashaz Serpent Guard
5%
4371
Strashaz Siren
5%
4370
Strashaz Sorceress
5%
4364
Strashaz Warrior
5%
950
Swamp Talker
2.5%
766
Tangled Horror
2.5%
2420
Targ
5%
2763
Thenan
5%
5481
Thistleshrub Dew Collector
2.5%
5485
Thistleshrub Rootshaper
2.5%
5267
Unliving Atal'ai
5%
3094
Unseen
2.5%
675
Venture Co. Foreman
2.5%
674
Venture Co. Strip Miner
2.5%
676
Venture Co. Surveyor
2.5%
677
Venture Co. Tinkerer
2.5%
5399
Veyzhak the Cannibal
5%
2927
Vicious Owlbeast
2.5%
1806
Vile Slime
2.5%
2648
Vilebranch Aman'zasi Guard
5%
2639
Vilebranch Axe Thrower
2.5%
2643
Vilebranch Berserker
5%
2646
Vilebranch Blood Drinker
5%
2641
Vilebranch Headhunter
5%
2644
Vilebranch Hideskinner
5%
4466
Vilebranch Scalper
2.5%
2645
Vilebranch Shadow Hunter
5%
2642
Vilebranch Shadowcaster
5%
4467
Vilebranch Soothsayer
2.5%
2647
Vilebranch Soul Eater
5%
4465
Vilebranch Warrior
5%
2640
Vilebranch Witch Doctor
2.5%
1804
Wailing Death
2.5%
5623
Wastewander Assassin
2.5%
5618
Wastewander Bandit
2.5%
5615
Wastewander Rogue
2.5%
5617
Wastewander Shadow Mage
2.5%
5616
Wastewander Thief
2.5%
5361
Wave Strider
5%
2654
Witherbark Caller
2.5%
2651
Witherbark Hideskinner
2.5%
2653
Witherbark Sadist
2.5%
2649
Witherbark Scalper
2.5%
2652
Witherbark Venomblood
2.5%
2650
Witherbark Zealot
2.5%
5258
Woodpaw Alpha
2.5%
5253
Woodpaw Brute
2.5%
5249
Woodpaw Mongrel
2.5%
5254
Woodpaw Mystic
2.5%
5255
Woodpaw Reaver
2.5%
5251
Woodpaw Trapper
2.5%
743
Wyrmkin Dreamwalker
5%
1049
Wyrmkin Firebrand
5%
2530
Yenniku
2.5%
1489
Zanzil Hunter
2.5%
1491
Zanzil Naga
2.5%
2534
Zanzil the Outcast
2.5%
1490
Zanzil Witch Doctor
2.5%
1488
Zanzil Zombie
2.5%
5400
Zekkis
5%
Item details
UPDATE `item_template` SET `field`
= xxxx WHERE (`entry` = 4017);
Field | Value |
---|---|
entry | 4017 |
class | Weapon |
subclass | Polearmx |
name | Sharp Shortsword |
description | |
display_id | 5129 |
quality | 0 |
flags | None |
buy_count | 1 |
buy_price | 3g 45s 50c |
sell_price | 69s 10c |
inventory_type | 21: Weapon Main Hand |
allowable_class | -1 |
allowable_race | -1 |
item_level | 46 |
required_level | 41 |
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 | 1800 |
range_mod | 0 |
ammo_type | 0 |
dmg_min1 | 20 |
dmg_max1 | 39 |
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 | 0 |
spellcategory_5 | 0 |
spellcategorycooldown_5 | 0 |
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 | 75 |
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 | 0 |
ignored | 0 |