+ 'title' => 'ACP_ATTACHMENTS',

+ $this->page_title = 'ACP_BBCODES';

+ 'title' => 'ACP_JABBER_SETTINGS',

+<?php

+/**

+*

+* @package acp

+* @version $Id$

+* @copyright (c) 2005 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* @package acp

+*/

+class acp_logs

+{

+ function main($id, $mode)

+ {

+ global $db, $user, $auth, $template, $cache;

+ global $config, $SID, $phpbb_root_path, $phpbb_admin_path, $phpEx;

+

+ $user->add_lang('mcp');

+

+ // Set up general vars

+ $action = request_var('action', '');

+ $forum_id = request_var('f', 0);

+ $start = request_var('start', 0);

+ $deletemark = (isset($_POST['delmarked'])) ? true : false;

+ $deleteall = (isset($_POST['delall'])) ? true : false;

+ $marked = request_var('mark', array(0));

+

+ // Sort keys

+ $sort_days = request_var('st', 0);

+ $sort_key = request_var('sk', 't');

+ $sort_dir = request_var('sd', 'd');

+

+ $this->tpl_name = 'acp_logs';

+ $this->log_type = constant('LOG_' . strtoupper($mode));

+

+ $u_action = "{$phpbb_admin_path}index.$phpEx$SID&amp;i=$id&amp;mode=$mode";

+

+ // Delete entries if requested and able

+ if (($deletemark || $deleteall) && $auth->acl_get('a_clearlogs'))

+ {

+ $where_sql = '';

+ if ($deletemark && $marked)

+ {

+ $sql_in = array();

+ foreach ($marked as $mark)

+ {

+ $sql_in[] = $mark;

+ }

+ $where_sql = ' AND log_id IN (' . implode(', ', $sql_in) . ')';

+ unset($sql_in);

+ }

+

+ if ($where_sql)

+ {

+ $sql = 'DELETE FROM ' . LOG_TABLE . "

+ WHERE log_type = {$this->log_type}

+ $where_sql";

+ $db->sql_query($sql);

+

+ add_log('admin', 'LOG_' . strtoupper($mode) . '_CLEAR');

+ }

+ }

+

+ // Sorting

+ $limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 364 => $user->lang['1_YEAR']);

+ $sort_by_text = array('u' => $user->lang['SORT_USERNAME'], 't' => $user->lang['SORT_DATE'], 'i' => $user->lang['SORT_IP'], 'o' => $user->lang['SORT_ACTION']);

+ $sort_by_sql = array('u' => 'l.user_id', 't' => 'l.log_time', 'i' => 'l.log_ip', 'o' => 'l.log_operation');

+

+ $s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';

+ 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);

+

+ // Define where and sort sql for use in displaying logs

+ $sql_where = ($sort_days) ? (time() - ($sort_days * 86400)) : 0;

+ $sql_sort = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');

+

+ $l_title = $user->lang['ACP_' . strtoupper($mode) . '_LOGS'];

+ $l_title_explain = $user->lang['ACP_' . strtoupper($mode) . '_LOGS_EXPLAIN'];

+

+ $this->page_title = $l_title;

+

+ // Define forum list if we're looking @ mod logs

+ if ($mode == 'mod')

+ {

+ $forum_box = '<option value="0">' . $user->lang['ALL_FORUMS'] . '</option>' . make_forum_select($forum_id);

+

+ $template->assign_vars(array(

+ 'S_SHOW_FORUMS' => true,

+ 'S_FORUM_BOX' => $forum_box)

+ );

+ }

+

+ // Grab log data

+ $log_data = array();

+ $log_count = 0;

+ view_log($mode, $log_data, $log_count, $config['topics_per_page'], $start, $forum_id, 0, 0, $sql_where, $sql_sort);

+

+ $template->assign_vars(array(

+ 'L_TITLE' => $l_title,

+ 'L_EXPLAIN' => $l_title_explain,

+ 'U_ACTION' => $u_action,

+

+ 'S_ON_PAGE' => on_page($log_count, $config['topics_per_page'], $start),

+ 'PAGINATION' => generate_pagination($u_action . "&amp;$u_sort_param", $log_count, $config['topics_per_page'], $start, true),

+

+ 'S_LIMIT_DAYS' => $s_limit_days,

+ 'S_SORT_KEY' => $s_sort_key,

+ 'S_SORT_DIR' => $s_sort_dir,

+ 'S_CLEARLOGS' => $auth->acl_get('a_clearlogs'),

+

+ )

+ );

+

+ foreach ($log_data as $row)

+ {

+ $data = array();

+

+ foreach (array('viewtopic', 'viewlogs', 'viewforum') as $check)

+ {

+ if (isset($row[$check]) && $row[$check])

+ {

+ $data[] = '<a href="' . $row[$check] . '">' . $user->lang['LOGVIEW_' . strtoupper($check)] . '</a>';

+ }

+ }

+

+ $template->assign_block_vars('log', array(

+ 'USERNAME' => $row['username'],

+ 'IP' => $row['ip'],

+ 'DATE' => $user->format_date($row['time']),

+ 'ACTION' => $row['action'],

+ 'DATA' => (sizeof($data)) ? implode(' | ', $data) : '',

+ 'ID' => $row['id'],

+ )

+ );

+ }

+ }

+}

+

+/**

+* @package module_install

+*/

