function add_audit_trail($trans_type, $trans_no, $trans_date, $descr='')
{
+ $descr = substr($descr, 0, 60);
begin_transaction();
$date = date2sql($trans_date);
$sql = "INSERT INTO ".TB_PREF."audit_trail"
- . " (type, trans_no, user, gl_date, description)
+ . " (type, trans_no, user, gl_date, description, stamp)
VALUES(".db_escape($trans_type).", ".db_escape($trans_no).","
. $_SESSION["wa_current_user"]->user . ","
- . "'$date',". db_escape($descr). ")";
+ . "'$date',". db_escape($descr). ", CURRENT_TIMESTAMP)";
db_query($sql, "Cannot add audit info");
// all audit records beside just inserted one should have gl_seq set to NULL
if (db_num_rows($res))
{
$myrow =db_fetch($res);
- return $myrow['gl_seq'] ? $myrow['gl_seq'] : _('None');
+ return $myrow['gl_seq'] ? $myrow['gl_seq'] : 0;
}
return "-";
}