admin list shows newest users first

[sql-web.git] / admin / main.php

<?php

require_once('../mitsql.cfg.php');
require_once('mitsql.lib.php');

if ((isAdmin() || isImpersonating()) && isset($i_impersonate)) {
	impersonate($i_impersonate);
	redirectStart();
	exit;
}

if (!isAdmin()) redirectStart();

//				INNER JOIN UserStat ON User.UserId = UserStat.UserId
$sql = sprintf("SELECT User.UserId,Username,Name,dSignup,dLastCheck,nBytes,nBytesSoft,nBytesHard
				FROM User
				NATURAL JOIN UserStat
				NATURAL JOIN UserQuota
				WHERE bEnabled=1
				ORDER BY dSignup DESC");
//				ORDER BY nBytes DESC");
$users = fetchRows(DBSelect($sql),'UserId');

include 'tpl/head.php';

?>
<style>
table.usertable td {
	border: 1px solid black;
	padding: 1px 2px 1px 2px;
}
</style>
<?php

echo '<table cellspacing="0" cellpadding="0" class="usertable">';
foreach($users as $id=>$user) {
	echo '<tr><td>',
		$user['UserId'],
		'</td><td>',
		'<a href="do/admin/main',newQSA(array('impersonate'=>$id)),'">',
		$user['Username'],
		'</a></td><td>',
		$user['Name'],
		'</td><td>',
		sprintSize($user['nBytes']),
		'</td><td>',
		sprintSize($user['nBytesHard']),
		'</td><td>',
		$user['dSignup'],
		'</td><td>',
		$user['dLastCheck'],
		'</td></tr>';
}
echo '</table>';

echo '<em>',count($users),' users</em>';

include 'tpl/foot.php';

?>