+$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './../';

+ trigger_error('NO_ADMIN');

+ 'S_CONTENT_FLOW_BEGIN' => ($user->lang['DIRECTION'] == 'ltr') ? 'left' : 'right',

+ 'S_CONTENT_FLOW_END' => ($user->lang['DIRECTION'] == 'ltr') ? 'right' : 'left',

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+

+</form>

+

+<form id="acp_unban" method="post" action="{U_ACTION}">

+

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <p class="submit-buttons">

+ <input class="button1" type="submit" id="submit" name="submit" value="{L_SUBMIT}" />&nbsp;

+ <input class="button2" type="reset" id="reset" name="reset" value="{L_RESET}" />

+ </p>

+

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <fieldset class="quick" style="float: {S_CONTENT_FLOW_BEGIN};">

+ <fieldset class="quick" style="float: {S_CONTENT_FLOW_END};">

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <dd><label><input type="radio" class="radio" name="type_action" value="delete"<!-- IF not S_MOVE_FORUM_OPTIONS --> checked="checked" id="type_action"<!-- ENDIF --> /> {L_DELETE_ALL_POSTS}</label></dd>

+ <!-- IF S_MOVE_FORUM_OPTIONS --><dd><label><input type="radio" class="radio" name="type_action" id="type_action" value="move" checked="checked" /> {L_MOVE_POSTS_TO}</label> <select name="to_forum_id">{S_MOVE_FORUM_OPTIONS}</select></dd><!-- ENDIF -->

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <!-- IF forums.FORUM_IMAGE --><div style="float: {S_CONTENT_FLOW_BEGIN}; margin-right: 5px;">{forums.FORUM_IMAGE}</div><!-- ENDIF -->

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <fieldset class="quick" style="float: {S_CONTENT_FLOW_BEGIN};">

+ <fieldset class="quick" style="float: {S_CONTENT_FLOW_END};">

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <input class="button2" type="submit" name="delall" value="{L_DELETE_ALL}" />&nbsp;

+ <input class="button2" type="submit" name="delmarked" value="{L_DELETE_MARKED}" /><br />

+ <td>{L_BOARD_VERSION}: </td>

+ <td><strong>{BOARD_VERSION}</strong></td>

+ <!-- IF S_TOTAL_ORPHAN -->

+ <!-- ELSE -->

+ <td>&nbsp;</td>

+ <td>&nbsp;</td>

+ </tr>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <fieldset class="quick" style="float: {S_CONTENT_FLOW_END};">

+ <fieldset class="quick" style="float: {S_CONTENT_FLOW_BEGIN};">

+ <div class="clearfix">&nbsp;</div><br style="clear: both;" />

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <div style="float: {S_CONTENT_FLOW_BEGIN}; width: 48%;">

+ <dd class="full" style="text-align: left;"><div style="float: {S_CONTENT_FLOW_END};">[ <a href="{U_FIND_USERNAME}" onclick="find_username(); return false;">{L_FIND_USERNAME}</a> ]</div><label><input type="checkbox" class="radio" id="anonymous" name="user_id[]" value="{ANONYMOUS_USER_ID}" /> {L_SELECT_ANONYMOUS}</label></dd>

+ <div style="float: {S_CONTENT_FLOW_END}; width: 48%">

+ <div style="float: {S_CONTENT_FLOW_BEGIN}; width: 48%;">

+ <div style="float: {S_CONTENT_FLOW_END}; width: 48%">

+ <fieldset class="quick" style="float: {S_CONTENT_FLOW_END};">

+ <fieldset class="quick" style="float: {S_CONTENT_FLOW_BEGIN};">

+ <fieldset class="quick" style="float: {S_CONTENT_FLOW_END};">

+<div class="phpinfo">

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <fieldset class="quick" style="float: {S_CONTENT_FLOW_BEGIN};">

+ <fieldset class="quick" style="float: {S_CONTENT_FLOW_END};">

+ <fieldset class="quick" style="float: {S_CONTENT_FLOW_BEGIN};">

+ <fieldset class="quick" style="float: {S_CONTENT_FLOW_END};">

+ <dd><select name="f[]" multiple="multiple" size="10">{S_FORUM_OPTIONS}</select></dd>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <dd><textarea name="reason_description" id="reason_description" rows="8" cols="80">{REASON_DESCRIPTION}</textarea></dd>

+ <i style="float: {S_CONTENT_FLOW_END}; font-size: .9em;"><!-- IF reasons.S_TRANSLATED -->{L_IS_TRANSLATED}<!-- ELSE -->{L_IS_NOT_TRANSLATED}<!-- ENDIF --></i>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+ <div style="float: {S_CONTENT_FLOW_END};">

+ <input class="button2" type="submit" name="delall" value="{L_DELETE_ALL}" />&nbsp;

+ <input class="button2" type="submit" name="delmarked" value="{L_DELETE_MARKED}" />

+ <a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

+fieldset.permissions .padding {

+}

+

+.permissions-reset {

+ margin-top: -6px;

+ padding-bottom: 10px;

+}

+

+.permissions-reset a {

+ font-size: .8em;

+}

+

+

+/* Classes for additional tasks

+---------------------------------------- */

+

+.phpinfo {

+ overflow: auto;

+ width: 99%;

+ direction: ltr;

+}

+

+.phpinfo td, .phpinfo th, .phpinfo h2, .phpinfo h1 {

+ text-align: left;

+}

+ Powered by phpBB &copy; 2000, 2002, 2005, 2007 <a href="http://www.phpbb.com/">phpBB Group</a>

+ function diff_popup(url)

+ window.open(url.replace(/&amp;/g, '&'), 'diff', 'height=600,resizable=yes,scrollbars=yes,width=950');

+ <div class="errorbox" style="margin-top: 0;">

+ <h3>{L_NOTICE}</h3>

+ <p>{ERROR_MSG}</p>

+ </div>

+

+ <!-- IF S_WARNING -->

+ <div class="successbox" style="margin-top: 0;">

+ <h3>{L_NOTICE}</h3>

+ <p>{WARNING_MSG}</p>

+ </div>

+ <!-- ENDIF -->

+

+ <!-- IF PACKAGE_VERSION and not S_UP_TO_DATE -->

+ <dl>

+ <dt><label>{L_PACKAGE_UPDATES_TO}</label></dt>

+ <dd><strong>{PACKAGE_VERSION}</strong></dd>

+ </dl>

+ <!-- ENDIF -->

+ <dd style="margin-left: 60%;"><!-- IF files.STATUS eq 'modified' -->&nbsp;<!-- ELSE --><!-- IF not files.S_BINARY -->[ <a href="{files.U_SHOW_DIFF}" onclick="diff_popup('{files.U_SHOW_DIFF}'); return false;">{files.L_SHOW_DIFF}</a> ]<!-- ELSE -->{L_BINARY_FILE}<!-- ENDIF --><!-- ENDIF --></dd>

+

+ <!-- IF files.STATUS eq 'modified' -->

+ </dl>

+ <dl>

+ <dt style="width: 60%"><label><input type="radio" class="radio" name="modified[{files.FILENAME}]" value="0" checked="checked" /> {L_MERGE_MODIFICATIONS_OPTION}</label></dt>

+ <dd style="margin-left: 60%;"><!-- IF not files.S_BINARY -->[ <a href="{files.U_SHOW_DIFF}" onclick="diff_popup('{files.U_SHOW_DIFF}'); return false;">{files.L_SHOW_DIFF}</a> ]<!-- ELSE -->{L_BINARY_FILE}<!-- ENDIF --></dd>

+ </dl>

+ <dl>

+ <dt style="width: 60%"><label><input type="radio" class="radio" name="modified[{files.FILENAME}]" value="1" /> {L_MERGE_NO_MERGE_NEW_OPTION}</label></dt>

+ <dd style="margin-left: 60%;"><!-- IF not files.S_BINARY -->[<a href="{files.U_VIEW_NO_MERGE_NEW}" onclick="diff_popup('{files.U_VIEW_NO_MERGE_NEW}'); return false;">{L_SHOW_DIFF_FINAL}</a>]<!-- ELSE -->&nbsp;<!-- ENDIF --></dd>

+ </dl>

+ <dl>

+ <dt style="width: 60%"><label><input type="radio" class="radio" name="modified[{files.FILENAME}]" value="2" /> {L_MERGE_NO_MERGE_MOD_OPTION}</label></dt>

+ <dd style="margin-left: 60%;"><!-- IF not files.S_BINARY -->[<a href="{files.U_VIEW_NO_MERGE_MOD}" onclick="diff_popup('{files.U_VIEW_NO_MERGE_MOD}'); return false;">{L_SHOW_DIFF_FINAL}</a>]<!-- ELSE -->&nbsp;<!-- ENDIF --></dd>

+ </dl>

+ <!-- IF not files.S_LAST_ROW -->

+ </fieldset>

+

+ <fieldset>

+ <legend><img src="{T_IMAGE_PATH}file_{files.STATUS}.gif" alt="{files.L_STATUS}" /></legend>

+ <!-- ENDIF -->

+

+ <!-- ENDIF -->

+

+ <dd style="margin-left: 60%;"><!-- IF not files.S_BINARY -->[<a href="{files.U_VIEW_NO_MERGE_NEW}" onclick="diff_popup('{files.U_VIEW_NO_MERGE_NEW}'); return false;">{L_SHOW_DIFF_FINAL}</a>]<!-- ELSE -->&nbsp;<!-- ENDIF --></dd>

+ <dd style="margin-left: 60%;"><!-- IF not files.S_BINARY -->[<a href="{files.U_VIEW_NO_MERGE_MOD}" onclick="diff_popup('{files.U_VIEW_NO_MERGE_MOD}'); return false;">{L_SHOW_DIFF_FINAL}</a>]<!-- ELSE -->&nbsp;<!-- ENDIF --></dd>

+ <dd style="margin-left: 60%;">[<a href="{files.U_VIEW_NEW_FILE}" onclick="diff_popup('{files.U_VIEW_NEW_FILE}'); return false;">{L_SHOW_DIFF_FINAL}</a>]</dd>

+ <dd style="margin-left: 60%;">[<a href="{files.U_VIEW_MOD_FILE}" onclick="diff_popup('{files.U_VIEW_MOD_FILE}'); return false;">{L_SHOW_DIFF_FINAL}</a>]</dd>

+ <!-- IF files.STATUS neq 'conflict' and files.STATUS neq 'modified' --></dl><!-- ENDIF -->

+#diff_content {

+ padding: 30px 10px 10px;

+}

+

+ display: inline-block;

+ <div id="diff_content">

