+

+ if (strpos($config_name, '_max') !== false)

+ {

+ // Min/max pairs of settings should ensure that min <= max

+ // Replace _max with _min to find the name of the minimum

+ // corresponding configuration variable

+ $min_name = str_replace('_max', '_min', $config_name);

+

+ if (isset($cfg_array[$min_name]) && is_numeric($cfg_array[$min_name]) && $cfg_array[$config_name] < $cfg_array[$min_name])

+ {

+ // A minimum value exists and the maximum value is less than it

+ $error[] = sprintf($user->lang['SETTING_TOO_LOW'], $user->lang[$config_definition['lang']], (int) $cfg_array[$min_name]);

+ }

+ }

+ if (file_exists($phpbb_root_path . $cfg_array[$config_name]) && !phpbb_is_writable($phpbb_root_path . $cfg_array[$config_name]))

+ document.getElementById('acp_unban').unbangivereason.innerHTML = ban_give_reason[option];

+ document.getElementById('acp_unban').unbanreason.innerHTML = ban_reason[option];

+ document.getElementById('acp_unban').unbanlength.innerHTML = ban_length[option];

+ <dd><label><input type="radio" class="radio" name="display_active" value="1"<!-- IF S_ENABLE_ACTIVE_TOPICS --> id="display_active" checked="checked"<!-- ENDIF --> /> {L_YES}</label>

+ <label><input type="radio" class="radio" name="display_active" value="0"<!-- IF not S_ENABLE_ACTIVE_TOPICS --> id="display_active" checked="checked"<!-- ENDIF --> /> {L_NO}</label></dd>

+ <!-- IF NEXT_FEATURE_VERSION -->

+ <div class="errorbox">

+ <p>{UPGRADE_INSTRUCTIONS}</p>

+ </div>

+ <!-- ENDIF -->

+

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

+ <!-- ENDIF -->

+ <input type="button" class="button2" accesskey="y" name="addlitsitem" value="[*]" style="width: 40px" onclick="bbstyle(-1)" onmouseover="helpline('e')" onmouseout="helpline('tip')" />

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 90px;"><textarea name="signature" rows="10" cols="60" style="width: 95%;" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);" onfocus="initInsertions();">{SIGNATURE}</textarea></dd>

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 90px; margin-top: 5px;">

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 90px; margin-top: 10px;"><strong>{L_OPTIONS}: </strong>{BBCODE_STATUS} :: {IMG_STATUS} :: {FLASH_STATUS} :: {URL_STATUS} :: {SMILIES_STATUS}</dd>

+ top: -.2em;

+ lang : '{LA_RECAPTCHA_LANG}',

+ theme : 'clean',

+

+ if (!document.forms[form_name])

+ {

+ document.body.focus();

+ }

+ mozWrap(textarea, text, '');

+ theSelection = theSelection.replace(/&nbsp\;/ig, ' ');

+ var s2 = (txtarea.value).substring(selStart, selEnd);

+ txtarea.selectionStart = selStart + open.length;

+ txtarea.selectionEnd = selEnd + open.length;

+ document.write('<td bgcolor="#' + color + '" style="width: ' + width + 'px; height: ' + height + 'px;">');

+ document.write('<a href="#" onclick="bbfontstyle(\'[color=#' + color + ']\', \'[/color]\'); return false;"><img src="images/spacer.gif" width="' + width + '" height="' + height + '" alt="#' + color + '" title="#' + color + '" /></a>');

+ <dd class="full" style="text-align: {S_CONTENT_FLOW_BEGIN};"><strong>{up_to_date.FILENAME}</strong></dd>

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;">

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;"><label><input type="checkbox" name="no_update[]" value="{new.FILENAME}" class="radio" /> {L_DO_NOT_UPDATE}</label></dd>

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

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;"><label><input type="checkbox" name="no_update[]" value="{not_modified.FILENAME}" class="radio" /> {L_DO_NOT_UPDATE}</label></dd>

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;">&nbsp;</dd>

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;"><label><input type="checkbox" name="no_update[]" value="{modified.FILENAME}" class="radio" /> {L_DO_NOT_UPDATE}</label></dd>

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

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

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

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;">

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;"><label><input type="checkbox" name="no_update[]" value="{new_conflict.FILENAME}" class="radio" /> {L_DO_NOT_UPDATE}</label></dd>

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;">

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;"><label><input type="checkbox" name="no_update[]" value="{conflict.FILENAME}" class="radio" /> {L_DO_NOT_UPDATE}</label></dd>

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;">&nbsp;</dd>

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;">[<a href="{conflict.U_VIEW_NEW_FILE}" onclick="diff_popup(this.href); return false;">{L_SHOW_DIFF_MODIFIED}</a>]</dd>

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;">[<a href="{conflict.U_VIEW_MOD_FILE}" onclick="diff_popup(this.href); return false;">{L_SHOW_DIFF_MODIFIED}</a>]</dd>

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;">[<a href="{conflict.U_VIEW_NO_MERGE_NEW}" onclick="diff_popup(this.href); return false;">{L_SHOW_DIFF_FINAL}</a>]</dd>

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 60%;">[<a href="{conflict.U_VIEW_NO_MERGE_MOD}" onclick="diff_popup(this.href); return false;">{L_SHOW_DIFF_FINAL}</a>]</dd>

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}: 20%"><select id="role{p_mask.S_ROW_COUNT}{p_mask.f_mask.S_ROW_COUNT}" name="role[{p_mask.f_mask.UG_ID}][{p_mask.f_mask.FORUM_ID}]" onchange="set_role_settings(this.options[selectedIndex].value, 'advanced{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}')">{p_mask.f_mask.S_ROLE_OPTIONS}</select></dd>

+ <fieldset class="quick" style="margin-{S_CONTENT_FLOW_END}: 11px;">

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

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

+<?php

+/**

+*

+* @package phpBB3

+* @version $Id$

+* @copyright (c) 2009, 2010 phpBB Group

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

+*

+*/

+

+/**

+* This script will check your database for potentially dangerous flash BBCode tags

+*/

+

+//

+// 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\n");

+

+/**

+*/

+define('IN_PHPBB', true);

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

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

+include($phpbb_root_path . 'common.' . $phpEx);

+

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

+{

+ header('Content-Type: text/plain');

+}

+

+check_table_flash_bbcodes(POSTS_TABLE, 'post_id', 'post_text', 'bbcode_uid', 'bbcode_bitfield');

+check_table_flash_bbcodes(PRIVMSGS_TABLE, 'msg_id', 'message_text', 'bbcode_uid', 'bbcode_bitfield');

+check_table_flash_bbcodes(USERS_TABLE, 'user_id', 'user_sig', 'user_sig_bbcode_uid', 'user_sig_bbcode_bitfield');

+check_table_flash_bbcodes(FORUMS_TABLE, 'forum_id', 'forum_desc', 'forum_desc_uid', 'forum_desc_bitfield');

+check_table_flash_bbcodes(FORUMS_TABLE, 'forum_id', 'forum_rules', 'forum_rules_uid', 'forum_rules_bitfield');

+check_table_flash_bbcodes(GROUPS_TABLE, 'group_id', 'group_desc', 'group_desc_uid', 'group_desc_bitfield');

+

+echo "If potentially dangerous flash bbcodes were found, please reparse the posts using the Support Toolkit (http://www.phpbb.com/support/stk/) and/or file a ticket in the Incident Tracker (http://www.phpbb.com/incidents/).\n";

+

+function check_table_flash_bbcodes($table_name, $id_field, $content_field, $uid_field, $bitfield_field)

+{

+ echo "Checking $content_field on $table_name\n";

+

+ $ids = get_table_flash_bbcode_pkids($table_name, $id_field, $content_field, $uid_field, $bitfield_field);

+

+ $size = sizeof($ids);

+ if ($size)

+ {

+ echo "Found $size potentially dangerous flash bbcodes.\n";

+ echo "$id_field: " . implode(', ', $ids) . "\n";

+ }

+ else

+ {

+ echo "No potentially dangerous flash bbcodes found.\n";

+ }

+

+ echo "\n";

+}

+

+function get_table_flash_bbcode_pkids($table_name, $id_field, $content_field, $uid_field, $bitfield_field)

+{

+ global $db;

+

+ $ids = array();

+

+ $sql = "SELECT $id_field, $content_field, $uid_field, $bitfield_field

+ FROM $table_name

+ WHERE $content_field LIKE '%[/flash:%'

+ AND $bitfield_field <> ''";

+

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

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

+ {

+ $uid = $row[$uid_field];

+

+ // thanks support toolkit

+ $content = html_entity_decode_utf8($row[$content_field]);

+ set_var($content, $content, 'string', true);

+ $content = utf8_normalize_nfc($content);

+

+ $bitfield_data = $row[$bitfield_field];

+

+ if (!is_valid_flash_bbcode($content, $uid) && has_flash_enabled($bitfield_data))

+ {

+ $ids[] = (int) $row[$id_field];

+ }

+ }

+ $db->sql_freeresult($result);

+

+ return $ids;

+}

+

+function get_flash_regex($uid)

+{

+ return "#\[flash=([0-9]+),([0-9]+):$uid\](.*?)\[/flash:$uid\]#";

+}

+

+// extract all valid flash bbcodes

+// check if the bbcode content is a valid URL for each match

+function is_valid_flash_bbcode($cleaned_content, $uid)

+{

+ $regex = get_flash_regex($uid);

+

+ $url_regex = get_preg_expression('url');

+ $www_url_regex = get_preg_expression('www_url');

+

+ if (preg_match_all($regex, $cleaned_content, $matches))

+ {

+ foreach ($matches[3] as $flash_url)

+ {

+ if (!preg_match("#^($url_regex|$www_url_regex)$#i", $flash_url))

+ {

+ return false;

+ }

+ }

+ }

+

+ return true;

+}

+

+// check if a bitfield includes flash

+// 11 = flash bit

+function has_flash_enabled($bitfield_data)

+{

+ $bitfield = new bitfield($bitfield_data);

+ return $bitfield->get(11);

+}

+

+// taken from support toolkit

+function html_entity_decode_utf8($string)

+{

+ static $trans_tbl;

+

+ // replace numeric entities

+ $string = preg_replace('~&#x([0-9a-f]+);~ei', 'code2utf8(hexdec("\\1"))', $string);

+ $string = preg_replace('~&#([0-9]+);~e', 'code2utf8(\\1)', $string);

+

+ // replace literal entities

+ if (!isset($trans_tbl))

+ {

+ $trans_tbl = array();

+

+ foreach (get_html_translation_table(HTML_ENTITIES) as $val=>$key)

+ $trans_tbl[$key] = utf8_encode($val);

+ }

+ return strtr($string, $trans_tbl);

+}

+

+// taken from support toolkit

+// Returns the utf string corresponding to the unicode value (from php.net, courtesy - romans@void.lv)

+function code2utf8($num)

+{

+ if ($num < 128) return chr($num);

+ if ($num < 2048) return chr(($num >> 6) + 192) . chr(($num & 63) + 128);

+ if ($num < 65536) return chr(($num >> 12) + 224) . chr((($num >> 6) & 63) + 128) . chr(($num & 63) + 128);

+ if ($num < 2097152) return chr(($num >> 18) + 240) . chr((($num >> 12) & 63) + 128) . chr((($num >> 6) & 63) + 128) . chr(($num & 63) + 128);

+ return '';

+}

+ // no need to do this, no transaction support for schema changes

+ //$line .= "BEGIN TRANSACTION\nGO\n\n";

+ // No need to do this, no transaction support for schema changes

+ //$line = "\nCOMMIT\nGO\n\n";

+ array(false, '::', '{0,5}', "(?:$h16(?::$h16)?|$ipv4)"),

+ array('{1,7}', ':', false, ''),

+ array(false, '::', false, '')

+#!/bin/sh

+# set permissions required for installation

+

+dir=$(dirname $0)

+

+for file in cache files store config.php images/avatars/upload

+do

+ chmod a+w $dir/../$file

+done

+ igorw (Igor Wiedler)

+ nickvergessen (Joas Schilling)

+ rxu (Ruslan Uzdenov)

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

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

+ <a name="v307-PL1"></a><h3>1.i. Changes since 3.0.7-PL1</h3>

+<h4> Security

+</h4>

+<ul>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9903'>PHPBB3-9903</a>] - Execute javascript in [flash=] BBCode

+</li>

+</ul>

+

+<h4> Bug

+</h4>

