Sold by (11)
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 |