Sweet Nectar

Item

General

Item model

Field Value
entry 1708
class Consumable
display_id 6366
sell_price 62c
inventory_type 0: Cannot Equip
spellid_1 1133: Drink IV

In-game view

Sweet Nectar

Item icon

Consumable
Cannot Equip
Level 35 (Min 25)

Casts:
1133: Drink IV

Buy price: 12s 50c

Stackable: 20

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 Consumable
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