+<ul>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-4923'>PHPBB3-4923</a>] - compress_tar incorrectly determines type

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-5164'>PHPBB3-5164</a>] - Honor minimum and maximum password length in generated passwords as much as possible.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-6726'>PHPBB3-6726</a>] - Connecting to PostgreSQL using &#39;localhost&#39; doesn&#39;t try to use a TCP connection

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-6747'>PHPBB3-6747</a>] - word censoring * does not handle space for two or more words

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-7260'>PHPBB3-7260</a>] - Do not delete polls if one exists and editing user lacks permissions

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-7296'>PHPBB3-7296</a>] - Style export to tar(.*) does not work

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-7369'>PHPBB3-7369</a>] - Custom Profile dates display incorrectly

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-7417'>PHPBB3-7417</a>] - Search keywords field does not initially get focus

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-7538'>PHPBB3-7538</a>] - Query exceeds maximum value for user_login_attempts

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-7716'>PHPBB3-7716</a>] - Data too long for column &#39;message_subject&#39;

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-7720'>PHPBB3-7720</a>] - Fix alternative image-description for unread posts.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-7782'>PHPBB3-7782</a>] - Send HTTP 404 if topic, forum or user do not exist

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-7972'>PHPBB3-7972</a>] - Copied topics are not indexed

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-8169'>PHPBB3-8169</a>] - Parse CSS Regex accepts invalid code

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-8792'>PHPBB3-8792</a>] - Misleading error message in auth_ldap.php, function init_ldap()

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-8894'>PHPBB3-8894</a>] - JavaScript error and visible quote button on topic review if BBCodes disallowed

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-8924'>PHPBB3-8924</a>] - spelling in admin_welcome_inactive.txt

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-8929'>PHPBB3-8929</a>] - MS SQL error on view all smilies after 3.0.6 upgrade

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-8935'>PHPBB3-8935</a>] - able to set minimal avatar size larger than maximum

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-8944'>PHPBB3-8944</a>] - Error on database update (must specify size of index on MySQL4)

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9012'>PHPBB3-9012</a>] - Retain original topic title in shadow topic when moving a topic and editing the title.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9034'>PHPBB3-9034</a>] - Redirect() fails with directory traversal

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9047'>PHPBB3-9047</a>] - Active topics and reported posts

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9049'>PHPBB3-9049</a>] - Password reminder system generates confusable passwords

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9053'>PHPBB3-9053</a>] - Correctly sort database backup file list by date on database restore page

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9061'>PHPBB3-9061</a>] - Race condition in queue locking

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9068'>PHPBB3-9068</a>] - Grammatical Error under Load Settings

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9075'>PHPBB3-9075</a>] - Missing / bad default values of CPFs result in SQL errors on registration of new users

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9091'>PHPBB3-9091</a>] - Wrong IP checking for IPv4 addresses mapped into IPv6

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9094'>PHPBB3-9094</a>] - Hide &quot;Copy permissions&quot; message, when permissions were copied.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9095'>PHPBB3-9095</a>] - Misleading setting text for CAPTCHA

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9099'>PHPBB3-9099</a>] - Missing comma in PASSWORD_EXPLAIN acp language strings

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9101'>PHPBB3-9101</a>] - Bad text placement for reCAPTCHA description

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9104'>PHPBB3-9104</a>] - Safari does not display box headers correctly in the ACP.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9107'>PHPBB3-9107</a>] - Can&#39;t Set Parent Forum

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9108'>PHPBB3-9108</a>] - RSS feeds does not work on Postgres

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9112'>PHPBB3-9112</a>] - Most active forum post count does not respect m_approve permission

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9114'>PHPBB3-9114</a>] - Recent bug fix for smilies causing problems on older MySQL versions

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9117'>PHPBB3-9117</a>] - Wrong redirection after login

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9119'>PHPBB3-9119</a>] - Language selection is disregarded in automatic update

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9120'>PHPBB3-9120</a>] - Typo fix in a comment in functions.php

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9121'>PHPBB3-9121</a>] - Forum feed shows posts that are currently on the moderation queue

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9125'>PHPBB3-9125</a>] - ACP User Overview: Unmatched &lt;/form&gt; tag when viewing own user

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9126'>PHPBB3-9126</a>] - Invalid redirection after login to forum not in web root

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9132'>PHPBB3-9132</a>] - Oracle CLOB support is broken, preventing storage of long strings

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9135'>PHPBB3-9135</a>] - Fix report-icon for moderators in PM folders.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9140'>PHPBB3-9140</a>] - Check current board version in incremental update packages

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9145'>PHPBB3-9145</a>] - Fix open_basedir issues when accessing styles- and language-management

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9146'>PHPBB3-9146</a>] - Quick-Reply tabindex=&quot;6&quot; set twice

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9147'>PHPBB3-9147</a>] - &quot;Change topic type&quot;-option &quot;Normal&quot; always selected.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9154'>PHPBB3-9154</a>] - Correctly check for double inclusion in captcha garbage collection

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9158'>PHPBB3-9158</a>] - viewforum/viewtopic pages unnecessarily duplicated with start=0

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9162'>PHPBB3-9162</a>] - BBCode in poll options is broken, when posting without question.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9167'>PHPBB3-9167</a>] - Remove shadow topics from remaining forums when deleting a forum including posts

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9170'>PHPBB3-9170</a>] - Unable to get image size in img bbcode when URL has multiple parameters.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9173'>PHPBB3-9173</a>] - sql_config_count() artificially limits number scope to 4byte-integer on PostgreSQL and Firebird

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9176'>PHPBB3-9176</a>] - When setting the board&#39;s date format the board&#39;s timezone settings aren&#39;t taken into account

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9451'>PHPBB3-9451</a>] - Unnecessary overhead in avatar_process_user function

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9478'>PHPBB3-9478</a>] - Validate maximum number of allowed recipients per PM value

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9495'>PHPBB3-9495</a>] - Loginbox &lt;input /&gt; redirect breaks xHTML

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9499'>PHPBB3-9499</a>] - Javascript function dE does not correctly detect element visibility

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9504'>PHPBB3-9504</a>] - Allow gallery avatars with whitespaces in the filename

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9509'>PHPBB3-9509</a>] - phpBB Coding Guidelines state subversion as the version control system for phpBB

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9510'>PHPBB3-9510</a>] - Unable to copy permissions from and to forums you cannot see

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9512'>PHPBB3-9512</a>] - Fix dead link in MCP on reports for global announcements in prosilver.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9514'>PHPBB3-9514</a>] - Correctly delete big datasets when deleting a forum including topics/posts on non-MySQL databases

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9518'>PHPBB3-9518</a>] - Postgres DBAL does not correctly create a new database connection when passing $new_link as true

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9519'>PHPBB3-9519</a>] - Replace remaining is_writable() calls with phpbb_is_writable().

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9521'>PHPBB3-9521</a>] - MSSQL error reporting returns String instead of an error

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9524'>PHPBB3-9524</a>] - IPv6 regular expression does not match addresses starting in ::

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9526'>PHPBB3-9526</a>] - User Preference to hide online status does not work for bots

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9528'>PHPBB3-9528</a>] - Quoting in a PM does not fall back to bbcode-less quotes using &quot;&gt; &quot; when bbcodes are disabled

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9529'>PHPBB3-9529</a>] - Topic review does not display all selected posts

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9530'>PHPBB3-9530</a>] - subsilver2 missing fallback option on quoting when bbcodes are disabled

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9531'>PHPBB3-9531</a>] - BBCode-less fall back option for quotes is missing &quot;Author wrote:&quot; line when quoting from topic-review.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9535'>PHPBB3-9535</a>] - Incorrect margins in RTL languages: signatures, permission ACP &amp; updater

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9545'>PHPBB3-9545</a>] - &#39;Your first forum&#39; should have &#39;Display active topics:&#39; set to &#39;Yes&#39;

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9546'>PHPBB3-9546</a>] - Moving all posts from one topic to another does not delete bookmarks

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9547'>PHPBB3-9547</a>] - Changing forum type applies FORUM_FLAG_ACTIVE_TOPICS to new forum type.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9548'>PHPBB3-9548</a>] - Delete user quicktool drop down should have an empty or invalid selection as the default

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9559'>PHPBB3-9559</a>] - Messenger Queue Batch Size configuration option is overridden

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9567'>PHPBB3-9567</a>] - Newly registered users group ACP wording

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9582'>PHPBB3-9582</a>] - Missing MSSQL native driver case statements

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9587'>PHPBB3-9587</a>] - Prosilver overrides reCaptcha class.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9592'>PHPBB3-9592</a>] - Test suite does not run on SQLite

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9593'>PHPBB3-9593</a>] - Missing documentation for running unit tests

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9599'>PHPBB3-9599</a>] - Windows workaround for checkdnsrr() returns wrong results

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9605'>PHPBB3-9605</a>] - Wrong class added to topiclist, when there&#39;s no announcement topic.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9615'>PHPBB3-9615</a>] - When attaching a file whose name contains quotes, filename before last quote is cut off in display

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9623'>PHPBB3-9623</a>] - Strings not properly normalized - acp_prune.php

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9626'>PHPBB3-9626</a>] - Regular expressions from get_preg_expression() are untested.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9628'>PHPBB3-9628</a>] - Add module function does not correctly insert a module after the specified one

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9633'>PHPBB3-9633</a>] - Newly registered users group color is not used in Our Newest Member

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9635'>PHPBB3-9635</a>] - Useless parameter $data[&#39;post_time&#39;] in function submit_post.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9637'>PHPBB3-9637</a>] - SET NAMES &#39;BINARY&#39; error in convertor

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9643'>PHPBB3-9643</a>] - DB connection error when $dbhost is an IPv6 address

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9644'>PHPBB3-9644</a>] - submit_post shows support for options that cause a trigger_error in the call to user_notification

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9646'>PHPBB3-9646</a>] - Cant hide/outcomment @import in stylesheet.css

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9650'>PHPBB3-9650</a>] - It should not be possible to ban Anonymous

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9653'>PHPBB3-9653</a>] - xhtml errors in subsilver2 when using the bbcodes code and quote in signatures

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9655'>PHPBB3-9655</a>] - Selecting an unavailable captcha plugin looks like a successful action

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9656'>PHPBB3-9656</a>] - PHP Information in ACP always lists error_reporting as 0

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9658'>PHPBB3-9658</a>] - Optimize topic splitting

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9662'>PHPBB3-9662</a>] - Search interval applied inconsistently

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9664'>PHPBB3-9664</a>] - Another duplicate accesskey: t = top and list item

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9665'>PHPBB3-9665</a>] - Signature &quot;0&quot; cannot be previewed

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9677'>PHPBB3-9677</a>] - Subsilver2 is missing the bbcode-helpline for inline-attachments.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9678'>PHPBB3-9678</a>] - Flash attachments are not displayed in subsilver2.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9679'>PHPBB3-9679</a>] - &quot;Notify User&quot; checkbox appears in MCP Queue even if no notification methods are enabled

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9686'>PHPBB3-9686</a>] - Unable to create data backup using the mssqlnative DBAL

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9694'>PHPBB3-9694</a>] - Calling download/file.php with empty avatar parameter can throw an E_NOTICE message

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9695'>PHPBB3-9695</a>] - Bad Display of User Input - mcp_ban

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9696'>PHPBB3-9696</a>] - Installation of phpBB with SQLite fails

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9697'>PHPBB3-9697</a>] - Backlink broken when the select parent forum does not exist.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9698'>PHPBB3-9698</a>] - Returning result of new by reference is deprecated in php 5.3

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9702'>PHPBB3-9702</a>] - &quot;Ban until (date)&quot; appears to be based on UTC time instead of local time

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9703'>PHPBB3-9703</a>] - Removing a user does not remove their private message folders or rules

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9704'>PHPBB3-9704</a>] - Coding guidelines typo

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9712'>PHPBB3-9712</a>] - Future dates display as &quot;less than one minute ago&quot;

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9714'>PHPBB3-9714</a>] - &quot;Undefined variable: email&quot; in email regular expression unit tests

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9715'>PHPBB3-9715</a>] - Fix email address regular expression or adjust email regular expression unit tests

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9722'>PHPBB3-9722</a>] - &quot;New Topic&quot; button title attribute mismatch in prosilver&#39;s viewforum

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9727'>PHPBB3-9727</a>] - Feed replaces ./ with board URL

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9743'>PHPBB3-9743</a>] - Fix background-position of top2-class in prosilver for RTL-languages.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9744'>PHPBB3-9744</a>] - Mistyped word &#39;then&#39; in FAQ. It should be &#39;than&#39;.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9748'>PHPBB3-9748</a>] - &lt;br /&gt; not being replaced in prepare_message

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9749'>PHPBB3-9749</a>] - fulltext_mysql.php overreacts on + and - characters in search words

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9752'>PHPBB3-9752</a>] - Misleading text when using Q&amp;A CAPTCHA

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9754'>PHPBB3-9754</a>] - Template variable S_USER_POSTED always set to false in search.php

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9757'>PHPBB3-9757</a>] - Empty template variable HISTORY_TITLE in ucp_pm_history

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9760'>PHPBB3-9760</a>] - Fulltext native search, wildcard * does not get escaped leading to long execution time

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9761'>PHPBB3-9761</a>] - Quote nesting depth explanation is misleading

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9771'>PHPBB3-9771</a>] - build_url() doesn&#39;t ignore empty parameters

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9772'>PHPBB3-9772</a>] - Under some circumstances, email addresses are shown to undesired users

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9780'>PHPBB3-9780</a>] - gen_rand_string() not respecting $num_chars parameter anymore.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9782'>PHPBB3-9782</a>] - Board disable radio in Board-Settings set on when server load high

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9793'>PHPBB3-9793</a>] - Undefined function send_status_line() in download/file.php when in avatar mode.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9807'>PHPBB3-9807</a>] - Avatar tab displays when avatars are disabled

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9810'>PHPBB3-9810</a>] - Clicking on &quot;Select All&quot; of code tag on print page results in a javascript error when using prosilver

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9820'>PHPBB3-9820</a>] - Fix undefined indexes when trying to post a new topic

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9822'>PHPBB3-9822</a>] - Can not delete style-components from the file-system as per explanation.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9829'>PHPBB3-9829</a>] - Recaptcha plugin result interpretation fault

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9835'>PHPBB3-9835</a>] - Login Confirm Explain Not Working

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9840'>PHPBB3-9840</a>] - Display view unread posts link for guests

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9841'>PHPBB3-9841</a>] - Change &quot;Save&quot; button to &quot;Save draft&quot;

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9847'>PHPBB3-9847</a>] - Language typo and written form (British/American)

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9854'>PHPBB3-9854</a>] - Auth API documentation is incomplete

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9855'>PHPBB3-9855</a>] - Tests don&#39;t run on PHPUnit 3.5

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9879'>PHPBB3-9879</a>] - captcha_qa.php spelling, punctuation and grammar errors

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9883'>PHPBB3-9883</a>] - CAPTCHA uses american english

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9884'>PHPBB3-9884</a>] - Massive email delays

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9885'>PHPBB3-9885</a>] - Default file extension groups not properly updated by database updater.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9886'>PHPBB3-9886</a>] - Database updater does not run on PostgreSQL because of an error in _add_module()

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9888'>PHPBB3-9888</a>] - Update fails when Bing [Bot] was already added to the users table

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9891'>PHPBB3-9891</a>] - Updater drops language-selection after database-update

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9509'>PHPBB3-9509</a>] - phpBB Coding Guidelines state subversion as the version control system for phpBB

