Sold by (71)
258
Joshua Maclure
274
Barkeep Hann
295
Innkeeper Farley
465
Barkeep Dobbins
734
Corporal Bluth
955
Sergeant De Vries
982
Thultash
1149
Uthok
1237
Kazan Mogosh
1247
Barkeep Belm
1285
Thurman Mullby
1328
Elly Langston
1464
Innkeeper Helbrek
1697
Keeg Gibn
2084
Natheril Raincaller
2352
Innkeeper Anderson
2364
Neema
2366
Barkeep Kelly
2388
Innkeeper Shay
2401
Kayren Soothallow
2803
Malygen
2806
Bale
2808
Vikki Lonsav
2820
Graud
2832
Nixxrax Fillamug
2908
Grawl
3086
Gretchen Vogel
3298
Gabrielle Chase
3313
Trak'gen
3350
Asoran
3411
Denni'ka
3541
Sarah Raycroft
3546
Bernie Heisten
3577
Dalaran Brewmaster
3621
Kurll
3689
Laer Stepperunner
3708
Gruna
3881
Grimtak
3882
Zlagk
3883
Moodan Sungrain
3884
Jhawna Oatwind
3934
Innkeeper Boorand Plainswind
3937
Kira Songshine
3959
Nantar
3961
Maliynn
4167
Dendrythis
4169
Jaeana
4170
Ellandrieth
4181
Fyrenna
4190
Kyndri
4191
Allyndia
4192
Taldan
4195
Tiyani
4241
Mydrannul
4266
Danlyia
4554
Tawny Grisette
4555
Eleanor Rusk
4571
Morley Bates
4782
Truk Wildbeard
4875
Turhaw
4879
Ogg'marr
4893
Bartender Lillian
4896
Charity Mipsy
4981
Ben Trias
5101
Bryllia Ironbrand
5111
Bogrum Firebrew
5112
Gwenna Firebrew
5140
Edris Barleybeard
5611
Barkeep Morag
5620
Bartender Wental
5688
Renee Samson
Item dropped by (363)
3577
Dalaran Brewmaster
100%
381
Dockmaster Baren
100%
2316
Gol'dir
100%
2992
Healing Ward V
100%
235
Salma Saldean
30.11%
3981
Vorrel Sengutz
30%
4095
Galak Mauler
24.36%
2712
Quae
22.2%
422
Murloc Flesheater
15.49%
2860
Sigrun Ironhew
10.3%
4096
Galak Windchaser
9.84%
3715
Wrathtail Sea Witch
9.84%
2602
Ruul Onestone
8.4%
5086
Sentry Point Captain
6.16%
2416
Crushridge Plunderer
5.48%
4687
Deepstrider Searcher
5.02%
469
Lieutenant Doren
5%
2453
Lo'Grosh
4.88%
2257
Mug'thol
4.86%
2601
Foulbelly
4.76%
4459
Murkgill Oracle
4.42%
2604
Molok the Crusher
4.31%
2744
Shadowforge Commander
3.85%
814
Sergeant Malthus
3.82%
5046
Lieutenant Caldwell
3.51%
2932
Magregan Deepshadow
3.51%
412
Stitches
3.26%
2780
Caretaker Nevlin
3.24%
2606
Nimar the Slayer
3.18%
2420
Targ
3.17%
4682
Nether Sister
3.13%
5044
Theramore Skirmisher
3.04%
4063
Feeboz
2.99%
2765
Znort
2.96%
2738
Stromgarde Cavalryman
2.96%
4643
Magram Pack Runner
2.94%
862
Stonard Explorer
2.91%
2817
Rigglefuzz
2.9%
4652
Gelkis Mauler
2.88%
2733
Apothecary Jorell
2.86%
2764
Sleeby
2.84%
4291
Scarlet Diviner
2.83%
2782
Caretaker Alaric
2.81%
775
Kurzen's Agent
2.76%
2558
Witherbark Berserker
2.75%
1421
Private Merle
2.75%
2892
Stonevault Seer
2.75%
4297
Scarlet Conjuror
2.74%
4461
Murkgill Warrior
2.74%
873
Saltscale Oracle
2.72%
4294
Scarlet Sorcerer
2.71%
2628
Dalaran Worker
2.69%
4288
Scarlet Beastmaster
2.68%
4401
Muckshell Clacker
2.67%
2596
Daggerspine Sorceress
2.66%
4298
Scarlet Defender
2.66%
4295
Scarlet Myrmidon
2.65%
5057
Theramore Deserter
2.64%
2247
Syndicate Enforcer
2.64%
4302
Scarlet Champion
2.63%
2571
Boulderfist Lord
2.62%
4300
Scarlet Wizard
2.62%
4308
Unfettered Spirit
2.62%
2318
Argus Shadow Mage
2.61%
4299
Scarlet Chaplain
2.61%
4504
Frostmaw
2.59%
4360
Mirefin Warrior
2.59%
4301
Scarlet Centurion
2.58%
4290
Scarlet Guardsman
2.58%
2595
Daggerspine Raider
2.58%
4651
Gelkis Earthcaller
2.58%
2573
Drywhisker Surveyor
2.58%
4656
Maraudine Mauler
2.58%
4845
Shadowforge Ruffian
2.57%
2893
Stonevault Bonesnapper
2.57%
2413
Dermot
2.57%
2242
Syndicate Spy
2.57%
2557
Witherbark Shadow Hunter
2.57%
941
Kurzen Headshrinker
2.56%
2306
Baron Vardus
2.55%
2304
Captain Ironhill
2.55%
763
Lost One Chieftain
2.55%
4715
Slitherblade Razortail
2.55%
2906
Dustbelcher Warrior
2.54%
4286
Scarlet Soldier
2.54%
4281
Scarlet Scout
2.54%
2742
Shadowforge Chanter
2.54%
4641
Magram Windchaser
2.54%
4283
Scarlet Sentry
2.54%
4363
Mirefin Oracle
2.53%
4306
Scarlet Torturer
2.52%
4282
Scarlet Magician
2.52%
4292
Scarlet Protector
2.52%
4636
Kolkar Battle Lord
2.51%
1144
Mosh'Ogg Witch Doctor
2.51%
2740
Shadowforge Darkweaver
2.51%
2319
Syndicate Wizard
2.51%
764
Swampwalker
2.51%
4684
Nether Sorceress
2.5%
2422
Glommus
2.5%
2894
Stonevault Shaman
2.5%
4648
Gelkis Stamper
2.5%
937
Kurzen Jungle Fighter
2.5%
2287
Crushridge Warmonger
2.5%
595
Bloodscalp Hunter
2.49%
2556
Witherbark Headhunter
2.49%
2249
Ferocious Yeti
2.49%
4287
Scarlet Gallant
2.49%
2240
Syndicate Footpad
2.49%
4670
Hatefury Rogue
2.49%
939
Kurzen Elite
2.49%
4649
Gelkis Windchaser
2.49%
4540
Scarlet Monk
2.48%
2431
Jailor Borhuin
2.48%
4850
Stonevault Cave Lurker
2.48%
701
Bloodscalp Mystic
2.48%
2569
Boulderfist Mauler
2.48%
757
Lost One Fisherman
2.48%
4303
Scarlet Abbot
2.47%
2716
Dustbelcher Wyrmhunter
2.47%
2574
Drywhisker Digger
2.46%
4644
Magram Marauder
2.46%
4856
Stonevault Cave Hunter
2.46%
660
Bloodscalp Witch Doctor
2.46%
2272
Dalaran Theurgist
2.45%
942
Kurzen Witch Doctor
2.45%
2584
Stromgarde Defender
2.45%
4665
Burning Blade Adept
2.44%
2907
Dustbelcher Mystic
2.44%
2421
Muckrake
2.44%
4633
Kolkar Scout
2.43%
2417
Grel'borg the Miser
2.43%
4716
Slitherblade Tidehunter
2.43%
4674
Hatefury Shadowstalker
2.43%
4647
Gelkis Scout
2.42%
588
Bloodscalp Scout
2.42%
4851
Stonevault Rockchewer
2.42%
2619
Hammerfall Grunt
2.41%
780
Skullsplitter Mystic
2.41%
871
Saltscale Warrior
2.41%
2251
Giant Yeti
2.41%
4679
Nether Maiden
2.4%
978
Kurzen Subchief
2.4%
759
Lost One Hunter
2.4%
2588
Syndicate Prowler
2.4%
5477
Noboru the Cudgel
2.4%
2248
Cave Yeti
2.4%
674
Venture Co. Strip Miner
2.4%
4289
Scarlet Evoker
2.39%
2243
Syndicate Sentry
2.39%
4645
Magram Mauler
2.39%
587
Bloodscalp Warrior
2.39%
2589
Syndicate Mercenary
2.39%
4675
Hatefury Hellcaller
2.39%
2582
Dabyrie Laborer
2.39%
2245
Syndicate Saboteur
2.39%
4637
Kolkar Destroyer
2.39%
2252
Crushridge Ogre
2.38%
2452
Skhowl
2.38%
2566
Boulderfist Brute
2.38%
4285
Scarlet Disciple
2.38%
4712
Slitherblade Sorceress
2.37%
1142
Mosh'Ogg Brute
2.37%
699
Bloodscalp Beastmaster
2.37%
4719
Slitherblade Sea Witch
2.36%
4852
Stonevault Oracle
2.36%
766
Tangled Horror
2.36%
4361
Mirefin Muckdweller
2.36%
4296
Scarlet Adept
2.36%
4284
Scarlet Augur
2.36%
4362
Mirefin Coastrunner
2.36%
979
Kurzen Shadow Hunter
2.36%
2591
Syndicate Magus
2.35%
696
Skullsplitter Axe Thrower
2.35%
2256
Crushridge Enforcer
2.35%
4293
Scarlet Scryer
2.35%
694
Bloodscalp Axe Thrower
2.35%
2618
Hammerfall Peon
2.35%
4358
Mirefin Puddlejumper
2.34%
5085
Sentry Point Guard
2.34%
2714
Forsaken Courier
2.34%
2607
Prince Galen Trollbane
2.34%
4668
Burning Blade Summoner
2.33%
2743
Shadowforge Warrior
2.33%
2250
Mountain Yeti
2.33%
755
Lost One Mudlurker
2.33%
4646
Gelkis Outrunner
2.32%
4642
Magram Stormer
2.32%
4666
Burning Blade Felsworn
2.32%
5600
Khan Dez'hepah
2.32%
2241
Syndicate Thief
2.32%
4657
Maraudine Windchaser
2.32%
4638
Magram Scout
2.32%
671
Bloodscalp Headhunter
2.31%
4640
Magram Wrangler
2.31%
2554
Witherbark Axe Thrower
2.31%
4634
Kolkar Mauler
2.31%
2567
Boulderfist Magus
2.31%
938
Kurzen Commando
2.31%
4659
Maraudine Marauder
2.3%
597
Bloodscalp Berserker
2.3%
4658
Maraudine Stormer
2.3%
4654
Maraudine Scout
2.3%
1096
Venture Co. Geologist
2.3%
667
Skullsplitter Warrior
2.3%
4359
Mirefin Murloc
2.3%
4834
Theramore Infiltrator
2.3%
4655
Maraudine Wrangler
2.3%
4664
Burning Blade Reaver
2.29%
2572
Drywhisker Kobold
2.29%
4847
Shadowforge Relic Hunter
2.29%
4632
Kolkar Centaur
2.29%
4635
Kolkar Windchaser
2.29%
2358
Dalaran Summoner
2.29%
765
Swampwalker Elder
2.28%
4846
Shadowforge Digger
2.28%
2715
Dustbelcher Brute
2.27%
921
Venture Co. Lumberjack
2.27%
1561
Bloodsail Raider
2.27%
940
Kurzen Medicine Man
2.27%
762
Lost One Riftseeker
2.27%
2253
Crushridge Brute
2.26%
702
Bloodscalp Scavenger
2.26%
697
Bloodscalp Shaman
2.26%
761
Lost One Seer
2.26%
2590
Syndicate Conjuror
2.25%
2555
Witherbark Witch Doctor
2.25%
2411
Ricter
2.25%
2570
Boulderfist Shaman
2.25%
943
Kurzen Wrangler
2.24%
677
Venture Co. Tinkerer
2.23%
2612
Lieutenant Valorcall
2.22%
4711
Slitherblade Naga
2.22%
4386
Withervine Bark Ripper
2.22%
2271
Dalaran Shield Guard
2.22%
4639
Magram Outrunner
2.22%
2553
Witherbark Shadowcaster
2.22%
5643
Tyranis Malem
2.21%
1097
Venture Co. Mechanic
2.21%
4844
Shadowforge Surveyor
2.21%
4713
Slitherblade Warrior
2.21%
2587
Syndicate Pathstalker
2.19%
4663
Burning Blade Augur
2.19%
4672
Hatefury Felsworn
2.18%
2545
"Pretty Boy" Duncan
2.18%
2254
Crushridge Mauler
2.18%
2739
Shadowforge Tunneler
2.17%
2581
Dabyrie Militia
2.17%
2423
Lord Aliden Perenolde
2.17%
5184
Theramore Sentry
2.17%
2721
Forsaken Bodyguard
2.17%
4458
Murkgill Hunter
2.16%
4671
Hatefury Trickster
2.16%
1562
Bloodsail Mage
2.15%
1094
Venture Co. Miner
2.14%
4062
Dark Iron Bombardier
2.14%
2583
Stromgarde Troll Hunter
2.13%
2255
Crushridge Mage
2.12%
4260
Venture Co. Shredder
2.12%
2564
Boulderfist Enforcer
2.12%
2599
Otto
2.11%
2586
Syndicate Highwayman
2.11%
4714
Slitherblade Myrmidon
2.11%
4673
Hatefury Betrayer
2.09%
2562
Boulderfist Ogre
2.09%
5622
Ongeku
2.08%
2246
Syndicate Assassin
2.08%
4280
Scarlet Preserver
2.08%
2575
Dark Iron Supplier
2.08%
4667
Burning Blade Shadowmage
2.07%
5045
Private Hallan
2.07%
5602
Khan Shaka
2.07%
760
Lost One Muckdweller
2.07%
2773
Or'Kalar
2.06%
2636
Blackwater Deckhand
2.04%
2598
Darbel Montrose
2.02%
4382
Withervine Creeper
2.02%
4402
Muckshell Snapclaw
2.02%
4680
Doomwarder Captain
2.01%
4457
Murkgill Forager
2%
861
Stonard Scout
1.99%
4387
Withervine Mire Beast
1.99%
5601
Khan Jehn
1.99%
2412
Alina
1.96%
2585
Stromgarde Vindicator
1.96%
813
Colonel Kurzen
1.94%
4677
Doomwarder
1.94%
2701
Dustbelcher Ogre
1.91%
4718
Slitherblade Oracle
1.91%
4653
Gelkis Marauder
1.87%
2577
Dark Iron Shadowcaster
1.84%
2552
Witherbark Troll
1.84%
4481
Marcel Dabyrie
1.84%
4479
Fardel Dabyrie
1.83%
877
Saltscale Forager
1.83%
2414
Kegan Darkmar
1.8%
4686
Deepstrider Giant
1.74%
4480
Kenata Dabyrie
1.73%
2320
Nagaz
1.72%
2434
Shadowy Assassin
1.71%
3985
Grandpa Vishas
1.68%
875
Saltscale Tide Lord
1.68%
3984
Nancy Vishas
1.68%
5402
Khan Hratha
1.67%
2783
Marez Cowl
1.67%
4705
Burning Blade Invoker
1.67%
2793
Kor'gresh Coldrage
1.66%
1106
Lost One Cook
1.66%
879
Saltscale Hunter
1.66%
2779
Prince Nazjak
1.54%
4460
Murkgill Lord
1.52%
2415
Warden Belamoore
1.46%
4723
Foreman Cozzle
1.44%
4385
Withervine Rager
1.44%
2624
Gazban
1.42%
1095
Venture Co. Workboss
1.41%
2597
Lord Falconcrest
1.22%
2781
Caretaker Weston
1.2%
815
Bookie Herod
1.19%
2605
Zalas Witherbark
1.19%
1062
Nezzliok the Dire
1.19%
2440
Drunken Footpad
1.18%
2603
Kovork
1.08%
2600
Singer
1.05%
2745
Ambassador Infernus
0.86%
1081
Mire Lord
0.52%
2723
Stone Golem
0.44%
4132
Silithid Ravager
0.34%
976
Kurzen War Tiger
0.24%
1061
Gan'zulah
0.16%
2718
Dustbelcher Shaman
0.14%
4133
Silithid Hive Drone
0.1%
977
Kurzen War Panther
0.08%
4130
Silithid Searcher
0.08%
2717
Dustbelcher Mauler
0.06%
1151
Saltwater Crocilisk
0.06%
4131
Silithid Invader
0.06%
2635
Elder Saltwater Crocilisk
0.04%
680
Mosh'Ogg Lord
0.04%
2945
Murdaloc
0.04%
670
Skullsplitter Witch Doctor
0.04%
2359
Elemental Slave
0.03%
1563
Bloodsail Swashbuckler
0.02%
1564
Bloodsail Warlock
0.02%
690
Cold Eye Basilisk
0.02%
689
Crystal Spine Basilisk
0.02%
379
Darcy
0.02%
2720
Dustbelcher Ogre Mage
0.02%
2729
Elder Crag Coyote
0.02%
2831
Giant Buzzard
0.02%
687
Jungle Stalker
0.02%
686
Lashtail Raptor
0.02%
1327
Reese Langston
0.02%
2732
Ridge Huntress
0.02%
684
Shadowmaw Panther
0.02%
2544
Southern Sand Crawler
0.02%
2375
Torn Fin Coastrunner
0.02%
2374
Torn Fin Muckdweller
0.02%
2376
Torn Fin Oracle
0.02%
2377
Torn Fin Tidehunter
0.02%
681
Young Stranglethorn Tiger
0.02%
1489
Zanzil Hunter
0.02%
1488
Zanzil Zombie
0.02%
Item is a quest requirement (1)
3375
(not found)
Item details
UPDATE `item_template` SET `field`
= xxxx WHERE (`entry` = 1708);
Field | Value |
---|---|
entry | 1708 |
class | Consumable |
subclass | -1x |
name | Sweet Nectar |
description | |
display_id | 6366 |
quality | 1 |
flags | None |
buy_count | 5 |
buy_price | 12s 50c |
sell_price | 62c |
inventory_type | 0: Cannot Equip |
allowable_class | -1 |
allowable_race | -1 |
item_level | 35 |
required_level | 25 |
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 | 1133: Drink IV |
spelltrigger_1 | 0 |
spellcharges_1 | -1 |
spellppmrate_1 | 0 |
spellcooldown_1 | 0 |
spellcategory_1 | 59 |
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 | 3 |
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 | 0 |
min_money_loot | 0 |
max_money_loot | 0 |
extra_flags | 0 |
ignored | 0 |