foreach ($report as $key => $value) {
if ($value == "jksdfKAEFJEK") {
unset($report[$key]);
}
}
foreach ($report as $r) {
$temp = explode(":", $r);
$agency = $temp[0];
$filename = $temp[1];
$nmaprun_start = $temp[2];
$finish_time = $temp[3];
$nmapid_port_sql = "SELECT\n\t\t\t\t\t\t\t\tnmap_runstats_xml.id AS runID,\n\t\t\t\t\t\t\t\tnmap_hosts_xml.id AS hostsID,\n\t\t\t\t\t\t\t\tnmap_ports_xml.id AS portID\n\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\tnmap_runstats_xml\n\t\t\t\t\t\t\tINNER JOIN nmap_hosts_xml ON nmap_hosts_xml.runstats_id = nmap_runstats_xml.id\n\t\t\t\t\t\t\tINNER JOIN nmap_ports_xml ON nmap_ports_xml.host_id = nmap_hosts_xml.id\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\tnmap_runstats_xml.agency = '{$agency}' AND\n\t\t\t\t\t\t\t\tnmap_runstats_xml.filename = '{$filename}' AND\n\t\t\t\t\t\t\t\tnmap_runstats_xml.nmaprun_start = '{$nmaprun_start}' AND\n\t\t\t\t\t\t\t\tnmap_runstats_xml.finished_time = '{$finish_time}'\n\t\t\t\t\t\t\t";
$nmapid_port_stmt = $db->prepare($nmapid_port_sql);
$data = array($agency, $filename, $nmaprun_start, $finish_time);
$nmapid_port_stmt->execute($data);
$nmapid__port_result =& $db->getAll($nmapid_port_sql, array(), DB_FETCHMODE_ORDERED | DB_FETCHMODE_FLIPPED);
$nmapid_portNSE_sql = "SELECT\n\t\t\t\t\t\tnmap_nse_xml.id as nsePortID\n\t\t\t\t\tFROM\n\t\t\t\t\t\tnmap_runstats_xml\n\t\t\t\t\tINNER JOIN nmap_hosts_xml ON nmap_hosts_xml.runstats_id = nmap_runstats_xml.id\n\t\t\t\t\tINNER JOIN nmap_ports_xml ON nmap_ports_xml.host_id = nmap_hosts_xml.id\n\t\t\t\t\tINNER JOIN nmap_nse_xml ON nmap_nse_xml.host_or_port_id = nmap_ports_xml.id\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tnmap_runstats_xml.agency = '{$agency}' AND\n\t\t\t\t\t\tnmap_runstats_xml.filename = '{$filename}' AND\n\t\t\t\t\t\tnmap_runstats_xml.nmaprun_start = '{$nmaprun_start}' AND\n\t\t\t\t\t\tnmap_runstats_xml.finished_time = '{$finish_time}'\n\t\t\t\t\t";
$nmapid__portNSE_result =& $db->getAll($nmapid_portNSE_sql, array(), DB_FETCHMODE_ORDERED | DB_FETCHMODE_FLIPPED);
$nmapid_hostNSE_sql = "SELECT\n\t\t\t\t\t\t\t\tnmap_nse_xml.id AS nseHostID\n\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\tnmap_runstats_xml\n\t\t\t\t\t\t\tINNER JOIN nmap_hosts_xml ON nmap_hosts_xml.runstats_id = nmap_runstats_xml.id\n\t\t\t\t\t\t\tINNER JOIN nmap_nse_xml ON nmap_nse_xml.host_or_port_id = nmap_hosts_xml.id\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\tnmap_runstats_xml.agency = '{$agency}' AND\n\t\t\t\t\t\t\t\tnmap_runstats_xml.filename = '{$filename}' AND\n\t\t\t\t\t\t\t\tnmap_runstats_xml.nmaprun_start = '{$nmaprun_start}' AND\n\t\t\t\t\t\t\t\tnmap_runstats_xml.finished_time = '{$finish_time}'\n\t\t\t\t\t\t\t";
$nmapid__hostNSE_result =& $db->getAll($nmapid_hostNSE_sql, array(), DB_FETCHMODE_ORDERED | DB_FETCHMODE_FLIPPED);
$runstatsArray = array_values(array_unique($nmapid__port_result[0]));
$hostsArray = array_values(array_unique($nmapid__port_result[1]));
$portsArray = array_values(array_unique($nmapid__port_result[2]));
$nseArray = array_merge(array_unique($nmapid__portNSE_result[0]), array_unique($nmapid__hostNSE_result[0]));
for ($x = 0; $x < count($runstatsArray); $x++) {
$delete_sql = "DELETE FROM nmap_runstats_xml WHERE nmap_runstats_xml.id = '{$runstatsArray[$x]}'";
$delete_result = $db->query($delete_sql);
ifError($delete_result);
}
for ($x = 0; $x < count($hostsArray); $x++) {
$delete_sql = "DELETE FROM nmap_hosts_xml WHERE nmap_hosts_xml.id = '{$hostsArray[$x]}'";