+</li>

+</ul>

+

+<h4> Improvement

+</h4>

+<ul>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-7332'>PHPBB3-7332</a>] - MCP post details usability

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-7717'>PHPBB3-7717</a>] - Use user&#39;s language for standard-extensions-group name

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-8709'>PHPBB3-8709</a>] - Multibyte keys in request_var not possible

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-8936'>PHPBB3-8936</a>] - subsilver2 missing reply-to-all feature

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9088'>PHPBB3-9088</a>] - Add missing semicolons in js files

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9179'>PHPBB3-9179</a>] - improve quasi-documentation of notify_status values

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9503'>PHPBB3-9503</a>] - Posts with empty titles in moderation queue are not easily approved

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9534'>PHPBB3-9534</a>] - user_ipwhois() does not support IPv6 addresses

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9536'>PHPBB3-9536</a>] - Small improvement for query against sessions table in acp_users.php

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9553'>PHPBB3-9553</a>] - Make git hooks run with /bin/sh instead of bash

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9570'>PHPBB3-9570</a>] - Change &quot;system timezone&quot; to &quot;guest timezone&quot; in acp, add explanation

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9578'>PHPBB3-9578</a>] - ACP Posting tab is missing &quot;Post settings&quot; module.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9589'>PHPBB3-9589</a>] - Sample nginx configuration file

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9595'>PHPBB3-9595</a>] - Search settings in ACP: Add information on minimum word size indexed when using Fulltext MySQL backend

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9598'>PHPBB3-9598</a>] - Call checkdnsrr() on Windows with PHP 5.3

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9609'>PHPBB3-9609</a>] - Use send_status_line instead of calling header

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9611'>PHPBB3-9611</a>] - Increase entropy in activation keys

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9612'>PHPBB3-9612</a>] - Split gen_rand_string() into gen_rand_string() and gen_rand_string_friendly()

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9629'>PHPBB3-9629</a>] - sid parameter forced for style.php makes caching difficult

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9659'>PHPBB3-9659</a>] - Default phpBB signature user_options need to be set for convertors

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9690'>PHPBB3-9690</a>] - MSN Bot will become Bing Bot

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9777'>PHPBB3-9777</a>] - Print useful error message in pre-commit hook when php is not installed.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9785'>PHPBB3-9785</a>] - Not able to recover a password when board disabled

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9825'>PHPBB3-9825</a>] - Run tests on sqlite if available and no test db configured

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9827'>PHPBB3-9827</a>] - IE9 Beta fixes IE8 textarea bug

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9830'>PHPBB3-9830</a>] - Awkward message when config.php is missing

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9850'>PHPBB3-9850</a>] - Allow version checker to display information on multiple releases

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9853'>PHPBB3-9853</a>] - Change default reCAPTCHA theme in Prosilver &amp; Subsilver2 to better coordinate with style color scheme

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9880'>PHPBB3-9880</a>] - Rename all mentions of CAPTCHA or visual confirmation to anti-bot

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9899'>PHPBB3-9899</a>] - Change the style in the ACP for the recaptcha to match that displayed on prosilver

+</li>

+</ul>

+

+<h4> New Feature

+</h4>

+<ul>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9039'>PHPBB3-9039</a>] - Native SQL Server Support mssqlnative.php

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9511'>PHPBB3-9511</a>] - View note for moderators on unapproved posts/topics with unapproved posts in ATOM Feed.

+</li>

+</ul>

+

+<h4> Task

+</h4>

+<ul>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9520'>PHPBB3-9520</a>] - Add web.config files for IIS

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9625'>PHPBB3-9625</a>] - Update database UNIT-test

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9701'>PHPBB3-9701</a>] - Enable notices in unit tests

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9768'>PHPBB3-9768</a>] - Create git commit-msg hook that verifies the commit message conforms to our standards

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9769'>PHPBB3-9769</a>] - Add install and uninstall scripts for the git hooks

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9770'>PHPBB3-9770</a>] - Git commit message should be prefilled with branch and ticket information

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9800'>PHPBB3-9800</a>] - Update tracker URL in docs/README.html

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9804'>PHPBB3-9804</a>] - Update docs/AUTHORS (DavidMJ &amp; igorw)

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9808'>PHPBB3-9808</a>] - Git commit message hook depends on GNU wc

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9816'>PHPBB3-9816</a>] - Remove config.php from git repository

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9848'>PHPBB3-9848</a>] - Add phpBB data files to .gitignore.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9849'>PHPBB3-9849</a>] - Create build script using phing

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9857'>PHPBB3-9857</a>] - Remove visible $Id$ from docs files.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9868'>PHPBB3-9868</a>] - Make the test suite run and pass using the mssqlnative driver

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9904'>PHPBB3-9904</a>] - Update WebPI Parameters.xml

+</li>

+</ul>

+

+<h4> Sub-task

+</h4>

+<ul>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9517'>PHPBB3-9517</a>] - Remote avatar upload does not check the filesize before and during transfer.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9562'>PHPBB3-9562</a>] - Advanced Search is inaccessible using the mssqlnative DBAL

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9564'>PHPBB3-9564</a>] - Reported messages are not assigned the default report reason when a reason is removed from the ACP using the mssqlnative DBAL

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9565'>PHPBB3-9565</a>] - It is impossible to create a custom profile field using the mssqlnative DBAL

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9566'>PHPBB3-9566</a>] - Two debug notices are displayed when setting a custom profile field though the UCP using the mssqlnative DBAL

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9583'>PHPBB3-9583</a>] - MSSQL native backups cannot be restored

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9606'>PHPBB3-9606</a>] - Drop redundant SQL query for unreads fetching

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9613'>PHPBB3-9613</a>] - Implement a load switch for unreads search feature.

+</li>

+<li>[<a href='http://tracker.phpbb.com/browse/PHPBB3-9817'>PHPBB3-9817</a>] - Make build script create blank config.php

+</li>

+</ul>

+

+

+ <a name="v307"></a><h3>1.ii. Changes since 3.0.7</h3>

+ <a name="v306"></a><h3>1.iii. Changes since 3.0.6</h3>

+ <a name="v305"></a><h3>1.iv. Changes since 3.0.5</h3>

+ <a name="v304"></a><h3>1.v. Changes since 3.0.4</h3>

+ <a name="v303"></a><h3>1.vi. Changes since 3.0.3</h3>

+ <a name="v302"></a><h3>1.vii. Changes since 3.0.2</h3>

+ <a name="v301"></a><h3>1.viii. Changes since 3.0.1</h3>

+ <a name="v300"></a><h3>1.ix Changes since 3.0.0</h3>

+ <a name="v30rc8"></a><h3>1.x. Changes since 3.0.RC8</h3>

+ <a name="v30rc7"></a><h3>1.xi. Changes since 3.0.RC7</h3>

+ <a name="v30rc6"></a><h3>1.xii. Changes since 3.0.RC6</h3>

+ <a name="v30rc5"></a><h3>1.xiii. Changes since 3.0.RC5</h3>

+ <a name="v30rc4"></a><h3>1.xiv. Changes since 3.0.RC4</h3>

+ <a name="v30rc3"></a><h3>1.xv. Changes since 3.0.RC3</h3>

+ <a name="v30rc2"></a><h3>1.xvi. Changes since 3.0.RC2</h3>

+ <a name="v30rc1"></a><h3>1.xvii. Changes since 3.0.RC1</h3>

+ <p>This package contains a number of archives, each contains the files changed from a given release to the latest version. You should select the appropriate archive for your current version, e.g. if you currently have <samp>3.0.7-PL1</samp> you should select the phpBB-3.0.7-PL1_to_3.0.8.zip/tar.gz file.</p>

+ <p>A number of patch files are provided to allow you to update from previous stable releases. Select the correct patch, e.g. if your current version is 3.0.5 you need the phpBB-3.0.7-PL1_to_3.0.8.patch file. Place the correct patch in the parent directory containing the phpBB3 core files (i.e. index.php, viewforum.php, etc.). With this done you should run the following command: <strong>patch -cl -d [PHPBB DIRECTORY] -p1 &lt; [PATCH NAME]</strong> (where PHPBB DIRECTORY is the directory name your phpBB Installation resides in, for example phpBB3, and where PATCH NAME is the relevant filename of the selected patch file). This should complete quickly, hopefully without any HUNK FAILED comments.</p>

+ <p><a href="http://tracker.phpbb.com/">http://tracker.phpbb.com/</a></p>

+ <li><a href="#acl_clear_prefetch">acl_clear_prefetch</a></li>

+ <li><a href="#acl_get_list">acl_get_list</a></li>

+ <li><a href="#misc">Miscellaneous</a></li>

+$result = $auth-&gt;acl_getf_global(<code>option</code>)

+ <a name="acl_clear_prefetch"></a><h3>2.vii. acl_clear_prefetch</h3>

+

+ <p>This method clears the user_permissions column in the users table for the given user. If the user ID passed is zero, the permissions cache is cleared for all users. This method should be called whenever permissions are set.</p>

+

+ <div class="codebox"><pre>

+// clear stored permissions for user 2

+$user_id = 2;

+$auth->acl_clear_prefetch($user_id);

+</pre></div>

+

+ <p>This method returns void.</p>

+

+ <a name="acl_get_list"></a><h3>2.viii. acl_get_list</h3>

+

+ <p>This method returns an an array describing which users have permissions in given fora. The resultant array contains an entry for permission that every user has in every forum when no arguments are passed.</p>

+

+ <div class="codebox"><pre>

+$user_id = array(2, 53);

+$permissions = array('f_list', 'f_read');

+$forum_id = array(1, 2, 3);

+$result = $auth-&gt;acl_get_list($user_id, $permissions, $forum_id);

+</pre></div>

+

+ <p>The parameters may be of the following legal types:</p>

+ <ul>

+ <li><strong>$user_id</strong>: <code>false</code>, int, array(int, int, int, ...)</li>

+ <li><strong>$permissions</strong>: <code>false</code>, string, array(string, string, ...)</li>

+ <li><strong>$forum_id</strong>: <code>false</code>, int, array(int, int, int, ...)</li>

+ </ul>

+

+ <a name="misc"></a><h3>2.ix. Miscellaneous</h3>

+

+ <p>There are other methods defined in the auth class which serve mostly as private methods, but are available for use if needed. Each of them is used to pull data directly from the database tables. They are:</p>

+ <ul>

+ <li><pre>function acl_group_raw_data($group_id = false, $opts = false, $forum_id = false)</pre></li>

+ <li><pre>function acl_user_raw_data($user_id = false, $opts = false, $forum_id = false)</pre></li>

+ <li><pre>function acl_raw_data_single_user($user_id)</pre></li>

+ <li><pre>function acl_raw_data($user_id = false, $opts = false, $forum_id = false)</pre></li>

+ <li><pre>function acl_role_data($user_type, $role_type, $ug_id = false, $forum_id = false)</pre></li>

+ </ul>

+

+ <p>Of these, <code>acl_raw_data</code> is the most general, but the others will be faster if you need a smaller amount of data.</p>

+

+ <div class="version">&nbsp;</div>

+ <li><a href="#commitmessage">Commit Messages and Repository Rules</a></li>

+ <p>Please note that these guidelines apply to all php, html, javascript and css files.</p>

+ <p>The version control system for phpBB3 is git. The repository is available at <a href="http://github.com/phpbb/phpbb3" title="repository">http://github.com/phpbb/phpbb3</a>.</p>

+ <li><strong>develop</strong><br />The latest unstable development version with new features etc.</li>

+ <li><strong>develop-*</strong><br />Development branches of stable phpBB releases. Branched off of <code>develop</code> at the time of feature freeze.

+ <li><strong>phpBB3.0</strong><code>develop-olympus</code><br />Development branch of the stable 3.0 line. Bug fixes are applied here.</li>

+ <li><strong>phpBB3.1</strong><code>develop-ascraeus</code><br />Development branch of the stable 3.1 line. Bug fixes are applied here.</li>

+ <li><strong>master</strong><br />A branch containing all stable phpBB3 release points</li>

+ <li><strong>tags</strong><br />Released versions. Stable ones get merged into the master branch.

+ <li><code>release-3.Y-BX</code><br />Beta release X of the 3.Y line.</li>

+ <li><code>release-3.Y-RCX</code><br />Release candidate X of the 3.Y line.</li>

+ <li><code>release-3.Y.Z-RCX</code><br />Release candidate X of the stable 3.Y.Z release.</li>

+ <li><code>release-3.0.X</code><br />Stable <strong>3.0.X</strong> release.</li>

+ <li><code>release-2.0.X</code><br />Old stable 2.0.X release.</li>

+ <a name="commitmessage"></a><h3>7.ii. Commit Messages and Repository Rules</h3>

+ <p>Information on repository rules, such as commit messages can be found at <a href="http://wiki.phpbb.com/display/DEV/Git" title="phpBB Git Information">http://wiki.phpbb.com/display/DEV/Git</a>.</p>

+ <div class="version">&nbsp;</div>

+ <div class="version">&nbsp;</div>

+# Sample nginx configuration file for phpBB.

+# Global settings have been removed, copy them

