Game Development Community

how to create a online leaderboard??

by Ashwin · in iTorque 2D · 04/24/2009 (3:52 am) · 3 replies

Hello everyone

I just started to learn programming and TGB and I have created my own version of the whack-a-mole game from the tutorial. The game is working now, so now I want add an online leaderboard function for learning purposes.

I know what i have to do
- I have to create a login screen GUI
- get the string from the guitextctrls and hash it
- create a function that will send it to my server, probably with httpobject
- and i have to setup the MySQL database and script on the serverside.

But since my programming knowledge is small and my knowledge about MySQL is almost nothing, I can't translate these concepts to programming language.

I am looking for a tutorial about this and MySQL, but I don't know where to start.

Can someone push me in the right direction?


thanks in advance

Ashwin

#1
04/24/2009 (5:14 am)
If you have a PHP-capable server, the magic keywords to search for are "php mysqli". Look for tutorials mainly, but don't ignore the PHP.net reference. Also note that it's "mysqli", not the more easily exploited "mysql" functions you should learn.
#2
04/26/2009 (1:29 am)
My game, Go Beryllium features an online leaderboard. The source is available here:

www.garagegames.com/community/forums/viewthread/77741

I've used this code on iPhone and it works fine.

Here's a good tutorial on setting up a MySQL database to store your scores:

www.clickteam.com/eng/resources/online_score/onlinescoreboards.html
#3
04/28/2009 (10:25 pm)
Thanks for the tips guys they are really helpful.