This topic is locked

audit friendly page

8/3/2011 7:25:33 AM
PHPRunner General questions
R
Rigmantas author

Hi,

In last topic I gave to a question:

I want modify audit table: create a new column where i want store a key (id). Then i will can use it for detail page, where i can see information about edit history. What need to edit in files (maybe audit.php) that the ID would automatically inserted to the new column in audit table?
Admin wrote:

I guess you can add a new field to audit log table and store data in this field using OnAuditLog event: http://xlinesoft.com...e_audit_log.htm

I found it.

I add a new field "key" in audit log table and in Before audit log: $values["key"]=$keys["id"];

It not work (PHPRUNNER probably do not know this column). Maybe you can help me?

Rimantas

Sergey Kornilov admin 8/3/2011

If you add new fields to Audit table you have to write SQL queries manually. You can use the same OnAuditLog event to build and execute this SQL query.