3 require_once('../mitsql.cfg.php');
4 require_once('mitsql.lib.php');
6 if ((isAdmin() || isImpersonating()) && isset($i_impersonate)) {
7 impersonate($i_impersonate);
12 if (!isAdmin()) redirectStart();
14 empty($i_pagesize) && $i_pagesize=20;
15 empty($i_page) && $i_page=1;
16 empty($i_sortby) && $i_sortby='dSignup';
17 empty($i_sortorder) && $i_sortorder=0;
19 if ($i_sortorder>0) $sortSQL = 'ASC'; else $sortSQL = 'DESC';
21 $i_pagesize = mysql_escape_string($i_pagesize);
22 $i_page = mysql_escape_string($i_page);
23 $i_sortby = mysql_escape_string($i_sortby);
25 $columns = array('','Username','Name','nBytes','nBytesHard','nBytesOver','dSignup');
28 $sqlc = "SELECT COUNT(*) as c FROM User WHERE bEnabled=1";
29 $r = fetchRows(DBSelect($sqlc));
31 count($r) && $userCount = array_shift($r);
33 $sql = sprintf("SELECT User.UserId,Username,Name,dSignup,dLastCheck,nBytes,nBytesSoft,nBytesHard,
34 IF(nBytes>nBytesHard,nBytes-nBytesHard,0) as nBytesOver
37 NATURAL JOIN UserQuota
39 ORDER BY $i_sortby $sortSQL");
41 $sql .= ' LIMIT '.($i_page-1)*$i_pagesize.','.$i_pagesize;
42 $pageArray = range(1,ceil($userCount/$i_pagesize));
43 $pageCount = count($pageArray);
45 $users = fetchRows(DBSelect($sql),'UserId');
47 include 'tpl/head.php';
52 border: 1px solid black;
53 padding: 0px 2px 0px 2px;
58 echo '<em>',$userCount,' users</em> | ';
59 if ($i_page > 1) $tPagePrev = ' <a href="'.$URI.newQS('page',$i_page-1).'">Prev</a>'; else $tPagePrev = 'First';
60 if ($i_page < $pageCount) $tPageNext = ' <a href="'.$URI.newQS('page',$i_page+1).'">Next</a>'; else $tPageNext = 'Last';
61 if (!empty($tPageNext) && empty($tPagePrev)) echo($tPageNext);
62 elseif (empty($tPageNext) && !empty($tPagePrev)) echo($tPagePrev);
63 else echo "$tPagePrev | $tPageNext";
67 foreach($pageArray as $availablePage) {
68 echo ' <a href="'.$URI.newQS('page',$availablePage).'">'.$availablePage.'</a>';
72 echo ' | Page '.$i_page.' of '.$pageCount.' by '.$i_sortby;
74 echo '<table cellspacing="0" cellpadding="0" class="usertable">';
76 foreach($columns as $column) {
77 if (!empty($column)) {
78 $qsa = array('sortby'=>$column);
79 if ($column==$i_sortby)
80 $qsa['sortorder']=abs($i_sortorder-1);
81 echo '<td><a href="'.$URI.newQSA($qsa).'">'.$column.'</a></td>';
82 } else echo '<td></td>';
85 foreach($users as $id=>$user) {
89 '<a href="do/admin/main',newQSA(array('impersonate'=>$id)),'">',
91 '</a></td><td><a href="http://web.mit.edu/bin/cgicso?query='.$user['Username'].'" target="_new">',
94 sprintSize($user['nBytes']),
96 sprintSize($user['nBytesHard']),
98 sprintSize($user['nBytesOver']),
102 // $user['dLastCheck'],
107 include 'tpl/foot.php';