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]}'";