Sold by (76)
227
Mabel Solaj
258
Joshua Maclure
274
Barkeep Hann
295
Innkeeper Farley
465
Barkeep Dobbins
491
Quartermaster Lewis
734
Corporal Bluth
791
Lindsay Ashlock
955
Sergeant De Vries
982
Thultash
1237
Kazan Mogosh
1247
Barkeep Belm
1285
Thurman Mullby
1328
Elly Langston
1448
Neal Allen
1452
Gruham Rumdnul
1464
Innkeeper Helbrek
1682
Yanni Stoutheart
1685
Xandar Goodbeard
1697
Keeg Gibn
2140
Edwin Harly
2352
Innkeeper Anderson
2364
Neema
2366
Barkeep Kelly
2388
Innkeeper Shay
2401
Kayren Soothallow
2803
Malygen
2806
Bale
2832
Nixxrax Fillamug
3086
Gretchen Vogel
3298
Gabrielle Chase
3313
Trak'gen
3411
Denni'ka
3481
Barg
3498
Jazzik
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
3962
Haljan Oakheart
4082
Grawnal
4084
Chylina
4167
Dendrythis
4169
Jaeana
4181
Fyrenna
4182
Dalmond
4190
Kyndri
4191
Allyndia
4192
Taldan
4195
Tiyani
4266
Danlyia
4554
Tawny Grisette
4555
Eleanor Rusk
4571
Morley Bates
4782
Truk Wildbeard
4875
Turhaw
4876
Jawn Highmesa
4879
Ogg'marr
4893
Bartender Lillian
4981
Ben Trias
5111
Bogrum Firebrew
5112
Gwenna Firebrew
5140
Edris Barleybeard
5611
Barkeep Morag
5620
Bartender Wental
5688
Renee Samson
Item dropped by (362)
3450
Defias Companion
80%
2058
Deathstalker Faerleia
66.66%
3389
Regthar Deathgate
33.34%
3465
Gilthares Firebough
30.4%
1093
Chief Engineer Hinderweir VII
22.9%
3939
Razormane Wolf
22.22%
4096
Galak Windchaser
11.13%
3715
Wrathtail Sea Witch
11.13%
2520
Remote-Controlled Golem
9.52%
3533
Moonrage Leatherworker
7.41%
1944
Rot Hide Bruiser
6.86%
545
Murloc Tidecaller
5.9%
3532
Pyrewood Leatherworker
4.76%
1948
Snarlmane
4.65%
2062
Councilman Hendricks
4.3%
2064
Councilman Hartin
4.24%
1399
Magosh
4.2%
2676
Compact Harvest Reaper
4.17%
2060
Councilman Smithers
4.17%
2061
Councilman Thatcher
4.11%
520
Brack
4.09%
3662
Delmanis the Hated
4.07%
647
Captain Greenskin
4%
645
Cookie
4%
639
Edwin VanCleef
4%
1763
Gilnid
4%
3671
Lady Anacondra
4%
3669
Lord Cobrahn
4%
3670
Lord Pythas
4%
3673
Lord Serpentis
4%
3586
Miner Johnson
4%
646
Mr. Smite
4%
3654
Mutanus the Devourer
4%
644
Rhahk'Zor
4%
643
Sneed
4%
642
Sneed's Shredder
4%
1207
Brawler
3.95%
1424
Master Digger
3.87%
2186
Carnivous the Breaker
3.8%
506
Sergeant Brashclaw
3.68%
3531
Moonrage Tailor
3.36%
1920
Dalaran Spellscribe
3.33%
125
Riverpaw Overseer
3.33%
1768
Vile Fin Tidehunter
3.33%
3529
Moonrage Armorer
3.32%
4001
Windshear Tunnel Rat
3.3%
1891
Pyrewood Watcher
3.25%
3455
Cannoneer Whessan
3.2%
453
Riverpaw Mystic
3.15%
1943
Raging Rot Hide
3.08%
1865
Ravenclaw Raider
3.06%
2066
Councilman Higarth
3.05%
2120
Archmage Ataeric
2.94%
485
Blackrock Outrunner
2.91%
3280
Witchwing Windcaller
2.91%
3464
Gazrog
2.9%
636
Defias Blackguard
2.88%
2478
Tauren Horde Runner
2.86%
2192
Firecaller Radison
2.82%
1180
Mo'grosh Brute
2.81%
3672
Boahn
2.78%
4070
Venture Co. Builder
2.76%
1176
Tunnel Rat Forager
2.75%
623
Skeletal Miner
2.72%
1164
Stonesplinter Bonesnapper
2.71%
456
Murloc Minor Oracle
2.7%
3528
Pyrewood Armorer
2.7%
2203
Greymist Seer
2.69%
641
Goblin Woodcarver
2.68%
1942
Rot Hide Savage
2.67%
430
Redridge Mystic
2.67%
2202
Greymist Coastrunner
2.67%
1169
Dark Iron Insurgent
2.66%
1913
Dalaran Warder
2.65%
3286
Venture Co. Overseer
2.65%
1767
Vile Fin Shredder
2.64%
2168
Blackwood Warrior
2.64%
596
Brainwashed Noble
2.63%
3393
Captain Fairmount
2.63%
2179
Stormscale Wave Rider
2.62%
1162
Stonesplinter Scout
2.62%
3530
Pyrewood Tailor
2.6%
1769
Moonrage Whitescalp
2.6%
481
Defias Footpad
2.59%
4003
Windshear Geomancer
2.59%
2169
Blackwood Totemic
2.59%
449
Defias Knuckleduster
2.58%
1974
Ravenclaw Drudger
2.58%
624
Undead Excavator
2.56%
1772
Rot Hide Gladerunner
2.55%
502
Benny Blaanco
2.54%
3384
Southsea Privateer
2.54%
2067
Councilman Brunswick
2.54%
4416
Defias Strip Miner
2.54%
1173
Tunnel Rat Scout
2.54%
4418
Defias Wizard
2.53%
2336
Dark Strand Fanatic
2.53%
1866
Ravenclaw Slave
2.53%
3263
Bristleback Geomancer
2.52%
2184
Lady Moongazer
2.52%
3276
Witchwing Harpy
2.51%
2068
Lord Mayor Morrison
2.5%
1947
Thule Ravenclaw
2.5%
1165
Stonesplinter Geomancer
2.5%
4417
Defias Taskmaster
2.5%
3274
Kolkar Pack Runner
2.49%
3275
Kolkar Marauder
2.49%
2178
Wailing Highborne
2.48%
2181
Stormscale Myrmidon
2.48%
513
Murloc Netter
2.48%
3471
Tinkerer Sniggles
2.48%
598
Defias Miner
2.47%
622
Goblin Engineer
2.46%
3260
Bristleback Water Seeker
2.45%
3277
Witchwing Roguefeather
2.45%
3991
Venture Co. Deforester
2.45%
3268
Razormane Thornweaver
2.45%
2176
Cursed Highborne
2.45%
1782
Moonrage Darksoul
2.45%
122
Defias Highwayman
2.45%
501
Riverpaw Herbalist
2.44%
124
Riverpaw Brute
2.44%
1726
Defias Magician
2.44%
1732
Defias Squallshaper
2.44%
619
Defias Conjurer
2.43%
95
Defias Smuggler
2.43%
423
Redridge Mongrel
2.42%
1197
Stonesplinter Shaman
2.42%
1869
Ravenclaw Champion
2.41%
2205
Greymist Warrior
2.41%
1725
Defias Watchman
2.41%
594
Defias Henchman
2.4%
657
Defias Pirate
2.4%
1205
Grawmug
2.4%
1727
Defias Worker
2.4%
1894
Pyrewood Sentry
2.39%
3284
Venture Co. Drudger
2.39%
3272
Kolkar Wrangler
2.39%
2177
Writhing Highborne
2.39%
1953
Lake Skulker
2.38%
424
Redridge Poacher
2.38%
3282
Venture Co. Mercenary
2.38%
1163
Stonesplinter Skullthumper
2.38%
440
Blackrock Grunt
2.38%
2201
Greymist Raider
2.37%
580
Redridge Drudger
2.37%
458
Murloc Hunter
2.37%
1958
Vile Fin Tidecaller
2.37%
2149
Dark Iron Raider
2.36%
590
Defias Looter
2.36%
1939
Rot Hide Brute
2.36%
3947
Goblin Shipbuilder
2.36%
3266
Razormane Defender
2.36%
634
Defias Overseer
2.36%
3386
Theramore Preserver
2.36%
599
Marisa du'Paige
2.35%
121
Defias Pathstalker
2.35%
3273
Kolkar Stormer
2.35%
3278
Witchwing Slayer
2.35%
98
Riverpaw Taskmaster
2.35%
1183
Mo'grosh Mystic
2.35%
3467
Baron Longshore
2.34%
3267
Razormane Water Seeker
2.34%
3383
Southsea Cutthroat
2.34%
123
Riverpaw Mongrel
2.34%
1202
Tunnel Rat Kobold
2.33%
3261
Bristleback Thornweaver
2.33%
3382
Southsea Cannoneer
2.33%
1161
Stonesplinter Trogg
2.33%
3840
Druid of the Fang
2.33%
452
Riverpaw Bandit
2.33%
1167
Stonesplinter Digger
2.33%
2339
Twilight Thug
2.32%
2324
Blackwood Windtalker
2.32%
3989
Venture Co. Logger
2.32%
712
Redridge Thrasher
2.31%
1773
Rot Hide Mystic
2.31%
1940
Rot Hide Plague Weaver
2.31%
824
Defias Digger
2.31%
1236
Kobold Digger
2.31%
3456
Razormane Pathfinder
2.3%
3258
Bristleback Hunter
2.3%
1172
Tunnel Rat Vermin
2.3%
2167
Blackwood Pathfinder
2.3%
2207
Greymist Oracle
2.29%
2212
Deth'ryll Satyr
2.29%
126
Murloc Coastrunner
2.29%
2189
Vile Sprite
2.29%
2332
Valdred Moray
2.28%
1178
Mo'grosh Ogre
2.28%
500
Riverpaw Scout
2.28%
446
Redridge Basher
2.28%
3285
Venture Co. Peon
2.28%
3271
Razormane Mystic
2.28%
1175
Tunnel Rat Digger
2.28%
426
Redridge Brute
2.27%
3265
Razormane Hunter
2.27%
1915
Dalaran Conjuror
2.27%
2054
Sickly Refugee
2.27%
1729
Defias Evoker
2.27%
1426
Riverpaw Miner
2.26%
1892
Moonrage Watcher
2.26%
2106
Apothecary Berard
2.26%
2191
Licillin
2.26%
3283
Venture Co. Enforcer
2.25%
3380
Burning Blade Acolyte
2.25%
2190
Wild Grell
2.24%
504
Defias Trapper
2.24%
1971
Ivar the Foul
2.24%
3381
Southsea Brigand
2.24%
1166
Stonesplinter Seer
2.23%
589
Defias Pillager
2.23%
1867
Dalaran Apprentice
2.22%
1174
Tunnel Rat Geomancer
2.22%
3988
Venture Co. Operator
2.21%
1731
Goblin Craftsman
2.21%
517
Murloc Oracle
2.2%
3452
Serena Bloodfeather
2.19%
1889
Dalaran Wizard
2.19%
1779
Moonrage Glutton
2.19%
578
Murloc Scout
2.18%
1868
Ravenclaw Servant
2.18%
3269
Razormane Geomancer
2.17%
2158
Gravelflint Scout
2.17%
1912
Dalaran Protector
2.17%
3385
Theramore Marine
2.16%
1181
Mo'grosh Shaman
2.16%
1973
Ravenclaw Guardian
2.16%
548
Murloc Minor Tidecaller
2.15%
1888
Dalaran Watcher
2.15%
3667
Anaya Dawnrunner
2.14%
515
Murloc Raider
2.14%
2180
Stormscale Siren
2.14%
1393
Berserk Trogg
2.13%
117
Riverpaw Gnoll
2.13%
3397
Kolkar Bloodcharger
2.13%
1914
Dalaran Mage
2.13%
1870
Hand of Ravenclaw
2.13%
2053
Haggard Refugee
2.12%
2170
Blackwood Ursa
2.12%
1083
Murloc Shorestriker
2.11%
846
Ghoul
2.11%
1957
Vile Fin Shorecreeper
2.1%
2206
Greymist Hunter
2.1%
625
Undead Dynamiter
2.1%
519
Slark
2.1%
2171
Blackwood Shaman
2.09%
1956
Elder Lake Creeper
2.08%
3270
Elder Mystic Razorsnout
2.07%
127
Murloc Tidehunter
2.06%
1909
Vile Fin Lakestalker
2.05%
3394
Barak Kodobane
2.05%
2159
Gravelflint Bonesnapper
2.05%
2204
Greymist Netter
2.04%
1179
Mo'grosh Enforcer
2.04%
171
Murloc Warrior
2.04%
3379
Burning Blade Bruiser
2.03%
2208
Greymist Tidehunter
2.01%
1954
Elder Lake Skulker
2.01%
1177
Tunnel Rat Surveyor
2.01%
5682
Dalin Forgewright
2.01%
1425
Grizlak
2%
1380
Saean
2%
3395
Verog the Dervish
2%
2182
Stormscale Sorceress
2%
422
Murloc Flesheater
1.99%
1955
Lake Creeper
1.99%
1896
Moonrage Elder
1.98%
2338
Twilight Disciple
1.98%
3992
Venture Co. Engineer
1.93%
450
Defias Renegade Mage
1.93%
3577
Dalaran Brewmaster
1.91%
3578
Dalaran Miner
1.9%
3470
Rathorian
1.88%
3279
Witchwing Ambusher
1.87%
3454
Cannoneer Smythe
1.85%
3396
Hezrul Bloodmark
1.83%
626
Foreman Thistlenettle
1.8%
1222
Dark Iron Sapper
1.79%
391
Old Murk-Eye
1.79%
3438
Kreenig Snarlsnout
1.78%
2183
Stormscale Warrior
1.78%
1770
Moonrage Darkrunner
1.78%
1924
Moonrage Bloodhowler
1.77%
1206
Gnasher
1.71%
1895
Pyrewood Elder
1.7%
1908
Vile Fin Oracle
1.7%
2065
Councilman Cooper
1.69%
1972
Grimson the Pale
1.68%
550
Defias Messenger
1.66%
3445
Supervisor Lugwizzle
1.58%
2160
Gravelflint Geomancer
1.2%
2283
Ravenclaw Regent
1.19%
1983
Nightlash
1.19%
1398
Boss Galgosh
1.1%
3655
Mad Magglish
1.1%
1893
Moonrage Sentry
1.08%
2477
Orc Horde Runner
1.08%
572
Leprithus
0.99%
1210
Chok'sul
0.85%
2063
Councilman Wilhelm
0.79%
1065
Riverpaw Shaman
0.73%
1981
Dark Iron Ambusher
0.56%
711
Ardo Dirtpaw
0.26%
3660
Athrikus Narassin
0.22%
3619
Ghost Saber
0.18%
445
Redridge Alpha
0.18%
518
Yowler
0.14%
2157
Stone Behemoth
0.12%
2156
Cracked Golem
0.08%
3862
Slavering Worg
0.08%
2337
Dark Strand Voidcaller
0.06%
5055
Deviate Lasher
0.06%
2234
Young Reef Crawler
0.06%
2174
Coastal Frenzy
0.04%
5755
Deviate Viper
0.04%
2231
Pygmy Tide Crawler
0.04%
2236
Raging Reef Crawler
0.04%
1216
Shore Crawler
0.04%
3944
Wrathtail Priestess
0.04%
3993
Venture Co. Machine Smith
0.04%
4014
Pridewing Consort
0.03%
2235
Reef Crawler
0.02%
1184
Cliff Lurker
0.02%
834
Coyote
0.02%
379
Darcy
0.02%
3727
Dark Strand Enforcer
0.02%
3730
Dark Strand Excavator
0.02%
2185
Darkshore Thresher
0.02%
5048
Deviate Adder
0.02%
5756
Deviate Venomwing
0.02%
1778
Ferocious Grizzled Bear
0.02%
1109
Fleshripper
0.02%
3823
Ghostpaw Runner
0.02%
1797
Giant Grizzled Bear
0.02%
157
Goretusk
0.02%
547
Great Goretusk
0.02%
505
Greater Tarantula
0.02%
114
Harvest Watcher
0.02%
3875
Haunted Servitor
0.02%
4316
Kolkar Packhound
0.02%
1191
Mangy Mountain Boar
0.02%
1766
Mottled Worg
0.02%
3461
Mud Thresh
0.02%
4012
Pridewing Wyvern
0.02%
2164
Rabid Thistle Bear
0.02%
1327
Reese Langston
0.02%
4036
Rogue Flame Spirit
0.02%
3855
Shadowfang Darksoul
0.02%
3256
Sunscale Scytheclaw
0.02%
442
Tarantula
0.02%
3239
Thunderhead
0.02%
2232
Tide Crawler
0.02%
3712
Wrathtail Razortail
0.02%
3717
Wrathtail Sorceress
0.02%
3713
Wrathtail Wave Rider
0.02%
199
Young Fleshripper
0.02%
454
Young Goretusk
0.02%
1224
Young Threshadon
0.02%
3999
Windshear Digger
0.01%
3853
Shadowfang Moonwalker
0.01%
3640
Evolving Ectoplasm
0.01%
Item is a reagent for spell (1)
Item is a quest requirement (2)
6962
(not found)
7025
(not found)
Item details
UPDATE `item_template` SET `field`
= xxxx WHERE (`entry` = 1179);
Field | Value |
---|---|
entry | 1179 |
class | Consumable |
subclass | -1x |
name | Ice Cold Milk |
description | |
display_id | 10531 |
quality | 1 |
flags | None |
buy_count | 5 |
buy_price | 1s 25c |
sell_price | 6c |
inventory_type | 0: Cannot Equip |
allowable_class | 32767 |
allowable_race | -1 |
item_level | 15 |
required_level | 5 |
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 | 431: Drink II |
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 | 7 |
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 |