Refreshing Spring Water

Item

General

Item model

Field Value
entry 159
class Consumable
display_id 6366
sell_price 1c
inventory_type 0: Cannot Equip
spellid_1 430: Drink

In-game view

Refreshing Spring Water

Item icon

Consumable
Cannot Equip
Level 5 (Min 1)

Casts:
430: Drink

Buy price: 25c

Stackable: 20

Sold by (109)

151 Brog Hamfist 152 Brother Danil 227 Mabel Solaj 258 Joshua Maclure 274 Barkeep Hann 295 Innkeeper Farley 465 Barkeep Dobbins 491 Quartermaster Lewis 734 Corporal Bluth 791 Lindsay Ashlock 829 Adlin Pridedrift 955 Sergeant De Vries 982 Thultash 1149 Uthok 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 1691 Kreg Bilmn 1697 Keeg Gibn 2084 Natheril Raincaller 2115 Joshua Kien 2134 Mrs. Winters 2140 Edwin Harly 2352 Innkeeper Anderson 2364 Neema 2366 Barkeep Kelly 2381 Micha Yance 2388 Innkeeper Shay 2397 Derak Nightfall 2401 Kayren Soothallow 2664 Kelsey Yance 2803 Malygen 2806 Bale 2808 Vikki Lonsav 2820 Graud 2832 Nixxrax Fillamug 2908 Grawl 3027 Naal Mistrunner 3072 Kawnie Softbreeze 3076 Moorat Longstride 3085 Gloria Femmel 3086 Gretchen Vogel 3158 Duokna 3164 Jark 3186 K'waii 3298 Gabrielle Chase 3313 Trak'gen 3350 Asoran 3400 Xen'to 3411 Denni'ka 3481 Barg 3498 Jazzik 3541 Sarah Raycroft 3546 Bernie Heisten 3587 Lyrai 3608 Aldia 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 4170 Ellandrieth 4181 Fyrenna 4182 Dalmond 4190 Kyndri 4191 Allyndia 4192 Taldan 4195 Tiyani 4223 Fyldan 4241 Mydrannul 4265 Nyoma 4266 Danlyia 4553 Ronald Burch 4554 Tawny Grisette 4555 Eleanor Rusk 4571 Morley Bates 4782 Truk Wildbeard 4875 Turhaw 4876 Jawn Highmesa 4879 Ogg'marr 4893 Bartender Lillian 4896 Charity Mipsy 4981 Ben Trias 5101 Bryllia Ironbrand 5111 Bogrum Firebrew 5112 Gwenna Firebrew 5140 Edris Barleybeard 5160 Emrul Riknussun 5483 Erika Tate 5611 Barkeep Morag 5620 Bartender Wental 5688 Renee Samson

Item dropped by (223)