+ <div style="float: {S_CONTENT_FLOW_END};"><strong>{L_NUM_CONFLICTS}: {NUM_CONFLICTS}</strong></div>

+ Powered by phpBB &copy; 2000, 2002, 2005, 2007 <a href="http://www.phpbb.com/">phpBB Group</a>

+ <p>{L_LOGGED_IN_AS}<br /><strong>{USERNAME}</strong> [&nbsp;<a href="{U_LOGOUT}">{L_LOGOUT}</a>&nbsp;]</p>

+<h3>{p_mask.NAME}<!-- IF p_mask.S_LOCAL --> <span class="small"> [{p_mask.L_ACL_TYPE}]</span><!-- ENDIF --></h3>

+ <!-- IF p_mask.f_mask.PADDING --><span class="padding">{p_mask.f_mask.PADDING}{p_mask.f_mask.PADDING}</span><!-- ENDIF -->{p_mask.f_mask.NAME}

+ <div class="permissions-reset">

+ <a href="#" onclick="mark_options('perm{p_mask.S_ROW_COUNT}{p_mask.f_mask.S_ROW_COUNT}', 'y'); reset_role('role{p_mask.S_ROW_COUNT}{p_mask.f_mask.S_ROW_COUNT}'); init_colours('{p_mask.S_ROW_COUNT}{p_mask.f_mask.S_ROW_COUNT}'); return false;">{L_ALL_YES}</a> &middot; <a href="#" onclick="mark_options('perm{p_mask.S_ROW_COUNT}{p_mask.f_mask.S_ROW_COUNT}', 'u'); reset_role('role{p_mask.S_ROW_COUNT}{p_mask.f_mask.S_ROW_COUNT}'); init_colours('{p_mask.S_ROW_COUNT}{p_mask.f_mask.S_ROW_COUNT}'); return false;">{L_ALL_NO}</a> &middot; <a href="#" onclick="mark_options('perm{p_mask.S_ROW_COUNT}{p_mask.f_mask.S_ROW_COUNT}', 'n'); reset_role('role{p_mask.S_ROW_COUNT}{p_mask.f_mask.S_ROW_COUNT}'); init_colours('{p_mask.S_ROW_COUNT}{p_mask.f_mask.S_ROW_COUNT}'); return false;">{L_ALL_NEVER}</a>

+ </div>

+ <a href="#" onclick="swap_options('{p_mask.S_ROW_COUNT}', '{p_mask.f_mask.S_ROW_COUNT}', '0', true); return false;">{L_ADVANCED_PERMISSIONS}</a><!-- IF not p_mask.S_VIEW and p_mask.f_mask.S_CUSTOM --> *<!-- ENDIF -->

+ <!-- IF not p_mask.S_VIEW -->

+ <div class="permissions-advanced" id="advanced{p_mask.S_ROW_COUNT}{p_mask.f_mask.S_ROW_COUNT}" style="display: none;">

+ <!-- ELSE -->

+ <div class="permissions-advanced" id="advanced{p_mask.S_ROW_COUNT}{p_mask.f_mask.S_ROW_COUNT}">

+ <!-- ENDIF -->

+ <!-- IF U_BACK --><a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a><!-- ENDIF -->

+ <tr class="row2">

+ <td style="white-space: nowrap;"><strong>{L_TRACE_RESULT}</strong></td>

+ <td colspan="2" style="text-align: center;" class="<!-- IF S_RESULT_NEVER -->never<!-- ELSEIF S_RESULT_YES -->yes<!-- ELSE -->no<!-- ENDIF -->">

+ <!-- IF S_RESULT_NEVER -->{L_ACL_NEVER}<!-- ELSEIF S_RESULT_YES -->{L_ACL_YES}<!-- ELSE -->{L_ACL_NO}<!-- ENDIF -->

+ </td>

+ <td>{L_RESULTING_PERMISSION}</td>

+ </tr>

+ <br />Powered by phpBB &copy; 2000, 2002, 2005, 2007 <a href="http://www.phpbb.com/">phpBB Group</a>

+$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './../';

+$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';

+// test without flush ;)

+// flush();

+

+// make sure cron doesn't run multiple times in parallel

+if ($config['cron_lock'])

+{

+ // if the other process is running more than an hour already we have to assume it

+ // aborted without cleaning the lock

+ $time = explode(' ', $config['cron_lock']);

+ $time = $time[0];

+

+ if ($time + 3600 >= time())

+ {

+ exit;

+ }

+}

+

+define('CRON_ID', time() . ' ' . unique_id());

+

+$sql = 'UPDATE ' . CONFIG_TABLE . "

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

+ WHERE config_name = 'cron_lock' AND config_value = '" . $db->sql_escape($config['cron_lock']) . "'";

+$db->sql_query($sql);

+

+// another cron process altered the table between script start and UPDATE query so exit

+if ($db->sql_affectedrows() != 1)

+{

+ exit;

+}

+$sql = 'UPDATE ' . CONFIG_TABLE . "

+ SET config_value = '0'

+ WHERE config_name = 'cron_lock' AND config_value = '" . $db->sql_escape(CRON_ID) . "'";

+$db->sql_query($sql);

+

+@set_time_limit(0);

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

+ 'group_avatar_type' => array('TINT:2', 0),

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

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

+ 'style_id' => array('USINT', NULL, 'auto_increment'),

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

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

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

+ 'template_id' => array('USINT', NULL, 'auto_increment'),

+ 'template_id' => array('USINT', NULL, 'auto_increment'),

+ 'theme_id' => array('USINT', NULL, 'auto_increment'),

+ 'imageset_id' => array('USINT', NULL, 'auto_increment'),

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

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

+<?php

+/**

+*

+* @package phpBB3

+* @version $Id$

+* @copyright (c) 2005 phpBB Group

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

+*

+*/

+

+if (php_sapi_name() != 'cli')

+{

+ die("This program must be run from the command line.\n");

+}

+

+//

+// Security message:

+//

+// This script is potentially dangerous.

+// Remove or comment the next line (die(".... ) to enable this script.

+// Do NOT FORGET to either remove this script or disable it after you have used it.

+//

+die("Please read the first lines of this script for instructions on how to enable it");

+

+set_time_limit(0);

+

+define('IN_PHPBB', true);

+$phpbb_root_path = '../';

+$phpEx = substr(strrchr(__FILE__, '.'), 1);

+

+echo "Checking for required files\n";

+download('http://unicode.org/reports/tr39/data/confusables.txt');

+download('http://unicode.org/Public/UNIDATA/CaseFolding.txt');

+echo "\n";

+

+

+/**

+* Load the confusables table

+*/

+echo "Loading confusables\n";

+$unidata = file_get_contents('confusables.txt');

+

+/**

+* Load the CaseFolding table

+*/

+echo "Loading CaseFolding\n";

+$casefolds = file_get_contents('CaseFolding.txt');

+

+

+function utf8_chr($cp)

+{

+ if ($cp > 0xFFFF)

+ {

+ return chr(0xF0 | ($cp >> 18)) . chr(0x80 | (($cp >> 12) & 0x3F)) . chr(0x80 | (($cp >> 6) & 0x3F)) . chr(0x80 | ($cp & 0x3F));

+ }

+ else if ($cp > 0x7FF)

+ {

+ return chr(0xE0 | ($cp >> 12)) . chr(0x80 | (($cp >> 6) & 0x3F)) . chr(0x80 | ($cp & 0x3F));

+ }

+ else if ($cp > 0x7F)

+ {

+ return chr(0xC0 | ($cp >> 6)) . chr(0x80 | ($cp & 0x3F));

+ }

+ else

+ {

+ return chr($cp);

+ }

+}

+

+preg_match_all('/^([0-9A-F]+) ;\s((?:[0-9A-F]+ )*);.*?$/im', $unidata, $array, PREG_SET_ORDER);

+preg_match_all('/^([0-9A-F]+); ([CFS]); ([0-9A-F]+(?: [0-9A-F]+)*);/im', $casefolds, $casefold_array);

+

+// some that we defined ourselves

+$uniarray = array(

+ "\xC2\xA1" => "\x69", // EXCLAMATION MARK, INVERTED => LATIN SMALL LETTER I

+ "\xC7\x83" => "\x21", // LATIN LETTER RETROFLEX CLICK => EXCLAMATION MARK

+ "\xCE\xB1" => "\x61", // GREEK SMALL LETTER ALPHA => LATIN SMALL LETTER A

+ "\xE1\x9A\x80" => "\x20", // OGHAM SPACE MARK

+

+ "\xC2\xAD" => '', // HYPHEN, SOFT => empty string

+ "\xDB\x9D" => '', // ARABIC END OF AYAH

+ "\xDC\x8F" => '', // SYRIAC ABBREVIATION MARK

+ "\xE1\xA0\x86" => '', // MONGOLIAN TODO SOFT HYPHEN

+ "\xE1\xA0\x8E" => '', // MONGOLIAN VOWEL SEPARATOR

+ "\xE2\x80\x8B" => '', // ZERO WIDTH SPACE

+ "\xE2\x80\x8C" => '', // ZERO WIDTH NON-JOINER

+ "\xE2\x80\x8D" => '', // ZERO WIDTH JOINER

+ "\xE2\x80\xA8" => '', // LINE SEPARATOR

+ "\xE2\x80\xA9" => '', // PARAGRAPH SEPARATOR

+ "\xE2\x81\xA0" => '', // WORD JOINER

+ "\xE2\x81\xA1" => '', // FUNCTION APPLICATION

+ "\xE2\x81\xA2" => '', // INVISIBLE TIMES

+ "\xE2\x81\xA3" => '', // INVISIBLE SEPARATOR

+ "\xE2\x81\xAA" => '', // [CONTROL CHARACTERS]

+ "\xE2\x81\xAB" => '', // [CONTROL CHARACTERS]

+ "\xE2\x81\xAC" => '', // [CONTROL CHARACTERS]

+ "\xE2\x81\xAD" => '', // [CONTROL CHARACTERS]

+ "\xE2\x81\xAE" => '', // [CONTROL CHARACTERS]

+ "\xE2\x81\xAF" => '', // [CONTROL CHARACTERS]

+ "\xEF\xBB\xBF" => '', // ZERO WIDTH NO-BREAK SPACE

+ "\xEF\xBF\xB9" => '', // [CONTROL CHARACTERS]

+ "\xEF\xBF\xBA" => '', // [CONTROL CHARACTERS]

+ "\xEF\xBF\xBB" => '', // [CONTROL CHARACTERS]

+ "\xEF\xBF\xBC" => '', // [CONTROL CHARACTERS]

+ "\xF0\x9D\x85\xB3" => '', // [MUSICAL CONTROL CHARACTERS]

+ "\xF0\x9D\x85\xB4" => '', // [MUSICAL CONTROL CHARACTERS]

+ "\xF0\x9D\x85\xB5" => '', // [MUSICAL CONTROL CHARACTERS]

+ "\xF0\x9D\x85\xB6" => '', // [MUSICAL CONTROL CHARACTERS]

+ "\xF0\x9D\x85\xB7" => '', // [MUSICAL CONTROL CHARACTERS]

+ "\xF0\x9D\x85\xB8" => '', // [MUSICAL CONTROL CHARACTERS]

+ "\xF0\x9D\x85\xB9" => '', // [MUSICAL CONTROL CHARACTERS]

+ "\xF0\x9D\x85\xBA" => '', // [MUSICAL CONTROL CHARACTERS]

+);

