*~

<project name="phpBB" description="The phpBB forum software" default="all" basedir="../">

<!-- a few settings for the build -->

<!-- no configuration should be needed beyond this point -->

<property name="oldversions" value="${olderversions}, ${prevversion}" />

--coverage-clover build/logs/clover.xml

--coverage-html build/coverage"

passthru="true" />

</target>

<target name="docs">

-->

<target name="export">

<exec dir="phpBB"

checkreturn="true" />

<delete file="${dir}/config.php" />

<delete dir="${dir}/develop" />

<echo msg="Setting permissions for checkout of ${revision} in ${dir}" />

<!-- set permissions of all files to 644, directories to 755 -->

<!-- set permissions of some directories to 777 -->

<chmod mode="0777" file="${dir}/cache" />

<chmod mode="0777" file="${dir}/store" />

}

// Is binary?

{

$binary[] = trim($match[1]);

}

</fieldset>

</form>

<!-- ENDIF -->

<!-- INCLUDE overall_footer.html -->

<dt><label for="parent">{L_FORUM_PARENT}:</label></dt>

<dd><select id="parent" name="forum_parent_id"><option value="0"<!-- IF not S_FORUM_PARENT_ID --> selected="selected"<!-- ENDIF -->>{L_NO_PARENT}</option>{S_PARENT_OPTIONS}</select></dd>

</dl>

<dl>

<dt><label for="forum_name">{L_FORUM_NAME}:</label></dt>

<dd><input class="text medium" type="text" id="forum_name" name="forum_name" value="{FORUM_NAME}" maxlength="255" /></dd>

</dl>

<dl>

<dt><label for="forum_password">{L_FORUM_PASSWORD}:</label><br /><span>{L_FORUM_PASSWORD_EXPLAIN}</span></dt>

</dl>

<dl>

<dt><label for="forum_password_confirm">{L_FORUM_PASSWORD_CONFIRM}:</label><br /><span>{L_FORUM_PASSWORD_CONFIRM_EXPLAIN}</span></dt>

</dl>

<!-- IF S_FORUM_PASSWORD_SET -->

<dl>

<dt><label for="forum_style">{L_FORUM_STYLE}:</label></dt>

<dd><select id="forum_style" name="forum_style"><option value="0">{L_DEFAULT_STYLE}</option>{S_STYLES_OPTIONS}</select></dd>

</dl>

</fieldset>

<div id="forum_cat_options">

<dd><input type="checkbox" class="radio" id="field_show_on_reg" name="field_show_on_reg" value="1"<!-- IF S_SHOW_ON_REG --> checked="checked"<!-- ENDIF --> /></dd>

</dl>

<dl>

<dt><label for="field_show_on_vt">{L_DISPLAY_ON_VT}:</label><br /><span>{L_DISPLAY_ON_VT_EXPLAIN}</span></dt>

<dd><input type="checkbox" class="radio" id="field_show_on_vt" name="field_show_on_vt" value="1"<!-- IF S_SHOW_ON_VT --> checked="checked"<!-- ENDIF --> /></dd>

</dl>

</dl>

<dl>

<dt><label for="special_rank">{L_RANK_SPECIAL}:</label></dt>

<label><input onclick="dE('posts', 1)" type="radio" class="radio" name="special_rank" value="0"<!-- IF not S_SPECIAL_RANK --> checked="checked"<!-- ENDIF --> /> {L_NO}</label></dd>

</dl>

<!-- IF S_SPECIAL_RANK --><div id="posts" style="display: none;"><!-- ELSE --><div id="posts"><!-- ENDIF -->

</dl>

<dl>

<dt><label for="user_email">{L_EMAIL}:</label></dt>

</dl>

<dl>

<dt><label for="email_confirm">{L_CONFIRM_EMAIL}:</label><br /><span>{L_CONFIRM_EMAIL_EXPLAIN}</span></dt>

</dl>

<dl>

<dt><label for="new_password">{L_NEW_PASSWORD}:</label><br /><span>{L_CHANGE_PASSWORD_EXPLAIN}</span></dt>

</dl>

<dl>

<dt><label for="password_confirm">{L_CONFIRM_PASSWORD}:</label><br /><span>{L_CONFIRM_PASSWORD_EXPLAIN}</span></dt>

</dl>

<p class="quick">

w: '{LA_BBCODE_W_HELP}',

s: '{LA_BBCODE_S_HELP}',

f: '{LA_BBCODE_F_HELP}',

d: '{LA_BBCODE_D_HELP}',

tip: '{L_STYLES_TIP}'

<!-- BEGIN custom_tags -->

,cb_{custom_tags.BBCODE_ID}: '{custom_tags.A_BBCODE_HELPLINE}'

<input type="button" class="button2" accesskey="c" name="addbbcode8" value="Code" style="width: 40px" onclick="bbstyle(8)" onmouseover="helpline('c')" onmouseout="helpline('tip')" />

<input type="button" class="button2" accesskey="l" name="addbbcode10" value="List" style="width: 40px" onclick="bbstyle(10)" onmouseover="helpline('l')" onmouseout="helpline('tip')" />

<input type="button" class="button2" accesskey="o" name="addbbcode12" value="List=" style="width: 40px" onclick="bbstyle(12)" onmouseover="helpline('o')" onmouseout="helpline('tip')" />

<!-- IF S_BBCODE_IMG -->

<input type="button" class="button2" accesskey="p" name="addbbcode14" value="Img" style="width: 40px" onclick="bbstyle(14)" onmouseover="helpline('p')" onmouseout="helpline('tip')" />

<!-- ENDIF -->

<head>

<title>{L_COLOUR_SWATCH}</title>

<style type="text/css">

</div>

<div id="page-footer">

</div>

</div>

<head>

<!-- IF META -->{META}<!-- ENDIF -->

<title>{PAGE_TITLE}</title>

<head>

<!-- IF META -->{META}<!-- ENDIF -->

<title>{PAGE_TITLE}</title>

<div id="page-footer">

<!-- IF S_COPYRIGHT_HTML -->

<!-- IF TRANSLATION_INFO --><br />{TRANSLATION_INFO}<!-- ENDIF -->

<!-- ENDIF -->

<head>

<!-- IF META -->{META}<!-- ENDIF -->

<title>{PAGE_TITLE}</title>

<div id="page-footer">

<!-- IF S_COPYRIGHT_HTML -->

<!-- IF TRANSLATION_INFO --><br />{TRANSLATION_INFO}<!-- ENDIF -->

