<?
include "./auth.inc.php";
$sql = "SELECT MasterAccounts.CustomerID as ID, FirstName, LastName, Login, ExpireDate, AutoBill,
TimeRemaining, LastUse,
TO_DAYS(now()) - TO_DAYS(LastUse) as ldays
FROM MasterAccounts, SubAccounts
WHERE MasterAccounts.CustomerID = SubAccounts.CustomerID
AND AccountType='Blocks'
AND TimeRemaining > 0
HAVING ldays>100
ORDER BY ldays DESC";
$res = mysql_query($sql);
print mysql_error();
?><HTML>
<HEAD>
</HEAD>
<BODY bgcolor=white>
<BR>
<H2>Block Accounts.</H2>
<TABLE border=0>
<TR><TH>Name</TH><TH>Login</TH><TH>TimeRemaining</TH><TH>AutoBill</TH></TR>
<?
while ($row = mysql_fetch_array($res)){
if ($i++%2)
$bgcolor="#EEEEEE";
else
$bgcolor="#FFFFFF";
print "<TR bgcolor=$bgcolor>";
print "<TD><A HREF=\"user.php?ID=$row[ID]\">$row[FirstName] $row[LastName]</TD>";
print "<TD>$row[Login]</TD>";
if ($row[TimeRemaining] < 1){
$fontcolor = "RED";
}elseif ($row[TimeRemaining] > 6000){
$fontcolor = "BLUE";
}else{
$fontcolor = "BLACK";
}
print "<TD><FONT COLOR=$fontcolor>$row[TimeRemaining] ";
if ($row[ldays]>30)
print " <IMG SRC=\"sad.gif\"> ";
print "</TD>";
print "<TD>$row[ldays]</TD>";
#if ($row[AutoBill] > 0){
# $asql = "SELECT PlanName FROM PlanTypes WHERE PlanID = $row[AutoBill]";
# $ares = mysql_query($asql);
# print mysql_error();
# print "<TD>".mysql_result($ares,0)."</TD>";
#}else{
# print "<TD><B>No AutoBill!</B></TD>";
#}
print "</tr>\n";
}
?></TABLE>
</body>
</html>