]>
Commit | Line | Data |
---|---|---|
1 | <?php | |
2 | ||
3 | require_once('../mitsql.cfg.php'); | |
4 | require_once('mitsql.lib.php'); | |
5 | ||
6 | if ((isAdmin() || isImpersonating()) && isset($i_impersonate)) { | |
7 | impersonate($i_impersonate); | |
8 | redirectStart(); | |
9 | exit; | |
10 | } | |
11 | ||
12 | if (!isAdmin()) redirectStart(); | |
13 | ||
14 | // INNER JOIN UserStat ON User.UserId = UserStat.UserId | |
15 | $sql = sprintf("SELECT User.UserId,Username,Name,dSignup,dLastCheck,nBytes,nBytesSoft,nBytesHard | |
16 | FROM User | |
17 | NATURAL JOIN UserStat | |
18 | NATURAL JOIN UserQuota | |
19 | WHERE bEnabled=1 | |
20 | ORDER BY dSignup"); | |
21 | $users = fetchRows(DBSelect($sql),'UserId'); | |
22 | ||
23 | include 'tpl/head.php'; | |
24 | ||
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">'; | |
35 | foreach($users as $id=>$user) { | |
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>', | |
46 | sprintSize($user['nBytesHard']), | |
47 | '</td><td>', | |
48 | $user['dSignup'], | |
49 | '</td><td>', | |
50 | $user['dLastCheck'], | |
51 | '</td></tr>'; | |
52 | } | |
53 | echo '</table>'; | |
54 | ||
55 | echo '<em>',count($users),' users</em>'; | |
56 | ||
57 | include 'tpl/foot.php'; | |
58 | ||
59 | ?> |