Quaddicted.com Forum

Spirit

Administrator

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?

Spirit

Administrator

Re: Quaddicted needs a real search function for the maps

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)

Spirit

Administrator

Re: Quaddicted needs a real search function for the maps

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

Midgard

Member

Re: Quaddicted needs a real search function for the maps

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...

-Midgard

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

Last edited by Midgard (2012-03-23 03:02:50)

Digs

Guest

Re: Quaddicted needs a real search function for the maps

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

Spirit

Administrator

Re: Quaddicted needs a real search function for the maps

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. ;)

spiritit

Guest

Re: Quaddicted needs a real search function for the maps

and for the ranking:

www.thebroth.com/blog/118/bayesian-rating

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

Legend:
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.

Spirit

Administrator

Re: Quaddicted needs a real search function for the maps

Suggestion: option to sort by type (maps, mods, speedmaps).