I'm making a game online... and I make a method to save the data of user in my database, actually every user can save like 70 variables and load in the game.
this working fine, but I think what happen if I would like to save the position and the variable of the object in the map.
I'm thinking to save the important variables in the database (level, health...etc) and the position of the object in the JSON file (or in local?)
but if someone clean the cache of the browser it's a problem, and I can't make 6000 records for each user in my database, will be crazy...
so, another idea it's to save a JSON file in the server, like,
if the user save the game, the string of JSON will send to a php, the php will make a file .JSON with the name of the user in a specific folder.
if the user load the game, scirra will load the json from the same folder with the same username.
this idea can work? 6000 records it's a lot for JSON file? I have another problem for save a items... every sprite has 5/6 variables and if i will save on database i need to make another 100 records (it's not a big problem...but if exsist something better is good to change this)
thank you very much