Online High Score Tutorial

I also need help with the same problem that Swiff has.
Any help is much appreciated
Thanks

I know that this may be a little late, but the solution I use to only allowing a user to upload one score and have it update their previous score if they get a new one (not using the name identification method, since more than one user might enter the same name) may help someone else out here. It requires a little bit more knowledge on php and how database tables work though, but there are plenty of php and SQL tutorials out there, so if you search, you should be able to find one!

In the game's .ini file, have a "playerID" variable. When they go to submit a high score, have the game check that variable. If it doesn't have a value, that means this user hasn't submitted a high score before. In this case (this is the part where php scripting knowledge comes in handy), have the script pull up the online high scores table sorted by the playerID (you'll have to add this column when creating the database), get the highest playerID and add 1 to it, and write the player's score to a new line in the table, including that new incremented playerID number. Remember to also write that new playerID number to the local .ini file, so that it can be referenced in the future! Then you'll re-sort the table by scores (highest to lowest) and show the top scores. Since the playerID is generated on the server and incremented each time someone new submits a high score, each player will have a unique playerID!

When someone with an existing playerID (written in their .ini file) submits a high score, you'll just tell the php script to locate the entry with that unique playerID, and overwrite those scores (if they're better). Voilà!

I know it's easier said than done, and I wish I had time to write a tutorial about the php side of things, but again, a quick search on the internet for tutorials returns a plethora of resources. (It's how I got to where I am today!)

I hope this helps someone out!

I am currently writing a new tutorial, with a different way of doing a high scores, which has those features in it. and is a lot easier to use as well
Along with 2 easy scripts.

Thank you crjMosh...
I found a solution via a php site
we must work on a php file: score_script.php and a phpadmin where is the database
change to unique in the index of playername in phpadmin page
Please login to see this attachment.
And change the script in the score_script.php fil like this
Please login to see this attachment.
That's all... it works fine

Anybody can help me please? I was able to done everything online score but the original score shown on the scoreboard is too high, i need to reset or delete the data through somewhere, i readed this forum and says delete the myphpadmin that part, i delete them all by clicking the "x" if im not wrong, then I open the scoreboard in the game it shown something weirld(shown at bottom) , I'd login back into myphpadmin but I don't understand anything I can't fix it... please help me...

here's what wrong... soemthing weirld.. after i done something at myphpadmin.
Please login to see this attachment.

confused me... what the beep is this on myphpadmin.. if anyone can teach I'm appreaciate it
Please login to see this attachment.

Problem solved, just browse the database your 123456_scores at myphpadmin> edit> change to 0.

alternative method, chg score with mmf/cf. thanks to sparckman, need some time to learn though:
Please login to see this link.

I got this error message:
"No route to host" - I tried for hours to solve it, with no success.
Anyone know what it means?

I just get an error message:
No route to host
Anyone knows whats wrong, and / or how it can be fixed?

Show the events / scripts... you probably did something wrong or there is something with the host

Bonjour ,

Après plusieurs tentatives donnant des trucs bizarres ,j'aimerai savoir comment modifier le code de Sparckman pour rajouter une colonne supplémentaire intitulé " VILLE " .

Merci

Hello, I need some help because i don't know where to change the code in order to add a " City " column.

Thanks in advance

This is brilliant tutorial, but I'm running into a problem and I don't know how to rectify.

If I do the check to see if the server is online, I get the following error message:
Please login to see this link. <== go to that link to see error.

When creating the database it gives me the following information:

Quote

a7026219_flappy a7026219_flappy mysql13.000webhost.com

(password is definately "flappy")

in the config script I have the following information:

// Your host -- for example localhost or mysql.server.com
	$mysql_host = "mysql13.000webhost.com";
	
	// Your user name for mySQL
	$mysql_user = "a7026219_flappy";
	
	// Your password for mySQL
               $mysql_password = "flappy";
	
	// Your database name for mySQL
	$mysql_database = "a7026219_flappy";

If I run the MFA it reports server offline, and if I run the script in the browser I get:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a7026219_flappy'@'10.1.1.39' (using password: YES) in /home/a7026219/public_html/score_script.php on line 20

Free Web Hosting
Access denied for user 'a7026219_flappy'@'10.1.1.39' (using password: YES)

Any Help would be greatly appreciated.

Password for the DB isn't the one for the actual hosting site

I have error
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a2647550_5687'@'10.1.1.31' (using password: YES) in /home/a2647550/public_html/sparck_score.php on line 14

Free Web Hosting
Access denied for user 'a2647550_5687'@'10.1.1.31' (using password: YES)

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a2647550_5687'@'10.1.1.31' (using password: YES) in /home/a2647550/public_html/sparck_score.php on line 14

Free Web Hosting
Access denied for user 'a2647550_5687'@'10.1.1.31' (using password: YES)

I'm trying online score system. However I got a same error message GamesMania
What I needs more action?
Thanks!Please login to see this attachment.

Hello.

Thank you for the script.
But I can't use next words in mobile_save_score.

"+" "#" "&"
and when "0" is first.

If I use these words when I submit the score, the score list crashes.
How can I fix this?

Hello.

Thank you for the script.
But I can't use next words in mobile_save_score.

"+" "#" "&"
and when "0" is first.

If I use these words when I submit the score, the score list crashes.
How can I fix this?

Please login to see this attachment.

D:<

Same errors! any other tutorials for making this? I tried a lot of webhostings and I can´t make it works :S! maybe the script doesnt work?

This still works, since i am using part if it as well.

1. Make sure you have access to the SQL on the host
2. Free hosts now these days won't work anymore as good anymore. Get a paid one for hosting your website.

I can confirm that this script works perfectly. I'm using it on all my online games with computers and tablets and it works perfectly on both.

Does anyone know how I could call on a specific row of data from the score database? In this tutorial it shows the full top 10 scores table and just lists them as individual pieces (ex: player names on the leaderboard being 1, 4, 7 using the string parser). What I wanted to be able to do was just pull a specific player's name, score and date as opposed to the whole leaderboard. So say for example, Doug is in 7th place with a score 150, I'd like to be able to click a button that just brings up that row of data ("Doug, 150 points, April 10"). How would I go about doing that in the game from working off of this tutorial?