".$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 >= ? AND ip_int <= ?', [ $row['ip_int_start'], $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 >= ? AND ip_int <= ?', [$row['dhcp_start'], $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 >= ? AND ip_int <= ? AND last_found <= ?', [ $row['ip_int_start'], $row['ip_int_stop'], $zombi_threshold]); print "".$zombi." | \n"; $zombi = get_count_records( $db_link, 'user_auth', 'deleted = 0 AND ip_int >= ? AND ip_int <= ? AND last_found <= ?', [ $row['dhcp_start'], $row['dhcp_stop'], $zombi_threshold]); print "".$zombi." | \n"; print "\n"; } } ?>