Discussion of Games' Scores

[ThundeRumble]

Originally Posted by TheGuru

This is a great idea, nice one ;-)

As Benny has already said he is also working a simliar idea which is a PHP script that lists the Top 10 highest scores ever for each game. consider it a Hall of Fame It looks great as it matches the Forum layout.

Perhaps the two could be combined in someway :?:

of course, having access to the database, via a resident .php, it becomes a matter of a couple of "SELECT ... WHERE...".

High scores tables - as I think - are separated in the database, so the listing of ten best players for each game becomes very easy...

I've used EXCEL, instead... a little bit harder... ;-)

[TheGuru]

Originally Posted by ThundeRumble

of course, having access to the database, via a resident .php, it becomes a matter of a couple of "SELECT ... WHERE...".

High scores tables - as I think - are separated in the database, so the listing of ten best players for each game becomes very easy...

I've used EXCEL, instead... a little bit harder... ;-)

The data is in one DB ;-)

[Benny]

One database... with many tables. The highscore data is only in one table, but other tables are required to lookup the game name and whether the best score is the highest or the lowest... I think you were both aluding to this

It's a sligtly more difficult problem we're tackling, cos it has to handle multiple sets of highscores for whenever they're reset. Using the same dataset I've also been thinking about an all-time player ranking system, which is more the kind of thing ThundeRumble has done. Two of the ideas I had some time ago are quoted below:

Originally Posted by Somewhere else Benny

Keep a count of how many 1st positions each player has.
Calculate a skill ranking for each player based on various statistics concerning their scores, positions, dates, etc. (This is starting to sound like a project I would give to a student! )

[ThundeRumble]

Originally Posted by Benny

One database... with many tables. The highscore data is only in one table, but other tables are required to lookup the game name and whether the best score is the highest or the lowest... I think you were both aluding to this

It's a sligtly more difficult problem we're tackling, cos it has to handle multiple sets of highscores for whenever they're reset. Using the same dataset I've also been thinking about an all-time player ranking system, which is more the kind of thing ThundeRumble has done. Two of the ideas I had some time ago are quoted below:

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.

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.

BTW here's how:

dload the games pages (the source) and get the names used for link to highscores' tables.

then dload every highscore table, looks for keywords in html and locate what I want in the page...

so I can locate the first 10 occurrences of names in every higscores' tables
;-) ;-)

[Benny]

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.

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?

[ThundeRumble]

Originally Posted by Benny

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?

VBA saves automatically html files in txt on hd, then second part that scans txt to find keywords, login datas, lucky, are stored in cache/cookies so EXCEL too gets access, but - anyway - it's not a problem since pages that I need are available, in reading mode, also for anonymous...