// process everything else by looking up all static hosts and comparing to broadcast and subnet mask
$sql = "SELECT * FROM `conf_hosts` WHERE `subnet-name` = \"" . $value['subnet-name'] . "\"";
if (($return = $db->dbQuery($val->ValidateSQL($sql, $dbconn), $dbconn)) !== -1) {
$hosts_array = $db->dbArrayResultsAssoc($return);
$ip_counts[] = $misc->GetAvailableIPAddressesStatic($hosts_array, $value['subnet-name']);
}
}
}
}
if (count($ip_counts) !== 0) {
$x = 1;
foreach ($ip_counts as $key => $value) {
foreach ($value as $k => $v) {
if ($x <= 6) {
// pass each array to a format specialist
$available .= $misc->GenDivHiddenContent($k, $v);
} else {
$available .= "</ul><br><br><ul>" . $misc->GenDivHiddenContent($k, $v);
$x = 1;
}
$x++;
}
}
}
}
// check for additional subnets this group can access
$sql = "SELECT `resource`, `allowed` FROM `auth_groups_perms` WHERE `type` = \"host\" AND `allowed` = \"" . $group . "\" AND `group` != \"" . $group . "\"";
if (($extra = $db->dbQuery($val->ValidateSQL($sql, $dbconn), $dbconn)) !== -1) {
$extra = $db->dbArrayResultsAssoc($extra);
foreach ($extra as $key => $value) {
$sql = "SELECT * FROM `conf_subnets` WHERE `subnet-name` = \"" . $value['resource'] . "\" LIMIT 1";