3577 Dalaran Brewmaster 100% 3662 Delmanis the Hated 100% 3141 Makrura Elder 10.36% 1916 Stephen Bhartec 8.37% 103 Garrick Padfoot 7.37% 1918 Karrel Grayves 7.25% 1502 Wretched Zombie 7.09% 2953 Bristleback Shaman 6.84% 1989 Grellkin 6.79% 1988 Grell 6.72% 706 Frostmane Troll Whelp 6.71% 1718 Rockjaw Raider 6.7% 707 Rockjaw Trogg 6.7% 1890 Rattlecage Skeleton 6.7% 1501 Mindless Zombie 6.68% 1506 Scarlet Convert 6.66% 724 Burly Rockjaw Trogg 6.63% 1507 Scarlet Initiate 6.6% 3101 Vile Familiar 6.56% 3229 "Squealer" Thornmantle 6.55% 6 Kobold Vermin 6.55% 257 Kobold Worker 6.52% 2952 Bristleback Quilboar 6.48% 1919 Samuel Fipps 6.46% 80 Kobold Laborer 6.44% 38 Defias Thug 6.4% 1917 Daniel Ulfman 6.34% 583 Defias Ambusher 5.99% 946 Frostmane Novice 5.98% 808 Grik'nir the Cold 5.85% 2014 Gnarlpine Totemic 5.59% 1667 Meven Korgal 5.43% 3183 Yarrog Baneshadow 5.19% 1388 Vagash 5.18% 2021 Bloodfeather Matriarch 5.1% 2984 Seer Wiserunner 5% 1936 Farmer Solliden 4.92% 1664 Captain Vachon 4.75% 1118 Rockjaw Backbreaker 4.68% 1271 Old Icebeard 4.64% 99 Morgaine the Sly 4.51% 2162 Agal 4.49% 2968 Galak Outrunner 4.44% 1665 Captain Melrache 4.42% 2951 Palemane Poacher 4.41% 1124 Frostmane Shadowcaster 4.34% 1935 Tirisfal Farmhand 4.28% 2004 Dark Sprite 4.23% 2002 Rascal Sprite 4.22% 1946 Lillith Nefara 4.21% 3206 Voodoo Troll 4.21% 3104 Makrura Shellhide 4.2% 1528 Shambling Horror 4.2% 1658 Captain Dargol 4.18% 3195 Burning Blade Thug 4.16% 2976 Venture Co. Laborer 4.14% 2020 Bloodfeather Wind Witch 4.13% 1120 Frostmane Troll 4.1% 1534 Wailing Ancestor 4.09% 3113 Razormane Dustrunner 4.09% 2015 Bloodfeather Harpy 4.08% 3116 Dustwind Pillager 4.08% 94 Defias Cutpurse 4.03% 735 Murloc Streamrunner 4.01% 3114 Razormane Battleguard 4% 1523 Cracked Skull Soldier 4% 285 Murloc 4% 1116 Rockjaw Ambusher 4% 1911 Deeb 4% 2962 Windfury Harpy 3.98% 1993 Greenpaw 3.97% 116 Defias Bandit 3.97% 1545 Vile Fin Muckdweller 3.96% 1211 Leper Gnome 3.95% 1525 Rotting Dead 3.95% 3103 Makrura Clacker 3.94% 2977 Venture Co. Taskmaster 3.94% 1527 Hungering Dead 3.94% 1934 Tirisfal Farmer 3.94% 3111 Razormane Quilboar 3.92% 1543 Vile Fin Puddlejumper 3.91% 2013 Gnarlpine Avenger 3.89% 1135 Wendigo 3.89% 2965 Windfury Matriarch 3.89% 473 Morgan the Collector 3.88% 1526 Ravaged Corpse 3.88% 2963 Windfury Wind Witch 3.86% 3199 Burning Blade Cultist 3.86% 2949 Palemane Tanner 3.86% 478 Riverpaw Outrunner 3.84% 2964 Windfury Sorceress 3.82% 1675 Rot Hide Mongrel 3.82% 2039 Ursal the Mauler 3.81% 1520 Rattlecage Soldier 3.81% 1537 Scarlet Zealot 3.8% 1674 Rot Hide Gnoll 3.79% 2029 Timberling Mire Beast 3.78% 1544 Vile Fin Minor Oracle 3.78% 2006 Gnarlpine Ursa 3.77% 476 Kobold Geomancer 3.75% 1536 Scarlet Missionary 3.74% 2011 Gnarlpine Augur 3.74% 1134 Young Wendigo 3.73% 3118 Dustwind Storm Witch 3.72% 100 Gruff Swiftbite 3.72% 3197 Burning Blade Fanatic 3.71% 3128 Kul Tiras Sailor 3.71% 1115 Rockjaw Skullthumper 3.7% 1121 Frostmane Snowstrider 3.7% 474 Defias Rogue Wizard 3.69% 2007 Gnarlpine Gardener 3.68% 3117 Dustwind Savage 3.68% 3115 Dustwind Harpy 3.67% 3129 Kul Tiras Marine 3.67% 40 Kobold Miner 3.67% 732 Murloc Lurker 3.67% 2152 Gnarlpine Ambusher 3.66% 2022 Timberling 3.66% 1522 Darkeye Bonecaster 3.65% 2017 Bloodfeather Rogue 3.64% 475 Kobold Tunneler 3.63% 2010 Gnarlpine Defender 3.63% 1117 Rockjaw Bonesnapper 3.62% 2009 Gnarlpine Shaman 3.62% 3198 Burning Blade Apprentice 3.62% 2975 Venture Co. Hireling 3.62% 3207 Hexed Troll 3.62% 3112 Razormane Scout 3.62% 1535 Scarlet Warrior 3.62% 2025 Timberling Bark Ripper 3.61% 3120 Kolkar Outrunner 3.6% 2989 Bael'dun Digger 3.6% 1530 Rotting Ancestor 3.6% 1654 Gregor Agamand 3.6% 881 Surena Caledon 3.59% 1538 Scarlet Friar 3.59% 1123 Frostmane Headhunter 3.59% 1656 Thurman Agamand 3.55% 46 Murloc Forager 3.55% 327 Goldtooth 3.55% 1122 Frostmane Hideskinner 3.54% 2019 Bloodfeather Fury 3.54% 2008 Gnarlpine Warrior 3.53% 2950 Palemane Skinner 3.52% 2979 Venture Co. Supervisor 3.51% 2003 Shadow Sprite 3.51% 2012 Gnarlpine Pathfinder 3.51% 448 Hogger 3.51% 1532 Wandering Spirit 3.5% 2978 Venture Co. Worker 3.5% 3119 Kolkar Drudge 3.48% 2990 Bael'dun Appraiser 3.48% 1540 Scarlet Vanguard 3.45% 1941 Rot Hide Graverobber 3.43% 880 Erlan Drudgemoor 3.42% 2018 Bloodfeather Sorceress 3.41% 2005 Vicious Grell 3.4% 1529 Bleeding Horror 3.4% 1539 Scarlet Neophyte 3.39% 1662 Captain Perrine 3.38% 3205 Zalazane 3.36% 1533 Tormented Spirit 3.36% 2027 Timberling Trampler 3.35% 1397 Frostmane Seer 3.35% 3232 Bristleback Interloper 3.34% 2030 Elder Timberling 3.32% 79 Narg the Taskmaster 3.32% 97 Riverpaw Runt 3.3% 472 Fedfennel 3.26% 3196 Burning Blade Neophyte 3.26% 2038 Lord Melenas 3.25% 3192 Lieutenant Benedict 3.24% 1657 Devlin Agamand 3.13% 1949 Servant of Azora 3.13% 1260 Great Father Arctikus 3.08% 1660 Scarlet Bodyguard 2.94% 61 Thuros Lightfingers 2.82% 2166 Oakenscowl 2.81% 1753 Maggot Eye 2.79% 1531 Lost Soul 2.74% 3051 Supervisor Fizsprocket 2.73% 60 Ruklar the Trapper 2.65% 1655 Nissa Agamand 2.56% 2967 Galak Centaur 2.38% 3203 Fizzle Darkstorm 2.3% 3204 Gazz'uz 2.25% 3105 Makrura Snapclaw 2.17% 1137 Edan the Howler 1.94% 1910 Muad 1.72% 3535 Blackmoss the Fetid 1.23% 1119 Hammerspine 0.94% 471 Mother Fang 0.2% 3121 Durotar Tiger 0.06% 1994 Githyiss the Vile 0.06% 3131 Lightning Hide 0.06% 1132 Timber 0.06% 43 Mine Spider 0.05% 3122 Bloodtalon Taillasher 0.04% 1688 Night Web Matriarch 0.04% 3100 Elder Mottled Boar 0.02% 3126 Armored Scorpid 0.02% 5426 Blisterpaw Hyena 0.02% 3110 Dreadmaw Crocilisk 0.02% 5429 Fire Roc 0.02% 3566 Flatland Prowler 0.02% 30 Forest Spider 0.02% 2044 Forlorn Spirit 0.02% 1553 Greater Duskbat 0.02% 1505 Night Web Spider 0.02% 390 Porcine Entourage 0.02% 2959 Prairie Stalker 0.02% 2960 Prairie Wolf Alpha 0.02% 3106 Pygmy Surf Crawler 0.02% 524 Rockhide Boar 0.02% 113 Stonetusk Boar 0.02% 1995 Strigid Owl 0.02% 3107 Surf Crawler 0.02% 1985 Thistle Boar 0.02% 3130 Thunder Lizard 0.02% 3127 Venomtail Scorpid 0.02% 1986 Webwood Spider 0.02% 1999 Webwood Venomfang 0.02% 822 Young Forest Bear 0.02%

Item is a quest reward (7)

8 A Rogue's Deal 381 The Scarlet Crusade
1656 (not found)
2158 (not found)
2159 (not found)
2160 (not found)
2161 (not found)

Item is a quest requirement (1)

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 159);
Field Value
entry 159
class Consumable
subclass -1x
name Refreshing Spring Water
description
display_id 6366
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 430: Drink
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 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 0
min_money_loot 0
max_money_loot 0
extra_flags 0
ignored 0