Snapvine Watermelon

Item

General

Item model

Field Value
entry 4538
class Consumable
display_id 4781
sell_price 25c
inventory_type 0: Cannot Equip
spellid_1 435: Food III

In-game view

Snapvine Watermelon

Item icon

Consumable
Cannot Equip
Level 25 (Min 15)

Casts:
435: Food III

Buy price: 5s

Stackable: 20

Item dropped by (271)

232 Farmer Ray 32% 2266 Hillsbrad Farmer 30.43% 2403 Farmer Getz 29.26% 2451 Farmer Kalaba 28.93% 5418 Deathstalker Zraedus 28.58% 2239 Drull 17.4% 5414 Apothecary Faustin 13.34% 3715 Wrathtail Sea Witch 10.86% 412 Stitches 7.82% 3998 Windshear Vermin 7.37% 4002 Windshear Stonecutter 7.11% 3942 Mavoris Cloudsbreak 7% 3940 Taneel Darkwood 6.91% 4517 Death's Head Priest 6.78% 3897 Krolg 6.24% 4440 Razorfen Totemic 6.06% 4525 Razorfen Earthbreaker 5.77% 235 Salma Saldean 5.7% 4435 Razorfen Warrior 5.69% 3696 Ran Bloodtooth 5.67% 4427 Ward Guardian 5.62% 4530 Razorfen Handler 5.48% 3660 Athrikus Narassin 5.47% 4052 Cenarion Druid 5.4% 4522 Razorfen Dustweaver 5.29% 4531 Razorfen Beast Trainer 5.27% 4437 Razorfen Warden 5.27% 4409 Gatekeeper Kordurus 5.21% 4523 Razorfen Groundshaker 5.15% 4061 Mirkfallon Dryad 5.14% 3926 Thistlefur Pathfinder 5.14% 4515 Death's Head Acolyte 5.12% 4442 Razorfen Defender 5.09% 4056 Mirkfallon Keeper 5.09% 4050 Cenarion Caretaker 5.09% 3749 Foulweald Ursa 5.09% 4114 Gravelsnout Forager 5.08% 4520 Razorfen Geomancer 5.06% 3799 Severed Druid 5.03% 4623 Quilguard Champion 5.03% 3801 Severed Sleeper 4.94% 4436 Razorfen Quilguard 4.93% 3746 Foulweald Den Watcher 4.92% 3921 Thistlefur Ursa 4.92% 3941 Uthil Mooncall 4.92% 3803 Severed Keeper 4.88% 4519 Death's Head Seer 4.86% 3457 Razormane Stalker 4.8% 3458 Razormane Seer 4.79% 4057 Son of Cenarius 4.77% 4518 Death's Head Sage 4.77% 4054 Laughing Sister 4.71% 3924 Thistlefur Shaman 4.69% 4532 Razorfen Beastmaster 4.67% 3925 Thistlefur Avenger 4.63% 3748 Foulweald Shaman 4.62% 4516 Death's Head Adept 4.62% 4111 Gravelsnout Kobold 4.57% 3923 Thistlefur Den Watcher 4.57% 3750 Foulweald Totemic 4.56% 3459 Razormane Warfrenzy 4.55% 3797 Cenarion Protector 4.45% 3999 Windshear Digger 4.44% 4053 Daughter of Cenarius 4.43% 3922 Thistlefur Totemic 4.42% 4116 Gravelsnout Surveyor 4.39% 4051 Cenarion Botanist 4.39% 3743 Foulweald Warrior 4.36% 4112 Gravelsnout Vermin 4.32% 3745 Foulweald Pathfinder 4.25% 3436 Kuz 4.24% 3987 Dal Bloodclaw 4.21% 4438 Razorfen Spearhide 4.14% 3434 Nak 4.06% 3932 Bloodtooth Guard 4.04% 4424 Aggem Thorncurse 4% 4421 Charlga Razorflank 4% 4428 Death Speaker Jargba 4% 4842 Earthcaller Halmgar 4% 4420 Overlord Ramtusk 4% 3802 Severed Dreamer 3.99% 3435 Lok Orcbane 3.95% 4113 Gravelsnout Digger 3.9% 4004 Windshear Overlord 3.87% 3844 Healing Ward IV 3.57% 4273 Keeper Ordanus 3.5% 3833 Cenarion Vindicator 3.23% 3662 Delmanis the Hated 3.15% 3695 Grimclaw 3.15% 3691 Raene Wolfrunner 3.15% 3694 Sentinel Selarin 3.15% 3693 Terenthis 3.15% 3692 Volcor 3.15% 2090 Ma'ruk Wyrmscale 0.52% 335 Singe 0.36% 2466 Mountaineer Grugelm 0.28% 1487 Splinter Fist Enslaver 0.28% 1014 Mosshide Alpha 0.2% 1037 Dragonmaw Battlemaster 0.16% 2305 Foreman Bonds 0.16% 315 Stalvan Mistmantle 0.14% 1140 Razormaw Matriarch 0.13% 1716 Bazil Thredd 0.12% 2091 Chieftain Nek'rosh 0.12% 4490 Grenka Bloodscreech 0.12% 2264 Hillsbrad Tailor 0.12% 1029 Bluegill Oracle 0.1% 910 Defias Enchanter 0.1% 1159 First Mate Snellig 0.1% 3414 General Twinbraid 0.1% 212 Splinter Fist Warrior 0.08% 486 Tharil'zun 0.08% 300 Zzarc' Vul 0.08% 544 Murloc Nightcrawler 0.06% 3873 Tormented Officer 0.06% 435 Blackrock Champion 0.04% 4462 Blackrock Hunter 0.04% 436 Blackrock Shadowcaster 0.04% 3767 Bleakheart Trickster 0.04% 1024 Bluegill Murloc 0.04% 2628 Dalaran Worker 0.04% 1711 Defias Convict 0.04% 4107 Highperch Wyvern 0.04% 2335 Magistrate Burnside 0.04% 2450 Miner Hackett 0.04% 545 Murloc Tidecaller 0.04% 432 Shadowhide Brute 0.04% 568 Shadowhide Warrior 0.04% 785 Skeletal Warder 0.04% 2529 Son of Arugal 0.04% 1251 Splinter Fist Firemonger 0.04% 4812 Twilight Loreseeker 0.04% 1054 Dark Iron Demolitionist 0.04% 2270 Hillsbrad Sentry 0.03% 615 Blackrock Tracker 0.03% 3378 Bael'dun Officer 0.02% 3377 Bael'dun Rifleman 0.02% 3376 Bael'dun Soldier 0.02% 628 Black Ravager 0.02% 1258 Black Ravager Mastiff 0.02% 4807 Blackfathom Myrmidon 0.02% 4805 Blackfathom Sea Witch 0.02% 4464 Blackrock Gladiator 0.02% 485 Blackrock Outrunner 0.02% 437 Blackrock Renegade 0.02% 4064 Blackrock Scout 0.02% 4065 Blackrock Sentry 0.02% 4463 Blackrock Summoner 0.02% 3765 Bleakheart Satyr 0.02% 3770 Bleakheart Shadowstalker 0.02% 4820 Blindlight Oracle 0.02% 4025 Bloodfury Ambusher 0.02% 4022 Bloodfury Harpy 0.02% 4023 Bloodfury Roguefeather 0.02% 4024 Bloodfury Slayer 0.02% 4027 Bloodfury Storm Witch 0.02% 4026 Bloodfury Windcaller 0.02% 1026 Bluegill Forager 0.02% 1028 Bluegill Muckdweller 0.02% 1025 Bluegill Puddlejumper 0.02% 570 Brain Eater 0.02% 3772 Burning Legionnaire 0.02% 4037 Burning Ravager 0.02% 4040 Cave Stalker 0.02% 2449 Citizen Wilkes 0.02% 2369 Daggerspine Shorehunter 0.02% 2368 Daggerspine Shorestalker 0.02% 1051 Dark Iron Dwarf 0.02% 1169 Dark Iron Insurgent 0.02% 1053 Dark Iron Tunneler 0.02% 4827 Deep Pool Threshfin 0.02% 1707 Defias Captive 0.02% 1708 Defias Inmate 0.02% 1715 Defias Insurgent 0.02% 909 Defias Night Blade 0.02% 1706 Defias Prisoner 0.02% 1057 Dragonmaw Bonewarder 0.02% 2102 Dragonmaw Grunt 0.02% 1034 Dragonmaw Raider 0.02% 2103 Dragonmaw Scout 0.02% 1035 Dragonmaw Swamprunner 0.02% 2344 Dun Garok Mountaineer 0.02% 2345 Dun Garok Rifleman 0.02% 1019 Elder Razormaw 0.02% 4799 Fallenroot Hellcaller 0.02% 4798 Fallenroot Shadowstalker 0.02% 3758 Felmusk Satyr 0.02% 1039 Fen Dweller 0.02% 1270 Fetid Corpse 0.02% 3807 Forsaken Assassin 0.02% 3806 Forsaken Infiltrator 0.02% 3734 Forsaken Thug 0.02% 4099 Galak Marauder 0.02% 4094 Galak Scout 0.02% 4097 Galak Stormer 0.02% 4096 Galak Windchaser 0.02% 2349 Giant Moss Creeper 0.02% 1259 Gobbler 0.02% 4539 Greater Kraul Bat 0.02% 569 Green Recluse 0.02% 3875 Haunted Servitor 0.02% 1018 Highland Razormaw 0.02% 4109 Highperch Consort 0.02% 2387 Hillsbrad Councilman 0.02% 2360 Hillsbrad Farmhand 0.02% 2268 Hillsbrad Footman 0.02% 2503 Hillsbrad Foreman 0.02% 2269 Hillsbrad Miner 0.02% 2267 Hillsbrad Peasant 0.02% 2427 Jailor Eston 0.02% 4538 Kraul Bat 0.02% 1111 Leech Stalker 0.02% 703 Lieutenant Fangore 0.02% 1012 Mosshide Brute 0.02% 1010 Mosshide Fenrunner 0.02% 1007 Mosshide Gnoll 0.02% 1009 Mosshide Mistweaver 0.02% 1011 Mosshide Trapper 0.02% 2372 Mudsnout Gnoll 0.02% 422 Murloc Flesheater 0.02% 578 Murloc Scout 0.02% 205 Nightbane Dark Runner 0.02% 533 Nightbane Shadow Weaver 0.02% 206 Nightbane Vile Fang 0.02% 604 Plague Spreader 0.02% 434 Rabid Shadowhide Gnoll 0.02% 4100 Screeching Harpy 0.02% 4101 Screeching Roguefeather 0.02% 819 Servant of Ilgalar 0.02% 3783 Shadethicket Raincaller 0.02% 3781 Shadethicket Wood Shaper 0.02% 3857 Shadowfang Glutton 0.02% 3859 Shadowfang Ragetooth 0.02% 3854 Shadowfang Wolfguard 0.02% 429 Shadowhide Darkweaver 0.02% 431 Shadowhide Slayer 0.02% 787 Skeletal Healer 0.02% 202 Skeletal Horror 0.02% 1110 Skeletal Raider 0.02% 3862 Slavering Worg 0.02% 892 Splinter Fist Taskmaster 0.02% 213 Starving Dire Wolf 0.02% 2244 Syndicate Shadow Mage 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% 4809 Twilight Acolyte 0.02% 4811 Twilight Aquamancer 0.02% 4810 Twilight Reaver 0.02% 217 Venom Web Spider 0.02% 3877 Wailing Guardsman 0.02% 3712 Wrathtail Razortail 0.02% 3717 Wrathtail Sorceress 0.02% 3752 Xavian Rogue 0.02% 1417 Young Wetlands Crocilisk 0.02% 2265 Hillsbrad Apprentice Blacksmith 0.02% 1027 Bluegill Warrior 0.02% 2373 Mudsnout Shaman 0.02% 3863 Lupine Horror 0.01% 1052 Dark Iron Saboteur 0.01% 1158 Cursed Marine 0.01% 898 Nightbane Worgen 0.01% 433 Shadowhide Gnoll 0.01% 4104 Screeching Windcaller 0.01% 3771 Bleakheart Hellcaller 0.01% 4095 Galak Mauler 0.01% 565 Rabid Dire Wolf 0.01% 2261 Syndicate Watchman 0.01% 1157 Cursed Sailor 0.01% 930 Black Widow Hatchling 0%

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 4538);
Field Value
entry 4538
class Consumable
subclass -1x
name Snapvine Watermelon
description
display_id 4781
quality 1
flags None
buy_count 5
buy_price 5s
sell_price 25c
inventory_type 0: Cannot Equip
allowable_class -1
allowable_race -1
item_level 25
required_level 15
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 435: Food III
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 0
spellcategory_2 0
spellcategorycooldown_2 0
spellid_3 0
spelltrigger_3 0
spellcharges_3 0
spellppmrate_3 0
spellcooldown_3 0
spellcategory_3 0
spellcategorycooldown_3 0
spellid_4 0
spelltrigger_4 0
spellcharges_4 0
spellppmrate_4 0
spellcooldown_4 0
spellcategory_4 0
spellcategorycooldown_4 0
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 6
min_money_loot 0
max_money_loot 0
extra_flags 0
ignored 0