NightWind's Card Searcher

(02-09-2009 08:22 AM)Runemaster Wrote:  I love you.

Daww... you're so sweet! ^.^ *now feels warm and fuzzy*

(02-09-2009 11:25 AM)Jessica Stryker Wrote:  I just thought of something. Concerning the minimum price feature, while I don't know if it's codeable (and if it is, I'm sure it might be difficult).

But the idea is, let's say you search 1000-5000 and mana bucket comes up (most likely either because somebody did the overpriced bucket trick or because it's overpriced just to keep the store open if everything else sells out). Obviously, there's going to be cheaper ones, so would it be possible to list the cheaper prices or maybe have a note say that there are cheaper prices for this card?

In reverse, perhaps the same for the maximum price, but obviously have it mention there are more expensive prices for this card.

I'm guessing you mean comparing multiple versions of mana bucket as the results are now already sorted. I haven't though about comparing different versions of cards yet as I'm going to work on getting the price range working first before thinking features which add onto that. If I do happen to get the price range to work fully, but forget about the points you mentioned here, remind me.

(02-09-2009 11:45 AM)masamunemaniac Wrote:  I think that was how it worked on the test site (could be wrong though).

The site orders the cards by id. It's been while since I touched the code. I'll try to get the price range basics done first then work whatever needs working on.

(02-09-2009 11:45 AM)masamunemaniac Wrote:  I still don't get why you'd want a minimum price though. I mean, why would you be more interested in Pirate Captain if there was one available for 1000 points but not interested if the most expensive one was 900 points?

The minimum for the price range was an attempt to reduce the result set down to a number accepted by the query, but as you can see, that method doesn't work that well.

(02-09-2009 01:53 PM)NOLDER Wrote:  well i don't know about others but i'd like a minimum price so i could check cards from say....remembrance to Y1C price ranges if i have a ton of points i want to spend but don't know exactly what i want to buy yet

Oh and that too. Good point. Ah, here's to a tired NightWind.

---

I just though of something. I may be able to run the SQL query that's generated from the rest of the search form. Then, I can filter the results according to the card ids found in the price range search. That way, I can have the best of both worlds without it becoming too complex or time consuming. That could work - I'll try this first.