mods/_core/users/admins/log.php

   1 <?php\r
   2 /****************************************************************/\r
   3 /* ATutor                                                                                                               */\r
   4 /****************************************************************/\r
   5 /* Copyright (c) 2002-2010                                      */\r
   6 /* Inclusive Design Institute                                   */\r
   7 /* http://atutor.ca                                                                                             */\r
   8 /*                                                              */\r
   9 /* This program is free software. You can redistribute it and/or*/\r
  10 /* modify it under the terms of the GNU General Public License  */\r
  11 /* as published by the Free Software Foundation.                                */\r
  12 /****************************************************************/\r
  13 // $Id$\r
  14 \r
  15 define('AT_INCLUDE_PATH', '../../../../include/');\r
  16 require(AT_INCLUDE_PATH.'vitals.inc.php');\r
  17 admin_authenticate(AT_ADMIN_PRIV_ADMIN);\r
  18 \r
  19 require(AT_INCLUDE_PATH.'header.inc.php');\r
  20 \r
  21 $operations[AT_ADMIN_LOG_UPDATE] = _AT('update_to');\r
  22 $operations[AT_ADMIN_LOG_DELETE] = _AT('delete_from');\r
  23 $operations[AT_ADMIN_LOG_INSERT] = _AT('insert_into');\r
  24 $operations[AT_ADMIN_LOG_REPLACE] = _AT('replace_into');\r
  25 $operations[AT_ADMIN_LOG_OTHER] = _AT('other');\r
  26 \r
  27 $login_where = '';\r
  28 if (isset($_GET['login']) && $_GET['login']) {\r
  29         $_GET['login'] = $addslashes($_GET['login']);\r
  30 \r
  31         $login_where = ' WHERE login=\''.$_GET['login'].'\'';\r
  32 }\r
  33 \r
  34 $sql    = "SELECT COUNT(login) FROM ".TABLE_PREFIX."admin_log $login_where";\r
  35 $result = mysql_query($sql, $db);\r
  36 \r
  37 if (($row = mysql_fetch_row($result))==0) {\r
  38         echo '<tr><td colspan="7" class="row1">'._AT('no_log_found_').'</td></tr>';\r
  39         require(AT_INCLUDE_PATH.'footer.inc.php');\r
  40         exit;\r
  41 }\r
  42 \r
  43         $num_results = $row[0];\r
  44         $results_per_page = 50;\r
  45         $num_pages = max(ceil($num_results / $results_per_page), 1);\r
  46         $page = intval($_GET['p']);\r
  47         if (!$page) {\r
  48                 $page = 1;\r
  49         }       \r
  50         $count = (($page-1) * $results_per_page) + 1;\r
  51 \r
  52         echo '<div class="paging">';\r
  53         echo '<ul>';\r
  54         for ($i=1; $i<=$num_pages; $i++) {\r
  55                 echo '<li>';\r
  56                 if ($i == $page) {\r
  57                         echo '<a class="current" href="'.$_SERVER['PHP_SELF'].'?p='.$i.SEP.'login='.$_GET['login'].'"><strong>'.$i.'</strong></a>';\r
  58                 } else {\r
  59                         echo '<a href="'.$_SERVER['PHP_SELF'].'?p='.$i.SEP.'login='.$_GET['login'].'#list">'.$i.'</a>';\r
  60                 }\r
  61                 echo '</li>';\r
  62         }\r
  63         echo '</ul>';\r
  64         echo '</div>';\r
  65 \r
  66         $offset = ($page-1)*$results_per_page;\r
  67 \r
  68         $sql    = "SELECT * FROM ".TABLE_PREFIX."admin_log $login_where ORDER BY `time` DESC LIMIT $offset, $results_per_page";\r
  69         $result = mysql_query($sql, $db);\r
  70 ?>\r
  71 <table summary="" class="data" rules="cols" align="center">\r
  72 <thead>\r
  73 <tr>\r
  74         <th scope="col"><?php echo _AT('date');           ?></th>\r
  75         <th scope="col"><?php echo _AT('login_name');     ?></th>\r
  76         <th scope="col"><?php echo _AT('action');         ?></th>\r
  77         <th scope="col"><?php echo _AT('database_table'); ?></th>\r
  78 </tr>\r
  79 </thead>\r
  80 <tbody>\r
  81 <?php if (mysql_num_rows($result) > 0) : ?>\r
  82         <?php while ($row = mysql_fetch_assoc($result)): ?>\r
  83                 <?php $offset++; ?>\r
  84                 <tr onmousedown="document.location='<?php echo AT_BASE_HREF; ?>mods/_core/users/admins/detail_log.php?offset=<?php echo $offset.SEP.'p='.$page.SEP.'login='.$_GET['login']; ?>'" title="<?php echo _AT('view_details'); ?>">\r
  85                         <td><a href="<?php echo AT_BASE_HREF; ?>mods/_core/users/admins/detail_log.php?offset=<?php echo $offset.SEP.'p='.$page.SEP.'login='.$_GET['login']; ?>"><?php echo $row['time']; ?></a></td>\r
  86                         <td><?php echo $row['login']; ?></td>\r
  87                         <td><?php echo $operations[$row['operation']]; ?></td>\r
  88                         <td><?php echo $row['table']; ?></td>\r
  89                 </tr>\r
  90         <?php endwhile; ?>\r
  91 <?php else: ?>\r
  92 <tr>\r
  93         <td colspan="4"><?php echo _AT('none_found'); ?></td>\r
  94 </tr>\r
  95 <?php endif; ?>\r
  96 </tbody>\r
  97 </table>\r
  98 \r
  99 <?php require(AT_INCLUDE_PATH.'footer.inc.php'); ?>