docs/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 \r
  72 \r
  73 <?php \r
  74 $savant->assign('result', $result);\r
  75 $savant->assign('operations', $operations);\r
  76 $savant->display('admin/users/log.tmpl.php');\r
  77 require(AT_INCLUDE_PATH.'footer.inc.php'); ?>