'') AND (U.ip_int BETWEEN S.ip_int_start AND S.ip_int_stop) AND S.office=1 AND deleted=0 ORDER BY net,mac,last_found"; $users = get_records_sql($db_link,$sSQL); $f_subnet=NULL; $f_mac=NULL; $f_id=NULL; $printed = NULL; foreach ($users as $row) { if (empty($f_subnet)) { $f_subnet = $row['net']; $f_mac=$row['mac']; $f_id=$row['id']; continue; } if ($row['net'] === $f_subnet and $row['mac']===$f_mac) { if (!isset($printed[$f_id])) { $user = get_record_sql($db_link,"SELECT * FROM User_auth WHERE id=".$f_id); if (empty($user['last_found']) or $user['last_found'] === '0000-00-00 00:00:00') { $user['last_found'] = ''; } if (empty($user['timestamp']) or $user['timestamp'] === '0000-00-00 00:00:00') { $user['timestamp'] = ''; } if (empty($user['changed_time']) or $user['changed_time'] === '0000-00-00 00:00:00') { $user['changed_time'] = ''; } print "\n"; $cl = "data"; print "\n"; print "\n"; print "\n"; print "\n"; if (isset($user['dhcp_hostname']) and strlen($user['dhcp_hostname']) > 0) { print "\n"; } else { print "\n"; } print "\n"; print "\n"; print "\n"; print "\n"; $printed[$f_id] = 1; } if (!isset($printed[$row['id']])) { $user = get_record_sql($db_link,"SELECT * FROM User_auth WHERE id=".$row['id']); if (empty($user['last_found']) or $user['last_found'] === '0000-00-00 00:00:00') { $user['last_found'] = ''; } if (empty($user['timestamp']) or $user['timestamp'] === '0000-00-00 00:00:00') { $user['timestamp'] = ''; } if (empty($user['changed_time']) or $user['changed_time'] === '0000-00-00 00:00:00') { $user['changed_time'] = ''; } print "\n"; $cl = "data"; print "\n"; print "\n"; print "\n"; print "\n"; if (isset($user['dhcp_hostname']) and strlen($user['dhcp_hostname']) > 0) { print "\n"; } else { print "\n"; } print "\n"; print "\n"; print "\n"; print "\n"; $printed[$row['id']] = 1; } } $f_subnet = $row['net']; $f_mac=$row['mac']; $f_id=$row['id']; } print "

	" . get_login($db_link,$user['user_id']) . "	" . $user['ip'] . "	" . expand_mac($db_link,$user['mac']) . "	".$user['comments']." [" . $user['dhcp_hostname'] . "]	".$user['comments']."	".$user['dns_name']."	".$user['timestamp']."	".$user['last_found']."
	" . get_login($db_link,$user['user_id']) . "	" . $user['ip'] . "	" . expand_mac($db_link,$user['mac']) . "	".$user['comments']." [" . $user['dhcp_hostname'] . "]	".$user['comments']."	".$user['dns_name']."	".$user['timestamp']."	".$user['last_found']."

\n"; ?>