+ <dd><input type="password" id="forum_password" name="forum_password" value="{FORUM_PASSWORD}" /></dd>

+<!-- IF S_CAN_USE_SSL -->

+ <dt><label for="jab_use_ssl">{L_JAB_USE_SSL}:</label><br /><span>{L_JAB_USE_SSL_EXPLAIN}</span></dt>

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

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

+<!-- ENDIF -->

+ <input class="button1" type="submit" name="next" value="{L_NEXT_STEP}" />

+ <script type="text/javascript">

+ <!--

+ /**

+ * Handle displaying/hiding the dimension fields

+ */

+ function display_options(value)

+ {

+ if (value == 0)

+ {

+ dE('img_dimensions', -1);

+ }

+ else

+ {

+ dE('img_dimensions', 1);

+ }

+ }

+

+ /**

+ * Init the wanted display functionality if javascript is enabled.

+ * If javascript is not available, the user is still able to properly administrate.

+ */

+ onload = function()

+ {

+ <!-- IF not IMAGE_SIZE -->

+ dE('img_dimensions', -1);

+ <!-- ENDIF -->

+ }

+ //-->

+ </script>

+ <option class="sep" value="" disabled="disabled">{category.NAME}</option>

+ <!-- BEGIN images --><option value="{category.images.VALUE}"<!-- IF category.images.SELECTED--> selected="selected"<!-- ENDIF -->>&nbsp;&nbsp;&nbsp;&nbsp;{category.images.TEXT}</option>

+ <dd><img src="{IMG_SRC}" id="newimg" alt="" /></dd>

+ <dd><label><input type="radio" class="radio" name="imgsize" id="imgsize" onclick="display_options(1);" value="1"<!-- IF IMAGE_SIZE --> checked="checked"<!-- ENDIF --> /> {L_YES}</label>

+ <label><input type="radio" class="radio" name="imgsize" onclick="display_options(0);" value="0"<!-- IF not IMAGE_SIZE --> checked="checked"<!-- ENDIF --> /> {L_NO}</label></dd>

+ <div id="img_dimensions">

+ <dl>

+ <dt><label for="imgwidth">{L_IMAGE_WIDTH}:</label><br /><span>{L_AUTOMATIC_EXPLAIN}</span></dt>

+ <dd><input type="text" name="imgwidth" value="{IMAGE_SIZE}" /></dd>

+ </dl>

+ <dl>

+ <dt><label for="imgheight">{L_IMAGE_HEIGHT}:</label><br /><span>{L_AUTOMATIC_EXPLAIN}</span></dt>

+ <dd><input type="text" name="imgheight" value="{IMAGE_HEIGHT}" /></dd>

+ </dl>

+ </div>

+ <td><a href="{attach.U_DOWNLOAD}">{attach.REAL_FILENAME}</a><br /><span class="small"><!-- IF attach.S_IN_MESSAGE --><strong>{L_PM}: </strong><!-- ELSE --><strong>{L_POST}: </strong><!-- ENDIF --><a href="{attach.U_VIEW_TOPIC}">{attach.TOPIC_TITLE}</a></span></td>

+ <p>{L_USER_NO_ATTACHMENTS}</p>

+#page-body.simple-page-body {

+.rtl #toggle {

+ left: 75%;

+ margin-right: 0;

+ margin-left: 6px;

+}

+

+.rtl #toggle-handle {

+ background-image: url(../images/toggle.gif);

+ background-position: 100% 50%;

+}

+

+ color: graytext;

+

+ <input class="button1" type="submit" name="submit" value="{L_NEXT_STEP}" />

+ <a href="{U_DB_UPDATE}" class="button1">{L_RUN_DATABASE_SCRIPT}</a>

+

+ <!-- input class="button1" type="submit" name="db_update" value="{L_CHECK_UPDATE_DATABASE}" / -->

+ font-size: 1em;

+ <fieldset class="quick">

+ </fieldset>

+

+ <!-- IF S_CONTENT_DIRECTION eq 'rtl' -->

+ handle.style.backgroundPosition = '0% 50%';

+ toggle.style.left = '96%';

+ <!-- ELSE -->

+ handle.style.backgroundPosition = '100% 50%';

+ toggle.style.left = '0';

+ <!-- ENDIF -->

+

+ <!-- IF S_CONTENT_DIRECTION eq 'rtl' -->

+ handle.style.backgroundPosition = '100% 50%';

+ toggle.style.left = '75%';

+ <!-- ELSE -->

+ handle.style.backgroundPosition = '0% 50%';

+ toggle.style.left = '15%';

+ <!-- ENDIF -->

+

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

+ 'ath_op_id' => array('INDEX', 'auth_option_id'),

+ 'post_subject' => array('XSTEXT_UNI', '', 'true_sort'),

+ 'i_d' => array('INDEX', 'imageset_id'),

+ '00C5' => 'ae', # Capital A with diaeresis

+ '00E4' => 'ae', # Small A with diaeresis

+ '00DC' => 'ue', # Capital U with diaeresis

+ '00FC' => 'ue', # Small U with diaeresis

+ Vic D'Elfant (Vic D'Elfant)

+Jabber Class (c) 2006 Flyspray.org, http://www.flyspray.org/

