Audit Logging or an Audit Trail

[eluser]WanWizard[/eluser]
I have solved that by extending the database class (requires a core hack) and overloading the insert, update, delete and where (i need the selection criteria) methods.

If you want to have the old value too, you need to come up with an solution to read and compare, which might be difficult if an update or delete affects multiple rows.