koobas.hobune.stream
Inserting game items in online database table and connect that table with the users table
Hi forum, I have been thinking what would be the best approach to take for my project. My game can basically be played offline but I want to give the chance for the user to be able to save their progress online (items, high scores etc.). I will have multiple high score tables. I currently have a complete Login/Register system that stores the user account details in MySQL. I want the items for each user to be stored in a separate table as well as the user high scores. When the user buys an item or make a high score i want the database to be updated for the user that is logged in. I know for the high scores i will probably need a button that does something like synchronize and it will update the database. But for the items I don't think that this will be efficient.
I would like to hear your thoughts on this. Is there any tutorials could look up to to get some help?
Thank you in advance,
