<?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 * from updates u, arp_table a where (a.IP_ADDRESS = '$REMOTE_ADDR') and (a.serial=u.arp_table)";
} else
{
$stmt6 = "select first 10 * from updates u where (arp_table = '$SERIAL') order by DOWNLOADED DESC";
}
$sth6=ibase_query($dbh,$stmt6);
print "</table>";
print '<TABLE BORDER = "1">';
$printheader = 'true';
while ($row5 = ibase_fetch_object($sth6)) {
    if ($printheader=='true')
    {
       print '<th>Downloaded Date</th><th>Installed Date</th><th>Patch Number</th><th>Description</th><th>Release Date</th>';
       $printheader = 'false';
    }
    print "<TR><td>";
    $stmt7 = "select * from updatelist where PATCH = '$row5->PATCH';";
//    echo $stmt7;
    $sth7 = ibase_query($dbh, $stmt7);
    if ($row5->DOWNLOADED=='') {
         print "Unknown</td><td>";
    } else {
         print $row5->DOWNLOADED . "</td><td>";
    }
    print $row5->INSTALLED_DATE . "</td><td>" . $row5->PATCH ;
    
    if ($row7 = ibase_fetch_object($sth7)) {
        print '</td><td><a href="';
        print $row7->LINK . '" target=window>' . $row7->DESCRIPTION . '</a>';
        print "</td><td>" . substr($row7->RELEASE_DATE,0,10);
    }
    print "</td></tr>";
}
print "</table>";
?>