Page 1 of 1

Need help with MySQL for a leaderboard

Posted: Tue Jul 29, 2014 4:51 pm
by TubooBokBok
Hello. I have been working on an android app and am now trying to implement a global leaderboard where high scores are saved.

Pretty much I want my app to retrieve a list of the top 50 scores, compare them to see if the users new score is better then any of them, if so place it in the leaderboard and re-order the scores. The top 50 scores would also be displayed in the app.

My question is should I use MySQL for this and if so how would I go about it? I have read the Runrev tutorials but I cannot follow them becasue I have no knowledge of how MySQL acctually works and how I could change their code to meet my needs.

Any help is greatly appreciated. Thanks.

Re: Need help with MySQL for a leaderboard

Posted: Tue Jul 29, 2014 11:01 pm
by sefrojones
HI,

I made a simple game/stack with a MySQL high score board, The full stack (minus my DB info) is available in this thread: (Scroll down, it is in the LAST mega link I posted)

http://forums.livecode.com/viewtopic.php?f=22&t=19380

The script that handles the database is in the button "done" of the group "entername" you can add your own mysql database info there.

You can set up a quick free MySQL database to test it out at :

http://www.freesqldatabase.com/


--Sefro

Re: Need help with MySQL for a leaderboard

Posted: Wed Jul 30, 2014 4:00 pm
by TubooBokBok
Thank you very much!