Page 1 of 1

Blasting a row into the past

Posted: Mon Sep 17, 2007 9:54 pm
by elinews
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.

Posted: Mon Sep 17, 2007 10:23 pm
by Stryks
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?

Posted: Tue Sep 18, 2007 3:35 pm
by elinews
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?
Yup. That's pretty much it.

Posted: Tue Sep 18, 2007 3:40 pm
by John Cartwright
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..