AND u.user_id = b.ban_userid

AND b.ban_userid <> 0

AND u.user_id <> ' . ANONYMOUS . '

break;

case 'ip':

$bbcode_match = request_var('bbcode_match', '');

$bbcode_tpl = htmlspecialchars_decode(request_var('bbcode_tpl', ''));

break;

}

$db->sql_freeresult($result);

// Grab the end, interrogate the last closing tag

{

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

}

}

$sql_ary = array(

'bbcode_tag' => $data['bbcode_tag'],

'bbcode_match' => $bbcode_match,

$sql = 'SELECT *

FROM ' . BBCODES_TABLE . '

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

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

'override_user_style' => array('lang' => 'OVERRIDE_STYLE', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'legend2' => 'WARNINGS',

)

);

break;

'allow_avatar_remote' => array('lang' => 'ALLOW_REMOTE', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'allow_avatar_upload' => array('lang' => 'ALLOW_UPLOAD', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'avatar_filesize' => array('lang' => 'MAX_FILESIZE', 'validate' => 'int', 'type' => 'text:4:10', 'explain' => true, 'append' => ' ' . $user->lang['BYTES']),

'avatar_path' => array('lang' => 'AVATAR_STORAGE_PATH', 'validate' => 'rwpath', 'type' => 'text:20:255', 'explain' => true),

'avatar_gallery_path' => array('lang' => 'AVATAR_GALLERY_PATH', 'validate' => 'rpath', 'type' => 'text:20:255', 'explain' => true)

)

'bump_type' => false,

'edit_time' => array('lang' => 'EDIT_TIME', 'validate' => 'int', 'type' => 'text:3:3', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

'display_last_edited' => array('lang' => 'DISPLAY_LAST_EDITED', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'bump_interval' => array('lang' => 'BUMP_INTERVAL', 'validate' => 'int', 'type' => 'custom', 'method' => 'bump_interval', 'explain' => true),

'topics_per_page' => array('lang' => 'TOPICS_PER_PAGE', 'validate' => 'int', 'type' => 'text:3:4', 'explain' => false),

'posts_per_page' => array('lang' => 'POSTS_PER_PAGE', 'validate' => 'int', 'type' => 'text:3:4', 'explain' => false),

'max_post_chars' => array('lang' => 'CHAR_LIMIT', 'validate' => 'int', 'type' => 'text:4:6', 'explain' => true),

'max_post_smilies' => array('lang' => 'SMILIES_LIMIT', 'validate' => 'int', 'type' => 'text:4:4', 'explain' => true),

'max_post_urls' => array('lang' => 'MAX_POST_URLS', 'validate' => 'int', 'type' => 'text:5:4', 'explain' => true),

'max_quote_depth' => array('lang' => 'QUOTE_DEPTH_LIMIT', 'validate' => 'int', 'type' => 'text:4:4', 'explain' => true),

)

);

break;

'legend2' => 'GENERAL_SETTINGS',

'max_sig_chars' => array('lang' => 'MAX_SIG_LENGTH', 'validate' => 'int', 'type' => 'text:5:4', 'explain' => true),

'max_sig_urls' => array('lang' => 'MAX_SIG_URLS', 'validate' => 'int', 'type' => 'text:5:4', 'explain' => true),

'max_sig_smilies' => array('lang' => 'MAX_SIG_SMILIES', 'validate' => 'int', 'type' => 'text:5:4', 'explain' => true),

)

);

break;

'min_pass_chars' => array('lang' => 'PASSWORD_LENGTH', 'validate' => 'int', 'type' => 'custom', 'method' => 'password_length', 'explain' => true),

'allow_name_chars' => array('lang' => 'USERNAME_CHARS', 'validate' => 'string', 'type' => 'select', 'method' => 'select_username_chars', 'explain' => true),

'pass_complex' => array('lang' => 'PASSWORD_TYPE', 'validate' => 'string', 'type' => 'select', 'method' => 'select_password_chars', 'explain' => true),

'legend2' => 'GENERAL_OPTIONS',

'allow_namechange' => array('lang' => 'ALLOW_NAME_CHANGE', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

}

$this->new_config = $config;

$error = array();

// We validate the complete config if whished

}

$sql_data .= implode(",\n", $rows);

break;

$sql = 'INSERT INTO ' . DISALLOW_TABLE . ' ' . $db->sql_build_array('INSERT', array('disallow_username' => $disallowed_user));

$db->sql_query($sql);

$message = $user->lang['DISALLOW_SUCCESSFUL'];

add_log('admin', 'LOG_DISALLOW_ADD', str_replace('%', '*', $disallowed_user));

WHERE disallow_id = ' . $disallowed_id;

$db->sql_query($sql);

add_log('admin', 'LOG_DISALLOW_DELETE');

}

$db->sql_freeresult($result);

$s_show_display_on_index = false;

if ($forum_data['parent_id'] > 0)

'S_SHOW_DISPLAY_ON_INDEX' => $s_show_display_on_index,

'S_FORUM_POST' => ($forum_data['forum_type'] == FORUM_POST) ? true : false,

'S_FORUM_ORIG_POST' => (isset($old_forum_type) && $old_forum_type == FORUM_POST) ? true : false,

'S_FORUM_LINK' => ($forum_data['forum_type'] == FORUM_LINK) ? true : false,

'S_FORUM_CAT' => ($forum_data['forum_type'] == FORUM_CAT) ? true : false,

'S_ENABLE_INDEXING' => ($forum_data['enable_indexing']) ? true : false,

$forum_data = $this->get_forum_info($forum_id);

$subforums_id = array();

$subforums = get_forum_branch($forum_id, 'children');

foreach ($subforums as $row)

{

$subforums_id[] = $row['forum_id'];

'FORUM_NAME' => $forum_data['forum_name'],

'S_FORUM_POST' => ($forum_data['forum_type'] == FORUM_POST) ? true : false,

'S_HAS_SUBFORUMS' => ($forum_data['right_id'] - $forum_data['left_id'] > 1) ? true : false,

'S_FORUMS_LIST' => $forums_list,

'S_ERROR' => (sizeof($errors)) ? true : false,

*/

function update_forum_data(&$forum_data)

{

$errors = array();

$forum_data_sql['forum_posts'] = $forum_data_sql['forum_topics'] = $forum_data_sql['forum_topics_real'] = $forum_data_sql['forum_last_post_id'] = $forum_data_sql['forum_last_poster_id'] = $forum_data_sql['forum_last_post_time'] = 0;

$forum_data_sql['forum_last_poster_name'] = $forum_data_sql['forum_last_poster_colour'] = '';

}

if (sizeof($errors))

{

set_config('upload_dir_size', (int) $row['stat'], true);

return array();

}

{

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

}

}

// Which page?

}

$name_ary = array_unique(explode("\n", $name_ary));

// Add user/s to group

{

trigger_error($user->lang[$error] . adm_back_link($this->u_action . '&amp;action=list&amp;g=' . $group_id), E_USER_WARNING);

}

$delete = request_var('delete', '');

$submit_ary = array(

);

if (!empty($_FILES['uploadfile']['tmp_name']) || $data['uploadurl'] || $data['remotelink'])

