}
         }
     } else {
         if ($group !== "admin") {
             $sql = "SELECT * FROM `conf_subnets` WHERE `group` = \"" . $group . "\"";
         } else {
             $sql = "SELECT * FROM `conf_subnets` ORDER BY `subnet-name` ASC";
         }
         if (($s = $db->dbQuery($val->ValidateSQL($sql, $dbconn), $dbconn)) !== -1) {
             $subnetlist_remainder = $db->dbArrayResultsAssoc($s);
             // );
         }
     }
 }
 if (count($subnet_name) > 0) {
     $subnet_name = $misc->GenDropMenuWSelectedSubnets($subnetlist_remainder, $subnet_name, 'subnet_name');
 } else {
     $subnet_name = "No Subnets defined";
 }
 // populate our pxe group list
 if ($group === "admin") {
     $px = "SELECT `pxe-group-name` FROM `conf_pxe_groups` ORDER BY `pxe-group-name` ASC";
 } else {
     $px = "SELECT `pxe-group-name` FROM `conf_pxe_groups` WHERE `group` = \"" . $group . "\" OR `group` = '' ORDER BY `pxe-group-name` ASC";
 }
 if (($return = $db->dbQuery($val->ValidateSQL($px, $dbconn), $dbconn)) !== -1) {
     $pxeg = $db->dbArrayResultsAssoc($return);
 }
 if (count($pxeg) === 0) {
     $pxe_group = "No PXE Groups defined";
 } else {
 // find the duplicate record so the user can edit it
 $find = "SELECT * FROM `conf_hosts` WHERE `hostname` = \"" . $tmp[$x]['hostname'] . "\" OR `mac-address` = \"" . $tmp[$x]['mac_address'] . "\" OR `ip-address` = \"" . $tmp[$x]['mac_address'] . "\" LIMIT 1";
 if (($value = $db->dbQuery($val->ValidateSQL($find, $dbconn), $dbconn)) === -1) {
     $error = $err->GenerateErrorLink("help/help.html", "#import_host", $defined['error'], "An error occured when attempting to lookup the duplicate record in which '" . $tmp[$x]['hostname'] . "' conflicts with.", NULL, NULL);
 } else {
     $found = $db->dbArrayResultsAssoc($value);
 }
 // populate our subnets list for our imported record
 $sub = "SELECT `subnet-name` FROM `conf_subnets` ORDER BY `subnet-name` ASC";
 if (($return = $db->dbQuery($val->ValidateSQL($sub, $dbconn), $dbconn)) !== -1) {
     $subs = $db->dbArrayResultsAssoc($return);
 }
 if (count($subs) === 0) {
     $subnet = "No subnets defined";
 } else {
     $subnet = $misc->GenDropMenuWSelectedSubnets($subs, $tmp[$x]['subnet'], 'subnet_tmp');
     // quick check to ensure subnet from import matches existing subnet group
     if (!in_array($tmp[$x]['subnet'], $subs) && !empty($tmp[$x]['subnet'])) {
         $subnet_err[$x] = $err->GenerateErrorImg($defined['error'], "help/help.html#import_host", '800', '800');
         $list .= "<li>Subnet field from import does match current list of existing subnet groups</li>";
     }
 }
 // populate our pxe group list
 $px = "SELECT `pxe-group-name` FROM `conf_pxe_groups` ORDER BY `pxe-group-name` ASC";
 if (($return = $db->dbQuery($val->ValidateSQL($px, $dbconn), $dbconn)) !== -1) {
     $pxeg = $db->dbArrayResultsAssoc($return);
 }
 if (count($pxeg) === 0) {
     $pxe_group = "No PXE Groups defined";
 } else {
     $pxe_group = $misc->GenDropMenuWSelectedPXE($pxeg, $tmp[$x]['pxe_group'], 'pxe_group_tmp');
 } else {
     $pxequery = "SELECT * FROM `conf_pxe_groups` WHERE `group` = \"" . $group . "\" ORDER BY `pxe-group-name` ASC";
 }
 if (($current = $db->dbQuery($val->ValidateSQL($pxequery, $dbconn), $dbconn)) !== -1) {
     $pxelist = $db->dbArrayResultsAssoc($current);
 }
 $pxe_groups = $misc->GenJumpMenuBoxPXE($pxelist, 'pxe_groups', $_GET['skin']);
 // populate our subnets list
 $sub = "SELECT `subnet-name` FROM `conf_subnets` ORDER BY `subnet-name` ASC";
 if (($return = $db->dbQuery($val->ValidateSQL($sub, $dbconn), $dbconn)) !== -1) {
     $subs = $db->dbArrayResultsAssoc($return);
 }
 if (count($subs) === 0) {
     $assign_subnet = "No subnets defined";
 } else {
     $assign_subnet = $misc->GenDropMenuWSelectedSubnets($subs, $assign_subnet, 'assign_subnet');
 }
 /* create checkbox list of available groups */
 $groupsquery = "SELECT * FROM `auth_groups` WHERE `group` != \"admin\" AND `group` != \"" . $group . "\" ORDER BY `group` ASC";
 if (($res = $db->dbQuery($val->ValidateSQL($groupsquery, $dbconn), $dbconn)) !== -1) {
     $groups = $db->dbArrayResultsAssoc($res);
     $groups = $misc->EliminiateDuplicates($groups);
     if (count($groups) !== 0) {
         // figure out which boxes are currently enabled
         if (!empty($_GET['id'])) {
             $sql = "SELECT * FROM `auth_groups_perms` WHERE `resource` = \"" . $subnet_name . "\"";
             if (($sql_res = $db->dbQuery($val->ValidateSQL($sql, $dbconn), $dbconn)) !== -1) {
                 $select_groups = $db->dbArrayResultsAssoc($sql_res);
             }
         }
         $select_groups = $misc->GenGroupsCheckBoxes($groups, 'select_groups', $_GET['skin'], $select_groups, $group);