Tweet
I'm putting my money on all of the stats being rolled up in a text cell or something... but hey, why not check. Are the stats for food actually values in each SQL table row? Point being, at certain times during certain fights I would love to be able to do a quick search for magic or poison resist food and tweak myself out a little more with a homebaked meal. This a possibility by chance?
-
-
Fairly sure that at this site the effects are stored en bloc so are not searchable, and it would be a considerable effort to alter things to make them so.
Allakhazam's Item Search provides an answer, though I am not sure if this is only available to premium users. For example, this search returns all Food/Drink items with a minimum MR of 1, ordered by MR (the former check is needed to avoid *all* food/drink items being returned). -
Actually I'm not so sure about that. The way the item descriptions are laid out leads me to think that the values are stored individually. The layout of the item stats and the standardized form in which they're presented, without a single exception across all items, makes it far too unlikely that they are typed in manually. It's much more likely that the database has each stat stored separately.
Ngreth has stated before that more detailed search options (which is basically what's being asked for) would take too long to program and probably add a heavier burden on the server. I don't know if this has changed in the last six months or so (when I last remember him mentioning it).Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi MarrComment
-
Note to self: research before posting.
The EQTraders advanced search can already do this. The page is a bit crowded, but the search options are already there. From the home page, click on Search, then Advanced Search. Under "Food or Drink", select Food. In the "svPoison" field, enter 1. Then click Find.Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi MarrComment
-
OMG I never saw advanced search..... PRETTY! <drool>
Comment
-
Yeah, me tooOriginally posted by KyrosKrane
Note to self: research before posting.
Comment
-
Wtf? Advanced search? How could I use a site for so long and not notice something like this... Course I am the same high elf that didn't realize there was a Southern Felwithe until level 40 =/Comment
Comment