on my current site I have a user DB. I also have an achievements DB. As the logged in user does certain events it changes fields in the Achievements DB. For example set a field from ‘to do’ to ‘complete’.
My question is how can I set it so that every time a new user logs in the Achievement DB resets everything to ‘to do’, but when a logged in user comes back it shows their Achievements again?
You can use the update() function to update certain fields in the database for certain users, This way no ‘reset’ is needed. On certain events run this update function to update the correct field for the correct user