+ <!-- IF .pagination -->

+ &bull; <!-- INCLUDE pagination.html -->

+ <!-- ELSE -->

+ &bull; {S_ON_PAGE}

+ {L_NUMBER_FILES}: {TOTAL_FILES} &bull; {L_TOTAL_SIZE}: {TOTAL_SIZE}

+ <!-- IF .pagination -->

+ &bull; <!-- INCLUDE pagination.html -->

+ <!-- ELSE -->

+ &bull; {S_ON_PAGE}

+ <!-- ENDIF -->

+ <span class="down"><a href="{forums.U_MOVE_DOWN}" data-ajax="forum_down" data-overlay="false">{ICON_MOVE_DOWN}</a></span>

+ <span class="up"><a href="{forums.U_MOVE_UP}" data-ajax="forum_up" data-overlay="false">{ICON_MOVE_UP}</a></span>

+ <span class="down"><a href="{forums.U_MOVE_DOWN}" data-ajax="forum_down" data-overlay="false">{ICON_MOVE_DOWN}</a></span>

+ <span class="up"><a href="{forums.U_MOVE_UP}" data-ajax="forum_up" data-overlay="false">{ICON_MOVE_UP}</a></span>

+<div class="pagination">

+<!-- ENDIF -->

+ {L_DISPLAY_LOG}: &nbsp;{S_LIMIT_DAYS}&nbsp;{L_SORT_BY}: {S_SORT_KEY} {S_SORT_DIR}<!-- IF .pagination -->&nbsp;Users per page: <input class="inputbox autowidth" type="text" name="users_per_page" id="users_per_page" size="3" value="{USERS_PER_PAGE}" /><!-- ENDIF -->

+<!-- IF .pagination -->

+ <!-- INCLUDE pagination.html -->

+<div class="pagination" style="float: right; margin: 15px 0 2px 0">

+<!-- ENDIF -->

+<!-- IF .pagination -->

+ <!-- INCLUDE pagination.html -->

+ <legend>{L_CRITERIA}</legend>

+ <dt><label for="email">{L_WEBSITE}:</label></dt>

+ <dd><input type="text" id="website" name="website" /></dd>

+</dl>

+<dl>

+ <dd>

+ <strong>{L_AFTER}</strong> <input type="text" id="joined_after" name="joined_after" />

+ <br /> <br /> <strong>{L_BEFORE}</strong> <input type="text" id="joined_before" name="joined_before" />

+ </dd>

+ <dt><label for="posts_on_queue">{L_POSTS_ON_QUEUE}:</label></dt>

+ <dd><select name="queue_select">{S_COUNT_OPTIONS}</select> <input type="text" id="posts_on_queue" name="posts_on_queue" /></select>

+</dl>

+<!-- IF S_GROUP_LIST -->

+<dl>

+ <dt><label for="group_id">{L_GROUP}:</label><br /><span>{L_PRUNE_USERS_GROUP_EXPLAIN}</dt>

+ <dd><select name="group_id">{S_GROUP_LIST}</select></dd>

+</dl>

+<!-- ENDIF -->

+</fieldset>

+

+<fieldset>

+ <legend>{L_USERNAMES}</legend>

+<dl>

+</fieldset>

+

+<fieldset>

+ <legend>{L_OPTIONS}</legend>

+ <select id="delete_type" name="delete_type"><option class="sep" value="">{L_SELECT_OPTION}</option><option value="retain">{L_RETAIN_POSTS}</option><option value="remove">{L_DELETE_POSTS}</option></select>

+ </dd>

+ float: right;

+ float: left;

