if (($value = $db->dbQuery($val->ValidateSQL($query, $dbconn), $dbconn)) === -1) { $error = $err->GenerateErrorLink("help/help.html", "#host_search", $defined['error'], $errors['db_search_err'], NULL, NULL); } else { // process results of search if ($db->dbNumRows($value) >= 1) { $data = $db->dbArrayResultsAssoc($value); if ($db->dbNumRows($value) === 1) { $id = $data[0]['id']; $hostname = $data[0]['hostname']; $mac_address = $data[0]['mac-address']; $ip_address = $data[0]['ip-address']; $subnet_name = $data[0]['subnet-name']; $pxe_group = $data[0]['pxe-group']; $error = $err->GenerateErrorLink("help/help.html", "#host_search", $defined['good'], "Your search for '" . $val->ValidateXSS($search) . "' returned '" . $db->dbNumRows($value) . "' results. The form has been populated for you to edit record #" . $id, NULL, NULL); } else { $hosts_list = $misc->GenJumpMenuBoxHOSTS($data, 'hosts_list', $_GET['skin'], NULL); $error = $err->GenerateErrorLink("help/help.html", "#host_search", $defined['good'], "Your search for '" . $val->ValidateXSS($search) . "' returned '" . $db->dbNumRows($value) . "' results. Please select the host you wish to edit from the select box below", NULL, NULL); } } else { $error = $err->GenerateErrorLink("help/help.html", "#host_search", $defined['error'], $errors['sql_empty'], NULL, NULL); } } } else { $search_err = $err->GenerateErrorImg($defined['error'], "help/help.html#host_search", '800', '800'); $list = "<ol><li>Search string is invalid. Allowed formats:<br>MAC Address: xx:xx:xx:xx:xx<br>IPv4 Address: xxx.xxx.xxx.xxx<br>Hostname: [0-9a-z]</li></ol>"; $error = $err->GenerateErrorLink("help/help.html", "#host_search", $defined['error'], $errors['val_host'] . $list, NULL, NULL); } } else { $sql_success = -1; // check each post element if (!empty($hostname) && !empty($mac_address) && !empty($ip_address) && !empty($subnet_name)) {