Quote:
|
Originally Posted by ThundeRumble
One DB, many tables, it's not a problem, some where there is the game's list... with this you address the highscore table, you'll look the first ten positions, select names of record's owners, and that's all folks.
|
Well it was not quite that easy... scores are entered for every player as they happen and for every game, there's no concept of "first ten positions" either for score size or for game. Not a difficult problem at all, but not as trivial as you suggest.
Quote:
|
Originally Posted by ThundeRumble
I'm very proud of my solution, because I've done it for reading things in another forum, and I was able to reuse procedures in few minutes to make this little thing.
|
So you should be
Parsing html churned out by someone elses forum software isn't a trivial task, especially when it's split over several pages. Was your program getting the data via http requests using your log-in details or were you saving the html source code manually first?
What do you think about my ranking ideas? My motivation is to produce a ranking scheme that benefits everyone who has set a score rather than just the 1st place trophy holders. I thought of weighting it using the following:
- - Scores that have remained unbeaten the longest
- Scores that have beaten others by the greatest percentage
- Number of times a game has been played
- Length of time a game has been available
Anyone got any other ideas?