<!-- ENDIF -->

<head>

<!-- IF META -->{META}<!-- ENDIF -->

<title>{PAGE_TITLE}</title>

* @copyright (c) 2005 phpBB Group

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

*

*/

/**

exit;

}

if (file_exists($phpbb_root_path . 'config.' . $phpEx))

{

// Write columns one by one...

foreach ($table_data['COLUMNS'] as $column_name => $column_data)

{

// Get type

if (strpos($column_data[0], ':') !== false)

{

$key_data[1] = array($key_data[1]);

}

switch ($dbms)

{

case 'mysql_40':

),

);

$schema_data['phpbb_moderator_cache'] = array(

'COLUMNS' => array(

'forum_id' => array('UINT', 0),

'field_validation' => array('VCHAR_UNI:20', ''),

'field_required' => array('BOOL', 0),

'field_show_on_reg' => array('BOOL', 0),

'field_show_on_vt' => array('BOOL', 0),

'field_show_profile' => array('BOOL', 0),

'field_hide' => array('BOOL', 0),

fclose($fp);

$html_skeleton = '

<html>

<head>

<link rel="stylesheet" href="subSilver.css" type="text/css">

$html_skeleton .= '

<br><br>

<br clear="all" /></td>

</tr>

$fp = fopen($store_dir . 'index.html', 'w');

$html_data = '

<html>

<head>

<link rel="stylesheet" href="subSilver.css" type="text/css">

$html_data .= '

</ol><br><br>

<br clear="all" /></td>

</tr>

$fp = fopen($store_dir . 'lang_index.html', 'w');

$html_data = '

<html>

<head>

<link rel="stylesheet" href="subSilver.css" type="text/css">

$html_data .= '

<br><br>

<br clear="all" /></td>

</tr>

// Do we now need to re-add the fulltext index? ;)

if ($table_name == ($prefix . 'posts') && $drop_index)

{

}

}

phpBB Lead Developer: naderman (Nils Adermann)

phpBB Developers: Acyd Burn (Meik Sievertsen) [Lead 09/2005 - 01/2010]

bantu (Andreas Fischer)

ckwalsh (Cullen Walsh)

igorw (Igor Wiedler)

kellanved (Henry Sudhof)

nickvergessen (Joas Schilling)

rxu (Ruslan Uzdenov)

ToonArmy (Chris Smith)

phpBB Lead Developer: psoTFX (Paul S. Owen) [2001 - 09/2005]

phpBB Developers: A_Jelly_Doughnut (Josh Woody) [01/2010 - 11/2010]

Ashe (Ludovic Arnaud) [10/2002 - 11/2003, 06/2006 - 10/2006]

BartVB (Bart van Bragt) [11/2000 - 03/2006]

DavidMJ (David M.) [12/2005 - 08/2009]

<head>

<meta name="keywords" content="" />

<meta name="description" content="phpBB 3.0.x Changelog" />

<title>phpBB3 &bull; Changelog</title>

<ol>

<li><a href="#changelog">Changelog</a>

<ol style="list-style-type: lower-roman;">

<li><a href="#v307-PL1">Changes since 3.0.7-PL1</a></li>

<li><a href="#v307">Changes since 3.0.7</a></li>

<li><a href="#v306">Changes since 3.0.6</a></li>

<div class="content">

<h4> Security

</h4>

<ul>

</ul>

<ul>

<li>[Sec] Do not expose forum content of forums with ACL entries but no actual permission in ATOM Feeds. (Bug #58595)</li>

</ul>

<ul>

<li>[Fix] Allow ban reason and length to be selected and copied in ACP and subsilver2 MCP. (Bug #51095)</li>

</ul>

<ul>

<li>[Fix] Allow whitespaces in avatar gallery names. (Bug #44955)</li>

<li>[Feature] Send anonymous statistical information to phpBB on installation and update (optional).</li>

</ul>

<ul>

<li>[Fix] Delete user entry from ban list table upon user deletion (Bug #40015 - Patch by TerraFrost)</li>

<li>[Sec] Only use forum id supplied for posting if global announcement detected. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Allow mixed-case template directories to be inherited (Bug #36725)</li>

<li>[Sec] Ask for forum password if post within passworded forum quoted in private message. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Correctly set topic starter if first post in topic removed (Bug #30575 - Patch by blueray2048)</li>

<li>[Sec Precaution] Stricter validation of the HTTP_HOST header (Thanks to Techie-Micheal et al for pointing out possible issues in derived code)</li>

</ul>

<ul>

<li>[Fix] Ability to set permissions on non-mysql dbms (Bug #24955)</li>

<li>[Sec] Only allow urls gone through redirect() being used within login_box(). (thanks nookieman)</li>

</ul>

<ul>

<li>[Change] Validate birthdays (Bug #15004)</li>

<li>[Fix] Find and display colliding usernames correctly when converting from one database to another (Bug #23925)</li>

</ul>

<ul>

<li>[Fix] Cleaned usernames contain only single spaces, so &quot;a_name&quot; and &quot;a__name&quot; are treated as the same name (Bug #15634)</li>

<li>[Fix] Call garbage_collection() within database updater to correctly close connections (affects Oracle for example)</li>

</ul>

<ul>

<li>[Fix] Fixed MSSQL related bug in the update system</li>

<li>[Fix] No duplication of active topics (Bug #15474)</li>

</ul>

<ul>

<li>[Fix] Submitting language changes using acp_language (Bug #14736)</li>

<li>[Fix] Able to request new password (Bug #14743)</li>

</ul>

<ul>

<li>[Feature] Removing constant PHPBB_EMBEDDED in favor of using an exit_handler(); the constant was meant to achive this more or less.</li>

<li>[Sec] New password hashing mechanism for storing passwords (#i42)</li>

</ul>

<ul>

<li>[Fix] MySQL, PostgreSQL and SQLite related database fixes (Bug #13862)</li>

<li>[Fix] odbc_autocommit causing existing result sets to be dropped (Bug #14182)</li>

</ul>

<ul>

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

</ul>

<ul>

<li>[Fix] Re-allow searching within the memberlist</li>

</ul>

<ul>

<li>[Fix] (X)HTML issues within the templates (Bug #11255, #11255)</li>

<head>

<meta name="keywords" content="" />

<meta name="description" content="phpBB 3.0.x frequently asked questions" />

<title>phpBB3 &bull; FAQ</title>

<head>

<meta name="keywords" content="" />

<meta name="description" content="phpBB 3.0.x Installation, updating and conversion informations" />

<title>phpBB3 &bull; Install</title>

<li>Oracle</li>

</ul>

</li>

<li>getimagesize() function need to be enabled.</li>

<li>These optional presence of the following modules within PHP will provide access to additional features, but they are not required.

<ul>

<p>This package is meant for those wanting to only replace changed files from a previous version to the latest version. This package normally contains the changed files from up to five previous versions.</p>

<p>The directory structure has been preserved enabling you (if you wish) to simply upload the contents of the archive to the appropriate location on your server, i.e. simply overwrite the existing files with the new versions. Do not forget that if you have installed any MODs these files will overwrite the originals possibly destroying them in the process. You will need to re-add MODs to any affected file before uploading.</p>

<p>The patch file is one solution for those with many Modifications (MODs) or other changes who do not want to re-add them back to all the changed files if they use the method explained above. To use this you will need command line access to a standard UNIX type <strong>patch</strong> application. If you do not have access to such an application but still want to use this update approach, we strongly recommend the <a href="#update_auto">Automatic update package</a> explained below. It is also the recommended update method.</p>

<p>If you do get failures you should look at using the <a href="#update_files">Changed files only</a> package to replace the files which failed to patch, please note that you will need to manually re-add any Modifications (MODs) to these particular files. Alternatively if you know how you can examine the .rej files to determine what failed where and make manual adjustments to the relevant source.</p>

<head>

<meta name="keywords" content="" />

<meta name="description" content="phpBB 3.0.x Readme" />

<title>phpBB3 &bull; Readme</title>

<div class="content">

<p>Please remember that running any application on a developmental version of PHP can lead to strange/unexpected results which may appear to be bugs in the application (which may not be true). Therefore we recommend you upgrade to the newest stable version of PHP before running phpBB3. If you are running a developmental version of PHP please check any bugs you find on a system running a stable release before submitting.</p>

<a name="phpsec"></a><h3>7.i. Notice on PHP security issues</h3>

<head>

<meta name="keywords" content="" />

<meta name="description" content="This is an explanation of how to use the phpBB auth/acl API" />

<title>phpBB3 &bull; Auth API</title>

<head>

<meta name="keywords" content="" />

<meta name="description" content="Olympus coding guidelines document" />

<title>phpBB3 &bull; Coding Guidelines</title>

<p>With phpBB3, the output encoding for the forum in now UTF-8, a Universal Character Encoding by the Unicode Consortium that is by design a superset to US-ASCII and ISO-8859-1. By using one character set which simultaenously supports all scripts which previously would have required different encodings (eg: ISO-8859-1 to ISO-8859-15 (Latin, Greek, Cyrillic, Thai, Hebrew, Arabic); GB2312 (Simplified Chinese); Big5 (Traditional Chinese), EUC-JP (Japanese), EUC-KR (Korean), VISCII (Vietnamese); et cetera), this removes the need to convert between encodings and improves the accessibility of multilingual forums.</p>

<h4>Language Tag:</h4>

<p>Most language tags consist of a two- or three-letter language subtag (from <a href="http://www.loc.gov/standards/iso639-2/php/English_list.php">ISO 639-1/ISO 639-2</a>). Sometimes, this is followed by a two-letter or three-digit region subtag (from <a href="http://www.iso.ch/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html">ISO 3166-1 alpha-2</a> or <a href="http://unstats.un.org/unsd/methods/m49/m49.htm">UN M.49</a>). Some examples are:</p>

<thead>

<tr>

<th scope="col">Language tag</th>

<p>Next is the <a href="http://www.unicode.org/iso15924/iso15924-codes.html">ISO 15924</a> language script code and when one should or shouldn't use it. For example, whilst <code>en-Latn</code> is syntaxically correct for describing English written with Latin script, real world English writing is <strong>more-or-less exclusively in the Latin script</strong>. For such languages like English that are written in a single script, the <a href="http://www.iana.org/assignments/language-subtag-registry"><abbr title="Internet Assigned Numbers Authority">IANA</abbr> Language Subtag Registry</a> has a "Suppress-Script" field meaning the script code <strong>should be ommitted</strong> unless a specific language tag requires a specific script code. Some languages are <strong>written in more than one script</strong> and in such cases, the script code <strong>is encouraged</strong> since an end-user may be able to read their language in one script, but not the other. Some examples are:</p>

<thead>

<tr>

<th scope="col">Language tag</th>

<p>Examples of English using marco-geographical regions:</p>

<thead>

<tr>

<th scope="col">ISO 639-1/ISO 639-2 + ISO 3166-1 alpha-2</th>

<p>Examples of Spanish using marco-geographical regions:</p>

<thead>

<tr>

<th scope="col">ISO 639-1/ISO 639-2 + ISO 3166-1 alpha-2</th>

<p>Example of where the <a href="http://www.iso.ch/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html">ISO 3166-1 alpha-2</a> is ambiguous and why <a href="http://unstats.un.org/unsd/methods/m49/m49.htm">UN M.49</a> might be preferred:</p>

<caption>Coding for ambiguous ISO 3166-1 alpha-2 regions</caption>

<thead>

<tr>

<p><a href="http://tools.ietf.org/html/rfc4646">RFC 4646</a> anticipates features which shall be available in (currently draft) <a href="http://www.sil.org/iso639-3/">ISO 639-3</a> which aims to provide as complete enumeration of languages as possible, including living, extinct, ancient and constructed languages, whether majour, minor or unwritten. A new feature of <a href="http://www.sil.org/iso639-3/">ISO 639-3</a> compared to the previous two revisions is the concept of <a href="http://www.sil.org/iso639-3/macrolanguages.asp">macrolanguages</a> where Arabic and Chinese are two such examples. In such cases, their respective codes of <code>ar</code> and <code>zh</code> is very vague as to which dialect/topolect is used or perhaps some terse classical variant which may be difficult for all but very educated users. For such macrolanguages, it is recommended that the sub-language tag is used as a suffix to the macrolanguage tag, eg:</p>

<caption>Macrolanguage subtag + sub-language subtag examples</caption>

<thead>

<tr>

<p>For phpBB, the language tags are <strong>not</strong> used in their raw form and instead converted to all lower-case and have the hyphen <code>-</code> replaced with an underscore <code>_</code> where appropriate, with some examples below:</p>

<caption>Language tag normalisation examples</caption>

<thead>

<tr>

<p>For the English language description, the language name is always first and any additional attributes required to describe the subtags within the language code are then listed in order separated with commas and enclosed within parentheses, eg:</p>

<caption>English language description examples for iso.txt</caption>

<thead>

<tr>

<p>The various Unicode control characters for bi-directional text and their HTML enquivalents where appropriate are as follows:</p>

<caption>Unicode bidirectional control characters &amp; HTML elements/entities</caption>

<thead>

<tr>

<p>For <code>iso.txt</code>, the directionality of the text can be explicitly set using special Unicode characters via any of the three methods provided by left-to-right/right-to-left markers/embeds/overrides, as without them, the ordering of characters will be incorrect, eg:</p>

<caption>Unicode bidirectional control characters iso.txt</caption>

<thead>

<tr>

<div class="codebox"><pre>

...

Visit &quot;Downloads&quot; at &lt;a href=&quot;http://www.php.net/&quot;&gt;www.php.net&lt;/a&gt;.',

...

</pre></div>

<div class="codebox"><pre>

...

Visit &amp;quot;Downloads&amp;quot; at &lt;a href=&quot;http://www.php.net/&quot;&gt;www.php.net&lt;/a&gt;.',

...

</pre></div>

<div class="codebox"><pre>

...

Visit &ldquo;Downloads&rdquo; at &lt;a href=&quot;http://www.php.net/&quot;&gt;www.php.net&lt;/a&gt;.',

...

</pre></div>

<head>

<meta name="keywords" content="" />

<meta name="description" content="Hook System explanation" />

<title>phpBB3 &bull; Hook System</title>

if (isset($_GET['avatar']))

{

require($phpbb_root_path . 'config.' . $phpEx);

if (!defined('PHPBB_INSTALLED') || empty($dbms) || empty($acm_type))

$l_title = 'ACP_ORPHAN_ATTACHMENTS';

break;

default:

trigger_error('NO_MODE', E_USER_ERROR);

break;

$db->sql_freeresult($result);

break;

}

if (sizeof($error))

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

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

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

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

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

'legend3' => 'CUSTOM_PROFILE_FIELDS',

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

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

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

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

'chg_passforce' => array('lang' => 'FORCE_PASS_CHANGE', 'validate' => 'int:0', 'type' => 'text:3:3', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

'max_login_attempts' => array('lang' => 'MAX_LOGIN_ATTEMPTS', 'validate' => 'int:0', 'type' => 'text:3:3', 'explain' => true),

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

'form_token_lifetime' => array('lang' => 'FORM_TIME_MAX', 'validate' => 'int:-1', 'type' => 'text:5:5', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

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

{

global $user, $config;

if ($config['email_enable'])

{

}

}

/**

'PAGINATION' => generate_pagination($this->u_action . "&amp;$u_sort_param&amp;users_per_page=$per_page", $inactive_count, $per_page, $start, true),

'USERS_PER_PAGE' => $per_page,

));

$this->tpl_name = 'acp_inactive';

// Grab log data

$log_data = array();

$log_count = 0;

$template->assign_vars(array(

'L_TITLE' => $l_title,

'L_EXPLAIN' => $l_title_explain,

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

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

{

$latest_version_info = explode("\n", $latest_version_info);

$template->assign_vars(array(

));

}

'U_ADMIN_LOG' => append_sid("{$phpbb_admin_path}index.$phpEx", 'i=logs&amp;mode=admin'),

'U_INACTIVE_USERS' => append_sid("{$phpbb_admin_path}index.$phpEx", 'i=inactive&amp;mode=list'),

'U_VERSIONCHECK' => append_sid("{$phpbb_admin_path}index.$phpEx", 'i=update&amp;mode=version_check'),

'S_ACTION_OPTIONS' => ($auth->acl_get('a_board')) ? true : false,

'S_FOUNDER' => ($user->data['user_type'] == USER_FOUNDER) ? true : false,

$output = preg_replace('#<img border="0"#i', '<img', $output);

$output = str_replace(array('class="e"', 'class="v"', 'class="h"', '<hr />', '<font', '</font>'), array('class="row1"', 'class="row2"', '', '', '<span', '</span>'), $output);

if (empty($output))

{

trigger_error('NO_PHPINFO_AVAILABLE', E_USER_WARNING);

$template->assign_var('PHPINFO', $output);

}

}

'field_show_profile'=> 0,

'field_no_view' => 0,

'field_show_on_reg' => 0,

'field_show_on_vt' => 0,

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

'lang_explain' => '',

// $exclude contains the data we gather in each step

$exclude = array(

2 => array('field_length', 'field_maxlen', 'field_minlen', 'field_validation', 'field_novalue', 'field_default_value'),

3 => array('l_lang_name', 'l_lang_explain', 'l_lang_default_value', 'l_lang_options')

);

$visibility_ary = array(

'field_required',

'field_show_on_reg',

'field_show_on_vt',

'field_show_profile',

'field_hide',

'S_STEP_ONE' => true,

'S_FIELD_REQUIRED' => ($cp->vars['field_required']) ? true : false,

'S_SHOW_ON_REG' => ($cp->vars['field_show_on_reg']) ? true : false,

'S_SHOW_ON_VT' => ($cp->vars['field_show_on_vt']) ? true : false,

'S_FIELD_HIDE' => ($cp->vars['field_hide']) ? true : false,

'S_SHOW_PROFILE' => ($cp->vars['field_show_profile']) ? true : false,

'field_validation' => $cp->vars['field_validation'],

'field_required' => $cp->vars['field_required'],

'field_show_on_reg' => $cp->vars['field_show_on_reg'],

'field_show_on_vt' => $cp->vars['field_show_on_vt'],

'field_hide' => $cp->vars['field_hide'],

'field_show_profile' => $cp->vars['field_show_profile'],

exit;

}

/**

* @package acp

*/

