Hello, I'm new here. Thank you for your time.
I have a PHP module that I use for user submitted poems. Based on the vote data I have poet rankings.
ratingdbid - int
ratinglid - int
ratinguser - char
rating - int
ratinghostname - char
ratingcomments - text
ratingtimestamp - datetime
rating_favorite - int
Right now people are ranked based on Average score. My thought was to create a batch job to maintain a ranking table I could join into this data. My question is what would be best to calculate the ranking on.
Vote data tallies up to:
Average | Reads | Votes | Comments | Page Slam Wins | # Poems
Of that data I can calculate stdev of scores, remove Min and Max from the averages... I can do all sorts of things.
What do you think would work?
Are there any gammers out there with ideas?
Can you think of a better forum on DeniWeb to ask this question?