|
Good Evening :-) I have been struggling with the Server Side Highscores example on the unify community wiki for a good two weeks now, and I really, really need to get this working. The script works excellent, everything is fine and I'm loving it. The problems starts when I try to add additional information to the database. The thing is, I would like to add two things to the database; the users email address and the date when the score was posted. But whenever I try to update the scripts to support this it wont upload to the database anymore. I have update the HSController, the addscores.php and the MySQL tables but I must be doing something wrong somewhere. Could you maybe help me out in adding these fields to the script? It would be very much appreciated and you will of course be credited for helping :-) http://www.unifycommunity.com/wiki/index.php?title=Server_Side_Highscores
(comments are locked)
|
|
You will of course add your extra info in the client script, on this line:
Then you need to add to the PHP script:
And make sure you add fields to your database too. You can test your PHP by just hitting it with a web browser. Thanks for the answer. That's pretty much what I tried. I tried your code aswell just in case, and I'm having the exact same problem. I'm starting to wonder if it's the hash that fails? MySQL CREATE TABLE
Jan 29 '11 at 08:43 PM
zbegra
Ok, I think I figured it out. It seems that if you add the fields in the wrong order in the database it will not work, once I had the exact same order in both url and the database then it worked.
Jan 29 '11 at 10:05 PM
zbegra
It's still not accepting when I do it with the hash though. I commented out the hash stuff and got it to work, any ideas?
Jan 29 '11 at 10:11 PM
zbegra
(comments are locked)
|
|
Allright, I finally got this working. I'll post the full code here so that others can benefit from this in the future PHP:
Javascript:
MySQL Table:
(comments are locked)
|
|
Assets/all/score/score.js(36,13): BCE0005: Unknown identifier: 'Md5'. error how can souve?
(comments are locked)
|
|
I have set up the db and its working with Server Side Highscores script. i am getting stuck in adding data automatically eg when a coin is collected in a game a score is added live onto the sql . any suggestions ?
(comments are locked)
|