function main($id, $mode)

{

$collect_url = "http://www.phpbb.com/stats/receive_stats.php";

$bitfield->set(9);

$bitfield->set(11);

$bitfield->set(12);

unset($bitfield);

$user->add_lang('acp/styles');

$db->sql_transaction('commit');

$cache->destroy('sql', STYLES_IMAGESET_DATA_TABLE);

add_log('admin', 'LOG_IMAGESET_REFRESHED', $imageset_row['imageset_name']);

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

}

else

{

}

// We set a pre-defined bitfield here which we may use further in 3.2

$current_version = (!empty($version_update_from)) ? $version_update_from : $config['version'];

$template->assign_vars(array(

'S_VERSION_CHECK' => true,

'U_ACTION' => $this->u_action,

'U_VERSIONCHECK_FORCE' => append_sid($this->u_action . '&amp;versioncheck_force=1'),

// Grab log data

$log_data = array();

$log_count = 0;

$template->assign_vars(array(

'S_FEEDBACK' => true,

'attach' => array('title' => 'ACP_ATTACHMENT_SETTINGS', 'auth' => 'acl_a_attach', 'cat' => array('ACP_BOARD_CONFIGURATION', 'ACP_ATTACHMENTS')),

'extensions' => array('title' => 'ACP_MANAGE_EXTENSIONS', 'auth' => 'acl_a_attach', 'cat' => array('ACP_ATTACHMENTS')),

'ext_groups' => array('title' => 'ACP_EXTENSION_GROUPS', 'auth' => 'acl_a_attach', 'cat' => array('ACP_ATTACHMENTS')),

),

);

}

/**

* Get permission listing based on user_id/options/forum_ids

*/

function acl_get_list($user_id = false, $opts = false, $forum_id = false)

{

$method = 'login_' . $method;

if (function_exists($method))

{

// If the auth module wants us to create an empty profile do so and then treat the status as LOGIN_SUCCESS

if ($login['status'] == LOGIN_SUCCESS_CREATE_PROFILE)

/**

* Login function

*/

{

global $db, $config;

global $request;

);

}

$sql = 'SELECT user_id, username, user_password, user_passchg, user_pass_convert, user_email, user_type, user_login_attempts

FROM ' . USERS_TABLE . "

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

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

$db->sql_freeresult($result);

if (!$row)

{

return array(

'user_row' => array('user_id' => ANONYMOUS),

);

}

// If there are too much login attempts, we need to check for an confirm image

// Every auth module is able to define what to do by itself...

$row['user_password'] = $hash;

}

if ($row['user_login_attempts'] != 0)

{

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

</dl>

<dl>

<dt><label for="ldap_password">' . $user->lang['LDAP_PASSWORD'] . ':</label><br /><span>' . $user->lang['LDAP_PASSWORD_EXPLAIN'] . '</span></dt>

</dl>

';

$code = str_replace("\t", '&nbsp; &nbsp;', $code);

$code = str_replace(' ', '&nbsp; ', $code);

$code = str_replace(' ', ' &nbsp;', $code);

// remove newline at the beginning

if (!empty($code) && $code[0] == "\n")

define('PHPBB_ACM_REDIS_HOST', 'localhost');

}

/**

* ACM for Redis

*

parent::__construct();

$this->redis = new Redis();

if (defined('PHPBB_ACM_REDIS_PASSWORD'))

{

if (!$this->redis->auth(PHPBB_ACM_REDIS_PASSWORD))

'max_filesize' => (int) $row['max_filesize'],

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

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

);

$allowed_forums = ($row['allowed_forums']) ? unserialize(trim($row['allowed_forums'])) : array();

{

$denom = ($code_len - $i);

$denom = max(1.3, $denom);

$width_avail -= $offset[$i];

}

),

'PRIMARY_KEY' => 'question_id',

'KEYS' => array(

),

),

CAPTCHA_ANSWERS_TABLE => array (

'answer_text' => array('STEXT_UNI', ''),

),

'KEYS' => array(

),

),

CAPTCHA_QA_CONFIRM_TABLE => array (

*/

class phpbb_recaptcha extends phpbb_default_captcha

{

var $challenge;

var $response;

return $user->lang['RECAPTCHA_INCORRECT'];

}

array(

'privatekey' => $config['recaptcha_privkey'],

'remoteip' => $user->ip,

define('ICONS_TABLE', $table_prefix . 'icons');

define('LANG_TABLE', $table_prefix . 'lang');

define('LOG_TABLE', $table_prefix . 'log');

define('MODERATOR_CACHE_TABLE', $table_prefix . 'moderator_cache');

define('MODULES_TABLE', $table_prefix . 'modules');

define('POLL_OPTIONS_TABLE', $table_prefix . 'poll_options');

*/

public function __construct($task_path, $phpEx, phpbb_cache_driver_interface $cache = null)

{

$this->task_path = $task_path;

$this->phpEx = $phpEx;

$this->cache = $cache;

$file = preg_replace('#^' . preg_quote($this->task_path, '#') . '#', '', $fileinfo->getPathname());

// skip directories and files direclty in the task root path

{

if (substr($file, -$ext_length) == $ext && $this->is_valid_name($task_name))

{

$task_names[] = 'phpbb_cron_task_' . $task_name;

// here lies an array, filled with information compiled on the column's data

$prepared_column = $this->sql_prepare_column_data($table_name, $column_name, $column_data);

// here we add the definition of the new column to the list of columns

switch ($this->sql_layer)

{

break;

case 'oracle':

$statements[] = $table_sql;

// do we need to add a sequence and a tigger for auto incrementing columns?

$trigger .= "BEGIN\n";

$trigger .= "\tSELECT {$table_name}_seq.nextval\n";

$trigger .= "\tINTO :new.{$create_sequence}\n";

$trigger .= "END;";

$statements[] = $trigger;

case 'firebird':

if ($create_sequence)

{

}

break;

}

$sqlite = true;

}

// Change columns?

if (!empty($schema_changes['change_columns']))

{

{

foreach ($columns as $column_name => $column_data)

{

if ($column_exists = $this->sql_column_exists($table, $column_name))

{

}

else

{

{

if ($column_exists)

{

}

else

{

{

foreach ($indexes as $index_name)

{

$result = $this->sql_index_drop($table, $index_name);

if ($this->return_statements)

{

foreach ($index_array as $index_name => $column)

{

$result = $this->sql_create_unique_index($table, $index_name, $column);

if ($this->return_statements)

{

foreach ($index_array as $index_name => $column)

{

$result = $this->sql_create_index($table, $index_name, $column);

if ($this->return_statements)

}

/**

* Private method for performing sql statements (either execute them or return them)

* @access private

*/

*/

function sql_prepare_column_data($table_name, $column_name, $column_data)

{

// Get type

if (strpos($column_data[0], ':') !== false)

{

switch ($this->sql_layer)

{

case 'firebird':

$statements[] = 'ALTER TABLE ' . $table_name . ' ADD "' . strtoupper($column_name) . '" ' . $column_data['column_type_sql'];

break;

case 'mssql':

case 'mssqlnative':

$statements[] = 'ALTER TABLE [' . $table_name . '] ADD [' . $column_name . '] ' . $column_data['column_type_sql_default'];

break;

case 'mysql_40':

case 'mysql_41':

break;

case 'oracle':

$statements[] = 'ALTER TABLE ' . $table_name . ' ADD ' . $column_name . ' ' . $column_data['column_type_sql'];

break;

case 'postgres':

if (version_compare($this->db->sql_server_info(true), '8.0', '>='))

{

$statements[] = 'ALTER TABLE ' . $table_name . ' ADD COLUMN "' . $column_name . '" ' . $column_data['column_type_sql'];

{

$statements = array();

switch ($this->sql_layer)

{

case 'firebird':

{

$statements = array();

// remove index length unless MySQL4

if ('mysql_40' != $this->sql_layer)

{

}

else

{

$statements[] = 'ALTER TABLE ' . $table_name . ' ALTER COLUMN "' . strtoupper($column_name) . '" TYPE ' . ' ' . $column_data['column_type_sql_type'];

}

break;

*

* @return bool Whether buffering is required.

*/

{

return false;

}

$mtime = explode(' ', microtime());

$totaltime = $mtime[0] + $mtime[1] - $starttime;

<head>

<title>SQL Report</title>

<link href="' . $phpbb_root_path . 'adm/style/admin.css" rel="stylesheet" type="text/css" media="screen" />

</head>

</div>

</div>

<div id="page-footer">

</div>

</div>

</body>

*/

function cast_expr_to_bigint($expression)

{

}

/**

/**

* {@inheritDoc}

*/

{

return true;

}

*/

function sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false , $new_link = false)

{

$this->user = $sqluser;

$this->dbname = $database;

$port = (!$port) ? NULL : $port;

if ($this->db_connect_id && $this->dbname != '')

{

}

/**

* Return formatted string for filesizes

*

* @param int $value filesize in bytes

}

/**

* Global function for chmodding directories and files for internal use

*

* This function determines owner and group whom the file belongs to and user and group of PHP and then set safest possible file permissions.

/**

* Generate board url (example: http://www.example.com/phpBB)

* @param bool $without_script_path if set to true the script path gets not appended (example: http://www.example.com)

*/

function generate_board_url($without_script_path = false)

{

{

header('Refresh: 0; URL=' . $url);

echo '<head>';

echo '<meta http-equiv="refresh" content="0; url=' . str_replace('&', '&amp;', $url) . '" />';

echo '<title>' . $user->lang['REDIRECT'] . '</title>';

echo '</head>';

{

$version = $_SERVER['SERVER_PROTOCOL'];

}

else

{

$version = 'HTTP/1.0';

{

return true;

}

default:

case 'AAAA':

if (!empty($host_matches))

{

// Second line

if (strpos($errfile, 'cache') === false && strpos($errfile, 'template.') === false)

{

// remove complete path to installation, with the risk of changing backslashes meant to be there

$errfile = str_replace(array(phpbb_realpath($phpbb_root_path), '\\'), array('', '/'), $errfile);

$msg_text = str_replace(array(phpbb_realpath($phpbb_root_path), '\\'), array('', '/'), $msg_text);

// we are writing an image - the user won't see the debug, so let's place it in the log

if (defined('IMAGE_OUTPUT') || defined('IN_CRON'))

// Try to not call the adm page data...

echo '<head>';

echo '<title>' . $msg_title . '</title>';

echo '<style type="text/css">' . "\n" . '/* <![CDATA[ */' . "\n";

echo '* { margin: 0; padding: 0; } html { font-size: 100%; height: 100%; margin-bottom: 1px; background-color: #E4EDF0; } body { font-family: "Lucida Grande", Verdana, Helvetica, Arial, sans-serif; color: #536482; background: #E4EDF0; font-size: 62.5%; margin: 0; } ';

echo ' </div>';

echo ' </div>';

echo ' <div id="page-footer">';

echo ' </div>';

echo '</div>';

echo '</body>';

// gzip_compression

if ($config['gzip_compress'])

{

{

ob_start('ob_gzhandler');

}

$user_lang = substr($user_lang, 0, strpos($user_lang, '-x-'));

}

// The following assigns all _common_ variables that may be used at any point in a template.

$template->assign_vars(array(

'SITENAME' => $config['sitename'],

'S_LOAD_UNREADS' => ($config['load_unreads_search'] && ($config['load_anon_lastread'] || $user->data['is_registered'])) ? true : false,

'T_THEME_PATH' => "{$web_path}styles/" . $user->theme['theme_path'] . '/theme',

'T_TEMPLATE_PATH' => "{$web_path}styles/" . $user->theme['template_path'] . '/template',

'T_SUPER_TEMPLATE_PATH' => (isset($user->theme['template_inherit_path']) && $user->theme['template_inherit_path']) ? "{$web_path}styles/" . $user->theme['template_inherit_path'] . '/template' : "{$web_path}styles/" . $user->theme['template_path'] . '/template',

'T_IMAGESET_PATH' => "{$web_path}styles/" . $user->theme['imageset_path'] . '/imageset',

'T_IMAGES_PATH' => "{$web_path}images/",

'T_SMILIES_PATH' => "{$web_path}{$config['smilies_path']}/",

'T_AVATAR_PATH' => "{$web_path}{$config['avatar_path']}/",

'T_ICONS_PATH' => "{$web_path}{$config['icons_path']}/",

'T_RANKS_PATH' => "{$web_path}{$config['ranks_path']}/",

'T_UPLOAD_PATH' => "{$web_path}{$config['upload_path']}/",

'T_STYLESHEET_NAME' => $user->theme['theme_name'],

'T_THEME_NAME' => $user->theme['theme_path'],

}

// As a pre-caution... some setups display a blank page if the flush() is not there.

exit;

}

/**

* Build radio fields in acp pages

*/

{

global $user;

foreach ($input_ary as $value => $title)

{

$selected = ($input_default !== false && $value == $input_default) ? ' checked="checked"' : '';

$id_assigned = true;

}

$size = (int) $tpl_type[1];

$maxlength = (int) $tpl_type[2];

break;

case 'dimension':

switch ($validator[$type])

{

case 'string':

// the column is a VARCHAR

$validator[$max] = (isset($validator[$max])) ? min(255, $validator[$max]) : 255;

{

case 'string' :

$max = (isset($column[1])) ? min($column[1],$type['max']) : $type['max'];

{

$error[] = sprintf($user->lang['SETTING_TOO_LONG'], $user->lang[$value['lang']], $max);

}

$sql_keywords .= 'LOWER(l.log_data) ' . implode(' OR LOWER(l.log_data) ', $keywords) . ')';

}

$sql = "SELECT l.*, u.username, u.username_clean, u.user_colour

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

WHERE l.log_type = $log_type

}

}

}

/**

$user_count = (int) $db->sql_fetchfield('user_count');

$db->sql_freeresult($result);

if ($offset >= $user_count)

{

$offset = ($offset - $limit < 0) ? 0 : $offset - $limit;

return '';

}

// We moved the word censor checks in here because we call this function quite often - and then only need to do the check once

if (!isset($censors) || !is_array($censors))

{

* @param int $max_length Maximum length of string (multibyte character count as 1 char / Html entity count as 1 char)

* @param int $max_store_length Maximum character length of string (multibyte character count as 1 char / Html entity count as entity chars).

* @param bool $allow_reply Allow Re: in front of string

* @param string $append String to be appended

*/

function truncate_string($string, $max_length = 60, $max_store_length = 255, $allow_reply = false, $append = '')

'SUBFORUMS' => $s_subforums_list,

'L_SUBFORUM_STR' => $l_subforums,

'L_MODERATOR_STR' => $l_moderator,

'U_UNAPPROVED_TOPICS' => ($row['forum_id_unapproved_topics']) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=unapproved_topics&amp;f=' . $row['forum_id_unapproved_topics']) : '',

/**

* Topic and forum watching common code

*/

{

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

global $request;

if (!is_null($notify_status) && $notify_status !== '')

{

if (isset($_GET['unwatch']))

{

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

{

$sql = 'DELETE FROM ' . $table_sql . "

WHERE $where_sql = $match_id

AND user_id = $user_id";

$db->sql_query($sql);

}

else

{

{

if (isset($_GET['watch']))

{

$token = request_var('hash', '');

{

$is_watching = true;

$sql = 'INSERT INTO ' . $table_sql . " (user_id, $where_sql, notify_status)

VALUES ($user_id, $match_id, " . NOTIFY_YES . ')';

$db->sql_query($sql);

$message = $user->lang['ARE_WATCHING_' . strtoupper($mode)] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');

}

else

{

}

else

{

}

else

{

{

login_box();

}

*/

function wrap_img_in_html($src, $title)

{

echo '<html>';

echo '<head>';

echo '<title>' . $title . '</title>';

echo '</head>';

echo '<body>';

*/

function generate_smilies($mode, $forum_id)

{

global $phpEx, $phpbb_root_path;

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

*/

function posting_gen_attachment_entry($attachment_data, &$filename_data, $show_attach_box = true)

{

// Some default template variables

$template->assign_vars(array(

return $url;

}

case FIELD_DROPDOWN:

$field_value = (int) $field_value;

if ($field_value == $field_data['field_novalue'] && $field_data['field_required'])

{

return 'FIELD_REQUIRED';

switch ($cp_result)

{

case 'FIELD_INVALID_DATE':

case 'FIELD_REQUIRED':

$error = sprintf($user->lang[$cp_result], $row['lang_name']);

break;

// Grab log data

$log_data = array();

$log_count = 0;

$template->assign_vars(array(

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

'L_TITLE' => $user->lang['MCP_LOGS'],

'S_CLEAR_ALLOWED' => ($auth->acl_get('a_clearlogs')) ? true : false,

'S_SELECT_SORT_DIR' => $s_sort_dir,

'S_SELECT_SORT_KEY' => $s_sort_key,

$log_data = array();

$log_count = 0;

if ($log_count)

{

/**

* Init bbcode data for later parsing

*/

{

static $rowset;

// This array holds all bbcode data. BBCodes will be processed in this

// order, so it is important to keep [code] in first position and

// [quote] in second position.

$this->bbcodes = array(

'code' => array('bbcode_id' => 8, 'regexp' => array('#\[code(?:=([a-z]+))?\](.+\[/code\])#uise' => "\$this->bbcode_code('\$1', '\$2')")),

'quote' => array('bbcode_id' => 0, 'regexp' => array('#\[quote(?:=&quot;(.*?)&quot;)?\](.+)\[/quote\]#uise' => "\$this->bbcode_quote('\$0')")),

'attachment' => array('bbcode_id' => 12, 'regexp' => array('#\[attachment=([0-9]+)\](.*?)\[/attachment\]#uise' => "\$this->bbcode_attachment('\$1', '\$2')")),

'b' => array('bbcode_id' => 1, 'regexp' => array('#\[b\](.*?)\[/b\]#uise' => "\$this->bbcode_strong('\$1')")),

'i' => array('bbcode_id' => 2, 'regexp' => array('#\[i\](.*?)\[/i\]#uise' => "\$this->bbcode_italic('\$1')")),

'img' => array('bbcode_id' => 4, 'regexp' => array('#\[img\](.*)\[/img\]#uiUe' => "\$this->bbcode_img('\$1')")),

'size' => array('bbcode_id' => 5, 'regexp' => array('#\[size=([\-\+]?\d+)\](.*?)\[/size\]#uise' => "\$this->bbcode_size('\$1', '\$2')")),

'color' => array('bbcode_id' => 6, 'regexp' => array('!\[color=(#[0-9a-f]{3}|#[0-9a-f]{6}|[a-z\-]+)\](.*?)\[/color\]!uise' => "\$this->bbcode_color('\$1', '\$2')")),

$this->parsed_items[$tag] = 0;

}

if (!is_array($rowset))

{

global $db;

// if the forwarded for header shall be checked we have to validate its contents

if ($config['forwarded_for_check'])

{

// split the list of IPs

$ips = explode(' ', $this->forwarded_for);

// Why no forwarded_for et al? Well, too easily spoofed. With the results of my recent requests

// it's pretty clear that in the majority of cases you'll at least be left with a proxy/cache ip.

// split the list of IPs

// Default IP if REMOTE_ADDR is invalid

$this->ip = '127.0.0.1';

continue;

}

{

}

{

{

}

}

$this->load = false;

// otherwise they'll index this page with the SID, duplicate content oh my!

if ($bot && isset($_GET['sid']))

{

redirect(build_url(array('sid')));

}

include($phpbb_root_path . "includes/captcha/captcha_factory." . $phpEx);

}

phpbb_captcha_factory::garbage_collect($config['captcha_plugin']);

}

return;

$ip = $this->ip;

}

$dnsbl_check = array(

'sbl.spamhaus.org' => 'http://www.spamhaus.org/query/bl?ip=',

);

// Use URL if told so

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

$img_data['width'] = $this->img_array[$img]['image_width'];

$img_data['height'] = $this->img_array[$img]['image_height'];

}

$alt = (!empty($this->lang[$alt])) ? $this->lang[$alt] : $alt;

SET user_actkey = ''

WHERE user_id = {$user_row['user_id']}";

$db->sql_query($sql);

}

if ($config['require_activation'] == USER_ACTIVATION_ADMIN && !$update_password)

case 'compose':

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

if (!$auth->acl_get('u_sendpm'))

{

}

include($phpbb_root_path . 'includes/ucp/ucp_pm_compose.' . $phpEx);

$tpl_file = 'posting_body';

break;

* Compose private message

* Called from ucp_pm with mode == 'compose'

*/

{

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

global $phpbb_root_path, $phpEx, $config;

}

$sql = '';

// What is all this following SQL for? Well, we need to know

// some basic information in all cases before we do anything.

unset($message_text);

$s_action = append_sid("{$phpbb_root_path}ucp.$phpEx", "i=$id&amp;mode=$mode&amp;action=$action", true, $user->session_id);

// Delete triggered ?

if ($action == 'delete')

$msg_id = submit_pm($action, $subject, $pm_data);

$return_message_url = append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;mode=view&amp;p=' . $msg_id);

trigger_error($message);

}

$bbcode = new bbcode($message_row['bbcode_bitfield']);

}

// Assign TO/BCC Addresses to template

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

$bbcode_status = ($config['allow_bbcode'] && $config['auth_bbcode_pm'] && $auth->acl_get('u_pm_bbcode')) ? true : false;

$template->assign_vars(array(

'MESSAGE_AUTHOR_FULL' => get_username_string('full', $author_id, $user_info['username'], $user_info['user_colour'], $user_info['username']),

'MESSAGE_AUTHOR_COLOUR' => get_username_string('colour', $author_id, $user_info['username'], $user_info['user_colour'], $user_info['username']),

'S_SPECIAL_FOLDER' => in_array($folder_id, array(PRIVMSGS_NO_BOX, PRIVMSGS_OUTBOX)),

'S_PM_RECIPIENTS' => $num_recipients,

'S_BBCODE_ALLOWED' => ($bbcode_status) ? 1 : 0,

'U_PRINT_PM' => ($config['print_pm'] && $auth->acl_get('u_pm_printpm')) ? "$url&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] . "&amp;view=print" : '',

'U_FORWARD_PM' => ($config['forward_pm'] && $auth->acl_get('u_sendpm') && $auth->acl_get('u_pm_forward')) ? "$url&amp;mode=compose&amp;action=forward&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] : '')

);

// Display not already displayed Attachments for this post, we already parsed them. ;)

if (isset($attachments) && sizeof($attachments))

{

$legend = implode(', ', $legend);

// Generate birthday list if required ...

if ($config['load_birthdays'] && $config['allow_birthdays'])

{

$sql = 'SELECT u.user_id, u.username, u.user_colour, u.user_birthday

FROM ' . USERS_TABLE . ' u

LEFT JOIN ' . BANLIST_TABLE . " b ON (u.user_id = b.ban_userid)

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

{

}

$db->sql_freeresult($result);

}

'NEWEST_USER' => sprintf($user->lang['NEWEST_USER'], get_username_string('full', $config['newest_user_id'], $config['newest_username'], $config['newest_user_colour'])),

'LEGEND' => $legend,

'FORUM_IMG' => $user->img('forum_read', 'NO_UNREAD_POSTS'),

'FORUM_UNREAD_IMG' => $user->img('forum_unread', 'UNREAD_POSTS'),

{

case 'mssql':

case 'mssql_odbc':

$db->sql_query('SET IDENTITY_INSERT ' . FORUMS_TABLE . ' ON');

break;

}

case 'mssql':

case 'mssql_odbc':

$db->sql_query('SET IDENTITY_INSERT ' . FORUMS_TABLE . ' OFF');

break;

case 'mssql':

case 'mssql_odbc':

$map_dbms = 'mssql';

break;

*

*/

// Enter any version to update from to test updates. The version within the db will not be updated.

// Which oldest version does this updater support?

// Return if we "just include it" to find out for which version the database update is responsible for

if (defined('IN_PHPBB') && defined('IN_INSTALL'))

{

return;

}

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

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

{

}

error_reporting(E_ALL);

@set_time_limit(0);

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

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

require($phpbb_root_path . 'includes/constants.' . $phpEx);

require($phpbb_root_path . 'includes/db/' . $dbms . '.' . $phpEx);

require($phpbb_root_path . 'includes/utf/utf_tools.' . $phpEx);

{

}

$class_loader = new phpbb_class_loader($phpbb_root_path, '.' . $phpEx);

set_config(null, null, null, $config);

set_config_count(null, null, null, $config);

$database_update_info = database_update_info();

if ($has_global && !$ga_forum_id)

{

?>

<head>

<title><?php echo $lang['UPDATING_TO_LATEST_STABLE']; ?></title>

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

?>

<head>

<title><?php echo $lang['UPDATING_TO_LATEST_STABLE']; ?></title>

</div>

<div id="page-footer">

</div>

</div>

$db->sql_return_on_error(true);

{

}

$db->sql_return_on_error(false);

'3.0.7-PL1' => array(),

// No changes from 3.0.8-RC1 to 3.0.8

'3.0.8-RC1' => array(),

// Changes from 3.0.8 to 3.0.9-RC1

'3.0.8' => array(

'change_columns' => array(

BBCODES_TABLE => array(

'bbcode_id' => array('USINT', 0),

),

),

),

// Changes from 3.1.0-dev to 3.1.0-A1

'3.1.0-dev' => array(

GROUPS_TABLE => array(

'group_teampage' => array('UINT', 0, 'after' => 'group_legend'),

),

),

'change_columns' => array(

GROUPS_TABLE => array(

// Changes from 3.0.8 to 3.0.9-RC1

case '3.0.8':

// Update file extension group names to use language strings, again.

$sql = 'SELECT group_id, group_name

FROM ' . EXTENSION_GROUPS_TABLE . '

}

$db->sql_freeresult($result);

$no_updates = false;

break;

// Changes from 3.1.0-dev to 3.1.0-A1

case '3.1.0-dev':

set_config('use_system_cron', 0);

'auth' => 'acl_a_group',

'cat' => 'ACP_GROUPS',

),

);

_add_modules($modules_to_install);

unset($table_ary);

}

$no_updates = false;

break;

}

}