Online High Score Tutorial

[famousgnu6]

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

[crjMosh]

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!

[Perry]

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.

[Rached MILADI]

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
php-admin.jpg
And change the script in the score_script.php fil like this
replace en php.gif
That's all... it works fine

[wing93]

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.
Attachment 17606

confused me... what the beep is this on myphpadmin.. if anyone can teach I'm appreaciate it
Attachment 17607

[wing93]

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:
https://www.youtube.com/watch?v=7qWg67FZQGo

[SMASHINGmedia]

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

[SMASHINGmedia]

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

[Perry]

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

[mouss1299]

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