+

+$copy = $uniarray;

+

+foreach ($array as $value)

+{

+ $temp_hold = implode(array_map('utf8_chr', array_map('hexdec', explode(' ', trim($value[2])))));

+

+ if (isset($copy[utf8_chr(hexdec((string)$value[1]))]))

+ {

+ $num = '';

+ $string = utf8_chr(hexdec((string)$value[1]));

+ for ($i = 0; $i < strlen($string); $i++)

+ {

+ $num .= '\x' . str_pad(base_convert(ord($string[$i]), 10, 16), 2, '0', STR_PAD_LEFT);

+ }

+ echo $num . "\n";

+ if ($uniarray[$string] != $temp_hold)

+ {

+ echo " --> $string\n";

+ echo " --> " . $temp_hold . "\n";

+ }

+ }

+

+ // do some tests for things that transform into something with the number one

+ if (strpos($temp_hold, utf8_chr(0x0031)) !== false)

+ {

+ // any kind of letter L?

+ if (strpos($value[0], 'LETTER L') !== false || strpos($value[0], 'IOTA') !== false || strpos($value[0], 'SMALL L ') !== false || preg_match('/SMALL LIGATURE [^L]*L /', $value[0]))

+ {

+ // replace all of the mappings that transform some sort of letter l to number one instead to some sort of letter l to latin small letter l

+ $temp_hold = str_replace(utf8_chr(0x0031), utf8_chr(0x006C), $temp_hold);

+ }

+ }

+

+ // uppercased chars that were folded do not exist in this universe,

+ // no amount of normalization could ever "trick" this into not working

+ if (in_array($value[1], $casefold_array[1]))

+ {

+ continue;

+ }

+

+ $uniarray[utf8_chr(hexdec((string)$value[1]))] = $temp_hold;

+}

+

+echo "Writing to confusables.$phpEx\n";

+

+$fp = fopen($phpbb_root_path . 'includes/utf/data/confusables.' . $phpEx, 'wb');

+fwrite($fp, '<?php return ' . my_var_export($uniarray) . ';');

+fclose($fp);

+

+/**

+* Return a parsable string representation of a variable

+*

+* This is function is limited to array/strings/integers

+*

+* @param mixed $var Variable

+* @return string PHP code representing the variable

+*/

+function my_var_export($var)

+{

+ if (is_array($var))

+ {

+ $lines = array();

+

+ foreach ($var as $k => $v)

+ {

+ $lines[] = my_var_export($k) . '=>' . my_var_export($v);

+ }

+

+ return 'array(' . implode(',', $lines) . ')';

+ }

+ else if (is_string($var))

+ {

+ return "'" . str_replace(array('\\', "'"), array('\\\\', "\\'"), $var) . "'";

+ }

+ else

+ {

+ return $var;

+ }

+}

+

+/**

+* Download a file to the develop/ dir

+*

+* @param string $url URL of the file to download

+* @return void

+*/

+function download($url)

+{

+ global $phpbb_root_path;

+

+ if (file_exists($phpbb_root_path . 'develop/' . basename($url)))

+ {

+ return;

+ }

+

+ echo 'Downloading from ', $url, ' ';

+

+ if (!$fpr = fopen($url, 'rb'))

+ {

+ die("Can't download from $url\nPlease download it yourself and put it in the develop/ dir, kthxbai");

+ }

+

+ if (!$fpw = fopen($phpbb_root_path . 'develop/' . basename($url), 'wb'))

+ {

+ die("Can't open develop/" . basename($url) . " for output... please check your permissions or something");

+ }

+

+ $i = 0;

+ $chunk = 32768;

+ $done = '';

+

+ while (!feof($fpr))

+ {

+ $i += fwrite($fpw, fread($fpr, $chunk));

+ echo str_repeat("\x08", strlen($done));

+

+ $done = ($i >> 10) . ' KiB';

+ echo $done;

+ }

+ fclose($fpr);

+ fclose($fpw);

+

+ echo "\n";

+}

+

+?> \ No newline at end of file

+<?php

+//

+// This file provides some useful functions for debugging the unicode/UTF-8 library

+// It requires utf_tools.php to be loaded

+//

+die("Please read the first lines of this script for instructions on how to enable it");

+

+if (!headers_sent())

+{

+ header('Content-type: text/html; charset=UTF-8');

+}

+

+/**

+ * Converts unicode escape sequences (\u0123) into UTF-8 characters

+ *

+ * @param string A unicode sequence

+ * @return string UTF-8 representation of the given unicode sequence

+ */

+function unicode_to_utf8($string)

+{

+ $utf8 = '';

+ $chars = array();

+ for ($i = 0; $i < strlen($string); $i++)

+ {

+ if (isset($string[$i + 5]) && substr($string, $i, 2) == '\\u' && ctype_xdigit(substr($string, $i + 2, 4)))

+ {

+ $utf8 .= utf8_from_unicode(array(base_convert(substr($string, $i + 2, 4), 16, 10)));

+ $i += 5;

+ }

+ else

+ {

+ $utf8 .= $string[$i];

+ }

+ }

+ return $utf8;

+}

+

+/**

+ * Takes an array of ints representing the Unicode characters and returns

+ * a UTF-8 string.

+ *

+ * @param array $array array of unicode code points representing a string

+ * @return string UTF-8 character string

+ */

+function utf8_from_unicode($array)

+{

+ $str = '';

+ foreach ($array as $value)

+ {

+ $str .= utf8_chr($value);

+ }

+ return $str;

+}

+

+/**

+* Converts a UTF-8 string to unicode code points

+*

+* @param string $text UTF-8 string

+* @return string Unicode code points

+*/

+function utf8_to_unicode($text)

+{

+ return preg_replace_callback(

+ '#[\\xC2-\\xF4][\\x80-\\xBF]?[\\x80-\\xBF]?[\\x80-\\xBF]#',

+ 'utf8_to_unicode_callback',

+ preg_replace_callback(

+ '#[\\x00-\\x7f]#',

+ 'utf8_to_unicode_callback',

+ $text

+ )

+ );

+}

+

+/**

+* Takes a UTF-8 char and replaces it with its unicode escape sequence. Attention, $m is an array

+*

+* @param array $m 0-based numerically indexed array passed by preg_replace_callback()

+* @return string A unicode escape sequence

+*/

+function utf8_to_unicode_callback($m)

+{

+ return '\u' . str_pad(base_convert(utf8_ord($m[0]), 10, 16), 4, '0', STR_PAD_LEFT) . '';

+}

+

+/**

+* A wrapper function for the normalizer which takes care of including the class if required and modifies the passed strings

+* to be in NFKC

+*

+* @param mixed $strings a string or an array of strings to normalize

+* @return mixed the normalized content, preserving array keys if array given.

+*/

+function utf8_normalize_nfkc($strings)

+{

+ if (empty($strings))

+ {

+ return $strings;

+ }

+

+ if (!class_exists('utf_normalizer'))

+ {

+ global $phpbb_root_path, $phpEx;

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

+ }

+

+ if (!is_array($strings))

+ {

+ utf_normalizer::nfkc($strings);

+ }

+ else if (is_array($strings))

+ {

+ foreach ($strings as $key => $string)

+ {

+ utf_normalizer::nfkc($strings[$key]);

+ }

+ }

+

+ return $strings;

+}

+

+?> \ No newline at end of file

+ <li><a href="#v30rc3">Changes since RC-3</a></li>

+ <a name="v30rc3"></a><b>1.i. Changes since 3.0.RC3</b>

+ <br /><br />

+ <div class="paragraph">

+

+ <p>These fixes/changes are currently only present within CVS and will appear within the next phpBB3 version.</p>

+

+ <ul class="menu">

+ <li>[Fix] Fixing some subsilver2 and prosilver style issues</li>