+hr {

+ height: 0;

+ color: #006600;

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

+ <li>[Fix] Tiny language and grammar changes</li>

+ <li>[Fix] Several style related fixes, mainly fixing cross-browser issues</li>

+ <li>[Fix] Several RTL fixes within prosilver</li>

+ <li>[Fix] MCP looses forum_id in some panels (Bug #11255)</li>

+ <li>[Fix] Moderation queue used unfriendly notification of no posts/topics (Bug #11291)</li>

+ <li>[Fix] Array in Oracle DBAL not always set (Bug #11475)</li>

+ <li>[Fix] Improper continue; in acp_styles.php (Bug #11523)</li>

+ <li>[Fix] Imageset editor more friendly (Bug #11511)</li>

+ <li>[Fix] Made Custom BBCode validation more strict (Bug #11335)</li>

+ <li>[Fix] Proper sync of data on topic copy (Bug #11335)</li>

+ <li>[Fix] Introduced ORDER BY clauses to converter queries (Bug #10697)</li>

+ <li>[Fix] Stopped bots from getting added to the registered users group during conversion (Bug #11283)</li>

+ <li>[Fix] Filled &quot;SMILIEYS_DISABLED&quot; template variable (Bug #11257)</li>

+ <li>[Fix] Properly escaped the delimiter in disallowed username comparisons (Bug #11339)</li>

+ <li>[Fix] Check global purge setting (Bug #11555)</li>

+ <li>[Fix] Improper magic url parsing applied to already parsed [url=] bbcode tag (Bug #11429)</li>

+ <li>[Fix] Renamed two indicies for Oracle support (Bug #11457)</li>

+ <li>[Fix] Added support for ISO-8859-8(-i) in the character set convertor (Bug #11265, #12039)</li>

+ <li>[Fix] Added support for Oracle's &quot;easy connect naming&quot;</li>

+ <li>[Fix] Let Mark/Unmark All work in Manage Drafts (Bug #11679)</li>

+ <li>[Fix] Display correct message if no attachments found in user administration (Bug #11629)</li>

+ <li>[Fix] Let the &quot;Delete all board cookies&quot; being displayed for guests too (only prosilver) (Bug #11603)</li>

+ <li>[Fix] Do not display view topic link in MCP while there is no link present (Bug #11573)</li>

+ <li>[Fix] MySQL now properly sorts by post_subject (Bug #11637)</li>

+ <li>[Fix] Introduced checks to stop negative postcounts (Bug #11561, #11421)</li>

+ <li>[Fix] Allow IP v4/v6 urls for remote avatars (Bug #11633)</li>

+ <li>[Fix] Delete avatar files automatically (Bug #11631)</li>

+ <li>[Fix] Automatically add selected columns to group by statements in the converter (Bug #11465)</li>

+ <li>[Fix] Allow posts without subjects to be clicked in the MCP (Bug #11483)</li>

+ <li>[Fix] Sync the forums that shadow topics reside in when the topic that they point to is deleted</li>

+ <li>[Fix] Do not use the gen_random_string function to create cookie names during install (Bug #11431)</li>

+ <li>[Fix] Send stylesheet in style.php even without a valid session id (Bug #11531)</li>

+ <li>[Fix] request_var should strictly return the requested number of dimensions</li>

+ <li>[Fix] Correct assignment of custom width to $user-&gt;img(); / Correctly display poll bars in subsilver2 (Bug #11301)</li>

+ <li>[Fix] Allow removing polls in prosilver</li>

+ <li>[Fix] Correct link to post in managing users attachments (Bug #11765)</li>

+ <li>[Fix] Reload confirm screen for selecting new forum for global topic type change if not postable forum is chosen (Bug #11711)</li>

+ <li>[Fix] Correctly show system default color for disabled options in Internet Explorer which does not support disabled option fields</li>

+ <li>[Fix] Update query for custom profiles in user management used wrong order for left/right delimiter (affecting mssql) (Bug #11781)</li>

+ <li>[Fix] Inconsistent display of more smileys link fixed (Bug #11801)</li>

+ <li>[Fix] Outbox messages are no always neither new nor unread post-conversion (Bug #11461)</li>

+ <li>[Feature] Replaced outdated jabber class with the one from the flyspray project</li>

+ <li>[Feature] The converter no longer relies on the smiley ID to decide if it should be displayed on the posting page</li>

+ <li>[Change] Limit maximum number of allowed characters in messages to 60.000 by default. Admins should increase their PHP time limits if they want to raise this tremedously.</li>

+ <li>[Change] Some changes to the conversion documentation</li>

+ <li>[Fix] Only use permissions from existing forums during the conversion (Bug #11417)</li>

+ <li>[Fix] Do not permit the decimal as a valid prefix character (Bug #11967)</li>

+ <li>[Fix] Account for the fact that the IM fields might hold non-IM information</li>

+ <li>[Fix] Make the queue function on post details</li>

+ <li>[Fix] Check if there are active styles left before deleting a style</li>

+ <li>[Fix] Correctly update styles after the deletion of an imageset.</li>

+ <li>[Fix] Replaced jabber validation to use the method used by the new jabber class (Bug #9822)</li>

+ <li>[Sec] Adding confirm boxes to UCP group actions (ToonArmy)</li>

+ <li>[Feature] Added the option to disable the flash bbcode globally (DelvarWorld)</li>

+ <li>[Sec] Changed the embedding of Flash (NeoThermic, DelvarWorld)</li>

+ <li>[Fix] Use the signature setting for PMs (Bug #12001)</li>

+ <li>[Fix] Made the DBMS selection use language variables (Bug #11969)</li>

+ <li>[Fix] Make sure that a folder is used when viewing messages to oneself (Bug #12105)</li>

+ <li>[Fix] Account for the fact that a board might have no visible Admins (Bug #12185)</li>

+ <li>[Fix] Change group ranks even if empty (Bug #12231)</li>

+ <li>[Fix] Correctly propagate variables across the custom profile field wizard (Bug #12237)</li>

+ <li>[Fix] Correctly move pm's into folders if more than one is received (Bug #12135)</li>

+ <li>[Fix] Corrected various bugs with CPF on multi-language boards (Bug #11803)</li>

+ <li>[Fix] Disable notify checkbox in posting editor when board email is disabled (Bug #12263)</li>

+ <li>[Fix] Removed maxlength from password/username fields (Bugs #12215, #11797)</li>

+ <li>[Fix] Use icon-unsubscribe in prosilver (Bug #12211)</li>

+ <li>[Fix] Seperated PREVIOUS/NEXT language vars for pagination and next/previous step (Bug #12197)</li>

+ <li>[Feature] append_sid() supporting anchor (Bug #11535) - patch provided by Schumi and ToonArmy</li>

+ <li>[Fix] Remember selected language while registering after submit (Bug #11435)</li>

+ <li>[Fix] UTF-8 support in theme and template editors (Bug #12251)</li>

+ <li>[Fix] Allow for posts per page in the MCP to change during topic selection (Bug #12067)</li>

+ <li>[Fix] Remove group avatars upon deletion from all profiles, not just the people having the group as default (Bug #12275, #12267)</li>

+ <li>[Fix] Allow for conversions to SQLite (Bug #12279) - patch provided by ToonArmy</li>

+ <li>[Fix] Apply colours to guests (Bug #12219)</li>

+ <li>[Fix] Set the Admin group as founder_manage during conversion (Bug #12287)</li>

+ <li>[Fix] Fixed a special quote BBCode case (Bug #12189)</li>

+ <li>[Fix] Correctly parse BBCodes in a post when a poll is being used (Bug #11833)</li>

+ <li>[Fix] Remember attached files on PM edit (Bug #12019)</li>

+ <li>[Fix] Correctly display poll ending on preview (Bug #12303)</li>

+ <li>[Feature] Display the success message on posting longer for posts awaiting approval (Bug #12053)</li>

+ <li>[Fix] Display maximum and entered number of characters for the &quot;maximum number of characters exceeded&quot; error messages (Bug #11981)</li>

+ <li>[Fix] Wrongly applied setting for allowing links in private messages (used the signature setting instead of the post setting) (Bug #11945)</li>

+ <li>[Fix] Unread flag for multipage topic wrongly set under some conditions (Bug #12127) - fix provided by asinshesq</li>

+ <li>[Fix] Able to delete posts within user prune panel (Bug #11849)</li>

+ <li>[Feature] Allow to specify dimensions of images manually on imageset config (Bug #11675)</li>

+ <li>[Fix] Correctly re-assign query result id after seeking rows (MSSQL/Firebird) (Bug #12369)</li>

+ <li>[Feature] Make effect of a changed hideonline permission instantaneous</li>

+ <li>[Fix] Do not overwrite larger memory values in the installer (Bug #12195)</li>

+ <li>[Fix] Order forums on role permission mask (Bug #12337)</li>

+ <li>[Fix] Show "no image" image when a non-selectable item was selected in the acp imageset editor - IE (Bug #12423)</li>

+ <li>[Fix] Update session information without new pageload (Bug #12393, Bug #12441)</li>

+ <li>[Fix] Let polls be edited correctly (Bug #12433)</li>

+ <li>[Fix] Overcome Oracle's inability to handle IN() clauses with over one thousand elements (Bug #12449)</li>

+ <li>[Fix] Simulate Firebird's affected rows mechanism for older versions of PHP</li>

+ <li>[Fix] Custom BBCodes properly handle lowercasing of parameterized tags (Bug #12377)</li>

+ <li>[Fix] Update the forum_id sequence for PostgreSQL during conversion (Bug #11927)</li>

+ <li>[Fix] Allow for multiple tags containing URL and LOCAL_URL tokens (Bug #12473)</li>

+ <li>[Fix] Properly display forum list in the MCP Queue (Bug #11313)</li>

+ <li>[Fix] Use the localised guest name for quotes (Bug #12483)</li>

+ <li>[Fix] Added post anchor to links in default warning message (Bug #12489)</li>

+ <li>[Fix] Allow 5 digits in editing time fields (Bug #12489)</li>

+ <li>[Fix] MS SQL DBAL drivers now write over extension limitations, they are too low for most installations (Bug #12415)</li>

+ <li>[Fix] Fix sorting by author on "unanswered posts" (Bug #12545)</li>

+ <li>[Fix] Allow searching for multibyte authors (Bug #11793)</li>

+ <li>[Fix] Writing directories/files with correct permissions using FTP for transfers on PHP4</li>

+ <li>[Fix] Oracle sequences during conversions are now corrected (Bug #12555)</li>

+ <li>[Fix] Allow users to continue after selecting "No" in the merge quickmod confirmation (Bug #12577)</li>

+ <li>[Fix] Correctly check permissions on the UCP subscription/bookmark pages (Bug #12595)</li>

+ <li>[Fix] Only convert non-orphaned PMs</li>

+ <li>[Fix] Fixed a few Postgres related errors (Bug #12587)</li>

+ <li>[Feature] New DBAL wrapper for LIKE expressions / sql_like_expression()</li>

+ <li>[Sec] Stricter validation of language entries. </li>

+

+hr {

+ height: 0;

+ color: #006600;

+ <li><a href="#convprob">Common conversion problems</a></li>

+

+ <p>Before converting we heavily recommend you do a <em>full backup of your database and files</em>! If you are unsure how to achieve this please ask your hosting provider for advice. You basically need to follow the basic instructions given for <a href="#install">New installations</a>. Please <strong>do not</strong> overwrite any old files - install phpBB3 at a different location.</p>

+

+ <p>Note that the conversion requires CREATE and DROP privileges for the phpBB3's database user account.</p>

+ <p>As with install the conversion is automated. Your previous 2.0.x database tables will not be changed as well as the original 2.0.x files remaining unaltered. The conversion is actually only filling your phpBB3 database tables and copying additional data over to your phpBB3 installation. This has the benefit that if something goes wrong you are able to either re-run the conversion or continue a conversion, while your old board is still accessible. We really recommend you disable your old installation while converting, else you may have inconsistent data after the conversion.</p>

+

+ <p>After verifying the settings in the ACP, you can delete the install directory to enable the board. The board will stay disabled until you do so.</p>

+

+<a name="convprob"></a><b>5.iv. Common conversion problems</b>

+<br /><br />

+

+<div class="paragraph">

+

+ <p><strong>Broken non-latin characters</strong> The conversion script assumes that the database encoding in the source phpBB2 matches the encoding defined in the <code>lang_main.php</code> file of the default language pack of the source installation. Edit that file to match the database's encoding and re-start the conversion procedure.</p>

+

+ <p><strong>http 500 / white pages</strong> The conversion is a load-heavy procedure. Restrictions imposed by some server hosting providers can cause problems. The most common causes are: too low values for the php settings <code>memory_limit</code> and <code>max_execution_time</code>. Limits on the allowed CPU time are also a frequent cause for such errors, as are caps on the number of database queries allowed. If you cannot change such settings, then contact your hosting provider or run the conversion procedure on a different computer. The phpBB.com forums are also an excellent location to ask for support.</p>

+

+ <p><strong>Password conversion</strong> Due to the utf-8 based handling of passwords in phpBB3, it is not always possible to transfer all passwords. For passwords "lost in translation" the easiest workaround is to use the "forgotten password" function.</p>

+

+ <p><strong>Path to your former board</strong> The converter expects the relative path to your old board's files. So, -for instance - if the new board is located at <code>http://www.yourdomain.com/forum</code> and the phpBB3 is located at <code>http://www.yourdomain.com/phpBB3</code>, then the correct value would be <code>../forum</code>. Note that the webserver user must be able to access the source installation's files.</p>

+

+ <p><strong>Missing images</strong> If your default board language's language pack does not include all images, then some images might be missing in your installation. Always use a complete language pack as default language.</p>

+

+ <p><strong>Smilies</strong> During the conversion you might see warnings about image files where the copying failed. That can happen if the old board's smilies have the same file names as those on the new board. Copy those files manually after the conversion, if you want to continue using the old smilies.</p>

+

+</div>

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

+<br /><br />

+

+

+

+/**

+* @copyright (c) 2005 phpBB Group

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

+ if (($action == 'modify' && strtolower($data['bbcode_tag']) !== strtolower($row['bbcode_tag'])) || ($action == 'create'))

+ '!([a-z0-9]+://)?([^< "\r\n\t\]]*?)!ie' => "(('\$1') ? '\$1\$2' : 'http://\$2')"

+ '!([^:]+/[^< "\r\n\t\]]*?)!' => '$1'

+ $bbcode_search = preg_replace('/.*?\[([a-z0-9_-]+)=?.*/i', '$1', $bbcode_match);

+

+ if (!preg_match('/^[a-zA-Z0-9_-]+=?$/', $bbcode_tag))

+ {

+ global $user;

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

+ }

+

+ $fp_match = preg_replace('#\[/?' . $bbcode_search . '#ie', "strtolower('\$0')", $fp_match);

+ $fp_replace = preg_replace('#\[/?' . $bbcode_search . '#ie', "strtolower('\$0')", $fp_replace);

+ $sp_match = preg_replace('#\[/?' . $bbcode_search . '#ie', "strtolower('\$0')", $sp_match);

+ $sp_replace = preg_replace('#\[/?' . $bbcode_search . '#ie', "strtolower('\$0')", $sp_replace);

+/**

+* @copyright (c) 2005 phpBB Group

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

+ 'default_lang' => array('lang' => 'DEFAULT_LANGUAGE', 'validate' => 'lang', 'type' => 'select', 'function' => 'language_select', 'params' => array('{CONFIG_VALUE}'), 'explain' => false),

+ 'pm_edit_time' => array('lang' => 'PM_EDIT_TIME', 'validate' => 'int', 'type' => 'text:5:5', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

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

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

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

+/**

+* @copyright (c) 2005 phpBB Group

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

+ SET user_posts = 0

+ WHERE user_id = ' . $poster_id . '

+ AND user_posts < ' . $substract;

+ $db->sql_query($sql);

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ WHERE user_id = ' . $poster_id . '

+ AND user_posts >= ' . $substract;

+ avatar_delete('group', $group_row, true);

+/**

+* @copyright (c) 2005 phpBB Group

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

+ $jab_use_ssl = request_var('jab_use_ssl', $config['jab_use_ssl']);

+ if ($submit)

+ $error = array();

+ $message = $user->lang['JAB_SETTINGS_CHANGED'];

+ $log = 'JAB_SETTINGS_CHANGED';

+ // Is this feature enabled? Then try to establish a connection

+ if ($jab_enable)

+ $jabber = new jabber($jab_host, $jab_port, $jab_username, $jab_password, $jab_use_ssl);

+ if (!$jabber->connect())

+ trigger_error($user->lang['ERR_JAB_CONNECT'] . '<br /><br />' . $jabber->get_log() . adm_back_link($this->u_action), E_USER_WARNING);

+ // We'll try to authorise using this account

+ if (!$jabber->login())

+ trigger_error($user->lang['ERR_JAB_AUTH'] . '<br /><br />' . $jabber->get_log() . adm_back_link($this->u_action), E_USER_WARNING);

+ set_config('jab_enable', $jab_enable);

+ set_config('jab_host', $jab_host);

+ set_config('jab_port', $jab_port);

+ set_config('jab_username', $jab_username);

+ set_config('jab_password', $jab_password);

+ set_config('jab_package_size', $jab_package_size);

+ set_config('jab_use_ssl', $jab_use_ssl);

+ 'JAB_ENABLE' => $jab_enable,

+ 'JAB_HOST' => $jab_host,

+ 'JAB_PORT' => $jab_port,

+ 'JAB_USERNAME' => $jab_username,

+ 'JAB_PASSWORD' => $jab_password,

+ 'JAB_PACKAGE_SIZE' => $jab_package_size,

+ 'JAB_USE_SSL' => $jab_use_ssl,

+ 'S_CAN_USE_SSL' => jabber::can_use_ssl(),

+ ));

+ WHERE auth_option " . $db->sql_like_expression($permission_type . $db->any_char) . "

+ WHERE auth_option " . $db->sql_like_expression($permission_type . $db->any_char) . "

+ WHERE auth_option " . $db->sql_like_expression($permission_type . $db->any_char);

+/**

+* @copyright (c) 2005 phpBB Group

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

+ $psubmit = request_var('psubmit', array(0 => array(0 => 0)));

+ $inherit = request_var('inherit', array(0 => array(0)));

+ $sql_permission_option = ' AND o.auth_option ' . $db->sql_like_expression($permission_type . $db->any_char);

+

+/**

+* @copyright (c) 2005 phpBB Group

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

+ else if ($field_type == FIELD_TEXT && $key == 'field_length')

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

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

+ {

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

+ }

+ else if ($key == 'l_lang_options' && is_array($cp->vars[$key]))

+

+ if ($field_type == FIELD_TEXT && $key == 'field_length' && isset($_REQUEST['rows']))

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

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

+ $_new_key_ary[$key] = $cp->vars['rows'] . '|' . $cp->vars['columns'];

+ }

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

+ {

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

+

+ if (!isset($_REQUEST[$key]))

+ {

+ $var = false;

+ }

+ else

+ {

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

+ }

+

+ if ($field_type != FIELD_BOOL)

+ {

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

+ }

+ else

+ {

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

+ }

+ $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD $field_ident ";

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

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

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

+/**

+* @copyright (c) 2005 phpBB Group

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

+ 'L_CONTINUE' => ($this->state[1] == 'create') ? $user->lang['CONTINUE_INDEXING'] : $user->lang['CONTINUE_DELETING_INDEX'],

+ 'L_CONTINUE_EXPLAIN' => ($this->state[1] == 'create') ? $user->lang['CONTINUE_INDEXING_EXPLAIN'] : $user->lang['CONTINUE_DELETING_INDEX_EXPLAIN'])

+/**

+* @copyright (c) 2005 phpBB Group

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

+# @copyright (c) 2005 phpBB Group

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

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

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

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

+

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

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

+ if (!$imgwidth || !$imgheight)

+ {

+ list($imgwidth_file, $imgheight_file) = getimagesize("{$phpbb_root_path}styles/$imageset_path/imageset/$imgpath");

+ $imgwidth = ($imgwidth) ? $imgwidth : $imgwidth_file;

+ $imgheight = ($imgheight) ? $imgheight : $imgheight_file;

+ }

+ }

+

+ if ($dp2)

+ while (($file2 = readdir($dp2)) !== false)

+ if (preg_match('#\.(?:gif|jpg|png)$#', $file2))

+ {

+ $imagesetlist['lang'][] = "$imgnamelang/$file2";

+ }

+ closedir($dp2);

+ $image_found = false;

+ $img_val = '';

+ $image_found = true;

+ $img_val = htmlspecialchars($img);

+ 'IMAGE_SIZE' => $image_width,

+ 'IMAGE_HEIGHT' => $image_height,

+ 'IMAGE_REQUEST' => (empty($image_filename)) ? 'images/no_image.png' : $image_request,

+ 'ERROR' => !$valid_name,

+ 'IMG_SRC' => ($image_found) ? '../styles/' . $imageset_path . '/imageset/' . $img_val : 'images/no_image.png',

+ 'IMAGE_SELECT' => $image_found

+ $sql_where = '';

+ $sql_where = 'AND style_active = 1';

+ WHERE {$mode}_id <> $style_id

+ $sql_where

+ if ($mode == 'imageset')

+ {

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

+ WHERE imageset_id = $style_id";

+ $db->sql_query($sql);

+ }

+/**

+* @copyright (c) 2005 phpBB Group

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

+ trigger_error($errstr, E_USER_WARNING);

+/**

+* @copyright (c) 2005 phpBB Group

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

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

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

+ array('jabber')),

+ $cp_data[$left_delim . $key . $right_delim] = $value;

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

+ $view_topic = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "t={$row['topic_id']}&amp;p={$row['post_msg_id']}") . '#p' . $row['post_msg_id'];

+ FROM ' . ACL_OPTIONS_TABLE . '

+ WHERE auth_option ' . $db->sql_like_expression($db->any_char . '_') . '

+ AND is_global = 1

+

+ WHERE auth_option " . $db->sql_like_expression($db->any_char . '_') . "

+ AND is_local = 1

+ ORDER BY is_global DESC, auth_option";

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

+ ORDER BY left_id';

+ foreach ($forum_names as $forum_id => $forum_name)

+ $auth_ary = $hold_ary[$forum_id];

+ 'NAME' => ($forum_id == 0) ? $user->lang['GLOBAL_MASK'] : $forum_name,

+ $sql = 'SELECT auth_option, auth_option_id

+ FROM ' . ACL_OPTIONS_TABLE . "

+ WHERE auth_option " . $db->sql_like_expression($permission_type . $db->any_char);

+/**

+* @version $Id$

+* @copyright (c) 2005 phpBB Group

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

+ $sql_opts = "AND $key " . $db->sql_like_expression(str_replace('%', $db->any_char, $auth_options));

+ $sql[] = $key . ' ' . $db->sql_like_expression(str_replace('%', $db->any_char, $option));

+/**

+* @copyright (c) 2005 phpBB Group

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

+ $usernames[] = str_replace('%', '.*?', preg_quote(utf8_clean_string($row['disallow_username']), '#'));

+ * Wildcards for matching any (%) or exactly one (_) character within LIKE expressions

+ */

+ var $any_char;

+ var $one_char;

+

+ /**

+

+ // Do not change this please! This variable is used to easy the use of it - and is hardcoded.

+ $this->any_char = chr(0) . '%';

+ $this->one_char = chr(0) . '_';

+ * Correctly adjust LIKE expression for special characters

+ * Some DBMS are handling them in a different way

+ *

+ * @param string $expression The expression to use. Every wildcard is escaped, except $this->any_char and $this->one_char

+ * @return string LIKE expression including the keyword!

+ */

+ function sql_like_expression($expression)

+ {

+ $expression = str_replace(array('_', '%'), array("\_", "\%"), $expression);

+ $expression = str_replace(array(chr(0) . "\_", chr(0) . "\%"), array('_', '%'), $expression);

+

+ return $this->_sql_like_expression('LIKE \'' . $this->sql_escape($expression) . '\'');

+ }

+

+ /**

+ var $affected_rows = 0;

+ $array = array();

+ if (preg_match('/^(INSERT INTO[^(]++)\\(([^()]+)\\) VALUES[^(]++\\((.*?)\\)$/s', $query, $regs))

+ else if (preg_match('/^(UPDATE ([\\w_]++)\\s+SET )([\\w_]++\\s*=\\s*(?:\'(?:[^\']++|\'\')*+\'|\\d+)(?:,\\s*[\\w_]++\\s*=\\s*(?:\'(?:[^\']++|\'\')*+\'|\\d+))*+)\\s+(WHERE.*)$/s', $query, $data))

+ if (strlen($data[3]) > 32767)

+ $update = $data[1];

+ $where = $data[4];

+ preg_match_all('/(\\w++)\\s*=\\s*(\'(?:[^\']++|\'\')*+\'|\\d++)/', $data[3], $temp, PREG_SET_ORDER);

+ $cols = array();

+ $cols[] = $value[1] . '=?';

+ $cols[] = $value[1] . '=' . $value[2];

+ $query = $update . implode(', ', $cols) . ' ' . $where;

+ unset($cols);

+ if (!function_exists('ibase_affected_rows') && (preg_match('/^UPDATE ([\w_]++)\s+SET [\w_]++\s*=\s*(?:\'(?:[^\']++|\'\')*+\'|\d+)(?:,\s*[\w_]++\s*=\s*(?:\'(?:[^\']++|\'\')*+\'|\d+))*+\s+(WHERE.*)$/s', $query, $regs) || preg_match('/^DELETE FROM ([\w_]++)\s*WHERE\s*(.*)$/s', $query, $regs)))

+ $affected_sql = 'SELECT COUNT(*) as num_rows_affected FROM ' . $regs[1] . ' ' . $regs[2];

+

+ if (!($temp_q_id = @ibase_query($this->db_connect_id, $affected_sql)))

+ {

+ return false;

+ }

+

+ $temp_result = @ibase_fetch_assoc($temp_q_id);

+ @ibase_free_result($temp_q_id);

+

+ $this->affected_rows = ($temp_result) ? $temp_result['NUM_ROWS_AFFECTED'] : false;

+ }

+

+ if (sizeof($array))

+ {

+ $p_query = @ibase_prepare($this->db_connect_id, $query);

+ return $this->affected_rows;

+ function sql_rowseek($rownum, &$query_id)

+ * Build LIKE expression

+ * @access private

+ */

+ function _sql_like_expression($expression)

+ {

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

+ }

+

+ /**

+ @ini_set('mssql.textlimit', 2147483647);

+ @ini_set('mssql.textsize', 2147483647);

+ function sql_rowseek($rownum, &$query_id)

+ * Build LIKE expression

+ * @access private

+ */

+ function _sql_like_expression($expression)

+ {

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

+ }

+

+ /**

+ $html_table = false;

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

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

+ @mssql_next_result($result);

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

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

+ }

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

+ @mssql_free_result($result);

+ if ($html_table)

+ {

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

+ @ini_set('odbc.defaultlrl', 65536);

+ function sql_rowseek($rownum, &$query_id)

+ * Build LIKE expression

+ * @access private

+ */

+ function _sql_like_expression($expression)

+ {

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

+ }

+

+ /**

+ function sql_rowseek($rownum, &$query_id)

+ * Build LIKE expression

+ * @access private

+ */

+ function _sql_like_expression($expression)

+ {

+ return $expression;

+ }

+

+ /**

+ function sql_rowseek($rownum, &$query_id)

+ * Build LIKE expression

+ * @access private

+ */

+ function _sql_like_expression($expression)

+ {

+ return $expression;

+ }

+

+ /**

+/**

+* @copyright (c) 2005 phpBB Group

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

+

+ $connect = $database;

+

+ // support for "easy connect naming"

+ if ($sqlserver !== '' && $sqlserver !== '/')

+ {

+ if (substr($sqlserver, -1, 1) == '/')

+ {

+ $sqlserver == substr($sqlserver, 0, -1);

+ }

+ $connect = $sqlserver . (($port) ? ':' . $port : '') . '/' . $database;

+ }

+

+ $this->db_connect_id = ($new_link) ? @ocinlogon($this->user, $sqlpassword, $connect, 'UTF8') : (($this->persistency) ? @ociplogon($this->user, $sqlpassword, $connect, 'UTF8') : @ocilogon($this->user, $sqlpassword, $connect, 'UTF8'));

+ * Oracle specific code to handle the fact that it does not compare columns properly

+ * @access private

+ */

+ function _rewrite_col_compare($args)

+ {

+ if (sizeof($args) == 4)

+ {

+ if ($args[2] == '=')

+ {

+ return '(' . $args[0] . ' OR (' . $args[1] . ' is NULL AND ' . $args[3] . ' is NULL))';

+ }

+ else if ($args[2] == '<>')

+ {

+ // really just a fancy way of saying foo <> bar or (foo is NULL XOR bar is NULL) but SQL has no XOR :P

+ return '(' . $args[0] . ' OR ((' . $args[1] . ' is NULL AND ' . $args[3] . ' is NOT NULL) OR (' . $args[1] . ' is NOT NULL AND ' . $args[3] . ' is NULL)))';

+ }

+ }

+ else

+ {

+ return $this->_rewrite_where($args[0]);

+ }

+ }

+

+ /**

+ * Oracle specific code to handle it's lack of sanity

+ * @access private

+ */

+ function _rewrite_where($where_clause)

+ {

+ preg_match_all('/\s*(AND|OR)?\s*([\w_.]++)\s*(?:(=|<>)\s*((?>\'(?>[^\']++|\'\')*+\'|\d+))|((NOT )?IN\s*\((?>\'(?>[^\']++|\'\')*+\',? ?|\d+,? ?)*+\)))/', $where_clause, $result, PREG_SET_ORDER);

+ $out = '';

+ foreach ($result as $val)

+ {

+ if (!isset($val[5]))

+ {

+ if ($val[4] !== "''")

+ {

+ $out .= $val[0];

+ }

+ else

+ {

+ $out .= ' ' . $val[1] . ' ' . $val[2];

+ if ($val[3] == '=')

+ {

+ $out .= ' is NULL';

+ }

+ else if ($val[3] == '<>')

+ {

+ $out .= ' is NOT NULL';

+ }

+ }

+ }

+ else

+ {

+ $in_clause = array();

+ $sub_exp = substr($val[5], strpos($val[5], '(') + 1, -1);

+ $extra = false;

+ preg_match_all('/\'(?>[^\']++|\'\')*+\'|\d++/', $sub_exp, $sub_vals, PREG_PATTERN_ORDER);

+ $i = 0;

+ foreach ($sub_vals[0] as $sub_val)

+ {

+ // two things:

+ // 1) This determines if an empty string was in the IN clausing, making us turn it into a NULL comparison

+ // 2) This fixes the 1000 list limit that Oracle has (ORA-01795)

+ if ($sub_val !== "''")

+ {

+ $in_clause[(int) $i++/1000][] = $sub_val;

+ }

+ else

+ {

+ $extra = true;

+ }

+ }

+ if (!$extra && $i < 1000)

+ {

+ $out .= $val[0];

+ }

+ else

+ {

+ $out .= ' ' . $val[1] . '(';

+ $in_array = array();

+

+ // constuct each IN() clause

+ foreach ($in_clause as $in_values)

+ {

+ $in_array[] = $val[2] . ' ' . (isset($val[6]) ? $val[6] : '') . 'IN(' . implode(', ', $in_values) . ')';

+ }

+

+ // Join the IN() clauses against a few ORs (IN is just a nicer OR anyway)

+ $out .= implode(' OR ', $in_array);

+

+ // handle the empty string case

+ if ($extra)

+ {

+ $out .= ' OR ' . $val[2] . ' is ' . (isset($val[6]) ? $val[6] : '') . 'NULL';

+ }

+ $out .= ')';

+

+ unset($in_array, $in_clause);

+ }

+ }

+ }

+

+ return $out;

+ }

+

+ /**

+ $array = array();

+

+ if (preg_match('/^(INSERT INTO[^(]++)\\(([^()]+)\\) VALUES[^(]++\\((.*?)\\)$/s', $query, $regs))

+ else if (preg_match_all('/^(UPDATE [\\w_]++\\s+SET )([\\w_]++\\s*=\\s*(?:\'(?:[^\']++|\'\')*+\'|\\d+)(?:,\\s*[\\w_]++\\s*=\\s*(?:\'(?:[^\']++|\'\')*+\'|\\d+))*+)\\s+(WHERE.*)$/s', $query, $data, PREG_SET_ORDER))

+ preg_match_all('/([\\w_]++)\\s*=\\s*(\'(?:[^\']++|\'\')*+\'|\\d++)/', $data[0][2], $temp, PREG_SET_ORDER);

+ $cols = array();

+ $cols[] = $value[1] . '=:' . strtoupper($value[1]);

+ $cols[] = $value[1] . '=' . $value[2];

+ $query = $update . implode(', ', $cols) . ' ' . $where;

+ unset($cols);

+ switch (substr($query, 0, 6))

+ {

+ case 'DELETE':

+ if (preg_match('/^(DELETE FROM [\w_]++ WHERE)((?:\s*(?:AND|OR)?\s*[\w_]+\s*(?:(?:=|<>)\s*(?>\'(?>[^\']++|\'\')*+\'|\d+)|(?:NOT )?IN\s*\((?>\'(?>[^\']++|\'\')*+\',? ?|\d+,? ?)*+\)))*+)$/', $query, $regs))

+ {

+ $query = $regs[1] . $this->_rewrite_where($regs[2]);

+ unset($regs);

+ }

+ break;

+

+ case 'UPDATE':

+ if (preg_match('/^(UPDATE [\\w_]++\\s+SET [\\w_]+\s*=\s*(?:\'(?:[^\']++|\'\')*+\'|\\d++|:\w++)(?:, [\\w_]+\s*=\s*(?:\'(?:[^\']++|\'\')*+\'|\\d++|:\w++))*+\\s+WHERE)(.*)$/s', $query, $regs))

+ {

+ $query = $regs[1] . $this->_rewrite_where($regs[2]);

+ unset($regs);

+ }

+ break;

+

+ case 'SELECT':

+ $query = preg_replace_callback('/([\w_.]++)\s*(?:(=|<>)\s*(?>\'(?>[^\']++|\'\')*+\'|\d++|([\w_.]++))|(?:NOT )?IN\s*\((?>\'(?>[^\']++|\'\')*+\',? ?|\d++,? ?)*+\))/', array($this, '_rewrite_col_compare'), $query);

+ break;

+ }

+

+ // Oracle treats empty strings as null

+ if (is_null($value))

+ {

+ $value = '';

+ }

+

+

+ function sql_rowseek($rownum, &$query_id)

+ /**

+ * Build LIKE expression

+ * @access private

+ */

+ function _sql_like_expression($expression)

+ {

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

+ }

+

+

+ $html_table = false;

+

+ // Grab a plan table, any will do

+ $sql = "SELECT table_name

+ FROM USER_TABLES

+ WHERE table_name LIKE '%PLAN_TABLE%'";

+ $stmt = ociparse($this->db_connect_id, $sql);

+ ociexecute($stmt);

+ $result = array();

+

+ if (ocifetchinto($stmt, $result, OCI_ASSOC + OCI_RETURN_NULLS))

+ {

+ $table = $result['TABLE_NAME'];

+

+ // This is the statement_id that will allow us to track the plan

+ $statement_id = substr(md5($query), 0, 30);

+

+ // Remove any stale plans

+ $stmt2 = ociparse($this->db_connect_id, "DELETE FROM $table WHERE statement_id='$statement_id'");

+ ociexecute($stmt2);

+ ocifreestatement($stmt2);

+

+ // Explain the plan

+ $sql = "EXPLAIN PLAN

+ SET STATEMENT_ID = '$statement_id'

+ FOR $query";

+ $stmt2 = ociparse($this->db_connect_id, $sql);

+ ociexecute($stmt2);

+ ocifreestatement($stmt2);

+

+ // Get the data from the plan

+ $sql = "SELECT operation, options, object_name, object_type, cardinality, cost

+ FROM plan_table

+ START WITH id = 0 AND statement_id = '$statement_id'

+ CONNECT BY PRIOR id = parent_id

+ AND statement_id = '$statement_id'";

+ $stmt2 = ociparse($this->db_connect_id, $sql);

+ ociexecute($stmt2);

+

+ $row = array();

+ while (ocifetchinto($stmt2, $row, OCI_ASSOC + OCI_RETURN_NULLS))

+ {

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

+ }

+

+ ocifreestatement($stmt2);

+

+ // Remove the plan we just made, we delete them on request anyway

+ $stmt2 = ociparse($this->db_connect_id, "DELETE FROM $table WHERE statement_id='$statement_id'");

+ ociexecute($stmt2);

+ ocifreestatement($stmt2);

+ }

+

+ ocifreestatement($stmt);

+

+ if ($html_table)

+ {

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

+ }

+

+ function sql_rowseek($rownum, &$query_id)

+ * Build LIKE expression

+ * @access private

+ */

+ function _sql_like_expression($expression)

+ {

+ return $expression;

+ }

+

+ /**

+ function sql_rowseek($rownum, &$query_id)

+ * Correctly adjust LIKE expression for special characters

+ * For SQLite an underscore is a not-known character... this may change with SQLite3

+ */

+ function sql_like_expression($expression)

+ {

+ // Unlike LIKE, GLOB is case sensitive (unfortunatly). SQLite users need to live with it!

+ // We only catch * and ? here, not the character map possible on file globbing.

+ $expression = str_replace(array(chr(0) . '_', chr(0) . '%'), array(chr(0) . '?', chr(0) . '*'), $expression);

+

+ $expression = str_replace(array('?', '*'), array("\?", "\*"), $expression);

+ $expression = str_replace(array(chr(0) . "\?", chr(0) . "\*"), array('?', '*'), $expression);

+

+ return 'GLOB \'' . $this->sql_escape($expression) . '\'';

+ }

+

+ /**

+/**

+* @copyright (c) 2005 phpBB Group

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

+ if ($type == 'array')

+ {

+ reset($default);

+ list($sub_key_type, $sub_type) = each(current($default));

+ $sub_type = gettype($sub_type);

+ $sub_type = ($sub_type == 'array') ? 'NULL' : $sub_type;

+ $sub_key_type = gettype($sub_key_type);

+ }

+ set_var($k, $k, $key_type);

+ if ($type == 'array' && is_array($v))

+ if (is_array($_v))

+ {

+ $_v = null;

+ }

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

+ set_var($var[$k][$_k], $_v, $sub_type, $multibyte);

+ if ($type == 'array' || is_array($v))

+ {

+ $v = null;

+ }

+ AND (tt.topic_id IS NULL OR tt.mark_time < t.topic_last_post_time)

+ $anchor = '';

+ if (strpos($url, '#') !== false)

+ {

+ list($url, $anchor) = explode('#', $url, 2);

+ $anchor = '#' . $anchor;

+ }

+ else if (!is_array($params) && strpos($params, '#') !== false)

+ {

+ list($params, $anchor) = explode('#', $params, 2);

+ $anchor = '#' . $anchor;

+ }

+

+ if (!$session_id)

+ {

+ return $url . (($append_url) ? $url_delim . $append_url : '') . $anchor;

+ }

+ else

+ {

+ return $url . (($append_url) ? $url_delim . $append_url . $amp_delim : $url_delim) . 'sid=' . $session_id . $anchor;

+ }

+ if ($key == '#')

+ {

+ $anchor = '#' . $item;

+ continue;

+ }

+

+ return $url . (($append_url) ? $url_delim . $append_url . $amp_delim : $url_delim) . $params . ((!$session_id) ? '' : $amp_delim . 'sid=' . $session_id) . $anchor;

+

+ break;

+ $url = 'mailto:' . $url;

+ $magic_url_match[] = '#(^|[\n\t (>])(' . preg_quote($server_url, '#') . ')/(' . get_preg_expression('relative_url_inline') . ')#ie';

+ $magic_url_match[] = '#(^|[\n\t (>])(' . get_preg_expression('url_inline') . ')#ie';

+ $magic_url_match[] = '#(^|[\n\t (>])(' . get_preg_expression('www_url_inline') . ')#ie';

+ $magic_url_match[] = '/(^|[\n\t (>])(' . get_preg_expression('email') . ')/ie';

+ return preg_replace('#<!\-\- s(.*?) \-\-><img src="\{SMILIES_PATH\}\/(.*?) \/><!\-\- s\1 \-\->#', '<img src="' . $phpbb_root_path . $config['smilies_path'] . '/\2 />', $text);

+ $reading_sql = ' AND s.session_page ' . $db->sql_like_expression("{$db->any_char}_f_={$f}x{$db->any_char}");

+ if ($row['session_viewonline'])

+ if (($row['session_viewonline']) || $auth->acl_get('u_viewonline'))

+/**

+* @copyright (c) 2005 phpBB Group

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

+

+ $right = $padding = 0;

+ $padding_store = array('0' => 0);

+

+ if ($row['left_id'] < $right)

+ {

+ $padding++;

+ $padding_store[$row['parent_id']] = $padding;

+ }

+ else if ($row['left_id'] > $right + 1)

+ {

+ // Ok, if the $padding_store for this parent is empty there is something wrong. For now we will skip over it.

+ // @todo digging deep to find out "how" this can happen.

+ $padding = (isset($padding_store[$row['parent_id']])) ? $padding_store[$row['parent_id']] : $padding;

+ }

+

+ $right = $row['right_id'];

+ $row['padding'] = $padding;

+

+ unset($padding_store);

+ $moved_topic_ids = array();

+

+ // update the other forums

+ $sql = 'SELECT topic_id, forum_id

+ FROM ' . TOPICS_TABLE . '

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

+

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

+ {

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

+ $moved_topic_ids[] = $row['topic_id'];

+ }

+ $db->sql_freeresult($result);

+

+ if (sizeof($moved_topic_ids))

+ {

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

+ WHERE ' . $db->sql_in_set('topic_id', $moved_topic_ids);

+ $db->sql_query($sql);

+ }

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

+ SET user_posts = 0

+ WHERE user_id = ' . $poster_id . '

+ AND user_posts < ' . $substract;

+ $db->sql_query($sql);

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ WHERE user_id = ' . $poster_id . '

+ AND user_posts >= ' . $substract;

+ AND o.auth_option " . $db->sql_like_expression('m_' . $db->any_char),

+

+ case 'oracle':

+ $sql = 'SELECT SUM(bytes) as dbsize

+ FROM user_segments';

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

+ $database_size = ($row = $db->sql_fetchrow($result)) ? $row['dbsize'] : false;

+ $db->sql_freeresult($result);

+ break;

+/**

+* @copyright (c) 2006 phpBB Group

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

+ $result = $src_db->sql_query(str_replace('{' . strtoupper($group) . '}', $group_id . ' ', $select_query));

+ $sql = 'INSERT INTO ' . USER_GROUP_TABLE . " (user_id, group_id, user_pending)

+ VALUES ({$row['user_id']}, $group_id, 0)";

+ $convert->p_master->error($user->lang['CONV_ERROR_CONFIG_EMPTY'], __LINE__, __FILE__);

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

+ 'GUESTS' => array('', 0, 0),

+ 'REGISTERED' => array('', 0, 0),

+ 'REGISTERED_COPPA' => array('', 0, 0),

+ 'GLOBAL_MODERATORS' => array('00AA00', 1, 0),

+ 'ADMINISTRATORS' => array('AA0000', 1, 1),

+ 'BOTS' => array('9E8DA7', 0, 0)

+ 'group_founder_manage' => $data[2]

+

+/**

+* Sync post count. We might need to do this in batches.

+*/

+function sync_post_count($offset, $limit)

+{

+ global $db;

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

+ FROM ' . POSTS_TABLE . '

+ WHERE post_postcount = 1

+ GROUP BY poster_id

+ ORDER BY poster_id';

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

+

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

+ {

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

+ }

+ $db->sql_freeresult($result);

+}

+

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

+function get_smiley_display()

+{

+ static $smiley_count = 0;

+ $smiley_count++;

+ return ($smiley_count < 50) ? 1 : 0;

+}

+

+/**

+* @copyright (c) 2005 phpBB Group

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

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

+ if (!empty($forum_parents))

+ foreach ($forum_parents as $parent_forum_id => $parent_data)

+ list($parent_name, $parent_type) = array_values($parent_data);

+ // Skip this parent if the user does not have the permission to view it

+ if (!$auth->acl_get('f_list', $parent_forum_id))

+ {

+ continue;

+ }

+

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

+ 'S_IS_CAT' => ($parent_type == FORUM_CAT) ? true : false,

+ 'S_IS_LINK' => ($parent_type == FORUM_LINK) ? true : false,

+ 'S_IS_POST' => ($parent_type == FORUM_POST) ? true : false,

+ 'FORUM_NAME' => $parent_name,

+ 'FORUM_ID' => $parent_forum_id,

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

+ );

+ }

+ $s_watching['is_watching'] = $is_watching;

+/**

+* @copyright (c) 2006 phpBB Group

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

+ global $lang;

+ global $lang;

+

+ $dbms_options .= '<option value="' . $dbms_name . '"' . $selected .'>' . $lang['DLL_' . strtoupper($dbms_name)] . '</option>';

+ if (strpos($table_prefix, '-') !== false || strpos($table_prefix, '.') !== false)

+/**

+* @copyright (c) 2007 phpBB Group

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

+* Jabber class from Flyspray project

+* @version class.jabber2.php 1244 2007-05-28

+* @copyright 2006 Flyspray.org

+* @author: Florian Schmitz (floele)

+* Modified by Acyd Burn

+ var $connection = null;

+ var $session = array();

+ var $timeout = 10;

+

+ var $use_ssl;

+ var $features = array();

+ function jabber($server, $port, $username, $password, $use_ssl = false)

+ $this->port = ($port) ? $port : 5222;

+ $this->use_ssl = ($use_ssl && $this->can_use_ssl()) ? true : false;

+ // Change port if we use SSL

+ if ($this->port == 5222 && $this->use_ssl)

+ $this->port = 5223;

+ $this->enable_logging = true;

+ $this->log_array = array();

+ * Able to use the SSL functionality?

+ function can_use_ssl()

+ // Will not work with PHP >= 5.2.1 or < 5.2.3RC2 until timeout problem with ssl hasn't been fixed (http://bugs.php.net/41236)

+ return ((version_compare(PHP_VERSION, '5.2.1', '<') || version_compare(PHP_VERSION, '5.2.3RC2', '>=')) && @extension_loaded('openssl')) ? true : false;

+ * Able to use TLS?

+ function can_use_tls()

+ if (!@extension_loaded('openssl') || !function_exists('stream_socket_enable_crypto') || !function_exists('stream_get_meta_data') || !function_exists('socket_set_blocking') || !function_exists('stream_get_wrappers'))

+ // Make sure the encryption stream is supported

+ $streams = stream_get_wrappers();

+ if (!in_array('streams.crypto', $streams))

+ return false;

+ * Connect

+ function connect()

+/* if (!$this->check_jid($this->username . '@' . $this->server))

+ $this->add_to_log('Error: Jabber ID is not valid: ' . $this->username . '@' . $this->server);

+ }*/

+ $this->session['ssl'] = $this->use_ssl;

+ if ($this->open_socket($this->server, $this->port, $this->use_ssl))

+ $this->send("<?xml version='1.0' encoding='UTF-8' ?" . ">\n");

+ $this->send("<stream:stream to='{$this->server}' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' version='1.0'>\n");

+ $this->add_to_log('Error: connect() #2');

+ // Now we listen what the server has to say...and give appropriate responses

+ $this->response($this->listen());

+ return true;

+ * Disconnect

+ function disconnect()

+ if ($this->connected())

+ // disconnect gracefully

+ if (isset($this->session['sent_presence']))

+ $this->presence('offline', '', true);

+

+ $this->send('</stream:stream>');

+ $this->session = array();

+ return fclose($this->connection);

+ return false;

+ * Connected?

+ function connected()

+ return (is_resource($this->connection) && !feof($this->connection)) ? true : false;

+

+ * Initiates login (using data from contructor, after calling connect())

+ * @access public

+ * @return bool

+ function login()

+ if (!sizeof($this->features))

+ $this->add_to_log('Error: No feature information from server available.');

+ return false;

+ return $this->response($this->features);

+ * Send data to the Jabber server

+ * @param string $xml

+ * @access public

+ * @return bool

+ function send($xml)

+ if ($this->connected())

+ $xml = trim($xml);

+ $this->add_to_log('SEND: '. $xml);

+ return fwrite($this->connection, $xml);

+ $this->add_to_log('Error: Could not send, connection lost (flood?).');

+ * OpenSocket

+ * @param string $server host to connect to

+ * @param int $port port number

+ * @param bool $use_ssl use ssl or not

+ * @access public

+ * @return bool

+ function open_socket($server, $port, $use_ssl = false)

+ if (@function_exists('dns_get_record'))

+ $record = @dns_get_record("_xmpp-client._tcp.$server", DNS_SRV);

+ if (!empty($record) && !empty($record[0]['target']))

+ $server = $record[0]['target'];

+ $this->add_to_log('Warning: dns_get_record() function not found. GTalk will not work.');

+ $server = $use_ssl ? 'ssl://' . $server : $server;

+ if ($this->connection = @fsockopen($server, $port, $errorno, $errorstr, $this->timeout))

+ socket_set_blocking($this->connection, 0);

+ socket_set_timeout($this->connection, 60);

+ return true;

+

+ // Apparently an error occured...

+ $this->add_to_log('Error: open_socket() - ' . $errorstr);

+ return false;

+ $this->log_array[] = utf8_htmlspecialchars($string);

+ * Listens to the connection until it gets data or the timeout is reached.

+ * Thus, it should only be called if data is expected to be received.

+ * @access public

+ * @return mixed either false for timeout or an array with the received data

+ function listen($timeout = 10, $wait = false)

+ if (!$this->connected())

+ return false;

+ // Wait for a response until timeout is reached

+ $start = time();

+ $data = '';

+ do

+ $read = trim(fread($this->connection, 4096));

+ $data .= $read;

+ while (time() <= $start + $timeout && ($wait || $data == '' || $read != '' || (substr(rtrim($data), -1) != '>')));

+ if ($data != '')

+ $this->add_to_log('RECV: '. $data);

+ return $this->xmlize($data);

+ $this->add_to_log('Timeout, no response from server.');

+ * Initiates account registration (based on data used for contructor)

+ * @access public

+ * @return bool

+ function register()

+ if (!isset($this->session['id']) || isset($this->session['jid']))

+ $this->add_to_log('Error: Cannot initiate registration.');

+

+ $this->send("<iq type='get' id='reg_1'><query xmlns='jabber:iq:register'/></iq>");

+ return $this->response($this->listen());

+ * Sets account presence. No additional info required (default is "online" status)

+ * @param $message online, offline...

+ * @param $type dnd, away, chat, xa or nothing

+ * @param $unavailable set this to true if you want to become unavailable

+ * @access public

+ * @return bool

+ function send_presence($message = '', $type = '', $unavailable = false)

+ if (!isset($this->session['jid']))

+ $this->add_to_log('ERROR: send_presence() - Cannot set presence at this point, no jid given.');

+ return false;

+ $type = strtolower($type);

+ $type = (in_array($type, array('dnd', 'away', 'chat', 'xa'))) ? '<show>'. $type .'</show>' : '';

+ $unavailable = ($unavailable) ? " type='unavailable'" : '';

+ $message = ($message) ? '<status>' . utf8_htmlspecialchars($message) .'</status>' : '';

+ $this->session['sent_presence'] = !$unavailable;

+ return $this->send("<presence$unavailable>" . $type . $message . '</presence>');

+ * This handles all the different XML elements

+ * @param array $xml

+ * @access public

+ * @return bool

+ function response($xml)

+ if (!is_array($xml) || !sizeof($xml))

+ // did we get multiple elements? do one after another

+ // array('message' => ..., 'presence' => ...)

+ if (sizeof($xml) > 1)

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

+ {

+ $this->response(array($key => $value));

+ }

+ return;

+ else

+ // or even multiple elements of the same type?

+ // array('message' => array(0 => ..., 1 => ...))

+ if (sizeof(reset($xml)) > 1)

+ {

+ foreach (reset($xml) as $value)

+ {

+ $this->response(array(key($xml) => array(0 => $value)));

+ }

+ return;

+ }

+ switch (key($xml))

+ case 'stream:stream':

+ // Connection initialised (or after authentication). Not much to do here...

+ $this->session['id'] = $xml['stream:stream'][0]['@']['id'];

+ if (isset($xml['stream:stream'][0]['#']['stream:features']))

+ // we already got all info we need

+ $this->features = $xml['stream:stream'][0]['#'];

+ $this->features = $this->listen();

+ // go on with authentication?

+ if (isset($this->features['stream:features'][0]['#']['bind']))

+ {

+ return $this->response($this->features);

+ }

+ break;

+ case 'stream:features':

+ // Resource binding after successful authentication

+ if (isset($this->session['authenticated']))

+ {

+ // session required?

+ $this->session['sess_required'] = isset($xml['stream:features'][0]['#']['session']);

+

+ $this->send("<iq type='set' id='bind_1'>

+ <bind xmlns='urn:ietf:params:xml:ns:xmpp-bind'>

+ <resource>functions_jabber.phpbb.php</resource>

+ </bind>

+ </iq>");

+ return $this->response($this->listen());

+ }

+ // Let's use TLS if SSL is not enabled and we can actually use it

+ if (!$this->session['ssl'] && $this->can_use_tls() && isset($xml['stream:features'][0]['#']['starttls']))

+ {

+ $this->add_to_log('Switching to TLS.');

+ $this->send("<starttls xmlns='urn:ietf:params:xml:ns:xmpp-tls'/>\n");

+ return $this->response($this->listen());

+ }

+ // Does the server support SASL authentication?

+ // I hope so, because we do (and no other method).

+ if (isset($xml['stream:features'][0]['#']['mechanisms'][0]['@']['xmlns']) && $xml['stream:features'][0]['#']['mechanisms'][0]['@']['xmlns'] == 'urn:ietf:params:xml:ns:xmpp-sasl')

+ {

+ // Now decide on method

+ $methods = array();

+ foreach ($xml['stream:features'][0]['#']['mechanisms'][0]['#']['mechanism'] as $value)

+ {

+ $methods[] = $value['#'];

+ }

+ // we prefer DIGEST-MD5

+ // we don't want to use plain authentication (neither does the server usually) if no encryption is in place

+ // http://www.xmpp.org/extensions/attic/jep-0078-1.7.html

+ // The plaintext mechanism SHOULD NOT be used unless the underlying stream is encrypted (using SSL or TLS)

+ // and the client has verified that the server certificate is signed by a trusted certificate authority.

+ if (in_array('DIGEST-MD5', $methods))

+ {

+ $this->send("<auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='DIGEST-MD5'/>");

+ }

+ else if (in_array('PLAIN', $methods) && ($this->session['ssl'] || !empty($this->session['tls'])))

+ {

+ $this->send("<auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='PLAIN'>"

+ . base64_encode(chr(0) . $this->username . '@' . $this->server . chr(0) . $this->password) .

+ '</auth>');

+ }

+ else if (in_array('ANONYMOUS', $methods))

+ {

+ $this->send("<auth xmlns='urn:ietf:params:xml:ns:xmpp-sasl' mechanism='ANONYMOUS'/>");

+ }

+ else

+ {

+ // not good...

+ $this->add_to_log('Error: No authentication method supported.');

+ $this->disconnect();

+ return false;

+ }

+ return $this->response($this->listen());

+ }

+ else

+ {

+ // ok, this is it. bye.

+ $this->add_to_log('Error: Server does not offer SASL authentication.');

+ $this->disconnect();

+ return false;

+ }

+ break;

+ case 'challenge':

+ // continue with authentication...a challenge literally -_-

+ $decoded = base64_decode($xml['challenge'][0]['#']);

+ $decoded = $this->parse_data($decoded);

+ if (!isset($decoded['digest-uri']))

+ {

+ $decoded['digest-uri'] = 'xmpp/'. $this->server;

+ }

+ // better generate a cnonce, maybe it's needed

+ $str = '';

+ mt_srand((double)microtime()*10000000);

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

+ {

+ $str .= chr(mt_rand(0, 255));

+ }

+ $decoded['cnonce'] = base64_encode($str);

+ // second challenge?

+ if (isset($decoded['rspauth']))

+ {

+ $this->send("<response xmlns='urn:ietf:params:xml:ns:xmpp-sasl'/>");

+ }

+ else

+ {

+ $response = array(

+ 'username' => $this->username,

+ 'response' => $this->encrypt_password(array_merge($decoded, array('nc' => '00000001'))),

+ 'charset' => 'utf-8',

+ 'nc' => '00000001',

+ );

+

+ foreach (array('nonce', 'qop', 'digest-uri', 'realm', 'cnonce') as $key)

+ {

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

+ {

+ $response[$key] = $decoded[$key];

+ }

+ }

+ $this->send("<response xmlns='urn:ietf:params:xml:ns:xmpp-sasl'>" . base64_encode($this->implode_data($response)) . '</response>');

+ }

+ return $this->response($this->listen());

+ break;

+ case 'failure':

+ $this->add_to_log('Error: Server sent "failure".');

+ $this->disconnect();

+ return false;

+ break;

+ case 'proceed':

+ // continue switching to TLS

+ $meta = stream_get_meta_data($this->connection);

+ socket_set_blocking($this->connection, 1);

+ if (!stream_socket_enable_crypto($this->connection, true, STREAM_CRYPTO_METHOD_TLS_CLIENT))

+ {

+ $this->add_to_log('Error: TLS mode change failed.');

+ return false;

+ }

+ socket_set_blocking($this->connection, $meta['blocked']);

+ $this->session['tls'] = true;

+ // new stream

+ $this->send("<?xml version='1.0' encoding='UTF-8' ?" . ">\n");

+ $this->send("<stream:stream to='{$this->server}' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' version='1.0'>\n");

+ return $this->response($this->listen());

+ break;

+ case 'success':

+ // Yay, authentication successful.

+ $this->send("<stream:stream to='{$this->server}' xmlns='jabber:client' xmlns:stream='http://etherx.jabber.org/streams' version='1.0'>\n");

+ $this->session['authenticated'] = true;

+ // we have to wait for another response

+ return $this->response($this->listen());

+ break;

+ case 'iq':

+ // we are not interested in IQs we did not expect

+ if (!isset($xml['iq'][0]['@']['id']))

+ {

+ return false;

+ }

+ // multiple possibilities here

+ switch ($xml['iq'][0]['@']['id'])

+ {

+ case 'bind_1':

+ $this->session['jid'] = $xml['iq'][0]['#']['bind'][0]['#']['jid'][0]['#'];

+

+ // and (maybe) yet another request to be able to send messages *finally*

+ if ($this->session['sess_required'])

+ {

+ $this->send("<iq to='{$this->server}' type='set' id='sess_1'>

+ <session xmlns='urn:ietf:params:xml:ns:xmpp-session'/>

+ </iq>");

+ return $this->response($this->listen());

+ }

+

+ return true;

+ break;

+

+ case 'sess_1':

+ return true;

+ break;

+

+ case 'reg_1':

+ $this->send("<iq type='set' id='reg_2'>

+ <query xmlns='jabber:iq:register'>

+ <username>" . utf8_htmlspecialchars($this->username) . "</username>

+ <password>" . utf8_htmlspecialchars($this->password) . "</password>

+ </query>

+ </iq>");

+ return $this->response($this->listen());

+ break;

+

+ case 'reg_2':

+ // registration end

+ if (isset($xml['iq'][0]['#']['error']))

+ {

+ $this->add_to_log('Warning: Registration failed.');

+ return false;

+ }

+ return true;

+ break;

+

+ case 'unreg_1':

+ return true;

+ break;

+

+ default:

+ $this->add_to_log('Notice: Received unexpected IQ.');

+ return false;

+ break;

+ }

+ break;

+ case 'message':

+ // we are only interested in content...

+ if (!isset($xml['message'][0]['#']['body']))

+ {

+ return false;

+ }

+ $message['body'] = $xml['message'][0]['#']['body'][0]['#'];

+ $message['from'] = $xml['message'][0]['@']['from'];

+ if (isset($xml['message'][0]['#']['subject']))

+ {

+ $message['subject'] = $xml['message'][0]['#']['subject'][0]['#'];

+ }

+ $this->session['messages'][] = $message;

+ break;

+ default:

+ // hm...don't know this response

+ $this->add_to_log('Notice: Unknown server response (' . key($xml) . ')');

+ return false;

+ break;

+ }

+ function send_message($to, $text, $subject = '', $type = 'normal')

+ if (!isset($this->session['jid']))

+ {

+ return false;

+ }

+ if (!in_array($type, array('chat', 'normal', 'error', 'groupchat', 'headline')))

+ {

+ $type = 'normal';

+ }

+ return $this->send("<message from='" . utf8_htmlspecialchars($this->session['jid']) . "' to='" . utf8_htmlspecialchars($to) . "' type='$type' id='" . uniqid('msg') . "'>

+ <subject>" . utf8_htmlspecialchars($subject) . "</subject>

+ <body>" . utf8_htmlspecialchars($text) . "</body>

+ </message>"

+ );

+ * Encrypts a password as in RFC 2831

+ * @param array $data Needs data from the client-server connection

+ * @access public

+ * @return string

+ function encrypt_password($data)

+ // let's me think about <challenge> again...

+ foreach (array('realm', 'cnonce', 'digest-uri') as $key)

+ if (!isset($data[$key]))

+ {

+ $data[$key] = '';

+ }

+ $pack = md5($this->username . ':' . $data['realm'] . ':' . $this->password);

+ if (isset($data['authzid']))

+ {

+ $a1 = pack('H32', $pack) . sprintf(':%s:%s:%s', $data['nonce'], $data['cnonce'], $data['authzid']);

+ }

+ else

+ $a1 = pack('H32', $pack) . sprintf(':%s:%s', $data['nonce'], $data['cnonce']);

+ // should be: qop = auth

+ $a2 = 'AUTHENTICATE:'. $data['digest-uri'];

+ return md5(sprintf('%s:%s:%s:%s:%s:%s', md5($a1), $data['nonce'], $data['nc'], $data['cnonce'], $data['qop'], md5($a2)));

+ * parse_data like a="b",c="d",...

+ * @param string $data

+ * @access public

+ * @return array a => b ...

+ function parse_data($data)

+ // super basic, but should suffice

+ $data = explode(',', $data);

+ $pairs = array();

+ foreach ($data as $pair)

+ $dd = strpos($pair, '=');

+ if ($dd)

+ {

+ $pairs[substr($pair, 0, $dd)] = trim(substr($pair, $dd + 1), '"');

+ }

+ return $pairs;

+ * opposite of jabber::parse_data()

+ * @param array $data

+ * @access public

+ * @return string

+ function implode_data($data)

+ $return = array();

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

+ {

+ $return[] = $key . '="' . $value . '"';

+ }

+ return implode(',', $return);

+ if (substr($data, 0, 5) != '<?xml')

+ {

+ // mod

+ $data = '<root>'. $data . '</root>';

+ }

+

+ $array[$tagname][0]['@'] = (isset($vals[$i]['attributes'])) ? $vals[$i]['attributes'] : array();

+ $array[$tagname][0]['#'] = $this->_xml_depth($vals, $i);

+

+ if (substr($data, 0, 5) != '<?xml')

+ {

+ $array = $array['root'][0]['#'];

+ }

+/**

+* @copyright (c) 2005 phpBB Group

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

+ $this->jabber = new jabber($config['jab_host'], $config['jab_port'], $config['jab_username'], $config['jab_password'], $config['jab_use_ssl']);

+ if (!$this->jabber->login())

+ $this->jabber->send_message($address, $this->msg, $this->subject);

+ $this->jabber = new jabber($config['jab_host'], $config['jab_port'], $config['jab_username'], $config['jab_password'], $config['jab_use_ssl']);

+ if (!$this->jabber->login())

+ if ($this->jabber->send_message($address, $msg, $subject) === false)

+ 'topic_first_poster_colour' => $user->data['user_colour'],

+ 'topic_last_poster_colour' => $user->data['user_colour'],

+ $sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = '" . $db->sql_escape($user->data['user_colour']) . "'";

+/**

+* @copyright (c) 2005 phpBB Group

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

+ $message_removed = false;

+ $move_into_folder[(int) $rule_ary['folder_id']][] = $msg_id;

+ $message_removed = true;

+

+ // We place this here because it could happen that the messages are doubled if a rule marks a message and then moves it into a specific

+ // folder. Here we simply move the message into the INBOX if it gets not removed and also not put into a custom folder.

+ if (!$folder_action && !$message_removed)

+ {

+ $move_into_folder[PRIVMSGS_INBOX][] = $msg_id;

+ }

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

+ // Unfortunatly CHMOD is not expecting an octal value...

+ // We need to transform the integer (which was an octal) to an octal representation (to get the int) and then pass as is. ;)

+ $chmod_cmd = 'CHMOD ' . base_convert($perms, 10, 8) . ' ' . $file;

+ // Unfortunatly CHMOD is not expecting an octal value...

+ // We need to transform the integer (which was an octal) to an octal representation (to get the int) and then pass as is. ;)

+ return $this->_send_command('SITE CHMOD', base_convert($perms, 10, 8) . ' ' . $file);

+ $username_clean = utf8_clean_string($user_row['username']);

+

+ if (empty($username_clean))

+ {

+ return false;

+ }

+

+ 'username_clean' => $username_clean,

+ if (strpos($username, '&quot;') !== false || strpos($username, '"') !== false || empty($clean_username))