Say a user makes an unwanted change to a row in a database. What would I need to take as a precaution if I wanted to send it to the way it once. Looking for a practical solution that doesn't envolve making an enourmous database.
Thanks in advance.
Blasting a row into the past
Moderator: General Moderators
I just want to clarify what you're asking.
A user comes along and makes a change, let's say a delete. You want to then give them the option to come back later (hours / days) and say 'oops' and hit a button to restore the deleted item to the existing database.
That sound along the lines of what you were thinking?
A user comes along and makes a change, let's say a delete. You want to then give them the option to come back later (hours / days) and say 'oops' and hit a button to restore the deleted item to the existing database.
That sound along the lines of what you were thinking?
Yup. That's pretty much it.Stryks wrote:I just want to clarify what you're asking.
A user comes along and makes a change, let's say a delete. You want to then give them the option to come back later (hours / days) and say 'oops' and hit a button to restore the deleted item to the existing database.
That sound along the lines of what you were thinking?
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
This really depends and can become a much larger task if it involve you need the capability to undo changes (or even several changes), such as you edited an article and wanted to revert back.
However, if all you want is to be able to "undo" deleting of accounts then you can create another column called active, and upon deleting the user simply set this to 0 or whatever. Basically to acquire all active users simply query active = 1
More info please..
However, if all you want is to be able to "undo" deleting of accounts then you can create another column called active, and upon deleting the user simply set this to 0 or whatever. Basically to acquire all active users simply query active = 1
More info please..