docs/mods/_core/users/admins/detail_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 if (isset($_POST['submit'])) {\r
  20         header('Location: log.php?p='.$_POST['p'].SEP.'login='.$_POST['login']);\r
  21         exit;\r
  22 }\r
  23 \r
  24 require(AT_INCLUDE_PATH.'header.inc.php');\r
  25 \r
  26 $offset = $_GET['offset'] - 1;\r
  27 $col = $addslashes($_GET['col']);\r
  28 $order = $addslashes($_GET['order']);\r
  29 \r
  30 $login_where = '';\r
  31 if (isset($_GET['login']) && $_GET['login']) {\r
  32         $_GET['login'] = $addslashes($_GET['login']);\r
  33 \r
  34         $login_where = ' WHERE login=\''.$_GET['login'].'\'';\r
  35 }\r
  36 \r
  37 $sql = "SELECT * FROM ".TABLE_PREFIX."admin_log $login_where ORDER BY `time` DESC LIMIT $offset,1";\r
  38 $result = mysql_query($sql, $db);\r
  39 $row = mysql_fetch_assoc($result);\r
  40 \r
  41 $operations[AT_ADMIN_LOG_UPDATE] = _AT('update_to');\r
  42 $operations[AT_ADMIN_LOG_DELETE] = _AT('delete_from');\r
  43 $operations[AT_ADMIN_LOG_INSERT] = _AT('insert_into');\r
  44 $operations[AT_ADMIN_LOG_REPLACE] = _AT('replace_into');\r
  45 $operations[AT_ADMIN_LOG_OTHER] = _AT('other');\r
  46 \r
  47 ?>\r
  48 <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">\r
  49 <input type="hidden" name="p" value="<?php echo $_GET['p']; ?>" />\r
  50 <input type="hidden" name="login" value="<?php echo $_GET['login']; ?>" />\r
  51 <div class="input-form">\r
  52         <div class="row">\r
  53                 <?php echo _AT('date'); ?><br />\r
  54                 <?php echo $row['time']; ?>\r
  55         </div>\r
  56         <div class="row">\r
  57                 <?php echo _AT('login_name'); ?><br />\r
  58                 <?php echo $row['login']; ?>\r
  59         </div>\r
  60         <div class="row">\r
  61                 <?php echo _AT('action'); ?><br />\r
  62                 <?php echo $operations[$row['operation']]; ?>\r
  63         </div>\r
  64 \r
  65         <div class="row">\r
  66                 <?php echo _AT('database_table'); ?><br />\r
  67                 <?php echo TABLE_PREFIX . $row['table']; ?>\r
  68         </div>\r
  69         <div class="row">\r
  70                 <?php echo _AT('affected_entries'); ?><br />\r
  71                 <?php echo $row['num_affected']; ?>\r
  72         </div>\r
  73         <div class="row">\r
  74                 <?php echo _AT('details'); ?><br />\r
  75                 <kbd>\r
  76                         <?php echo htmlspecialchars(wordwrap($row['details'], 80, "\n", TRUE)); ?>\r
  77                 </kbd>\r
  78         </div>\r
  79 \r
  80         <div class="row buttons">\r
  81                 <input type="submit" name="submit" value="<?php echo _AT('back'); ?>" />\r
  82         </div>\r
  83 </div>\r
  84 </form>\r
  85 \r
  86 <?php require(AT_INCLUDE_PATH.'footer.inc.php'); ?>