+# from your system's nginx.conf.

+# Tested with nginx 0.8.35.

+

+http {

+ # Compression - requires gzip and gzip static modules.

+ gzip on;

+ gzip_static on;

+ gzip_vary on;

+ gzip_http_version 1.1;

+ gzip_min_length 700;

+ gzip_comp_level 6;

+ gzip_disable "MSIE [1-6]\.";

+

+ # Catch-all server for requests to invalid hosts.

+ # Also catches vulnerability scanners probing IP addresses.

+ # Should be first.

+ server {

+ listen 80;

+ server_name bogus;

+ return 444;

+ root /var/empty;

+ }

+

+ # If you have domains with and without www prefix,

+ # redirect one to the other.

+ server {

+ listen 80;

+ server_name myforums.com;

+ rewrite ^(.*)$ http://www.myforums.com$1 permanent;

+ }

+

+ # The actual board domain.

+ server {

+ listen 80;

+ server_name www.myforums.com;

+

+ root /path/to/phpbb;

+

+ location / {

+ # phpbb uses index.htm

+ index index.php index.html index.htm;

+ }

+

+ # Deny access to internal phpbb files.

+ location ~ /(config\.php|common\.php|includes|cache|files|store|images/avatars/upload) {

+ deny all;

+ }

+

+ # Pass the php scripts to fastcgi server specified in upstream declaration.

+ location ~ \.php$ {

+ fastcgi_pass php;

+ # Necessary for php.

+ fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

+ # Unmodified fastcgi_params from nginx distribution.

+ include fastcgi_params;

+ }

+

+ # Deny access to version control system directories.

+ location ~ /\.svn|/\.git {

+ deny all;

+ }

+ }

+

+ # If running php as fastcgi, specify php upstream.

+ upstream php {

+ server unix:/tmp/php.sock;

+ }

+}

+ if (!defined('E_DEPRECATED'))

+ {

+ define('E_DEPRECATED', 8192);

+ }

+ error_reporting(E_ALL ^ E_NOTICE ^ E_DEPRECATED);

+

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

+ if (isset($filename[0]) && $filename[0] === 'g')

+ send_status_line(403, 'Forbidden');

+ send_status_line(403, 'Forbidden');

+ send_status_line(403, 'Forbidden');

+ send_status_line(403, 'Forbidden');

+ send_status_line(403, 'Forbidden');

+ send_status_line(403, 'Forbidden');

+ send_status_line(404, 'Not Found');

+ send_status_line(304, 'Not Modified');

+ // Convert smiley Relative paths to Absolute path, Windows style

+ $content = str_replace($phpbb_root_path . $config['smilies_path'], $board_url . '/' . $config['smilies_path'], $content);

+ $forum_ids = array_keys($auth->acl_getf('m_approve', true));

+ function is_moderator_approve_forum($forum_id)

+ {

+ static $forum_ids;

+

+ if (!isset($forum_ids))

+ {

+ $forum_ids = array_flip($this->get_moderator_approve_forums());

+ }

+

+ if (!$forum_id)

+ {

+ // Global announcement, your a moderator in any forum than it's okay.

+ return (!empty($forum_ids)) ? true : false;

+ }

+

+ return (isset($forum_ids[$forum_id])) ? true : false;

+ }

+

+ . ' ' . $this->separator_stats . ' ' . $user->format_date($row['post_time'])

+ . (($this->is_moderator_approve_forum($row['forum_id']) && !$row['post_approved']) ? ' ' . $this->separator_stats . ' ' . $user->lang['POST_UNAPPROVED'] : '');

+ . ' ' . $this->separator_stats . ' ' . $user->lang['REPLIES'] . ' ' . (($this->is_moderator_approve_forum($row['forum_id'])) ? $row['topic_replies_real'] : $row['topic_replies'])

+ . ' ' . $this->separator_stats . ' ' . $user->lang['VIEWS'] . ' ' . $row['topic_views']

+ . (($this->is_moderator_approve_forum($row['forum_id']) && ($row['topic_replies_real'] != $row['topic_replies'])) ? ' ' . $this->separator_stats . ' ' . $user->lang['POSTS_UNAPPROVED'] : '');

+ 'p.post_id, p.topic_id, p.post_time, p.post_approved, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ POSTS_TABLE => 'p',

+ 'SELECT' => 'p.post_id, p.topic_id, p.post_time, p.post_approved, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ $in_fid_ary = array_intersect($in_fid_ary, $this->get_moderator_approve_forums());

+ 'SELECT' => 'p.post_id, p.post_time, p.post_approved, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_replies, t.topic_replies_real, t.topic_views, t.topic_time,

+ t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_replies, t.topic_replies_real, t.topic_views, t.topic_time,

+ t.topic_id, t.topic_title, t.topic_replies, t.topic_replies_real, t.topic_views,

+<Files *>

+ Order Allow,Deny

+ Deny from All

+</Files>

+ if (!function_exists('phpbb_is_writable'))

+ {

+ global $phpbb_root_path;

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

+ }

+

+ if (!phpbb_is_writable($this->cache_dir))

+ if (!function_exists('phpbb_is_writable'))

+ {

+ global $phpbb_root_path, $phpEx;

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

+ }

+

+ if ($check && !phpbb_is_writable($this->cache_dir))

+if (!defined('PHPBB_ACM_MEMCACHE'))

+{

+ //can define multiple servers with host1/port1,host2/port2 format

+ define('PHPBB_ACM_MEMCACHE', PHPBB_ACM_MEMCACHE_HOST . '/' . PHPBB_ACM_MEMCACHE_PORT);

+}

+

+ foreach(explode(',', PHPBB_ACM_MEMCACHE) as $u)

+ {

+ $parts = explode('/', $u);

+ $this->memcache->addServer(trim($parts[0]), trim($parts[1]));

+ }

+?>

+ if (!function_exists('phpbb_is_writable'))

+ {

+ global $phpbb_root_path, $phpEx;

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

+ }

+

+ if ($check && !phpbb_is_writable($this->cache_dir))

+ $row['group_name'] = (isset($user->lang['EXT_GROUP_' . $row['group_name']])) ? $user->lang['EXT_GROUP_' . $row['group_name']] : $row['group_name'];

+ if ($group_id)

+ {

+ $sql .= ' AND group_id <> ' . $group_id;

+ }

+ $group_name = (isset($user->lang['EXT_GROUP_' . $group_name])) ? $user->lang['EXT_GROUP_' . $group_name] : $group_name;

+ 'GROUP_NAME' => (isset($user->lang['EXT_GROUP_' . $row['group_name']])) ? $user->lang['EXT_GROUP_' . $row['group_name']] : $row['group_name'],

+ $row['group_name'] = (isset($user->lang['EXT_GROUP_' . $row['group_name']])) ? $user->lang['EXT_GROUP_' . $row['group_name']] : $row['group_name'];

+ if (!phpbb_is_writable($phpbb_root_path . $upload_dir))

+ 'A_REASON' => addslashes($reason),

+ 'A_REASON' => addslashes($reason),

+ 'board_timezone' => array('lang' => 'SYSTEM_TIMEZONE', 'validate' => 'string', 'type' => 'select', 'function' => 'tz_select', 'params' => array('{CONFIG_VALUE}', 1), 'explain' => true),

+ 'load_unreads_search' => array('lang' => 'YES_UNREAD_SEARCH', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

+ $user->timezone = $config['board_timezone'] * 3600;

+ $user->dst = $config['board_dst'] * 3600;

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

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

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ $backup_files[(int) $matches[1]] = $file;

+ 'NAME' => $user->format_date($name, 'd-m-Y H:i:s', true),

+ else if($db->sql_layer === 'mssqlnative')

+ {

+ $this->write_data_mssqlnative($table_name);

+ }

+

+ function write_data_mssqlnative($table_name)

+ {

+ global $db;

+ $ary_type = $ary_name = array();

+ $ident_set = false;

+ $sql_data = '';

+

+ // Grab all of the data from current table.

+ $sql = "SELECT * FROM $table_name";

+ $db->mssqlnative_set_query_options(array('Scrollable' => SQLSRV_CURSOR_STATIC));

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

+

+ $retrieved_data = $db->mssqlnative_num_rows($result);

+

+ if (!$retrieved_data)

+ {

+ $db->sql_freeresult($result);

+ return;

+ }

+

+ $sql = "SELECT * FROM $table_name";

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

+

+ $row = new result_mssqlnative($result_fields);

+ $i_num_fields = $row->num_fields();

+

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

+ {

+ $ary_type[$i] = $row->field_type($i);

+ $ary_name[$i] = $row->field_name($i);

+ }

+ $db->sql_freeresult($result_fields);

+ $sql = "SELECT 1 as has_identity

+ FROM INFORMATION_SCHEMA.COLUMNS

+ WHERE COLUMNPROPERTY(object_id('$table_name'), COLUMN_NAME, 'IsIdentity') = 1";

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

+ $row2 = $db->sql_fetchrow($result2);

+

+ if (!empty($row2['has_identity']))

+ {

+ $sql_data .= "\nSET IDENTITY_INSERT $table_name ON\nGO\n";

+ $ident_set = true;

+ }

+ $db->sql_freeresult($result2);

+

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

+ {

+ $schema_vals = $schema_fields = array();

+

+ // Build the SQL statement to recreate the data.

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

+ {

+ $str_val = $row[$ary_name[$i]];

+

+ // defaults to type number - better quote just to be safe, so check for is_int too

+ if (is_int($ary_type[$i]) || preg_match('#char|text|bool|varbinary#i', $ary_type[$i]))

+ {

+ $str_quote = '';

+ $str_empty = "''";

+ $str_val = sanitize_data_mssql(str_replace("'", "''", $str_val));

+ }

+ else if (preg_match('#date|timestamp#i', $ary_type[$i]))

+ {

+ if (empty($str_val))

+ {

+ $str_quote = '';

+ }

+ else

+ {

+ $str_quote = "'";

+ }

+ }

+ else

+ {

+ $str_quote = '';

+ $str_empty = 'NULL';

+ }

+

+ if (empty($str_val) && $str_val !== '0' && !(is_int($str_val) || is_float($str_val)))

+ {

+ $str_val = $str_empty;

+ }

+

+ $schema_vals[$i] = $str_quote . $str_val . $str_quote;

+ $schema_fields[$i] = $ary_name[$i];

+ }

+

+ // Take the ordered fields and their associated data and build it

+ // into a valid sql statement to recreate that field in the data.

+ $sql_data .= "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES (' . implode(', ', $schema_vals) . ");\nGO\n";

+

+ $this->flush($sql_data);

+ $sql_data = '';

+ }

+ $db->sql_freeresult($result);

+

+ if ($ident_set)

+ {

+ $sql_data .= "\nSET IDENTITY_INSERT $table_name OFF\nGO\n";

+ }

+ $this->flush($sql_data);

+ }

+

+ $forum_data['show_active'] = ($forum_data['forum_type'] == FORUM_POST) ? request_var('display_recent', true) : request_var('display_active', false);

+ $copied_permissions = false;

+ $copied_permissions = true;

+ if ($auth->acl_get('a_fauth') && !$copied_permissions)

+ if ($action == 'add' && !$copied_permissions && $auth->acl_get('a_fauth'))

