i have a question and don't seem to find the solution. I have a game like Draw Something. So users have to authorize my app to access it. I save the userid of all the users in a mysql database.
To generate a new game, i pick a random userid from my database. The problem is that i want to know which user is still using my app.
It happens that several users install your app, login to facebook, they are saved in my database but after a while they uninstall the app. If someone then generates a random game it is quite possible he has to play to an ex-user of my app (a user who has already uninstalled my app).
Is there anyway to know the still active users of an app? I know that if the user de-authorizes your app, we can check it with is_app_user but that is not what i'm looking after. Users seldomly de-authorize apps imo.
Right now, i'm just doing the check by selecting random users who have : 1) registered between now - 7 days 2) last opened the app between now - 7 days
but still, this isn't an elegant solution.
If someone knows a solution, i would also use it to clean my db (deleting all inactive users).
Thanks for you input!