} } } 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);