".$zombi_days." ".WEB_days.")"; ?> |
".$zombi_days." ".WEB_days.")"; ?> |
".$row['subnet']." | \n"; $all_ips = $row['ip_int_stop']-$row['ip_int_start']-3; print "".$all_ips." | \n"; #used $used_all = get_count_records($db_link,'user_auth','deleted=0 and ip_int>='.$row['ip_int_start'].' and ip_int<='.$row['ip_int_stop']); print "".$used_all." | \n"; $free_all = $all_ips - $used_all; print "".$free_all." | \n"; $dhcp_pool = $row['dhcp_stop']-$row['dhcp_start']+1; print "".$dhcp_pool." | \n"; #used pool $used_dhcp = get_count_records($db_link,'user_auth','deleted=0 and ip_int>='.$row['dhcp_start'].' and ip_int<='.$row['dhcp_stop']); print "".$used_dhcp." | \n"; $free_dhcp = $dhcp_pool - $used_dhcp; print "".$free_dhcp." | \n"; $free_static = $free_all - $free_dhcp; print "".$free_static." | \n"; $zombi = get_count_records($db_link,'user_auth','deleted=0 and ip_int>='.$row['ip_int_start'].' and ip_int<='.$row['ip_int_stop'].' and last_found<=(NOW() - INTERVAL '.$zombi_days.' DAY)'); print "".$zombi." | \n"; $zombi = get_count_records($db_link,'user_auth','deleted=0 and ip_int>='.$row['dhcp_start'].' and ip_int<='.$row['dhcp_stop'].' and last_found<=(NOW() - INTERVAL '.$zombi_days.' DAY)'); print "".$zombi." | \n"; print "\n"; } } ?>