+ 'S_DISPLAY_ACTIVE_TOPICS' => ($forum_data['forum_type'] == FORUM_POST) ? ($forum_data['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS) : true,

+ 'S_ENABLE_ACTIVE_TOPICS' => ($forum_data['forum_type'] == FORUM_CAT) ? ($forum_data['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS) : false,

+ trigger_error($user->lang['PARENT_NOT_EXIST'] . adm_back_link($this->u_action . '&amp;parent_id=' . $this->parent_id), E_USER_WARNING);

+ // Delete shadow topics pointing to topics in this forum

+ delete_topic_shadows($forum_id);

+

+ // Amount of rows we select and delete in one iteration.

+ $batch_size = 500;

+

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

+ while (sizeof($ids) == $batch_size);

+ $can_upload = (file_exists($phpbb_root_path . $config['avatar_path']) && phpbb_is_writable($phpbb_root_path . $config['avatar_path']) && $file_uploads) ? true : false;

+ // Validate the length of "Maximum number of allowed recipients per private message" setting.

+ // We use 16777215 as a maximum because it matches MySQL unsigned mediumint maximum value

+ // which is the lowest amongst DBMSes supported by phpBB3

+ if ($max_recipients_error = validate_data($submit_ary, array('max_recipients' => array('num', false, 0, 16777215))))

+ {

+ // Replace "error" string with its real, localised form

+ $error = array_merge($error, array_map(array(&$user, 'lang'), $max_recipients_error));

+ }

+

+ if ($file[0] == '.' || !is_dir($phpbb_root_path . 'language/' . $file))

+ if (file_exists("{$phpbb_root_path}language/$file/iso.txt"))

+

+ phpinfo(INFO_GENERAL | INFO_CONFIGURATION | INFO_MODULES | INFO_VARIABLES);

+ case 'mssqlnative':

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

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

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

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

+ case 'mssqlnative':

+ if ($file[0] == '.' || !is_dir($phpbb_root_path . 'styles/' . $file))

+ if (file_exists("{$phpbb_root_path}styles/$file/$subpath$mode.cfg"))

+ if (!$safe_mode && !$template_info['template_storedb'] && file_exists($file) && phpbb_is_writable($file))

+ if (!$safe_mode && !$theme_info['theme_storedb'] && file_exists($file) && phpbb_is_writable($file))

+ if (($style_row["{$mode}_storedb"] != $store_db) && !$store_db && ($safe_mode || !phpbb_is_writable($check)))

+ else if (!$store_db && !$safe_mode && phpbb_is_writable("{$phpbb_root_path}styles/{$style_row['theme_path']}/theme/stylesheet.css"))

+ if (!$store_db && !$safe_mode && phpbb_is_writable("{$phpbb_root_path}styles/{$style_row['template_path']}/template"))

+ preg_match_all('/@import url\((["\'])(.*)\1\);/i', $stylesheet, $matches);

+

+ // remove commented stylesheets (very simple parser, allows only whitespace

+ // around an @import statement)

+ preg_match_all('#/\*\s*@import url\((["\'])(.*)\1\);\s\*/#i', $stylesheet, $commented);

+ $matches[2] = array_diff($matches[2], $commented[2]);

+ if (isset($matches[2][$idx]))

+ {

+ $stylesheet = str_replace($match, acp_styles::load_css_file($theme_row['theme_path'], $matches[2][$idx]), $stylesheet);

+ }

+ if (!$safe_mode && phpbb_is_writable("{$phpbb_root_path}styles/{$path}/template"))

+ // next feature release

+ $next_feature_version = $next_feature_announcement_url = false;

+ if (isset($info[2]) && trim($info[2]) !== '')

+ {

+ $next_feature_version = trim($info[2]);

+ $next_feature_announcement_url = trim($info[3]);

+ }

+

+ 'NEXT_FEATURE_VERSION' => $next_feature_version,

+ 'UPGRADE_INSTRUCTIONS' => $next_feature_version ? $user->lang('UPGRADE_INSTRUCTIONS', $next_feature_version, $next_feature_announcement_url) : false,

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

+ if ($delete_type)

+ if (confirm_box(true))

+ {

+ user_delete($delete_type, $user_id, $user_row['username']);

+ add_log('admin', 'LOG_USER_DELETED', $user_row['username']);

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

+ }

+ else

+ {

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

+ 'u' => $user_id,

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action,

+ 'update' => true,

+ 'delete' => 1,

+ 'delete_type' => $delete_type))

+ );

+ }

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

+ if ($user_id == ANONYMOUS)

+ {

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

+ }

+

+ $user_actkey = gen_rand_string(mt_rand(6, 10));

+ // Check if user has an active session

+ if ($user_row['session_id'])

+ {

+ // We'll update the session if user_allow_viewonline has changed and the user is a bot

+ // Or if it's a regular user and the admin set it to hide the session

+ if ($user_row['user_allow_viewonline'] != $sql_ary['user_allow_viewonline'] && $user_row['user_type'] == USER_IGNORE

+ || $user_row['user_allow_viewonline'] && !$sql_ary['user_allow_viewonline'])

+ {

+ // We also need to check if the user has the permission to cloak.

+ $user_auth = new auth();

+ $user_auth->acl($user_row);

+

+ $session_sql_ary = array(

+ 'session_viewonline' => ($user_auth->acl_get('u_hideonline')) ? $sql_ary['user_allow_viewonline'] : true,

+ );

+

+ $sql = 'UPDATE ' . SESSIONS_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', $session_sql_ary) . "

+ WHERE session_user_id = $user_id";

+ $db->sql_query($sql);

+

+ unset($user_auth);

+ }

+ }

+

+ $can_upload = (file_exists($phpbb_root_path . $config['avatar_path']) && phpbb_is_writable($phpbb_root_path . $config['avatar_path']) && $file_uploads) ? true : false;

+ if (avatar_process_user($error, $user_row, $can_upload))

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

+ 'post' => array('title' => 'ACP_POST_SETTINGS', 'auth' => 'acl_a_board', 'cat' => array('ACP_BOARD_CONFIGURATION', 'ACP_MESSAGES')),

+ WHERE user_id = ' . (int) $row['user_id'] . '

+ AND user_login_attempts < ' . LOGIN_ATTEMPTS_MAX;

+ WHERE user_id = ' . (int) $row['user_id'] . '

+ AND user_login_attempts < ' . LOGIN_ATTEMPTS_MAX;

+ return $user->lang['LDAP_SEARCH_FAILED'];

+ $unicode = ((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) ? true : false;

+

+ if ($unicode)

+ // Unescape the asterisk to simplify further conversions

+ $row['word'] = str_replace('\*', '*', preg_quote($row['word'], '#'));

+

+ // Replace the asterisk inside the pattern, at the start and at the end of it with regexes

+ $row['word'] = preg_replace(array('#(?<=[\p{Nd}\p{L}_])\*(?=[\p{Nd}\p{L}_])#iu', '#^\*#', '#\*$#'), array('([\x20]*?|[\p{Nd}\p{L}_-]*?)', '[\p{Nd}\p{L}_-]*?', '[\p{Nd}\p{L}_-]*?'), $row['word']);

+

+ // Generate the final substitution

+ $censors['match'][] = '#(?<![\p{Nd}\p{L}_-])(' . $row['word'] . ')(?![\p{Nd}\p{L}_-])#iu';

+ case 'mssqlnative':

+ $this->code = gen_rand_string_friendly(mt_rand(CAPTCHA_MIN_CHARS, CAPTCHA_MAX_CHARS));

+ $this->code = gen_rand_string_friendly(mt_rand(CAPTCHA_MIN_CHARS, CAPTCHA_MAX_CHARS));

+ $this->code = gen_rand_string_friendly(mt_rand(CAPTCHA_MIN_CHARS, CAPTCHA_MAX_CHARS));

+ $this->code = gen_rand_string_friendly(mt_rand(CAPTCHA_MIN_CHARS, CAPTCHA_MAX_CHARS));

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

+define('PHPBB_VERSION', '3.0.8');

+// Maximum login attempts

+// The value is arbitrary, but it has to fit into the user_login_attempts field.

+define('LOGIN_ATTEMPTS_MAX', 100);

+

+// Notify status

+define('NOTIFY_YES', 0);

+define('NOTIFY_NO', 1);

+

+ 'mssqlnative' => array(

+ 'INT:' => '[int]',

+ 'BINT' => '[float]',

+ 'UINT' => '[int]',

+ 'UINT:' => '[int]',

+ 'TINT:' => '[int]',

+ 'USINT' => '[int]',

+ 'BOOL' => '[int]',

+ 'VCHAR' => '[varchar] (255)',

+ 'VCHAR:' => '[varchar] (%d)',

+ 'CHAR:' => '[char] (%d)',

+ 'XSTEXT' => '[varchar] (1000)',

+ 'STEXT' => '[varchar] (3000)',

+ 'TEXT' => '[varchar] (8000)',

+ 'MTEXT' => '[text]',

+ 'XSTEXT_UNI'=> '[varchar] (100)',

+ 'STEXT_UNI' => '[varchar] (255)',

+ 'TEXT_UNI' => '[varchar] (4000)',

+ 'MTEXT_UNI' => '[text]',

+ 'TIMESTAMP' => '[int]',

+ 'DECIMAL' => '[float]',

+ 'DECIMAL:' => '[float]',

+ 'PDECIMAL' => '[float]',

+ 'PDECIMAL:' => '[float]',

+ 'VCHAR_UNI' => '[varchar] (255)',

+ 'VCHAR_UNI:'=> '[varchar] (%d)',

+ 'VCHAR_CI' => '[varchar] (255)',

+ 'VARBINARY' => '[varchar] (255)',

+ ),

+

+ var $supported_dbms = array('firebird', 'mssql', 'mssqlnative', 'mysql_40', 'mysql_41', 'oracle', 'postgres', 'sqlite');

+ case 'mssqlnative':

+ $this->sql_layer = 'mssqlnative';

+ break;

+

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ * add_index: adding an index (can be column:index_size if you need to provide size)

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ // remove index length unless MySQL4

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

+ {

+ $column = preg_replace('#:.*$#', '', $column);

+ }

+

+ // add index size to definition as required by MySQL4

+ foreach ($column as $i => $col)

+ {

+ if (false !== strpos($col, ':'))

+ {

+ list($col, $index_size) = explode(':', $col);

+ $column[$i] = "$col($index_size)";

+ }

+ }

+ // no break

+ case 'mssqlnative':

+ if ($this->sql_layer == 'mssql' || $this->sql_layer == 'mssqlnative')

+ case 'mssqlnative':

+ * @param bool $use_cache forced to false for Interbase

+ function sql_server_info($raw = false, $use_cache = true)

+ /**

+ * force $use_cache false. I didn't research why the caching code there is no caching code

+ * but I assume its because the IB extension provides a direct method to access it

+ * without a query.

+ */

+

+ $use_cache = false;

+

+ * @param bool $use_cache If true, it is safe to retrieve the value from the cache

+ function sql_server_info($raw = false, $use_cache = true)

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('mssql_version')) === false)

+ if (!empty($cache) && $use_cache)

+ * @param bool $use_cache If true, it is safe to retrieve the value from the cache

+ function sql_server_info($raw = false, $use_cache = true)

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('mssqlodbc_version')) === false)

+ if (!empty($cache) && $use_cache)

+<?php

+/**

+*

+* @package dbal

+* @version $Id$

+* @copyright (c) 2010 phpBB Group

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

+*

+* This is the MS SQL Server Native database abstraction layer.

+* PHP mssql native driver required.

+* @author Chris Pucci

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

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

+

+/**

+ * Prior to version 1.1 the SQL Server Native PHP driver didn't support sqlsrv_num_rows, or cursor based seeking so we recall all rows into an array

+ * and maintain our own cursor index into that array.

+ */

+class result_mssqlnative

+{

+ public function result_mssqlnative($queryresult = false)

+ {

+ $this->m_cursor = 0;

+ $this->m_rows = array();

+ $this->m_num_fields = sqlsrv_num_fields($queryresult);

+ $this->m_field_meta = sqlsrv_field_metadata($queryresult);

+

+ while ($row = sqlsrv_fetch_array($queryresult, SQLSRV_FETCH_ASSOC))

+ {

+ if ($row !== null)

+ {

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

+ {

+ if (is_object($v) && method_exists($v, 'format'))

+ {

+ $row[$k] = $v->format("Y-m-d\TH:i:s\Z");

+ }

+ }

+ $this->m_rows[] = $row;//read results into memory, cursors are not supported

+ }

+ }

+

+ $this->m_row_count = count($this->m_rows);

+ }

+

+ private function array_to_obj($array, &$obj)

+ {

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

+ {

+ if (is_array($value))

+ {

+ $obj->$key = new stdClass();

+ array_to_obj($value, $obj->$key);

+ }

+ else

+ {

+ $obj->$key = $value;

+ }

+ }

+ return $obj;

+ }

+

+ public function fetch($mode = SQLSRV_FETCH_BOTH, $object_class = 'stdClass')

+ {

+ if ($this->m_cursor >= $this->m_row_count || $this->m_row_count == 0)

+ {

+ return false;

+ }

+

+ $ret = false;

+ $arr_num = array();

+

+ if ($mode == SQLSRV_FETCH_NUMERIC || $mode == SQLSRV_FETCH_BOTH)

+ {

+ foreach($this->m_rows[$this->m_cursor] as $key => $value)

+ {

+ $arr_num[] = $value;

+ }

+ }

+

+ switch ($mode)

+ {

+ case SQLSRV_FETCH_ASSOC:

+ $ret = $this->m_rows[$this->m_cursor];

+ break;

+ case SQLSRV_FETCH_NUMERIC:

+ $ret = $arr_num;

+ break;

+ case 'OBJECT':

+ $ret = $this->array_to_obj($this->m_rows[$this->m_cursor], $o = new $object_class);

+ break;

+ case SQLSRV_FETCH_BOTH:

+ default:

+ $ret = $this->m_rows[$this->m_cursor] + $arr_num;

+ break;

+ }

+ $this->m_cursor++;

+ return $ret;

+ }

+

+ public function get($pos, $fld)

+ {

+ return $this->m_rows[$pos][$fld];

+ }

+

+ public function num_rows()

+ {

+ return $this->m_row_count;

+ }

+

+ public function seek($iRow)

+ {

+ $this->m_cursor = min($iRow, $this->m_row_count);

+ }

+

+ public function num_fields()

+ {

+ return $this->m_num_fields;

+ }

+

+ public function field_name($nr)

+ {

+ $arr_keys = array_keys($this->m_rows[0]);

+ return $arr_keys[$nr];

+ }

+

+ public function field_type($nr)

+ {

+ $i = 0;

+ $int_type = -1;

+ $str_type = '';

+

+ foreach ($this->m_field_meta as $meta)

+ {

+ if ($nr == $i)

+ {

+ $int_type = $meta['Type'];

+ break;

+ }

+ $i++;

+ }

+

+ //http://msdn.microsoft.com/en-us/library/cc296183.aspx contains type table

+ switch ($int_type)

+ {

+ case SQLSRV_SQLTYPE_BIGINT: $str_type = 'bigint'; break;

+ case SQLSRV_SQLTYPE_BINARY: $str_type = 'binary'; break;

+ case SQLSRV_SQLTYPE_BIT: $str_type = 'bit'; break;

+ case SQLSRV_SQLTYPE_CHAR: $str_type = 'char'; break;

+ case SQLSRV_SQLTYPE_DATETIME: $str_type = 'datetime'; break;

+ case SQLSRV_SQLTYPE_DECIMAL/*($precision, $scale)*/: $str_type = 'decimal'; break;

+ case SQLSRV_SQLTYPE_FLOAT: $str_type = 'float'; break;

+ case SQLSRV_SQLTYPE_IMAGE: $str_type = 'image'; break;

+ case SQLSRV_SQLTYPE_INT: $str_type = 'int'; break;

+ case SQLSRV_SQLTYPE_MONEY: $str_type = 'money'; break;

+ case SQLSRV_SQLTYPE_NCHAR/*($charCount)*/: $str_type = 'nchar'; break;

+ case SQLSRV_SQLTYPE_NUMERIC/*($precision, $scale)*/: $str_type = 'numeric'; break;

+ case SQLSRV_SQLTYPE_NVARCHAR/*($charCount)*/: $str_type = 'nvarchar'; break;

+ case SQLSRV_SQLTYPE_NTEXT: $str_type = 'ntext'; break;

+ case SQLSRV_SQLTYPE_REAL: $str_type = 'real'; break;

+ case SQLSRV_SQLTYPE_SMALLDATETIME: $str_type = 'smalldatetime'; break;

+ case SQLSRV_SQLTYPE_SMALLINT: $str_type = 'smallint'; break;

+ case SQLSRV_SQLTYPE_SMALLMONEY: $str_type = 'smallmoney'; break;

+ case SQLSRV_SQLTYPE_TEXT: $str_type = 'text'; break;

+ case SQLSRV_SQLTYPE_TIMESTAMP: $str_type = 'timestamp'; break;

+ case SQLSRV_SQLTYPE_TINYINT: $str_type = 'tinyint'; break;

+ case SQLSRV_SQLTYPE_UNIQUEIDENTIFIER: $str_type = 'uniqueidentifier'; break;

+ case SQLSRV_SQLTYPE_UDT: $str_type = 'UDT'; break;

+ case SQLSRV_SQLTYPE_VARBINARY/*($byteCount)*/: $str_type = 'varbinary'; break;

+ case SQLSRV_SQLTYPE_VARCHAR/*($charCount)*/: $str_type = 'varchar'; break;

+ case SQLSRV_SQLTYPE_XML: $str_type = 'xml'; break;

+ default: $str_type = $int_type;

+ }

+ return $str_type;

+ }

+

+ public function free()

+ {

+ unset($this->m_rows);

+ return;

+ }

+}

