3 Replies - 391 Views - Last Post: 14 February 2013 - 08:14 AM Rate Topic: -----

#1 CountBale  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 23
  • Joined: 22-January 13

Online databases

Posted 14 February 2013 - 07:22 AM

My game has high scores and I need a way to store the high scores online so everyone can access the global high scores from in game. Originally I was going to use Mysql but I thought that it would be too easy for people to fake scores with that, what would be the best method for sending, retrieving and storing high scores?
Is This A Good Question/Topic? 0
  • +

Replies To: Online databases

#2 tlhIn`toq  Icon User is offline

  • Please show what you have already tried when asking a question.
  • member icon

Reputation: 5509
  • View blog
  • Posts: 11,814
  • Joined: 02-June 10

Re: Online databases

Posted 14 February 2013 - 07:32 AM

1 - If you properly parameterize your queries it helps.
2 - Encrypt the data rather than storing plan text like "Bob, 145000"


Q:... how to do x,y,z with a database {probably for the first time}...
A: Read this tutorial
Entire section of tutorials
Parameterizing Your SQL Queries: The RIGHT Way To Query A Database.
Using SqlDependency to monitor SQL database changes
Was This Post Helpful? 0
  • +
  • -

#3 CountBale  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 23
  • Joined: 22-January 13

Re: Online databases

Posted 14 February 2013 - 08:01 AM

View PosttlhIn`toq, on 14 February 2013 - 07:32 AM, said:

1 - If you properly parameterize your queries it helps.
2 - Encrypt the data rather than storing plan text like "Bob, 145000"


Q:... how to do x,y,z with a database {probably for the first time}...
A: Read this tutorial
Entire section of tutorials
Parameterizing Your SQL Queries: The RIGHT Way To Query A Database.
Using SqlDependency to monitor SQL database changes


Thanks, I will try a simple encryption. I doubt I need anything complex since I'm not going to be releasing this game or anything.
Was This Post Helpful? 0
  • +
  • -

#4 tlhIn`toq  Icon User is offline

  • Please show what you have already tried when asking a question.
  • member icon

Reputation: 5509
  • View blog
  • Posts: 11,814
  • Joined: 02-June 10

Re: Online databases

Posted 14 February 2013 - 08:14 AM

Don't worry about simple or hard... There are good industrial-level encryption schemes already present in .NET, or other libraries already out there if you are not in Windows.

Take the extra time to work out a quality encryption class one time.
Add that to your personal framework/library/skeleton of code and you won't have to re-invent the wheel for every project.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1