+li.pagination {

+ margin-top: 0;

+.pagination img {

+ vertical-align: middle;

+.pagination ul {

+ display: inline-block;

+ *display: inline; /* IE7 inline-block hack */

+ *zoom: 1;

+ margin-left: 0;

+ margin-bottom: 0;

+}

+

+li.pagination ul {

+ margin-top: -2px;

+ vertical-align: middle;

+}

+

+.pagination ul li, dl .pagination ul li, dl.icon .pagination ul li {

+ display: inline;

+ padding: 0;

+ font-size: 100%;

+ line-height: normal;

+.pagination li a, .pagnation li span, li .pagination li a, li .pagnation li span, .pagination li.active span, .pagination li.ellipsis span {

+ border: 1px solid transparent;

+ font-size: 0.9em;

+ line-height: 1.5em;

+.pagination li a, .pagination li a:link, .pagination li a:visited {

+ color: #5C758C;

+ background-color: #ECEDEE;

+ border-color: #B4BAC0;

+}

+

+.pagination li.ellipsis span {

+ background-color: transparent;

+ color: #000000;

+}

+

+.pagination li.active span {

+ background-color: #4692BF;

+ border-color: #4692BF;

+.pagination li a:hover, .pagination .active a:hover {

+ color: #FFFFFF;

+ background-color: #368AD2;

+ border-color: #368AD2;

+.pagination li a:active, .pagination li.active a:active {

+ color: #5C758C;

+ background-color: #ECEDEE;

+ border-color: #B4BAC0;

+}

+}

+<fieldset id="userlist">

+ <h2>{L_PRUNE_USERS_LIST}</h2>

+ <!-- IF S_DEACTIVATE --><p>{L_PRUNE_USERS_LIST_DEACTIVATE}</p><!-- ELSE --><p>{L_PRUNE_USERS_LIST_DELETE}</p><!-- ENDIF -->

+

+ <br />

+ <!-- BEGIN users -->

+ &raquo; <input type="checkbox" name="user_ids[]" value="{users.USER_ID}" checked="checked" />

+ <a href="{users.U_PROFILE}">{users.USERNAME}</a>

+ <!-- IF users.U_USER_ADMIN --> [ <a href="{users.U_USER_ADMIN}">{L_USER_ADMIN}</a> ]<!-- ENDIF --><br />

+ <!-- END users -->

+ <br />

+ <span class="small">

+ <a href="#" onclick="marklist('userlist', 'user_ids', true)">{L_MARK_ALL}</a> &bull;

+ <a href="#" onclick="marklist('userlist', 'user_ids', false)">{L_UNMARK_ALL}</a>

+ </span>

+</fieldset>

+

+$phpbb_admin_path = (defined('PHPBB_ADMIN_PATH')) ? PHPBB_ADMIN_PATH : './';

+

+$phpbb_style->set_custom_style('admin', $phpbb_admin_path . 'style', '');

+ if (overlay && (typeof $this.attr('data-overlay') === 'undefined' || $this.attr('data-overlay') == 'true'))

+ require($phpbb_root_path . 'includes/functions.' . $phpEx);

+

+ // $phpbb_root_path accounts for redirects from e.g. /adm

+ $script_path = trim(dirname($script_name)) . '/' . $phpbb_root_path . 'install/index.' . $phpEx;

+ // Eliminate . and .. from the path

+ $script_path = phpbb_clean_path($script_path);

+ - @template_context

+

+ template_context:

+ class: phpbb_template_context

+ 'report_id' => array('UINT', NULL, 'auto_increment'),

+ 'reason_id' => array('USINT', 0),

+ 'post_id' => array('UINT', 0),

+ 'pm_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'user_notify' => array('BOOL', 0),

+ 'report_closed' => array('BOOL', 0),

+ 'report_time' => array('TIMESTAMP', 0),

+ 'report_text' => array('MTEXT_UNI', ''),

+ 'reported_post_text' => array('MTEXT_UNI', ''),

+ 'reported_post_uid' => array('VCHAR:8', ''),

+ 'reported_post_bitfield' => array('VCHAR:255', ''),

+ );

+

+ self::display_ban_options($mode);

+ static public function display_ban_options($mode)

+ $factory = new phpbb_captcha_factory();

+ $captchas = $factory->get_captcha_types();

+ phpbb_generate_template_pagination($template, $base_url, 'pagination', 'start', $total_members, $config['topics_per_page'], $start);

+

+

+ phpbb_generate_template_pagination($template, $this->u_action, 'pagination', 'start', $item_count, $config['smilies_per_page'], $pagination_start);

+ user_delete('retain', $mark, true);

+ phpbb_generate_template_pagination($template, $base_url, 'pagination', 'start', $inactive_count, $per_page, $start);

+

+

+ $this->get_prune_users($user_ids, $usernames);

+ user_delete('remove', $user_ids);

+ user_delete('retain', $user_ids, true);

+ 'USER_ID' => $user_id,

+ $s_group_list = '';

+ $sql = 'SELECT group_id, group_name

+ FROM ' . GROUPS_TABLE . '

+ WHERE group_type <> ' . GROUP_SPECIAL . '

+ ORDER BY group_name ASC';

+ $result = $db->sql_query($sql);

+

+ while ($row = $db->sql_fetchrow($result))

+ {

+ $s_group_list .= '<option value="' . $row['group_id'] . '">' . $row['group_name'] . '</select>';

+ }

+ $db->sql_freeresult($result);

+

+ 'S_GROUP_LIST' => $s_group_list,

+ $users_by_name = request_var('users', '', true);

+ $users_by_id = request_var('user_ids', array(0));

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

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

+

+ if ($users_by_name)

+ $users = explode("\n", $users_by_name);

+ else if (!empty($users_by_id))

+ {

+ $user_ids = $users_by_id;

+ user_get_id_name($user_ids, $usernames);

+

+ $where_sql = ' AND ' . $db->sql_in_set('user_id', $user_ids);

+ }

+ $username = request_var('username', '', true);

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

+ $queue_select = request_var('queue_select', 'gt');

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

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

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

+

+ $joined_before = ($joined_before) ? explode('-', $joined_before) : array();

+ $joined_after = ($joined_after) ? explode('-', $joined_after) : array();

+ // calculate the conditions required by the join time criteria

+ $joined_sql = '';

+ if (!empty($joined_before) && !empty($joined_after))

+ // if the two entered dates are equal, we need to adjust

+ // so that our time range is a full day instead of 1 second

+ if ($joined_after == $joined_before)

+ {

+ $joined_after[2] += 1;

+ }

+

+ $joined_sql = ' AND user_regdate BETWEEN ' . gmmktime(0, 0, 0, (int) $joined_after[1], (int) $joined_after[2], (int) $joined_after[0]) .

+ ' AND ' . gmmktime(0, 0, 0, (int) $joined_before[1], (int) $joined_before[2], (int) $joined_before[0]);

+ else if (empty($joined_before) && !empty($joined_after))

+ {

+ $joined_sql = ' AND user_regdate > ' . gmmktime(0, 0, 0, (int) $joined_after[1], (int) $joined_after[2], (int) $joined_after[0]);

+ }

+ else if (empty($joined_after) && !empty($joined_before))

+ {

+ $joined_sql = ' AND user_regdate < ' . gmmktime(0, 0, 0, (int) $joined_before[1], (int) $joined_before[2], (int) $joined_before[0]);

+ }

+ // implicit else when both arrays are empty do nothing

+ if ((sizeof($active) && sizeof($active) != 3) || (sizeof($joined_before) && sizeof($joined_before) != 3) || (sizeof($joined_after) && sizeof($joined_after) != 3))

+ {

+ trigger_error($user->lang['WRONG_ACTIVE_JOINED_DATE'] . adm_back_link($this->u_action), E_USER_WARNING);

+ }

+ $where_sql .= ($website) ? ' AND user_website ' . $db->sql_like_expression(str_replace('*', $db->any_char, $website)) . ' ' : '';

+ $where_sql .= $joined_sql;

+ $where_sql .= ($count) ? " AND user_posts " . $key_match[$count_select] . ' ' . (int) $count . ' ' : '';

+

+ if ($group_id)

+ {

+ $sql = 'SELECT user_id

+ FROM ' . USER_GROUP_TABLE . '

+ WHERE group_id = ' . (int) $group_id . '

+ AND user_pending = 0

+ AND ' . $db->sql_in_set('user_id', $user_ids, false, true);

+ $result = $db->sql_query($sql);

+

+ // we're performing an intersection operation, so all the relevant users

+ // come from this most recent query (which was limited to the results of the

+ // previous query)

+ $user_ids = $usernames = array();

+ while ($row = $db->sql_fetchrow($result))

+ {

+ $user_ids[] = $row['poster_id'];

+ }

+ $db->sql_freeresult($result);

+

+ // only get usernames if they are needed (not part of some later query)

+ if (!$posts_on_queue)

+ {

+ // this is an additional query aginst the users table

+ user_get_id_name($user_ids, $usernames);

+ }

+ }

+

+ if ($posts_on_queue)

+ {

+ $sql = 'SELECT poster_id, COUNT(post_id) AS queue_posts

+ FROM ' . POSTS_TABLE . '

+ WHERE ' . $db->sql_in_set('poster_id', $user_ids, false, true) . '

+ GROUP BY poster_id

+ HAVING queue_posts ' . $key_match[$queue_select] . ' ' . $posts_on_queue;

+ $result = $db->sql_query($result);

+

+ // same intersection logic as the above group ID portion

+ $user_ids = $usernames = array();

+ while ($row = $db->sql_fetchrow($result))

+ {

+ $user_ids[] = $row['poster_id'];

+ }

+ $db->sql_freeresult($result);

+

+ // do an additional query to get the correct set of usernames

+ user_get_id_name($user_ids, $usernames);

+ }

+

+

+ $template = new phpbb_template($phpbb_root_path, $phpEx, $config, $user, $style_resource_locator, new phpbb_template_context());

+ static public function get_instance($name)

+ static public function get_instance()

+ static public function is_available()

+ static public function get_name()

+ static public function get_instance()

+ static public function is_available()

+ static public function get_name()

+ static public function get_instance()

+ static public function is_available()

+ static public function get_name()

+ static public function get_instance()

+ static public function is_installed()

+ static public function is_available()

+ if (!self::is_installed())

+ static public function get_name()

+ if (!self::is_installed())

+ static public function get_instance()

+ static public function is_available()

+ static public function get_name()

+ 'S_RECAPTCHA_AVAILABLE' => self::is_available(),

+ $this->extensions = array();

+

+ // Do not try to load any extensions when installing or updating

+ // Note: database updater invokes this code, and in 3.0

+ // there is no extension table therefore the rest of this function

+ // fails

+ if (defined('IN_INSTALL'))

+ {

+ return;

+ }

+

+* Provides a set of items found in extensions.

+*

+* This abstract class is essentially a wrapper around item-specific

+* finding logic. It handles storing the extension manager via constructor

+* for the finding logic to use to find the items, and provides an

+* iterator interface over the items found by the finding logic.

+*

+* Items could be anything, for example template paths or cron task names.

+* Derived classes completely define what the items are.

+ * Finds items using the extension manager.

+/**

+* Eliminates useless . and .. components from specified path.

+*

+* @param string $path Path to clean

+* @return string Cleaned path

+*/

+function phpbb_clean_path($path)

+{

+ $exploded = explode('/', $path);

+ $filtered = array();

+ foreach ($exploded as $part)

+ {

+ if ($part === '.' && !empty($filtered))

+ {

+ continue;

+ }

+

+ if ($part === '..' && !empty($filtered) && $filtered[sizeof($filtered) - 1] !== '..')

+ {

+ array_pop($filtered);

+ }

+ else

+ {

+ $filtered[] = $part;

+ }

+ }

+ $path = implode('/', $filtered);

+ return $path;

+}

+

+* @param string $mode (all, topics, topic, post)

+* @param int|bool $forum_id Used in all, topics, and topic mode

+* @param int|bool $topic_id Used in topic and post mode

+* @param int $post_time 0 means current time(), otherwise to set a specific mark time

+ $post_time = ($post_time === 0 || $post_time > time()) ? time() : (int) $post_time;

+

+ $tables = array(TOPICS_TRACK_TABLE, FORUMS_TRACK_TABLE);

+ foreach ($tables as $table)

+ {

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

+ WHERE user_id = {$user->data['user_id']}

+ AND mark_time < $post_time";

+ $db->sql_query($sql);

+ }

+

+ $sql = 'UPDATE ' . USERS_TABLE . "

+ SET user_lastmark = $post_time

+ WHERE user_id = {$user->data['user_id']}

+ AND user_lastmark < $post_time";

+ $db->sql_query($sql);

+ $tracking_topics['l'] = base_convert($post_time - $config['board_startdate'], 10, 36);

+ $user->set_cookie('track', tracking_serialize($tracking_topics), $post_time + 31536000);

+ $sql = 'UPDATE ' . USERS_TABLE . "

+ SET user_lastmark = $post_time

+ WHERE user_id = {$user->data['user_id']}

+ AND user_lastmark < $post_time";

+ $db->sql_query($sql);

+ AND mark_time < $post_time

+ AND mark_time < $post_time

+ $sql = 'UPDATE ' . FORUMS_TRACK_TABLE . "

+ SET mark_time = $post_time

+ AND mark_time < $post_time

+ 'mark_time' => $post_time,

+ $tracking['f'][$f_id] = base_convert($post_time - $config['board_startdate'], 10, 36);

+ $user->set_cookie('track', tracking_serialize($tracking), $post_time + 31536000);

+ $sql = 'UPDATE ' . TOPICS_TRACK_TABLE . "

+ SET mark_time = $post_time

+ AND mark_time < $post_time

+ 'mark_time' => $post_time,

+

+ $sql = 'UPDATE ' . USERS_TABLE . "

+ SET user_lastmark = $post_time

+ WHERE user_id = {$user->data['user_id']}

+ AND mark_time < $post_time";

+ $db->sql_query($sql);

+ $user->set_cookie('track', tracking_serialize($tracking), $post_time + 31536000);

+ 'topic_posted' => 1,

+ if ($on_page != 1)

+ 'PAGE_URL' => $base_url . $url_delim . $start_name . '=' . (($on_page - 2) * $per_page),

+ 'S_IS_PREV' => true,

+ 'S_IS_NEXT' => false,

+ if ($on_page != $total_pages)

+ 'PAGE_URL' => $base_url . $url_delim . $start_name . '=' . ($on_page * $per_page),

+ 'S_IS_PREV' => false,

+ 'S_IS_NEXT' => true,

+

+ // If the block_var_name is a nested block, we will use the last (most

+ // inner) block as a prefix for the template variables. If the last block

+ // name is pagination, the prefix is empty. If the rest of the

+ // block_var_name is not empty, we will modify the last row of that block

+ // and add our pagination items.

+ $tpl_block_name = $tpl_prefix = '';

+ if (strrpos($block_var_name, '.') !== false)

+ {

+ $tpl_block_name = substr($block_var_name, 0, strrpos($block_var_name, '.'));

+ $tpl_prefix = strtoupper(substr($block_var_name, strrpos($block_var_name, '.') + 1));

+ }

+ else

+ {

+ $tpl_prefix = strtoupper($block_var_name);

+ }

+ $tpl_prefix = ($tpl_prefix == 'PAGINATION') ? '' : $tpl_prefix . '_';

+

+ $previous_page = ($on_page != 1) ? $base_url . $url_delim . $start_name . '=' . (($on_page - 2) * $per_page) : '';

+

+ $template_array = array(

+ $tpl_prefix . 'BASE_URL' => $base_url,

+ 'A_' . $tpl_prefix . 'BASE_URL' => addslashes($base_url),

+ $tpl_prefix . 'PER_PAGE' => $per_page,

+ $tpl_prefix . 'PREVIOUS_PAGE' => $previous_page,

+ $tpl_prefix . 'PREV_PAGE' => $previous_page,

+ $tpl_prefix . 'NEXT_PAGE' => ($on_page != $total_pages) ? $base_url . $url_delim . $start_name . '=' . ($on_page * $per_page) : '',

+ $tpl_prefix . 'TOTAL_PAGES' => $total_pages,

+ $tpl_prefix . 'CURRENT_PAGE' => $on_page,

+ );

+

+ if ($tpl_block_name)

+ {

+ $template->alter_block_array($tpl_block_name, $template_array, true, 'change');

+ }

+ else

+ {

+ $template->assign_vars($template_array);

+ }

+ static public function methods()

+function generate_text_for_display($text, $uid, $bitfield, $flags, $censor_text = true)

+ $redirect = build_url(array('mark', 'hash', 'mark_time'));

+ markread('all', false, false, request_var('mark_time', 0));

+ $redirect = build_url(array('mark', 'hash', 'mark_time'));

+ markread('topics', $forum_ids, false, request_var('mark_time', 0));

+ 'U_MARK_FORUMS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'hash=' . generate_link_hash('global') . '&amp;f=' . $root_data['forum_id'] . '&amp;mark=forums&amp;mark_time=' . time()) : '',

+ $tpl = new phpbb_template($phpbb_root_path, $phpEx, $config, $user, $style_resource_locator, new phpbb_template_context());

+ $root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $phpbb_root_path;

+

+ 'ICON_IMG' => $root_path . $config['icons_path'] . '/' . $data['img'],

+function user_notification($mode, $subject, $topic_title, $forum_name, $forum_id, $topic_id, $post_id, $author_name = '')

+ 'AUTHOR_NAME' => htmlspecialchars_decode($author_name),

+ $username = ($username) ? $username : $user->data['username'];

+ user_notification($mode, $subject, $data['topic_title'], $data['forum_name'], $data['forum_id'], $data['topic_id'], $data['post_id'], $username);

+

+

+

+

+

+

+

+

+

+

+ return phpbb_delete_users_pms(array($user_id));

+}

+

+/**

+* Delete all PM(s) for given users and delete the ones without references

+*

+* @param array $user_ids IDs of the users whose private messages we want to delete

+*

+* @return boolean False if there were no pms found, true otherwise.

+*/

+function phpbb_delete_users_pms($user_ids)

+{

+ global $db, $user, $phpbb_root_path, $phpEx;

+

+ $user_id_sql = $db->sql_in_set('user_id', $user_ids);

+ $author_id_sql = $db->sql_in_set('author_id', $user_ids);

+

+ WHERE ' . $user_id_sql;

+ // Part 2: get PMs the users sent, but are yet to be received.

+ // We cannot simply delete them. First we have to check

+ WHERE ' . $author_id_sql . '

+ WHERE ' . $author_id_sql . '

+ WHERE ' . $author_id_sql . '

+ WHERE ' . $user_id_sql;

+ WHERE ' . $user_id_sql;

+ WHERE ' . $author_id_sql;

+ WHERE ' . $author_id_sql;

+* @param $mode Either 'retain' or 'remove'

+function user_delete($mode, $user_ids, $retain_username = true)

+ $db->sql_transaction('begin');

+

+ $user_rows = array();

+ if (!is_array($user_ids))

+ {

+ $user_ids = array($user_ids);

+ }

+

+ $user_id_sql = $db->sql_in_set('user_id', $user_ids);

+

+ WHERE ' . $user_id_sql;

+ while ($row = $db->sql_fetchrow($result))

+ {

+ $user_rows[(int) $row['user_id']] = $row;

+ }

+ if (empty($user_rows))

+ WHERE ' . $db->sql_in_set('r.user_id', $user_ids) . '

+ $db->sql_query('DELETE FROM ' . REPORTS_TABLE . ' WHERE ' . $user_id_sql);

+ $num_users_delta = 0;

+ // Some things need to be done in the loop (if the query changes based

+ // on which user is currently being deleted)

+ $added_guest_posts = 0;

+ foreach ($user_rows as $user_id => $user_row)

+ if ($user_row['user_avatar'] && $user_row['user_avatar_type'] == AVATAR_UPLOAD)

+ {

+ avatar_delete('user', $user_row);

+ }

+ // Decrement number of users if this user is active

+ if ($user_row['user_type'] != USER_INACTIVE && $user_row['user_type'] != USER_IGNORE)

+ {

+ --$num_users_delta;

+ }

+ switch ($mode)

+ {

+ case 'retain':

+ if ($retain_username === false)

+ {

+ $post_username = $user->lang['GUEST'];

+ }

+ else

+ {

+ $post_username = $user_row['username'];

+ }

+ // If the user is inactive and newly registered

+ // we assume no posts from the user, and save

+ // the queries

+ if ($user_row['user_type'] != USER_INACTIVE || $user_row['user_inactive_reason'] != INACTIVE_REGISTER || $user_row['user_posts'])

+ {

+ // When we delete these users and retain the posts, we must assign all the data to the guest user

+ $sql = 'UPDATE ' . FORUMS_TABLE . '

+ SET forum_last_poster_id = ' . ANONYMOUS . ", forum_last_poster_name = '" . $db->sql_escape($post_username) . "', forum_last_poster_colour = ''

+ WHERE forum_last_poster_id = $user_id";

+ $db->sql_query($sql);

+ $sql = 'UPDATE ' . POSTS_TABLE . '

+ SET poster_id = ' . ANONYMOUS . ", post_username = '" . $db->sql_escape($post_username) . "'

+ WHERE poster_id = $user_id";

+ $db->sql_query($sql);

+ $sql = 'UPDATE ' . TOPICS_TABLE . '

+ SET topic_poster = ' . ANONYMOUS . ", topic_first_poster_name = '" . $db->sql_escape($post_username) . "', topic_first_poster_colour = ''

+ WHERE topic_poster = $user_id";

+ $db->sql_query($sql);

+ $sql = 'UPDATE ' . TOPICS_TABLE . '

+ SET topic_last_poster_id = ' . ANONYMOUS . ", topic_last_poster_name = '" . $db->sql_escape($post_username) . "', topic_last_poster_colour = ''

+ WHERE topic_last_poster_id = $user_id";

+ $db->sql_query($sql);

+ // Since we change every post by this author, we need to count this amount towards the anonymous user

+ if ($user_row['user_posts'])

+ {

+ $added_guest_posts += $user_row['user_posts'];

+ }

+ break;

+ case 'remove':

+ // there is nothing variant specific to deleting posts

+ break;

+ }

+ }

+ if ($num_users_delta != 0)

+ {

+ set_config_count('num_users', $num_users_delta, true);

+ }

+ // Now do the invariant tasks

+ // all queries performed in one call of this function are in a single transaction

+ // so this is kosher

+ if ($mode == 'retain')

+ {

+ // Assign more data to the Anonymous user

+ $sql = 'UPDATE ' . ATTACHMENTS_TABLE . '

+ SET poster_id = ' . ANONYMOUS . '

+ WHERE ' . $db->sql_in_set('poster_id', $user_ids);

+ $db->sql_query($sql);

+ $sql = 'UPDATE ' . POSTS_TABLE . '

+ SET post_edit_user = ' . ANONYMOUS . '

+ WHERE ' . $db->sql_in_set('post_edit_user', $user_ids);

+ $db->sql_query($sql);

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_posts = user_posts + ' . $added_guest_posts . '

+ WHERE user_id = ' . ANONYMOUS;

+ $db->sql_query($sql);

+ else if ($mode == 'remove')

+ {

+ if (!function_exists('delete_posts'))

+ {

+ include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

+ }

+ // Delete posts, attachments, etc.

+ // delete_posts can handle any number of IDs in its second argument

+ delete_posts('poster_id', $user_ids);

+ }

+ // Delete the miscellaneous (non-post) data for the user

+ WHERE " . $user_id_sql;

+ WHERE ' . $db->sql_in_set('reportee_id', $user_ids);

+ WHERE ' . $user_id_sql;

+ WHERE ' . $user_id_sql . '

+ OR ' . $db->sql_in_set('zebra_id', $user_ids);

+ WHERE ' . $db->sql_in_set('ban_userid', $user_ids);

+ WHERE ' . $db->sql_in_set('session_user_id', $user_ids);

+ phpbb_delete_users_pms($user_ids);

+ if (in_array($config['newest_user_id'], $user_ids))

+

+ $redirect = request_var('redirect', "{$phpbb_root_path}viewtopic.$phpEx?f=$to_forum_id&amp;t=$to_topic_id");

+ meta_refresh(3, $redirect);

+ phpbb_generate_template_pagination($template, $base_url, 'pagination', 'start', $log_count, $config['topics_per_page'], $start);

+

+

+

+

+

+ $sql = 'SELECT r.post_id, r.user_id, r.report_id, r.report_closed, report_time, r.report_text, r.reported_post_text, r.reported_post_uid, r.reported_post_bitfield, rr.reason_title, rr.reason_description, u.username, u.username_clean, u.user_colour

+ 'POST_PREVIEW' => generate_text_for_display($report['reported_post_text'], $report['reported_post_uid'], $report['reported_post_bitfield'], OPTION_FLAG_BBCODE | OPTION_FLAG_SMILIES, false),

+

+

+ $redirect = request_var('redirect', "{$phpbb_root_path}viewtopic.$phpEx?f=$to_forum_id&amp;t=$to_topic_id");

+ meta_refresh(3, $redirect);

+ $redirect = request_var('redirect', "{$phpbb_root_path}viewtopic.$phpEx?f=$to_forum_id&amp;t=$to_topic_id");

+ meta_refresh(3, $redirect);

+

+ /**

+ * Associative array holding index stats

+ * @var array

+ */

+

+ /**

+ * Holds the words entered by user, obtained by splitting the entered query on whitespace

+ * @var array

+ */

+

+ /**

+ * Config object

+ * @var phpbb_config

+ */

+

+ /**

+ * DBAL object

+ * @var dbal

+ */

+

+ /**

+ * User object

+ * @var phpbb_user

+ */

+

+ /**

+ * Associative array stores the min and max word length to be searched

+ * @var array

+ */

+

+ /**

+ * Contains tidied search query.

+ * Operators are prefixed in search query and common words excluded

+ * @var string

+ */

+

+ /**

+ * Contains common words.

+ * Common words are words with length less/more than min/max length

+ * @var array

+ */

+ * Creates a new phpbb_search_fulltext_mysql, which is used as a search backend

+ * Performs a search on keywords depending on display specific params. You have to run split_keywords() first

+ // No keywords? No posts

+ // No author? No posts

+ * Destroys cached search results, that contained one of the new words in a post so the results won't be outdated

+ /**

+ * Associative array holding index stats

+ * @var array

+ */

+

+ /**

+ * Associative array stores the min and max word length to be searched

+ * @var array

+ */

+

+ /**

+ * Contains tidied search query.

+ * Operators are prefixed in search query and common words excluded

+ * @var string

+ */

+

+ /**

+ * Contains common words.

+ * Common words are words with length less/more than min/max length

+ * @var array

+ */

+ /**

+ * Post ids of posts containing words that are to be included

+ * @var array

+ */

+

+ /**

+ * Post ids of posts containing words that should not be included

+ * @var array

+ */

+

+ /**

+ * Post ids of posts containing atleast one word that needs to be excluded

+ * @var array

+ */

+ /**

+ * Relative path to board root

+ * @var string

+ */

+

+ /**

+ * PHP Extension

+ * @var string

+ */

+

+ /**

+ * Config object

+ * @var phpbb_config

+ */

+

+ /**

+ * DBAL object

+ * @var dbal

+ */

+

+ /**

+ * User object

+ * @var phpbb_user

+ */

+ * Initialises the fulltext_native search backend with min/max word length and makes sure the UTF-8 normalizer is loaded

+ * @param boolean|string &$error is passed by reference and should either be set to false on success or an error message on failure

+ if (!function_exists('utf8_decode_ncr'))

+ {

+ include($this->phpbb_root_path . 'includes/utf/utf_tools.' . $this->php_ext);

+ }

+ * This function fills $this->search_query with the cleaned user search query

+ * $must_contain_ids and $must_exclude_one_ids which are later used by keyword_search()

+ * Performs a search on keywords depending on display specific params. You have to run split_keywords() first

+ // Count rows for the executed queries. Replace $select within $sql with SQL_CALC_FOUND_ROWS, and run it

+ // No author? No posts

+ /**

+ * Associative array holding index stats

+ * @var array

+ */

+

+ /**

+ * Holds the words entered by user, obtained by splitting the entered query on whitespace

+ * @var array

+ */

+

+ /**

+ * True if PostgreSQL version supports tsearch

+ * @var boolean

+ */

+

+ /**

+ * Stores the PostgreSQL version

+ * @var string

+ */

+

+ /**

+ * Stores the tsearch query

+ * @var string

+ */

+

+ /**

+ * True if phrase search is supported.

+ * PostgreSQL fulltext currently doesn't support it

+ * @var boolean

+ */

+

+ /**

+ * Config object

+ * @var phpbb_config

+ */

+

+ /**

+ * DBAL object

+ * @var dbal

+ */

+

+ /**

+ * User object

+ * @var phpbb_user

+ */

+

+ /**

+ * Contains tidied search query.

+ * Operators are prefixed in search query and common words excluded

+ * @var string

+ */

+

+ /**

+ * Contains common words.

+ * Common words are words with length less/more than min/max length

+ * @var array

+ */

+

+ /**

+ * Associative array stores the min and max word length to be searched

+ * @var array

+ */

+ * Creates a new phpbb_search_fulltext_postgres, which is used as a search backend

+ * Performs a search on keywords depending on display specific params. You have to run split_keywords() first

+ // No keywords? No posts

+ // No author? No posts

+ * Destroys cached search results, that contained one of the new words in a post so the results won't be outdated

+ /**

+ * Associative array holding index stats

+ * @var array

+ */

+

+ /**

+ * Holds the words entered by user, obtained by splitting the entered query on whitespace

+ * @var array

+ */

+

+ /**

+ * Holds unique sphinx id

+ * @var string

+ */

+

+ /**

+ * Stores the names of both main and delta sphinx indexes

+ * separated by a semicolon

+ * @var string

+ */

+

+ /**

+ * Sphinx searchd client object

+ * @var SphinxClient

+ */

+

+ /**

+ * Relative path to board root

+ * @var string

+ */

+

+ /**

+ * PHP Extension

+ * @var string

+ */

+

+ /**

+ * Auth object

+ * @var phpbb_auth

+ */

+

+ /**

+ * Config object

+ * @var phpbb_config

+ */

+

+ /**

+ * DBAL object

+ * @var dbal

+ */

+

+ /**

+ * Database Tools object

+ * @var phpbb_db_tools

+ */

+

+ /**

+ * Stores the database type if supported by sphinx

+ * @var string

+ */

+

+ /**

+ * User object

+ * @var phpbb_user

+ */

+

+ /**

+ * Stores the generated content of the sphinx config file

+ * @var string

+ */

+

+ /**

+ * Contains tidied search query.

+ * Operators are prefixed in search query and common words excluded

+ * @var string

+ */

+ * Creates a new phpbb_search_fulltext_postgres, which is used as a search backend

+ * Returns an empty array as there are no common_words

+ return array();

+ * Performs a search on keywords depending on display specific params. You have to run split_keywords() first

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ private $context;

+ * @param phpbb_template_context $context template context

+ public function __construct($phpbb_root_path, $php_ext, $config, $user, phpbb_template_locator $locator, phpbb_template_context $context)

+ $this->context = $context;

+ * Obtains filesystem path for a template file.

+ *

+ * The simplest use is specifying a single template file as a string

+ * in the first argument. This template file should be a basename

+ * of a template file in the selected style, or its parent styles

+ * if template inheritance is being utilized.

+ *

+ * Note: "selected style" is whatever style the style resource locator

+ * is configured for.

+ *

+ * The return value then will be a path, relative to the current

+ * directory or absolute, to the template file in the selected style

+ * or its closest parent.

+ *

+ * If the selected style does not have the template file being searched,

+ * (and if inheritance is involved, none of the parents have it either),

+ * false will be returned.

+ *

+ * Specifying true for $return_default will cause the function to

+ * return the first path which was checked for existence in the event

+ * that the template file was not found, instead of false.

+ * This is the path in the selected style itself, not any of its

+ * parents.

+ *

+ * $files can be given an array of templates instead of a single

+ * template. When given an array, the function will try to resolve

+ * each template in the array to a path, and will return the first

+ * path that exists, or false if none exist.

+ *

+ * If $return_full_path is false, then instead of returning a usable

+ * path (when the template is found) only the template's basename

+ * will be returned. This can be used to check which of the templates

+ * specified in $files exists, provided different file names are

+ * used for different templates.

+ // add template path prefix

+ 'signature' => array('title' => 'UCP_PROFILE_SIGNATURE', 'auth' => 'acl_u_sig', 'cat' => array('UCP_PROFILE')),

+ phpbb_generate_template_pagination($template, $base_url, 'pagination', 'start', $num_attachments, $config['topics_per_page'], $start);

+

+ $save_message = ($action === 'edit') ? $user->lang['MESSAGE_EDITED'] : $user->lang['MESSAGE_STORED'];

+ $message = $save_message . '<br /><br />' . $user->lang('VIEW_PRIVATE_MESSAGE', '<a href="' . $return_message_url . '">', '</a>');

+

+ 'U_MARK_FORUMS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}index.$phpEx", 'hash=' . generate_link_hash('global') . '&amp;mark=forums&amp;mark_time=' . time()) : '',

+ // No changes from 3.0.11 to 3.0.12-RC1

+ '3.0.11' => array(),

+ 'reported_post_text' => array('MTEXT_UNI', ''),

+ 'reported_post_uid' => array('VCHAR:8', ''),

+ 'reported_post_bitfield' => array('VCHAR:255', ''),

+ // Changes from 3.0.11 to 3.0.12-RC1

+ case '3.0.11':

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET module_auth = \'acl_u_sig\'

+ WHERE module_class = \'ucp\'

+ AND module_basename = \'profile\'

+ AND module_mode = \'signature\'';

+ _sql($sql, $errored, $error_ary);

+

+ // Update bots

+ if (!function_exists('user_delete'))

+ {

+ include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

+ }

+

+ $bots_updates = array(

+ // Bot Deletions

+ 'NG-Search [Bot]' => false,

+ 'Nutch/CVS [Bot]' => false,

+ 'OmniExplorer [Bot]' => false,

+ 'Seekport [Bot]' => false,

+ 'Synoo [Bot]' => false,

+ 'WiseNut [Bot]' => false,

+

+ // Bot Updates

+ // Bot name to bot user agent map

+ 'Baidu [Spider]' => 'Baiduspider',

+ 'Exabot [Bot]' => 'Exabot',

+ 'Voyager [Bot]' => 'voyager/',

+ 'W3C [Validator]' => 'W3C_Validator',

+ );

+

+ foreach ($bots_updates as $bot_name => $bot_agent)

+ {

+ $sql = 'SELECT user_id

+ FROM ' . USERS_TABLE . '

+ WHERE user_type = ' . USER_IGNORE . "

+ AND username_clean = '" . $db->sql_escape(utf8_clean_string($bot_name)) . "'";

+ $result = $db->sql_query($sql);

+ $bot_user_id = (int) $db->sql_fetchfield('user_id');

+ $db->sql_freeresult($result);

+

+ if ($bot_user_id)

+ {

+ if ($bot_agent === false)

+ {

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

+ WHERE user_id = $bot_user_id";

+ _sql($sql, $errored, $error_ary);

+

+ user_delete('remove', $bot_user_id);

+ }

+ else

+ {

+ $sql = 'UPDATE ' . BOTS_TABLE . "

+ SET bot_agent = '" . $db->sql_escape($bot_agent) . "'

+ WHERE user_id = $bot_user_id";

+ _sql($sql, $errored, $error_ary);

+ }

+ }

+ }

+

+ $no_updates = false;

+ break;

+

+$template = new phpbb_template($phpbb_root_path, $phpEx, $config, $user, $phpbb_style_resource_locator, new phpbb_template_context());

+ 'Baidu [Spider]' => array('Baiduspider', ''),

+ 'Bing [Bot]' => array('bingbot/', ''),

+ 'Exabot [Bot]' => array('Exabot', ''),

+ 'Voyager [Bot]' => array('voyager/', ''),

+ 'W3C [Validator]' => array('W3C_Validator', ''),

+ reported_post_text BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,

+ reported_post_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,

+ reported_post_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL

+ [reported_post_text] [text] DEFAULT ('') NOT NULL ,

+ [reported_post_bitfield] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [reported_post_uid] [varchar] (8) DEFAULT ('') NOT NULL

+ reported_post_bitfield varbinary(255) DEFAULT '' NOT NULL,

+ reported_post_uid varbinary(8) DEFAULT '' NOT NULL,

+ reported_post_bitfield varchar(255) DEFAULT '' NOT NULL,

+ reported_post_uid varchar(8) DEFAULT '' NOT NULL,

+ reported_post_bitfield varchar2(255) DEFAULT '' ,

+ reported_post_uid varchar2(8) DEFAULT '' ,

+ reported_post_bitfield varchar(255) DEFAULT '' NOT NULL,

+ reported_post_uid varchar(8) DEFAULT '' NOT NULL,

+ reported_post_text mediumtext(16777215) NOT NULL DEFAULT '',

+ reported_post_bitfield varchar(255) NOT NULL DEFAULT '',

+ reported_post_uid varchar(8) NOT NULL DEFAULT ''

+ 'acl_f_list' => array('lang' => 'Can see forum', 'cat' => 'actions'),

+ 'acl_f_read' => array('lang' => 'Can read forum', 'cat' => 'actions'),

+ 'acl_f_search' => array('lang' => 'Can search the forum', 'cat' => 'actions'),

+ 'acl_f_subscribe' => array('lang' => 'Can subscribe forum', 'cat' => 'actions'),

+ 'acl_f_print' => array('lang' => 'Can print topics', 'cat' => 'actions'),

+ 'acl_f_email' => array('lang' => 'Can email topics', 'cat' => 'actions'),

+ 'acl_f_bump' => array('lang' => 'Can bump topics', 'cat' => 'actions'),

+ 'acl_f_user_lock' => array('lang' => 'Can lock own topics', 'cat' => 'actions'),

+ 'acl_f_download' => array('lang' => 'Can download files', 'cat' => 'actions'),

+ 'acl_f_report' => array('lang' => 'Can report posts', 'cat' => 'actions'),

+

+ 'acl_f_announce' => array('lang' => 'Can post announcements', 'cat' => 'post'),

+ 'acl_f_reply' => array('lang' => 'Can reply to topics', 'cat' => 'post'),

+ 'acl_f_edit' => array('lang' => 'Can edit own posts', 'cat' => 'post'),

+ 'acl_f_delete' => array('lang' => 'Can delete own posts', 'cat' => 'post'),

+ 'acl_f_ignoreflood' => array('lang' => 'Can ignore flood limit', 'cat' => 'post'),

+ 'acl_f_postcount' => array('lang' => 'Increment post counter<br /><em>Please note that this setting only affects new posts.</em>', 'cat' => 'post'),

+ 'acl_f_noapprove' => array('lang' => 'Can post without approval', 'cat' => 'post'),

+

+ 'acl_f_attach' => array('lang' => 'Can attach files', 'cat' => 'content'),

+ 'acl_f_icons' => array('lang' => 'Can use topic/post icons', 'cat' => 'content'),

+ 'acl_f_bbcode' => array('lang' => 'Can use BBCode', 'cat' => 'content'),

+ 'acl_f_flash' => array('lang' => 'Can use [flash] BBCode tag', 'cat' => 'content'),

+ 'acl_f_img' => array('lang' => 'Can use [img] BBCode tag', 'cat' => 'content'),

+ 'acl_f_sigs' => array('lang' => 'Can use signatures', 'cat' => 'content'),

+ 'acl_f_smilies' => array('lang' => 'Can use smilies', 'cat' => 'content'),

+ 'ACP_PRUNE_USERS_EXPLAIN' => 'This section allows you to delete or deactivate users on your board. Accounts can be filtered in a variety of ways; by post count, most recent activity, etc. Criteria may be combined to narrow down which accounts are affected. For example, you can prune users with fewer than 10 posts, who were also inactive after 2002-01-01. Use * as a wildcard for text fields. Alternatively, you may skip the criteria selection completely by entering a list of users (each on a separate line) into the text field. Take care with this facility! Once a user is deleted, there is no way to reverse the action.',

+

+ 'CRITERIA' => 'Criteria',

+ 'JOINED_EXPLAIN' => 'Enter a date in <kbd>YYYY-MM-DD</kbd> format. You may use both fields to specify an interval, or leave one blank for an open date range.',

+ 'POSTS_ON_QUEUE' => 'Posts Awaiting Approval',

+ 'PRUNE_USERS_GROUP_EXPLAIN' => 'Selects all members of the group for pruning.',

+ 'PRUNE_USERS_LIST_DELETE' => 'With the selected critera for pruning users the following accounts will be removed. You can remove individual users from the deletion list by unchecking the box next to their username.',

+ 'PRUNE_USERS_LIST_DEACTIVATE' => 'With the selected critera for pruning users the following accounts will be deactivated. You can remove individual users from the deactivation list by unchecking the box next to their username.',

+ 'SELECT_USERS_EXPLAIN' => 'Enter specific usernames here. They will be used in preference to the criteria above. Founders cannot be pruned.',

+You are receiving this notification because you are watching the forum, "{FORUM_NAME}" at "{SITENAME}". This forum has received a new reply to the topic "{TOPIC_TITLE}"<!-- IF AUTHOR_NAME --> by {AUTHOR_NAME}<!-- ENDIF --> since your last visit. You can use the following link to view the last unread reply, no more notifications will be sent until you visit the topic.

+You are receiving this notification because you are watching the forum, "{FORUM_NAME}" at "{SITENAME}". This forum has received a new topic<!-- IF AUTHOR_NAME --> by {AUTHOR_NAME}<!-- ENDIF --> since your last visit, "{TOPIC_TITLE}". You can use the following link to view the forum, no more notifications will be sent until you visit the forum.

+You are receiving this notification because you are watching the topic, "{TOPIC_TITLE}" at "{SITENAME}". This topic has received a reply<!-- IF AUTHOR_NAME --> by {AUTHOR_NAME}<!-- ENDIF --> since your last visit. You can use the following link to view the replies made, no more notifications will be sent until you visit the topic.

+ 'MESSAGE_EDITED' => 'Message successfully edited.',

+

+ $forum_id = (int) $report_data['forum_id'];

+ $topic_id = (int) $report_data['topic_id'];

+ $reported_post_text = $report_data['post_text'];

+ $reported_post_bitfield = $report_data['bbcode_bitfield'];

+ $reported_post_uid = $report_data['bbcode_uid'];

+ $reported_post_text = $report_data['message_text'];

+ $reported_post_bitfield = $report_data['bbcode_bitfield'];

+ $reported_post_uid = $report_data['bbcode_uid'];

+ 'reason_id' => (int) $reason_id,

+ 'post_id' => $post_id,

+ 'pm_id' => $pm_id,

+ 'user_id' => (int) $user->data['user_id'],

+ 'user_notify' => (int) $user_notify,

+ 'report_closed' => 0,

+ 'report_time' => (int) time(),

+ 'report_text' => (string) $report_text,

+ 'reported_post_uid' => $reported_post_uid,

+ 'reported_post_bitfield'=> $reported_post_bitfield,

+

+

+$('#quick-mod-select').change(function () {

+ $('#quickmodform').submit();

+});

+

+<!-- IF S_DISPLAY_BIRTHDAY_LIST -->

+ <!-- IF to_recipient.IS_GROUP --><a href="{to_recipient.U_VIEW}"><strong>{to_recipient.NAME}</strong></a><!-- ELSE -->{to_recipient.NAME_FULL}<!-- ENDIF -->&nbsp;

+ <!-- IF bcc_recipient.IS_GROUP --><a href="{bcc_recipient.U_VIEW}"><strong>{bcc_recipient.NAME}</strong></a><!-- ELSE -->{bcc_recipient.NAME_FULL}<!-- ENDIF -->&nbsp;

+ <!-- IF to_recipient.IS_GROUP --><a href="{to_recipient.U_VIEW}"><strong>{to_recipient.NAME}</strong></a><!-- ELSE -->{to_recipient.NAME_FULL}<!-- ENDIF -->&nbsp;

+<!-- IF S_NUM_POSTS > 1 or PREVIOUS_PAGE or NEXT_PAGE -->

+.pagination li.ellipsis span {

+ color: #000000;

+ color: #FFFFFF;

+li.pagination ul {

+ margin-top: -2px;

+ vertical-align: middle;

+}

+

+.pagination ul li, dl .pagination ul li, dl.icon .pagination ul li {

+ font-size: 100%;

+ line-height: normal;

+ <td class="row2"><input class="post" type="text" name="qa_answer" size="80"<!-- IF $CAPTCHA_TAB_INDEX --> tabindex="{$CAPTCHA_TAB_INDEX}"<!-- ENDIF --> />

+ <!-- IF .pagination -->

+ <!-- IF pagination.S_IS_PREV --><a href="{pagination.PAGE_URL}">{L_PREVIOUS}</a>

+ <!-- ELSEIF pagination.S_IS_NEXT --><a href="{pagination.PAGE_URL}">{L_NEXT}</a>

+ <!-- IF .pagination -->

+<!-- IF .pagination -->

+<!-- IF .pagination -->

+ markread('topics', array($forum_id), false, request_var('mark_time', 0));

+ 'U_MARK_TOPICS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'hash=' . generate_link_hash('global') . "&amp;f=$forum_id&amp;mark=topics&amp;mark_time=" . time()) : '',

+ static public $was_run = 0;

+ static public $was_run = 0;

+ static public $was_run = 0;

+ static public function fetchfield_seek_data()

+ static public function query_limit_data()

+ new phpbb_style_resource_locator(),

+ new phpbb_template_context()

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+require_once dirname(__FILE__) . '/../../phpBB/includes/functions.php';

+

+class phpbb_clean_path_test extends phpbb_test_case

+{

+ public function clean_path_test_data()

+ {

+ return array(

+ array('foo', 'foo'),

+ array('foo/bar', 'foo/bar'),

+ array('foo/bar/', 'foo/bar/'),

+ array('foo/./bar', 'foo/bar'),

+ array('foo/./././bar', 'foo/bar'),

+ array('foo/bar/.', 'foo/bar'),

+ array('./foo/bar', './foo/bar'),

+ array('../foo/bar', '../foo/bar'),

+ array('one/two/three', 'one/two/three'),

+ array('one/two/../three', 'one/three'),

+ array('one/../two/three', 'two/three'),

+ array('one/two/..', 'one'),

+ array('one/two/../', 'one/'),

+ array('one/two/../three/../four', 'one/four'),

+ array('one/two/three/../../four', 'one/four'),

+ );

+ }

+

+ /**

+ * @dataProvider clean_path_test_data

+ */

+ public function test_clean_path($input, $expected)

+ {

+ $output = phpbb_clean_path($input);

+

+ $this->assertEquals($expected, $output);

+ }

+}

+ static public function delete_user_pms_data()

+<?xml version="1.0" encoding="UTF-8" ?>

+<dataset>

+ <table name="phpbb_posts">

+ <column>post_username</column>

+ <column>post_subject</column>

+ <column>post_text</column>

+ <row>

+ <value>foo</value>

+ <value>foo</value>

+ <value>foo</value>

+ </row>

+ <row>

+ <value>bar</value>

+ <value>bar</value>

+ <value>bar</value>

+ </row>

+ <row>

+ <value>commonword</value>

+ <value>commonword</value>

+ <value>commonword</value>

+ </row>

+ </table>

+ <table name="phpbb_search_wordlist">

+ <column>word_id</column>

+ <column>word_text</column>

+ <column>word_common</column>

+ <row>

+ <value>1</value>

+ <value>foo</value>

+ <value>0</value>

+ </row>

+ <row>

+ <value>2</value>

+ <value>bar</value>

+ <value>0</value>

+ </row>

+ <row>

+ <value>3</value>

+ <value>commonword</value>

+ <value>1</value>

+ </row>

+ </table>

+</dataset>

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+function phpbb_search_wrapper($class)

+{

+ $wrapped = $class . '_wrapper';

+ if (!class_exists($wrapped))

+ {

+ $code = "

+class $wrapped extends $class

+{

+ public function get_must_contain_ids() { return \$this->must_contain_ids; }

+ public function get_must_not_contain_ids() { return \$this->must_not_contain_ids; }

+}

+ ";

+ eval($code);

+ }

+ return $wrapped;

+}

+

+class phpbb_search_native_test extends phpbb_database_test_case

+{

+ protected $db;

+ protected $search;

+

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__) . '/fixtures/posts.xml');

+ }

+

+ protected function setUp()

+ {

+ global $phpbb_root_path, $phpEx, $config, $user, $cache;

+

+ parent::setUp();

+

+ // dbal uses cache

+ $cache = new phpbb_cache_driver_null;

+

+ $this->db = $this->new_dbal();

+ $error = null;

+ $class = phpbb_search_wrapper('phpbb_search_fulltext_native');

+ $this->search = new $class($error, $phpbb_root_path, $phpEx, null, $config, $this->db, $user);

+ }

+

+ protected function tearDown()

+ {

+ parent::tearDown();

+ }

+

+ public function keywords()

+ {

+ return array(

+ // keywords

+ // terms

+ // ok

+ // must contain ids

+ // must not contain ids

+ // common words

+ array(

+ 'foo',

+ 'all',

+ true,

+ array(1),

+ array(),

+ array(),

+ ),

+ array(

+ 'foo bar',

+ 'all',

+ true,

+ array(1, 2),

+ array(),

+ array(),

+ ),

+ // leading, trailing and multiple spaces

+ array(

+ ' foo bar ',

+ 'all',

+ true,

+ array(1, 2),

+ array(),

+ array(),

+ ),

+ // words too short

+ array(

+ 'f',

+ 'all',

+ false,

+ null,

+ null,

+ // short words count as "common" words

+ array('f'),

+ ),

+ array(

+ 'f o o',

+ 'all',

+ false,

+ null,

+ null,

+ array('f', 'o', 'o'),

+ ),

+ array(

+ 'foo -bar',

+ 'all',

+ true,

+ array(1),

+ array(2),

+ array(),

+ ),

+ // all negative

+ array(

+ '-foo',

+ 'all',

+ false,

+ null,

+ null,

+ array(),

+ ),

+ array(

+ '-foo -bar',

+ 'all',

+ false,

+ null,

+ null,

+ array(),

+ ),

+ // all common

+ array(

+ 'commonword',

+ 'all',

+ false,

+ null,

+ null,

+ array('commonword'),

+ ),

+ // some common

+ array(

+ 'commonword foo',

+ 'all',

+ true,

+ array(1),

+ array(),

+ array('commonword'),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider keywords

+ */

+ public function test_split_keywords($keywords, $terms, $ok, $must_contain, $must_not_contain, $common)

+ {

+ $rv = $this->search->split_keywords($keywords, $terms);

+ $this->assertEquals($ok, $rv);

+ if ($ok)

+ {

+ // only check criteria if the search is going to be performed

+ $this->assert_array_content_equals($must_contain, $this->search->get_must_contain_ids());

+ $this->assert_array_content_equals($must_not_contain, $this->search->get_must_not_contain_ids());

+ }

+ $this->assert_array_content_equals($common, $this->search->get_common_words());

+ }

+

+ public function assert_array_content_equals($one, $two)

+ {

+ // http://stackoverflow.com/questions/3838288/phpunit-assert-two-arrays-are-equal-but-order-of-elements-not-important

+ // but one array_diff is not enough!

+ if (sizeof(array_diff($one, $two)) || sizeof(array_diff($two, $one)))

+ {

+ // get a nice error message

+ $this->assertEquals($one, $two);

+ }

+ else

+ {

+ // increase assertion count

+ $this->assertTrue(true);

+ }

+ }

+}

+ $this->style->set_custom_style('tests', $cache_dir, '');

+ $this->template = new phpbb_template($phpbb_root_path, $phpEx, $config, $user, $this->style_resource_locator, new phpbb_template_context());

+ $this->template = new phpbb_template($phpbb_root_path, $phpEx, $config, $user, $this->style_resource_locator, new phpbb_template_context());

+ static public function to_upper($matches)