From: Joe Presbrey <presbrey@mit.edu>
Date: Wed, 14 Sep 2005 14:14:26 +0000 (+0000)
Subject: admin page updates, secure sessions
X-Git-Url: http://andersk.mit.edu/gitweb/sql-web.git/commitdiff_plain/d02b16c40106290da735ba4e7bbe7bb50f76d8fa

admin page updates, secure sessions

git-svn-id: svn://presbrey.mit.edu/sql/mitsql@70 a142d4bd-2cfb-0310-9673-cb33a7e74f58
---

diff --git a/admin/main.php b/admin/main.php
index f4ee825..bdd8023 100755
--- a/admin/main.php
+++ b/admin/main.php
@@ -12,16 +12,26 @@ if ((isAdmin() || isImpersonating()) && isset($i_impersonate)) {
 if (!isAdmin()) redirectStart();
 
 //				INNER JOIN UserStat ON User.UserId = UserStat.UserId
-$sql = sprintf("SELECT User.UserId,Username,Name,dSignup,nBytes
+$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");
 $users = fetchRows(DBSelect($sql),'UserId');
 
 include 'tpl/head.php';
 
-echo '<table cellspacing="3">';
+?>
+<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'],
@@ -33,11 +43,17 @@ foreach($users as $id=>$user) {
 		'</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';
 
 ?>
diff --git a/php.ini b/php.ini
index 549f5a6..629e3f4 100755
--- a/php.ini
+++ b/php.ini
@@ -1,3 +1,4 @@
 display_errors = 0
 extension = mysql.so
 auto_append_file = "global.done.php"
+session.save_path = "/home/sql/tmp/"