hi,
so i created online highscores a while back for a game using this tutorial:
construct.net/en/tutorials/creating-own-leaderboard-1032/page-3
everything works perfectly fine.
so recently i wanted to do another game with online highscores.
so i copypaste the php from earlier and changed the required values. test it - doesn't work. now i am stumped.
PLEASE READ:
I created a new database, this time it uses mysq l5.7 instad of 5.5 - cant change that, server-side thing
i changed all the values correctly. no error on that end
the new database is an exact copy of the old one for testing
i used the new php to upload scores to the old one to see if it works. it does. so neither the game code nor the PHP is not at fault here
i can read the tables just fine, the scores are displayed as they should. the problem is the upload part. i made sure to get all the values and php right - as said, if i use the new code to upload to the old scores it works fine.
so here's my problem: did the syntax change a lot from sql5.5 to 5.7? if so, how do i need to reflect the changes in my code?
as said the old game, where everything works fine, used a 5.5 version, the new one 5.7 and that is the only difference between the two. it either is that or something so obvious I can't help but miss it.
any ideas?