if (!isAdmin()) redirectStart();
-$sql = sprintf("SELECT Username,Name,UserId FROM User WHERE bEnabled=1");
+// INNER JOIN UserStat ON User.UserId = UserStat.UserId
+$sql = sprintf("SELECT User.UserId,Username,Name,dSignup,nBytes
+ FROM User
+ NATURAL JOIN UserStat
+ WHERE bEnabled=1
+ ORDER BY dSignup");
$users = fetchRows(DBSelect($sql),'UserId');
include 'tpl/head.php';
+echo '<table cellspacing="3">';
foreach($users as $id=>$user) {
- echo '<a href="do/admin/main',newQSA(array('impersonate'=>$id)),'">',$user['Username'],'</a> (',$user['Name'],')<br />';
+ 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>',
+ $user['dSignup'],
+ '</td></tr>';
}
+echo '</table>';
include 'tpl/foot.php';
Logged in: <em><?=$loggedInText?>@<?=DBHOST?></em>
<?php else: ?>
<div style="float:left; position: relative;">
-<a href="do/index">Home</a> |
-<a href="do/signup">Sign up</a>
+<a href="do/signup">Sign up</a> |
+<a href="/~sql/phpMyAdmin/" target="_blank">phpMyAdmin</a> |
+<a href="do/index">Home</a>
</div>
<div style="float: right;">
Login via <a href="do/login?ssl=0">SQL Password</a> or <a href="do/login?ssl=1">MIT Certificate</a>