VB6 Quiz Game help

[Dev Alahan]

Hi, I'm relatively new to VB6 and would like some help if possible please. I need to create a quiz game using VB6 where a player answers 6 randomly generated questions and gets points for every correct answer given.

Now, I have been able to create the game but the final stage I am having trouble with is creating a 'leaderboard' where the top 10 scores are displayed. I have a 'Submit Score' command button on my main game form, which takes the player through to a 'Scores' form. This also takes over the player name, level and score using global variables. My college lecturer has advised that I need to add the scores to a database, and then the top 10scores are displayed on the form.

My questions are this:

1) How do I get the player scores into the database?
2) How do I then get the top 10 scores displayed on the form? Should I use SQL?

All help is appreciated!

[smUX]

If your lecturer's advice is just that, and not a requirement, there are better ways to do such a simple task. Search the forum for "hiscores" and other key words and you should be able to find some examples.

Personally I'd just save the top 10 scores into a text file and use that, although unless you encrypt the data it'd be easy to cheat and add your own scores.

[akhileshbc]

For storing the scores in database, you can use MS Access as backend...
For tutorials: http://www.vbforums.com/showthread.php?t=337051#ado

And for displaying the scores, you could just use an SQL SELECT statement and ORDER BY clause (either ASC or DES)....

[Spoo]

Dev

Another alternative -- dirt cheap (and assumes you don't
have access to (ahem) Access) -- just store the top 10
scores in a text file.

You'll need some code to read from/write to the text file,
but it is fairly basic. Holler if you want to go down this road.

Spoo

[Dev Alahan]

Hi all, thanks to everyone that has replied.

Spoo - I do have Access, but if you think the text file option is easier, then I'm open to your suggestions!

Would it be easy to update after each score submission and then sort the top 10 scores?

Cheers

[Spoo]

Dev

It depends on what "easier" means...

Since you have Access, that would probably be easier.

However, if you plan to distribute your game to some users who
don't have it, then the text file option would seem appropriate.

How would you like to proceed?

Spoo

[smUX]

I was the first person to respond to this, and I mentioned text file as a method...I *also* mentioned searching the forum for ALREADY ANSWERED posts about this question, of which there are many.

[Code Doc]

Dev

Another alternative -- dirt cheap (and assumes you don't
have access to (ahem) Access) -- just store the top 10
scores in a text file.

You'll need some code to read from/write to the text file,
but it is fairly basic. Holler if you want to go down this road.

Spoo

Spoo, I think he could aslo store the top ten stores in a random access file, each record holding a user identifier and a score. Prior to writing to the file, he can check all existing scores and if the user doesn't crack the top ten, notify and trash the result. If he does, store it.

Note that ties will have to be handled. Eventually, the top ten could have all reached the total points possible.