Welcome to xCrud Community - Data Management and extended PHP CRUD

[pierluisdj]

Hi,
when the set_logging is true, the query not update the column 'updated_by'.
How i can remediate?
Tnks in advance

 

[DaDo]

Hi,
when the set_logging is true, the query not update the column 'updated_by'.
How i can remediate?
Tnks in advance

Sorry version xcrud?

 

[pierluisdj]

xcrud pro 1.0.3

 

[pierluisdj]

SOLUTION:

mod file
xcrud.php

search
$db->query('INSERT INTO `logs` (record_id,action,table_name,data) VALUES ("' . $ins_id . '","INSERT","' . $this->table . '","' . $q_log . '")');
replace with
$db->query('INSERT INTO `logs` (record_id,action,updated_by,table_name,data) VALUES ("' . $ins_id . '","INSERT","' .$_SESSION['user_id'].'","' . $this->table . '","' . $q_log . '")');

search
$db->query('INSERT INTO `logs` (record_id,action,table_name,data,old_record) VALUES (' . $db->escape($primary) . ',"UPDATE","' . $this->table . '","' . $q_log . '","' . $row_log_json . '")');
replace with
$db->query('INSERT INTO `logs` (record_id,action,updated_by,table_name,data,old_record) VALUES (' . $db->escape($primary) . ',"UPDATE","' .$_SESSION['user_id'].'","' . $this->table . '","' . $q_log . '","' . $row_log_json . '")');

search
$db->query('INSERT INTO `logs` (record_id,action,table_name,data,old_record) VALUES (' . $db->escape($this->primary_val) . ',"DELETE","' . $this->table . '","' . $q_log . '","' . $row_log_json . '")');
replace with
$db->query('INSERT INTO `logs` (record_id,action,updated_by,table_name,data,old_record) VALUES (' . $db->escape($this->primary_val) . ',"DELETE","' .$_SESSION['user_id']. '","' . $this->table . '","' . $q_log . '","' . $row_log_json . '")');