Quaddicted needs a real search function for the maps

A proper, useful, linkable search interface to http://www.quaddicted.com/reviews/ is needed. I myself am not capable of writing it so I am looking for help. It will be a 50$ bounty but for that we will need to decide what is needed. So, what features would you like?

On another note, any idea if people might be more inclined to help out with these kinds of things self-initiated if the code to that part of the site was open-sourced?

The obvious: Filter/sort by any of the data fields. Eg (here in human words):
show earlier than 1999
show dates from 2001-2008
sizes from 500KB-4MB
sizes smaller 10MB
releases by author X
without the tags base, small and stupid
rated better than 3 (by community)

The stuff must be in PHP.

And for anyone interested in peeking in, here is the current database, usernames and comment times are stripped for privacy. http://www.quaddicted.com/stuff/temp/quaddicted.sqlite

Be happy to do it. I’m fairly capable in php & mysql…can give links to stuff I’ve done…

…once you figure out exactly what you want the search function to do…

btw, the link above to the db doesn’t work…


Edit: D’oh! Didn’t realize the link was for a DL…my bad, disregard…

Sometimes I’m lazy and I do not want to download the map, requiring a separate directory. Maybe it sounds strange. But it does not interfere with the choice:

  1. just a map for id1
  2. mod
  3. Map requires a different mod (you can even make a choice for any fashion to make a selection)

Select by rating needed again to mark the checkbox (pure, average, etc.). First, the new player will be all the Excellent-map, and then want nice, and then want to get ideas from the pure-maps. This is more accurate choice, it seems to me unnecessary

Oh yes, it definitely needs filtering by type. Something neither the current javascript filter not the Quake Injector do.

Midgard, linked is the sqlite3 database. :wink:

and for the ranking:


br = ( (avg_num_votes * avg_rating) + (this_num_votes * this_rating) ) / (avg_num_votes + this_num_votes)

avg_num_votes: The average number of votes of all items that have num_votes>0
avg_rating: The average rating of each item (again, of those that have num_votes>0)
this_num_votes: number of votes for this item
this_rating: the rating of this item

Note: avg_num_votes is used as the “magic” weight in this formula. The higher this value, the more votes it takes to influence the bayesian rating value.