Ice Cold Milk

Item

General

Item model

Field Value
entry 1179
class Consumable
display_id 10531
sell_price 6c
inventory_type 0: Cannot Equip
spellid_1 431: Drink II

In-game view

Ice Cold Milk

Item icon

Consumable
Cannot Equip
Level 15 (Min 5)

Casts:
431: Drink II

Buy price: 1s 25c

Stackable: 20

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