if (!empty($value['pool'])) {
             // process assigned pool IP addresses minus IP's engaged in `conf_leases` table
             $sql = "SELECT * FROM `conf_pools` WHERE `pool-name` = \"" . $value['pool'] . "\"";
             if (($return = $db->dbQuery($val->ValidateSQL($sql, $dbconn), $dbconn)) !== -1) {
                 $pool_array = $db->dbArrayResultsAssoc($return);
                 foreach ($pool_array as $k => $v) {
                     $ip_counts[] = $misc->GetAvailableIPAddresses($v, $value['subnet-name']);
                 }
             }
         } else {
             // look at broadcast and mask to determine range first
             // 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;
             }
     } else {
         if (!empty($value['pool'])) {
             // process assigned pool IP addresses minus IP's engaged in `conf_leases` table
             $sql = "SELECT * FROM `conf_pools` WHERE `pool-name` = \"" . $value['pool'] . "\"";
             if (($return = $db->dbQuery($val->ValidateSQL($sql, $dbconn), $dbconn)) !== -1) {
                 $pool_array = $db->dbArrayResultsAssoc($return);
                 foreach ($pool_array as $k => $v) {
                     $ip_counts[] = $misc->GetAvailableIPAddresses($v, $value['subnet-name']);
                 }
             }
         } else {
             // look at broadcast and mask to determine range first
             // 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) {
                 $ip_counts[] = $misc->GetAvailableIPAddressesStatic($db->dbArrayResultsAssoc($return), $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;
             }