Sold by (13)
Item dropped by (249)
2058
Deathstalker Faerleia
66.66%
2520
Remote-Controlled Golem
9.52%
2067
Councilman Brunswick
9.32%
3533
Moonrage Leatherworker
9%
2064
Councilman Hartin
7.63%
3578
Dalaran Miner
7.62%
2061
Councilman Thatcher
7.53%
2066
Councilman Higarth
6.87%
3529
Moonrage Armorer
6.76%
3530
Pyrewood Tailor
6.49%
2062
Councilman Hendricks
6.47%
2332
Valdred Moray
6.09%
3454
Cannoneer Smythe
5.97%
2120
Archmage Ataeric
5.88%
1915
Dalaran Conjuror
5.82%
1893
Moonrage Sentry
5.61%
3455
Cannoneer Whessan
5.55%
1726
Defias Magician
5.39%
657
Defias Pirate
5.34%
4416
Defias Strip Miner
5.32%
1913
Dalaran Warder
5.31%
4417
Defias Taskmaster
5.29%
1891
Pyrewood Watcher
5.28%
598
Defias Miner
5.2%
1732
Defias Squallshaper
5.16%
1727
Defias Worker
5.13%
2065
Councilman Cooper
5.08%
1914
Dalaran Mage
5.06%
2054
Sickly Refugee
5.02%
1729
Defias Evoker
5.01%
1888
Dalaran Watcher
4.97%
634
Defias Overseer
4.97%
636
Defias Blackguard
4.94%
3386
Theramore Preserver
4.88%
95
Defias Smuggler
4.85%
4418
Defias Wizard
4.84%
824
Defias Digger
4.83%
502
Benny Blaanco
4.82%
589
Defias Pillager
4.82%
3385
Theramore Marine
4.81%
3384
Southsea Privateer
4.81%
1725
Defias Watchman
4.78%
3381
Southsea Brigand
4.77%
2336
Dark Strand Fanatic
4.76%
590
Defias Looter
4.76%
3382
Southsea Cannoneer
4.75%
504
Defias Trapper
4.75%
619
Defias Conjurer
4.71%
449
Defias Knuckleduster
4.71%
3383
Southsea Cutthroat
4.71%
4096
Galak Windchaser
4.67%
3715
Wrathtail Sea Witch
4.67%
121
Defias Pathstalker
4.63%
596
Brainwashed Noble
4.61%
3393
Captain Fairmount
4.6%
122
Defias Highwayman
4.58%
594
Defias Henchman
4.58%
1912
Dalaran Protector
4.58%
3662
Delmanis the Hated
4.56%
3695
Grimclaw
4.56%
3691
Raene Wolfrunner
4.56%
3694
Sentinel Selarin
4.56%
3693
Terenthis
4.56%
3692
Volcor
4.56%
481
Defias Footpad
4.54%
1894
Pyrewood Sentry
4.54%
1867
Dalaran Apprentice
4.5%
1892
Moonrage Watcher
4.38%
550
Defias Messenger
4.38%
1895
Pyrewood Elder
4.37%
3467
Baron Longshore
4.37%
1889
Dalaran Wizard
4.36%
1896
Moonrage Elder
4.31%
2053
Haggard Refugee
4.24%
599
Marisa du'Paige
4.24%
1093
Chief Engineer Hinderweir VII
4.2%
1947
Thule Ravenclaw
4.17%
639
Edwin VanCleef
4%
3586
Miner Johnson
4%
2060
Councilman Smithers
3.47%
1920
Dalaran Spellscribe
3.33%
2063
Councilman Wilhelm
3.17%
5682
Dalin Forgewright
3.01%
3528
Pyrewood Armorer
2.7%
2068
Lord Mayor Morrison
2.5%
2676
Compact Harvest Reaper
2.4%
3532
Pyrewood Leatherworker
2.38%
450
Defias Renegade Mage
2.32%
3577
Dalaran Brewmaster
1.91%
3531
Moonrage Tailor
1.68%
711
Ardo Dirtpaw
0.26%
1948
Snarlmane
0.19%
3619
Ghost Saber
0.18%
1944
Rot Hide Bruiser
0.17%
1398
Boss Galgosh
0.15%
1425
Grizlak
0.14%
1399
Magosh
0.09%
2159
Gravelflint Bonesnapper
0.08%
1180
Mo'grosh Brute
0.08%
445
Redridge Alpha
0.08%
1177
Tunnel Rat Surveyor
0.08%
1183
Mo'grosh Mystic
0.08%
1205
Grawmug
0.07%
518
Yowler
0.07%
4013
Pridewing Skyhunter
0.06%
3660
Athrikus Narassin
0.04%
1210
Chok'sul
0.04%
4202
Gerenzo Wrenchwhistle
0.04%
3947
Goblin Shipbuilder
0.04%
2160
Gravelflint Geomancer
0.04%
2158
Gravelflint Scout
0.04%
545
Murloc Tidecaller
0.04%
391
Old Murk-Eye
0.04%
446
Redridge Basher
0.04%
1773
Rot Hide Mystic
0.04%
2157
Stone Behemoth
0.04%
3992
Venture Co. Engineer
0.04%
1909
Vile Fin Lakestalker
0.04%
1957
Vile Fin Shorecreeper
0.04%
1767
Vile Fin Shredder
0.04%
1181
Mo'grosh Shaman
0.03%
626
Foreman Thistlenettle
0.02%
624
Undead Excavator
0.02%
623
Skeletal Miner
0.02%
1393
Berserk Trogg
0.02%
2169
Blackwood Totemic
0.02%
2168
Blackwood Warrior
0.02%
2324
Blackwood Windtalker
0.02%
3263
Bristleback Geomancer
0.02%
3258
Bristleback Hunter
0.02%
3260
Bristleback Water Seeker
0.02%
3380
Burning Blade Acolyte
0.02%
3379
Burning Blade Bruiser
0.02%
834
Coyote
0.02%
2156
Cracked Golem
0.02%
2176
Cursed Highborne
0.02%
1169
Dark Iron Insurgent
0.02%
2337
Dark Strand Voidcaller
0.02%
2185
Darkshore Thresher
0.02%
2212
Deth'ryll Satyr
0.02%
5055
Deviate Lasher
0.02%
5755
Deviate Viper
0.02%
428
Dire Condor
0.02%
3640
Evolving Ectoplasm
0.02%
3733
Forsaken Herbalist
0.02%
3732
Forsaken Seeker
0.02%
3734
Forsaken Thug
0.02%
622
Goblin Engineer
0.02%
547
Great Goretusk
0.02%
154
Greater Fleshripper
0.02%
2202
Greymist Coastrunner
0.02%
2203
Greymist Seer
0.02%
36
Harvest Golem
0.02%
114
Harvest Watcher
0.02%
3875
Haunted Servitor
0.02%
1236
Kobold Digger
0.02%
3275
Kolkar Marauder
0.02%
3274
Kolkar Pack Runner
0.02%
3272
Kolkar Wrangler
0.02%
1191
Mangy Mountain Boar
0.02%
1179
Mo'grosh Enforcer
0.02%
1178
Mo'grosh Ogre
0.02%
1770
Moonrage Darkrunner
0.02%
1782
Moonrage Darksoul
0.02%
1769
Moonrage Whitescalp
0.02%
3461
Mud Thresh
0.02%
126
Murloc Coastrunner
0.02%
422
Murloc Flesheater
0.02%
456
Murloc Minor Oracle
0.02%
548
Murloc Minor Tidecaller
0.02%
517
Murloc Oracle
0.02%
1083
Murloc Shorestriker
0.02%
127
Murloc Tidehunter
0.02%
4014
Pridewing Consort
0.02%
4012
Pridewing Wyvern
0.02%
2231
Pygmy Tide Crawler
0.02%
2236
Raging Reef Crawler
0.02%
1869
Ravenclaw Champion
0.02%
3266
Razormane Defender
0.02%
3269
Razormane Geomancer
0.02%
3265
Razormane Hunter
0.02%
3271
Razormane Mystic
0.02%
3268
Razormane Thornweaver
0.02%
426
Redridge Brute
0.02%
580
Redridge Drudger
0.02%
430
Redridge Mystic
0.02%
712
Redridge Thrasher
0.02%
2235
Reef Crawler
0.02%
124
Riverpaw Brute
0.02%
117
Riverpaw Gnoll
0.02%
501
Riverpaw Herbalist
0.02%
1426
Riverpaw Miner
0.02%
123
Riverpaw Mongrel
0.02%
453
Riverpaw Mystic
0.02%
500
Riverpaw Scout
0.02%
98
Riverpaw Taskmaster
0.02%
1772
Rot Hide Gladerunner
0.02%
1940
Rot Hide Plague Weaver
0.02%
1942
Rot Hide Savage
0.02%
480
Rusty Harvest Golem
0.02%
830
Sand Crawler
0.02%
3853
Shadowfang Moonwalker
0.02%
3862
Slavering Worg
0.02%
1164
Stonesplinter Bonesnapper
0.02%
1167
Stonesplinter Digger
0.02%
1162
Stonesplinter Scout
0.02%
1166
Stonesplinter Seer
0.02%
1197
Stonesplinter Shaman
0.02%
1163
Stonesplinter Skullthumper
0.02%
1161
Stonesplinter Trogg
0.02%
2181
Stormscale Myrmidon
0.02%
2180
Stormscale Siren
0.02%
2182
Stormscale Sorceress
0.02%
2183
Stormscale Warrior
0.02%
1175
Tunnel Rat Digger
0.02%
1176
Tunnel Rat Forager
0.02%
1174
Tunnel Rat Geomancer
0.02%
1173
Tunnel Rat Scout
0.02%
1172
Tunnel Rat Vermin
0.02%
2338
Twilight Disciple
0.02%
2339
Twilight Thug
0.02%
625
Undead Dynamiter
0.02%
3283
Venture Co. Enforcer
0.02%
3989
Venture Co. Logger
0.02%
3286
Venture Co. Overseer
0.02%
3285
Venture Co. Peon
0.02%
2189
Vile Sprite
0.02%
2178
Wailing Highborne
0.02%
2190
Wild Grell
0.02%
3999
Windshear Digger
0.02%
4004
Windshear Overlord
0.02%
3278
Witchwing Slayer
0.02%
3280
Witchwing Windcaller
0.02%
3717
Wrathtail Sorceress
0.02%
199
Young Fleshripper
0.02%
454
Young Goretusk
0.02%
2234
Young Reef Crawler
0.02%
1165
Stonesplinter Geomancer
0.01%
3397
Kolkar Bloodcharger
0.01%
452
Riverpaw Bandit
0.01%
5048
Deviate Adder
0.01%
5756
Deviate Venomwing
0.01%
424
Redridge Poacher
0.01%
423
Redridge Mongrel
0.01%
3840
Druid of the Fang
0.01%
641
Goblin Woodcarver
0%
3261
Bristleback Thornweaver
0%
3273
Kolkar Stormer
0%
1731
Goblin Craftsman
0%
Item is a quest reward (1)
Item details
UPDATE `item_template` SET `field`
= xxxx WHERE (`entry` = 414);
Field | Value |
---|---|
entry | 414 |
class | Consumable |
subclass | -1x |
name | Dalaran Sharp |
description | |
display_id | 6352 |
quality | 1 |
flags | None |
buy_count | 5 |
buy_price | 1s 25c |
sell_price | 6c |
inventory_type | 0: Cannot Equip |
allowable_class | -1 |
allowable_race | -1 |
item_level | 15 |
required_level | 5 |
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 | 20 |
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 | 0 |
range_mod | 0 |
ammo_type | 0 |
dmg_min1 | 0 |
dmg_max1 | 0 |
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 | 434: Food II |
spelltrigger_1 | 0 |
spellcharges_1 | -1 |
spellppmrate_1 | 0 |
spellcooldown_1 | 0 |
spellcategory_1 | 11 |
spellcategorycooldown_1 | 1 sec |
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 | 0 |
sheath | 0 |
random_property | 0 |
set_id | 0 |
max_durability | 0 |
area_bound | 0 |
map_bound | 0 |
duration | 0 |
bag_family | 0 |
disenchant_id | 0 |
food_type | 3 |
min_money_loot | 0 |
max_money_loot | 0 |
extra_flags | 0 |
ignored | 0 |