+

+/**

+* @package dbal

+*/

+class dbal_mssqlnative extends dbal

+{

+ var $m_insert_id = NULL;

+ var $last_query_text = '';

+ var $query_options = array();

+

+ /**

+ * Connect to server

+ */

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

+ {

+ # Test for driver support, to avoid suppressed fatal error

+ if (!function_exists('sqlsrv_connect'))

+ {

+ trigger_error('Native MS SQL Server driver for PHP is missing or needs to be updated. Version 1.1 or later is required to install phpBB3. You can download the driver from: http://www.microsoft.com/sqlserver/2005/en/us/PHP-Driver.aspx\n', E_USER_ERROR);

+ }

+

+ //set up connection variables

+ $this->persistency = $persistency;

+ $this->user = $sqluser;

+ $this->dbname = $database;

+ $port_delimiter = (defined('PHP_OS') && substr(PHP_OS, 0, 3) === 'WIN') ? ',' : ':';

+ $this->server = $sqlserver . (($port) ? $port_delimiter . $port : '');

+

+ //connect to database

+ error_reporting(E_ALL);

+ $this->db_connect_id = sqlsrv_connect($this->server, array(

+ 'Database' => $this->dbname,

+ 'UID' => $this->user,

+ 'PWD' => $sqlpassword

+ ));

+

+ return ($this->db_connect_id) ? $this->db_connect_id : $this->sql_error('');

+ }

+

+ /**

+ * Version information about used database

+ * @param bool $raw if true, only return the fetched sql_server_version

+ * @param bool $use_cache If true, it is safe to retrieve the value from the cache

+ * @return string sql server version

+ */

+ function sql_server_info($raw = false, $use_cache = true)

+ {

+ global $cache;

+

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('mssql_version')) === false)

+ {

+ $arr_server_info = sqlsrv_server_info($this->db_connect_id);

+ $this->sql_server_version = $arr_server_info['SQLServerVersion'];

+

+ if (!empty($cache) && $use_cache)

+ {

+ $cache->put('mssql_version', $this->sql_server_version);

+ }

+ }

+

+ if ($raw)

+ {

+ return $this->sql_server_version;

+ }

+

+ return ($this->sql_server_version) ? 'MSSQL<br />' . $this->sql_server_version : 'MSSQL';

+ }

+

+ /**

+ * SQL Transaction

+ * @access private

+ */

+ function _sql_transaction($status = 'begin')

+ {

+ switch ($status)

+ {

+ case 'begin':

+ return sqlsrv_begin_transaction($this->db_connect_id);

+ break;

+

+ case 'commit':

+ return sqlsrv_commit($this->db_connect_id);

+ break;

+

+ case 'rollback':

+ return sqlsrv_rollback($this->db_connect_id);

+ break;

+ }

+ return true;

+ }

+

+ /**

+ * Base query method

+ *

+ * @param string $query Contains the SQL query which shall be executed

+ * @param int $cache_ttl Either 0 to avoid caching or the time in seconds which the result shall be kept in cache

+ * @return mixed When casted to bool the returned value returns true on success and false on failure

+ *

+ * @access public

+ */

+ function sql_query($query = '', $cache_ttl = 0)

+ {

+ if ($query != '')

+ {

+ global $cache;

+

+ // EXPLAIN only in extra debug mode

+ if (defined('DEBUG_EXTRA'))

+ {

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

+ }

+

+ $this->last_query_text = $query;

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

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

+

+ if ($this->query_result === false)

+ {

+ if (($this->query_result = @sqlsrv_query($this->db_connect_id, $query, array(), $this->query_options)) === false)

+ {

+ $this->sql_error($query);

+ }

+ // reset options for next query

+ $this->query_options = array();

+

+ if (defined('DEBUG_EXTRA'))

+ {

+ $this->sql_report('stop', $query);

+ }

+

+ if ($cache_ttl && method_exists($cache, 'sql_save'))

+ {

+ $this->open_queries[(int) $this->query_result] = $this->query_result;

+ $cache->sql_save($query, $this->query_result, $cache_ttl);

+ }

+ else if (strpos($query, 'SELECT') === 0 && $this->query_result)

+ {

+ $this->open_queries[(int) $this->query_result] = $this->query_result;

+ }

+ }

+ else if (defined('DEBUG_EXTRA'))

+ {

+ $this->sql_report('fromcache', $query);

+ }

+ }

+ else

+ {

+ return false;

+ }

+ return $this->query_result;

+ }

+

+ /**

+ * Build LIMIT query

+ */

+ function _sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

+ {

+ $this->query_result = false;

+

+ // total == 0 means all results - not zero results

+ if ($offset == 0 && $total !== 0)

+ {

+ if (strpos($query, "SELECT") === false)

+ {

+ $query = "TOP {$total} " . $query;

+ }

+ else

+ {

+ $query = preg_replace('/SELECT(\s*DISTINCT)?/Dsi', 'SELECT$1 TOP '.$total, $query);

+ }

+ }

+ else if ($offset > 0)

+ {

+ $query = preg_replace('/SELECT(\s*DISTINCT)?/Dsi', 'SELECT$1 TOP(10000000) ', $query);

+ $query = 'SELECT *

+ FROM (SELECT sub2.*, ROW_NUMBER() OVER(ORDER BY sub2.line2) AS line3

+ FROM (SELECT 1 AS line2, sub1.* FROM (' . $query . ') AS sub1) as sub2) AS sub3';

+

+ if ($total > 0)

+ {

+ $query .= ' WHERE line3 BETWEEN ' . ($offset+1) . ' AND ' . ($offset + $total);

+ }

+ else

+ {

+ $query .= ' WHERE line3 > ' . $offset;

+ }

+ }

+

+ $result = $this->sql_query($query, $cache_ttl);

+

+ return $result;

+ }

+

+ /**

+ * Return number of affected rows

+ */

+ function sql_affectedrows()

+ {

+ return ($this->db_connect_id) ? @sqlsrv_rows_affected($this->db_connect_id) : false;

+ }

+

+ /**

+ * Fetch current row

+ */

+ function sql_fetchrow($query_id = false)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

+ if (isset($cache->sql_rowset[$query_id]))

+ {

+ return $cache->sql_fetchrow($query_id);

+ }

+

+ if ($query_id === false)

+ {

+ return false;

+ }

+

+ $row = @sqlsrv_fetch_array($query_id, SQLSRV_FETCH_ASSOC);

+

+ if ($row)

+ {

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

+ {

+ $row[$key] = ($value === ' ' || $value === NULL) ? '' : $value;

+ }

+

+ // remove helper values from LIMIT queries

+ if (isset($row['line2']))

+ {

+ unset($row['line2'], $row['line3']);

+ }

+ }

+ return $row;

+ }

+

+ /**

+ * Seek to given row number

+ * rownum is zero-based

+ */

+ function sql_rowseek($rownum, &$query_id)

+ {

+ global $cache;

+

+ if (isset($cache->sql_rowset[$query_id]))

+ {

+ return $cache->sql_rowseek($rownum, $query_id);

+ }

+

+ $seek = new result_mssqlnative($query_id);

+ $row = $seek->seek($rownum);

+ return ($row = $seek->fetch()) ? $row : false;

+ }

+

+ /**

+ * Get last inserted id after insert statement

+ */

+ function sql_nextid()

+ {

+ $result_id = @sqlsrv_query($this->db_connect_id, 'SELECT @@IDENTITY');

+

+ if ($result_id !== false)

+ {

+ $row = @sqlsrv_fetch_array($result_id);

+ $id = $row[0];

+ @sqlsrv_free_stmt($result_id);

+ return $id;

+ }

+ else

+ {

+ return false;

+ }

+ }

+

+ /**

+ * Free sql result

+ */

+ function sql_freeresult($query_id = false)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

+ if (isset($cache->sql_rowset[$query_id]))

+ {

+ return $cache->sql_freeresult($query_id);

+ }

+

+ if (isset($this->open_queries[$query_id]))

+ {

+ unset($this->open_queries[$query_id]);

+ return @sqlsrv_free_stmt($query_id);

+ }

+ return false;

+ }

+

+ /**

+ * Escape string used in sql query

+ */

+ function sql_escape($msg)

+ {

+ return str_replace(array("'", "\0"), array("''", ''), $msg);

+ }

+

+ /**

+ * Build LIKE expression

+ * @access private

+ */

+ function _sql_like_expression($expression)

+ {

+ return $expression . " ESCAPE '\\'";

+ }

+

+ /**

+ * return sql error array

+ * @access private

+ */

+ function _sql_error()

+ {

+ $errors = @sqlsrv_errors(SQLSRV_ERR_ERRORS);

+ $error_message = '';

+ $code = 0;

+

+ if ($errors != null)

+ {

+ foreach ($errors as $error)

+ {

+ $error_message .= "SQLSTATE: ".$error[ 'SQLSTATE']."\n";

+ $error_message .= "code: ".$error[ 'code']."\n";

+ $code = $error['code'];

+ $error_message .= "message: ".$error[ 'message']."\n";

+ }

+ $this->last_error_result = $error_message;

+ $error = $this->last_error_result;

+ }

+ else

+ {

+ $error = (isset($this->last_error_result) && $this->last_error_result) ? $this->last_error_result : array();

+ }

+

+ return array(

+ 'message' => $error,

+ 'code' => $code,

+ );

+ }

+

+ /**

+ * Build db-specific query data

+ * @access private

+ */

+ function _sql_custom_build($stage, $data)

+ {

+ return $data;

+ }

+

+ /**

+ * Close sql connection

+ * @access private

+ */

+ function _sql_close()

+ {

+ return @sqlsrv_close($this->db_connect_id);

+ }

+

+ /**

+ * Build db-specific report

+ * @access private

+ */

+ function _sql_report($mode, $query = '')

+ {

+ switch ($mode)

+ {

+ case 'start':

+ $html_table = false;

+ @sqlsrv_query($this->db_connect_id, 'SET SHOWPLAN_TEXT ON;');

+ if ($result = @sqlsrv_query($this->db_connect_id, $query))

+ {

+ @sqlsrv_next_result($result);

+ while ($row = @sqlsrv_fetch_array($result))

+ {

+ $html_table = $this->sql_report('add_select_row', $query, $html_table, $row);

+ }

+ }

+ @sqlsrv_query($this->db_connect_id, 'SET SHOWPLAN_TEXT OFF;');

+ @sqlsrv_free_stmt($result);

+

+ if ($html_table)

+ {

+ $this->html_hold .= '</table>';

+ }

+ break;

+

+ case 'fromcache':

+ $endtime = explode(' ', microtime());

+ $endtime = $endtime[0] + $endtime[1];

+

+ $result = @sqlsrv_query($this->db_connect_id, $query);

+ while ($void = @sqlsrv_fetch_array($result))

+ {

+ // Take the time spent on parsing rows into account

+ }

+ @sqlsrv_free_stmt($result);

+

+ $splittime = explode(' ', microtime());

+ $splittime = $splittime[0] + $splittime[1];

+

+ $this->sql_report('record_fromcache', $query, $endtime, $splittime);

+

+ break;

+ }

+ }

+

+ /**

+ * Utility method used to retrieve number of rows

+ * Emulates mysql_num_rows

+ * Used in acp_database.php -> write_data_mssqlnative()

+ * Requires a static or keyset cursor to be definde via

+ * mssqlnative_set_query_options()

+ */

+ function mssqlnative_num_rows($res)

+ {

+ if ($res !== false)

+ {

+ return sqlsrv_num_rows($res);

+ }

+ else

+ {

+ return false;

+ }

+ }

+

+ /**

+ * Allows setting mssqlnative specific query options passed to sqlsrv_query as 4th parameter.

+ */

+ function mssqlnative_set_query_options($options)

+ {

+ $this->query_options = $options;

+ }

+}

+

+?>

+ * @param bool $use_cache If true, it is safe to retrieve the value from the cache

+ function sql_server_info($raw = false, $use_cache = true)

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('mysql_version')) === false)

