]>
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 | ||
1050fbb7 | 14 | // INNER JOIN UserStat ON User.UserId = UserStat.UserId |
d02b16c4 | 15 | $sql = sprintf("SELECT User.UserId,Username,Name,dSignup,dLastCheck,nBytes,nBytesSoft,nBytesHard |
1050fbb7 JP |
16 | FROM User |
17 | NATURAL JOIN UserStat | |
d02b16c4 | 18 | NATURAL JOIN UserQuota |
1050fbb7 JP |
19 | WHERE bEnabled=1 |
20 | ORDER BY dSignup"); | |
d1f4316d JP |
21 | $users = fetchRows(DBSelect($sql),'UserId'); |
22 | ||
23 | include 'tpl/head.php'; | |
24 | ||
d02b16c4 JP |
25 | ?> |
26 | <style> | |
27 | table.usertable td { | |
28 | border: 1px solid black; | |
29 | padding: 1px 2px 1px 2px; | |
30 | } | |
31 | </style> | |
32 | <?php | |
33 | ||
34 | echo '<table cellspacing="0" cellpadding="0" class="usertable">'; | |
d1f4316d | 35 | foreach($users as $id=>$user) { |
1050fbb7 JP |
36 | echo '<tr><td>', |
37 | $user['UserId'], | |
38 | '</td><td>', | |
39 | '<a href="do/admin/main',newQSA(array('impersonate'=>$id)),'">', | |
40 | $user['Username'], | |
41 | '</a></td><td>', | |
42 | $user['Name'], | |
43 | '</td><td>', | |
44 | sprintSize($user['nBytes']), | |
45 | '</td><td>', | |
d02b16c4 JP |
46 | sprintSize($user['nBytesHard']), |
47 | '</td><td>', | |
1050fbb7 | 48 | $user['dSignup'], |
d02b16c4 JP |
49 | '</td><td>', |
50 | $user['dLastCheck'], | |
1050fbb7 | 51 | '</td></tr>'; |
d1f4316d | 52 | } |
1050fbb7 | 53 | echo '</table>'; |
d1f4316d | 54 | |
d02b16c4 JP |
55 | echo '<em>',count($users),' users</em>'; |
56 | ||
d1f4316d JP |
57 | include 'tpl/foot.php'; |
58 | ||
1426e302 | 59 | ?> |