$circut_id = $_POST['circut_id']; $remote_id = $_POST['remote_id']; $ddns_text = $_POST['ddns_text']; $ddns_fwd_name = $_POST['ddns_fwd_name']; $ddns_client_fqdn = $_POST['ddns_client_fqdn']; $ddns_rev_name = $_POST['ddns_rev_name']; $search = $_POST['search']; $startdate = $_POST['startdate']; $enddate = $_POST['enddate']; // perform search if not empty if (!empty($_POST['SrchLeases'])) { if (empty($search) && empty($startdate) && empty($enddate)) { $error = $err->GenerateErrorLink("help/help.html", "#lease_search", $defined['error'], "Empty search fields, please enter an IP or Hostname to search or enter a start and end date for a list of leases between those dates", NULL, NULL); } else { // perform validation on search string(s) if ($val->ValidateIPv4($search) !== -1 || $val->ValidateMACFormats($search) !== -1 || $val->ValidateHostname($search) !== -1 && $val->ValidateDate($startdate) !== -1 && $val->ValidateDate($enddate) !== -1) { /* define our search query */ if ($group !== "admin") { $having = " HAVING `group` = \"" . $group . "\""; } // search by dates if (!empty($startdate) || !empty($enddate)) { $dates = " `start` > \"" . $startdate . "\" AND `end` < \"" . $enddate . "\""; } // provide fields search if (!empty($search)) { $main = "`hostname` LIKE \"" . $search . "\" OR `hardware` LIKE \"" . $search . "\" OR `ip` LIKE \"" . $search . "\""; } // and apply the attributes $query = "SELECT * FROM `conf_leases` WHERE {$main}{$dates}{$having} ORDER BY `hostname` ASC"; // process our query