+ if (!empty($cache) && $use_cache)

+ * @param bool $use_cache If true, it is safe to retrieve the value from the cache

+ function sql_server_info($raw = false, $use_cache = true)

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('mysqli_version')) === false)

+ if (!empty($cache) && $use_cache)

+ * @param bool $use_cache forced to false for Oracle

+ function sql_server_info($raw = false, $use_cache = true)

+ /**

+ * force $use_cache false. I didn't research why the caching code below is commented out

+ * but I assume its because the Oracle extension provides a direct method to access it

+ * without a query.

+ */

+

+ $use_cache = false;

+/* The code inside this comment block breaks clob handling, but does allow the

+ database restore script to work. If you want to allow no posts longer than 4KB

+ and/or need the db restore script, uncomment this.

+

+*/

+ // $sqlserver can carry a port separated by : for compatibility reasons

+ // If $sqlserver has more than one : it's probably an IPv6 address.

+ // In this case we only allow passing a port via the $port variable.

+ if (substr_count($sqlserver, ':') === 1)

+ if ($this->persistency)

+ {

+ $this->db_connect_id = (!$new_link) ? @pg_pconnect($connect_string) : @pg_pconnect($connect_string, PGSQL_CONNECT_FORCE_NEW);

+ }

+ else

+ {

+ $this->db_connect_id = (!$new_link) ? @pg_connect($connect_string) : @pg_connect($connect_string, PGSQL_CONNECT_FORCE_NEW);

+ }

+ * @param bool $use_cache If true, it is safe to retrieve the value from the cache

+ function sql_server_info($raw = false, $use_cache = true)

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('pgsql_version')) === false)

+ if (!empty($cache) && $use_cache)

+ * @param bool $use_cache if true, it is safe to retrieve the stored value from the cache

+ function sql_server_info($raw = false, $use_cache = true)

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('sqlite_version')) === false)

+

+ if (!empty($cache) && $use_cache)

+ {

+ $cache->put('sqlite_version', $this->sql_server_version);

+ }

+ set_var($_k, $_k, $sub_key_type, $multibyte);

+ $sql_update = 'CAST(CAST(config_value as DECIMAL(255, 0)) + ' . (int) $increment . ' as VARCHAR(255))';

+*

+* @return string

+ // [a, z] + [0, 9] = 36

+ return substr(strtoupper(base_convert(unique_id(), 16, 36)), 0, $num_chars);

+}

+

+/**

+* Generates a user-friendly alphanumeric random string of given length

+* We remove 0 and O so users cannot confuse those in passwords etc.

+*

+* @return string

+*/

+function gen_rand_string_friendly($num_chars = 8)

+{

+

+ // Remove Z and Y from the base_convert(), replace 0 with Z and O with Y

+ // [a, z] + [0, 9] - {z, y} = [a, z] + [0, 9] - {0, o} = 34

+ $rand_str = str_replace(array('0', 'O'), array('Z', 'Y'), strtoupper(base_convert($rand_str, 16, 34)));

+ if (is_readable($filename) && phpbb_is_writable($filename))

+ if ((!($perms & CHMOD_READ) || is_readable($filename)) && (!($perms & CHMOD_WRITE) || phpbb_is_writable($filename)))

+ if ((!($perms & CHMOD_READ) || is_readable($filename)) && (!($perms & CHMOD_WRITE) || phpbb_is_writable($filename)))

+ if (!@file_exists($resolved) || (!@is_dir($resolved . '/') && !is_file($resolved)))

+* @param string $sql_limit_offset Sets the offset of the first row to search, 0 to search from the start

+function get_unread_topics($user_id = false, $sql_extra = '', $sql_sort = '', $sql_limit = 1001, $sql_limit_offset = 0)

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

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

+ // Developers using the hook function need to globalise the $_SID and $_EXTRA_URL on their own and also handle it appropriately.

+ // They could mimic most of what is within this function

+ $failover_flag = false;

+

+ if (!$disable_cd_check && !file_exists($pathinfo['dirname']))

+ $url = str_replace('../', '', $url);

+ $pathinfo = pathinfo($url);

+ if (!file_exists($pathinfo['dirname']))

+ // fallback to "last known user page"

+ // at least this way we know the user does not leave the phpBB root

+ $url = generate_board_url() . '/' . $user->page['page'];

+ $failover_flag = true;

+ }

+ if (!$failover_flag)

+ {

+ // Is the uri pointing to the current directory?

+ if ($pathinfo['dirname'] == '.')

+ $url = str_replace('./', '', $url);

+

+ // Strip / from the beginning

+ if ($url && substr($url, 0, 1) == '/')

+ {

+ $url = substr($url, 1);

+ }

+

+ if ($user->page['page_dir'])

+ {

+ $url = generate_board_url() . '/' . $user->page['page_dir'] . '/' . $url;

+ }

+ else

+ {

+ $url = generate_board_url() . '/' . $url;

+ }

+ // Used ./ before, but $phpbb_root_path is working better with urls within another root path

+ $root_dirs = explode('/', str_replace('\\', '/', phpbb_realpath($phpbb_root_path)));

+ $page_dirs = explode('/', str_replace('\\', '/', phpbb_realpath($pathinfo['dirname'])));

+ $intersection = array_intersect_assoc($root_dirs, $page_dirs);

+ $root_dirs = array_diff_assoc($root_dirs, $intersection);

+ $page_dirs = array_diff_assoc($page_dirs, $intersection);

+ $dir = str_repeat('../', sizeof($root_dirs)) . implode('/', $page_dirs);

+ // Strip / from the end

+ if ($dir && substr($dir, -1, 1) == '/')

+ {

+ $dir = substr($dir, 0, -1);

+ }

+ // Strip / from the beginning

+ if ($dir && substr($dir, 0, 1) == '/')

+ {

+ $dir = substr($dir, 1);

+ }

+ $url = str_replace($pathinfo['dirname'] . '/', '', $url);

+ // Strip / from the beginning

+ if (substr($url, 0, 1) == '/')

+ {

+ $url = substr($url, 1);

+ }

+ $url = (!empty($dir) ? $dir . '/' : '') . $url;

+ $url = generate_board_url() . '/' . $url;

+ }

+ if ($key === '')

+ {

+ continue;

+ }

+

+/**

+* Outputs correct status line header.

+*

+* Depending on php sapi one of the two following forms is used:

+*

+* Status: 404 Not Found

+*

+* HTTP/1.x 404 Not Found

+*

+* HTTP version is taken from HTTP_VERSION environment variable,

+* and defaults to 1.0.

+*

+* Sample usage:

+*

+* send_status_line(404, 'Not Found');

+*

+* @param int $code HTTP status code

+* @param string $message Message for the status code

+* @return void

+*/

+function send_status_line($code, $message)

+{

+ if (substr(strtolower(@php_sapi_name()), 0, 3) === 'cgi')

+ {

+ // in theory, we shouldn't need that due to php doing it. Reality offers a differing opinion, though

+ header("Status: $code $message", true, $code);

+ }

+ else

+ {

+ if (isset($_SERVER['HTTP_VERSION']))

+ {

+ $version = $_SERVER['HTTP_VERSION'];

+ }

+ else

+ {

+ $version = 'HTTP/1.0';

+ }

+ header("$version $code $message", true, $code);

+ }

+}

+

+ // Regex written by James Watts and Francisco Jose Martin Moreno

+ // http://fightingforalostcause.net/misc/2006/compare-email-regex.php

+ return '([\w\!\#$\%\&\'\*\+\-\/\=\?\^\`{\|\}\~]+\.)*(?:[\w\!\#$\%\'\*\+\-\/\=\?\^\`{\|\}\~]|&amp;)+@((((([a-z0-9]{1}[a-z0-9\-]{0,62}[a-z0-9]{1})|[a-z])\.)+[a-z]{2,6})|(\d{1,3}\.){3}\d{1,3}(\:\d{1,5})?)';

+ return '#^(?:(?:(?:[\dA-F]{1,4}:){6}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:::(?:[\dA-F]{1,4}:){0,5}(?:[\dA-F]{1,4}(?::[\dA-F]{1,4})?|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:):(?:[\dA-F]{1,4}:){4}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,2}:(?:[\dA-F]{1,4}:){3}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,3}:(?:[\dA-F]{1,4}:){2}(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,4}:(?:[\dA-F]{1,4}:)(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,5}:(?:[\dA-F]{1,4}:[\dA-F]{1,4}|(?:(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])\.){3}(?:\d{1,2}|1\d\d|2[0-4]\d|25[0-5])))|(?:(?:[\dA-F]{1,4}:){1,6}:[\dA-F]{1,4})|(?:(?:[\dA-F]{1,4}:){1,7}:)|(?:::))$#i';

+* @param string $host Fully-Qualified Domain Name

+* @param string $type Resource record type to lookup

+* Supported types are: MX (default), A, AAAA, NS, TXT, CNAME

+* Other types may work or may not work

+* @return mixed true if entry found,

+* false if entry not found,

+* null if this function is not supported by this environment

+*

+* Since null can also be returned, you probably want to compare the result

+* with === true or === false,

+*

+* @author bantu

+function phpbb_checkdnsrr($host, $type = 'MX')

+ // The dot indicates to search the DNS root (helps those having DNS prefixes on the same domain)

+ if (substr($host, -1) == '.')

+ {

+ $host_fqdn = $host;

+ $host = substr($host, 0, -1);

+ }

+ else

+ {

+ $host_fqdn = $host . '.';

+ }

+ // $host has format some.host.example.com

+ // $host_fqdn has format some.host.example.com.

+

+ // If we're looking for an A record we can use gethostbyname()

+ if ($type == 'A' && function_exists('gethostbyname'))

+ {

+ return (@gethostbyname($host_fqdn) == $host_fqdn) ? false : true;

+ }

+

+ // checkdnsrr() is available on Windows since PHP 5.3,

+ // but until 5.3.3 it only works for MX records

+ // See: http://bugs.php.net/bug.php?id=51844

+

+ // Call checkdnsrr() if

+ // we're looking for an MX record or

+ // we're not on Windows or

+ // we're running a PHP version where #51844 has been fixed

+

+ // checkdnsrr() supports AAAA since 5.0.0

+ // checkdnsrr() supports TXT since 5.2.4

+ if (

+ ($type == 'MX' || DIRECTORY_SEPARATOR != '\\' || version_compare(PHP_VERSION, '5.3.3', '>=')) &&

+ ($type != 'AAAA' || version_compare(PHP_VERSION, '5.0.0', '>=')) &&

+ ($type != 'TXT' || version_compare(PHP_VERSION, '5.2.4', '>=')) &&

+ function_exists('checkdnsrr')

+ )

+ {

+ return checkdnsrr($host_fqdn, $type);

+ }

+

+ // dns_get_record() is available since PHP 5; since PHP 5.3 also on Windows,

+ // but on Windows it does not work reliable for AAAA records before PHP 5.3.1

+ // Call dns_get_record() if

+ // we're not looking for an AAAA record or

+ // we're not on Windows or

+ // we're running a PHP version where AAAA lookups work reliable

+ if (

+ ($type != 'AAAA' || DIRECTORY_SEPARATOR != '\\' || version_compare(PHP_VERSION, '5.3.1', '>=')) &&

+ function_exists('dns_get_record')

+ )

+ // dns_get_record() expects an integer as second parameter

+ // We have to convert the string $type to the corresponding integer constant.

+ $type_constant = 'DNS_' . $type;

+ $type_param = (defined($type_constant)) ? constant($type_constant) : DNS_ANY;

+

+ // dns_get_record() might throw E_WARNING and return false for records that do not exist

+ $resultset = @dns_get_record($host_fqdn, $type_param);

+

+ if (empty($resultset) || !is_array($resultset))

+ return false;

+ }

+ else if ($type_param == DNS_ANY)

+ {

+ // $resultset is a non-empty array

+ return true;

+ foreach ($resultset as $result)

+ {

+ if (

+ isset($result['host']) && $result['host'] == $host &&

+ isset($result['type']) && $result['type'] == $type

+ )

+ {

+ return true;

+ }

+ }

+

+ return false;

+ }

+

+ // If we're on Windows we can still try to call nslookup via exec() as a last resort

+ if (DIRECTORY_SEPARATOR == '\\' && function_exists('exec'))

