/** * Display the output for this extension * * @return null * @access public */ public function display_output() { // Add the language file $this->language->add_lang('acp_activesessions', 'david63/activesessions'); // Start initial var setup $action = $this->request->variable('action', ''); $start = $this->request->variable('start', 0); $fc = $this->request->variable('fc', ''); $sort_key = $this->request->variable('sk', 's'); $sd = $sort_dir = $this->request->variable('sd', 'd'); $sort_dir = $sort_dir == 'd' ? ' DESC' : ' ASC'; $order_ary = array('i' => 's.session_ip' . $sort_dir . ', u.username_clean ASC', 's' => 's.session_start' . $sort_dir . ', u.username_clean ASC', 'u' => 'u.username_clean' . $sort_dir); $filter_by = ''; if ($fc == 'other') { for ($i = ord($this->language->lang('START_CHARACTER')); $i <= ord($this->language->lang('END_CHARACTER')); $i++) { $filter_by .= ' AND u.username_clean ' . $this->db->sql_not_like_expression(utf8_clean_string(chr($i)) . $this->db->get_any_char()); } } else { if ($fc) { $filter_by .= ' AND u.username_clean ' . $this->db->sql_like_expression(utf8_clean_string(substr($fc, 0, 1)) . $this->db->get_any_char()); } } $sql = $this->db->sql_build_query('SELECT', array('SELECT' => 'u.user_id, u.username, u.username_clean, u.user_colour, s.*, f.forum_id, f.forum_name', 'FROM' => array(USERS_TABLE => 'u', SESSIONS_TABLE => 's'), 'LEFT_JOIN' => array(array('FROM' => array(FORUMS_TABLE => 'f'), 'ON' => 's.session_forum_id = f.forum_id')), 'WHERE' => 'u.user_id = s.session_user_id AND s.session_time >= ' . (time() - $this->config['session_length'] * 60) . $filter_by, 'ORDER_BY' => $sort_key == '' ? 'u.username_clean' : $order_ary[$sort_key])); $result = $this->db->sql_query_limit($sql, $this->config['topics_per_page'], $start); while ($row = $this->db->sql_fetchrow($result)) { $this->template->assign_block_vars('active_sessions', array('ADMIN' => $row['session_admin'] ? $this->language->lang('YES') : $this->language->lang('NO'), 'AUTO_LOGIN' => $row['session_autologin'] ? $this->language->lang('YES') : $this->language->lang('NO'), 'BROWSER' => $row['session_browser'], 'FORUM' => $row['forum_id'] > 0 ? $row['forum_name'] : '', 'LAST_VISIT' => $this->user->format_date($row['session_last_visit']), 'SESSION_FORWARD' => $row['session_forwarded_for'], 'SESSION_ID' => $row['session_id'], 'SESSION_IP' => $row['session_ip'], 'SESSION_KEY' => $row['session_id'] . $row['user_id'], 'SESSION_ONLINE' => $row['session_viewonline'] ? $this->language->lang('YES') : $this->language->lang('NO'), 'SESSION_PAGE' => $row['session_page'], 'SESSION_START' => $this->user->format_date($row['session_start']), 'SESSION_TIME' => $this->user->format_date($row['session_time']), 'USERNAME' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']))); } $this->db->sql_freeresult($result); $sort_by_text = array('u' => $this->language->lang('SORT_USERNAME'), 'i' => $this->language->lang('SESSION_IP'), 's' => $this->language->lang('SESSION_START')); $limit_days = array(); $s_sort_key = $s_limit_days = $s_sort_dir = $u_sort_param = ''; gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sd, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param); // Get total session count for output $sql = $this->db->sql_build_query('SELECT', array('SELECT' => 'COUNT(s.session_id) AS total_sessions', 'FROM' => array(USERS_TABLE => 'u', SESSIONS_TABLE => 's'), 'WHERE' => 'u.user_id = s.session_user_id' . $filter_by)); $result = $this->db->sql_query($sql); $session_count = (int) $this->db->sql_fetchfield('total_sessions'); $this->db->sql_freeresult($result); $action = "{$this->u_action}&sk={$sort_key}&sd={$sd}"; $link = $session_count ? adm_back_link($action . '&start=' . $start) : ''; if ($session_count == 0) { trigger_error($this->language->lang('NO_SESSION_DATA') . $link); } $start = $this->pagination->validate_start($start, $this->config['topics_per_page'], $session_count); $this->pagination->generate_template_pagination($action, 'pagination', 'start', $session_count, $this->config['topics_per_page'], $start); $first_characters = array(); $first_characters[''] = $this->language->lang('ALL'); for ($i = ord($this->language->lang('START_CHARACTER')); $i <= ord($this->language->lang('END_CHARACTER')); $i++) { $first_characters[chr($i)] = chr($i); } $first_characters['other'] = $this->language->lang('OTHER'); foreach ($first_characters as $char => $desc) { $this->template->assign_block_vars('first_char', array('DESC' => $desc, 'U_SORT' => $action . '&fc=' . $char)); } $this->template->assign_vars(array('ACTIVE_SESSIONS_VERSION' => ext::ACTIVE_SESSIONS_VERSION, 'S_SORT_DIR' => $s_sort_dir, 'S_SORT_KEY' => $s_sort_key, 'TOTAL_USERS' => $this->language->lang('TOTAL_SESSIONS', (int) $session_count), 'U_ACTION' => $action)); }
public function add_page_header_links($event) { if (!empty($this->config['allow_visits_counter'])) { $this->language->add_lang('common', 'dmzx/counter'); $sql = 'SELECT COUNT(*) AS visits_counter FROM ' . $this->visits_counter_table . ' WHERE ' . $this->db->sql_in_set('uvc_ip', $this->user->ip); $result = $this->db->sql_query($sql); $visits_counter = (int) $this->db->sql_fetchfield('visits_counter'); $this->db->sql_freeresult($result); $visits = $this->config['visits_counter']; if ($visits_counter == 0) { $sql_ary = array('uvc_ip' => $this->user->ip, 'uvc_timestamp' => time()); $sql = 'INSERT INTO ' . $this->visits_counter_table . ' ' . $this->db->sql_build_array('INSERT', $sql_ary); $this->db->sql_query($sql); $this->config->increment('visits_counter', 1, true); } else { $sql_ary = array('uvc_timestamp' => time()); $sql = 'UPDATE ' . $this->visits_counter_table . ' SET ' . $this->db->sql_build_array('UPDATE', $sql_ary) . ' WHERE ' . $this->db->sql_in_set('uvc_ip', $this->user->ip); $this->db->sql_query($sql); } $timestamp = time() - 3600 * 24; $sql_ary = array($timestamp); $sql = 'DELETE FROM ' . $this->visits_counter_table . ' WHERE uvc_timestamp < ' . $timestamp; $this->db->sql_query($sql); $sql = 'SELECT COUNT(*) AS num_del FROM ' . $this->visits_counter_table . ' '; $result = $this->db->sql_query($sql); $visitsok = (int) $this->db->sql_fetchfield('num_del'); $this->template->assign_vars(array('UNIQUE_VISITS_COUNTER' => $this->language->lang('UNIQUE_VISITS_COUNTER', $visitsok))); } }
protected function get_filetypes() { $filetypes = array(); if (@extension_loaded('zlib')) { $filetypes['gzip'] = $this->language->lang(['FILETYPE', 'gzip']); } if (@extension_loaded('bz2')) { $filetypes['bzip2'] = $this->language->lang(['FILETYPE', 'bzip2']); } $filetypes['text'] = $this->language->lang(['FILETYPE', 'text']); foreach ($filetypes as $filetype => $value) { $this->template->assign_block_vars('filetypes', array('FILETYPE' => $filetype, 'VALUE' => $value, 'S_CHECKED' => $this->config['auto_db_backup_filetype'] == $filetype ? true : false)); } }
/** * Display the output for this extension * * @return null * @access public */ public function display_output() { // Add the language file $this->language->add_lang('acp_pmmonitor', 'david63/pmmonitor'); // Check that the user has permission to access here if (!$this->auth->acl_get('a_comms_pm_manage')) { trigger_error('NOT_AUTHORISED', E_USER_WARNING); } // Get message count $sql = 'SELECT COUNT(msg_id) AS total_msg FROM ' . PRIVMSGS_TO_TABLE; $result = $this->db->sql_query($sql); $total_msg = (int) $this->db->sql_fetchfield('total_msg'); $this->db->sql_freeresult($result); // If no data then no point going any further if ($total_msg == 0) { trigger_error($this->language->lang('NO_PM_DATA')); } // Start initial var setup $start = $this->request->variable('start', 0); $sort_key = $this->request->variable('sk', 'd'); $sd = $sort_dir = $this->request->variable('sd', 'd'); if ($this->request->is_set_post('delete')) { $pm_monitor_list = $this->request->variable('mark', array('')); if (!sizeof($pm_monitor_list)) { trigger_error($this->language->lang('NO_PM_SELECTED') . adm_back_link($this->u_action)); } if (confirm_box(true)) { // Restore the array to its correct format $pm_monitor_list = str_replace("'", '"', $pm_monitor_list); foreach ($pm_monitor_list as $pm_msg_list) { $pm_list[] = json_decode($pm_msg_list); } if (!function_exists('delete_pm')) { include $this->phpbb_root_path . 'includes/functions_privmsgs.' . $this->phpEx; } foreach ($pm_list as $row) { delete_pm($row['user_id'], $row['msg_ids'], $row['folder_id']); } // Add option settings change action to the admin log $phpbb_log = $this->container->get('log'); $phpbb_log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_PM_MONITOR'); } else { confirm_box(false, $this->language->lang('CONFIRM_DELETE'), build_hidden_fields(array('mark' => $pm_monitor_list, 'delete' => 'delete'))); } } $sort_dir = $sort_dir == 'd' ? ' DESC' : ' ASC'; switch ($sort_key) { case 'b': $order_by = 'u.username_clean' . $sort_dir; $order_sql = ' AND t.user_id = u.user_id '; break; case 'd': $order_by = 'p.message_time' . $sort_dir; $order_sql = ' AND t.user_id = u.user_id '; break; case 'f': $order_by = 'u.username_clean' . $sort_dir; $order_sql = ' AND t.author_id = u.user_id '; break; case 'i': $order_by = 'p.author_ip' . $sort_dir . ', u.username_clean ASC'; $order_sql = ' AND t.user_id = u.user_id '; break; case 'p': $order_by = 't.folder_id' . $sort_dir . ', u.username_clean ASC'; $order_sql = ' AND t.user_id = u.user_id '; break; case 't': $order_by = 'to_username' . $sort_dir; $order_sql = ' AND t.user_id = u.user_id '; break; } $pm_box_ary = array(PRIVMSGS_HOLD_BOX => $this->language->lang('PM_HOLDBOX'), PRIVMSGS_NO_BOX => $this->language->lang('PM_NOBOX'), PRIVMSGS_OUTBOX => $this->language->lang('PM_OUTBOX'), PRIVMSGS_SENTBOX => $this->language->lang('PM_SENTBOX'), PRIVMSGS_INBOX => $this->language->lang('PM_INBOX')); $flags = ($this->config['auth_bbcode_pm'] ? OPTION_FLAG_BBCODE : 0) + ($this->config['auth_smilies_pm'] ? OPTION_FLAG_SMILIES : 0) + ($this->config['allow_post_links'] ? OPTION_FLAG_LINKS : 0); $sql = 'SELECT p.msg_id, p.message_subject, p.message_text, p.bbcode_uid, p.bbcode_bitfield, p.message_time, p.bcc_address, p.to_address, p.author_ip, t.user_id, t.author_id, t.folder_id, LOWER(u.username) AS to_username FROM ' . PRIVMSGS_TABLE . ' p, ' . PRIVMSGS_TO_TABLE . ' t, ' . USERS_TABLE . ' u WHERE p.msg_id = t.msg_id ' . $order_sql . ' ORDER BY ' . $order_by; $result = $this->db->sql_query_limit($sql, $this->config['topics_per_page'], $start); while ($row = $this->db->sql_fetchrow($result)) { $this->template->assign_block_vars('pm_row', array('AUTHOR_IP' => $row['author_ip'], 'BCC' => $row['bcc_address'] ? $this->get_msg_user_data($row['user_id'], $row['author_id']) : '', 'DATE' => $this->user->format_date($row['message_time']), 'FOLDER' => $row['folder_id'] > PRIVMSGS_INBOX ? $this->language->lang('PM_SAVED') : $pm_box_ary[$row['folder_id']], 'FROM' => $this->get_msg_user_data($row['author_id']), 'IS_GROUP' => strstr($row['to_address'], 'g') ? $this->language->lang('IS_GROUP') : '', 'LAST_VISIT_FROM' => $this->get_last_visit($row['author_id']), 'LAST_VISIT_TO' => $row['to_address'] ? $this->get_last_visit($row['user_id'], $row['author_id']) : '', 'PM_ID' => str_replace('"', "'", json_encode(array('msg_ids' => $row['msg_id'], 'user_id' => $row['user_id'], 'folder_id' => $row['folder_id']))), 'PM_KEY' => $row['msg_id'] . $row['user_id'], 'PM_SUBJECT' => $row['message_subject'], 'PM_TEXT' => generate_text_for_display($row['message_text'], $row['bbcode_uid'], $row['bbcode_bitfield'], $flags), 'TO' => $row['to_address'] ? $this->get_msg_user_data($row['user_id'], $row['author_id']) : '')); } $this->db->sql_freeresult($result); $sort_by_text = array('f' => $this->language->lang('SORT_FROM'), 't' => $this->language->lang('SORT_TO'), 'b' => $this->language->lang('SORT_BCC'), 'p' => $this->language->lang('SORT_PM_BOX'), 'i' => $this->language->lang('SORT_IP'), 'd' => $this->language->lang('SORT_DATE')); $limit_days = array(); $s_sort_key = $s_limit_days = $s_sort_dir = $u_sort_param = ''; gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sd, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param); $action = $this->u_action . '&sk=' . $sort_key . '&sd=' . $sd; $this->pagination->generate_template_pagination($action, 'pagination', 'start', $total_msg, $this->config['topics_per_page'], $start); $this->template->assign_vars(array('MESSAGE_COUNT' => $total_msg, 'PM_MONITOR_VERSION' => ext::PM_MONITOR_VERSION, 'S_CAN_READ' => $this->auth->acl_get('a_comms_pm_manage') ? true : false, 'S_SORT_KEY' => $s_sort_key, 'S_SORT_DIR' => $s_sort_dir, 'U_ACTION' => $this->u_action . '&action=delete')); }
/** * Display the output for this extension * * @return null * @access public */ public function display_output() { // Check that the user has permission to access here if (!$this->auth->acl_get('a_comms_pm_stats')) { trigger_error('NOT_AUTHORISED', E_USER_WARNING); } // Add the language file $this->language->add_lang('acp_pmstats', 'david63/pmstats'); // Get message count $sql = 'SELECT COUNT(msg_id) AS total_msg FROM ' . PRIVMSGS_TO_TABLE; $result = $this->db->sql_query($sql); $total_msg = (int) $this->db->sql_fetchfield('total_msg'); $this->db->sql_freeresult($result); // If no data then no point going any further if ($total_msg == 0) { trigger_error($this->language->lang('NO_PM_DATA')); } // Start initial var setup $action = $this->request->variable('action', ''); $fc = $this->request->variable('fc', ''); $sort_key = $this->request->variable('sk', 't'); $start = $this->request->variable('start', 0); $sd = $sort_dir = $this->request->variable('sd', 'd'); $sort_dir = $sort_dir == 'd' ? ' DESC' : ' ASC'; $order_ary = array('d' => 'p.pm_deleted' . $sort_dir . ', u.username_clean ASC', 'f' => 'p.pm_forwarded' . $sort_dir . ', u.username_clean ASC', 'h' => 'holdbox' . $sort_dir . ', u.username_clean ASC', 'i' => 'inbox' . $sort_dir . ', u.username_clean ASC', 'm' => 'p.pm_marked' . $sort_dir . ', u.username_clean ASC', 'n' => 'p.pm_new' . $sort_dir . ', u.username_clean ASC', 'nb' => 'nobox' . $sort_dir . ', u.username_clean ASC', 't' => 'total' . $sort_dir . ', u.username_clean ASC', 'o' => 'outbox' . $sort_dir . ', u.username_clean ASC', 'r' => 'p.pm_replied' . $sort_dir . ', u.username_clean ASC', 's' => 'sentbox' . $sort_dir . ', u.username_clean ASC', 'sv' => 'savedbox' . $sort_dir . ', u.username_clean ASC', 'u' => 'u.username_clean' . $sort_dir, 'un' => 'p.pm_unread' . $sort_dir . ', u.username_clean ASC'); $filter_by = ''; if ($fc == 'other') { for ($i = ord($this->language->lang('START_CHARACTER')); $i <= ord($this->language->lang('END_CHARACTER')); $i++) { $filter_by .= ' AND u.username_clean ' . $this->db->sql_not_like_expression(utf8_clean_string(chr($i)) . $this->db->get_any_char()); } } else { if ($fc) { $filter_by .= ' AND u.username_clean ' . $this->db->sql_like_expression(utf8_clean_string(substr($fc, 0, 1)) . $this->db->get_any_char()); } } $sql = $this->db->sql_build_query('SELECT', array('SELECT' => 'u.user_id, u.username, u.username_clean, u.user_colour, p.pm_deleted, p.pm_new, p.pm_unread, p.pm_replied, p.pm_marked, p.pm_forwarded, SUM(IF(p.folder_id = ' . PRIVMSGS_INBOX . ', 1, 0)) AS inbox, SUM(IF(p.folder_id = ' . PRIVMSGS_SENTBOX . ', 1, 0)) AS sentbox, SUM(IF(p.folder_id = ' . PRIVMSGS_OUTBOX . ', 1, 0)) AS outbox, SUM(IF(p.folder_id = ' . PRIVMSGS_NO_BOX . ', 1, 0)) AS nobox, SUM(IF(p.folder_id = ' . PRIVMSGS_HOLD_BOX . ', 1, 0)) AS holdbox, SUM(IF(p.folder_id > ' . PRIVMSGS_INBOX . ', 1, 0)) AS savedbox, COUNT(p.folder_id) AS total', 'FROM' => array(USERS_TABLE => 'u'), 'LEFT_JOIN' => array(array('FROM' => array(PRIVMSGS_TO_TABLE => 'p'), 'ON' => 'u.user_id = p.user_id')), 'WHERE' => 'u.user_type <> ' . USER_IGNORE . $filter_by, 'ORDER_BY' => $sort_key == '' ? 'total DESC' : $order_ary[$sort_key], 'GROUP_BY' => 'u.username_clean')); $result = $this->db->sql_query_limit($sql, $this->config['topics_per_page'], $start); while ($row = $this->db->sql_fetchrow($result)) { $this->template->assign_block_vars('pm_statistics', array('DELETED' => (int) $row['pm_deleted'], 'FORWARDED' => (int) $row['pm_forwarded'], 'HOLDBOX' => $row['holdbox'], 'INBOX' => $row['inbox'], 'MARKED' => (int) $row['pm_marked'], 'NEW' => (int) $row['pm_new'], 'NOBOX' => $row['nobox'], 'OUTBOX' => $row['outbox'], 'REPLIED' => (int) $row['pm_replied'], 'SAVEDBOX' => $row['savedbox'], 'SENTBOX' => $row['sentbox'], 'UNREAD' => (int) $row['pm_unread'], 'USERNAME' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']), 'TOTAL' => $row['total'])); } $this->db->sql_freeresult($result); $sort_by_text = array('u' => $this->language->lang('SORT_USERNAME'), 't' => $this->language->lang('SORT_TOTAL_MESSAGES'), 'i' => $this->language->lang('SORT_INBOX'), 'n' => $this->language->lang('SORT_NEW'), 'un' => $this->language->lang('SORT_UNREAD'), 'o' => $this->language->lang('SORT_OUTBOX'), 's' => $this->language->lang('SORT_SENT'), 'sv' => $this->language->lang('SORT_SAVED'), 'h' => $this->language->lang('SORT_HOLD'), 'd' => $this->language->lang('SORT_DELETED'), 'm' => $this->language->lang('SORT_MARKED'), 'r' => $this->language->lang('SORT_REPLY'), 'f' => $this->language->lang('SORT_FORWARDED'), 'nb' => $this->language->lang('SORT_NO_BOX')); $limit_days = array(); $s_sort_key = $s_limit_days = $s_sort_dir = $u_sort_param = ''; gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sd, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param); // Get total user count for pagination $sql = 'SELECT COUNT(u.user_id) AS total_users FROM ' . USERS_TABLE . ' u WHERE u.user_type <> ' . USER_IGNORE . $filter_by; $result = $this->db->sql_query($sql); $user_count = (int) $this->db->sql_fetchfield('total_users'); $this->db->sql_freeresult($result); $action = $this->u_action . '&sk=' . $sort_key . '&sd=' . $sd; $this->pagination->generate_template_pagination($action, 'pagination', 'start', $user_count, $this->config['topics_per_page'], $start); $first_characters = array(); $first_characters[''] = $this->language->lang('ALL'); for ($i = ord($this->language->lang('START_CHARACTER')); $i <= ord($this->language->lang('END_CHARACTER')); $i++) { $first_characters[chr($i)] = chr($i); } $first_characters['other'] = $this->language->lang('OTHER'); foreach ($first_characters as $char => $desc) { $this->template->assign_block_vars('first_char', array('DESC' => $desc, 'U_SORT' => $action . '&fc=' . $char)); } $this->template->assign_vars(array('MESSAGE_COUNT' => $total_msg, 'S_SORT_DIR' => $s_sort_dir, 'S_SORT_KEY' => $s_sort_key, 'U_ACTION' => $action, 'PM_STATS_VERSION' => ext::PM_STATS_VERSION)); }