function CreateComputerLogs($ip, $mac, $hostname) { $q = new postgres_sql(); if (!isset($GLOBALS["dhcpd_hosts_checked"])) { $q->CREATE_DHCPD_TABLES(); } $ligne = pg_fetch_array($q->QUERY_SQL("SELECT mac FROM dhcpd_hosts WHERE mac='{$mac}'")); $time = date("Y-m-d H:i:s"); if ($ligne["MAC"] == null) { $q->QUERY_SQL("INSERT INTO dhcpd_hosts (MAC,created`,updated,ipaddr,hostname) VALUES('{$mac}','{$time}','{$time}','{$ip}','{$hostname}')"); } else { $q->QUERY_SQL("UPDATE dhcpd_hosts SET ipaddr='{$ip}',hostname='{$hostname}',updated='{$time}' WHERE mac='{$mac}'"); } }