+ {

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

+ $line = trim($line);

+

+ if (empty($line))

+ // Squash tabs and multiple whitespaces to a single whitespace.

+ $line = preg_replace('/\s+/', ' ', $line);

+

+ switch ($type)

+ case 'MX':

+ if (stripos($line, "$host MX") === 0)

+ {

+ return true;

+ }

+ break;

+

+ case 'NS':

+ if (stripos($line, "$host nameserver") === 0)

+ {

+ return true;

+ }

+ break;

+

+ case 'TXT':

+ if (stripos($line, "$host text") === 0)

+ {

+ return true;

+ }

+ break;

+

+ case 'CNAME':

+ if (stripos($line, "$host canonical name") === 0)

+ {

+ return true;

+ }

+

+ default:

+ case 'A':

+ case 'AAAA':

+ if (!empty($host_matches))

+ {

+ // Second line

+ if (stripos($line, "Address: ") === 0)

+ {

+ return true;

+ }

+ else

+ {

+ $host_matches = false;

+ }

+ }

+ else if (stripos($line, "Name: $host") === 0)

+ {

+ // First line

+ $host_matches = true;

+ }

+ break;

+ send_status_line(503, 'Service Unavailable');

+ if ($msg_text == 'ERROR_NO_ATTACHMENT' || $msg_text == 'NO_FORUM' || $msg_text == 'NO_TOPIC' || $msg_text == 'NO_USER')

+ {

+ send_status_line(404, 'Not Found');

+ }

+

+ send_status_line(401, 'Unauthorized');

+

+ send_status_line(401, 'Unauthorized');

+ 'S_LOGIN_REDIRECT' => build_hidden_fields(array('redirect' => build_url())),

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

+

+ 'T_STYLESHEET_LINK' => (!$user->theme['theme_storedb']) ? "{$web_path}styles/" . $user->theme['theme_path'] . '/theme/stylesheet.css' : append_sid("{$phpbb_root_path}style.$phpEx", 'id=' . $user->theme['style_id'] . '&amp;lang=' . $user->data['user_lang']),

+ if (!$ignore_acl && $auth->acl_gets(array('f_list', 'a_forum', 'a_forumadd', 'a_forumdel'), $row['forum_id']))

+ $forum_ids[] = (int) $row['forum_id'];

+ $topic_ids[] = (int) $row['topic_id'];

+ SET forum_id = ' . (int) $forum_row['forum_id'] . ", topic_id = $topic_id

+ $forum_ids[] = (int) $forum_row['forum_id'];

+ $table_ary = array(BOOKMARKS_TABLE, TOPICS_TRACK_TABLE, TOPICS_POSTED_TABLE, POLL_VOTES_TABLE, POLL_OPTIONS_TABLE, TOPICS_WATCH_TABLE, TOPICS_TABLE);

+* Deletes shadow topics pointing to a specified forum.

+*

+* @param int $forum_id The forum id

+* @param string $sql_more Additional WHERE statement, e.g. t.topic_time < (time() - 1234)

+* @param bool $auto_sync Will call sync() if this is true

+*

+* @return array Array with affected forums

+*

+* @author bantu

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

+ global $db;

+ if (!$forum_id)

+ // Nothing to do.

+ return;

+ }

+ // Set of affected forums we have to resync

+ $sync_forum_ids = array();

+ // Amount of topics we select and delete at once.

+ $batch_size = 500;

+ do

+ {

+ $sql = 'SELECT t2.forum_id, t2.topic_id

+ FROM ' . TOPICS_TABLE . ' t2, ' . TOPICS_TABLE . ' t

+ WHERE t2.topic_moved_id = t.topic_id

+ AND t.forum_id = ' . (int) $forum_id . '

+ ' . (($sql_more) ? 'AND ' . $sql_more : '');

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

+

+ $topic_ids = array();

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

+ {

+ $topic_ids[] = (int) $row['topic_id'];

+

+ $sync_forum_ids[(int) $row['forum_id']] = (int) $row['forum_id'];

+ }

+ $db->sql_freeresult($result);

+

+ if (!empty($topic_ids))

+ {

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

+ WHERE ' . $db->sql_in_set('topic_id', $topic_ids);

+ $db->sql_query($sql);

+ }

+ while (sizeof($topic_ids) == $batch_size);

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

+

+ return $sync_forum_ids;

+ case 'mssqlnative':

+ $info = get_remote_file('version.phpbb.com', '/phpbb',

+ /**

+ * Commented out, as adding the folders produces corrupted archives

+ */

+ /**

+ * Commented out, as adding the folders produces corrupted archives

+ */

+ $this->isgz = preg_match('#(\.tar\.gz|\.tgz)$#', $type);

+ $this->isbz = preg_match('#\.tar\.bz2$#', $type);

+ 'sig_bbcode' => array('bit' => 15, 'default' => 1),

+ 'sig_smilies' => array('bit' => 16, 'default' => 1),

+ 'sig_links' => array('bit' => 17, 'default' => 1),

+ case 'mssqlnative':

+ if (!phpbb_is_writable($path))

+ if (!phpbb_is_writable($trg_path))

+ if (!phpbb_is_writable($trg_path . $dir))

+ $folder_alt = ($forum_unread) ? 'UNREAD_POSTS' : 'NO_UNREAD_POSTS';

+ $s_subforums_list[] = '<a href="' . $subforum['link'] . '" class="subforum ' . (($subforum['unread']) ? 'unread' : 'read') . '" title="' . (($subforum['unread']) ? $user->lang['UNREAD_POSTS'] : $user->lang['NO_UNREAD_POSTS']) . '">' . $subforum['name'] . '</a>';

+ $pagination .= '<a href="' . $url . ($j == 0 ? '' : '&amp;start=' . $j) . '">' . $times . '</a>';

+ $folder_alt = ($unread_topic) ? 'UNREAD_POSTS' : (($topic_row['topic_status'] == ITEM_LOCKED) ? 'TOPIC_LOCKED' : 'NO_UNREAD_POSTS');

+ $fid_m_approve = $auth->acl_getf('m_approve', true);

+ $sql_m_approve = (!empty($fid_m_approve)) ? 'OR ' . $db->sql_in_set('forum_id', array_keys($fid_m_approve)) : '';

+

+ AND (post_approved = 1

+ $sql_m_approve)

+ AND (post_approved = 1

+ $sql_m_approve)

+ if ($notify_status != NOTIFY_YES)

+ SET notify_status = " . NOTIFY_YES . "

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

+ 'mssqlnative' => array(

+ 'LABEL' => 'MS SQL Server 2005+ [ Native ]',

+ 'SCHEMA' => 'mssql',

+ 'MODULE' => 'sqlsrv',

+ 'DELIM' => 'GO',

+ 'COMMENTS' => 'remove_comments',

+ 'DRIVER' => 'mssqlnative',

+ 'AVAILABLE' => true,

+ '2.0.x' => false,

+ ),

+ case 'mssqlnative':

+ case 'mssqlnative':

+ * Obtains exclusive lock on queue cache file.

+ * Returns resource representing the lock

+ */

+ function lock()

+ {

+ // For systems that can't have two processes opening

+ // one file for writing simultaneously

+ if (file_exists($this->cache_file . '.lock'))

+ {

+ $mode = 'rb';

+ }

+ else

+ {

+ $mode = 'wb';

+ }

+

+ $lock_fp = @fopen($this->cache_file . '.lock', $mode);

+

+ if ($mode == 'wb')

+ {

+ if (!$lock_fp)

+ {

+ // Two processes may attempt to create lock file at the same time.

+ // Have the losing process try opening the lock file again for reading

+ // on the assumption that the winning process created it

+ $mode = 'rb';

+ $lock_fp = @fopen($this->cache_file . '.lock', $mode);

+ }

+ else

+ {

+ // Only need to set mode when the lock file is written

+ @chmod($this->cache_file . '.lock', 0666);

+ }

+ }

+

+ if ($lock_fp)

+ {

+ @flock($lock_fp, LOCK_EX);

+ }

+

+ return $lock_fp;

+ }

+

+ /**

+ * Releases lock on queue cache file, using resource obtained from lock()

+ */

+ function unlock($lock_fp)

+ {

+ // lock() will return null if opening lock file, and thus locking, failed.

+ // Accept null values here so that client code does not need to check them

+ if ($lock_fp)

+ {

+ @flock($lock_fp, LOCK_UN);

+ fclose($lock_fp);

+ }

+ }

+

+ /**

+ $lock_fp = $this->lock();

+ set_config('last_queue_run', time(), true);

+ if (!file_exists($this->cache_file) || filemtime($this->cache_file) > time() - $config['queue_interval'])

+ $this->unlock($lock_fp);

+ /*

+ * This code is commented out because it causes problems on some web hosts.

+ * The core problem is rather restrictive email sending limits.

+ * This code is nly useful if you have no such restrictions from the

+ * web host and the package size setting is wrong.

+

+ */

+ $this->unlock($lock_fp);

+ $this->unlock($lock_fp);

+ $lock_fp = $this->lock();

+

+

+ $this->unlock($lock_fp);

+ $sql = 'SELECT smiley_url, MIN(emotion) as emotion, MIN(code) AS code, smiley_width, smiley_height, MIN(smiley_order) AS min_smiley_order

+ ORDER BY min_smiley_order';

+ 'S_CHECKED' => ($cur_topic_type == POST_NORMAL) ? ' checked="checked"' : '',

+ unset($rowset[$post_list[$i]]);

+ AND w.notify_status = " . NOTIFY_YES . '

+ AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')

+ AND fw.notify_status = " . NOTIFY_YES . '

+ AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')

+ $sql = 'UPDATE ' . TOPICS_WATCH_TABLE . '

+ SET notify_status = ' . NOTIFY_NO . "

+ $sql = 'UPDATE ' . FORUMS_WATCH_TABLE . '

+ SET notify_status = ' . NOTIFY_NO . "

+ markread('post', $data['forum_id'], $data['topic_id']);

+ if (($mode == 'reply' || $mode == 'quote' || $mode == 'post') && $post_approval)

+ // First of all make sure the subject are having the correct length.

+ $subject = truncate_string($subject);

+

+ $title = $row['message_subject'];

+

+ case 'mssqlnative':

+ // Date should display as the same date for every user regardless of timezone, so remove offset

+ // to compensate for the offset added by user::format_date()

+ return $user->format_date(gmmktime(0, 0, 0, $month, $day, $year) - ($user->timezone + $user->dst), $user->lang['DATE_FORMAT'], true);

+ else if ($row['field_default_value'] === '' && $row['field_type'] == FIELD_INT)

+ {

+ // We cannot insert an empty string into an integer column.

+ $row['field_default_value'] = NULL;

+ }

+ $name = (STRIP) ? stripslashes($upload_ary['name']) : $upload_ary['name'];

+ $name = trim(utf8_htmlspecialchars(utf8_basename($name)));

+ $this->realname = $this->uploadname = $name;

+ $block = @fread($fsock, 1024);

+ $filesize += strlen($block);

+

+ if ($this->max_filesize && $filesize > $this->max_filesize)

+ {

+ $max_filesize = get_formatted_filesize($this->max_filesize, false);

+

+ $file = new fileerror(sprintf($user->lang[$this->error_prefix . 'WRONG_FILESIZE'], $max_filesize['value'], $max_filesize['unit']));

+ return $file;

+ }

+

+ $data .= $block;

+ else if ($this->max_filesize && stripos($line, 'content-length: ') !== false)

+ {

+ $length = (int) str_replace('content-length: ', '', strtolower($line));

+

+ if ($length && $length > $this->max_filesize)

+ {

+ $max_filesize = get_formatted_filesize($this->max_filesize, false);

+

+ $file = new fileerror(sprintf($user->lang[$this->error_prefix . 'WRONG_FILESIZE'], $max_filesize['value'], $max_filesize['unit']));

+ return $file;

+ }

+ }

+ $user_row['group_id'] = $add_group_id;

+ $table_ary = array(USERS_TABLE, USER_GROUP_TABLE, TOPICS_WATCH_TABLE, FORUMS_WATCH_TABLE, ACL_USERS_TABLE, TOPICS_TRACK_TABLE, TOPICS_POSTED_TABLE, FORUMS_TRACK_TABLE, PROFILE_FIELDS_DATA_TABLE, MODERATOR_CACHE_TABLE, DRAFTS_TABLE, BOOKMARKS_TABLE, SESSIONS_KEYS_TABLE, PRIVMSGS_FOLDER_TABLE, PRIVMSGS_RULES_TABLE);

+ $time_offset = (isset($user->timezone) && isset($user->dst)) ? (int) $user->timezone + (int) $user->dst : 0;

+ $ban_end = max($current_time, gmmktime(0, 0, 0, (int)$ban_other[1], (int)$ban_other[2], (int)$ban_other[0]) - $time_offset);

+ // Do not allow banning yourself, the guest account, or founders.

+ $non_bannable = array($user->data['user_id'], ANONYMOUS);

+ $sql .= ' AND ' . $db->sql_in_set('user_id', array_merge(array_keys($founder), $non_bannable), true);

+ $sql .= ' AND ' . $db->sql_in_set('user_id', $non_bannable, true);

+* Internet Protocol Address Whois

+* RFC3912: WHOIS Protocol Specification

+* @param string $ip Ip address, either IPv4 or IPv6.

+*

+* @return string Empty string if not a valid ip address.

+* Otherwise make_clickable()'ed whois result.

+ if (empty($ip))

+ {

+ return '';

+ }

+ if (preg_match(get_preg_expression('ipv4'), $ip))

+ {

+ // IPv4 address

+ $whois_host = 'whois.arin.net.';

+ }

+ else if (preg_match(get_preg_expression('ipv6'), $ip))

+ {

+ // IPv6 address

+ $whois_host = 'whois.sixxs.net.';

+ }

+ else

+ $ipwhois = '';

+

+ if (($fsk = @fsockopen($whois_host, 43)))

+ // Test for referrals from $whois_host to other whois databases, roll on rwhois

+ // Use the result from $whois_host if we don't get any result here

+function avatar_process_user(&$error, $custom_userdata = false, $can_upload = null)

+ if (is_null($can_upload))

+ {

+ $can_upload = ($config['allow_avatar_upload'] && file_exists($phpbb_root_path . $config['avatar_path']) && phpbb_is_writable($phpbb_root_path . $config['avatar_path']) && $change_avatar && (@ini_get('file_uploads') || strtolower(@ini_get('file_uploads')) == 'on')) ? true : false;

+ }

+ list($sql_ary['user_avatar_width'], $sql_ary['user_avatar_height']) = getimagesize($phpbb_root_path . $config['avatar_gallery_path'] . '/' . $category . '/' . urldecode($sql_ary['user_avatar']));

+ if ($topic_data['enable_indexing'])

+ {

+ // Select the search method and do some additional checks to ensure it can actually be utilised

+ $search_type = basename($config['search_type']);

+

+ if (!file_exists($phpbb_root_path . 'includes/search/' . $search_type . '.' . $phpEx))

+ {

+ trigger_error('NO_SUCH_SEARCH_MODULE');

+ }

+

+ if (!class_exists($search_type))