--- alx-src/branches/alx-web-070/index.php 2015/11/03 11:07:38 7744 +++ alx-src/branches/alx-web-070/index.php 2015/11/03 13:33:12 7745 @@ -75,7 +75,7 @@ $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); +sqlforeach('SELECT state_connected.serial, state_connected.ip, cfg_network.hostname, state_connected.mac FROM state_connected left join cfg_network on cfg_network.serial=state_connected.serial', 'check_online', null); usort($comps, 'sortcomp'); echo '';