// 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";