+class acp_logs_info

+{

+ function module()

+ {

+ return array(

+ 'filename' => 'acp_logs',

+ 'title' => 'ACP_LOGGING',

+ 'version' => '1.0.0',

+ 'modes' => array(

+ 'admin' => array('title' => 'ACP_ADMIN_LOGS', 'auth' => 'acl_a_'),

+ 'mod' => array('title' => 'ACP_MOD_LOGS', 'auth' => 'acl_a_'),

+ 'critical' => array('title' => 'ACP_CRITICAL_LOGS', 'auth' => 'acl_a_'),

+ ),

+ );

+ }

+

+ function install()

+ {

+ }

+

+ function uninstall()

+ {

+ }

+}

+

+?> \ No newline at end of file

+ FROM ' . MODULES_TABLE . ' m1

+ LEFT JOIN ' . MODULES_TABLE . " m2 ON ($condition)

+* Compatible with:

+* MySQL 4.0+

+* MySQL 4.1+

+* MySQL 5.0+

+* mysqli-extension has to be compiled with:

+* MySQL 4.1+ or MySQL 5.0+

+ if (strpos($query, 'SELECT') === 0 && strpos($query, 'FROM (') !== false)

+ {

+ $query = preg_replace('#FROM \((.+)\) #', 'FROM \1 ', $query);

+ }

+

+function get_forum_list($acl_list = 'f_list', $id_only = true, $postable_only = false, $no_cache = false)

+function get_forum_branch($forum_id, $type = 'all', $order = 'descending', $include_forum = true)

+ FROM ' . FORUMS_TABLE . ' f1

+ LEFT JOIN ' . FORUMS_TABLE . " f2 ON ($condition)

+function delete_topics($where_type, $where_ids, $auto_sync = true)

+function delete_posts($where_type, $where_ids, $auto_sync = true)

+function delete_attachments($mode, $ids, $resync = true)

+function delete_topic_shadows($max_age, $forum_id = '', $auto_sync = true)

+ sync('forum', $where_type, $forum_id, true);

+function sync($mode, $where_type = '', $where_ids = '', $resync_parents = false, $sync_extra = false)

+ else if ($where_type != 'range')

+ else if ($where_type == 'range')

+ delete_posts('topic_id', array_keys($delete_posts), false);

+ delete_topics($where_type, $where_ids, true);

+ delete_topics('topic_id', $delete_topic_ids, false);

+ // except when we're only syncing a range, we don't want to sync forums during

+ // batch processing.

+ sync('forum', 'forum_id', $resync_forums, true);

+ // this is faster than calling sizeof($oktens) every time thru the loop.

+ for ($i = 0, $token_count = sizeof($tokens); $i < $token_count; $i++)

+ $sql_from = FORUMS_TABLE . ' f LEFT JOIN ' . FORUMS_TRACK_TABLE . ' ft ON (ft.user_id = ' . $user->data['user_id'] . ' AND ft.forum_id = f.forum_id)';

+ if (!isset($this->module->page_title))

+ {

+ return '';

+ }

+

+ FROM (' . REPORTS_TABLE . ' r, ' . REASONS_TABLE . ' rr,' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . USERS_TABLE . ' u)

+ LEFT JOIN ' . FORUMS_TABLE . ' f ON (f.forum_id = p.forum_id)

+ 'url' => array('bbcode_id' => 3, 'regexp' => array('#\[url(=(.*))?\](.*)\[/url\]#iUe' => "\$this->validate_url('\$2', '\$3')")),

+ else if (preg_match('#list(=?(?:[0-9]|[a-z]|))#i', $buffer, $m))

+ else if (preg_match('#^quote(?:=&quot;(.*?)&quot;)?$#is', $buffer, $m))

+ else if (preg_match('#^quote=&quot;(.*?)#is', $buffer, $m))

+ LEFT JOIN ' . SEARCH_MATCH_TABLE . ' m ON (w.word_id = m.word_id)

+ $sql_join = ' LEFT JOIN ' . FORUMS_TRACK_TABLE . ' ft ON (ft.user_id = ' . $user->data['user_id'] . ' AND ft.forum_id = f.forum_id)';

+ $sql_join = '';

+ FROM (" . FORUMS_TABLE . ' f, ' . FORUMS_WATCH_TABLE . " fw)

+ $sql_join

+ WHERE fw.user_id = " . $user->data['user_id'] . '

+ $sql_join = ($config['load_db_lastread']) ? ' LEFT JOIN ' . FORUMS_TRACK_TABLE . ' ft ON (ft.forum_id = t.forum_id AND ft.user_id = ' . $user->data['user_id'] . ')' : '';

+ $sql_join .= ' LEFT JOIN ' . TOPICS_POSTED_TABLE . ' tp ON (tp.topic_id = t.topic_id

+ $sql_join .= ' LEFT JOIN ' . TOPICS_TRACK_TABLE . ' tt ON (tt.topic_id = t.topic_id

+ FROM (" . TOPICS_TABLE . ' t, ' . TOPICS_WATCH_TABLE . " tw

+ $sql_join

+ WHERE tw.user_id = " . $user->data['user_id'] . '

+ LEFT JOIN ' . TOPICS_TABLE . ' t ON (b.topic_id = t.topic_id)

+ LEFT JOIN ' . FORUMS_TABLE . ' f ON (t.forum_id = f.forum_id)