Location: PHPKode > projects > Network Asset Management Archive > nama/this3.php
<?php
$now = date("m/j/y h:i:s",time());
include "../connect.php";
$now = date("j/m/y h:i:s",time());
if ($SERIAL=="") {
$stmt4 = "select DISTINCT a.SHORTDESC, a.FULLDESC, A.FIX, A.SEVERITY, B.HOSTID from VULNS a, VULNSFOUND b, HOSTS c where (c.ipaddressstr = '$REMOTE_ADDR') and (c.hostid=b.hostid) and (b.vulnid=a.vulnid) ORDER BY a.SEVERITY DESC";
} else {
$stmt4 = "select DISTINCT a.SHORTDESC, a.FULLDESC, A.FIX, A.SEVERITY, B.HOSTID, B.JOBID, B.VULNID from VULNS a, VULNSFOUND b, HOSTS c, arp_table d where (d.IP_ADDRESS=c.IPADDRESSSTR) and (d.serial = '$SERIAL') and (c.hostid=b.hostid) and (b.vulnid=a.vulnid) ORDER BY a.SEVERITY DESC";
}
print '<TABLE BORDER="1">';
$sth4 = ibase_query($dbh,$stmt4);
while ($row4 = ibase_fetch_object($sth4)) {
if ($row4->SEVERITY==3) {
    print '<tr bgcolor="EED3D6">';
}
if ($row4->SEVERITY==2) {
    print '<tr bgcolor="F9FBBE">';
}
if ($row4->SEVERITY==1) {
    print '<tr bgcolor="D3EED3">';
}
print '<input type="hidden" name="JOBID[]" value="' . $row4->JOBID . '">';
print '<input type="hidden" name="VULNID[]" value="' . $row4->VULNID . '">';
print '<input type="hidden" name="HOSTID[]" value="' . $row4->HOSTID . '">';
     print '<td width="5%" rowspan="3">';
     print $row4->SEVERITY . "</td>";
     print '<td colspan="2">'; 
     print '<select name="Fixed[]" size="1"><option value="No" selected >Not Fixed</option><option value="Yes">Fixed</option></select>';
     print $row4->SHORTDESC . "</td>";
     print "</tr>";
if ($row4->SEVERITY==3) {
    print '<tr bgcolor="EED3D6">';
}
if ($row4->SEVERITY==2) {
    print '<tr bgcolor="F9FBBE">';
}
if ($row4->SEVERITY==1) {
    print '<tr bgcolor="D3EED3">';
}

     print '<td>';
     $myblob = ibase_blob_open($row4->FULLDESC);
     print nl2br(wordwrap(ibase_blob_get($myblob,1024),60));
     print "</td>";
     print '</tr>';
if ($row4->SEVERITY==3) {
    print '<tr bgcolor="EED3D6">';
}
if ($row4->SEVERITY==2) {
    print '<tr bgcolor="F9FBBE">';
}
if ($row4->SEVERITY==1) {
    print '<tr bgcolor="D3EED3">';
}
     print '<td>';
     $myblob2 = ibase_blob_open($row4->FIX);
     print nl2br(wordwrap(ibase_blob_get($myblob2,2048),86));
     print "</td>";
     print "</tr>";
}
//print "</form>";

include("this4.php");
?>

Return current item: Network Asset Management Archive