<?php
$now = date("m/j/y h:i:s",time());
include "../connect.php";
$now = date("j/m/y h:i:s",time());
if ($SERIAL=="") {
$stmt6 = "select v.* from viruslog v, arp_table a where (a.IP_ADDRESS = '$REMOTE_ADDR') and (a.serial=v.arp_table)";
} else
{
//$stmt6 = "select first 15 v.* from viruslog v where (arp_table = '$SERIAL') and (checked is null) order by EVENTDATE DESC";
$stmt6 = "select first 75 v.* from viruslog v where (arp_table = '$SERIAL') and (checked is null) order by EVENTDATE DESC";
}
//echo $stmt6;
$sth6=ibase_query($dbh,$stmt6);
print "</table>";
print '<TABLE BORDER = "1">';
$printheader = 'true';
while ($row5 = ibase_fetch_object($sth6)) {
    if ($printheader=='true')
    {
       print '<th>Fixed</th><th>Event Date</th><th>Description</th><th>Severity</th><th>Virus</th><th>File</th><th>Requested Action</th><th>Actual Action</th>';
       $printheader = 'false';
    }
    print "<TR>";
    if ($row5->ALERT_TYPE=='VF') {
        print '<td><input type="checkbox" name="DELETEVIRUS[]" value="' . $row5->SERIAL  . '"';
       if ($row5->CHECKED == '1') {print "checked";}
       print '></td>';
    } else {
       print '<td>&nbsp</td>';
    }
    print "<td>" . $row5->EVENTDATE . "</td>"; 
    print "<td>" . $row5->DESCRIPTION . "</td>";
    print "<td>" . $row5->SEVERITY . "</td>";
    print '<td><a href="http://search.symantec.com/custom/us/query.html?qt=' . strtolower($row5->VIRUS) . '" target = window>' . $row5->VIRUS . '</a></td>';
    print "<td>" . $row5->INFECTED_FILE . "</td>";
    print "<td>" . $row5->RACTION . "</td>";
    print "<td>" . $row5->AACTION . "</td>";
    
    print "</td></tr>";
}
print "</table>";
?>