--- alx-src/branches/alx-web-050/index.php 2011/01/21 08:34:45 1651 +++ alx-src/branches/alx-web-050/index.php 2011/03/16 11:04:35 1725 @@ -61,7 +61,8 @@ function checkif($b) { if($b) return ' checked'; else return ''; } - $comps = sqlarr("SELECT s.serial, s.location, s.mac, n.hostname, t.mtime FROM cfg_network n,client_serials s,state_connected t WHERE n.serial=s.serial OR t.serial=s.serial", "serial"); + $comps = sqlarr("select client_serials.serial, client_serials.location, client_serials.mac, cfg_network.hostname, state_connected.mtime from client_serials left join cfg_network on client_serials.serial=cfg_network.serial left join state_connected on client_serials.serial=state_connected.serial", "serial"); + sqlforeach('SELECT serial, ip, hostname, mac FROM state_connected', 'check_online', null); usort($comps, 'sortcomp'); echo '