Night Watch Shortsword

Item

General

Item model

Field Value
entry 935
class Weapon
display_id 8274
sell_price 26s 4c
inventory_type 13: Weapon
spellid_1 0

In-game view

Night Watch Shortsword

Item icon

Weapon
Sword
Weapon
Level 23 (Min 13)

38 – 47 Damage

Speed: 2.6

Buy price: 1g 30s 20c

Stackable: 1

NPCs that drop this as reference loot (201)

4018 Antlered Courser 0.01% 3809 Ashenvale Bear 0.01% 3374 Bael'dun Excavator 0.01% 3375 Bael'dun Foreman 0.01% 3376 Bael'dun Soldier 0.01% 3236 Barrens Kodo 0.01% 3917 Befouled Water Elemental 0.01% 1393 Berserk Trogg 0.01% 1032 Black Ooze 0.01% 1030 Black Slime 0.01% 4044 Blackened Basilisk 0.01% 4807 Blackfathom Myrmidon 0.03% 4803 Blackfathom Oracle 0.03% 4805 Blackfathom Sea Witch 0.03% 4802 Blackfathom Tide Priestess 0.03% 435 Blackrock Champion 0.01% 440 Blackrock Grunt 0.01% 4462 Blackrock Hunter 0.03% 485 Blackrock Outrunner 0.01% 437 Blackrock Renegade 0.01% 4064 Blackrock Scout 0.03% 4065 Blackrock Sentry 0.03% 436 Blackrock Shadowcaster 0.03% 4463 Blackrock Summoner 0.01% 615 Blackrock Tracker 0.01% 2171 Blackwood Shaman 0.01% 4818 Blindlight Murloc 0.03% 4025 Bloodfury Ambusher 0.01% 4022 Bloodfury Harpy 0.01% 1026 Bluegill Forager 0.01% 1028 Bluegill Muckdweller 0.01% 1024 Bluegill Murloc 0.01% 1025 Bluegill Puddlejumper 0.01% 3263 Bristleback Geomancer 0.01% 3393 Captain Fairmount 0.01% 4040 Cave Stalker 0.01% 4051 Cenarion Botanist 0.01% 1210 Chok'sul 0.03% 3812 Clattering Crawler 0.01% 5683 Comar Villard 0.01% 1889 Dalaran Wizard 0.01% 3879 Dark Strand Assassin 0.01% 3727 Dark Strand Enforcer 0.01% 3730 Dark Strand Excavator 0.01% 4006 Deepmoss Webspinner 0.01% 636 Defias Blackguard 0.03% 1707 Defias Captive 0.03% 1711 Defias Convict 0.03% 1708 Defias Inmate 0.03% 657 Defias Pirate 0.03% 1706 Defias Prisoner 0.03% 1732 Defias Squallshaper 0.03% 5056 Deviate Dreadfang 0.03% 5756 Deviate Venomwing 0.03% 5755 Deviate Viper 0.03% 2102 Dragonmaw Grunt 0.01% 2103 Dragonmaw Scout 0.01% 2233 Encrusted Tide Crawler 0.01% 4799 Fallenroot Hellcaller 0.03% 4789 Fallenroot Rogue 0.03% 4788 Fallenroot Satyr 0.03% 4798 Fallenroot Shadowstalker 0.03% 3864 Fel Steed 0.03% 3774 Felslayer 0.01% 1039 Fen Dweller 0.01% 626 Foreman Thistlenettle 0.03% 2350 Forest Moss Creeper 0.01% 3734 Forsaken Thug 0.01% 3750 Foulweald Totemic 0.01% 3743 Foulweald Warrior 0.01% 4096 Galak Windchaser 0.01% 3619 Ghost Saber 0.01% 3824 Ghostpaw Howler 0.01% 3823 Ghostpaw Runner 0.01% 1259 Gobbler 0.01% 3947 Goblin Shipbuilder 0.03% 2351 Gray Bear 0.01% 505 Greater Tarantula 0.01% 3249 Greater Thunderhawk 0.01% 569 Green Recluse 0.01% 2208 Greymist Tidehunter 0.01% 3875 Haunted Servitor 0.03% 4128 Hecklefang Stalker 0.01% 1015 Highland Raptor 0.01% 2266 Hillsbrad Farmer 0.01% 2360 Hillsbrad Farmhand 0.01% 3436 Kuz 0.01% 1111 Leech Stalker 0.01% 3863 Lupine Horror 0.03% 1180 Mo'grosh Brute 0.03% 1183 Mo'grosh Mystic 0.03% 2071 Moonstalker Matriarch 0.01% 1010 Mosshide Fenrunner 0.01% 1007 Mosshide Gnoll 0.01% 1009 Mosshide Mistweaver 0.01% 1008 Mosshide Mongrel 0.01% 1011 Mosshide Trapper 0.01% 1020 Mottled Raptor 0.01% 4815 Murkshallow Snapclaw 0.03% 544 Murloc Nightcrawler 0.01% 578 Murloc Scout 0.01% 545 Murloc Tidecaller 0.01% 3721 Mystlash Hydra 0.01% 3434 Nak 0.01% 1225 Ol' Sooty 0.03% 391 Old Murk-Eye 0.01% 4014 Pridewing Consort 0.01% 4013 Pridewing Skyhunter 0.01% 4012 Pridewing Wyvern 0.01% 565 Rabid Dire Wolf 0.01% 434 Rabid Shadowhide Gnoll 0.01% 2236 Raging Reef Crawler 0.01% 1974 Ravenclaw Drudger 0.01% 1973 Ravenclaw Guardian 0.01% 2283 Ravenclaw Regent 0.05% 3456 Razormane Pathfinder 0.01% 3458 Razormane Seer 0.01% 3457 Razormane Stalker 0.01% 1042 Red Whelp 0.01% 445 Redridge Alpha 0.01% 446 Redridge Basher 0.01% 580 Redridge Drudger 0.01% 4036 Rogue Flame Spirit 0.01% 1944 Rot Hide Bruiser 0.05% 3928 Rotting Slime 0.01% 235 Salma Saldean 0.01% 3740 Saltspittle Muckdweller 0.01% 3742 Saltspittle Oracle 0.01% 3737 Saltspittle Puddlejumper 0.01% 3739 Saltspittle Warrior 0.01% 4020 Sap Beast 0.01% 3452 Serena Bloodfeather 0.01% 3780 Shadethicket Moss Eater 0.01% 3783 Shadethicket Raincaller 0.01% 3865 Shadow Charger 0.03% 3855 Shadowfang Darksoul 0.03% 3857 Shadowfang Glutton 0.03% 3853 Shadowfang Moonwalker 0.03% 3859 Shadowfang Ragetooth 0.03% 3854 Shadowfang Wolfguard 0.03% 432 Shadowhide Brute 0.01% 433 Shadowhide Gnoll 0.01% 568 Shadowhide Warrior 0.01% 3817 Shadowhorn Stag 0.01% 200 Shambling Skeleton 0.01% 2054 Sickly Refugee 0.01% 3250 Silithid Creeper 0.01% 3251 Silithid Grub 0.01% 3252 Silithid Swarmer 0.01% 202 Skeletal Horror 0.01% 203 Skeletal Mage 0.01% 48 Skeletal Warrior 0.01% 4821 Skittering Crustacean 0.03% 2529 Son of Arugal 0.03% 3814 Spined Crawler 0.01% 213 Starving Dire Wolf 0.01% 2384 Starving Mountain Lion 0.01% 2157 Stone Behemoth 0.01% 3238 Stormhide 0.01% 2182 Stormscale Sorceress 0.01% 2183 Stormscale Warrior 0.01% 2172 Strider Clutchmother 0.05% 2260 Syndicate Rogue 0.01% 2244 Syndicate Shadow Mage 0.01% 2261 Syndicate Watchman 0.01% 3925 Thistlefur Avenger 0.01% 3923 Thistlefur Den Watcher 0.01% 3926 Thistlefur Pathfinder 0.01% 3924 Thistlefur Shaman 0.01% 3922 Thistlefur Totemic 0.01% 3921 Thistlefur Ursa 0.01% 3424 Thunderhawk Cloudscraper 0.01% 3247 Thunderhawk Hatchling 0.01% 3239 Thunderhead 0.01% 4811 Twilight Aquamancer 0.03% 4067 Twilight Runner 0.01% 217 Venom Web Spider 0.01% 4070 Venture Co. Builder 0.01% 3991 Venture Co. Deforester 0.01% 3992 Venture Co. Engineer 0.01% 3993 Venture Co. Machine Smith 0.01% 3988 Venture Co. Operator 0.01% 2354 Vicious Gray Bear 0.01% 1908 Vile Fin Oracle 0.01% 3877 Wailing Guardsman 0.03% 1400 Wetlands Crocilisk 0.01% 3819 Wildthorn Stalker 0.01% 3999 Windshear Digger 0.01% 4003 Windshear Geomancer 0.01% 4004 Windshear Overlord 0.01% 3998 Windshear Vermin 0.01% 3711 Wrathtail Myrmidon 0.01% 3944 Wrathtail Priestess 0.01% 3712 Wrathtail Razortail 0.01% 3715 Wrathtail Sea Witch 0.01% 4073 XT:4 0.01% 923 Young Black Ravager 0.01% 4032 Young Chimaera 0.01% 4011 Young Pridewing 0.01% 1417 Young Wetlands Crocilisk 0.01% 3466 Zhevra Courser 0.01%

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 935);
Field Value
entry 935
class Weapon
subclass Polearmx
name Night Watch Shortsword
description
display_id 8274
quality 3
flags None
buy_count 1
buy_price 1g 30s 20c
sell_price 26s 4c
inventory_type 13: Weapon
allowable_class -1
allowable_race -1
item_level 23
required_level 13
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 2600
range_mod 0
ammo_type 0
dmg_min1 38
dmg_max1 47
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 0
area_bound 0
map_bound 0
duration 0
bag_family 0
disenchant_id 41
food_type 0
min_money_loot 0
max_money_loot 0
extra_flags 0
ignored 0