]>
Commit | Line | Data |
---|---|---|
1426e302 JP |
1 | <?php |
2 | ||
3 | require_once('../mitsql.cfg.php'); | |
e47be57b | 4 | require_once('mitsql.lib.php'); |
1426e302 | 5 | |
224df904 | 6 | if ((isAdmin() || isImpersonating()) && isset($i_impersonate)) { |
d1f4316d | 7 | impersonate($i_impersonate); |
224df904 | 8 | redirectStart(); |
d1f4316d JP |
9 | exit; |
10 | } | |
11 | ||
224df904 JP |
12 | if (!isAdmin()) redirectStart(); |
13 | ||
77bd9685 JP |
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; | |
27aca87f | 18 | !isset($i_search) && $i_search=''; |
77bd9685 JP |
19 | |
20 | if ($i_sortorder>0) $sortSQL = 'ASC'; else $sortSQL = 'DESC'; | |
21 | ||
22 | $i_pagesize = mysql_escape_string($i_pagesize); | |
23 | $i_page = mysql_escape_string($i_page); | |
27aca87f | 24 | $i_search = mysql_escape_string($i_search); |
77bd9685 JP |
25 | $i_sortby = mysql_escape_string($i_sortby); |
26 | ||
27aca87f JP |
27 | $sql_search = empty($i_search)?'':" AND Username LIKE '%$i_search%' "; |
28 | ||
77bd9685 JP |
29 | $columns = array('','Username','Name','nBytes','nBytesHard','nBytesOver','dSignup'); |
30 | ||
31 | $userCount = 0; | |
27aca87f | 32 | $sqlc = "SELECT COUNT(*) as c FROM User WHERE bEnabled=1 $sql_search"; |
77bd9685 JP |
33 | $r = fetchRows(DBSelect($sqlc)); |
34 | $r = array_shift($r); | |
35 | count($r) && $userCount = array_shift($r); | |
36 | ||
27aca87f | 37 | $sql = "SELECT User.UserId,Username,Name,dSignup,dLastCheck,nBytes,nBytesSoft,nBytesHard, |
77bd9685 | 38 | IF(nBytes>nBytesHard,nBytes-nBytesHard,0) as nBytesOver |
1050fbb7 JP |
39 | FROM User |
40 | NATURAL JOIN UserStat | |
d02b16c4 | 41 | NATURAL JOIN UserQuota |
1050fbb7 | 42 | WHERE bEnabled=1 |
27aca87f JP |
43 | $sql_search |
44 | ORDER BY $i_sortby $sortSQL"; | |
77bd9685 JP |
45 | |
46 | $sql .= ' LIMIT '.($i_page-1)*$i_pagesize.','.$i_pagesize; | |
47 | $pageArray = range(1,ceil($userCount/$i_pagesize)); | |
48 | $pageCount = count($pageArray); | |
49 | ||
d1f4316d JP |
50 | $users = fetchRows(DBSelect($sql),'UserId'); |
51 | ||
52 | include 'tpl/head.php'; | |
53 | ||
d02b16c4 JP |
54 | ?> |
55 | <style> | |
56 | table.usertable td { | |
57 | border: 1px solid black; | |
77bd9685 | 58 | padding: 0px 2px 0px 2px; |
d02b16c4 JP |
59 | } |
60 | </style> | |
61 | <?php | |
62 | ||
77bd9685 JP |
63 | echo '<em>',$userCount,' users</em> | '; |
64 | if ($i_page > 1) $tPagePrev = ' <a href="'.$URI.newQS('page',$i_page-1).'">Prev</a>'; else $tPagePrev = 'First'; | |
65 | if ($i_page < $pageCount) $tPageNext = ' <a href="'.$URI.newQS('page',$i_page+1).'">Next</a>'; else $tPageNext = 'Last'; | |
66 | if (!empty($tPageNext) && empty($tPagePrev)) echo($tPageNext); | |
67 | elseif (empty($tPageNext) && !empty($tPagePrev)) echo($tPagePrev); | |
68 | else echo "$tPagePrev | $tPageNext"; | |
69 | ||
70 | /* | |
71 | echo ' | Skip to: '; | |
72 | foreach($pageArray as $availablePage) { | |
73 | echo ' <a href="'.$URI.newQS('page',$availablePage).'">'.$availablePage.'</a>'; | |
74 | } | |
75 | */ | |
76 | ||
77 | echo ' | Page '.$i_page.' of '.$pageCount.' by '.$i_sortby; | |
27aca87f JP |
78 | ?> |
79 | <span></span> | |
80 | <form method=get id=search name=search> | |
81 | <input type=text name=search value="<?=$i_search?>" /> | |
82 | <input type=submit value="Search" /> | |
83 | <input type=button value="Clear" onClick="document.forms['search']['search'].value = ''; document.forms['search'].submit();" /> | |
84 | </form> | |
85 | <?php | |
d02b16c4 | 86 | echo '<table cellspacing="0" cellpadding="0" class="usertable">'; |
77bd9685 JP |
87 | echo '<thead>'; |
88 | foreach($columns as $column) { | |
89 | if (!empty($column)) { | |
90 | $qsa = array('sortby'=>$column); | |
91 | if ($column==$i_sortby) | |
92 | $qsa['sortorder']=abs($i_sortorder-1); | |
93 | echo '<td><a href="'.$URI.newQSA($qsa).'">'.$column.'</a></td>'; | |
94 | } else echo '<td></td>'; | |
95 | } | |
96 | echo '</thead>'; | |
d1f4316d | 97 | foreach($users as $id=>$user) { |
1050fbb7 JP |
98 | echo '<tr><td>', |
99 | $user['UserId'], | |
100 | '</td><td>', | |
101 | '<a href="do/admin/main',newQSA(array('impersonate'=>$id)),'">', | |
102 | $user['Username'], | |
77bd9685 | 103 | '</a></td><td><a href="http://web.mit.edu/bin/cgicso?query='.$user['Username'].'" target="_new">', |
1050fbb7 | 104 | $user['Name'], |
77bd9685 | 105 | '</a></td><td>', |
1050fbb7 JP |
106 | sprintSize($user['nBytes']), |
107 | '</td><td>', | |
d02b16c4 JP |
108 | sprintSize($user['nBytesHard']), |
109 | '</td><td>', | |
77bd9685 | 110 | sprintSize($user['nBytesOver']), |
d02b16c4 | 111 | '</td><td>', |
77bd9685 JP |
112 | $user['dSignup'], |
113 | // '</td><td>', | |
114 | // $user['dLastCheck'], | |
1050fbb7 | 115 | '</td></tr>'; |
d1f4316d | 116 | } |
1050fbb7 | 117 | echo '</table>'; |
d1f4316d JP |
118 | |
119 | include 'tpl/foot.php'; | |
120 | ||
1426e302 | 121 | ?> |