admin/main.php

   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 ?>