<?
include "./auth.inc.php";
if (!$order)
$order = 'CreateDate DESC';
$sql="SELECT MasterAccounts.CustomerID, FirstName, LastName, Login, ExpireDate, TimeRemaining, Reseller, LastUse
FROM MasterAccounts, SubAccounts
WHERE MasterAccounts.CustomerID = SubAccounts.CustomerID ";
if (!$expired)
$sql.=" AND TO_DAYS(now()) < TO_DAYS(ExpireDate) ";
$sql.=" AND AccountType = 'dealerspecial' ORDER BY $order";
$res=mysql_query($sql);
?><HTML>
<HEAD></HEAD>
<BODY bgcolor = white>
<h2>Dealer Trial Accounts</h2>
<P><? echo mysql_num_rows($res) ?> DealerSpecial Accounts in the system</P>
<?
if (!$expired){
?>
Expired Accounts not shown. <A HREF="dealerspecial-check.php?expired=yes">Click here to see full list</A>
<?
}
?>
<TABLE BORDER=1>
<TR><TH>Name</TH><TH><A HREF="dealerspecial.php?order=Login">Login</A></TH>
<TH><A HREF="dealerspecial.php?order=ExpireDate+DESC">Expire</A></TH>
<TH><A HREF="dealerspecial.php?order=TimeRemaining">Time Remaining</A></TH>
<TH><A HREF="dealerspecial.php?order=Reseller">Dealer</A></TH></TR>
<?
while ($row = mysql_fetch_array($res)){
print "<TR>";
print "<TD><A HREF=\"user.php?ID=$row[0]\">$row[FirstName] $row[LastName]</A></TD>";
print "<TD>$row[Login]</TD>";
print "<TD>";
print $row[ExpireDate];
if (!$row[LastUse])
print " <IMG SRC=\"sad.gif\" ALT=\"This Account has not logged in yet\">";
print "</TD>";
print "<TD>$row[TimeRemaining]</TD>";
$dsql = "SELECT DealerName FROM Dealer WHERE DealerID = '$row[Reseller]'";
$dres = mysql_query($dsql);
if (mysql_num_rows($dres))
$dealer = mysql_result($dres,0);
else
$dealer='';
print "<TD>$dealer</TD>";
print "<TD><A HREF=\"clicheck.php?user=$row[Login]\">Check CLI</A></TD>";
print "</TR>";
}
print "</TABLE>";