Thank you Eugenio.
This doesn't appear to do what I need. It allows users to login and change records but doesn't record who last changed the records.
This may be overkill, but I think I need to do the following:-
In business_logic.php
find
function update_record($_FILES, $_POST, $fields_labels_ar, $table_name, $table_internal_name, $where_field, $where_value, $update_type)
a few lines down add $current_user to the global statement viz:
global $conn, $ext_updated_field, $quote, $use_limit_in_update, $upload_directory, $current_user;
Then Find:
// no, since I don't handle select_multiple anymore, I delete isset, and anyway it was not correct because for a file $_POST[$field_name_temp] is not set
if ($fields_labels_ar[$i][$field_to_check] == "1" or $fields_labels_ar[$i]["type_field"] == "update_date"){ // if the field is in the form or need to be inserted because it's an update data
And change the if statement to include the ID_user instance:
if ($fields_labels_ar[$i][$field_to_check] == "1" or $fields_labels_ar[$i]["type_field"] == "update_date" or $fields_labels_ar[$i]["type_field"] == "ID_user"){ // if the field is in the form or need to be inserted because it's an update data or ID_user
Then before case 'select_single': add a new case:
case "ID_user":
$sql .= $quote.$field_name_temp.$quote." = "; // add the field name to the sql statement
$sql .= "'".$current_user."', "; // add the field name to the sql statement
break;
Note that there are some implications on the auth user setup, because this changes the owner of the record to the updater.
This seems to work on my installation, could someone check it out for me please as I am not much of a coder.
Best wishes
Adrian