{

$data['width'] = request_var('width', '');

// were made.

$group_attributes = array();

foreach ($test_variables as $test)

{

if (isset($submit_ary[$test]) && ($action == 'add' || $group_row['group_' . $test] != $submit_ary[$test]))

if (isset($group_row['group_avatar']) && $group_row['group_avatar'])

{

switch ($group_row['group_avatar_type'])

{

case AVATAR_UPLOAD:

$avatar_img = $phpbb_root_path . $config['avatar_gallery_path'] . '/';

break;

}

$avatar_img = '<img src="' . $avatar_img . '" width="' . $group_row['group_avatar_width'] . '" height="' . $group_row['group_avatar_height'] . '" alt="" />';

}

else

'S_SPECIAL_GROUP' => ($group_type == GROUP_SPECIAL) ? true : false,

'S_DISPLAY_GALLERY' => ($config['allow_avatar_local'] && !$display_gallery) ? true : false,

'S_IN_GALLERY' => ($config['allow_avatar_local'] && $display_gallery) ? true : false,

'ERROR_MSG' => (sizeof($error)) ? implode('<br />', $error) : '',

'GROUP_NAME' => ($group_type == GROUP_SPECIAL) ? $user->lang['G_' . $group_name] : $group_name,

'GROUP_INTERNAL_NAME' => $group_name,

'GROUP_DESC' => $group_desc_data['text'],

'GROUP_RECEIVE_PM' => (isset($group_row['group_receive_pm']) && $group_row['group_receive_pm']) ? ' checked="checked"' : '',

'GROUP_LEGEND' => (isset($group_row['group_legend']) && $group_row['group_legend']) ? ' checked="checked"' : '',

'GROUP_MESSAGE_LIMIT' => (isset($group_row['group_message_limit'])) ? $group_row['group_message_limit'] : 0,

'GROUP_COLOUR' => (isset($group_row['group_colour'])) ? $group_row['group_colour'] : '',

'S_DESC_BBCODE_CHECKED' => $group_desc_data['allow_bbcode'],

'S_DESC_URLS_CHECKED' => $group_desc_data['allow_urls'],

'S_DESC_SMILIES_CHECKED'=> $group_desc_data['allow_smilies'],

// 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'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('i' => $user->lang['SORT_INACTIVE'], 'j' => $user->lang['SORT_REG_DATE'], 'l' => $user->lang['SORT_LAST_VISIT'], 'r' => $user->lang['SORT_REASON'], 'u' => $user->lang['SORT_USERNAME']);

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

$template->assign_vars(array(

'U_ACTION' => $this->u_action,

'JAB_ENABLE' => $new['jab_enable'],

'JAB_HOST' => $new['jab_host'],

'JAB_PORT' => $new['jab_port'],

'JAB_USERNAME' => $new['jab_username'],

$hidden_data = build_hidden_fields(array(

'file' => $this->language_file,

'dir' => $this->language_directory,

);

$template->assign_vars(array(

'S_UPLOAD' => true,

'NAME' => $method,

// 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'], 365 => $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']);

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

}

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

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

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

foreach ($log_data as $row)

{

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

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

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

'ACTION' => $row['action'])

// Category/not category?

$is_cat = (!$module_data['module_basename']) ? true : false;

$module_infos = $this->get_module_infos();

// Build name options

}

/**

*/

function get_module_infos($module = '', $module_class = false)

{

$right = $row['right_id'];

if (!$ignore_acl && $row['module_auth'])

{

{

continue;

}

$field_id = request_var('field_id', 0);

$profile_sql = $profile_lang = $empty_lang = $profile_lang_fields = array();

$default_lang_id = $lang_defs['iso'][$config['default_lang']];

/**

* @todo remove Javascript

*/

<!--

close_waitscreen = 1;

//-->

foreach ($classes as $class)

{

$selected = ($class == $edit_class) ? ' selected="selected"' : '';

}

$template->assign_vars(array(

// Prevent normal users/admins change/view founders if they are not a founder by themselves

if ($user->data['user_type'] != USER_FOUNDER && $user_row['user_type'] == USER_FOUNDER)

{

}

switch ($mode)

$data = array(

'username' => request_var('user', $user_row['username'], true),

'user_founder' => request_var('user_founder', ($user_row['user_type'] == USER_FOUNDER) ? 1 : 0),

'user_password' => request_var('user_password', '', true),

'password_confirm' => request_var('password_confirm', '', true),

'warnings' => request_var('warnings', $user_row['user_warnings']),

$last_visit = (!empty($user_row['session_time'])) ? $user_row['session_time'] : $user_row['user_lastvisit'];

$template->assign_vars(array(

'L_NAME_CHARS_EXPLAIN' => sprintf($user->lang[$user_char_ary[str_replace('\\\\', '\\', $config['allow_name_chars'])] . '_EXPLAIN'], $config['min_name_chars'], $config['max_name_chars']),

'L_CHANGE_PASSWORD_EXPLAIN' => sprintf($user->lang[$pass_char_ary[str_replace('\\\\', '\\', $config['pass_complex'])] . '_EXPLAIN'], $config['min_pass_chars'], $config['max_pass_chars']),

'USER_EMAIL' => $user_row['user_email'],

'USER_WARNINGS' => $user_row['user_warnings'],

'USER_POSTS' => $user_row['user_posts'],

)

);

// 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'], 365 => $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']);

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

foreach ($log_data as $row)

{

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

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

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

'ACTION' => nl2br($row['action']),

'yim' => request_var('yim', $user_row['user_yim']),

'jabber' => request_var('jabber', $user_row['user_jabber']),

'website' => request_var('website', $user_row['user_website']),

'bday_day' => 0,

'bday_month' => 0,

'bday_year' => 0,

);

if ($user_row['user_birthday'])

{

case 'prefs':

$data = array(

'lang' => request_var('lang', $user_row['user_lang']),

'tz' => request_var('tz', (float) $user_row['user_timezone']),

'style' => request_var('style', $user_row['user_style']),

$enable_bbcode = ($config['allow_sig_bbcode']) ? request_var('enable_bbcode', $this->optionget($user_row, 'bbcode')) : false;

$enable_smilies = ($config['allow_sig_smilies']) ? request_var('enable_smilies', $this->optionget($user_row, 'smilies')) : false;

$enable_urls = request_var('enable_urls', true);

$preview = (isset($_POST['preview'])) ? true : false;

if ($submit || $preview)

trigger_error($user->lang['NO_GROUP'] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

}

// Add user/s to group

if ($error = group_user_add($group_id, $user_id))

{

$db->sql_freeresult($result);

// Select box for other groups

FROM ' . GROUPS_TABLE . '

' . ((sizeof($id_ary)) ? 'WHERE ' . $db->sql_in_set('group_id', $id_ary, true) : '') . '

ORDER BY group_type DESC, group_name ASC';

continue;

}

$s_group_options .= '<option' . (($row['group_type'] == GROUP_SPECIAL) ? ' class="sep"' : '') . ' value="' . $row['group_id'] . '">' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

}

$db->sql_freeresult($result);

if ($db->sql_layer == 'mssql' || $db->sql_layer == 'mssql_odbc')

{

}

$sql .= 'AND is_global = 1

if ($db->sql_layer == 'mssql' || $db->sql_layer == 'mssql_odbc')

{

}

$sql .= 'AND is_local = 1

break;

case 'save':

if (!$word || !$replacement)

{

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

$sql = 'SELECT user_id as ug_id, username as ug_name

FROM ' . USERS_TABLE . '

WHERE ' . $db->sql_in_set('user_id', array_keys($hold_ary)) . '

}

else

{

$sql = 'SELECT user_id, username

FROM ' . USERS_TABLE . '

WHERE ' . $db->sql_in_set('user_id', $auth_ary['users']) . '

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

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

'S_FIELD_NAME' => 'setting[' . $ug_id . '][' . $forum_id . '][' . $permission . ']',

'U_TRACE' => ($show_trace) ? append_sid("{$phpbb_admin_path}index.$phpEx", "i=permissions&amp;mode=trace&amp;u=$ug_id&amp;f=$forum_id&amp;auth=$permission") : '',

'PERMISSION' => $user->lang['acl_' . $permission]['lang'])

);

$sql_user = ($user_id !== false) ? ((!is_array($user_id)) ? "user_id = $user_id" : $db->sql_in_set('user_id', $user_id)) : '';

$sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND ' . $db->sql_in_set('a.forum_id', $forum_id)) : '';

if ($opts !== false)

{

}

$hold_ary = array();

'ORDER_BY' => 'a.forum_id, ao.auth_option'

));

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

{

$sql_user = ($user_id !== false) ? ((!is_array($user_id)) ? "user_id = $user_id" : $db->sql_in_set('user_id', $user_id)) : '';

$sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND ' . $db->sql_in_set('a.forum_id', $forum_id)) : '';

if ($opts !== false)

{

}

$hold_ary = array();

'ORDER_BY' => 'a.forum_id, ao.auth_option'

));

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

{

$sql_group = ($group_id !== false) ? ((!is_array($group_id)) ? "group_id = $group_id" : $db->sql_in_set('group_id', $group_id)) : '';

$sql_forum = ($forum_id !== false) ? ((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND ' . $db->sql_in_set('a.forum_id', $forum_id)) : '';

if ($opts !== false)

{

}

$hold_ary = array();

'ORDER_BY' => 'a.forum_id, ao.auth_option'

));

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

{

/**

* Fill auth_option statement for later querying based on the supplied options

*/

{

global $db;

if (strpos($auth_options, '_') !== false)

{

$sql_opts = "AND $key LIKE '" . $db->sql_escape(str_replace('_', "\_", $auth_options)) . "'";

}

else

{

}

else

{

foreach ($auth_options as $option)

{

{

$is_like_expression = true;

}

}

if (!$is_like_expression)

foreach ($auth_options as $option)

{

}

$sql_opts = 'AND (' . implode(' OR ', $sql) . ')';

}

}

}

{

global $db, $config;

FROM ' . USERS_TABLE . "

WHERE username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'";

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

}

}

{

// Successful, reset login attempts (the user passed all stages)

$sql = 'UPDATE ' . USERS_TABLE . '

<dd><input type="text" id="ldap_uid" size="40" name="config[ldap_uid]" value="' . $new['ldap_uid'] . '" /></dd>

</dl>

<dl>

</dl>

';

{

$this->bbcode_cache[$bbcode_id] = array(

'preg' => array(

)

);

}

{

$this->bbcode_cache[$bbcode_id] = array(

'preg' => array(

)

);

}

/**

* Return bbcode template

*/

{

if (empty($bbcode_hardtpl))

{

$template_bitfield = new bitfield($this->template_bitfield);

}

{

return (isset($bbcode_hardtpl[$tpl_name])) ? $bbcode_hardtpl[$tpl_name] : false;

}

*/

class captcha

{

function execute($code)

{

global $config;

$stats = gd_info();

preg_match('/[\\d.]+/', $stats['GD Version'], $version);

// create the image, stay compat with older versions of GD

if ($gd_version === 2)

$func2 = 'imagecolorclosest';

}

if ($bundled)

{

// set background color

$back = imagecolorallocate($image, mt_rand(224, 255), mt_rand(224, 255), mt_rand(224, 255));

// allocates the 216 websafe color palette to the image

if ($gd_version === 1)

}

}

// fill with noise or grid

if ($config['captcha_gd_noise'])

{

$size = mt_rand(8, 23);

$angle = mt_rand(0, 360);

$x = mt_rand(0, 360);

$color = $func2($image, mt_rand(160, 224), mt_rand(160, 224), mt_rand(160, 224));

$text = chr(mt_rand(45, 250));

imagettftext($image, $size, $angle, $x, $y, $color, $this->get_font(), $text);

else

{

// generate grid

{

$color = $func2($image, mt_rand(160, 224), mt_rand(160, 224), mt_rand(160, 224));

}

{

$color = $func2($image, mt_rand(160, 224), mt_rand(160, 224), mt_rand(160, 224));

}

}

$text = strtoupper($code[$i]);

$angle = mt_rand(-30, 30);

$size = mt_rand(20, 40);

$color = $func2($image, mt_rand(0, 127), mt_rand(0, 127), mt_rand(0, 127));

$shadow = $func2($image, mt_rand(127, 254), mt_rand(127, 254), mt_rand(127, 254));

class captcha

{

var $filtered_pngs;

/**

* Define filtered pngs on init

*/

function execute($code)

{

$img_width = 0;

list($usec, $sec) = explode(' ', microtime());

for ($i = 0; $i < $code_len; $i++)

{

$width = mt_rand(0, 4);

$raw_width = $this->filtered_pngs[$char]['width'];

}

}

$image = '';

{

$image .= chr(0);

$image .= $this->randomise(substr($hold_chars[$code{$j}][$i - $offset_y - 1], 1), $char_widths[$j]);

}

{

$image .= chr(mt_rand(140, 255));

}

}

else

{

{

$image .= chr(mt_rand(140, 255));

}

}

unset($hold_chars);

// Output image

header('Content-Type: image/png');

}

else

{

}

}

/**

* Run more than one insert statement.

*

*

* @return bool false if no statements were executed.

* @access public

case 'mysql':

case 'mysql4':

case 'mysqli':

$this->sql_query('INSERT INTO ' . $table . ' ' . $this->sql_build_array('MULTI_INSERT', $sql_ary));

break;

$this->sql_report('start', $query);

}

$this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false;

$this->sql_add_num_queries($this->query_result);

$this->sql_report('start', $query);

}

$this->last_query_text = $query;

$this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false;

$this->sql_add_num_queries($this->query_result);

{

$this->query_result = false;

$query = 'SELECT * FROM (SELECT /*+ FIRST_ROWS */ rownum AS xrownum, a.* FROM (' . $query . ') a WHERE rownum <= ' . ($offset + $total) . ') WHERE xrownum >= ' . $offset;

return $this->sql_query($query, $cache_ttl);

* Code from pear.php.net, Text_Diff-0.2.1 (beta) package

* http://pear.php.net/package/Text_Diff/

*

* and being able to integrate into phpBB

* General API for generating and formatting diffs - the differences between

* two sequences of strings.

*

* @package phpBB3

* @author Geoffrey T. Dairiki <dairiki@dairiki.org>

*/

/**

* Removes trailing newlines from a line of text. This is meant to be used with array_walk().

*

* @param integer $key The index of the line in the array. Not used.

*/

function trim_newlines(&$line, $key)

* Code from pear.php.net, Text_Diff-0.2.1 (beta) package

* http://pear.php.net/package/Text_Diff/

*

* and being able to integrate into phpBB

* Class used internally by Diff to actually compute the diffs. This class is

* implemented using native PHP code.

*

* Code from pear.php.net, Text_Diff-0.2.1 (beta) package

* http://pear.php.net/package/Text_Diff/

*

* and being able to integrate into phpBB

* A class to render Diffs in different formats.

*

* This class renders the diff in classic diff format. It is intended that

/**

* Renders a diff.

*

*

* @return string The formatted output.

*/

/**

* Return unique id

*/

function unique_id($extra = 'c')

{

*/

function make_jumpbox($action, $forum_id = false, $select_all = false, $acl_list = false)

{

if (!$config['load_jumpbox'])

{

* Find position of first occurrence of a case-insensitive string

*

* @param string $haystack is the string to search in

*

* Note that the needle may be a string of one or more characters.

* If needle is not found, stripos() will return boolean FALSE.

*/

else if (isset($_SERVER['SCRIPT_FILENAME']) && !empty($_SERVER['SCRIPT_FILENAME']))

{

// Warning: If chdir() has been used this will lie!

$path = str_replace(DIRECTORY_SEPARATOR, '/', dirname($_SERVER['SCRIPT_FILENAME'])) . '/' . $path;

$absolute = true;

$path_prefix = '';

if (!function_exists('htmlspecialchars_decode'))

{

function htmlspecialchars_decode($string, $quote_style = ENT_COMPAT)

{

return strtr($string, array_flip(get_html_translation_table(HTML_SPECIALCHARS, $quote_style)));

*/

function tz_select($default = '', $truncate = false)

{

$tz_select = '';

foreach ($user->lang['tz_zones'] as $offset => $zone)

{

if ($truncate)

{

}

if (is_numeric($offset))

{

$selected = ($offset == $default) ? ' selected="selected"' : '';

}

}

}

}

if ($result['status'] == LOGIN_SUCCESS)

{

$redirect = request_var('redirect', "{$phpbb_root_path}index.$phpEx");

function get_context($text, $words, $length = 400)

{

// first replace all whitespaces with single spaces

$word_indizes = array();

if (sizeof($words))

// Be sure to not let the matches cross over. ;)

// relative urls for this board

$magic_url_replace[] = "'\$1<!-- l --><a href=\"\$2/' . preg_replace('/(&amp;|\?)sid=[0-9a-f]{32}/', '\\1', '\$3') . '\">' . preg_replace('/(&amp;|\?)sid=[0-9a-f]{32}/', '\\1', '\$3') . '</a><!-- l -->'";

// matches a xxxx://aaaaa.bbb.cccc. ...

$magic_url_replace[] = "'\$1<!-- m --><a href=\"\$2\">' . ((strlen('\$2') > 55) ? substr(str_replace('&amp;', '&', '\$2'), 0, 39) . ' ... ' . substr(str_replace('&amp;', '&', '\$2'), -10) : '\$2') . '</a><!-- m -->'";

// matches a "www.xxxx.yyyy[/zzzz]" kinda lazy URL thing

$magic_url_replace[] = "'\$1<!-- w --><a href=\"http://\$2\">' . ((strlen('\$2') > 55) ? substr(str_replace('&amp;', '&', '\$2'), 0, 39) . ' ... ' . substr(str_replace('&amp;', '&', '\$2'), -10) : '\$2') . '</a><!-- w -->'";

// matches an email@domain type address at the start of a line, or after a space or after what might be a BBCode.

$magic_url_replace[] = "'\$1<!-- e --><a href=\"mailto:\$2\">' . ((strlen('\$2') > 55) ? substr('\$2', 0, 39) . ' ... ' . substr('\$2', -10) : '\$2') . '</a><!-- e -->'";

}

/**

* Little helper for the build_hidden_fields function

*/

{

$hidden_fields = '';

if (!is_array($value))

{

$hidden_fields .= '<input type="hidden" name="' . $key . '" value="' . $value . '" />' . "\n";

}

{

foreach ($value as $_key => $_value)

{

}

}

/**

* Build simple hidden fields from array

*/

{

$s_hidden_fields = '';

foreach ($field_ary as $name => $vars)

{

}

return $s_hidden_fields;

$trace['file'] = substr($trace['file'], 1);

$args = array();

if (!in_array($trace['function'], array('include', 'require', 'include_once')))

{

unset($trace['args']);

* Truncates string while retaining special characters if going over the max length

* The default max length is 60 at the moment

*/

{

$chars = array();

$strip_reply = false;

if ($allow_reply && strpos($string, 'Re: ') === 0)

{

$strip_reply = true;

{

// Cut off the last elements from the array

$string = implode('', array_slice($chars, 0, $max_length));

}

if ($strip_reply)

{

$string = 'Re: ' . $string;

}

return $string;

}

/**

* Wrapper for php's checkdnsrr function.

@exec('nslookup -type=' . escapeshellarg($type) . ' ' . escapeshellarg($host), $output);

foreach ($output as $line)

{

if (!trim($line))

// Check the error reporting level and return if the error level does not match

// Additionally do not display notices if we suppress them via @

{

return;

}

{

}

break;

case E_USER_ERROR:

// Specify escape character for MSSQL

if ($db->sql_layer == 'mssql' || $db->sql_layer == 'mssql_odbc')

{

}

}

$reading_sql .

((!$config['load_online_guests']) ? ' AND s.session_user_id <> ' . ANONYMOUS : '') . '

AND u.user_id = s.session_user_id

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

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

}

$template->assign_vars(array(

'U_ACP' => ($auth->acl_get('a_') && $user->data['is_registered']) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", '', true, $user->session_id) : '')

);

if ($cron_type)

{

}

}

if ($return_array)

{

$selected = (is_array($select_id)) ? ((in_array($row['forum_id'], $select_id)) ? true : false) : (($row['forum_id'] == $select_id) ? true : false);

$forum_list[$row['forum_id']] = array_merge(array('padding' => $padding, 'selected' => $selected), $row);

}

sync('forum', 'forum_id', $forum_ids, true);

}

update_posted_info($topic_ids);

}

{

global $db, $config;

$forum_ids = $topic_ids = array();

if (is_array($where_ids))

'posts' => delete_posts($where_type, $where_ids, false, true)

);

FROM ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set($where_type, $where_ids);

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

{

$forum_ids[] = $row['forum_id'];

$topic_ids[] = $row['topic_id'];

}

$db->sql_freeresult($result);

sync('topic_reported', $where_type, $where_ids);

}

return $return;

}

return false;

}

$post_ids = $topic_ids = $forum_ids = $post_counts = array();

FROM ' . POSTS_TABLE . '

WHERE ' . $db->sql_in_set($where_type, array_map('intval', $where_ids));

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

{

$post_counts[$row['poster_id']] = (!empty($post_counts[$row['poster_id']])) ? $post_counts[$row['poster_id']] + 1 : 1;

}

}

$db->sql_freeresult($result);

sync('forum', 'forum_id', $forum_ids, true);

}

return sizeof($post_ids);

}

}

/**

*/

function update_posted_info(&$topic_ids)

{

/**

* Cache moderators, called whenever permissions are changed via admin_permissions. Changes of username

* and group names must be carried through for the moderators table

*/

function cache_moderators()

{

case 'user':

$log_type = LOG_USERS;

break;

case 'users':

return;

}

FROM " . LOG_TABLE . " l, " . USERS_TABLE . " u

WHERE l.log_type = $log_type

AND u.user_id = l.user_id

$log[$i] = array(

'id' => $row['log_id'],

'user_id' => $row['user_id'],

'ip' => $row['log_ip'],

'time' => $row['log_time'],

'forum_id' => $row['forum_id'],

}

}

{

$reportee_id_list = array_unique($reportee_id_list);

$reportee_names_list = array();

{

}

foreach ($log as $key => $row)

{

}

}

{

global $db;

FROM ' . USERS_TABLE . '

WHERE user_warnings > 0

' . (($limit_days) ? "AND user_last_warning >= $limit_days" : '') . "

{

$last_post_subject = $row['forum_last_post_subject'];

$last_post_time = $user->format_date($row['forum_last_post_time']);

$last_post_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id_last_post'] . '&amp;p=' . $row['forum_last_post_id']) . '#p' . $row['forum_last_post_id'];

}

else

{

}

// Output moderator listing ... if applicable

'SUBFORUMS' => $subforums_list,

'LAST_POST_SUBJECT' => censor_text($last_post_subject),

'LAST_POST_TIME' => $last_post_time,

'MODERATORS' => $moderators_list,

'L_SUBFORUM_STR' => $l_subforums,

'L_MODERATOR_STR' => $l_moderator,

'U_VIEWFORUM' => ($row['forum_type'] != FORUM_LINK || ($row['forum_flags'] & FORUM_FLAG_LINK_TRACK)) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : $row['forum_link'],

'U_LAST_POST' => $last_post_url)

);

}

/**

* User authorisation levels output

*/

function gen_forum_auth_level($mode, $forum_id, $forum_status)

{

$rules = array(

($auth->acl_get('f_post', $forum_id) && !$locked) ? $user->lang['RULES_POST_CAN'] : $user->lang['RULES_POST_CANNOT'],

($auth->acl_get('f_reply', $forum_id) && !$locked) ? $user->lang['RULES_REPLY_CAN'] : $user->lang['RULES_REPLY_CANNOT'],

);

if ($config['allow_attachments'])

$extensions = $cache->obtain_attach_extensions();

}

$attach_ids = array();

foreach ($attachment_data as $pos => $attachment)

{

$attachment_data[$attach_ids[$row['attach_id']]] = $row;

}

$db->sql_freeresult($result);

ksort($attachment_data);

}

// Start counting from 22 for the bbcode ids (every bbcode takes two ids - opening/closing)

$num_predefined_bbcodes = 22;

$sql = 'SELECT bbcode_id, bbcode_tag, bbcode_helpline

FROM ' . BBCODES_TABLE . '

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

$i = 0;

'BBCODE_NAME' => "'[{$row['bbcode_tag']}]', '[/" . str_replace('=', '', $row['bbcode_tag']) . "]'",

'BBCODE_ID' => $num_predefined_bbcodes + ($i * 2),

'BBCODE_TAG' => $row['bbcode_tag'],

);

$i++;

$forum_sql

GROUP BY forum_id

ORDER BY num_posts DESC";

$active_f_row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

$forum_sql

GROUP BY topic_id

ORDER BY num_posts DESC";

$active_t_row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

function smtp_class()

{

{

$this->backtrace = true;

$this->backtrace_log = array();

{

fputs($this->socket, $command . "\r\n");

// We could put additional code here

}

}

/**

*

* This version is using base64 encoded data. The downside of this

* is if the mail client does not understand this encoding the user

* is basically doomed with an unreadable subject.

*/

function mail_encode($str)

{

// define start delimimter, end delimiter and spacer

}

?> \ No newline at end of file

/**

* Check module authorisation

*/

{

global $auth, $config;

$module_auth = trim($module_auth);

// Generally allowed to access module if module_auth is empty

return true;

}

$is_auth = false;

return $is_auth;

}

}

/**

*

* @param string $type Can be forum|topic

* @param mixed $ids topic/forum ids

// Check Image Size, if it is an image

if (!$auth->acl_get('a_') && !$auth->acl_get('m_', $forum_id) && $cat_id == ATTACHMENT_CATEGORY_IMAGE)

{

}

// Admins and mods are allowed to exceed the allowed filesize

list($new_width, $new_height) = get_img_size_format($width, $height);

$used_imagick = false;

// Only use imagemagick if defined and the passthru function not disabled

/**

* Generate inline attachment entry

*/

{

global $template, $config, $phpbb_root_path, $phpEx, $user;

'S_HAS_ATTACHMENTS' => true)

);

{

$hidden = '';

$attach_row['real_filename'] = basename($attach_row['real_filename']);

'U_VIEW_ATTACHMENT' => $download_link,

'S_HIDDEN' => $hidden)

);

}

}

global $config, $phpbb_root_path, $phpEx;

// Go ahead and pull all data for this topic

FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . " u

WHERE p.topic_id = $topic_id

AND p.poster_id = u.user_id

foreach ($rowset as $i => $row)

{

$decoded_message = false;

if ($show_quote_button && $auth->acl_get('f_reply', $forum_id))

$post_subject = censor_text($post_subject);

$template->assign_block_vars($mode . '_row', array(

'POST_SUBJECT' => $post_subject,

'MINI_POST_IMG' => $user->img('icon_post_target', $user->lang['POST']),

'POST_DATE' => $user->format_date($row['post_time']),

'U_POST_ID' => $row['post_id'],

'U_MINI_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'p=' . $row['post_id']) . '#p' . $row['post_id'],

'U_MCP_DETAILS' => ($auth->acl_get('m_info', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=post_details&amp;f=' . $forum_id . '&amp;p=' . $row['post_id'], true, $user->session_id) : '',

);

unset($rowset[$i]);

}

));

$messenger->send($addr['method']);

}

}

unset($msg_list_ary);

$sql_data[FORUMS_TABLE] = 'forum_posts = forum_posts - 1';

}

$sql_data[TOPICS_TABLE] .= ', topic_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');

$next_post_id = (int) $row['post_id'];

$subject = truncate_string($subject);

$data['topic_title'] = truncate_string($data['topic_title']);

$sql_data = array();

$poster_id = ($mode == 'edit') ? $data['poster_id'] : (int) $user->data['user_id'];

switch ($post_mode)

{

case 'post':

$folder = array();

$sql = 'SELECT folder_id, COUNT(msg_id) as num_messages, SUM(pm_unread) as num_unread

FROM ' . PRIVMSGS_TO_TABLE . "

WHERE user_id = $user_id

}

/**

*/

function check_rule(&$rules, &$rule_row, &$message_row, $user_id)

{

$auth2 = new auth();

$auth2->acl($userdata);

{

return array('action' => $rule_row['rule_action'], 'pm_unread' => $message_row['pm_unread'], 'pm_marked' => $message_row['pm_marked']);

}

$row['author_in_group'] = $memberships[$row['user_id']];

}

$is_match = false;

foreach ($user_rules as $rule_row)

{

// Do not change the order of processing

// The number of queries needed to be executed here highly depends on the defined rules and are

// only gone through if new messages arrive.

// Delete messages

if (sizeof($delete_ids))

{

delete_pm($user_id, $delete_ids, PRIVMSGS_NO_BOX);

}

$user->data['user_unread_privmsg'] -= $num_unread;

}

}

/**

return false;

}

$sql = 'SELECT msg_id, pm_unread, pm_new

FROM ' . PRIVMSGS_TO_TABLE . '

WHERE ' . $db->sql_in_set('msg_id', array_map('intval', $msg_ids)) . "

$db->sql_query($sql);

// Set delete flag for those intended to receive the PM

$sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . '

SET pm_deleted = 1

WHERE ' . $db->sql_in_set('msg_id', array_keys($delete_rows));

}

else

{

$sql = 'DELETE FROM ' . PRIVMSGS_TO_TABLE . "

WHERE user_id = $user_id

AND folder_id = $folder_id

}

/**

*/

function write_pm_addresses($check_ary, $author_id, $plaintext = false)

{

{

foreach ($adr_ary as $id => $row)

{

'UG_ID' => $id,

);

}

}

}

$current_time = time();

$sql_data = array();

$root_level = 0;

$recipients = $to = $bcc = array();

if ($mode != 'edit')

);

$messenger->send($addr['method']);

}

unset($msg_list_ary);

if (gettype($value) == 'string')

{

}

}

