From what I'm gathering I can just have it pulled from the website and mirrored/pulled into the game when you click the leaderboard option? If so I'll just go that route.

That leads me into my next question- would a website be able to auto sort high scores that are submitted and update it daily? Is it much more feasible  to have it update weekly?

3 hours ago, h8CplusplusGuru said:

You cant get a server because of money. If anyone buys your game you'll have money. Why not host your own server on one of your own computers? It's not as if you expect to have crazy traffic, do you? Do you Apache? Maybe you should. 

This may sound like a dumb question but whats Apache? 

Apache is a web sever that manages TCP connections for HTTP communication.  Apache delegates the TCP connection to another script or process, which then processes the request and prepares an appropriate HTTP response with data.  With the appropriate accompanying apache2 module, you can use PHP, Python, or even Perl.  This is the easiest approach.

Another alternative is to write a program that listens to TCP connections on port 80, and handle the HTTP request/response yourself.

The idea with either approach is to handle the two major functions of a leader board:

• Fetch the top ranking scores of all time
• Add a high score entry

8 minutes ago, fastcall22 said:

Apache is a web sever that manages TCP connections for HTTP communication.  Apache delegates the TCP connection to another script or process, which then processes the request and prepares an appropriate HTTP response with data.  With the appropriate accompanying apache2 module, you can use PHP, Python, or even Perl.  This is the easiest approach.

Another alternative is to write a program that listens to TCP connections on port 80, and handle the HTTP request/response yourself.

The idea with either approach is to handle the two major functions of a leader board:

• Fetch the top ranking scores of all time
• Add a high score entry

 

So would it be easier to use Apache as a go between or as the overall host for the site and leaderboard database? 

Or am i missing the point completely?

apache allows you to turn your favorite computer into a webserver. From there you can do anything web related, on your own computer, having clients connect directly to your computer.

I'm probably not understanding my options; and I hope i am now.

But to make sure I am this is how it SHOULD be set up. 

Client connects to website, website connects to Database submitting Longin/account information with high score data. . Database stores it and sorts it. At a set interval of time Database should send the information to update on the website so the Client can see the information on website and in the game?

And I will look into getting a tower and converting it to a database and one to convert into a webserver(to save on domain hosting costs down the road?). 

Suggestion...

1. Distribute your software (game) and require that they register with your server to end up on the leaderboard. So the client sends a POST message with their e-mail in the message. The server responds with a signed sha256 hash of that e-mail. From that point on that signed hash identifies the player and is sent every single time the player needs to identify itself to the server. The signed hash and email go into a database on the server.

2. When a player's game is complete, it sends the same sha256 hash to the server with the relevant data (wins, losses, who played etc) in a POST message. That data goes into the database using the hash that identifies the player as a key.

3. When a player wants to see the leaderboard, they send a GET message to the server and a list of player statistics is returned (use e-mail or partial e-mail as a key with stastics as the value). The statistics are alll stored in a database so whenever the server recieves the GET message it just has to do a query.

^The problem will all of that is that it is certainly possible for a player to impersonate another player to the server or for a player impersonate the server to a player and cause all kinds of bad things to happen. You would need to use some kind scheme with public/private key encryption to prevent that. Ideally you would want a server to host the game...so the server is adding the statistics, not the client which you really have no control of.

No matter what you do I would not allow a direct sql connection from the client (player) to the server. Have a webapp to the inserting and querying and act as a shield.

2 hours ago, Aaric90 said:

Client connects to website, website connects to Database submitting Longin/account information with high score data. . Database stores it and sorts it. At a set interval of time Database should send the information to update on the website so the Client can see the information on website and in the game?

Close; that last part is reversed.  The game website should either query the database directly or consume the API that your game will use, and render the leaderboard on the fly.
 

2 hours ago, Aaric90 said:

And I will look into getting a tower and converting it to a database and one to convert into a webserver(to save on domain hosting costs down the road?). 

The game website, the database, and the highscore API need not be on different servers.  Apache2, as well as other webservers, can be configured to direct requests to separate processes/scripts depending on the subdomain(s) used in the requests’ `Host` header.  Then, you can configure your domain to point all the subdomains to the correct servers.