+ <li>[Fix] Parse error in MCP ban (Bug #13109)</li>

+ <li>[Fix] Correctly hide online status in the profile (Bug #13059)</li>

+ <li>[Feature] Let the user choose how to update modified files (merging, using new file or using old file) within automatic updater</li>

+ <li>[Fix] An extra \ in an Oracle SQL regex was corrected (Bug #13151)</li>

+ <li>[Fix] Added a missing global to get_file() (Bug #13149)</li>

+ <li>[Fix] Hide autologin box when autologin is disabled (Bug #13093)</li>

+ <li>[Fix] Account for the forum id not being part of the request uri in prosilver (Bug #13121)</li>

+ <li>[Fix] Properly alter PostgreSQL tables</li>

+ <li>[Fix] Properly cache template files that were stored in the database (Bug #12675)</li>

+ <li>[Fix] Do not count the deletion of an unapproved topic as a decrease in normally viewable posts (Bug #13167)</li>

+ <li>[Fix] Allow column_exists() to return true if the column exists but no data is in the table</li>

+ <li>[Fix] Allow setting the smiley order via the select. Also allow to add smileys at the top. (Bug #13199)</li>

+ <li>[Fix] Fix php notice on sending jabber messages (Bug #13201)</li>

+ <li>[Fix] Make the window showing file differences a little wider (Bug #13157)</li>

+ <li>[Fix] Preserve preview style on search form (Bug #13205)</li>

+ <li>[Fix] Place attachment filename in new line in posting editor (Bug #9726)</li>

+ <li>[Fix] Don't allow caching to occur in the update sequence (Bug #13207)</li>

+ <li>[Fix] Enforce the max password length for automatically generated password created by the password sender (Bug #13181)</li>

+ <li>[Fix] Handle phpinfo() when expose_php is false (Bug #12777)</li>

+ <li>[Fix] Allow managing of forum roles without global users (Bug #13249)</li>

+ <li>[Change] Do not run cron script if board is disabled</li>

+ <li>[Fix] Correctly destroy sql cache for some query combinations (Bug #13237)</li>

+ <li>[Fix] Allow link forums being password protected (Bug #12967)</li>

+ <li>[Fix] Allow wrapping topic/post icons in posting editor (Bug #12843)</li>

+ <li>[Fix] Display L_RANK only once in template if rank title and image defined (Bug #13231)</li>

+ <li>[Fix] Make sure selected transfer method exists before calling (Bug #13265)</li>

+ <li>[Fix] Correctly escape language keys in language editor (Bug #13279)</li>

+ <li>[Fix] Correctly hide post/reply buttons if permissions are not given (related to Bug #12809)</li>

+ <li>[Fix] Remove orphan/wrong permission entries for non-existent forums - self-repairing permissions if conversions went &quot;crazy&quot;</li>

+ <li>[Feature] Allow &quot;older&quot; updates applied with the automatic updater. This allows people using it for updating, say, from 3.0.0 to 3.0.1 (with the correct package of course) and then from 3.0.1 to 3.0.2 if the latest version at this time is 3.0.2. These changes take effect beginning with RC4 or people replacing install/install_update.php manually prior doing the updates.</li>

+ <li>[Fix] Present correct error message if user tries to edit already read private message (Bug #13271)</li>

+ <li>[Fix] Also display board disabled notice for admins/mods if board got disabled due to exceeding the load limit (Bug #13267)</li>

+ <li>[Fix] Correctly deliver avatar if readfile function has been disabled (Bug #13309)</li>

+ <li>[Fix] Display php information page with the correct direction (Bug #12557)</li>

+ <li>[Fix] Increased the number of style objects (styles, templates, themes and imagesets) possible from 127 to 65535 for MySQL (Bug #13179)</li>

+ <li>[Fix] Although theoretically impossible in our code, removed the chance of trying to open a file that does not exist (Bug #13327)</li>

+ <li>[Fix] Although theoretically impossible in our code, changed the handling of non-existent language files (Bug #13329, #13331)</li>

+ <li>[Fix] Removed extra ampersand from ACP link (Bug #13315)</li>

+ <li>[Fix] used cleaned up version of given field identification for pre-filling a new custom profile field (Bug #13319)</li>

+ <li>[Fix] Correctly convert 2.0 website profile fields. (Bug #13379)</li>

+ <li>[Fix] Fixed the "Alphanumeric" and "Alphanumeric and spacers" username selection limitations (Bug #13391)</li>

+ <li>[Fix] Make sure filelist() is only returning array types (Bug #13385)</li>

+ <li>[Fix] Correctly mark forums read if using cookie based topic tracking (Bug #13245)</li>

+ <li>[Change] Put custom profile fields into top box and signature into separate box in members profile view (Bug #13357)</li>

+ <li>[Fix] Only show moderator log entries for forums the user is having moderation rights in (Bug #12481)</li>

+ <li>[Feature] Show resulting permission alone in trace window (Bug #10952) - thanks to dark/rain for the proposal</li>

+ <li>[Fix] Fixed bug in realpath replacement letting it actually work again</li>

+ <li>[Change] Try to be a bit more specific regarding global/local permission trace (Bug #11032)</li>

+ <li>[Fix] Fixed some strangeness in password validation due to mb_ereg()</li>

+ <li>[Fix] Subforums of a forum would overwrite the latest post information even if they did not contain the latest post (Bug #11931)</li>

+ <li>[Fix] Use global username display function on several places (Bug #11080, #11098) - patch by HoL</li>

+ <li>[Fix] Several viewonline fixes and feature changes. Also displaying the users browser in viewonline list to let the admin easier spot additional search bots, connected to a_user permission (Bug #11088) - patch and suggestions provided by HoL</li>

+ <li>[Change] u_viewprofile permission also affecting viewonline list now</li>

+ <li>[Fix] Do not display return to search link in prosilver if search is not allowed (Bug #11393)</li>

+ <li>[Fix] Use global url validation for img bbcode tag (Bug #11935)</li>

+ <li>[Fix] Added proper unicode support to style names (Bug #12165)</li>

+ <li>[Fix] Search result extract should not end in the middle of a multibyte character (Bug #11863)</li>

+ <li>[Fix] Missing localisation for an imageset no longer triggers a lot of "imageset refreshed" log messages (Bug #12027)</li>

+ <li>[Fix] Explain that themes which need parsing cannot be stored on the filesystem (Bug #11134)</li>

+ <li>[Fix] Normalize usernames</li>

+ <li>[Change] Improved utf8_clean_string with a more complete list of homographs and NFKC normalization</li>

+ <li>[Fix] Fixed error messages that ACP Database can give (Bug #13463)</li>

+ <li>[Fix] Fixed potential issues with databases that use tables names is uppercase</li>

+ <li>[Fix] Handle forum links/redirects within viewforum if no read permission given (to display login box or error message) (Bug #13467)</li>

+ <li>[Fix] Prevent changing postable forum having subforums to link forum without moving subforums out first</li>

+ <li>[Fix] Do not display version in admin template (Bug #13495)</li>

+ <li>[Fix] Allow manual specification of remote avatar dimensions if getimagesize is disabled (Bug #13531)</li>

+ <li>[Fix] Make viewonline use the session page's added forum parameter (Bug #13597)</li>

+ <li>[Fix] Correcting BBCode FAQ (Bug #11180)</li>

+ <li>[Fix] Make to/bcc line in view private message display consistent with other username displays in prosilver (Bug #11989)</li>

+ <li>[Fix] Send out activation email if admin activation is enabled and user activated through inactive users panel upon registration (Bug #12065)</li>

+ <li>[Change] Re-implemented All Yes/No/Never links in permission panels for easier changing all categories at once</li>

+ <li>[Change] Advanced permission link now &quot;marked&quot; if no role is assigned and custom permissions set. With this an admin can instantly see if the object is not set at all or having custom permissions, something you only saw if advanced permissions were viewed before.</li>

+ <li>[Fix] Change misleading custom BBCodes explanation, regarding tokens and useable template variables (Bug #12403, #5660)</li>

+ <li>[Feature] Ability to disable birthdays completely with new board features setting</li>

+ <li>[Fix] Fix disallowed username check (Bug #13511)</li>

+ <li>[Fix] Allow for unicode usernames to be pruned (Bug #13643)</li>

+ <li>[Fix] Do not copy forum permissions from self (Bug #13663)</li>

+ <li>[Fix] Allow for polls to work during preview (Bug #13657) - thanks to Thatbitextra</li>

+ <li>[Fix] Finer error conditions for sending IM messages (Bugs #13681, #13683)</li>

+ <li>[Fix] Add a confirmation for log deletion in the MCP (Bug #13693)</li>

+ <li>[Fix] Do not erase ranks and avatars when changing default groups (Bugs #13701, #13697)</li>

+ <li>[Fix] Limit author searches to firstpost, if selected (Bug #13579)</li>

+ <li>[Fix] Properly resync user post counts for users that have no posts (Bug #13581)</li>

+ <li>[Fix] Do not require space after , in smiley pak files (Bug #13647)</li>

+ <li>[Fix] Properly display the subscribe link in topic and forum display for Oracle (Bug #13583)</li>

+ <li>[Change] Add version number to ACP index (Bug #13703)</li>

+ <li>[Fix] Several fixes for custom profile fields on multi-lingual boards (Bugs #13763, #13527, #13525, #11515)</li>

+ <li>[Fix] Return to the mode previously selected after disaproving a post (Bug #13796)</li>

+ <li>[Fix] Cron now uses a locking variable to make sure it does not spawn too many webserver processes (Bug #12741)</li>

+ <li>[Fix] Cached stylesheet now supporting gzip compression</li>

+ <li>[Fix] Added link to inbox for deleted PMs (Bug #13813)</li>

+ <li>[Fix] Re-syncing the board stats also refreshes the newest user (Bug #13831)</li>

+ <li>[Feature] Ability to externally set $phpbb_root_path if wrapping phpBB3 by defining constant PHPBB_ROOT_PATH</li>

+ <li>[Fix] Implemented correct left/right floating within ACP in regard to RTL languages (Bug #13777)</li>

+ <li>[Fix] Fixing session problems when using MySQL strict mode in conjunction with very long browser agent string (Bug #13827)</li>

+ <li>[Fix] Disallow post/pm subjects entirely made up from non-printable chars and whitespaces (Bug #13800)</li>

+ <li>[Fix] Allow moving private messages from the sentbox (Bug #13791)</li>

+ <li>[Fix] Properly export localized imagesets</li>

+ <li>[Feature] Show the size of Firebird databases</li>

+ <li>[Fix] Show error when moving topic into a category via quickmod (Bug #11611)</li>

+ <li>[Fix] Allow Oracle to install on a database without specify the database name</li>

+

+ </ul>

+

+ </div>

+ <a href="#top">Top</a>

+ <br /><br />

+

+ <hr />

+

+ <a name="v30rc2"></a><b>1.ii. Changes since 3.0.RC2</b>

+ <li>[Fix] Display custom profile field &quot;date&quot; based on users language (Bug #12787)</li>

+ <a name="v30rc1"></a><b>1.iii. Changes since 3.0.RC1</b>

+<p>phpBB categorises gallery avatars and it does this by reading through folders contained in the location you specified as being the gallery path. For example, if you set the gallery path to <samp>images/avatars/gallery</samp> phpBB will expect to find a series of folders within that path, e.g. <samp>images/avatars/gallery/moviestars</samp>, <samp>images/avatars/gallery/cartoons</samp>, <samp>images/avatars/gallery/misc</samp>, etc. Placing images directly in <samp>images/avatars/gallery/</samp> will result in nothing being listed in your gallery.</p>

+<p>If you still have problems try setting the cookie domain to your full domain name, e.g. <samp>www.mysystem.tld</samp>, <samp>www.something.mydomain.tld</samp>. You <strong>must</strong> ensure the domain name contains at least two dots or browsers will be unlikely to recognise the cookie, e.g. <samp>.mydomain.com</samp>, <samp>mydomain.com</samp>. Do <strong>not</strong> add http:// or anything else to the domain name!</p>

+ <li>Your server type/version, e.g. Apache 1.3.28, IIS 4, Sambar, etc.</li>

+ <li>PHP version and mode of operation, e.g. PHP 5.1.1 as a module, PHP 4.4.4 running as CGI, etc.</li>

+ <li>DB type/version, e.g. MySQL 4.0.1, PostgreSQL 7.3.2, MSSQL Server 2000 SP1, etc.</li>

+$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';

+ if (@readfile($file_path) === false)

+ {

+ $fp = @fopen($file_path, 'rb');

+

+ if ($fp !== false)

+ {

+ while (!feof($fp))

+ {

+ echo fread($fp, 8192);

+ }

+ fclose($fp);

+ }

+ }

+

+ else

+ {

+ @readfile($filename);

+ }

+$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';

+ @include($this->cache_dir . 'data_global.' . $phpEx);

+ @include($this->cache_dir . "data{$var_name}.$phpEx");

+ $check_line = @file_get_contents($this->cache_dir . $entry);

+

+ if (empty($check_line))

+ {

+ continue;

+ }

+ // Better catch partial table names than no table names. ;)

+ if (strpos($check_line, $check_table) !== false)

+ $group_name = utf8_normalize_nfc(request_var('group_name', '', true));

+ 'group_name' => utf8_normalize_nfc(request_var('group_name', '', true)),

+ $ban = utf8_normalize_nfc(request_var('ban', '', true));

+ $ban_reason = utf8_normalize_nfc(request_var('banreason', '', true));

+ $ban_give_reason = utf8_normalize_nfc(request_var('bangivereason', '', true));

+ $bbcode_tpl = htmlspecialchars_decode(utf8_normalize_nfc(request_var('bbcode_tpl', '', true)));

+ $bbcode_helpline = utf8_normalize_nfc(request_var('bbcode_helpline', '', true));

+ 'allow_birthdays' => array('lang' => 'ALLOW_BIRTHDAYS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

+ 'load_birthdays' => array('lang' => 'YES_BIRTHDAYS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

+ 'load_birthdays' => array('lang' => 'YES_BIRTHDAYS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

+ 'bot_name' => utf8_normalize_nfc(request_var('bot_name', '', true)),

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

+ if (strlen($table_prefix) === 0 || stripos($table_name, $table_prefix) === 0)

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

+ $disallowed_user = str_replace('*', '%', utf8_normalize_nfc(request_var('disallowed_user', '', true)));

+ $subject = utf8_normalize_nfc(request_var('subject', '', true));

+ $message = utf8_normalize_nfc(request_var('message', '', true));

+ add_log('admin', 'LOG_MASS_EMAIL', implode(', ', utf8_normalize_nfc($usernames)));

+ 'forum_name' => utf8_normalize_nfc(request_var('forum_name', '', true)),

+ 'forum_desc' => utf8_normalize_nfc(request_var('forum_desc', '', true)),

+ 'forum_rules' => utf8_normalize_nfc(request_var('forum_rules', '', true)),

+ if ($forum_perm_from && !empty($forum_perm_from) && $forum_perm_from != $forum_data['forum_id'])

+ 'forum_name' => utf8_normalize_nfc(request_var('forum_name', '', true)),

+ 'S_FORUM_OPTIONS' => make_forum_select(($action == 'add') ? $forum_data['parent_id'] : false, ($action == 'edit') ? $forum_data['forum_id'] : false, false, false, false),

+ // Has subforums and want to change into a link?

+ if ($row['right_id'] - $row['left_id'] > 1 && $forum_data_sql['forum_type'] == FORUM_LINK)

+ {

+ $errors[] = $user->lang['FORUM_WITH_SUBFORUMS_NOT_TO_LINK'];

+ return $errors;

+ }

+

+ $group_name = utf8_normalize_nfc(request_var('group_name', '', true));

+ $group_desc = utf8_normalize_nfc(request_var('group_desc', '', true));

+ $group_name = utf8_normalize_nfc(request_var('group_name', '', true));

+ $add_order_list = '<option value="1">' . $user->lang['FIRST'] . '</option>' . $add_order_list;

+ $image_emotion = utf8_normalize_nfc(request_var('emotion', array('' => ''), true));

+ $image_code = utf8_normalize_nfc(request_var('code', array('' => ''), true));

+ $add_code = utf8_normalize_nfc(request_var('add_code', '', true));

+ $add_emotion = utf8_normalize_nfc(request_var('add_emotion', '', true));

+ if (!empty($image_order[$image]))

+ if ($action == 'modify' && !empty($image_id[$image]))

+ else if ($action !== 'modify')

+ }

+ if (preg_match_all("#'(.*?)', ?#", $pak_entry, $data))

+ if (preg_match_all("#'(.*?)', ?#", $pak_entry, $data))

+ if ($config['require_activation'] == USER_ACTIVATION_ADMIN)

+ {

+ // Get those 'being activated'...

+ $sql = 'SELECT user_id, username, user_email, user_lang

+ FROM ' . USERS_TABLE . '

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

+ AND user_type = ' . USER_INACTIVE;

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

+

+ $inactive_users = array();

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

+ {

+ $inactive_users[] = $row;

+ }

+ $db->sql_freeresult($result);

+ }

+

+

+ if ($config['require_activation'] == USER_ACTIVATION_ADMIN && !empty($inactive_users))

+ {

+ include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

+

+ $messenger = new messenger();

+

+ foreach ($inactive_users as $row)

+ {

+ $messenger->template('admin_welcome_activated', $row['user_lang']);

+

+ $messenger->to($row['user_email'], $row['username']);

+

+ $messenger->headers('X-AntiAbuse: Board servername - ' . $config['server_name']);

+ $messenger->headers('X-AntiAbuse: User_id - ' . $user->data['user_id']);

+ $messenger->headers('X-AntiAbuse: Username - ' . $user->data['username']);

+

+ $messenger->assign_vars(array(

+ 'USERNAME' => htmlspecialchars_decode($row['username']))

+ );

+

+ $messenger->send(NOTIFY_EMAIL);

+ }

+

+ $messenger->save_queue();

+ }

+ if (!class_exists($method))

+ {

+ trigger_error('Method does not exist.', E_USER_ERROR);

+ }

+

+ 'lang_local_name' => utf8_normalize_nfc(request_var('lang_local_name', $row['lang_local_name'], true)),

+ 'lang_author' => utf8_normalize_nfc(request_var('lang_author', $row['lang_author'], true)),

+ $fp = @fopen($phpbb_root_path . $filename, 'wb');

+ $fp = @fopen($phpbb_root_path . $filename, 'rb');

+ if (file_exists($phpbb_root_path . 'store/' . $lang_path . $file))

+ {

+ @unlink($phpbb_root_path . 'store/' . $lang_path . $file);

+ }

+

+ if (file_exists($phpbb_root_path . $store_filename))

+ {

+ @unlink($phpbb_root_path . $store_filename);

+ }

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

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

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

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

+ 'imageset_id' => (int) $imageset_row['imageset_id'],

+ 'image_lang' => (string) $lang_pack['iso'],

+ $entry .= "{$tabs}'" . $this->prepare_lang_entry($key) . "'\t=> '" . $this->prepare_lang_entry($value) . "',\n";

+ $entry .= "\n{$tabs}'" . $this->prepare_lang_entry($key) . "'\t=> array(\n";

+ global $phpbb_root_path, $phpbb_admin_path, $phpEx;

+

+ if (!function_exists('update_last_username'))

+ {

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

+ }

+ update_last_username();

+ $sql = 'SELECT COUNT(p.post_id) AS num_posts, u.user_id

+ FROM ' . USERS_TABLE . ' u

+ LEFT JOIN ' . POSTS_TABLE . ' p ON (u.user_id = p.poster_id AND p.post_postcount = 1)

+ GROUP BY u.user_id';

+ $db->sql_query('UPDATE ' . USERS_TABLE . " SET user_posts = {$row['num_posts']} WHERE user_id = {$row['user_id']}");

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

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

+ 'BOARD_VERSION' => $config['version'],

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

+ if ($module->p_class != $this->module_class)

+ {

+ $module->add_mod_info($this->module_class);

+ }

+

+ 'module_langname' => utf8_normalize_nfc(request_var('module_langname', '', true)),

+ $module_data['module_langname'] = utf8_normalize_nfc(request_var('module_langname', (string) $module_row['module_langname'], true));

+ AND module_id = " . (int) $module_data['parent_id'];

+ AND module_id = " . (int) $module_data['module_id'];

+ AND left_id < " . (int) $from_data['right_id'] . '

+ AND right_id > ' . (int) $from_data['right_id'];

+ AND left_id > " . (int) $from_data['right_id'];

+ AND " . (int) $to_data['right_id'] . ' BETWEEN left_id AND right_id

+ AND left_id > " . (int) $to_data['right_id'] . '

+ $diff = '+ ' . (int) ($row['right_id'] - $from_data['left_id'] + 1);

+ $row['right_id'] = (int) $row['right_id'];

+ $row['left_id'] = (int) $row['left_id'];

+

+ AND parent_id = " . (int) $module_row['parent_id'] . '

+ AND ' . (($action == 'move_up') ? 'right_id < ' . (int) $module_row['right_id'] . ' ORDER BY right_id DESC' : 'left_id > ' . (int) $module_row['left_id'] . ' ORDER BY left_id ASC');

+ $left_id = (int) $target['left_id'];

+ $right_id = (int) $module_row['right_id'];

+ $diff_up = (int) ($module_row['left_id'] - $target['left_id']);

+ $diff_down = (int) ($module_row['right_id'] + 1 - $module_row['left_id']);

+ $move_up_left = (int) $module_row['left_id'];

+ $move_up_right = (int) $module_row['right_id'];

+ $left_id = (int) $module_row['left_id'];

+ $right_id = (int) $target['right_id'];

+ $diff_up = (int) ($module_row['right_id'] + 1 - $module_row['left_id']);

+ $diff_down = (int) ($target['right_id'] - $module_row['right_id']);

+ $move_up_left = (int) ($module_row['right_id'] + 1);

+ $move_up_right = (int) $target['right_id'];

+ $role_name = utf8_normalize_nfc(request_var('role_name', '', true));

+ $role_description = utf8_normalize_nfc(request_var('role_description', '', true));

+ 'role_name' => utf8_normalize_nfc(request_var('role_name', '', true)),

+ 'role_description' => utf8_normalize_nfc(request_var('role_description', '', true)),

+ 'S_PERMISSION_DROPDOWN' => (sizeof($this->permission_dropdown) > 1) ? $this->build_permission_dropdown($this->permission_dropdown, $permission_type, $permission_scope) : false,

+ function build_permission_dropdown($options, $default_option, $permission_scope)

+

+ $l_setting = (isset($user->lang['permission_type'][$permission_scope][$setting])) ? $user->lang['permission_type'][$permission_scope][$setting] : $user->lang['permission_type'][$setting];

+ $s_dropdown_options .= '<option value="' . $setting . '"' . $selected . '>' . $l_setting . '</option>';

+

+ 'S_GLOBAL_TRACE' => ($forum_id) ? false : true,

+

+ 'U_BACK' => ($back) ? build_url(array('f', 'back')) . "&amp;f=$back" : '')

+ $add_key = (($forum_id) ? '_LOCAL' : '');

+

+ $information = $user->lang['TRACE_GROUP_NO' . $add_key];

+ $information = ($total == ACL_YES) ? $user->lang['TRACE_GROUP_YES_TOTAL_YES' . $add_key] : (($total == ACL_NEVER) ? $user->lang['TRACE_GROUP_YES_TOTAL_NEVER' . $add_key] : $user->lang['TRACE_GROUP_YES_TOTAL_NO' . $add_key]);

+ $information = ($total == ACL_YES) ? $user->lang['TRACE_GROUP_NEVER_TOTAL_YES' . $add_key] : (($total == ACL_NEVER) ? $user->lang['TRACE_GROUP_NEVER_TOTAL_NEVER' . $add_key] : $user->lang['TRACE_GROUP_NEVER_TOTAL_NO' . $add_key]);

+ // Get user specific permission... globally or for this forum

+ $information = ($total == ACL_NO) ? $user->lang['TRACE_USER_NO_TOTAL_NO' . $add_key] : $user->lang['TRACE_USER_KEPT' . $add_key];

+ $information = ($total == ACL_YES) ? $user->lang['TRACE_USER_YES_TOTAL_YES' . $add_key] : (($total == ACL_NEVER) ? $user->lang['TRACE_USER_YES_TOTAL_NEVER' . $add_key] : $user->lang['TRACE_USER_YES_TOTAL_NO' . $add_key]);

+ $information = ($total == ACL_YES) ? $user->lang['TRACE_USER_NEVER_TOTAL_YES' . $add_key] : (($total == ACL_NEVER) ? $user->lang['TRACE_USER_NEVER_TOTAL_NEVER' . $add_key] : $user->lang['TRACE_USER_NEVER_TOTAL_NO' . $add_key]);

+ if ($forum_id != 0 && isset($auth->acl_options['global'][$permission]))

+ // If there is no auth information we do not need to worry the user by showing non-relevant data.

+ if ($auth_setting)

+ {

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

+ 'WHO' => sprintf($user->lang['TRACE_GLOBAL_SETTING'], $userdata['username']),

+ 'INFORMATION' => sprintf($information, '<a href="' . $this->u_action . "&amp;u=$user_id&amp;f=0&amp;auth=$permission&amp;back=$forum_id\">", '</a>'),

+ 'S_SETTING_NO' => false,

+ 'S_SETTING_YES' => $auth_setting,

+ 'S_SETTING_NEVER' => !$auth_setting,

+ 'S_TOTAL_NO' => false,

+ 'S_TOTAL_YES' => ($total == ACL_YES) ? true : false,

+ 'S_TOTAL_NEVER' => ($total == ACL_NEVER) ? true : false)

+ );

+ }

+

+ $total = ACL_YES;

+

+ // Total value...

+ $template->assign_vars(array(

+ 'S_RESULT_NO' => ($total == ACL_NO) ? true : false,

+ 'S_RESULT_YES' => ($total == ACL_YES) ? true : false,

+ 'S_RESULT_NEVER' => ($total == ACL_NEVER) ? true : false,

+ ));

+

+ // expose_php can make the image not exist

+ if (preg_match('#<a[^>]*><img[^>]*></a>#', $output))

+ {

+ $output = preg_replace('#<tr class="v"><td>(.*?<a[^>]*><img[^>]*></a>)(.*?)</td></tr>#s', '<tr class="row1"><td><table class="type2"><tr><td>\2</td><td>\1</td></tr></table></td></tr>', $output);

+ }

+ else

+ {

+ $output = preg_replace('#<tr class="v"><td>(.*?)</td></tr>#s', '<tr class="row1"><td><table class="type2"><tr><td>\1</td></tr></table></td></tr>', $output);

+ }

+ 'field_ident' => utf8_clean_string(request_var('field_ident', '', true)),

+ 'lang_name' => utf8_normalize_nfc(request_var('field_ident', '', true)),

+ $cp->vars['field_ident'] = ($action == 'create' && $step == 1) ? utf8_clean_string(request_var('field_ident', $field_row['field_ident'], true)) : request_var('field_ident', $field_row['field_ident']);

+ $cp->vars['lang_name'] = utf8_normalize_nfc(request_var('lang_name', $field_row['lang_name'], true));

+ $cp->vars['lang_explain'] = utf8_normalize_nfc(request_var('lang_explain', $field_row['lang_explain'], true));

+ $cp->vars['lang_default_value'] = utf8_normalize_nfc(request_var('lang_default_value', $field_row['lang_default_value'], true));

+ $options = utf8_normalize_nfc(request_var('lang_options', array(''), true));

+ $options = utf8_normalize_nfc(request_var('lang_options', '', true));

+ $var = utf8_normalize_nfc(request_var($key, $field_row[$key], true));

+ $var = sizeof(explode("\n", utf8_normalize_nfc(request_var('lang_options', '', true))));

+ }

+ else if ($field_type == FIELD_BOOL && $key == 'field_default_value')

+ {

+ // Get the number of options if this key is 'field_maxlen'

+ $var = request_var('field_default_value', 0);

+ $cp->vars[$key] = utf8_normalize_nfc(request_var($key, array(0 => ''), true));

+ $cp->vars[$key] = utf8_normalize_nfc(request_var($key, array(0 => array('')), true));

+ else if ($field_type == FIELD_DATE && $key == 'field_default_value')

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

+ if ($always_now)

+ {

+ $_new_key_ary[$key] = 'now';

+ }

+ else if (isset($_REQUEST['field_default_value_day']))

+ {

+ $cp->vars['field_default_value_day'] = request_var('field_default_value_day', 0);

+ $cp->vars['field_default_value_month'] = request_var('field_default_value_month', 0);

+ $cp->vars['field_default_value_year'] = request_var('field_default_value_year', 0);

+ $_new_key_ary[$key] = sprintf('%2d-%2d-%4d', $cp->vars['field_default_value_day'], $cp->vars['field_default_value_month'], $cp->vars['field_default_value_year']);

+ }

+ }

+ else if ($field_type == FIELD_BOOL && $key == 'l_lang_options' && isset($_REQUEST['l_lang_options']))

+ {

+ $_new_key_ary[$key] = utf8_normalize_nfc(request_var($key, array(array('')), true));

+ $_new_key_ary[$key] = (is_array($_REQUEST[$key])) ? utf8_normalize_nfc(request_var($key, array(''), true)) : utf8_normalize_nfc(request_var($key, '', true));

+ 'L_NEXT_STEP' => (sizeof($this->lang_defs['iso']) == 1) ? $user->lang['SAVE'] : $user->lang['PROFILE_LANG_OPTIONS'])

+ $value = ($action == 'create') ? utf8_normalize_nfc(request_var('l_' . $field, array(0 => ''), true)) : $cp->vars['l_' . $field];

+ $var = (!isset($cp->vars['l_lang_options'][$lang_id]) || !is_array($cp->vars['l_lang_options'][$lang_id])) ? $cp->vars['lang_options'] : $cp->vars['l_lang_options'][$lang_id];

+ $value = ((isset($value[$lang_id])) ? ((is_array($value[$lang_id])) ? implode("\n", $value[$lang_id]) : $value[$lang_id]) : implode("\n", $var));

+ 'FIELD' => '<dd><textarea name="l_' . $field . '[' . $lang_id . ']" rows="7" cols="80">' . $value . '</textarea></dd>'

+ $cp->vars['l_lang_name'] = utf8_normalize_nfc(request_var('l_lang_name', array(0 => ''), true));

+ $cp->vars['l_lang_explain'] = utf8_normalize_nfc(request_var('l_lang_explain', array(0 => ''), true));

+ $cp->vars['l_lang_default_value'] = utf8_normalize_nfc(request_var('l_lang_default_value', array(0 => ''), true));

+

+ $cp->vars['l_lang_options'] = utf8_normalize_nfc(request_var('l_lang_options', array(0 => ''), true));

+ /**

+ * @todo check if this line is correct...

+ */

+ $cp->vars['l_lang_options'] = utf8_normalize_nfc(request_var('l_lang_options', array(0 => array('')), true));

+

+ 'users' => request_var('users', '', true),

+ $rank_title = utf8_normalize_nfc(request_var('title', '', true));

+ sort($img_ary);

+

+ ORDER BY rank_special DESC, rank_min ASC, rank_title ASC';

+ 'reason_title' => utf8_normalize_nfc(request_var('reason_title', '', true)),

+ 'reason_description' => utf8_normalize_nfc(request_var('reason_description', '', true)),

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

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

+ 'imageset_id' => (int) $style_id,

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

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

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

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

+ 'imageset_id' => (int) $style_id,

+ 'image_lang' => (string) $row['lang_dir'],

+ $template_file = utf8_normalize_nfc(request_var('template_file', '', true));

+ if (!($fp = @fopen($file, 'wb')))

+ $theme_file = utf8_normalize_nfc(request_var('template_file', '', true));

+ if (!($fp = @fopen($file, 'wb')))

+ if ($file[0] != '.' && strtoupper($file) != 'CVS' && !is_file($dir . '/' . $file) && !is_link($dir . '/' . $file))

+ end($data);

+

+ $imageset_root = "{$phpbb_root_path}styles/{$style_row['imageset_path']}/imageset/";

+

+ $dh = @opendir($imageset_root);

+ while (($fname = readdir($dh)) !== false)

+ {

+ if ($fname[0] != '.' && $fname != 'CVS' && is_dir("$imageset_root$fname"))

+ {

+ $files[key($files)]['exclude'] .= ',' . $fname . '/imageset.cfg';

+ }

+ }

+ @closedir($dh);

+

+ $imageset_lang = array();

+

+ $sql = 'SELECT image_filename, image_name, image_height, image_width, image_lang

+ FROM ' . STYLES_IMAGESET_DATA_TABLE . "

+ WHERE imageset_id = $style_id

+ AND image_lang <> ''";

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

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

+ {

+ $imageset_lang[$row['image_lang']][$row['image_name']] = $row['image_filename'] . ($row['image_height'] ? '*' . $row['image_height']: '') . ($row['image_width'] ? '*' . $row['image_width']: '');

+ }

+ $db->sql_freeresult($result);

+

+ foreach ($imageset_lang as $lang => $imageset_localized)

+ {

+ $imageset_cfg = str_replace(array('{MODE}', '{NAME}', '{COPYRIGHT}', '{VERSION}'), array($mode, $style_row['imageset_name'], $style_row['imageset_copyright'], $config['version']), $this->imageset_cfg);

+

+ foreach ($this->imageset_keys as $topic => $key_array)

+ {

+ foreach ($key_array as $key)

+ {

+ if (isset($imageset_localized[$key]))

+ {

+ $imageset_cfg .= "\nimg_" . $key . ' = ' . str_replace("styles/{$style_row['imageset_path']}/imageset/", '{PATH}', $imageset_localized[$key]);

+ }

+ }

+ }

+

+ $data[] = array(

+ 'src' => trim($imageset_cfg),

+ 'prefix' => 'imageset/' . $lang . '/imageset.cfg'

+ );

+ }

+

+ $name = utf8_normalize_nfc(request_var('name', '', true));

+ $copyright = utf8_normalize_nfc(request_var('copyright', '', true));

+

+ // themes which have to be parsed have to go into db

+ if ($mode == 'theme')

+ {

+ $cfg = parse_cfg_file("{$phpbb_root_path}styles/" . $style_row["{$mode}_path"] . "/theme/theme.cfg");

+

+ if (isset($cfg['parse_css_file']) && $cfg['parse_css_file'])

+ {

+ $error[] = $user->lang['EDIT_THEME_STORE_PARSED'];

+ $store_db = 1;

+ }

+ }

+ if (!($fp = @fopen("{$phpbb_root_path}styles/$template_path$pathfile$file", 'r')))

+ if ($file[0] == '.')

+ {

+ continue;

+ }

+

+ $mode . '_name' => utf8_normalize_nfc(request_var('name', '', true)),

+ $mode . '_copyright' => utf8_normalize_nfc(request_var('copyright', '', true)),

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

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

+

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

+

+ $ban_reason = utf8_normalize_nfc(request_var('ban_reason', $user->lang[$reason], true));

+ $ban_give_reason = utf8_normalize_nfc(request_var('ban_give_reason', '', true));

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

+ $message = utf8_normalize_nfc(request_var('message', '', true));

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

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

+

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

+

+ 'dateformat' => utf8_normalize_nfc(request_var('dateformat', $user_row['user_dateformat'], true)),

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

+ add_log('admin', 'LOG_ATTACHMENTS_DELETED', implode(', ', $log_attachments));

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

+

+ @reset($content_array);

+ while (list($ug_id, $ug_array) = each($content_array))

+

+ @reset($roles);

+ while (list($role_id, $role_row) = each($roles))

+ if (!$current_role_id && $mode != 'view')

+ {

+ $s_custom_permissions = false;

+

+ foreach ($ug_array as $key => $value)

+ {

+ if ($value['S_NEVER'] || $value['S_YES'])

+ {

+ $s_custom_permissions = true;

+ break;

+ }

+ }

+ }

+ else

+ {

+ $s_custom_permissions = false;

+ }

+

+ 'S_CUSTOM' => $s_custom_permissions,

+ if (!$current_role_id && $mode != 'view')

+ {

+ $s_custom_permissions = false;

+

+ foreach ($forum_array as $key => $value)

+ {

+ if ($value['S_NEVER'] || $value['S_YES'])

+ {

+ $s_custom_permissions = true;

+ break;

+ }

+ }

+ }

+ else

+ {

+ $s_custom_permissions = false;

+ }

+

+ 'S_CUSTOM' => $s_custom_permissions,

+ // If the role is used globally, then reflect that

+ $forum_names = (isset($hold_ary[0])) ? array(0 => '') : array();

+

+ 'auth_option' => (string) $option,

+ $auth_option_ids = array((int)$any_option_id);

+ AND " . $db->sql_in_set('auth_option_id', $auth_option_ids);

+ 'auth_role_id' => (int) $role_id,

+ 'auth_option_id' => (int) $this->option_ids[$flag],

+ // Sometimes, it can happen $hold_ary holding forums which do not exist.

+ // Since this function is not called that often (we are caching the data) we check for this inconsistency.

+ $sql = 'SELECT forum_id

+ FROM ' . FORUMS_TABLE . '

+ WHERE ' . $db->sql_in_set('forum_id', array_keys($hold_ary));

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

+

+ $forum_ids = (isset($hold_ary[0])) ? array(0) : array();

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

+ {

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

+ }

+ $db->sql_freeresult($result);

+

+ // Now determine forums which do not exist and remove the unneeded information (for modding purposes it is clearly the wrong place. ;))

+ $missing_forums = array_diff(array_keys($hold_ary), $forum_ids);

+

+ if (sizeof($missing_forums))

+ {

+ foreach ($missing_forums as $forum_id)

+ {

+ unset($hold_ary[$forum_id]);

+ }

+

+ $sql = 'DELETE FROM ' . ACL_GROUPS_TABLE . ' WHERE ' . $db->sql_in_set('forum_id', $missing_forums);

+ $db->sql_query($sql);

+

+ $sql = 'DELETE FROM ' . ACL_USERS_TABLE . ' WHERE ' . $db->sql_in_set('forum_id', $missing_forums);

+ $db->sql_query($sql);

+ }

+

+ if ((isset($auth) && $auth->acl_get('a_')) || defined('IN_INSTALL') || defined('DEBUG_EXTRA'))

+ preg_match_all('/\'(?:[^\']++|\'\')*+\'|[\d-.]+/', $regs[3], $vals, PREG_PATTERN_ORDER);

+ $bits = array_values(array_diff($bits, array('.')));

+ $_COOKIE[$config['cookie_name'] . '_track'] = (STRIP) ? addslashes(tracking_serialize($tracking_topics)) : tracking_serialize($tracking_topics);

+

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

+ 'forum_id' => (int) $f_id,

+ if (isset($tracking['tf']) && empty($tracking['tf']))

+ {

+ unset($tracking['tf']);

+ }

+

+ $_COOKIE[$config['cookie_name'] . '_track'] = (STRIP) ? addslashes(tracking_serialize($tracking)) : tracking_serialize($tracking);

+

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

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

+ 'mark_time' => ($post_time) ? (int) $post_time : time(),

+ $_COOKIE[$config['cookie_name'] . '_track'] = (STRIP) ? addslashes(tracking_serialize($tracking)) : tracking_serialize($tracking);

+ 'user_id' => (int) $use_user_id,

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

+ $tracking_topics = (isset($_COOKIE[$config['cookie_name'] . '_track'])) ? ((STRIP) ? stripslashes($_COOKIE[$config['cookie_name'] . '_track']) : $_COOKIE[$config['cookie_name'] . '_track']) : '';

+ $tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();

+

+ $pos = utf8_strpos($text, $match[1]);

+ for ($i = $word_indizes[$word], $n = utf8_strlen($text); $i < $n; $i++)

+ $final_text .= '... ' . preg_replace('#^([^ ]*)#', '', utf8_substr($text, $i - $sequence_length, $sequence_length));

+ $final_text .= utf8_substr($text, $final_text_index + 1, $i - $final_text_index - 1);

+ $final_text .= utf8_substr($text, $i, 1);

+ if (utf8_substr($text, $i, 1) == ' ')

+ if (($j > $sequence_length && $word >= $wordnum) || utf8_strlen($final_text) > $length)

+ return (utf8_strlen($text) >= $length + 3) ? utf8_substr($text, 0, $length) . '...' : $text;

+ 'U_VIEWONLINE' => ($auth->acl_gets('u_viewprofile', 'a_user', 'a_useradd', 'a_userdel')) ? append_sid("{$phpbb_root_path}viewonline.$phpEx") : '',

+ 'S_AUTOLOGIN_ENABLED' => ($config['allow_autologin']) ? true : false,

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

+ if (!defined('IN_CRON') && $run_cron && !$config['board_disable'])

+ return $matches;

+ return $matches;

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

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

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

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

+ 'username' => (string) $usernames_ary[$user_id],

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

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

+ 'group_name' => (string) $groupnames_ary[$group_id]

+ // We supress the warning about inappropiate number of passed parameters here due to possible changes within LOG strings from one version to another.

+ $log[$i]['action'] = @vsprintf($log[$i]['action'], $log_data_ary);

+ case 'firebird':

+ global $dbname;

+

+ // if it on the local machine, we can get lucky

+ if (file_exists($dbname))

+ {

+ $database_size = filesize($dbname);

+ }

+

+ break;

+

+class compress

+ $fp = @fopen("{$phpbb_root_path}store/$filename.zip", 'rb');

+ if ($fp)

+ while ($buffer = fread($fp, 1024))

+ {

+ echo $buffer;

+ }

+ fclose($fp);

+ // The end of a tar archive ends in two records of all NULLs (1024 bytes of \0)

+ $fzwrite($this->fp, str_repeat("\0", 1024));

+ $fp = @fopen("{$phpbb_root_path}store/$filename$this->type", 'rb');

+ if ($fp)

+ while ($buffer = fread($fp, 1024))

+ {

+ echo $buffer;

+ }

+ fclose($fp);

+ if ($url === 'http://')

+ {

+ return $url;

+ if (is_numeric($forum_id))

+ $sql = 'SELECT role_id

+ FROM ' . ACL_ROLES_TABLE . "

+ WHERE role_name = 'ROLE_" . $db->sql_escape($acl_list) . "'";

+ $result = $db->sql_query_limit($sql, 1);

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

+ $db->sql_freeresult($result);

+

+ // If we have no role id there is something wrong here

+ if ($row)

+ {

+ $sql = "INSERT INTO $table ($id_field, forum_id, auth_role_id) VALUES ($ug_id, $forum_id, " . $row['role_id'] . ')';

+ $db->sql_query($sql);

+ }

+ $sql_forum = 'AND ' . $db->sql_in_set('a.forum_id', array_map('intval', $forum_id), false, true);

+ FROM ' . GROUPS_TABLE . '

+ WHERE ' . $db->sql_in_set('group_name', array_keys($default_groups));

+ 'group_colour' => (string) $data[0],

+ 'group_legend' => (int) $data[1],

+ 'group_founder_manage' => (int) $data[2]

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

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

+ if ($row['forum_type'] != FORUM_LINK)

+ {

+ $u_viewforum = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']);

+ }

+ else

+ {

+ // If the forum is a link and we count redirects we need to visit it

+ // If the forum is having a password or no read access we do not expose the link, but instead handle it in viewforum

+ if (($row['forum_flags'] & FORUM_FLAG_LINK_TRACK) || $row['forum_password'] || !$auth->acl_get('f_read', $forum_id))

+ {

+ $u_viewforum = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']);

+ }

+ else

+ {

+ $u_viewforum = $row['forum_link'];

+ }

+ }

+

+ 'U_VIEWFORUM' => $u_viewforum,

+ $forum_moderators[$row['forum_id']][] = '<a' . (($row['group_colour']) ? ' style="color:#' . $row['group_colour'] . ';"' : '') . ' href="' . append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&amp;g=' . $row['group_id']) . '">' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</a>';

+ if ($dbms['DRIVER'] != 'sqlite' && $dbms['DRIVER'] != 'oracle' && $dbname === '')

+ $tables = array_map('strtolower', $tables);

+ if (isset($this->features['stream:features'][0]['#']['bind']) || !empty($this->session['tls']))

+ global $config;

+

+ $this->use_queue = (!$config['email_package_size']) ? false : $use_queue;

+ return;

+ ob_start();

+ $smtp->socket = fsockopen($config['smtp_host'], $config['smtp_port'], $errno, $errstr, 20);

+ $error_contents = ob_get_clean();

+

+ if (!$smtp->socket)

+ $err_msg .= ($error_contents) ? '<br /><br />' . htmlspecialchars($error_contents) : '';

+ $this->add_mod_info($this->p_class);

+

+ /**

+ * Add custom MOD info language file

+ */

+ function add_mod_info($module_class)

+ {

+ global $user, $phpEx;

+

+ if (file_exists($user->lang_path . 'mods'))

+ {

+ $add_files = array();

+

+ $dir = @opendir($user->lang_path . 'mods');

+

+ if ($dir)

+ {

+ while (($entry = readdir($dir)) !== false)

+ {

+ if (strpos($entry, 'info_' . strtolower($module_class) . '_') === 0 && substr(strrchr($entry, '.'), 1) == $phpEx)

+ {

+ $add_files[] = 'mods/' . substr(basename($entry), 0, -(strlen($phpEx) + 1));

+ }

+ }

+ closedir($dir);

+ }

+

+ if (sizeof($add_files))

+ {

+ $user->add_lang($add_files);

+ }

+ }

+ }

+ $download_link = append_sid("{$phpbb_root_path}download.$phpEx", 'mode=view&amp;id=' . (int) $attach_row['attach_id'], true, ($attach_row['is_orphan']) ? $user->session_id : false);

+ $sql_data[FORUMS_TABLE] .= 'forum_topics_real = forum_topics_real - 1';

+ $sql_data[FORUMS_TABLE] .= ($data['topic_approved']) ? ', forum_posts = forum_posts - 1, forum_topics = forum_topics - 1' : '';

+ $sql_data[FORUMS_TABLE] = ($data['post_approved']) ? 'forum_posts = forum_posts - 1' : '';

+ $sql_data[FORUMS_TABLE] = ($data['post_approved']) ? 'forum_posts = forum_posts - 1' : '';

+ $sql_data[FORUMS_TABLE] = ($data['post_approved']) ? 'forum_posts = forum_posts - 1' : '';

+ // salvation, a post is found! jam it into the topics table

+ // Committing the transaction before updating search index

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

+

+ // Delete draft if post was loaded...

+ $draft_id = request_var('draft_loaded', 0);

+ if ($draft_id)

+ {

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

+ WHERE draft_id = $draft_id

+ AND user_id = {$user->data['user_id']}";

+ $db->sql_query($sql);

+ }

+

+ !in_array($cur_folder_id, array(PRIVMSGS_NO_BOX, PRIVMSGS_OUTBOX)) && $cur_folder_id != $dest_folder)

+ }

+ else if (in_array($cur_folder_id, array(PRIVMSGS_NO_BOX, PRIVMSGS_OUTBOX)))

+ {

+ trigger_error('CANNOT_MOVE_SPECIAL');

+

+ // Try to cope with previous wrong conversions...

+ if ($user->data['user_unread_privmsg'] < 0)

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . "

+ SET user_unread_privmsg = 0

+ WHERE user_id = $user_id";

+ $db->sql_query($sql);

+

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

+ }

+ var $profile_types = array(FIELD_INT => 'int', FIELD_STRING => 'string', FIELD_TEXT => 'text', FIELD_BOOL => 'bool', FIELD_DROPDOWN => 'dropdown', FIELD_DATE => 'date');

+ 'FIELD_ID' => ($type == FIELD_DATE || ($type == FIELD_BOOL && $row['field_length'] == '1')) ? '' : 'pf_' . $row['field_ident'],

+ return $this->options_lang[$field_id][$lang_id][(int) ($value) + 1];

+ $user_ident = $profile_row['field_ident'];

+ $user_ident = $profile_row['field_ident'];

+ 0 => array('TITLE' => $user->lang['FIELD_TYPE'], 'EXPLAIN' => $user->lang['BOOL_TYPE_EXPLAIN'], 'FIELD' => '<label><input type="radio" class="radio" name="field_length" value="1"' . (($this->vars['field_length'] == 1) ? ' checked="checked"' : '') . ' onchange="document.getElementById(\'add_profile_field\').submit();" /> ' . $user->lang['RADIO_BUTTONS'] . '</label><label><input type="radio" class="radio" name="field_length" value="2"' . (($this->vars['field_length'] == 2) ? ' checked="checked"' : '') . ' onchange="document.getElementById(\'add_profile_field\').submit();" /> ' . $user->lang['CHECKBOX'] . '</label>'),

+ // If the user is inactive and newly registered we assume no posts from this user being there...

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

+ {

+ }

+ else

+ {

+ $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 ' . POSTS_TABLE . '

+ SET post_edit_user = ' . ANONYMOUS . "

+ WHERE post_edit_user = $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

+ // Update the post count for the anonymous user

+ if ($user_row['user_posts'])

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_posts = user_posts + ' . $user_row['user_posts'] . '

+ WHERE user_id = ' . ANONYMOUS;

+ $db->sql_query($sql);

+ }

+ trigger_error('LENGTH_BAN_INVALID');

+ trigger_error('CANNOT_BAN_YOURSELF', E_USER_WARNING);

+ trigger_error('CANNOT_BAN_FOUNDER', E_USER_WARNING);

+ trigger_error('NO_USER_SPECIFIED');

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

+ trigger_error('NO_USERS');

+ $banlist_ary[] = '*';

+ 'ban_start' => (int) $current_time,

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

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

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

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

+ if ((version_compare(PHP_VERSION, '5.1.0', '>=') || (version_compare(PHP_VERSION, '5.0.0-dev', '<=') && version_compare(PHP_VERSION, '4.4.0', '>='))) && @preg_match('/\p{L}/u', 'a') !== false)

+ $regex = '[A-Za-z0-9]+';

+ $regex = '[A-Za-z0-9-[\]_+ ]+';

+ if (preg_match('#^' . $bad_username . '$#', $clean_username))

+ if ((version_compare(PHP_VERSION, '5.1.0', '>=') || (version_compare(PHP_VERSION, '5.0.0-dev', '<=') && version_compare(PHP_VERSION, '4.4.0', '>='))) && @preg_match('/\p{L}/u', 'a') !== false)

+ if (mb_ereg($char, $password) === false)

+ if (($image_data = @getimagesize($data['remotelink'])) === false && (empty($data['width']) || empty($data['height'])))

+ if (!empty($image_data) && ($image_data[0] < 2 || $image_data[1] < 2))

+ if (!empty($image_data) && (!isset($types[$image_data[2]]) || !in_array($extension, $types[$image_data[2]])))

+ group_set_user_default($group_id, $user_ary, $sql_ary, false, true);

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

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

+ 'group_leader' => (int) $leader,

+ 'user_pending' => (int) $pending,

+function group_set_user_default($group_id, $user_id_ary, $group_attributes = false, $update_listing = false, $same_group = false)

+ // If we are about to set an avatar or rank, we will not overwrite with empty, unless we are not actually changing the default group

+ if (!$same_group && (strpos($attribute, 'group_avatar') === 0 || strpos($attribute, 'group_rank') === 0) && !$group_attributes[$attribute])

+ $ban = request_var('ban', '', ($mode === 'user') ? true : false);

+

+ if ($mode === 'user')

+ {

+ $ban = utf8_normalize_nfc($ban);

+ }

+

+ $ban_reason = utf8_normalize_nfc(request_var('banreason', '', true));

+ $ban_give_reason = utf8_normalize_nfc(request_var('bangivereason', '', true));

+ trigger_error('NO_TOPIC_SELECTED');

+ $db->sql_query('UPDATE ' . TOPICS_WATCH_TABLE . ' SET topic_id = ' . (int) $to_topic_id . ' WHERE ' . $db->sql_in_set('topic_id', $topic_ids));

+ $forum_list = get_forum_list('m_');

+ $forum_list = get_forum_list('m_');

+ $forum_list[] = 0;

+

+

+

+ if (!in_array($forum_id, $forum_list))

+ {

+ trigger_error('NOT_AUTHORISED');

+ }

+

+ $forum_list = array($forum_id);

+

+ $sql = 'SELECT forum_id

+ FROM ' . TOPICS_TABLE . '

+ WHERE topic_id = ' . $topic_id;

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

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

+ $db->sql_freeresult($result);

+

+ if (!in_array($forum_id, $forum_list))

+ {

+ trigger_error('NOT_AUTHORISED');

+ }

+

+ $forum_list = array($forum_id);

+ if (confirm_box(true))

+ if ($deletemark && sizeof($marked))

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

+ WHERE log_type = ' . LOG_MOD . '

+ AND ' . $db->sql_in_set('forum_id', $forum_list) . '

+ AND ' . $db->sql_in_set('log_id', $marked);

+ $db->sql_query($sql);

+

+ add_log('admin', 'LOG_CLEAR_MOD');

+ else if ($deleteall)

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

+ WHERE log_type = ' . LOG_MOD . '

+ AND ' . $db->sql_in_set('forum_id', $forum_list);

+

+ if ($mode == 'topic_logs')

+ $sql .= ' AND topic_id = ' . $topic_id;

+ $db->sql_query($sql);

+ add_log('admin', 'LOG_CLEAR_MOD');

+ else

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(

+ 'f' => $forum_id,

+ 't' => $topic_id,

+ 'start' => $start,

+ 'delmarked' => $deletemark,

+ 'delall' => $deleteall,

+ 'mark' => $marked,

+ 'st' => $sort_days,

+ 'sk' => $sort_key,

+ 'sd' => $sort_dir,

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => request_var('action', array('' => ''))))

+ );

+ view_log('mod', $log_data, $log_count, $config['topics_per_page'], $start, $forum_list, $topic_id, 0, $sql_where, $sql_sort);

+ else if (isset($_POST['confirm']))

+ {

+ $additional_msg = $user->lang['FORUM_NOT_EXIST'];

+ }

+ unset($_REQUEST['confirm_key']);

+ else if (isset($_POST['confirm']))

+ {

+ $additional_msg = $user->lang['FORUM_NOT_EXIST'];

+ }

+ if ($additional_msg)

+ unset($_REQUEST['confirm_key']);

+ 'topic_id' => (int) $new_topic_id,

+ 'user_id' => (int) $row['user_id'],

+ 'notify_status' => (int) $row['notify_status'],

+ trigger_error('NO_USER');

+ $usernote = utf8_normalize_nfc(request_var('usernote', '', true));