case FIELD_STRING:

case FIELD_TEXT:

break;

case FIELD_INT:

*/

/**

* The {@link fileupload fileupload class} can be used to upload several files, each of them being this object to operate further on.

* @package phpBB3

*/

'username' => $user_row['username'],

'username_clean' => utf8_clean_string($user_row['username']),

'user_password' => (isset($user_row['user_password'])) ? $user_row['user_password'] : '',

'user_email_hash' => (int) crc32(strtolower($user_row['user_email'])) . strlen($user_row['user_email']),

'group_id' => $user_row['group_id'],

'user_type' => $user_row['user_type'],

'user_posts' => 0,

'user_dst' => 0,

'user_colour' => '',

'user_interests' => '',

'user_avatar' => '',

'user_avatar_type' => 0,

AND folder_id = ' . PRIVMSGS_NO_BOX;

$db->sql_query($sql);

$sql = 'DELETE FROM ' . PRIVMSGS_TO_TABLE . '

WHERE user_id = ' . $user_id;

$db->sql_query($sql);

* Also checks if it includes the " character, which we don't allow in usernames.

* Used for registering, changing names, and posting anonymously with a username

*

*/

function validate_username($username)

{

{

global $config, $db, $user;

{

return false;

}

{

$sql = 'SELECT user_email_hash

FROM ' . USERS_TABLE . "

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

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

'group_receive_pm' => 'int',

'group_legend' => 'int',

'group_message_limit' => 'int',

);

// Those are group-only attributes

// Check data

if (!utf8_strlen($name) || utf8_strlen($name) > 40)

/**

* Add user(s) to group

*

*/

function group_user_add($group_id, $user_id_ary = false, $username_ary = false, $group_name = false, $default = false, $leader = 0, $pending = 0, $group_attributes = false)

{

);

$messenger->send($row['user_notify_type']);

}

$messenger->save_queue();

{

if (!function_exists('cache_moderators'))

{

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

}

cache_moderators();

'REPORTED_IMG' => $user->img('icon_topic_reported', 'TOPIC_REPORTED'),

'UNAPPROVED_IMG' => $user->img('icon_topic_unapproved', 'TOPIC_UNAPPROVED'),

'S_CAN_DELETE' => $auth->acl_get('m_delete', $forum_id),

'S_CAN_MOVE' => $auth->acl_get('m_move', $forum_id),

'S_CAN_FORK' => $auth->acl_get('m_', $forum_id),

'U_VIEW_FORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id),

'U_VIEW_FORUM_LOGS' => ($auth->acl_gets('a_', 'm_', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=logs&amp;mode=forum_logs&amp;f=' . $forum_id) : '',

'PAGINATION' => generate_pagination($url . "&amp;i=$id&amp;action=$action&amp;mode=$mode" . (($action == 'merge_select') ? $selected_ids : ''), $forum_topics, $topics_per_page, $start),

'PAGE_NUMBER' => on_page($forum_topics, $topics_per_page, $start),

$replies = ($auth->acl_get('m_approve', $forum_id)) ? $row['topic_replies_real'] : $row['topic_replies'];

$folder_img = $folder_alt = $topic_type = '';

topic_status($row, $replies, false, $folder_img, $folder_alt, $topic_type);

'S_SELECT_TOPIC' => ($action == 'merge_select' && $row['topic_id'] != $topic_id) ? true : false,

'U_SELECT_TOPIC' => $url . "&amp;i=$id&amp;mode=topic_view&amp;action=merge&amp;to_topic_id=" . $row['topic_id'] . $selected_ids,

'U_MCP_QUEUE' => $u_mcp_queue,

'ATTACH_ICON_IMG' => ($auth->acl_get('u_download') && $auth->acl_get('f_download', $row['forum_id']) && $row['topic_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',

'TOPIC_FOLDER_IMG' => $user->img($folder_img, $folder_alt),

'TOPIC_ICON_IMG_HEIGHT' => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['height'] : '',

'UNAPPROVED_IMG' => ($topic_unapproved || $posts_unapproved) ? $user->img('icon_topic_unapproved', ($topic_unapproved) ? 'TOPIC_UNAPPROVED' : 'POSTS_UNAPPROVED') : '',

'TOPIC_TYPE' => $topic_type,

'TOPIC_TITLE' => $topic_title,

'REPLIES' => ($auth->acl_get('m_approve', $row['forum_id'])) ? $row['topic_replies_real'] : $row['topic_replies'],

'LAST_POST_TIME' => $user->format_date($row['topic_last_post_time']),

'TOPIC_ID' => $row['topic_id'],

'S_TOPIC_CHECKED' => ($topic_id_list && in_array($row['topic_id'], $topic_id_list)) ? 'checked="checked" ' : '',

'S_TOPIC_REPORTED' => (!empty($row['topic_reported']) && $auth->acl_get('m_report', $row['forum_id'])) ? true : false,

'S_TOPIC_UNAPPROVED' => $topic_unapproved,

{

global $auth, $db, $template, $phpEx, $user, $phpbb_root_path;

{

}

{

return;

}

$global_id = $forum_list[0];

$sql = $db->sql_build_query('SELECT', array(

'FROM' => array(

REPORTS_TABLE => 'r',

'U_MCP_TOPIC' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id'] . "&amp;i=$id&amp;mode=topic_view"),

'U_FORUM' => (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',

'U_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),

'FORUM_NAME' => (!$global_topic) ? $row['forum_name'] : $user->lang['GLOBAL_ANNOUNCEMENT'],

'TOPIC_TITLE' => $row['topic_title'],

'SUBJECT' => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],

'REPORT_TIME' => $user->format_date($row['report_time']))

);

foreach ($log as $row)

{

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

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

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

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

'U_VIEWLOGS' => (!empty($row['viewlogs'])) ? $row['viewlogs'] : '')

);

}

// 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'], 365 => $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']);

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

}

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

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

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

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

$l_prefix = 'POST';

}

{

// Make sure that for f_user_lock only the lock action is triggered.

if ($action != 'lock')

return;

}

{

return;

}

}

$s_hidden_fields = build_hidden_fields(array(

$sql_id . '_list' => $ids,

foreach ($data as $id => $row)

{

}

$success_msg = $l_prefix . ((sizeof($ids) == 1) ? '' : 'S') . '_' . (($action == 'lock' || $action == 'lock_post') ? 'LOCKED' : 'UNLOCKED') . '_SUCCESS';

{

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

{

return;

}

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

global $phpEx, $phpbb_root_path;

{

return;

}

{

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

{

return;

}

$s_hidden_fields = build_hidden_fields(array(

'topic_id_list' => $topic_ids,

foreach ($data as $topic_id => $row)

{

}

$return = delete_topics('topic_id', $topic_ids);

{

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

{

return;

}

$s_hidden_fields = build_hidden_fields(array(

'post_id_list' => $post_ids,

{

if (!function_exists('delete_posts'))

{

}

// Count the number of topics that are affected

global $auth, $user, $db, $template, $config;

global $phpEx, $phpbb_root_path;

{

return;

}

$to_forum_id = request_var('to_forum_id', 0);

$additional_msg = $success_msg = '';

$s_hidden_fields = build_hidden_fields(array(

$new_topic_id = $db->sql_nextid();

$new_topic_id_list[$topic_id] = $new_topic_id;

if ($topic_row['poll_start'])

{

$poll_rows = array();

// get_user_rank($userrow['user_rank'], $userrow['user_posts'], $rank_title, $rank_img);

$avatar_img = '';

if (!empty($userrow['user_avatar']))

{

switch ($userrow['user_avatar_type'])

$avatar_img = $config['avatar_gallery_path'] . '/';

break;

}

$avatar_img = '<img src="' . $avatar_img . '" width="' . $userrow['user_avatar_width'] . '" height="' . $userrow['user_avatar_height'] . '" alt="" />';

}

$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'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['SORT_USERNAME'], 'b' => $user->lang['SORT_DATE'], 'c' => $user->lang['SORT_IP'], 'd' => $user->lang['SORT_ACTION']);

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

gen_sort_selects($limit_days, $sort_by_text, $st, $sk, $sd, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);

foreach ($log_data as $row)

{

$template->assign_block_vars('usernotes', array(

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

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

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

// Set some vars

$users_ary = $usernames_ary = array();

$post_id = $post_info['post_id'];

// Process message, leave it uncensored

$message = $post_info['post_text'];

'U_MCP_USER_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $post_info['user_id']),

'U_MCP_WARN_USER' => ($auth->acl_getf_global('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&amp;mode=warn_user&amp;u=' . $post_info['user_id']) : '',

'U_VIEW_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $post_info['forum_id'] . '&amp;p=' . $post_info['post_id'] . '#p' . $post_info['post_id']),

'U_VIEW_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $post_info['forum_id'] . '&amp;t=' . $post_info['topic_id']),

'RETURN_TOPIC' => sprintf($user->lang['RETURN_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$post_info['forum_id']}&amp;p=$post_id") . "#p$post_id\">", '</a>'),

'EDIT_IMG' => $user->img('icon_post_edit', $user->lang['EDIT_POST']),

'SEARCH_IMG' => $user->img('icon_user_search', $user->lang['SEARCH']),

'POST_PREVIEW' => $message,

'POST_SUBJECT' => $post_info['post_subject'],

'POST_DATE' => $user->format_date($post_info['post_time']),

foreach ($log_data as $row)

{

$template->assign_block_vars('usernotes', array(

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

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

'ID' => $row['id'])

$db->sql_query($sql);

}

$from_username = $post_info['username'];

$to_username = $userdata['username'];

);

}

// Process message, leave it uncensored

$message = $post_info['post_text'];

$message = str_replace("\n", '<br />', $message);

'U_MCP_USER_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $post_info['user_id']),

'U_MCP_WARN_USER' => ($auth->acl_getf_global('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&amp;mode=warn_user&amp;u=' . $post_info['user_id']) : '',

'U_VIEW_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $post_info['forum_id'] . '&amp;p=' . $post_info['post_id'] . '#p' . $post_info['post_id']),

'U_VIEW_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $post_info['forum_id'] . '&amp;t=' . $post_info['topic_id']),

'RETURN_QUEUE' => sprintf($user->lang['RETURN_QUEUE'], '<a href="' . append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue' . (($topic_id) ? '&amp;mode=unapproved_topics' : '&amp;mode=unapproved_posts')) . "&amp;start=$start\">", '</a>'),

'UNAPPROVED_IMG' => $user->img('icon_topic_unapproved', $user->lang['POST_UNAPPROVED']),

'EDIT_IMG' => $user->img('icon_post_edit', $user->lang['EDIT_POST']),

'POST_PREVIEW' => $message,

'POST_SUBJECT' => $post_info['post_subject'],

'POST_DATE' => $user->format_date($post_info['post_time']),

if (sizeof($post_ids))

{

FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . USERS_TABLE . ' u

WHERE ' . $db->sql_in_set('p.post_id', $post_ids) . '

AND t.topic_id = p.topic_id

}

else

{

FROM ' . TOPICS_TABLE . " t

WHERE forum_id IN (0, $forum_list)

AND topic_approved = 0

foreach ($rowset as $row)

{

$global_topic = ($row['forum_id']) ? false : true;

if ($global_topic)

{

$row['forum_id'] = $global_id;

}

$template->assign_block_vars('postrow', array(

'U_VIEWFORUM' => (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',

'U_VIEWPOST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;p=' . $row['post_id']) . (($mode == 'unapproved_posts') ? '#p' . $row['post_id'] : ''),

'U_VIEW_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue&amp;start=$start&amp;mode=approve_details&amp;f={$row['forum_id']}&amp;p={$row['post_id']}" . (($mode == 'unapproved_topics') ? "&amp;t={$row['topic_id']}" : '')),

'POST_ID' => $row['post_id'],

'FORUM_NAME' => (!$global_topic) ? $forum_names[$row['forum_id']] : $user->lang['GLOBAL_ANNOUNCEMENT'],

'POST_SUBJECT' => $row['post_subject'],

'POST_TIME' => $user->format_date($row['post_time']))

);

}

global $db, $template, $user, $config;

global $phpEx, $phpbb_root_path;

{

trigger_error('NOT_AUTHORIZED');

}

$success_msg = '';

$s_hidden_fields = build_hidden_fields(array(

'i' => 'queue',

'mode' => $mode,

'post_id_list' => $post_id_list,

'action' => 'approve',

'redirect' => $redirect)

);

// If Topic -> total_topics = total_topics+1, total_posts = total_posts+1, forum_topics = forum_topics+1, forum_posts = forum_posts+1

// If Post -> total_posts = total_posts+1, forum_posts = forum_posts+1, topic_replies = topic_replies+1

$update_forum_information = false;

{

$topic_id_list[$post_data['topic_id']] = 1;

// Topic or Post. ;)

if ($post_data['topic_first_post_id'] == $post_id)

{

if ($post_data['forum_id'])

{

$total_topics++;

}

$topic_approve_sql[] = $post_data['topic_id'];

{

if (!isset($topic_replies_sql[$post_data['topic_id']]))

{

}

}

if ($post_data['forum_id'])

{

$total_posts++;

}

$post_approve_sql[] = $post_id;

}

}

{

}

if ($total_topics)

if ($update_forum_information)

{

}

$messenger = new messenger();

'POST_SUBJECT' => htmlspecialchars_decode(censor_text($post_data['post_subject'])),

'TOPIC_TITLE' => htmlspecialchars_decode(censor_text($post_data['topic_title'])),

);

$messenger->send($post_data['user_notify_type']);

}

}

// Send out normal user notifications

$email_sig = str_replace('<br />', "\n", "-- \n" . $config['board_email_sig']);

if ($post_id == $post_data['topic_first_post_id'] && $post_id == $post_data['topic_last_post_id'])

{

// Forum Notifications

}

else

{

// Topic Notifications

}

}

unset($post_info);

{

}

else

{

global $db, $template, $user, $config;

global $phpEx, $phpbb_root_path;

{

trigger_error('NOT_AUTHORIZED');

}

$reason = request_var('reason', '', true);

$reason_id = request_var('reason_id', 0);

$success_msg = $additional_msg = '';

'i' => 'queue',

'mode' => $mode,

'post_id_list' => $post_id_list,

'action' => 'disapprove',

'redirect' => $redirect)

);

// If Topic -> forum_topics_real -= 1

// If Post -> topic_replies_real -= 1

foreach ($post_info as $post_id => $post_data)

{

$topic_id_list[$post_data['topic_id']] = 1;

// Topic or Post. ;)

if ($post_data['topic_first_post_id'] == $post_id && $post_data['topic_last_post_id'] == $post_id)

{

if ($post_data['forum_id'])

{

}

}

else

{

if (!isset($topic_replies_real_sql[$post_data['topic_id']]))

{

}

}

$post_disapprove_sql[] = $post_id;

}

{

}

if (sizeof($topic_replies_real_sql))

unset($post_disapprove_sql, $topic_replies_real_sql);

update_post_information('topic', array_keys($topic_id_list));

$messenger = new messenger();

);

$messenger->send($post_data['user_notify_type']);

}

}

unset($post_info, $disapprove_reason);

{

}

else

{

// closed reports are accessed by report id

$report_id = request_var('r', 0);

FROM ' . REPORTS_TABLE . ' r, ' . REPORTS_REASONS_TABLE . ' rr, ' . USERS_TABLE . ' u

WHERE ' . (($report_id) ? 'r.report_id = ' . $report_id : "r.post_id = $post_id AND r.report_closed = 0") . '

AND rr.reason_id = r.reason_id

);

}

// Process message, leave it uncensored

$message = $post_info['post_text'];

$message = str_replace("\n", '<br />', $message);

$template->assign_vars(array(

'S_MCP_REPORT' => true,

'S_CAN_VIEWIP' => $auth->acl_get('m_info', $post_info['forum_id']),

'S_POST_REPORTED' => $post_info['post_reported'],

'S_POST_UNAPPROVED' => !$post_info['post_approved'],

'U_MCP_WARN_REPORTER' => ($auth->acl_getf_global('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&amp;mode=warn_user&amp;u=' . $report['user_id']) : '',

'U_MCP_WARN_USER' => ($auth->acl_getf_global('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&amp;mode=warn_user&amp;u=' . $post_info['user_id']) : '',

'U_VIEW_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $post_info['forum_id'] . '&amp;p=' . $post_info['post_id'] . '#p' . $post_info['post_id']),

'U_VIEW_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $post_info['forum_id'] . '&amp;t=' . $post_info['topic_id']),

'EDIT_IMG' => $user->img('icon_post_edit', $user->lang['EDIT_POST']),

'UNAPPROVED_IMG' => $user->img('icon_topic_unapproved', $user->lang['POST_UNAPPROVED']),

'REPORTED_IMG' => $user->img('icon_topic_reported', $user->lang['POST_REPORTED']),

'REPORT_REASON_TITLE' => $reason['title'],

'REPORT_REASON_DESCRIPTION' => $reason['description'],

'REPORT_DATE' => $user->format_date($report['report_time']),

'REPORT_TEXT' => $report['report_text'],

'POST_PREVIEW' => $message,

'POST_SUBJECT' => $post_info['post_subject'],

'POST_DATE' => $user->format_date($post_info['post_time']),

if (sizeof($report_ids))

{

FROM ' . REPORTS_TABLE . ' r, ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . USERS_TABLE . ' u, ' . USERS_TABLE . ' ru

WHERE ' . $db->sql_in_set('r.report_id', $report_ids) . '

AND t.topic_id = p.topic_id

$report_data = $rowset = array();

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

{

$global_topic = ($row['forum_id']) ? false : true;

if ($global_topic)

{

'U_VIEWFORUM' => (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',

'U_VIEWPOST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;p=' . $row['post_id']) . '#p' . $row['post_id'],

'U_VIEW_DETAILS' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=reports&amp;start=$start&amp;mode=report_details&amp;f={$row['forum_id']}&amp;r={$row['report_id']}"),

'FORUM_NAME' => (!$global_topic) ? $forum_data[$row['forum_id']]['forum_name'] : $user->lang['GLOBAL_ANNOUNCEMENT'],

'POST_ID' => $row['post_id'],

'POST_SUBJECT' => $row['post_subject'],

'POST_TIME' => $user->format_date($row['post_time']),

'REPORT_TIME' => $user->format_date($row['report_time']),

'TOPIC_TITLE' => $row['topic_title'])

);

'L_TITLE' => ($mode == 'reports') ? $user->lang['MCP_REPORTS_OPEN'] : $user->lang['MCP_REPORTS_CLOSED'],

'L_ONLY_TOPIC' => ($topic_id) ? sprintf($user->lang['ONLY_TOPIC'], $topic_info['topic_title']) : '',

'S_FORUM_OPTIONS' => $forum_options,

'S_CLOSED' => ($mode == 'reports_closed') ? true : false,

global $db, $template, $user, $config;

global $phpEx, $phpbb_root_path;

{

trigger_error('NOT_AUTHORIZED');

}

if ($action == 'delete' && strpos($user->data['session_page'], 'mode=report_details') !== false)

{

}

else

{

}

$success_msg = '';

'i' => 'reports',

'mode' => $mode,

'post_id_list' => $post_id_list,

'action' => $action,

'redirect' => $redirect)

);

);

$messenger->send($reporter['user_notify_type']);

}

}

unset($notify_reporters, $post_info);

$success_msg = (sizeof($post_id_list) == 1) ? 'REPORT_' . strtoupper($action) . 'D_SUCCESS' : 'REPORTS_' . strtoupper($action) . 'D_SUCCESS';

}

else

// Set up some vars

$icon_id = request_var('icon', 0);

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

$to_topic_id = request_var('to_topic_id', 0);

$to_forum_id = request_var('to_forum_id', 0);

$post_id_list = request_var('post_id_list', array(0));

// Split Topic?

if ($action == 'split_all' || $action == 'split_beyond')

{

$sql = 'SELECT u.username, u.user_colour, p.*

FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

AND p.poster_id = u.user_id

$result = $db->sql_query_limit($sql, $posts_per_page, $start);

$rowset = array();

foreach ($rowset as $i => $row)

{

$has_unapproved_posts = false;

$message = $row['post_text'];

$post_subject = ($row['post_subject'] != '') ? $row['post_subject'] : $topic_info['topic_title'];

}

$template->assign_block_vars('postrow', array(

'POST_DATE' => $user->format_date($row['post_time']),

'POST_SUBJECT' => $post_subject,

'MESSAGE' => $message,

'S_CHECKED' => ($post_id_list && in_array(intval($row['post_id']), $post_id_list)) ? true : false,

'U_POST_DETAILS' => "$url&amp;i=$id&amp;p={$row['post_id']}&amp;mode=post_details",

);

unset($rowset[$i]);

$template->assign_vars(array(

'TOPIC_TITLE' => $topic_info['topic_title'],

'TO_TOPIC_ID' => $to_topic_id,

'TO_TOPIC_INFO' => ($to_topic_id) ? sprintf($user->lang['YOU_SELECTED_TOPIC'], $to_topic_id, '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $to_topic_info['forum_id'] . '&amp;t=' . $to_topic_id) . '">' . $to_topic_info['topic_title'] . '</a>') : '',

'S_CAN_DELETE' => ($auth->acl_get('m_delete', $topic_info['forum_id'])) ? true : false,

'S_CAN_APPROVE' => ($has_unapproved_posts && $auth->acl_get('m_approve', $topic_info['forum_id'])) ? true : false,

'S_CAN_LOCK' => ($auth->acl_get('m_lock', $topic_info['forum_id'])) ? true : false,

'S_REPORT_VIEW' => ($action == 'reports') ? true : false,

'S_MERGE_VIEW' => ($action == 'merge') ? true : false,

global $db, $template, $user, $phpEx, $phpbb_root_path, $auth;

$post_id_list = request_var('post_id_list', array(0));

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

if (!sizeof($post_id_list))

return;

}

{

return;

}

return;

}

{

return;

}

'action' => 'merge_posts',

'start' => $start,

'redirect' => $redirect,

't' => $topic_id)

);

$success_msg = $return_link = '';

if (sizeof($topic_data))

{

}

// Link to the new topic

{

$template->assign_block_vars('highest', array(

'U_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $row['user_id']),

'WARNING_TIME' => $user->format_date($row['user_last_warning']),

'WARNINGS' => $row['user_warnings'],

)

// And now the 5 most recent users to get in trouble

FROM ' . USERS_TABLE . ' u, ' . WARNINGS_TABLE . ' w

WHERE u.user_id = w.user_id

ORDER BY w.warning_time DESC';

{

$template->assign_block_vars('latest', array(

'U_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $row['user_id']),

'WARNING_TIME' => $user->format_date($row['warning_time']),

'WARNINGS' => $row['user_warnings'],

)

$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'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['SORT_USERNAME'], 'b' => $user->lang['SORT_DATE'], 'c' => $user->lang['SORT_WARNINGS']);

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

gen_sort_selects($limit_days, $sort_by_text, $st, $sk, $sd, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);

{

$template->assign_block_vars('user', array(

'U_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $row['user_id']),

'WARNING_TIME' => $user->format_date($row['user_last_warning']),

'WARNINGS' => $row['user_warnings'],

)

// get_user_rank($userrow['user_rank'], $userrow['user_posts'], $rank_title, $rank_img);

$avatar_img = '';

if (!empty($userrow['user_avatar']))

{

switch ($userrow['user_avatar_type'])

$avatar_img = $config['avatar_gallery_path'] . '/';

break;

}

$avatar_img = '<img src="' . $avatar_img . '" width="' . $userrow['user_avatar_width'] . '" height="' . $userrow['user_avatar_height'] . '" alt="" />';

}

// get_user_rank($userrow['user_rank'], $userrow['user_posts'], $rank_title, $rank_img);

$avatar_img = '';

if (!empty($userrow['user_avatar']))

{

switch ($userrow['user_avatar_type'])

$avatar_img = $config['avatar_gallery_path'] . '/';

break;

}

$avatar_img = '<img src="' . $avatar_img . '" width="' . $userrow['user_avatar_width'] . '" height="' . $userrow['user_avatar_height'] . '" alt="" />';

}

// Add newline at the end and in front of each quote block to prevent parsing errors (urls, smilies, etc.)

if (strpos($this->message, '[quote') !== false)

{

}

// Add other checks which needs to be placed before actually parsing anything (be it bbcodes, smilies, urls...)

}

$code = preg_replace('#^<span class="[a-z]+"><span class="([a-z]+)">(.*)</span></span>#s', '<span class="$1">$2</span>', $code);

// remove newline at the end

if (!empty($code) && $code{strlen($code)-1} == "\n")

$pos = strlen($in);

for ($i = 0, $tok_len = strlen($tok); $i < $tok_len; ++$i)

{

if ($tmp_pos !== false && $tmp_pos < $pos)

{

$pos = $tmp_pos;

}

$buffer .= substr($in, 0, $pos);

$in = substr($in, $pos + 1);

if ($tok == ']')

if ($buffer == '/quote' && sizeof($close_tags))

{

// we have found a closing tag

$tok = '[';

$buffer = '';

}

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

{

else

{

$end_tag = array_pop($end_tags);

}

}

}

else

{

$out .= $buffer . $tok;

$buffer = '';

}

}

// Do some general 'cleanup' first before processing message,

// e.g. remove excessive newlines(?), smilies(?)

// Transform \r\n and \r into \n

$replace = array("\n", "\n\n", "\\1&#058;");

$this->message = preg_replace($match, $replace, trim($this->message));

// Message length check. -1 disables this check completely.

if ($config['max_' . $mode . '_chars'] != -1)

{

if ((!$msg_len && $mode !== 'sig') || $config['max_' . $mode . '_chars'] && $msg_len > $config['max_' . $mode . '_chars'])

{

$error = array();

$num_attachments = sizeof($this->attachment_data);

$upload_file = (isset($_FILES[$form_name]) && $_FILES[$form_name]['name'] != 'none' && trim($_FILES[$form_name]['name'])) ? true : false;

$add_file = (isset($_POST['add_file'])) ? true : false;

{

if ($edit_comment)

{

$edit_comment = request_var('edit_comment', array(0 => ''));

$edit_comment = key($edit_comment);

{

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

$attachment_data = (isset($_POST['attachment_data'])) ? $_POST['attachment_data'] : array();

$this->attachment_data = array();

* Splits keywords entered by a user into an array of words stored in $this->split_words

* Stores the tidied search query in $this->search_query

*

* @param string $terms is either 'all' or 'any'

*/

function split_keywords(&$keywords, $terms)

{

if ($terms == 'all')

{

$replace = array(' +', ' |', ' -', ' +', ' -', ' |');

$keywords = preg_replace($match, $replace, $keywords);

/**

* Performs a search on keywords depending on display specific params.

*

* @param int $start indicates the first index of the page

* @param int $per_page number of ids each page is supposed to contain

* @return total number of results

/**

* Performs a search on an author's posts without caring about message contents. Depends on display specific params

*

* @param int $start indicates the first index of the page

* @param int $per_page number of ids each page is supposed to contain

* @return total number of results

/**

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

*

*

* @access public

*/

{

$words = array();

if (sizeof($words[1]))

{

$keywords = '(' . implode('|', $words[1]) . ')';

$this->search_query = $keywords;

$exact_words = array();

$exact_words = $exact_words[1];

if (sizeof($exact_words))

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

*

* @param string $type contains either posts or topics depending on what should be searched for

* @param int $start indicates the first index of the page

* @param int $per_page number of ids each page is supposed to contain

* @return boolean|int total number of results

* Performs a search on an author's posts without caring about message contents. Depends on display specific params

*

* @param string $type contains either posts or topics depending on what should be searched for

* @param int $start indicates the first index of the page

* @param int $per_page number of ids each page is supposed to contain

* @return boolean|int total number of results

*

* @param string $mode Contains the post mode: edit, post, reply, quote

* @param int $post_id The id of the post which is modified/created

* @param int $poster_id Post author's user id

* @param int $forum_id The id of the forum in which the post is located

*

* @param string $allowed_chars String of special chars to allow

* @param string $encoding Text encoding

* @return string Cleaned up text, only alphanumeric chars are left

*/

function cleanup($text, $allowed_chars = null, $encoding = 'utf-8')

{

static $conv = array(), $conv_loaded = array();

$words = $allow = array();

$encoding = strtolower($encoding);

if ($encoding != 'utf-8')

{

* If we use it more widely, an instance of that class should be held in a

* a global variable instead

*/

/**

* The first thing we do is:

/**

* Retrieves cached search results

*

*

* @return int SEARCH_RESULT_NOT_IN_CACHE or SEARCH_RESULT_IN_CACHE or SEARCH_RESULT_INCOMPLETE

*/

/**

* Caches post/topic ids

*

* must have the absolute index $start in the result set.

*/

function save_ids($search_key, $keywords, $author_ary, $result_count, &$id_ary, $start, $sort_dir)

{

global $phpEx, $SID, $_SID, $db, $config, $phpbb_root_path;

$this->time_now = time();

$this->cookie_data = array('u' => 0, 'k' => '');

$this->update_session_page = $update_session_page;

$this->check_ban($this->data['user_id'], $this->ip);

}

$this->data['is_registered'] = (!$bot && $this->data['user_id'] != ANONYMOUS && ($this->data['user_type'] == USER_NORMAL || $this->data['user_type'] == USER_FOUNDER)) ? true : false;

$this->data['is_bot'] = ($bot) ? true : false;

// Only update session DB a minute or so after last update or if page changes

if ($this->time_now - $this->data['session_time'] > 60 || ($this->update_session_page && $this->data['session_page'] != $this->page['page']))

{

$sql_ary = array('session_time' => $this->time_now, 'session_last_visit' => $this->time_now, 'session_admin' => 0);

if ($this->update_session_page)

$sql = 'UPDATE ' . SESSIONS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "

WHERE session_id = '" . $db->sql_escape($this->session_id) . "'";

$db->sql_query($sql);

}

$SID = '?sid=';

/**

* If a guest user is surfing, we try to guess his/her language first by obtaining the browser language

if (isset($_SERVER['HTTP_ACCEPT_LANGUAGE']))

{

$this->img_lang = (file_exists($phpbb_root_path . 'styles/' . $this->theme['imageset_path'] . '/imageset/' . $this->lang_name)) ? $this->lang_name : $config['default_lang'];

// Is board disabled and user not an admin or moderator?

if ($config['board_disable'] && !defined('IN_LOGIN') && !$auth->acl_gets('a_', 'm_'))

{

/**

* Change already assigned key variable pair (one-dimensional - single loop entry)

*

*

*

* array: KEY => VALUE [the key/value pair to search for within the loop to determine the correct position]

*

* If key is false the position is set to 0

* If key is true the position is set to the last entry

*

*

* If insert, the vararray is inserted at the given position (position counting from zero).

* If change, the current block gets merged with the vararray (resulting in new key/value pairs be added and existing keys be replaced by the new value).

* Since counting begins by zero, inserting at the last position will result in this array: array(vararray, last positioned array)

* and inserting at position 1 will result in this array: array(first positioned array, vararray, following vars)

*

* @access public

*/

function alter_block_array($blockname, $vararray, $key = false, $mode = 'insert')

);

$messenger->send($row['user_notify_type']);

}

$db->sql_freeresult($result);

// Hide hidden groups unless user is an admin with group privileges

$sql_and = ($auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel')) ? '<> ' . GROUP_SPECIAL : 'NOT IN (' . GROUP_SPECIAL . ', ' . GROUP_HIDDEN . ')';

$sql = 'SELECT group_id, group_name, group_desc, group_desc_uid, group_desc_bitfield, group_desc_options, group_type

FROM ' . GROUPS_TABLE . '

ORDER BY group_type DESC, group_name";

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

if (isset($group_row['group_avatar']) && $group_row['group_avatar'])

{

switch ($group_row['group_avatar_type'])

{

case AVATAR_UPLOAD:

$avatar_img = $phpbb_root_path . $config['avatar_gallery_path'] . '/';

break;

}

$avatar_img = '<img src="' . $avatar_img . '" width="' . $group_row['group_avatar_width'] . '" height="' . $group_row['group_avatar_height'] . '" alt="" />';

}

else

}

$name_ary = array_unique(explode("\n", $name_ary));

$default = request_var('default', 0);

// Add user/s to group

{

trigger_error($user->lang[$error] . $return_page);

}

}

$template->assign_block_vars('topicrow', array(

'LAST_POST_IMG' => $user->img('icon_topic_latest', 'VIEW_LATEST_POST'),

'NEWEST_POST_IMG' => $user->img('icon_topic_newest', 'VIEW_NEWEST_POST'),

'S_UNREAD' => $unread_topic,

'U_LAST_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$g_forum_id&amp;t=$topic_id&amp;p=" . $row['topic_last_post_id']) . '#p' . $row['topic_last_post_id'],

'U_NEWEST_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$g_forum_id&amp;t=$topic_id&amp;view=unread") . '#unread',

'U_VIEW_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$g_forum_id&amp;t=$topic_id"))

);

if ($row['forum_last_post_id'])

{

$last_post_time = $user->format_date($row['forum_last_post_time']);

$last_post_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;p=" . $row['forum_last_post_id']) . '#p' . $row['forum_last_post_id'];

}

else

{

}

$template->assign_block_vars('forumrow', array(

'LAST_POST_IMG' => $user->img('icon_topic_latest', 'VIEW_LATEST_POST'),

'LAST_POST_SUBJECT' => $row['forum_last_post_subject'],

'LAST_POST_TIME' => $last_post_time,

'U_LAST_POST' => $last_post_url,

'U_VIEWFORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']))

);

$topic_id = $row['topic_moved_id'];

}

$folder_img = $folder_alt = $topic_type = '';

topic_status($row, $replies, $unread_topic, $folder_img, $folder_alt, $topic_type);

$template->assign_block_vars('topicrow', array(

'FORUM_ID' => $forum_id,

'TOPIC_ID' => $topic_id,

'FIRST_POST_TIME' => $user->format_date($row['topic_time']),

'LAST_POST_SUBJECT' => $row['topic_last_post_subject'],

'LAST_POST_TIME' => $user->format_date($row['topic_last_post_time']),

'LAST_VIEW_TIME' => $user->format_date($row['topic_last_view_time']),

'PAGINATION' => topic_generate_pagination($replies, append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . (($row['forum_id']) ? $row['forum_id'] : $forum_id) . "&amp;t=$topic_id")),

'REPLIES' => $replies,

'U_NEWEST_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;t=$topic_id&amp;view=unread") . '#unread',

'U_LAST_POST' => $view_topic_url . '&amp;p=' . $row['topic_last_post_id'] . '#p' . $row['topic_last_post_id'],

'U_VIEW_TOPIC' => $view_topic_url)

);

}

$replies = ($auth->acl_get('m_approve', $forum_id)) ? $row['topic_replies_real'] : $row['topic_replies'];

$folder_img = $folder_alt = $topic_type = '';

$unread_topic = false;

'S_DELETED_TOPIC' => (!$row['topic_id']) ? true : false,

'S_GLOBAL_TOPIC' => (!$forum_id) ? true : false,

'FIRST_POST_TIME' => $user->format_date($row['topic_time']),

'LAST_POST_SUBJECT' => $row['topic_last_post_subject'],

'LAST_POST_TIME' => $user->format_date($row['topic_last_post_time']),

'LAST_VIEW_TIME' => $user->format_date($row['topic_last_view_time']),

'PAGINATION' => topic_generate_pagination($replies, append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . (($row['forum_id']) ? $row['forum_id'] : $forum_id) . "&amp;t=$topic_id")),

'POSTED_AT' => $user->format_date($row['topic_time']),

'LAST_POST_IMG' => $user->img('icon_topic_latest', 'VIEW_LATEST_POST'),

'U_LAST_POST' => $view_topic_url . '&amp;p=' . $row['topic_last_post_id'] . '#p' . $row['topic_last_post_id'],

'U_VIEW_TOPIC' => $view_topic_url,

'U_VIEW_FORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id),

'U_MOVE_UP' => ($row['order_id'] != 1) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=main&amp;mode=bookmarks&amp;move_up=' . $row['order_id']) : '',

if ($submit && $edit)

{

if ($draft_message && $draft_subject)

{

$draft_row = array(

/**

* Private Message Class

*

*

* Display Messages (default to inbox) - mode=view

* Display single message - mode=view&p=[msg_id] or &p=[msg_id] (short linkage)

}

// If new messages arrived, place them into the appropiate folder

if ($user->data['user_new_privmsg'] && $action == 'view_folder')

{

$num_not_moved = $user->data['user_new_privmsg'];

// Make sure num_not_moved is valid.

$num_not_moved = $user->data['user_new_privmsg'] = $user->data['user_unread_privmsg'] = 0;

}

}

if (!$msg_id && $folder_id == PRIVMSGS_NO_BOX)

'CUR_FOLDER_ID' => $folder_id,

'CUR_FOLDER_NAME' => $folder_status['folder_name'],

'NUM_NOT_MOVED' => $num_not_moved,

'RELEASE_MESSAGE_INFO' => sprintf($user->lang['RELEASE_MESSAGES'], '<a href="' . $this->u_action . '&amp;folder=' . $folder_id . '&amp;release=1">', '</a>'),

'NOT_MOVED_MESSAGES' => ($num_not_moved == 1) ? $user->lang['NOT_MOVED_MESSAGE'] : sprintf($user->lang['NOT_MOVED_MESSAGES'], $num_not_moved),

'S_FOLDER_OPTIONS' => $s_folder_options,

'S_TO_FOLDER_OPTIONS' => $s_to_folder_options,

}

else

{

FROM ' . PRIVMSGS_TO_TABLE . ' t, ' . PRIVMSGS_TABLE . ' p, ' . USERS_TABLE . ' u

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

AND p.author_id = u.user_id

}

// check for outbox (not read) status, we do not allow editing if one user already having the message

FROM ' . PRIVMSGS_TO_TABLE . ' t, ' . PRIVMSGS_TABLE . ' p

WHERE t.user_id = ' . $user->data['user_id'] . '

AND t.folder_id = ' . PRIVMSGS_OUTBOX . "

{

delete_pm($user->data['user_id'], $msg_id, $folder_id);

$meta_info = append_sid("{$phpbb_root_path}ucp.$phpEx", "i=pm&amp;folder=$folder_id");

$message = $user->lang['MESSAGE_DELETED'];

WHERE post_msg_id = $msg_id

AND in_message = 1

AND is_orphan = 0

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

$message_parser->attachment_data = array_merge($message_parser->attachment_data, $db->sql_fetchrowset($result));

$db->sql_freeresult($result);

// Save Draft

if ($save && $auth->acl_get('u_savedrafts'))

{

$subject = (!$subject && $action != 'post') ? $user->lang['NEW_MESSAGE'] : $subject;

if ($subject && $message)

{

if (confirm_box(true))

if ($submit || $preview || $refresh)

{

$icon_id = request_var('icon', 0);

$enable_bbcode = (!$bbcode_status || isset($_POST['disable_bbcode'])) ? false : true;

$type = ($type == 'u') ? 'u' : 'g';

$id = (int) $id;

'UG_ID' => $id,

);

}

}

}

$friend_list = (is_array($_REQUEST['add_' . $type])) ? array_map('intval', array_keys($_REQUEST['add_' . $type])) : array();

$user_id_ary = array_merge($user_id_ary, $friend_list);

{

{

}

}

}

}

$rule_option = request_var('rule_option', 0);

$cond_option = request_var('cond_option', '');

$action_option = explode('|', request_var('action_option', ''));

$rule_user_id = ($cond_option != 'none') ? request_var('rule_user_id', 0) : 0;

$rule_group_id = ($cond_option != 'none') ? request_var('rule_group_id', 0) : 0;

$action = (int) $action_option[0];

$folder_id = (int) $action_option[1];

switch ($condition)

{

case 'text':

$template->assign_vars(array(

'S_TEXT_CONDITION' => true,

'CURRENT_STRING' => $rule_string,

case 'user':

$rule_user_id = request_var('rule_user_id', 0);

if ($rule_string && !$rule_user_id)

{

$sql = 'SELECT user_id

case 'group':

$rule_group_id = request_var('rule_group_id', 0);

$sql_and = ($auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel')) ? '<> ' . GROUP_SPECIAL : 'NOT IN (' . GROUP_SPECIAL . ', ' . GROUP_HIDDEN . ')';

$sql = 'SELECT group_id, group_name, group_type

FROM ' . GROUPS_TABLE . "

{

foreach ($id_ary as $ug_id => $_id)

{

if ($type == 'u')

{

$folder_alt = ($row['pm_unread']) ? 'NEW_MESSAGES' : 'NO_NEW_MESSAGES';

// Generate all URIs ...

$view_message_url = append_sid("{$phpbb_root_path}ucp.$phpEx", "i=$id&amp;mode=view&amp;f=$folder_id&amp;p=$message_id");

$remove_message_url = append_sid("{$phpbb_root_path}ucp.$phpEx", "i=$id&amp;mode=compose&amp;action=delete&amp;p=$message_id");

$template->assign_block_vars('messagerow', array(

'PM_CLASS' => ($row_indicator) ? 'pm_' . $row_indicator . '_colour' : '',

'FOLDER_ID' => $folder_id,

'MESSAGE_ID' => $message_id,

'SENT_TIME' => $user->format_date($row['message_time']),

'SUBJECT' => censor_text($row['message_subject']),

'FOLDER' => (isset($folder[$row['folder_id']])) ? $folder[$row['folder_id']]['folder_name'] : '',

// PM ordering options

$limit_days = array(0 => $user->lang['ALL_MESSAGES'], 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'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 's' => $user->lang['SUBJECT']);

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

$sql_start = $start;

}

FROM ' . PRIVMSGS_TO_TABLE . ' t, ' . PRIVMSGS_TABLE . ' p, ' . USERS_TABLE . " u

WHERE t.user_id = $user_id

AND p.author_id = u.user_id

// Assign TO/BCC Addresses to template

write_pm_addresses(array('to' => $message_row['to_address'], 'bcc' => $message_row['bcc_address']), $author_id);

// Parse the message and subject

$message = $message_row['message_text'];

FROM ' . ATTACHMENTS_TABLE . "

WHERE post_msg_id = $msg_id

AND in_message = 1

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

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

$url = append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm');

$template->assign_vars(array(

'AUTHOR_RANK' => $user_info['rank_title'],

'RANK_IMAGE' => $user_info['rank_image'],

'AUTHOR_AVATAR' => (isset($user_info['avatar'])) ? $user_info['avatar'] : '',

'U_INFO' => ($auth->acl_get('m_info') && $message_row['pm_forwarded']) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'mode=pm_details&amp;p=' . $message_row['msg_id'], true, $user->session_id) : '',

'U_DELETE' => ($auth->acl_get('u_pm_delete')) ? "$url&amp;mode=compose&amp;action=delete&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] : '',

'U_EMAIL' => $user_info['email'],

'U_QUOTE' => ($auth->acl_get('u_sendpm') && $author_id != ANONYMOUS) ? "$url&amp;mode=compose&amp;action=quote&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] : '',

'U_EDIT' => (($message_row['message_time'] > time() - ($config['pm_edit_time'] * 60) || !$config['pm_edit_time']) && $folder_id == PRIVMSGS_OUTBOX && $auth->acl_get('u_pm_edit')) ? "$url&amp;mode=compose&amp;action=edit&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] : '',

foreach ($rowset as $id => $row)

{

$author_id = $row['author_id'];

$folder_id = (int) $row['folder_id'];

$subject = $row['message_subject'];

}

$template->assign_block_vars('history_row', array(

'SUBJECT' => $subject,

'SENT_DATE' => $user->format_date($row['message_time']),

'MESSAGE' => $message,

'U_MSG_ID' => $row['msg_id'],

'U_VIEW_MESSAGE' => "$url&amp;f=$folder_id&amp;p=" . $row['msg_id'],

'U_QUOTE' => ($auth->acl_get('u_sendpm') && $author_id != ANONYMOUS && $author_id != $user->data['user_id']) ? "$url&amp;mode=compose&amp;action=quote&amp;f=" . $folder_id . "&amp;p=" . $row['msg_id'] : '',

'U_POST_REPLY_PM' => ($author_id != $user->data['user_id'] && $author_id != ANONYMOUS && $auth->acl_get('u_sendpm')) ? "$url&amp;mode=compose&amp;action=reply&amp;f=$folder_id&amp;p=" . $row['msg_id'] : '')

);

}

/**

*/

{

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

global $phpbb_root_path, $phpEx, $config;

if ($user_row['user_avatar'] && $user->optionget('viewavatars'))

{

$avatar_img = '';

switch ($user_row['user_avatar_type'])

{

case AVATAR_UPLOAD:

$avatar_img = $config['avatar_gallery_path'] . '/';

break;

}

$user_row['avatar'] = '<img src="' . $avatar_img . '" width="' . $user_row['user_avatar_width'] . '" height="' . $user_row['user_avatar_height'] . '" alt="' . $user->lang['USER_AVATAR'] . '" />';

}

$data = array(

'notifymethod' => request_var('notifymethod', $user->data['user_notify_type']),

'lang' => request_var('lang', $user->data['user_lang']),

'style' => request_var('style', (int) $user->data['user_style']),

'tz' => request_var('tz', (float) $user->data['user_timezone']),

'DEFAULT_DATEFORMAT' => $config['default_dateformat'],

'A_DEFAULT_DATEFORMAT' => addslashes($config['default_dateformat']),

);

break;

case 'view':

$data = array(

'images' => request_var('images', (bool) $user->optionget('viewimg')),

'flash' => request_var('flash', (bool) $user->optionget('viewflash')),

$data = array(

'username' => request_var('username', $user->data['username'], true),

'new_password' => request_var('new_password', '', true),

'cur_password' => request_var('cur_password', '', true),

'password_confirm' => request_var('password_confirm', '', true),

'username' => ($auth->acl_get('u_chgname') && $config['allow_namechange']) ? $data['username'] : $user->data['username'],

'username_clean' => ($auth->acl_get('u_chgname') && $config['allow_namechange']) ? utf8_clean_string($data['username']) : $user->data['username_clean'],

'user_email' => ($auth->acl_get('u_chgemail')) ? $data['email'] : $user->data['user_email'],

'user_password' => ($auth->acl_get('u_chgpasswd') && $data['new_password']) ? md5($data['new_password']) : $user->data['user_password'],

'user_passchg' => ($auth->acl_get('u_chgpasswd') && $data['new_password']) ? time() : 0,

);

$key_len = ($key_len > 6) ? $key_len : 6;

$user_actkey = substr($user_actkey, 0, $key_len);

$template_file = ($config['require_activation'] == USER_ACTIVATION_ADMIN) ? 'user_activate_inactive' : 'user_activate';

$messenger->template($template_file, $user->data['user_lang']);

$messenger->headers('X-AntiAbuse: User IP - ' . $user->ip);

$messenger->assign_vars(array(

'U_ACTIVATE' => "$server_url/ucp.$phpEx?mode=activate&u={$user->data['user_id']}&k=$user_actkey")

);

$messenger->im($row['user_jabber'], $row['username']);

$messenger->assign_vars(array(

);

$messenger->send($row['user_notify_type']);

$db->sql_freeresult($result);

}

user_active_flip('deactivate', $user->data['user_id'], INACTIVE_PROFILE);

$sql_ary += array(

'yim' => request_var('yim', $user->data['user_yim']),

'jabber' => request_var('jabber', $user->data['user_jabber']),

'website' => request_var('website', $user->data['user_website']),

'bday_day' => 0,

'bday_month' => 0,

'bday_year' => 0,

);

if ($user->data['user_birthday'])

{

list($data['bday_day'], $data['bday_month'], $data['bday_year']) = explode('-', $user->data['user_birthday']);

$enable_bbcode = ($config['allow_sig_bbcode']) ? request_var('enable_bbcode', $user->optionget('bbcode')) : false;

$enable_smilies = ($config['allow_sig_smilies']) ? request_var('enable_smilies', $user->optionget('smilies')) : false;

$enable_urls = request_var('enable_urls', true);

if ($submit || $preview)

{

$avatar_img = $phpbb_root_path . $config['avatar_gallery_path'] . '/';

break;

}

$avatar_img = '<img src="' . $avatar_img . '" width="' . $user->data['user_avatar_width'] . '" height="' . $user->data['user_avatar_height'] . '" alt="" />';

}

return;

}

$timezone = date('Z') / 3600;

$is_dst = date('I');

{

$timezone = $config['board_timezone'];

}

'password_confirm' => request_var('password_confirm', '', true),

'new_password' => request_var('new_password', '', true),

'cur_password' => request_var('cur_password', '', true),

'confirm_code' => request_var('confirm_code', ''),

'lang' => request_var('lang', $user->lang_name),

'tz' => request_var('tz', (float) $timezone),

$messenger->im($row['user_jabber'], $row['username']);

$messenger->assign_vars(array(

);

$messenger->send($row['user_notify_type']);

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

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

$submit = (isset($_POST['submit'])) ? true : false;

if ($submit)

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

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

$submit = (isset($_POST['submit'])) ? true : false;

if ($submit)

$messenger->im($row['user_jabber'], $row['username']);

$messenger->assign_vars(array(

);

$messenger->send($row['user_notify_type']);

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

AND $sql_and

AND u.user_id = z.zebra_id

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

$s_username_options = '';

* The ultimate convenience function! Clean up invalid UTF-8 sequences,

* and convert to Normal Form C, canonical composition.

*

* @return string The same string, all shiny and cleaned-up

*/

{

// The string below is the list of all autorized characters, sorted by frequency in latin text

$pos = strspn($str, "\x20\x65\x69\x61\x73\x6E\x74\x72\x6F\x6C\x75\x64\x5D\x5B\x63\x6D\x70\x27\x0A\x67\x7C\x68\x76\x2E\x66\x62\x2C\x3A\x3D\x2D\x71\x31\x30\x43\x32\x2A\x79\x78\x29\x28\x4C\x39\x41\x53\x2F\x50\x22\x45\x6A\x4D\x49\x6B\x33\x3E\x35\x54\x3C\x44\x34\x7D\x42\x7B\x38\x46\x77\x52\x36\x37\x55\x47\x4E\x3B\x4A\x7A\x56\x23\x48\x4F\x57\x5F\x26\x21\x4B\x3F\x58\x51\x25\x59\x5C\x09\x5A\x2B\x7E\x5E\x24\x40\x60\x7F\x0D");

if ($pos == $len)

{

// ASCII strings with no special chars return immediately

}

// Note: we do not check for $GLOBALS['utf_canonical_decomp']. It is assumed they are always loaded together

// Replace any byte in the range 0x00..0x1F, except for \r, \n and \t

// We replace those characters with a 0xFF byte, which is illegal in UTF-8 and will in turn be replaced with a UTF replacement char

);

}

/**

* Validate and normalize a UTF string to NFC

*

* @return string The string, validated and in normal form

*/

{

$pos = strspn($str, UTF8_ASCII_RANGE);

$len = strlen($str);

if ($pos == $len)

{

// ASCII strings return immediately

}

if (!isset($GLOBALS['utf_nfc_qc']))

include($phpbb_root_path . 'includes/utf/data/utf_nfc_qc.' . $phpEx);

}

}

/**

* Validate and normalize a UTF string to NFKC

*

* @return string The string, validated and in normal form

*/

{

$pos = strspn($str, UTF8_ASCII_RANGE);

$len = strlen($str);

if ($pos == $len)

{

// ASCII strings return immediately

}

if (!isset($GLOBALS['utf_nfkc_qc']))

include($phpbb_root_path . 'includes/utf/data/utf_canonical_comp.' . $phpEx);

}

}

/**

* Validate and normalize a UTF string to NFD

*

* @return string The string, validated and in normal form

*/

{

$pos = strspn($str, UTF8_ASCII_RANGE);

$len = strlen($str);

if ($pos == $len)

{

// ASCII strings return immediately

}

if (!isset($GLOBALS['utf_canonical_decomp']))

include($phpbb_root_path . 'includes/utf/data/utf_canonical_decomp.' . $phpEx);

}

}

/**

* Validate and normalize a UTF string to NFKD

*

* @return string The string, validated and in normal form

*/

{

$pos = strspn($str, UTF8_ASCII_RANGE);

$len = strlen($str);

if ($pos == $len)

{

// ASCII strings return immediately

}

if (!isset($GLOBALS['utf_compatibility_decomp']))

include($phpbb_root_path . 'includes/utf/data/utf_compatibility_decomp.' . $phpEx);

}

}

/**

* Recompose a UTF string

*

*

* @access private

*/

$tmp = '';

$i = $tmp_pos = $last_cc = 0;

// UTF char length array

// This array is used to determine the length of a UTF character.

// has been encoded in a five- or six- byte sequence

if ($utf_char[0] >= "\xF8")

{

{

$trailing_bytes = 4;

}

{

$trailing_bytes = 0;

}

/**

* Decompose a UTF string

*

*

* @access private

*/

function decompose($str, $pos, $len, &$decomp_map)

{

// Load some commonly-used tables

if (!isset($utf_combining_class))

ksort($utf_sort);

}

{

$tmp .= implode('', $utf_chars);

}

// LIndex can only range from 0 to 18, therefore it cannot influence the first two bytes of the L Jamo, which allows us to hardcode them (based on LBase).

//

// The same goes for VIndex, but for TIndex there's a catch: the value of the third byte could exceed 0xBF and we would have to increment the second byte

{

{

$utf_char = "\xE1\x84\x00\xE1\x85\x00\xE1\x86\x00";

}

else

{

$utf_char = "\xE1\x84\x00\xE1\x85\x00\xE1\x87\x00";

}

}

else

}

return $tmp;

}

else if ($tmp_pos)

{

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

*

* @todo make sure the replacements are called correctly

*/

/**

/**

* Implementation of PHP's native utf8_decode for people without XML support

*

* @return string ISO-8859-1 encoded data

*/

function utf8_decode($str)

return false;

}

}

}

else

function utf8_strrpos($str, $needle, $offset = null)

{

// offset for mb_strrpos was added in 5.2.0

{

// Emulate behaviour of strrpos rather than raising warning

if (empty($str))

return false;

}

}

else

{

$str = mb_substr($str, $offset);

{

return $pos + $offset;

}

*/

function utf8_strpos($str, $needle, $offset = null)

{

{

return mb_strpos($str, $needle);

}

* UTF-8 aware alternative to substr

* @ignore

*/

{

{

return mb_substr($str, $offset);

}

* Find position of last occurrence of a char in a string

*

* @author Harry Fuecks

* @return mixed integer position or FALSE on failure

*/

function utf8_strrpos($str, $needle, $offset = null)

* Find position of first occurrence of a string

*

* @author Harry Fuecks

* @return mixed integer position or FALSE on failure

*/

function utf8_strpos($str, $needle, $offset = null)

* necessary. It isn't necessary for +ve offsets and no specified length

*

* @author Chris Smith<chris@jalakai.co.uk>

* @return mixed string or FALSE if failure

*/

function utf8_substr($str, $offset, $length = NULL)

* Convert a string to an array

*

* @author Harry Fuecks

* @return string characters in string reverses

*/

function utf8_str_split($str, $split_len = 1)

* Find length of initial segment not matching mask

*

* @author Harry Fuecks

*/

function utf8_strspn($str, $mask, $start = null, $length = null)

{

/**

* Converts an NCR to a UTF-8 char

*

*/

function utf8_chr($cp)

{

* Convert Numeric Character References to UTF-8 chars

*

* Notes:

*

* @param string $text String to convert, encoded in UTF-8 (no normal form required)

* @return string UTF-8 string where NCRs have been replaced with the actual chars

* Takes an array of ints representing the Unicode characters and returns

* a UTF-8 string.

*

*/

function utf8_case_fold($text, $option = 'full')

{

* A wrapper function for the normalizer which takes care of including the class if required and modifies the passed strings

* to be in NFC (Normalization Form Composition).

*

*/

function utf8_normalize_nfc($strings)

{

{

}

}

}

/**

* functions used here you need to rebuild/update the username_clean column in the users table. And all other

* columns that store a clean string otherwise you will break this functionality.

*

*/

function utf8_clean_string($text)

{

include($phpbb_root_path . 'includes/utf/utf_normalizer.' . $phpEx);

}

static $homographs = array(

// cyrllic