admin/admin.php

   1 <?
   2 /**
   3  * Admin.php
   4  *
   5 include_once("include/session.php");
   6
   7 /**
   8  * displayUsers - Displays the users database table in
   9  * a nicely formatted html table.
  10  */
  11 function displayUsers(){
  12    global $database;
  13    $q = "SELECT username,userlevel,email,timestamp FROM ".TBL_USERS." ORDER BY userlevel DESC;";
  14    $result = $database->query($q);
  15    /* Error occurred, return given name by default */
  16    $num_rows = mysql_numrows($result);
  17    if(!$result || ($num_rows < 0)){
  18       echo "Error displaying info";
  19       return;
  20    }
  21    if($num_rows == 0){
  22       echo "Database table empty";
  23       return;
  24    }
  25    /* Display table contents */
  26    echo '<table border="1" cellspacing="0" cellpadding="3">';
  27    echo "<tr><td><b>Código</b></td><td><b>Level</b></td><td><b>Email</b></td><td><b>Last Active</b></td></tr>\n";
  28    for($i=0; $i<$num_rows; $i++){
  29       $uname  = mysql_result($result,$i,"username");
  30       $uname = '<a href=./?x=usr+info&usr='.$uname.'>'.$uname.'</a>';
  31       $ulevel = mysql_result($result,$i,"userlevel");
  32       $email  = mysql_result($result,$i,"email");
  33       $time   = mysql_result($result,$i,"timestamp");
  34
  35       echo "<tr><td>$uname</td><td>$ulevel</td><td>$email</td><td>$time</td></tr>\n";
  36    }
  37    echo "</table><br>\n";
  38 }
  39
  40 /**
  41  * displayBannedUsers - Displays the banned users
  42  * database table in a nicely formatted html table.
  43  */
  44 function displayBannedUsers(){
  45    global $database;
  46    $q = "SELECT username,timestamp "
  47        ."FROM ".TBL_BANNED_USERS." ORDER BY username";
  48    $result = $database->query($q);
  49    /* Error occurred, return given name by default */
  50    $num_rows = mysql_numrows($result);
  51    if(!$result || ($num_rows < 0)){
  52       echo "Error displaying info";
  53       return;
  54    }
  55    if($num_rows == 0){
  56       echo "Database table empty";
  57       return;
  58    }
  59    /* Display table contents */
  60    echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"3\">\n";
  61    echo "<tr><td><b>username</b></td><td><b>Time Banned</b></td></tr>\n";
  62    for($i=0; $i<$num_rows; $i++){
  63       $uname = mysql_result($result,$i,"username");
  64       $time  = mysql_result($result,$i,"timestamp");
  65
  66       echo "<tr><td>$uname</td><td>$time</td></tr>\n";
  67    }
  68    echo "</table><br>\n";
  69 }
  70
  71 /**
  72  * User not an administrator, redirect to main page
  73  * automatically.
  74  */
  75 if(!$session->isAdmin()){
  76    header("Location: ./");
  77 }
  78 else{
  79 /**
  80  * Administrator is viewing page, so display all
  81  * forms.
  82  */
  83 ?>
  84 <h3>Centro de Administración</h3>
  85 <?
  86 if($form->num_errors > 0){
  87    echo "<font size=\"4\" color=\"#ff0000\">"
  88        ."!*** Error with request, please fix</font><br><br>";
  89 }
  90 ?>
  91 <table border="0">
  92 <tr><td>
  93 <?
  94 /**
  95  * Display Users Table
  96  */
  97 ?>
  98 <h3>Users Table Contents:</h3>
  99 <?
 100 displayUsers();
 101 ?>
 102 </td></tr>
 103 <tr>
 104 <td>
 105 <br>
 106 <?
 107 /**
 108  * Update User Level
 109  */
 110 ?>
 111 <h3>Establecer permisos a instructor</h3>
 112 <? echo $form->error("upduser"); ?>
 113 <form action="admin/adminprocess.php" method="POST">
 114 <table>
 115 <tr>
 116 <td>
 117 Código:<br>
 118 <input type="text" name="upduser" maxlength="30" value="<? echo $form->value("upduser"); ?>">
 119 </td>
 120 <td>
 121 Level:<br>
 122 <select name="updlevel">
 123 <option value="1">1
 124 <option value="9">9
 125 </select>
 126 </td>
 127 <td>
 128 <br>
 129 <input type="hidden" name="subupdlevel" value="1">
 130 <input type="submit" value="Update Level">
 131 </td></tr>
 132 </table>
 133 </form>
 134 <?
 135 /**
 136  * Delete User
 137  */
 138 ?>
 139 <h3>Quitar Instructor</h3>
 140 <? echo $form->error("deluser"); ?>
 141 <form action="admin/adminprocess.php" method="POST">
 142 Código:<br>
 143 <input type="text" name="deluser"  maxlength="30" value="<? echo $form->value("deluser"); ?>">
 144 <input type="hidden" name="subdeluser" value="1">
 145 <input type="submit" value="Delete User">
 146 </form>
 147 <?
 148 /**
 149  * Delete Inactive Users
 150  */
 151 ?>
 152 <h3>Borrar instructores inactivos</h3>
 153 Esto borrará todos los usuarios (no administradores), que no se hayan registrado en el sitio
 154 en un cierto periodo de tiempo. <br /><br />
 155 <table>
 156 <form action="admin/adminprocess.php" method="POST">
 157 <tr><td>
 158 Days:<br>
 159 <select name="inactdays">
 160 <option value="3">3
 161 <option value="7">7
 162 <option value="14">14
 163 <option value="30">30
 164 <option value="100">100
 165 <option value="365">365
 166 </select>
 167 </td>
 168 <td>
 169 <br>
 170 <input type="hidden" name="subdelinact" value="1">
 171 <input type="submit" value="Delete All Inactive">
 172 </td>
 173 </form>
 174 </table>
 175 </td>
 176 </tr>
 177 <tr>
 178 <td><hr></td>
 179 </tr>
 180 <tr>
 181 <td>
 182 <?
 183 /**
 184  * Ban User
 185  */
 186 ?>
 187 <h3>Restringir Instructor</h3>
 188 <? echo $form->error("banuser"); ?>
 189 <form action="admin/adminprocess.php" method="POST">
 190 Código:<br>
 191 <input type="text" name="banuser"  maxlength="30" value="<? echo $form->value("banuser"); ?>">
 192 <input type="hidden" name="subbanuser" value="1">
 193 <input type="submit" value="Ban User">
 194 </form>
 195 </td>
 196 </tr>
 197 <tr>
 198 <td><hr></td>
 199 </tr>
 200 <tr><td>
 201 <?
 202 /**
 203  * Display Banned Users Table
 204  */
 205 ?>
 206 <h3>Instructores restringidos:</h3>
 207 <?
 208 displayBannedUsers();
 209 ?>
 210 </td></tr>
 211 <?
 212 /**
 213  * Delete Banned User
 214  */
 215 ?>
 216 <h3>Quitar restricción al instructor con código</h3>
 217 <? echo $form->error("delbanuser"); ?>
 218 <form action="admin/adminprocess.php" method="POST">
 219 Código:<br>
 220 <input type="text" name="delbanuser"  maxlength="30" value="<? echo $form->value("delbanuser"); ?>">
 221 <input type="hidden" name="subdelbanned" value="1">
 222 <input type="submit" value="Delete Banned User">
 223 </form>
 224 </td>
 225 </tr>
 226 </table>
 227 <?
 228 }
 229 ?>
 230