/upload/admin/admin_log.php
http://torrentpier2.googlecode.com/ · PHP · 416 lines · 310 code · 75 blank · 31 comment · 42 complexity · 275c20878a09051cd4c8ae92becee73d MD5 · raw file
- <?php
- // ACP Header - START
- if (!empty($setmodules))
- {
- $module['Users']['Actions_log'] = basename(__FILE__);
- return;
- }
- require('./pagestart.php');
- // ACP Header - END
- $datastore->enqueue(array(
- 'moderators',
- ));
- $log_action->init();
- $per_page = 50;
- $row_class_1 = 'row1';
- $row_class_2 = 'row2';
- $def_days = 3;
- $def_datetime = TIMENOW;
- $max_forum_name_len = 40;
- $title_match_max_len = 60;
- $poster_name_max_len = 25;
- $select_max_height = 16;
- $dt_format = 'Y-m-d'; // used in one-day filter
- $url = basename(__FILE__);
- // Key names
- $type_key = 'type';
- $forum_key = 'f';
- $topic_key = 't';
- $user_key = 'u';
- $datetime_key = 'dt'; // value should be strtotime() time ("2006-06-25" etc.)
- $daysback_key = 'db';
- $sort_key = 'sort';
- $title_match_key = 'tm';
- // Key values
- $all_types = 0; // =|
- $all_users = 0; // |> only "0" is a valid value
- $all_forums = 0; // =|
- $sort_asc = 'ASC';
- $sort_desc = 'DESC';
- // Defaults
- $def_types = $all_types;
- $def_users = $all_users;
- $def_forums = $all_forums;
- $def_sort = $sort_desc;
- // Moderators data
- if (!$mod = $datastore->get('moderators'))
- {
- $datastore->update('moderators');
- $mod = $datastore->get('moderators');
- }
- array_deep($mod['moderators'], 'html_entity_decode');
- array_deep($mod['admins'], 'html_entity_decode');
- $users = array($lang['ACTS_LOG_ALL_ACTIONS'] => $all_users) + array_flip($mod['moderators']) + array_flip($mod['admins']);
- unset($mod);
- // Forums data
- if (!$forums = $datastore->get('cat_forums'))
- {
- $datastore->update('cat_forums');
- $forums = $datastore->get('cat_forums');
- }
- $f_data = $forums['f'];
- unset($forums);
- // Start
- $start = isset($_REQUEST['start']) ? abs(intval($_REQUEST['start'])) : 0;
- // Type
- $type_selected = array($def_types);
- $type_csv = '';
- if ($var =& $_REQUEST[$type_key])
- {
- $type_selected = get_id_ary($var);
- if (in_array($all_types, $type_selected))
- {
- $type_selected = array($all_types);
- }
- $type_csv = join(',', $type_selected);
- $url = ($type_csv != $def_types) ? url_arg($url, $type_key, $type_csv) : $url;
- }
- // User
- $user_selected = array($def_users);
- $user_csv = '';
- if ($var =& $_REQUEST[$user_key])
- {
- $user_selected = get_id_ary($var);
- if (in_array($all_users, $user_selected))
- {
- $user_selected = array($all_users);
- }
- $user_csv = join(',', $user_selected);
- $url = ($user_csv != $def_users) ? url_arg($url, $user_key, $user_csv) : $url;
- }
- // Forum
- $forum_selected = array($def_forums);
- $forum_csv = '';
- if ($var =& $_REQUEST[$forum_key])
- {
- $forum_selected = get_id_ary($var);
- if (in_array($all_forums, $forum_selected))
- {
- $forum_selected = array($all_forums);
- }
- $forum_csv = join(',', $forum_selected);
- $url = ($forum_csv != $def_forums) ? url_arg($url, $forum_key, $forum_csv) : $url;
- }
- // Topic
- $topic_selected = null;
- $topic_csv = '';
- if ($var =& $_REQUEST[$topic_key])
- {
- $topic_selected = get_id_ary($var);
- $topic_csv = join(',', $topic_selected);
- $url = ($topic_csv) ? url_arg($url, $topic_key, $topic_csv) : $url;
- }
- // Order
- $order_val = 'log_time';
- // Sort
- $sort_val = $def_sort;
- if ($var =& $_REQUEST[$sort_key] AND $var != $def_sort)
- {
- $sort_val = ($var == $sort_asc) ? $sort_asc : $sort_desc;
- $url = url_arg($url, $sort_key, $sort_val);
- }
- // Time
- $datetime_val = $def_datetime;
- $daysback_val = $def_days;
- if ($var =& $_REQUEST[$daysback_key] AND $var != $def_days)
- {
- $daysback_val = max(intval($var), 1);
- $url = url_arg($url, $daysback_key, $daysback_val);
- }
- if ($var =& $_REQUEST[$datetime_key] AND $var != $def_datetime)
- {
- $tz = TIMENOW + (3600 * $bb_cfg['board_timezone']);
- if (($tmp_timestamp = strtotime($var, $tz)) > 0)
- {
- $datetime_val = $tmp_timestamp;
- $url = url_arg($url, $datetime_key, date($dt_format, $datetime_val));
- }
- }
- $time_end_val = 86400 + mktime(0, 0, 0, date('m', $datetime_val), date('d', $datetime_val), date('Y', $datetime_val));
- $time_start_val = $time_end_val - 86400*$daysback_val;
- // First log time
- $row = DB()->fetch_row("SELECT MIN(log_time) AS first_log_time FROM ". BB_LOG);
- $first_log_time = (int) $row['first_log_time'];
- // Title match
- $title_match_val = $title_match_sql = '';
- if ($var =& $_REQUEST[$title_match_key])
- {
- if ($tmp_title_match = substr(urldecode(trim($var)), 0, $title_match_max_len))
- {
- $title_match_sql = DB()->escape($tmp_title_match);
- $url = url_arg($url, $title_match_key, urlencode($tmp_title_match));
- }
- }
- //
- // SQL
- //
- $select = "SELECT *";
- $from = "FROM ". BB_LOG;
- $where = "
- WHERE log_time BETWEEN $time_start_val AND $time_end_val
- ";
- $where .= ($type_csv) ? "
- AND log_type_id IN($type_csv)
- " : '';
- $where .= ($user_csv) ? "
- AND log_user_id IN($user_csv)
- " : '';
- $where .= ($forum_csv) ? "
- AND log_forum_id IN($forum_csv)
- " : '';
- $where .= ($topic_csv) ? "
- AND log_topic_id IN($topic_csv)
- " : '';
- $where .= ($title_match_sql) ? "
- AND MATCH (log_topic_title) AGAINST ('$title_match_sql' IN BOOLEAN MODE)
- " : '';
- $order = "ORDER BY $order_val";
- $sort = $sort_val;
- $limit = "LIMIT $start, ". ($per_page + 1);
- $sql = "
- $select
- $from
- $where
- $order
- $sort
- $limit
- ";
- $log_rowset = DB()->fetch_rowset($sql);
- $log_count = count($log_rowset);
- if ($log_count == $per_page + 1)
- {
- $items_count = $start + ($per_page * 2);
- $pages = '?';
- array_pop($log_rowset);
- }
- else
- {
- $items_count = $start + $log_count;
- $pages = (!$log_count) ? 1 : ceil($items_count / $per_page);
- }
- generate_pagination($url, $items_count, $per_page, $start);
- $filter = array();
- if ($log_rowset)
- {
- $log_type = $log_action->log_type;
- $log_type_flip = array_flip($log_type);
- foreach ($log_rowset as $row_num => $row)
- {
- $msg = '';
- $forum_name = $forum_name_new = '';
- $topic_title = $topic_title_new = '';
- $topic_deleted = ($row['log_type_id'] == $log_type['mod_topic_delete']);
- switch ($row['log_type_id'])
- {
- case $log_type['mod_topic_delete']:
- case $log_type['mod_topic_move']:
- case $log_type['mod_topic_lock']:
- case $log_type['mod_topic_unlock']:
- case $log_type['mod_post_delete']:
- case $log_type['mod_topic_split']:
- // topic_title
- if (!empty($row['log_topic_title']))
- {
- $topic_title = $row['log_topic_title'];
- }
- // topic_title_new
- if (!empty($row['log_topic_title_new']))
- {
- $topic_title_new = $row['log_topic_title_new'];
- }
- // forum_name
- if ($fid =& $row['log_forum_id'])
- {
- $forum_name = ($fname =& $f_data[$fid]['forum_name']) ? $fname : 'id:'. $row['log_forum_id'];
- }
- // forum_name_new
- if ($fid =& $row['log_forum_id_new'])
- {
- $forum_name_new = ($fname =& $f_data[$fid]['forum_name']) ? $fname : 'id:'. $row['log_forum_id'];
- }
- break;
- }
- $msg .= " $row[log_msg]";
- $row_class = !($row_num & 1) ? $row_class_1 : $row_class_2;
- $datetime_href_s = url_arg($url, $datetime_key, date($dt_format, $row['log_time']));
- $datetime_href_s = url_arg($datetime_href_s, $daysback_key, 1);
- $template->assign_block_vars('log', array(
- 'ACTION_DESC' => $lang['LOG_ACTION']['LOG_TYPE'][$log_type_flip[$row['log_type_id']]],
- 'ACTION_HREF_S' => url_arg($url, $type_key, $row['log_type_id']),
- 'USER_ID' => $row['log_user_id'],
- 'USERNAME' => $row['log_username'],
- 'USER_HREF_S' => url_arg($url, $user_key, $row['log_user_id']),
- 'USER_IP' => decode_ip($row['log_user_ip']),
- 'FORUM_ID' => $row['log_forum_id'],
- 'FORUM_HREF' => BB_ROOT . FORUM_URL . $row['log_forum_id'],
- 'FORUM_HREF_S' => url_arg($url, $forum_key, $row['log_forum_id']),
- 'FORUM_NAME' => htmlCHR($forum_name),
- 'FORUM_ID_NEW' => $row['log_forum_id_new'],
- 'FORUM_HREF_NEW' => BB_ROOT . FORUM_URL . $row['log_forum_id_new'],
- 'FORUM_HREF_NEW_S' => url_arg($url, $forum_key, $row['log_forum_id_new']),
- 'FORUM_NAME_NEW' => htmlCHR($forum_name_new),
- 'TOPIC_ID' => $row['log_topic_id'],
- 'TOPIC_HREF' => (!$topic_deleted) ? BB_ROOT . TOPIC_URL . $row['log_topic_id'] : '',
- 'TOPIC_HREF_S' => url_arg($url, $topic_key, $row['log_topic_id']),
- 'TOPIC_TITLE' => $topic_title,
- 'TOPIC_ID_NEW' => $row['log_topic_id_new'],
- 'TOPIC_HREF_NEW' => BB_ROOT . TOPIC_URL . $row['log_topic_id_new'],
- 'TOPIC_HREF_NEW_S' => url_arg($url, $topic_key, $row['log_topic_id_new']),
- 'TOPIC_TITLE_NEW' => $topic_title_new,
- 'DATE' => bb_date($row['log_time'], 'j-M'),
- 'TIME' => bb_date($row['log_time'], 'H:i'),
- 'DATETIME_HREF_S' => $datetime_href_s,
- 'MSG' => $msg,
- 'ROW_CLASS' => $row_class,
- ));
- // Topics
- if ($topic_csv && empty($filter['topics'][$row['log_topic_title']]))
- {
- $template->assign_block_vars('topics', array(
- 'TOPIC_TITLE' => $row['log_topic_title'],
- ));
- $filter['topics'][$row['log_topic_title']] = true;
- }
- // Forums
- if ($forum_csv && empty($filter['forums'][$forum_name]))
- {
- $template->assign_block_vars('forums', array(
- 'FORUM_NAME' => htmlCHR($forum_name),
- ));
- $filter['forums'][$forum_name] = true;
- }
- // Users
- if ($user_csv && empty($filter['users'][$row['log_username']]))
- {
- $template->assign_block_vars('users', array(
- 'USERNAME' => $row['log_username'],
- ));
- $filter['users'][$row['log_username']] = true;
- }
- }
- $template->assign_vars(array(
- 'FILTERS' => ($topic_csv || $forum_csv || $user_csv),
- 'FILTER_TOPICS' => !empty($filter['topics']),
- 'FILTER_FORUMS' => !empty($filter['forums']),
- 'FILTER_USERS' => !empty($filter['users']),
- ));
- }
- else
- {
- $template->assign_block_vars('log_not_found', array());
- }
- //
- // Selects
- //
- $log_type_select = array($lang['ACTS_LOG_ALL_ACTIONS'] => $all_types) + $log_action->log_type_select;
- // Order select
- $order_options = '<option value=""> '.$lang['ACTS_LOG_TIME'].' </option>';
- $template->assign_vars(array(
- 'LOG_COLSPAN' => 4,
- 'DATETIME_NAME' => $datetime_key,
- 'DATETIME_VAL' => date('Y-m-d', $datetime_val),
- 'DAYSBACK_NAME' => $daysback_key,
- 'DAYSBACK_VAL' => $daysback_val,
- 'FIRST_LOG_TIME' => ($first_log_time) ? date('Y-m-d', $first_log_time) : $lang['ACC_NONE'],
- 'TITLE_MATCH_MAX' => $title_match_max_len,
- 'TITLE_MATCH_NAME' => $title_match_key,
- 'TITLE_MATCH_VAL' => $title_match_val,
- 'ORDER_NAME' => '',
- 'ORDER_OPTIONS' => $order_options,
- 'SORT_NAME' => $sort_key,
- 'SORT_ASC' => $sort_asc,
- 'SORT_DESC' => $sort_desc,
- 'SORT_ASC_CHECKED' => ($sort_val == $sort_asc) ? HTML_CHECKED : '',
- 'SORT_DESC_CHECKED' => ($sort_val == $sort_desc) ? HTML_CHECKED : '',
- 'SEL_FORUM' => get_forum_select('admin', "{$forum_key}[]", $forum_selected, $max_forum_name_len, $select_max_height, '', $all_forums),
- 'SEL_LOG_TYPE' => build_select("{$type_key}[]", $log_type_select, $type_selected, 60, $select_max_height),
- 'SEL_USERS' => build_select("{$user_key}[]", $users, $user_selected, 16, $select_max_height),
- 'S_LOG_ACTION' => "admin_log.php",
- 'TOPIC_CSV' => $topic_csv,
- ));
- print_page('admin_log.tpl', 'admin');