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 DESC");
  21 //                              ORDER BY nBytes DESC");
  22 $users = fetchRows(DBSelect($sql),'UserId');
  23
  24 include 'tpl/head.php';
  25
  26 ?>
  27 <style>
  28 table.usertable td {
  29         border: 1px solid black;
  30         padding: 1px 2px 1px 2px;
  31 }
  32 </style>
  33 <?php
  34
  35 echo '<table cellspacing="0" cellpadding="0" class="usertable">';
  36 foreach($users as $id=>$user) {
  37         echo '<tr><td>',
  38                 $user['UserId'],
  39                 '</td><td>',
  40                 '<a href="do/admin/main',newQSA(array('impersonate'=>$id)),'">',
  41                 $user['Username'],
  42                 '</a></td><td>',
  43                 $user['Name'],
  44                 '</td><td>',
  45                 sprintSize($user['nBytes']),
  46                 '</td><td>',
  47                 sprintSize($user['nBytesHard']),
  48                 '</td><td>',
  49                 $user['dSignup'],
  50                 '</td><td>',
  51                 $user['dLastCheck'],
  52                 '</td></tr>';
  53 }
  54 echo '</table>';
  55
  56 echo '<em>',count($users),' users</em>';
  57
  58 include 'tpl/foot.php';
  59
  60 ?>