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 reagent for spell (3)
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 |