From 1050fbb732198f8336ab0708c2aed221d864a1b7 Mon Sep 17 00:00:00 2001
From: Joe Presbrey <presbrey@mit.edu>
Date: Mon, 12 Sep 2005 02:23:01 +0000
Subject: [PATCH] added phpMyAdmin to menu updated admin page to show bytes and
 signup

git-svn-id: svn://presbrey.mit.edu/sql/mitsql@69 a142d4bd-2cfb-0310-9673-cb33a7e74f58
---
 admin/main.php | 22 ++++++++++++++++++++--
 tpl/menu.php   |  5 +++--
 2 files changed, 23 insertions(+), 4 deletions(-)

diff --git a/admin/main.php b/admin/main.php
index 5f6535b..f4ee825 100755
--- a/admin/main.php
+++ b/admin/main.php
@@ -11,14 +11,32 @@ if ((isAdmin() || isImpersonating()) && isset($i_impersonate)) {
 
 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';
 
diff --git a/tpl/menu.php b/tpl/menu.php
index a9d6083..3060e24 100644
--- a/tpl/menu.php
+++ b/tpl/menu.php
@@ -17,8 +17,9 @@
 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>
-- 
2.45.0