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 f4ee825370267933299840b23cabe480fd04c658..bdd80236f47a4586bc5c35760b8b54b6dc9f1258 100755 (executable)
--- 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 549f5a6645fc87539b1328e60db049c5e8b486e2..629e3f417d9b38c5ed98e6e3fe8ff734418f6757 100755 (executable)
--- 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/"