phpBB/modules/acp/acp_logs.php

   1 <?php
   2 /**
   3 *
   4 * @package acp
   5 * @version $Id$
   6 * @copyright (c) 2005 phpBB Group
   7 * @license http://opensource.org/licenses/gpl-license.php GNU Public License
   8 *
   9 */
  10
  11 /**
  12 * @ignore
  13 */
  14 if (!defined('IN_PHPBB'))
  15 {
  16         exit;
  17 }
  18
  19 /**
  20 * @package acp
  21 */
  22 class acp_logs
  23 {
  24         var $u_action;
  25
  26         function main($id, $mode)
  27         {
  28                 phpbb::$user->add_lang('mcp');
  29
  30                 // Set up general vars
  31                 $action         = request_var('action', '');
  32                 $forum_id       = request_var('f', 0);
  33                 $start          = request_var('start', 0);
  34                 $deletemark = phpbb_request::variable('delmarked', false, false, phpbb_request::POST);
  35                 $deleteall      = phpbb_request::variable('delall', false, false, phpbb_request::POST);
  36                 $marked         = request_var('mark', array(0));
  37
  38                 // Sort keys
  39                 $sort_days      = request_var('st', 0);
  40                 $sort_key       = request_var('sk', 't');
  41                 $sort_dir       = request_var('sd', 'd');
  42
  43                 $this->tpl_name = 'acp_logs';
  44                 $this->log_type = constant('LOG_' . strtoupper($mode));
  45
  46                 // Delete entries if requested and able
  47                 if (($deletemark || $deleteall) && phpbb::$acl->acl_get('a_clearlogs'))
  48                 {
  49                         if (confirm_box(true))
  50                         {
  51                                 $where_sql = '';
  52
  53                                 if ($deletemark && sizeof($marked))
  54                                 {
  55                                         $sql_in = array();
  56                                         foreach ($marked as $mark)
  57                                         {
  58                                                 $sql_in[] = $mark;
  59                                         }
  60                                         $where_sql = ' AND ' . phpbb::$db->sql_in_set('log_id', $sql_in);
  61                                         unset($sql_in);
  62                                 }
  63
  64                                 if ($where_sql || $deleteall)
  65                                 {
  66                                         $sql = 'DELETE FROM ' . LOG_TABLE . "
  67                                                 WHERE log_type = {$this->log_type}
  68                                                 $where_sql";
  69                                         phpbb::$db->sql_query($sql);
  70
  71                                         add_log('admin', 'LOG_CLEAR_' . strtoupper($mode));
  72                                 }
  73                         }
  74                         else
  75                         {
  76                                 confirm_box(false, phpbb::$user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(
  77                                         'f'                     => $forum_id,
  78                                         'start'         => $start,
  79                                         'delmarked'     => $deletemark,
  80                                         'delall'        => $deleteall,
  81                                         'mark'          => $marked,
  82                                         'st'            => $sort_days,
  83                                         'sk'            => $sort_key,
  84                                         'sd'            => $sort_dir,
  85                                         'i'                     => $id,
  86                                         'mode'          => $mode,
  87                                         'action'        => $action))
  88                                 );
  89                         }
  90                 }
  91
  92                 // Sorting
  93                 $limit_days = array(0 => phpbb::$user->lang['ALL_ENTRIES'], 1 => phpbb::$user->lang['1_DAY'], 7 => phpbb::$user->lang['7_DAYS'], 14 => phpbb::$user->lang['2_WEEKS'], 30 => phpbb::$user->lang['1_MONTH'], 90 => phpbb::$user->lang['3_MONTHS'], 180 => phpbb::$user->lang['6_MONTHS'], 365 => phpbb::$user->lang['1_YEAR']);
  94                 $sort_by_text = array('u' => phpbb::$user->lang['SORT_USERNAME'], 't' => phpbb::$user->lang['SORT_DATE'], 'i' => phpbb::$user->lang['SORT_IP'], 'o' => phpbb::$user->lang['SORT_ACTION']);
  95                 $sort_by_sql = array('u' => 'u.username_clean', 't' => 'l.log_time', 'i' => 'l.log_ip', 'o' => 'l.log_operation');
  96
  97                 $s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';
  98                 gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);
  99
 100                 // Define where and sort sql for use in displaying logs
 101                 $sql_where = ($sort_days) ? (time() - ($sort_days * 86400)) : 0;
 102                 $sql_sort = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');
 103
 104                 $l_title = phpbb::$user->lang['ACP_' . strtoupper($mode) . '_LOGS'];
 105                 $l_title_explain = phpbb::$user->lang['ACP_' . strtoupper($mode) . '_LOGS_EXPLAIN'];
 106
 107                 $this->page_title = $l_title;
 108
 109                 // Define forum list if we're looking @ mod logs
 110                 if ($mode == 'mod')
 111                 {
 112                         $forum_box = '<option value="0">' . phpbb::$user->lang['ALL_FORUMS'] . '</option>' . make_forum_select($forum_id);
 113
 114                         phpbb::$template->assign_vars(array(
 115                                 'S_SHOW_FORUMS'                 => true,
 116                                 'S_FORUM_BOX'                   => $forum_box,
 117                         ));
 118                 }
 119
 120                 // Grab log data
 121                 $log_data = array();
 122                 $log_count = 0;
 123                 view_log($mode, $log_data, $log_count, phpbb::$config['topics_per_page'], $start, $forum_id, 0, 0, $sql_where, $sql_sort);
 124
 125                 phpbb::$template->assign_vars(array(
 126                         'L_TITLE'               => $l_title,
 127                         'L_EXPLAIN'             => $l_title_explain,
 128                         'U_ACTION'              => $this->u_action,
 129
 130                         'S_ON_PAGE'             => on_page($log_count, phpbb::$config['topics_per_page'], $start),
 131                         'PAGINATION'    => generate_pagination($this->u_action . "&amp;$u_sort_param", $log_count, phpbb::$config['topics_per_page'], $start, true),
 132
 133                         'S_LIMIT_DAYS'  => $s_limit_days,
 134                         'S_SORT_KEY'    => $s_sort_key,
 135                         'S_SORT_DIR'    => $s_sort_dir,
 136                         'S_CLEARLOGS'   => phpbb::$acl->acl_get('a_clearlogs'),
 137                 ));
 138
 139                 foreach ($log_data as $row)
 140                 {
 141                         $data = array();
 142
 143                         $checks = array('viewtopic', 'viewlogs', 'viewforum');
 144                         foreach ($checks as $check)
 145                         {
 146                                 if (isset($row[$check]) && $row[$check])
 147                                 {
 148                                         $data[] = '<a href="' . $row[$check] . '">' . phpbb::$user->lang['LOGVIEW_' . strtoupper($check)] . '</a>';
 149                                 }
 150                         }
 151
 152                         phpbb::$template->assign_block_vars('log', array(
 153                                 'USERNAME'                      => $row['username_full'],
 154                                 'REPORTEE_USERNAME'     => ($row['reportee_username'] && $row['user_id'] != $row['reportee_id']) ? $row['reportee_username_full'] : '',
 155
 156                                 'IP'                            => $row['ip'],
 157                                 'DATE'                          => phpbb::$user->format_date($row['time']),
 158                                 'ACTION'                        => $row['action'],
 159                                 'DATA'                          => (sizeof($data)) ? implode(' | ', $data) : '',
 160                                 'ID'                            => $row['id'],
 161                         ));
 162                 }
 163         }
 164 }
 165
 166 ?>