alter table audit_trail add 
(
	idRoles 	bigint(20),
	idSubRoles 	bigint(20),
	ipaddress varchar(15),
	register_user char(1)
);

alter table audit_trail add register_user char(1);

update audit_trail set register_user='Y' WHERE register_user is null;
update audit_trail set register_user='N',idRoles='1',idSubRoles='0' WHERE descr like '%Self-Update%' and idRoles is null;
update audit_trail set register_user='N',idRoles='1',idSubRoles='0' WHERE descr in ('Agent Email Confirmation','Password Reset By Recovery Token','Agent Self Registration') and running_sql like '%user_register%' and idRoles is null;
update audit_trail set register_user='N',idRoles='1',idSubRoles='0' WHERE descr in ('Agent Email Confirmation','Agent Self Registration') and idRoles is null;
update audit_trail a left join user_list b on b.idUser=a.idUser and b.idRoles!=1 set a.idRoles=b.idRoles,a.idSubRoles=b.idSubRoles where b.idRoles!=1 and a.register_user='Y' and a.descr NOT LIKE '%sistem%' and a.idRoles is null;
update audit_trail a left join user_list b on b.idUser=a.idUser and b.idRoles=1 set a.idRoles=b.idRoles,a.idSubRoles=b.idSubroles where b.idUser is not null and a.register_user='Y' and a.descr like '%APPLICATION UPDATE%' and a.idRoles is null;
update audit_trail a left join user_list b on b.idUser=a.idUser set a.idRoles=b.idRoles,a.idSubRoles=b.idSubRoles WHERE a.running_sql like '%user_list%' and a.idRoles is null and a.register_user='Y';
update audit_trail a left join user_list b on b.idUser=a.idUser set a.idRoles=b.idRoles,a.idSubRoles=b.idSubRoles WHERE a.descr not in ('Login Sistem','Log Out Sistem') and a.register_user!='N' and a.idRoles is null;


update audit_trail a left join user_list b ON b.idUser = a.idUser and 


// Function to get the client ip address
function get_client_ip_env() {
    $ipaddress = '';
    if (getenv('HTTP_CLIENT_IP'))
        $ipaddress = getenv('HTTP_CLIENT_IP');
    else if(getenv('HTTP_X_FORWARDED_FOR'))
        $ipaddress = getenv('HTTP_X_FORWARDED_FOR');
    else if(getenv('HTTP_X_FORWARDED'))
        $ipaddress = getenv('HTTP_X_FORWARDED');
    else if(getenv('HTTP_FORWARDED_FOR'))
        $ipaddress = getenv('HTTP_FORWARDED_FOR');
    else if(getenv('HTTP_FORWARDED'))
        $ipaddress = getenv('HTTP_FORWARDED');
    else if(getenv('REMOTE_ADDR'))
        $ipaddress = getenv('REMOTE_ADDR');
    else
        $ipaddress = 'UNKNOWN';
 
    return $ipaddress;
}
	
// Function to get the client ip address
function get_client_ip_server() {
    $ipaddress = '';
    if ($_SERVER['HTTP_CLIENT_IP'])
        $ipaddress = $_SERVER['HTTP_CLIENT_IP'];
    else if($_SERVER['HTTP_X_FORWARDED_FOR'])
        $ipaddress = $_SERVER['HTTP_X_FORWARDED_FOR'];
    else if($_SERVER['HTTP_X_FORWARDED'])
        $ipaddress = $_SERVER['HTTP_X_FORWARDED'];
    else if($_SERVER['HTTP_FORWARDED_FOR'])
        $ipaddress = $_SERVER['HTTP_FORWARDED_FOR'];
    else if($_SERVER['HTTP_FORWARDED'])
        $ipaddress = $_SERVER['HTTP_FORWARDED'];
    else if($_SERVER['REMOTE_ADDR'])
        $ipaddress = $_SERVER['REMOTE_ADDR'];
    else
        $ipaddress = 'UNKNOWN';
 
    return $ipaddress;
}