BKP "Sparrow" Smallbore

Item

General

Item model

Field Value
entry 3042
class Weapon
display_id 6591
sell_price 45s 77c
inventory_type 26: Ranged Right
spellid_1 0

In-game view

BKP "Sparrow" Smallbore

Item icon

Weapon
Gun
Ranged Right
Level 33 (Min 23)

16 – 24 Damage

Speed: 1.7

Buy price: 2g 28s 87c

Stackable: 1

NPCs that drop this as reference loot (294)

740 Adolescent Whelp 0.5% 4700 Aged Kodo 0.5% 2412 Alina 0.5% 2318 Argus Shadow Mage 0.5% 3660 Athrikus Narassin 0.5% 1364 Balgaras the Foul 1% 2306 Baron Vardus 0.5% 1716 Bazil Thredd 1% 4029 Blackened Ancient 0.5% 3770 Bleakheart Shadowstalker 0.5% 3767 Bleakheart Trickster 0.5% 694 Bloodscalp Axe Thrower 0.5% 699 Bloodscalp Beastmaster 0.5% 597 Bloodscalp Berserker 0.5% 595 Bloodscalp Hunter 0.5% 701 Bloodscalp Mystic 0.5% 702 Bloodscalp Scavenger 0.5% 588 Bloodscalp Scout 0.5% 697 Bloodscalp Shaman 0.5% 587 Bloodscalp Warrior 0.5% 1418 Bluegill Raider 0.5% 2564 Boulderfist Enforcer 0.5% 2562 Boulderfist Ogre 0.5% 570 Brain Eater 0.5% 4665 Burning Blade Adept 0.5% 4663 Burning Blade Augur 0.5% 4666 Burning Blade Felsworn 0.5% 4664 Burning Blade Reaver 0.5% 4667 Burning Blade Shadowmage 0.5% 1160 Captain Halyndor 0.5% 2304 Captain Ironhill 1% 2248 Cave Yeti 0.5% 2091 Chieftain Nek'rosh 1% 771 Commander Felstrom 1% 2256 Crushridge Enforcer 1% 2255 Crushridge Mage 1% 2254 Crushridge Mauler 1% 2252 Crushridge Ogre 0.5% 689 Crystal Spine Basilisk 0.5% 1158 Cursed Marine 0.5% 2582 Dabyrie Laborer 0.5% 2581 Dabyrie Militia 0.5% 2370 Daggerspine Screamer 0.5% 2369 Daggerspine Shorehunter 0.5% 2368 Daggerspine Shorestalker 0.5% 2371 Daggerspine Siren 0.5% 2271 Dalaran Shield Guard 0.5% 2358 Dalaran Summoner 0.5% 2272 Dalaran Theurgist 0.5% 2628 Dalaran Worker 0.5% 4062 Dark Iron Bombardier 0.5% 1054 Dark Iron Demolitionist 1% 1051 Dark Iron Dwarf 1% 1052 Dark Iron Saboteur 1% 2577 Dark Iron Shadowcaster 0.5% 2575 Dark Iron Supplier 0.5% 1053 Dark Iron Tunneler 1% 2337 Dark Strand Voidcaller 0.5% 4515 Death's Head Acolyte 1% 4516 Death's Head Adept 1% 4518 Death's Head Sage 1% 4519 Death's Head Seer 1% 2413 Dermot 0.5% 1037 Dragonmaw Battlemaster 1% 1036 Dragonmaw Centurion 0.5% 1038 Dragonmaw Shadowwarder 0.5% 4692 Dread Swoop 0.5% 2440 Drunken Footpad 0.5% 2344 Dun Garok Mountaineer 1% 2346 Dun Garok Priest 1% 2345 Dun Garok Rifleman 1% 4119 Elder Cloud Serpent 0.5% 1019 Elder Razormaw 0.5% 1085 Elder Stranglethorn Tiger 0.5% 2359 Elemental Slave 0.5% 314 Eliza 1% 4479 Fardel Dabyrie 0.5% 507 Fenros 1% 2385 Feral Mountain Lion 0.5% 2249 Ferocious Yeti 0.5% 1270 Fetid Corpse 0.5% 1159 First Mate Snellig 0.5% 2305 Foreman Bonds 0.5% 3807 Forsaken Assassin 0.5% 3808 Forsaken Dark Stalker 0.5% 3806 Forsaken Infiltrator 0.5% 3804 Forsaken Intruder 0.5% 4095 Galak Mauler 0.5% 2108 Garneg Charskull 1% 4651 Gelkis Earthcaller 0.5% 4646 Gelkis Outrunner 0.5% 4647 Gelkis Scout 0.5% 4648 Gelkis Stamper 0.5% 4649 Gelkis Windchaser 0.5% 4619 Geltharis 0.5% 3414 General Twinbraid 0.5% 3825 Ghostpaw Alpha 0.5% 3811 Giant Ashenvale Bear 0.5% 2565 Giant Plains Creeper 0.5% 2251 Giant Yeti 0.5% 3985 Grandpa Vishas 1% 4113 Gravelsnout Digger 0.5% 4116 Gravelsnout Surveyor 0.5% 4539 Greater Kraul Bat 1% 4490 Grenka Bloodscreech 0.5% 4728 Gritjaw Basilisk 0.5% 1717 Hamhock 1% 2619 Hammerfall Grunt 0.5% 2618 Hammerfall Peon 0.5% 5185 Hammerhead Shark 1% 4673 Hatefury Betrayer 0.5% 4672 Hatefury Felsworn 0.5% 4675 Hatefury Hellcaller 0.5% 4670 Hatefury Rogue 0.5% 4674 Hatefury Shadowstalker 0.5% 4671 Hatefury Trickster 0.5% 2559 Highland Strider 0.5% 2560 Highland Thrasher 0.5% 4109 Highperch Consort 0.5% 4110 Highperch Patriarch 0.5% 4107 Highperch Wyvern 0.5% 2503 Hillsbrad Foreman 0.5% 2270 Hillsbrad Sentry 0.5% 2407 Hulking Mountain Lion 0.5% 4273 Keeper Ordanus 0.5% 5600 Khan Dez'hepah 0.5% 4636 Kolkar Battle Lord 0.5% 4632 Kolkar Centaur 0.5% 4637 Kolkar Destroyer 0.5% 4634 Kolkar Mauler 0.5% 4633 Kolkar Scout 0.5% 4635 Kolkar Windchaser 0.5% 4538 Kraul Bat 1% 938 Kurzen Commando 0.5% 941 Kurzen Headshrinker 0.5% 937 Kurzen Jungle Fighter 0.5% 940 Kurzen Medicine Man 0.5% 977 Kurzen War Panther 0.5% 976 Kurzen War Tiger 0.5% 943 Kurzen Wrangler 0.5% 775 Kurzen's Agent 0.5% 1754 Lord Gregor Lescovar 0.5% 503 Lord Malathrom 1% 755 Lost One Mudlurker 0.5% 2335 Magistrate Burnside 0.5% 4639 Magram Outrunner 0.5% 4643 Magram Pack Runner 0.5% 4638 Magram Scout 0.5% 4642 Magram Stormer 0.5% 4641 Magram Windchaser 0.5% 4640 Magram Wrangler 0.5% 4481 Marcel Dabyrie 0.5% 1755 Marzon the Silent Blade 0.5% 3942 Mavoris Cloudsbreak 0.5% 2579 Mesa Buzzard 0.5% 2450 Miner Hackett 0.5% 1108 Mistvale Gorilla 0.5% 1200 Morbent Fel 1% 2406 Mountain Lion 0.5% 2250 Mountain Yeti 0.5% 2421 Muckrake 1% 4066 Nal'taszar 1% 3984 Nancy Vishas 1% 4124 Needles Cougar 0.5% 205 Nightbane Dark Runner 0.5% 533 Nightbane Shadow Weaver 0.5% 920 Nightbane Tainted One 0.5% 206 Nightbane Vile Fang 0.5% 736 Panther 0.5% 4249 Pesterhide Snarler 0.5% 1824 Plague Lurker 0.5% 604 Plague Spreader 0.5% 2563 Plains Creeper 0.5% 1421 Private Merle 0.5% 4623 Quilguard Champion 1% 4726 Raging Thunder Lizard 0.5% 3696 Ran Bloodtooth 0.5% 4531 Razorfen Beast Trainer 1% 4532 Razorfen Beastmaster 1% 4442 Razorfen Defender 1% 4522 Razorfen Dustweaver 1% 4525 Razorfen Earthbreaker 1% 4523 Razorfen Groundshaker 1% 4438 Razorfen Spearhide 1% 4440 Razorfen Totemic 1% 1140 Razormaw Matriarch 1% 2411 Ricter 0.5% 1150 River Crocilisk 0.5% 4499 Rok'Alim the Pounder 1% 4512 Rotting Agam'ar 1% 4154 Salt Flats Scavenger 0.5% 4158 Salt Flats Vulture 0.5% 4147 Saltstone Basilisk 0.5% 4151 Saltstone Crystalhide 0.5% 4150 Saltstone Gazer 0.5% 1353 Sarltooth 0.5% 4296 Scarlet Adept 1% 4284 Scarlet Augur 1% 4288 Scarlet Beastmaster 1% 4301 Scarlet Centurion 1% 4299 Scarlet Chaplain 1% 4285 Scarlet Disciple 1% 4291 Scarlet Diviner 1% 4287 Scarlet Gallant 1% 4282 Scarlet Magician 1% 4540 Scarlet Monk 1% 4280 Scarlet Preserver 1% 4292 Scarlet Protector 1% 4281 Scarlet Scout 1% 4293 Scarlet Scryer 1% 4283 Scarlet Sentry 1% 4306 Scarlet Torturer 1% 4304 Scarlet Tracking Hound 1% 4041 Scorched Basilisk 0.5% 4697 Scorpashi Lasher 0.5% 4696 Scorpashi Snapper 0.5% 4140 Scorpid Reaver 0.5% 4139 Scorpid Terror 0.5% 4100 Screeching Harpy 0.5% 4101 Screeching Roguefeather 0.5% 4104 Screeching Windcaller 0.5% 5085 Sentry Point Guard 0.5% 3802 Severed Dreamer 0.5% 3799 Severed Druid 0.5% 3803 Severed Keeper 0.5% 3801 Severed Sleeper 0.5% 3931 Shadethicket Oracle 0.5% 4844 Shadowforge Surveyor 1% 905 Sharptooth Frenzy 0.5% 4133 Silithid Hive Drone 0.5% 4131 Silithid Invader 0.5% 4130 Silithid Searcher 0.5% 2600 Singer 1% 1110 Skeletal Raider 0.5% 785 Skeletal Warder 0.5% 4714 Slitherblade Myrmidon 0.5% 4711 Slitherblade Naga 0.5% 4718 Slitherblade Oracle 0.5% 4712 Slitherblade Sorceress 0.5% 4713 Slitherblade Warrior 0.5% 2408 Snapjaw 0.5% 4144 Sparkleshell Borer 0.5% 4143 Sparkleshell Snapper 0.5% 4142 Sparkleshell Tortoise 0.5% 1487 Splinter Fist Enslaver 0.5% 1251 Splinter Fist Firemonger 0.5% 892 Splinter Fist Taskmaster 0.5% 212 Splinter Fist Warrior 0.5% 315 Stalvan Mistmantle 0.5% 4689 Starving Bonepaw 0.5% 4548 Steelsnap 0.5% 688 Stone Maw Basilisk 0.5% 685 Stranglethorn Raptor 0.5% 682 Stranglethorn Tiger 0.5% 2240 Syndicate Footpad 0.5% 2586 Syndicate Highwayman 0.5% 2589 Syndicate Mercenary 0.5% 2587 Syndicate Pathstalker 0.5% 2242 Syndicate Spy 0.5% 2241 Syndicate Thief 0.5% 2319 Syndicate Wizard 0.5% 3940 Taneel Darkwood 0.5% 3789 Terrowulf Fleshripper 0.5% 3792 Terrowulf Packlord 1% 3791 Terrowulf Shadow Weaver 0.5% 4120 Thundering Boulderkin 0.5% 2375 Torn Fin Coastrunner 0.5% 2374 Torn Fin Muckdweller 0.5% 2376 Torn Fin Oracle 0.5% 2377 Torn Fin Tidehunter 0.5% 4308 Unfettered Spirit 0.5% 3941 Uthil Mooncall 0.5% 4030 Vengeful Ancient 1% 921 Venture Co. Lumberjack 0.5% 1097 Venture Co. Mechanic 0.5% 1094 Venture Co. Miner 0.5% 4427 Ward Guardian 1% 3821 Wildthorn Lurker 0.5% 2554 Witherbark Axe Thrower 0.5% 2556 Witherbark Headhunter 0.5% 2553 Witherbark Shadowcaster 0.5% 2552 Witherbark Troll 0.5% 2555 Witherbark Witch Doctor 0.5% 3754 Xavian Betrayer 0.5% 3755 Xavian Felsworn 0.5% 3757 Xavian Hellcaller 0.5% 3752 Xavian Rogue 0.5% 856 Young Lashtail Raptor 0.5% 2578 Young Mesa Buzzard 0.5% 4388 Young Murk Thresher 0.5% 683 Young Panther 0.5% 855 Young Stranglethorn Raptor 0.5% 681 Young Stranglethorn Tiger 0.5% 300 Zzarc' Vul 0.5%

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 3042);
Field Value
entry 3042
class Weapon
subclass Gun
name BKP "Sparrow" Smallbore
description
display_id 6591
quality 2
flags None
buy_count 1
buy_price 2g 28s 87c
sell_price 45s 77c
inventory_type 26: Ranged Right
allowable_class -1
allowable_race -1
item_level 33
required_level 23
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 1700
range_mod 100
ammo_type 3
dmg_min1 16
dmg_max1 24
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 -1
bonding 0: No bind
page_text 0
page_language 0
page_material 0
start_quest -
lock_id 0
material 1
sheath 0
random_property 0
set_id 0
max_durability 0
area_bound 0
map_bound 0
duration 0
bag_family 0
disenchant_id 25
food_type 0
min_money_loot 0
max_money_loot 0
extra_flags 0
ignored 0