This topic is locked

Audit Table

3/5/2014 7:57:52 AM
PHPRunner General questions
C
chrispa author

Hi , i use audit trail of phprunner which is great .
now i have that insert sql to insert values to one other table after record updated :
global $conn;

global $data;

$strSQLInsert = "insert into formshistory (ITEM) values ('".$values["ITEM"]."')";

db_exec($strSQLInsert,$conn);
Return true;
which is also working fine .
BUT audit table "forms_audit" does not record that insert sql .

can someone help me and add also that with same format as it is been used by audit script ?
thanks in advance

W
wildwally 3/5/2014

Sounds like this would be another insert into your forms_audit table.
Look at the forms_audit table for the current format used then through the use of queries (retrieve data not available), and session variable build the insert string. I'm pretty sure the audit trail only records things that are done directly by PHPR, so any behind the scene scripts that you create will not be logged. Not exactly sure what you intent is, but the audit log is a trail of what the user changed. If the system is making the insert with every record update it would be safe to say that the data is captured already and kind of a given, just my opinion. I can certainly understand the need for certain situations other than stated.