Sold by (10)
Item dropped by (135)
1934
Tirisfal Farmer
30.98%
1936
Farmer Solliden
25.14%
80
Kobold Laborer
13.54%
6
Kobold Vermin
13.46%
2952
Bristleback Quilboar
13.39%
2953
Bristleback Shaman
13.37%
257
Kobold Worker
13.29%
3229
"Squealer" Thornmantle
10.99%
60
Ruklar the Trapper
10.62%
2014
Gnarlpine Totemic
9.87%
1993
Greenpaw
9.75%
3662
Delmanis the Hated
8.38%
3695
Grimclaw
8.38%
3691
Raene Wolfrunner
8.38%
3694
Sentinel Selarin
8.38%
3693
Terenthis
8.38%
3692
Volcor
8.38%
3111
Razormane Quilboar
8.07%
2010
Gnarlpine Defender
7.97%
3112
Razormane Scout
7.93%
2011
Gnarlpine Augur
7.82%
2162
Agal
7.76%
3232
Bristleback Interloper
7.72%
2009
Gnarlpine Shaman
7.59%
475
Kobold Tunneler
7.56%
3114
Razormane Battleguard
7.53%
40
Kobold Miner
7.53%
2008
Gnarlpine Warrior
7.49%
2039
Ursal the Mauler
7.45%
2152
Gnarlpine Ambusher
7.34%
327
Goldtooth
7.33%
2012
Gnarlpine Pathfinder
7.32%
3113
Razormane Dustrunner
7.3%
476
Kobold Geomancer
7.22%
2006
Gnarlpine Ursa
7.12%
2007
Gnarlpine Gardener
7.08%
2013
Gnarlpine Avenger
6.82%
79
Narg the Taskmaster
4.98%
881
Surena Caledon
0.14%
3203
Fizzle Darkstorm
0.12%
99
Morgaine the Sly
0.12%
1688
Night Web Matriarch
0.12%
471
Mother Fang
0.1%
2990
Bael'dun Appraiser
0.08%
2020
Bloodfeather Wind Witch
0.06%
3118
Dustwind Storm Witch
0.06%
1994
Githyiss the Vile
0.06%
3120
Kolkar Outrunner
0.06%
2038
Lord Melenas
0.06%
97
Riverpaw Runt
0.06%
1916
Stephen Bhartec
0.06%
2021
Bloodfeather Matriarch
0.04%
2018
Bloodfeather Sorceress
0.04%
3122
Bloodtalon Taillasher
0.04%
1662
Captain Perrine
0.04%
3121
Durotar Tiger
0.04%
880
Erlan Drudgemoor
0.04%
3204
Gazz'uz
0.04%
448
Hogger
0.04%
43
Mine Spider
0.04%
2977
Venture Co. Taskmaster
0.04%
2962
Windfury Harpy
0.04%
2976
Venture Co. Laborer
0.02%
2989
Bael'dun Digger
0.02%
1529
Bleeding Horror
0.02%
2019
Bloodfeather Fury
0.02%
2015
Bloodfeather Harpy
0.02%
3198
Burning Blade Apprentice
0.02%
3199
Burning Blade Cultist
0.02%
3197
Burning Blade Fanatic
0.02%
3196
Burning Blade Neophyte
0.02%
3195
Burning Blade Thug
0.02%
1523
Cracked Skull Soldier
0.02%
1917
Daniel Ulfman
0.02%
2004
Dark Sprite
0.02%
1522
Darkeye Bonecaster
0.02%
116
Defias Bandit
0.02%
94
Defias Cutpurse
0.02%
474
Defias Rogue Wizard
0.02%
38
Defias Thug
0.02%
3116
Dustwind Pillager
0.02%
3117
Dustwind Savage
0.02%
1123
Frostmane Headhunter
0.02%
1122
Frostmane Hideskinner
0.02%
1397
Frostmane Seer
0.02%
1124
Frostmane Shadowcaster
0.02%
1121
Frostmane Snowstrider
0.02%
1120
Frostmane Troll
0.02%
1988
Grell
0.02%
1989
Grellkin
0.02%
3207
Hexed Troll
0.02%
1196
Ice Claw Bear
0.02%
1918
Karrel Grayves
0.02%
3119
Kolkar Drudge
0.02%
1211
Leper Gnome
0.02%
3103
Makrura Clacker
0.02%
3104
Makrura Shellhide
0.02%
1513
Mangy Duskbat
0.02%
1501
Mindless Zombie
0.02%
473
Morgan the Collector
0.02%
285
Murloc
0.02%
46
Murloc Forager
0.02%
732
Murloc Lurker
0.02%
1505
Night Web Spider
0.02%
2951
Palemane Poacher
0.02%
2950
Palemane Skinner
0.02%
2960
Prairie Wolf Alpha
0.02%
3106
Pygmy Surf Crawler
0.02%
1117
Rockjaw Bonesnapper
0.02%
1115
Rockjaw Skullthumper
0.02%
1919
Samuel Fipps
0.02%
1506
Scarlet Convert
0.02%
1507
Scarlet Initiate
0.02%
1537
Scarlet Zealot
0.02%
2003
Shadow Sprite
0.02%
1201
Snow Leopard
0.02%
3107
Surf Crawler
0.02%
3130
Thunder Lizard
0.02%
1388
Vagash
0.02%
2979
Venture Co. Supervisor
0.02%
2978
Venture Co. Worker
0.02%
2005
Vicious Grell
0.02%
3206
Voodoo Troll
0.02%
1534
Wailing Ancestor
0.02%
1532
Wandering Spirit
0.02%
1986
Webwood Spider
0.02%
1135
Wendigo
0.02%
2965
Windfury Matriarch
0.02%
2964
Windfury Sorceress
0.02%
822
Young Forest Bear
0.02%
2017
Bloodfeather Rogue
0.01%
2949
Palemane Tanner
0.01%
3115
Dustwind Harpy
0.01%
3129
Kul Tiras Marine
0.01%
478
Riverpaw Outrunner
0%
Item is a reagent for spell (1)
Item is a quest reward (1)
Item details
UPDATE `item_template` SET `field`
= xxxx WHERE (`entry` = 4536);
Field | Value |
---|---|
entry | 4536 |
class | Consumable |
subclass | -1x |
name | Shiny Red Apple |
description | |
display_id | 6410 |
quality | 1 |
flags | None |
buy_count | 5 |
buy_price | 25c |
sell_price | 1c |
inventory_type | 0: Cannot Equip |
allowable_class | -1 |
allowable_race | -1 |
item_level | 5 |
required_level | 1 |
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 | 433: Food |
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 | 6 |
min_money_loot | 0 |
max_money_loot | 0 |
extra_flags | 0 |
ignored | 0 |