<?PHP
$DB->Connect();
$times =& IniParse("{$GLOBALS['DDIR']}/times");
?>
<table>
<tr>
<td>
<h2>Topsites Administration</h2><br>
</td>
</tr>
<tr>
<td>
<b>Total Accounts</b><br />
</td>
<td>
<?PHP
echo $DB->Count("SELECT COUNT(*) FROM topsites_Accounts WHERE Status='Approved'");
?>
</td>
</tr>
<?PHP
if( isset($GLOBALS['O_CONFIRM']) )
{
?>
<tr>
<td>
<b>Unconfirmed Accounts</b><br />
</td>
<td>
<?PHP
echo $DB->Count("SELECT COUNT(*) FROM topsites_Accounts WHERE Status='Unconfirmed'");
?>
</td>
</tr>
<?PHP
}
?>
<?PHP
if( isset($GLOBALS['O_REVIEW_NEW']) )
{
?>
<tr>
<td>
<b>New Accounts Awaiting Approval</b><br />
</td>
<td>
<?PHP
echo $DB->Count("SELECT COUNT(*) FROM topsites_Accounts WHERE Status='Pending'");
?>
</td>
</tr>
<?PHP
}
?>
<?PHP
if( isset($GLOBALS['O_REVIEW_EDIT']) )
{
?>
<tr>
<td>
<b>Edited Accounts Awaiting Approval</b><br />
</td>
<td>
<?PHP
echo $DB->Count("SELECT COUNT(*) FROM topsites_AccountEdits");
?>
</td>
</tr>
<?PHP
}
?>
<tr>
<td>
<b>Last Rerank</b><br />
</td>
<td>
<?PHP
echo AgeString(time()-$times['Rerank']);
?>
</td>
</tr>
<tr>
<td>
<b>Last Reset</b><br />
</td>
<td>
<?PHP
echo AgeString(time()-$times['Reset']);
?>
</td>
</tr>
<!--
<tr>
<td>
<b>Last Backup</b><br />
</td>
<td>
<?PHP
echo date($date_format, $times['Backup']);
?>
</td>
</tr>
<tr>
<td>
<b>Software Version</b><br />
</td>
<td>
<?PHP echo $GLOBALS['VERSION'] ?>
-->
</td>
</tr>
</table>
<br />
<?PHP
echo "<!-- Run: {$_REQUEST['Run']}\nT: {$_REQUEST['T']} -->";
?>