X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdb%2Faudit_trail_db.inc;h=79061e18be97a78c6564ab01f140b4637180702f;hb=181a41d711bef3cec7ca559e35e9e12d1d4f4515;hp=6aa91d9833689c0fdfd4db3a70f2f653f747ab08;hpb=95ff74b5722826544743a01daf527aa3c9efe11a;p=fa-stable.git

diff --git a/includes/db/audit_trail_db.inc b/includes/db/audit_trail_db.inc
index 6aa91d98..79061e18 100644
--- a/includes/db/audit_trail_db.inc
+++ b/includes/db/audit_trail_db.inc
@@ -12,14 +12,15 @@
 
 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
@@ -124,7 +125,7 @@ function get_journal_number($type, $trans_no) {
 	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 "-";
 }