+ <dt><label for="prune_shadow_freq">{L_AUTO_PRUNE_SHADOW_FREQ}{L_COLON}</label><br /><span>{L_AUTO_PRUNE_SHADOW_FREQ_EXPLAIN}</span></dt>

+ <dd><input type="number" id="prune_shadow_freq" name="prune_shadow_freq" value="{PRUNE_SHADOW_FREQ}" maxlength="4" size="4" min="0" max="9999" /> {L_DAYS}</dd>

+ <dt><label for="prune_shadow_days">{L_AUTO_PRUNE_SHADOW_DAYS}{L_COLON}</label><br /><span>{L_AUTO_PRUNE_SHADOW_DAYS_EXPLAIN}</span></dt>

+ <dd><input type="number" id="prune_shadow_days" name="prune_shadow_days" value="{PRUNE_SHADOW_DAYS}" maxlength="4" size="4" min="0" max="9999" /> {L_DAYS}</dd>

+ <!-- IF .deleted -->

+ <h2>{L_FILES_DELETED}</h2>

+ <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('deleted', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

+ <p>{L_FILES_DELETED_EXPLAIN}</p>

+ <fieldset id="deleted">

+ <legend><img src="{T_IMAGE_PATH}icon_delete.gif" alt="{L_STATUS_DELETED}" /></legend>

+ <!-- BEGIN deleted -->

+ <dt style="width: 60%;"><strong><!-- IF deleted.DIR_PART -->{deleted.DIR_PART}<br /><!-- ENDIF -->{deleted.FILE_PART}</strong></dt>

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

+ <!-- IF not deleted.S_BINARY -->[<a href="{deleted.U_SHOW_DIFF}" onclick="diff_popup(this.href); return false;">{deleted.L_SHOW_DIFF}</a>]<!-- ELSE -->{L_BINARY_FILE}<!-- ENDIF -->

+ </dd>

+ <!-- END deleted -->

+ <!-- IF .conflict -->

+ <h2>{L_FILES_CONFLICT}</h2>

+ <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('conflict', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

+ <p>{L_FILES_CONFLICT_EXPLAIN}</p>

+ <!-- BEGIN conflict -->

+ <fieldset id="conflict">

+ <legend><img src="{T_IMAGE_PATH}file_conflict.gif" alt="{L_STATUS_CONFLICT}" /></legend>

+ <dt style="width: 60%;"><strong><!-- IF conflict.DIR_PART -->{conflict.DIR_PART}<br /><!-- ENDIF -->{conflict.FILE_PART}</strong>

+ <!-- IF conflict.S_CUSTOM --><br /><span><em>{L_FILE_USED}{L_COLON} </em>{conflict.CUSTOM_ORIGINAL}</span><!-- ENDIF -->

+ <!-- IF conflict.NUM_CONFLICTS --><br /><span>{L_NUM_CONFLICTS}{L_COLON} {conflict.NUM_CONFLICTS}</span><!-- ENDIF -->

+ </dt>

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

+ <!-- IF not conflict.S_BINARY -->[<a href="{conflict.U_SHOW_DIFF}">{L_DOWNLOAD_CONFLICTS}</a>]<br />{L_DOWNLOAD_CONFLICTS_EXPLAIN}

+ <!-- ELSE -->{L_BINARY_FILE}<!-- ENDIF -->

+ </dd>

+ <!-- IF conflict.S_CUSTOM -->

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

+ <!-- ENDIF -->

+ <!-- IF conflict.S_BINARY -->

+ <dl>

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

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

+ </dl>

+ <!-- ELSE -->

+ <dl>

+ <dt style="width: 60%"><label><input type="radio" class="radio" name="conflict[{conflict.FILENAME}]" value="3" checked="checked" /> {L_MERGE_NEW_FILE_OPTION}</label></dt>

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

+ </dl>

+ <dl>

+ <dt style="width: 60%"><label><input type="radio" class="radio" name="conflict[{conflict.FILENAME}]" value="4" /> {L_MERGE_MOD_FILE_OPTION}</label></dt>

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

+ </dl>

+ <dl>

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

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

+ </dl>

+ <dl>

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

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

+ </dl>

+ <!-- ENDIF -->

+ <!-- END conflict -->

+ <!-- IF .new_conflict -->

+ <h2>{L_FILES_NEW_CONFLICT}</h2>

+ <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('new_conflict', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

+ <p>{L_FILES_NEW_CONFLICT_EXPLAIN}</p>

+ <fieldset id="new_conflict">

+ <legend><img src="{T_IMAGE_PATH}file_new_conflict.gif" alt="{L_STATUS_NEW_CONFLICT}" /></legend>

+ <!-- BEGIN new_conflict -->

+ <dt style="width: 60%;"><strong><!-- IF new_conflict.DIR_PART -->{new_conflict.DIR_PART}<br /><!-- ENDIF -->{new_conflict.FILE_PART}</strong>

+ <!-- IF new_conflict.S_CUSTOM --><br /><span><em>{L_FILE_USED}{L_COLON} </em>{new_conflict.CUSTOM_ORIGINAL}</span><!-- ENDIF -->

+ </dt>

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

+ <!-- IF not new_conflict.S_BINARY -->[<a href="{new_conflict.U_SHOW_DIFF}" onclick="diff_popup(this.href); return false;">{new_conflict.L_SHOW_DIFF}</a>]<!-- ELSE -->{L_BINARY_FILE}<!-- ENDIF -->

+ </dd>

+ <!-- IF new_conflict.S_CUSTOM -->

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

+ <!-- ENDIF -->

+ <!-- END new_conflict -->

+ <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('modified', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

+ <fieldset id="modified">

+ <!-- IF .new -->

+ <h2>{L_FILES_NEW}</h2>

+ <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('new_files', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

+ <p>{L_FILES_NEW_EXPLAIN}</p>

+ <fieldset id="new_files" style="display: none;">

+ <legend><img src="{T_IMAGE_PATH}file_new.gif" alt="{L_STATUS_NEW}" /></legend>

+ <!-- BEGIN new -->

+ <dt style="width: 60%;"><strong><!-- IF new.DIR_PART -->{new.DIR_PART}<br /><!-- ENDIF -->{new.FILE_PART}</strong>

+ <!-- IF new.S_CUSTOM --><br /><span><em>{L_FILE_USED}{L_COLON} </em>{new.CUSTOM_ORIGINAL}</span><!-- ENDIF -->

+ <!-- IF not new.S_BINARY -->[<a href="{new.U_SHOW_DIFF}" onclick="diff_popup(this.href); return false;">{new.L_SHOW_DIFF}</a>]<!-- ELSE -->{L_BINARY_FILE}<!-- ENDIF -->

+ <!-- IF new.S_CUSTOM -->

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

+ <!-- END new -->

+ <!-- IF .not_modified -->

+ <h2>{L_FILES_NOT_MODIFIED}</h2>

+ <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('not_modified', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

+ <p>{L_FILES_NOT_MODIFIED_EXPLAIN}</p>

+ <fieldset id="not_modified" style="display: none;">

+ <legend><img src="{T_IMAGE_PATH}file_not_modified.gif" alt="{L_STATUS_NOT_MODIFIED}" /></legend>

+ <!-- BEGIN not_modified -->

+ <dt style="width: 60%;"><strong><!-- IF not_modified.DIR_PART -->{not_modified.DIR_PART}<br /><!-- ENDIF -->{not_modified.FILE_PART}</strong>

+ <!-- IF not_modified.S_CUSTOM --><br /><span><em>{L_FILE_USED}{L_COLON} </em>{not_modified.CUSTOM_ORIGINAL}</span><!-- ENDIF -->

+ <dd style="margin-{S_CONTENT_FLOW_BEGIN}{L_COLON} 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>

+ <!-- IF not_modified.S_CUSTOM -->

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

+ <!-- END not_modified -->

+ <!-- IF .up_to_date -->

+ <h2>{L_FILES_UP_TO_DATE}</h2>

+ <div style="float: {S_CONTENT_FLOW_END};">&raquo; <a href="#" onclick="phpbb.toggleDisplay('up_to_date', 0); return false;">{L_TOGGLE_DISPLAY}</a></div>

+ <p>{L_FILES_UP_TO_DATE_EXPLAIN}</p>

+ <fieldset id="up_to_date" style="display: none;">

+ <legend><img src="{T_IMAGE_PATH}file_up_to_date.gif" alt="{L_STATUS_UP_TO_DATE}" /></legend>

+ <!-- BEGIN up_to_date -->

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

+ <!-- END up_to_date -->

+

+ // Check whether the vertical scrollbar is present.

+ $this.toggleClass('dropdown-nonscroll', this.scrollHeight === $this.innerHeight());

+

+

+ // Try to position the notification dropdown correctly in RTL-responsive mode

+ if (options.dropdown.hasClass('dropdown-extended')) {

+ var contentWidth,

+ fullFreeSpace = freeSpace + parent.outerWidth();

+

+ options.dropdown.find('.dropdown-contents').each(function() {

+ contentWidth = parseInt($(this).outerWidth());

+ $(this).css({marginLeft: 0, left: 0});

+ });

+

+ var maxOffset = Math.min(contentWidth, fullFreeSpace) + 'px';

+ options.dropdown.css({'width': maxOffset, 'margin-left': '-' + maxOffset});

+ }

+phpbb_load_extensions_autoloaders($phpbb_root_path);

+

+ class: phpbb\db\driver\factory

+ arguments:

+ - @service_container

+

+ dbal.conn.driver:

+

+ viewonline_helper:

+ class: phpbb\viewonline_helper

+ switch ($db->get_sql_layer())

+ if($db->get_sql_layer() == "mysql")

+switch ($db->get_sql_layer())

+switch ($db->get_sql_layer())

+switch ($db->get_sql_layer())

+ nicofuma (Tristan Darricau)

+index_body_markforums_after

+* Since: 3.1.0-RC2

+* Purpose: Add content after the mark-read link above the forum list on Board index

+index_body_markforums_before

+* Since: 3.1.0-RC2

+* Purpose: Add content before the mark-read link above the forum list on Board index

+navbar_header_logged_out_content

+* Since: 3.1.0-RC1

+* Purpose: Add text and HTML in place of the username when not logged in.

+navbar_header_profile_list_after

+* Since: 3.1.0-RC2

+* Purpose: Add links to the bottom of the profile drop-down menu in the header navbar

+

+navbar_header_profile_list_before

+===

+* Locations:

+ + styles/prosilver/template/navbar_header.html

+* Since: 3.1.0-RC2

+* Purpose: Add links to the top of the profile drop-down menu in the header navbar

+

+navbar_header_quick_links_after

+===

+* Locations:

+ + styles/prosilver/template/navbar_header.html

+* Since: 3.1.0-RC2

+* Purpose: Add links to the bottom of the quick-links drop-down menu in the header

+

+navbar_header_quick_links_before

+===

+* Locations:

+ + styles/prosilver/template/navbar_header.html

+* Since: 3.1.0-RC2

+* Purpose: Add links to the top of the quick-links drop-down menu in the header

+

+navbar_header_username_append

+===

+* Locations:

+ + styles/prosilver/template/navbar_header.html

+* Since: 3.1.0-RC1

+* Purpose: Add text and HTMl after the username shown in the navbar.

+* Since: 3.1.0-RC1

+* Purpose: Add text and HTMl before the username shown in the navbar.

+ phpbb_load_extensions_autoloaders($phpbb_root_path);

+

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

+ pg_put_line($db->get_db_connect_id(), $sub . "\n");

+ pg_put_line($db->get_db_connect_id(), "\\.\n");

+ pg_end_copy($db->get_db_connect_id());

+ if ($db->get_sql_layer() === 'mysqli' || version_compare($db->sql_server_info(true), '3.23.20', '>='))

+ if ($db->get_sql_layer() === 'mysqli')

+ $result = mysqli_query($db->get_db_connect_id(), $sql, MYSQLI_USE_RESULT);

+ $result = mysql_unbuffered_query($sql, $db->get_db_connect_id());

+ $col_types = sqlite_fetch_column_types($db->get_db_connect_id(), $table_name);

+ $result = sqlite_unbuffered_query($db->get_db_connect_id(), $sql);

+ if ($db->get_sql_layer() === 'mssql')

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

+ if ($phpbb_extension_manager->is_enabled($ext_name))

+ if ($phpbb_extension_manager->is_enabled($ext_name))

+ if (!$phpbb_extension_manager->is_enabled($ext_name))

+ if (!$phpbb_extension_manager->is_enabled($ext_name))

+ if ($phpbb_extension_manager->is_enabled($ext_name))

+ if ($phpbb_extension_manager->is_enabled($ext_name))

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

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

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

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

+ WHERE auth_option ' . $db->sql_like_expression($permission_type . $db->get_any_char());

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

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

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

+ switch ($db->get_sql_layer())

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

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

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

+* Load the autoloaders added by the extensions.

+*

+* @param string $phpbb_root_path Path to the phpbb root directory.

+*/

+function phpbb_load_extensions_autoloaders($phpbb_root_path)

+{

+ $iterator = new \RecursiveIteratorIterator(

+ new \phpbb\recursive_dot_prefix_filter_iterator(

+ new \RecursiveDirectoryIterator(

+ $phpbb_root_path . 'ext/',

+ \FilesystemIterator::SKIP_DOTS

+ )

+ ),

+ \RecursiveIteratorIterator::SELF_FIRST

+ );

+ $iterator->setMaxDepth(2);

+

+ foreach ($iterator as $file_info)

+ {

+ if ($file_info->getFilename() === 'vendor' && $iterator->getDepth() === 2)

+ {

+ $filename = $file_info->getRealPath() . '/autoload.php';

+ if (file_exists($filename))

+ {

+ require $filename;

+ }

+ }

+ }

+}

+

+/**

+ if ($db->get_sql_layer() === 'sqlite' || $db->get_sql_layer() === 'sqlite3')

+ 'CURRENT_USERNAME_SIMPLE' => get_username_string('no_profile', $user->data['user_id'], $user->data['username'], $user->data['user_colour']),

+ $debug_info[] = sprintf('<abbr title="SQL time: %.3fs / PHP time: %.3fs">Time: %.3fs</abbr>', $db->get_sql_time(), ($totaltime - $db->get_sql_time()), $totaltime);

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

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

+ switch ($db->get_sql_layer())

+ $sql = 'DELETE ' . (($db->get_sql_layer() === 'mysqli' || version_compare($db->sql_server_info(true), '4.1', '>=')) ? 'z.*' : ZEBRA_TABLE) . '

+ switch ($db->get_sql_layer())

+ $db_name = (preg_match('#^(?:3\.23\.(?:[6-9]|[1-9]{2}))|[45]\.#', $version)) ? "`{$db->get_db_name()}`" : $db->get_db_name();

+ $database = $db->get_db_name();

+* @param \phpbb\db\driver\driver_interface $db The generated connection

+function phpbb_bootstrap_enabled_exts($config_file, $phpbb_root_path, &$db)

+ $container->register('dbal.conn.driver')->setSynthetic(true);

+ $db = null;

+ $installed_exts = phpbb_bootstrap_enabled_exts($config_file, $phpbb_root_path, $db);

+ $container = phpbb_create_dumped_container_unless_debug(

+

+ $container->get('dbal.conn')->set_driver($db);

+

+ return $container;

+ 'S_FORUM_COUNT' => $iteration,

+ 'LINK' => $phpbb_path_helper->append_url_params($action, array('f' => $forum_id)),

+ ));

+ 'S_IS_POST' => ($row['forum_type'] == FORUM_POST) ? true : false,

+ 'LINK' => $phpbb_path_helper->append_url_params($action, array('f' => $row['forum_id'])),

+ ));

+ $_profile_cache['tpl_noprofile'] = '<span class="username">{USERNAME}</span>';

+ $_profile_cache['tpl_profile'] = '<a href="{PROFILE_URL}" class="username">{USERNAME}</a>';

+ * @param string $url The recepting URL for the quickmod actions.

+function phpbb_add_quickmod_option($url, $option, $lang_string)

+ global $template, $user, $phpbb_path_helper;

+

+ 'VALUE' => $option,

+ 'TITLE' => $lang_string,

+ 'LINK' => $phpbb_path_helper->append_url_params($url, array('action' => $option)),

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

+ if (version_compare(mysqli_get_server_info($db->get_db_connect_id()), '4.1.3', '<'))

+ switch ($db->get_sql_layer())

+ if (!$message_row['message_edit_user'])

+ {

+ $display_username = get_username_string('full', $author_id, $user_info['username'], $user_info['user_colour']);

+ }

+ else

+ {

+ $edit_user_info = get_user_information($message_row['message_edit_user'], false);

+ $display_username = get_username_string('full', $message_row['message_edit_user'], $edit_user_info['username'], $edit_user_info['user_colour']);

+ }

+ $l_edited_by = '<br /><br />' . $user->lang('EDITED_TIMES_TOTAL', (int) $message_row['message_edit_count'], $display_username, $user->format_date($message_row['message_edit_time'], false, true));

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

+ $map_dbms = $db->get_sql_layer();

+ <p><?php echo $user->lang['DATABASE_TYPE']; ?> :: <strong><?php echo $db->get_sql_layer(); ?></strong><br />

+ if ($db->get_transaction())

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

+ switch ($db->get_sql_layer())

+ if ($db->get_sql_error_triggered())

+ $sql_ignore = (strpos($db->get_sql_layer(), 'mysql') === 0 && !defined('DEBUG')) ? 'IGNORE ' : '';

+ if ($db->get_sql_error_triggered())

+ $error = $db->sql_error($db->get_sql_error_sql());

+ $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__);

+ if ($db->get_sql_error_triggered())

+ $error = $db->sql_error($db->get_sql_error_sql());

+ $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__);

+ if ($db->get_sql_error_triggered())

+ $error = $db->sql_error($db->get_sql_error_sql());

+ $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__);

+ if ($db->get_sql_error_triggered())

+ $error = $db->sql_error($db->get_sql_error_sql());

+ $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__);

+ if ($db->get_sql_error_triggered())

+ $error = $db->sql_error($db->get_sql_error_sql());

+ $this->p_master->db_error($error['message'], $db->get_sql_error_sql(), __LINE__, __FILE__);

+ $this->p_master->db_error('Unable to insert bot into users table', $db->get_sql_error_sql(), __LINE__, __FILE__, true);

+ 'AUTO_PRUNE_SHADOW_FREQ' => 'Auto-prune shadow topics frequency',

+ 'AUTO_PRUNE_SHADOW_DAYS' => 'Auto-prune shadow topics age',

+ 'AUTO_PRUNE_SHADOW_DAYS_EXPLAIN' => 'Number of days after which shadow topic is removed.',

+ 'AUTO_PRUNE_SHADOW_FREQ_EXPLAIN' => 'Time in days between pruning events.',

+ 'ACP_SHORT' => 'ACP',

+ 'MCP_SHORT' => 'MCP',

+ 'QUICK_LINKS' => 'Quick links',

+

+ 'SEARCH_ACTIVE_TOPICS' => 'Active topics',

+ 'SEARCH_NEW' => 'New posts',

+ 'SEARCH_SELF' => 'Your posts',

+ 'SEARCH_UNANSWERED' => 'Unanswered posts',

+ 'SEARCH_UNREAD' => 'Unread posts',

+ 'SUPPORT_BODY' => 'Full support will be provided for the current stable release of phpBB3, free of charge. This includes:</p><ul><li>installation</li><li>configuration</li><li>technical questions</li><li>problems relating to potential bugs in the software</li><li>updating from Release Candidate (RC) versions to the latest stable version</li><li>converting from phpBB 2.0.x to phpBB3</li><li>converting from other discussion board software to phpBB3 (please see the <a href="https://www.phpbb.com/community/viewforum.php?f=486">Convertors Forum</a>)</li></ul><p>We encourage users still running beta versions of phpBB3 to replace their installation with a fresh copy of the latest version.</p><h2>Extensions / Styles</h2><p>For issues relating to Extensions, please post in the appropriate <a href="https://www.phpbb.com/community/viewforum.php?f=451">Extensions Forum</a>.<br />For issues relating to styles, templates and themes, please post in the appropriate <a href="https://www.phpbb.com/community/viewforum.php?f=471">Styles Forum</a>.<br /><br />If your question relates to a specific package, please post directly in the topic dedicated to the package.</p><h2>Obtaining Support</h2><p><a href="https://www.phpbb.com/community/viewtopic.php?f=14&amp;t=571070">The phpBB Welcome Package</a><br /><a href="https://www.phpbb.com/support/">Support Section</a><br /><a href="https://www.phpbb.com/support/documentation/3.1/quickstart/">Quick Start Guide</a><br /><br />To ensure you stay up to date with the latest news and releases, why not <a href="https://www.phpbb.com/support/">subscribe to our mailing list</a>?<br /><br />',

+ AND username_clean ' . $db->sql_like_expression(utf8_clean_string($username_chars) . $db->get_any_char());

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

+ $sql_where .= ($auth->acl_get('a_user') && $email) ? ' AND u.user_email ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), $email)) . ' ' : '';

+ $sql_where .= ($jabber) ? ' AND u.user_jabber ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), $jabber)) . ' ' : '';

+ $sql_where .= ' AND u.username_clean NOT ' . $db->sql_like_expression(chr($i) . $db->get_any_char());

+ $sql_where .= ' AND u.username_clean ' . $db->sql_like_expression(substr($first_char, 0, 1) . $db->get_any_char());

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

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

+ switch ($this->db->get_sql_layer())

+ if ($this->manager->is_enabled($name))

+ if ($this->manager->is_enabled($name))

+ if ($this->manager->is_enabled($name))

+ * @param \phpbb\db\driver\driver_interface $db The db connection

+ public function __construct($phpbb_root_path, $php_ext, \phpbb\config\config $config, \phpbb\db\driver\driver_interface $db, \phpbb\log\log $log, \phpbb\user $user)

+ * {@inheritdoc}

+ */

+ public function get_sql_layer()

+ {

+ return $this->sql_layer;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_db_name()

+ {

+ return $this->dbname;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_any_char()

+ {

+ return $this->any_char;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_one_char()

+ {

+ return $this->one_char;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_db_connect_id()

+ {

+ return $this->db_connect_id;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_sql_error_triggered()

+ {

+ return $this->sql_error_triggered;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_sql_error_sql()

+ {

+ return $this->sql_error_sql;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_transaction()

+ {

+ return $this->transaction;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_sql_time()

+ {

+ return $this->sql_time;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_sql_error_returned()

+ {

+ return $this->sql_error_returned;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_multi_insert()

+ {

+ return $this->multi_insert;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function set_multi_insert($multi_insert)

+ {

+ $this->multi_insert = $multi_insert;

+ }

+

+ /**

+ * Gets the name of the sql layer.

+ *

+ * @return string

+ */

+ public function get_sql_layer();

+

+ /**

+ * Gets the name of the database.

+ *

+ * @return string

+ */

+ public function get_db_name();

+

+ /**

+ * Wildcards for matching any (%) character within LIKE expressions

+ *

+ * @return string

+ */

+ public function get_any_char();

+

+ /**

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

+ *

+ * @return string

+ */

+ public function get_one_char();

+

+ /**

+ * Gets the time spent into the queries

+ *

+ * @return int

+ */

+ public function get_sql_time();

+

+ /**

+ * Gets the connect ID.

+ *

+ * @return mixed

+ */

+ public function get_db_connect_id();

+

+ /**

+ * Indicates if an error was triggered.

+ *

+ * @return bool

+ */

+ public function get_sql_error_triggered();

+

+ /**

+ * Gets the last faulty query

+ *

+ * @return string

+ */

+ public function get_sql_error_sql();

+

+ /**

+ * Indicates if we are in a transaction.

+ *

+ * @return bool

+ */

+ public function get_transaction();

+

+ /**

+ * Gets the returned error.

+ *

+ * @return array

+ */

+ public function get_sql_error_returned();

+

+ /**

+ * Indicates if multiple insertion can be used

+ *

+ * @return bool

+ */

+ public function get_multi_insert();

+

+ /**

+ * Set if multiple insertion can be used

+ *

+ * @param bool $multi_insert

+ */

+ public function set_multi_insert($multi_insert);

+

+ /**

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb\db\driver;

+

+use \Symfony\Component\DependencyInjection\ContainerInterface;

+

+/**

+* Database Abstraction Layer

+*/

+class factory implements driver_interface

+{

+ /**

+ * @var driver_interface

+ */

+ protected $driver = null;

+

+ /**

+ * @var ContainerInterface

+ */

+ protected $container;

+

+ /**

+ * Constructor.

+ *

+ * @param ContainerInterface $container A ContainerInterface instance

+ */

+ public function __construct(ContainerInterface $container)

+ {

+ $this->container = $container;

+ }

+

+ /**

+ * Return the current driver (and retrieved it from the container if necessary)

+ *

+ * @return driver_interface

+ */

+ protected function get_driver()

+ {

+ if ($this->driver === null)

+ {

+ $this->driver = $this->container->get('dbal.conn.driver');

+ }

+

+ return $this->driver;

+ }

+

+ /**

+ * Set the current driver

+ *

+ * @param driver_interface $driver

+ */

+ public function set_driver(driver_interface $driver)

+ {

+ $this->driver = $driver;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_sql_layer()

+ {

+ return $this->get_driver()->get_sql_layer();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_db_name()

+ {

+ return $this->get_driver()->get_db_name();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_any_char()

+ {

+ return $this->get_driver()->get_any_char();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_one_char()

+ {

+ return $this->get_driver()->get_one_char();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_db_connect_id()

+ {

+ return $this->get_driver()->get_db_connect_id();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_sql_error_triggered()

+ {

+ return $this->get_driver()->get_sql_error_triggered();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_sql_error_sql()

+ {

+ return $this->get_driver()->get_sql_error_sql();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_transaction()

+ {

+ return $this->get_driver()->get_transaction();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_sql_time()

+ {

+ return $this->get_driver()->get_sql_time();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_sql_error_returned()

+ {

+ return $this->get_driver()->get_sql_error_returned();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_multi_insert()

+ {

+ return $this->get_driver()->get_multi_insert();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function set_multi_insert($multi_insert)

+ {

+ $this->get_driver()->set_multi_insert($multi_insert);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_row_count($table_name)

+ {

+ return $this->get_driver()->get_row_count($table_name);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function get_estimated_row_count($table_name)

+ {

+ return $this->get_driver()->get_estimated_row_count($table_name);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_lower_text($column_name)

+ {

+ return $this->get_driver()->sql_lower_text($column_name);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_error($sql = '')

+ {

+ return $this->get_driver()->sql_error($sql);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_buffer_nested_transactions()

+ {

+ return $this->get_driver()->sql_buffer_nested_transactions();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_bit_or($column_name, $bit, $compare = '')

+ {

+ return $this->get_driver()->sql_bit_or($column_name, $bit, $compare);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

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

+ {

+ return $this->get_driver()->sql_server_info($raw, $use_cache);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_return_on_error($fail = false)

+ {

+ return $this->get_driver()->sql_return_on_error($fail);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_build_array($query, $assoc_ary = array())

+ {

+ return $this->get_driver()->sql_build_array($query, $assoc_ary);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_fetchrowset($query_id = false)

+ {

+ return $this->get_driver()->sql_fetchrowset($query_id);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_transaction($status = 'begin')

+ {

+ return $this->get_driver()->sql_transaction($status);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_concatenate($expr1, $expr2)

+ {

+ return $this->get_driver()->sql_concatenate($expr1, $expr2);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_case($condition, $action_true, $action_false = false)

+ {

+ return $this->get_driver()->sql_case($condition, $action_true, $action_false);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_build_query($query, $array)

+ {

+ return $this->get_driver()->sql_build_query($query, $array);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_fetchfield($field, $rownum = false, $query_id = false)

+ {

+ return $this->get_driver()->sql_fetchfield($field, $rownum, $query_id);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_fetchrow($query_id = false)

+ {

+ return $this->get_driver()->sql_fetchrow($query_id);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function cast_expr_to_bigint($expression)

+ {

+ return $this->get_driver()->cast_expr_to_bigint($expression);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_nextid()

+ {

+ return $this->get_driver()->sql_nextid();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_add_num_queries($cached = false)

+ {

+ return $this->get_driver()->sql_add_num_queries($cached);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

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

+ {

+ return $this->get_driver()->sql_query_limit($query, $total, $offset, $cache_ttl);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

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

+ {

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

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function cast_expr_to_string($expression)

+ {

+ return $this->get_driver()->cast_expr_to_string($expression);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

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

+ {

+ throw new \Exception('Disabled method.');

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_bit_and($column_name, $bit, $compare = '')

+ {

+ return $this->get_driver()->sql_bit_and($column_name, $bit, $compare);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_freeresult($query_id = false)

+ {

+ return $this->get_driver()->sql_freeresult($query_id);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_num_queries($cached = false)

+ {

+ return $this->get_driver()->sql_num_queries($cached);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_multi_insert($table, $sql_ary)

+ {

+ return $this->get_driver()->sql_multi_insert($table, $sql_ary);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_affectedrows()

+ {

+ return $this->get_driver()->sql_affectedrows();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_close()

+ {

+ return $this->get_driver()->sql_close();

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_rowseek($rownum, &$query_id)

+ {

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

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_escape($msg)

+ {

+ return $this->get_driver()->sql_escape($msg);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_like_expression($expression)

+ {

+ return $this->get_driver()->sql_like_expression($expression);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_report($mode, $query = '')

+ {

+ return $this->get_driver()->sql_report($mode, $query);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function sql_in_set($field, $array, $negate = false, $allow_empty_set = false)

+ {

+ return $this->get_driver()->sql_in_set($field, $array, $negate, $allow_empty_set);

+ }

+}

+ WHERE bbcode_match ' . $this->db->sql_like_expression($this->db->get_any_char() . 'LOCAL_URL' . $this->db->get_any_char());

+ if ($this->db->get_sql_layer() == 'oracle')

+ WHERE template_filename ' . $this->db->sql_like_expression($this->db->get_any_char() . '.txt');

+ WHERE group_name ' . $this->db->sql_like_expression('EXT_GROUP_' . $this->db->get_any_char());

+ return strpos($this->db->get_sql_layer(), 'mysql') === false;

+ return strpos($this->db->get_sql_layer(), 'postgres') === false;

+ if ($this->db->get_sql_error_triggered())

+ 'sql' => $this->db->get_sql_error_sql(),

+ 'code' => $this->db->get_sql_error_returned(),

+ if (!$this->db->get_sql_error_triggered())

+ if (!$this->db->get_multi_insert() || sizeof($this->buffer) >= $this->max_buffered_rows)

+ switch ($this->db->get_sql_layer())

+ $this->sql_layer = $this->db->get_sql_layer();

+ switch ($this->db->get_sql_layer())

+ if (($this->db->get_sql_layer() == 'sqlite' || $this->db->get_sql_layer() == 'sqlite3') && $this->return_statements)

+ public function is_available($name)

+ public function is_enabled($name)

+ * Check to see if a given extension is disabled

+ *

+ * @param string $name Extension name to check

+ * @return bool Depending on whether or not the extension is disabled

+ */

+ public function is_disabled($name)

+ {

+ return isset($this->extensions[$name]) && !$this->extensions[$name]['ext_active'];

+ }

+

+ /**

+ * Check to see if a given extension is configured

+ *

+ * All enabled and disabled extensions are considered configured. A purged

+ * extension that is no longer in the database is not configured.

+ *

+ * @param string $name Extension name to check

+ * @return bool Depending on whether or not the extension is configured

+ */

+ public function is_configured($name)

+ {

+ return isset($this->extensions[$name]);

+ }

+

+ /**

+ * Check to see if a given extension is purged

+ *

+ * An extension is purged if it is available, not enabled and not disabled.

+ *

+ * @param string $name Extension name to check

+ * @return bool Depending on whether or not the extension is purged

+ */

+ public function is_purged($name)

+ {

+ return $this->is_available($name) && !$this->is_configured($name);

+ }

+

+ /**

+ if (!isset($this->metadata['extra']['soft-require']['phpbb/phpbb']))

+ 'META_REQUIRE_PHPBB' => (isset($this->metadata['extra']['soft-require']['phpbb/phpbb'])) ? htmlspecialchars($this->metadata['extra']['soft-require']['phpbb/phpbb']) : '',

+ $keywords[$i] = $this->db->sql_like_expression($this->db->get_any_char() . $keywords[$i] . $this->db->get_any_char());

+ $value_raw = $profile_field->get_profile_value_raw($ident_ary['value'], $ident_ary['data']);

+ 'PROFILE_' . strtoupper($ident) . '_IDENT' => $ident,

+ 'PROFILE_' . strtoupper($ident) . '_VALUE' => $value,

+ 'PROFILE_' . strtoupper($ident) . '_VALUE_RAW' => $value_raw,

+ 'PROFILE_' . strtoupper($ident) . '_CONTACT' => $contact_url,

+ 'PROFILE_' . strtoupper($ident) . '_DESC' => $field_desc,

+ 'PROFILE_' . strtoupper($ident) . '_TYPE' => $ident_ary['data']['field_type'],

+ 'PROFILE_' . strtoupper($ident) . '_NAME' => $this->user->lang($ident_ary['data']['lang_name']),

+ 'PROFILE_' . strtoupper($ident) . '_EXPLAIN' => $this->user->lang($ident_ary['data']['lang_explain']),

+ 'PROFILE_FIELD_IDENT' => $ident,

+ 'PROFILE_FIELD_VALUE' => $value,

+ 'PROFILE_FIELD_VALUE_RAW' => $value_raw,

+ 'PROFILE_FIELD_CONTACT' => $contact_url,

+ 'PROFILE_FIELD_DESC' => $field_desc,

+ 'PROFILE_FIELD_TYPE' => $ident_ary['data']['field_type'],

+ 'PROFILE_FIELD_NAME' => $this->user->lang($ident_ary['data']['lang_name']),

+ 'PROFILE_FIELD_EXPLAIN' => $this->user->lang($ident_ary['data']['lang_explain']),

+ public function get_profile_value_raw($field_value, $field_data)

+ {

+ if ($field_value == $field_data['field_novalue'] && !$field_data['field_show_novalue'])

+ {

+ return null;

+ }

+

+ if (!$field_value && $field_data['field_show_novalue'])

+ {

+ $field_value = $field_data['field_novalue'];

+ }

+

+ return $field_value;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_value_raw($field_value, $field_data)

+ {

+ if (($field_value === '' || $field_value === null) && !$field_data['field_show_novalue'])

+ {

+ return null;

+ }

+

+ return $field_value;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_value_raw($field_value, $field_data)

+ {

+ if ($field_value == $field_data['field_novalue'] && !$field_data['field_show_novalue'])

+ {

+ return null;

+ }

+

+ if (!$field_value && $field_data['field_show_novalue'])

+ {

+ $field_value = $field_data['field_novalue'];

+ }

+

+ return $field_value;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function get_profile_value_raw($field_value, $field_data)

+ {

+ if (($field_value === '' || $field_value === null) && !$field_data['field_show_novalue'])

+ {

+ return null;

+ }

+ return (int) $field_value;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ * Get Profile Value ID for display (the raw, unprocessed user data)

+ *

+ * @param mixed $field_value Field value as stored in the database

+ * @param array $field_data Array with requirements of the field

+ * @return mixed Field value ID to display

+ */

+ public function get_profile_value_raw($field_value, $field_data);

+

+ /**

+ public function get_profile_value_raw($field_value, $field_data)

+ {

+ if (!$field_value && !$field_data['field_show_novalue'])

+ {

+ return null;

+ }

+

+ return $field_value;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ $sql_where .= " OR search_keywords " . $db->sql_like_expression($db->get_any_char() . $word . $db->get_any_char());

+ $sql_where .= (($sql_where) ? ' OR ' : '') . 'search_authors ' . $db->sql_like_expression($db->get_any_char() . ' ' . (int) $author . ' ' . $db->get_any_char());

+ if ($this->db->get_sql_layer() != 'mysql4' && $this->db->get_sql_layer() != 'mysqli')

+ if ($this->db->get_sql_layer() == 'mysqli' || version_compare($this->db->sql_server_info(true), '4.1.3', '>='))

+ if ($this->db->get_sql_layer() == 'mysqli' || version_compare($this->db->sql_server_info(true), '4.1.3', '>='))

+ if (strpos($this->db->get_sql_layer(), 'mysql') === false)

+ switch ($this->db->get_sql_layer())

+ switch ($this->db->get_sql_layer())

+ if ($this->db->get_sql_layer() == 'sqlite' || $this->db->get_sql_layer() == 'sqlite3')

+ $sql_time" . (($this->db->get_sql_layer() == 'sqlite' || $this->db->get_sql_layer() == 'sqlite3') ? ')' : '');

+ switch ($this->db->get_sql_layer())

+ if ($this->db->get_sql_layer() != 'postgres')

+ if ($this->db->get_sql_layer() != 'postgres')

+ <dd>' . (($this->db->get_sql_layer() == 'postgres') ? $this->user->lang['YES'] : $this->user->lang['NO']) . '</dd>

+ if ($this->db->get_sql_layer() == 'postgres')

+ if ($this->db->get_sql_layer() != 'mysql' && $this->db->get_sql_layer() != 'mysql4' && $this->db->get_sql_layer() != 'mysqli' && $this->db->get_sql_layer() != 'postgres')

+ if ($this->db->get_sql_layer() =='mysql' || $this->db->get_sql_layer() == 'mysql4' || $this->db->get_sql_layer() == 'mysqli')

+ else if ($this->db->get_sql_layer() == 'postgres')

+ return preg_replace_callback('#<!-- (ELSE)?IF((.*?) (?:\(*!?[\$|\.]([^\s]+)(.*?))?)-->#', $callback, $code);

+<?php

+/**

+*

+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

+*

+*/

+

+namespace phpbb;

+

+/**

+* Class to handle viewonline related tasks

+*/

+class viewonline_helper

+{

+ /**

+ * Get user page

+ *

+ * @param string $session_page User's session page

+ * @return array Match array filled by preg_match()

+ */

+ public function get_user_page($session_page)

+ {

+ preg_match('#^([./\\]*+[a-z0-9/_-]+)#i', $session_page, $on_page);

+ if (empty($on_page))

+ {

+ $on_page[1] = '';

+ }

+

+ return $on_page;

+ }

+}

+ $sql_where = (strpos($author, '*') !== false) ? ' username_clean ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), utf8_clean_string($author))) : " username_clean = '" . $db->sql_escape(utf8_clean_string($author)) . "'";

+ $sql_where = (strpos($author, '*') !== false) ? ' post_username ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), utf8_clean_string($author))) : " post_username = '" . $db->sql_escape(utf8_clean_string($author)) . "'";

+ $sql_author_match = (strpos($author, '*') !== false) ? ' ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), utf8_clean_string($author))) : " = '" . $db->sql_escape(utf8_clean_string($author)) . "'";

+ switch ($db->get_sql_layer())

+ container.find('ul.linklist.bulletin > li:first-child, ul.linklist.bulletin > li.rightside:last-child').addClass('no-bulletin');

+ * Responsive link lists

+ */

+ container.find('.linklist:not(.navlinks, [data-skip-responsive]), .postbody .post-buttons:not([data-skip-responsive])').each(function() {

+ var $this = $(this),

+ $body = $('body'),

+ filterSkip = '.breadcrumbs, [data-skip-responsive]',

+ filterLast = '.edit-icon, .quote-icon, [data-last-responsive]',

+ persist = $this.attr('id') == 'nav-main',

+ allLinks = $this.children(),

+ links = allLinks.not(filterSkip),

+ html = '<li class="responsive-menu" style="display:none;"><a href="javascript:void(0);" class="responsive-menu-link">&nbsp;</a><div class="dropdown" style="display:none;"><div class="pointer"><div class="pointer-inner" /></div><ul class="dropdown-contents" /></div></li>',

+ filterLastList = links.filter(filterLast),

+ slack = 1; // Vertical slack space (in pixels). Determines how sensitive the script is in determining whether a line-break has occured.

+

+ if (!persist) {

+ if (links.is('.rightside'))

+ {

+ links.filter('.rightside:first').before(html);

+ $this.children('.responsive-menu').addClass('rightside');

+ }

+ else

+ {

+ $this.append(html);

+ }

+ }

+

+ var item = $this.children('.responsive-menu'),

+ menu = item.find('.dropdown-contents'),

+ lastWidth = false,

+ compact = false,

+ responsive = false,

+ copied = false;

+

+ function check() {

+ var width = $body.width();

+ if (responsive && width <= lastWidth) {

+ return;

+ }

+

+ // Unhide the quick-links menu if it has content

+ if (persist) {

+ item.addClass('hidden');

+ if (menu.find('li:not(.separator, .clone)').length || (responsive && menu.find('li.clone').length)) {

+ item.removeClass('hidden');

+ }

+ }

+

+ // Reset responsive and compact layout

+ if (responsive) {

+ responsive = false;

+ $this.removeClass('responsive');

+ links.css('display', '');

+ if (!persist) item.css('display', 'none');

+ }

+

+ if (compact) {

+ compact = false;

+ $this.removeClass('compact');

+ }

+

+ // Find tallest element

+ var maxHeight = 0;

+ allLinks.each(function() {

+ if (!$(this).height()) return;

+ maxHeight = Math.max(maxHeight, $(this).outerHeight(true));

+ });

+

+ if (maxHeight < 1) {

+ return;

+ }

+

+ // Nothing to resize if block's height is not bigger than tallest element's height

+ if ($this.height() <= (maxHeight + slack)) {

+ return;

+ }

+

+ // Enable compact layout, find tallest element, compare to height of whole block

+ compact = true;

+ $this.addClass('compact');

+

+ var compactMaxHeight = 0;

+ allLinks.each(function() {

+ if (!$(this).height()) return;

+ compactMaxHeight = Math.max(compactMaxHeight, $(this).outerHeight(true));

+ });

+

+ if ($this.height() <= (maxHeight + slack)) {

+ return;

+ }

+

+ // Compact layout did not resize block enough, switch to responsive layout

+ compact = false;

+ $this.removeClass('compact');

+ responsive = true;

+

+ if (!copied) {

+ var clone = links.clone(true);

+ clone.filter('.rightside').each(function() {

+ if (persist) $(this).addClass('clone');

+ menu.prepend(this);

+ });

+

+ if (persist) {

+ menu.prepend(clone.not('.rightside').addClass('clone'));

+ } else {

+ menu.prepend(clone.not('.rightside'));

+ }

+

+ menu.find('li.leftside, li.rightside').removeClass('leftside rightside');

+ menu.find('.inputbox').parents('li:first').css('white-space', 'normal');

+

+ if ($this.hasClass('post-buttons')) {

+ $('.button', menu).removeClass('button icon-button');

+ $('.responsive-menu-link', item).addClass('button icon-button').prepend('<span></span>');

+ }

+ copied = true;

+ }

+ else {

+ menu.children().css('display', '');

+ }

+

+ item.css('display', '');

+ $this.addClass('responsive');

+

+ // Try to not hide filtered items

+ if (filterLastList.length) {

+ links.not(filterLast).css('display', 'none');

+

+ maxHeight = 0;

+ filterLastList.each(function() {

+ if (!$(this).height()) return;

+ maxHeight = Math.max(maxHeight, $(this).outerHeight(true));

+ });

+

+ if ($this.height() <= (maxHeight + slack)) {

+ menu.children().filter(filterLast).css('display', 'none');

+ return;

+ }

+ }

+

+ // If even responsive isn't enough, use both responsive and compact at same time

+ compact = true;

+ $this.addClass('compact');

+

+ links.css('display', 'none');

+ }

+

+ if (!persist) phpbb.registerDropdown(item.find('a.responsive-menu-link'), item.find('.dropdown'));

+

+ check();

+ $(window).resize(check);

+ });

+

+ /**

+ * Do not run functions below for old browsers

+ */

+ if (oldBrowser) {

+ return;

+ }

+

+ /**

+<p class="{S_CONTENT_FLOW_END} responsive-center time<!-- IF S_USER_LOGGED_IN --> rightside<!-- ENDIF -->"><!-- IF S_USER_LOGGED_IN -->{LAST_VISIT_DATE}<!-- ELSE -->{CURRENT_TIME}<!-- ENDIF --></p>

+<!-- IF S_USER_LOGGED_IN --><p class="responsive-center time">{CURRENT_TIME}</p><!-- ENDIF -->

+<!-- EVENT index_body_markforums_before -->

+<!-- IF U_MARK_FORUMS -->

+ <div class="action-bar compact">

+ <a href="{U_MARK_FORUMS}" class="mark-read rightside" accesskey="m" data-ajax="mark_forums_read">{L_MARK_FORUMS_READ}</a>

+ </div>

+<!-- EVENT index_body_markforums_after -->

+ <div class="dropdown-container dropdown-container-{S_CONTENT_FLOW_END}<!-- IF not S_IN_MCP --> dropdown-up<!-- ENDIF --> dropdown-{S_CONTENT_FLOW_BEGIN} dropdown-button-control" id="jumpbox">

+ <span title="<!-- IF S_IN_MCP and S_MERGE_SELECT -->{L_SELECT_TOPICS_FROM}<!-- ELSEIF S_IN_MCP -->{L_MODERATE_FORUM}<!-- ELSE -->{L_JUMP_TO}<!-- ENDIF -->" class="dropdown-trigger button dropdown-select">

+ <!-- IF S_IN_MCP and S_MERGE_SELECT -->{L_SELECT_TOPICS_FROM}<!-- ELSEIF S_IN_MCP -->{L_MODERATE_FORUM}<!-- ELSE -->{L_JUMP_TO}<!-- ENDIF -->

+ </span>

+ <div class="dropdown hidden">

+ <div class="pointer"><div class="pointer-inner"></div></div>

+ <ul class="dropdown-contents">

+ <!-- IF jumpbox_forums.FORUM_ID neq -1 -->

+ <li><!-- BEGIN level -->&nbsp; &nbsp;<!-- END level --><a href="{jumpbox_forums.LINK}">{jumpbox_forums.FORUM_NAME}</a></li>

+ <!-- ENDIF -->

+ </ul>

+ </div>

+ </div>

+ <ul id="nav-footer" class="linklist bulletin" role="menubar">

+ <li class="small-icon icon-home breadcrumbs" role="navigation">

+ <!-- IF U_WATCH_FORUM_LINK and not S_IS_BOT --><li class="small-icon icon-<!-- IF S_WATCHING_FORUM -->unsubscribe<!-- ELSE -->subscribe<!-- ENDIF -->" data-last-responsive="true"><a href="{U_WATCH_FORUM_LINK}" title="{S_WATCH_FORUM_TITLE}" data-ajax="toggle_link" data-toggle-class="small-icon icon-<!-- IF not S_WATCHING_FORUM -->unsubscribe<!-- ELSE -->subscribe<!-- ENDIF -->" data-toggle-text="{S_WATCH_FORUM_TOGGLE}" data-toggle-url="{U_WATCH_FORUM_TOGGLE}">{S_WATCH_FORUM_TITLE}</a></li><!-- ENDIF -->

+

+ <!-- IF not S_IS_BOT -->

+ <li class="small-icon icon-delete-cookies rightside"><a href="{U_DELETE_COOKIES}" data-ajax="true" data-refresh="true" role="menuitem">{L_DELETE_COOKIES}</a></li>

+ <!-- IF S_DISPLAY_MEMBERLIST --><li class="small-icon icon-members rightside" data-last-responsive="true"><a href="{U_MEMBERLIST}" title="{L_MEMBERLIST_EXPLAIN}" role="menuitem">{L_MEMBERLIST}</a></li><!-- ENDIF -->

+ <!-- ENDIF -->

+ <!-- IF U_TEAM --><li class="small-icon icon-team rightside" data-last-responsive="true"><a href="{U_TEAM}" role="menuitem">{L_THE_TEAM}</a></li><!-- ENDIF -->

+ <!-- IF U_CONTACT_US --><li class="small-icon icon-contact rightside" data-last-responsive="true"><a href="{U_CONTACT_US}" role="menuitem">{L_CONTACT_US}</a></li><!-- ENDIF -->

+<div class="navbar" role="navigation">

+ <ul id="nav-main" class="linklist bulletin" role="menubar">

+

+ <li id="quick-links" class="small-icon responsive-menu dropdown-container<!-- IF not S_DISPLAY_QUICK_LINKS and not S_DISPLAY_SEARCH --> hidden<!-- ENDIF -->" data-skip-responsive="true">

+ <a href="#" class="responsive-menu-link dropdown-trigger">{L_QUICK_LINKS}</a>

+ <div class="dropdown hidden">

+ <div class="pointer"><div class="pointer-inner"></div></div>

+ <ul class="dropdown-contents" role="menu">

+ <!-- EVENT navbar_header_quick_links_before -->

+

+ <!-- IF S_DISPLAY_SEARCH -->

+ <li class="separator"></li>

+ <!-- IF S_REGISTERED_USER -->

+ <li class="small-icon icon-search-self"><a href="{U_SEARCH_SELF}" role="menuitem">{L_SEARCH_SELF}</a></li>

+ <!-- ENDIF -->

+ <li class="small-icon icon-search-unanswered"><a href="{U_SEARCH_UNANSWERED}" role="menuitem">{L_SEARCH_UNANSWERED}</a></li>

+ <!-- IF S_LOAD_UNREADS -->

+ <li class="small-icon icon-search-unread"><a href="{U_SEARCH_UNREAD}" role="menuitem">{L_SEARCH_UNREAD}</a></li>

+ <!-- ENDIF -->

+ <!-- IF S_USER_LOGGED_IN -->

+ <li class="small-icon icon-search-new"><a href="{U_SEARCH_NEW}" role="menuitem">{L_SEARCH_NEW}</a></li>

+ <!-- ENDIF -->

+ <li class="small-icon icon-search-active"><a href="{U_SEARCH_ACTIVE_TOPICS}" role="menuitem">{L_SEARCH_ACTIVE_TOPICS}</a></li>

+ <!-- ENDIF -->

+ <li class="separator"></li>

+

+ <!-- EVENT navbar_header_quick_links_after -->

+ </ul>

+ </div>

+ <!-- IF U_ACP --><li class="small-icon icon-acp" data-skip-responsive="true"><a href="{U_ACP}" title="{L_ACP}" role="menuitem">{L_ACP_SHORT}</a></li><!-- ENDIF -->

+ <!-- IF U_MCP --><li class="small-icon icon-mcp" data-skip-responsive="true"><a href="{U_MCP}" title="{L_MCP}" role="menuitem">{L_MCP_SHORT}</a></li><!-- ENDIF -->

+ <!-- EVENT overall_header_navigation_prepend -->

+ <li class="small-icon icon-faq" <!-- IF not S_USER_LOGGED_IN -->data-skip-responsive="true"<!-- ELSE -->data-last-responsive="true"<!-- ENDIF -->><a href="{U_FAQ}" title="{L_FAQ_EXPLAIN}" role="menuitem">{L_FAQ}</a></li>

+ <!-- EVENT overall_header_navigation_append -->

+ <!-- IF S_REGISTERED_USER -->

+ <li id="username_logged_in" class="rightside <!-- IF CURRENT_USER_AVATAR --> no-bulletin<!-- ENDIF -->" data-skip-responsive="true">

+ <!-- EVENT navbar_header_username_prepend -->

+ <div class="header-profile dropdown-container">

+ <a href="{U_PROFILE}" class="header-avatar dropdown-trigger"><!-- IF CURRENT_USER_AVATAR -->{CURRENT_USER_AVATAR} <!-- ENDIF -->{CURRENT_USERNAME_SIMPLE}</a>

+ <div class="dropdown hidden">

+ <div class="pointer"><div class="pointer-inner"></div></div>

+ <ul class="dropdown-contents" role="menu">

+ <!-- IF U_RESTORE_PERMISSIONS --><li class="small-icon icon-restore-permissions"><a href="{U_RESTORE_PERMISSIONS}">{L_RESTORE_PERMISSIONS}</a></li><!-- ENDIF -->

+

+ <!-- EVENT navbar_header_profile_list_before -->

+

+ <li class="small-icon icon-ucp"><a href="{U_PROFILE}" title="{L_PROFILE}" role="menuitem">{L_PROFILE}</a></li>

+ <li class="small-icon icon-profile"><a href="{U_USER_PROFILE}" title="{L_READ_PROFILE}" role="menuitem">{L_READ_PROFILE}</a></li>

+

+ <!-- EVENT navbar_header_profile_list_after -->

+

+ <li class="separator"></li>

+ <li class="small-icon icon-logout"><a href="{U_LOGIN_LOGOUT}" title="{L_LOGIN_LOGOUT}" accesskey="x" role="menuitem">{L_LOGIN_LOGOUT}</a></li>

+ </ul>

+ </div>

+ </div>

+ <!-- EVENT navbar_header_username_append -->

+ <li class="small-icon icon-pm rightside" data-skip-responsive="true">

+ <a href="{U_PRIVATEMSGS}" role="menuitem"><span>{L_PRIVATE_MESSAGES} [</span><strong>{PRIVATE_MESSAGE_COUNT}</strong><span>]</span></a>

+ <!-- IF S_NOTIFICATIONS_DISPLAY -->

+ <li class="small-icon icon-notification dropdown-container dropdown-{S_CONTENT_FLOW_END} rightside" data-skip-responsive="true">

+ <a href="{U_VIEW_ALL_NOTIFICATIONS}" id="notification_list_button" class="dropdown-trigger"><span>{L_NOTIFICATIONS} [</span><strong>{NOTIFICATIONS_COUNT}</strong><span>]</span></a>

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

+ </li>

+ <!-- ELSE -->

+ <li class="small-icon icon-logout rightside" data-skip-responsive="true"><a href="{U_LOGIN_LOGOUT}" title="{L_LOGIN_LOGOUT}" accesskey="x" role="menuitem">{L_LOGIN_LOGOUT}</a></li>

+ <!-- IF S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) -->

+ <li class="small-icon icon-register rightside" data-skip-responsive="true"><a href="{U_REGISTER}" role="menuitem">{L_REGISTER}</a></li>

+ <!-- EVENT navbar_header_logged_out_content -->

+ </ul>

+ <ul id="nav-breadcrumbs" class="linklist navlinks" role="menubar">

+ <!-- DEFINE $MICRODATA = ' itemtype="http://data-vocabulary.org/Breadcrumb" itemscope=""' -->

+ <li class="small-icon icon-home breadcrumbs" role="navigation">

+ <!-- IF U_SITE_HOME --><span class="crumb"><a href="{U_SITE_HOME}"{$MICRODATA} data-navbar-reference="home">{L_SITE_HOME}</a></span><!-- ENDIF -->

+ <span class="crumb"><a href="{U_INDEX}" accesskey="h"{$MICRODATA} data-navbar-reference="index">{L_INDEX}</a></span>

+ <!-- BEGIN navlinks -->

+ <!-- EVENT overall_header_navlink_prepend -->

+ <span class="crumb"><a href="{navlinks.U_VIEW_FORUM}"{$MICRODATA}<!-- IF navlinks.MICRODATA --> {navlinks.MICRODATA}<!-- ENDIF -->>{navlinks.FORUM_NAME}</a></span>

+ <!-- EVENT overall_header_navlink_append -->

+ <!-- END navlinks -->

+ <!-- EVENT overall_header_breadcrumb_append -->

+ </li>

+

+ <!-- IF S_DISPLAY_SEARCH and not S_IN_SEARCH -->

+ <li class="rightside responsive-search" style="display: none;"><a href="{U_SEARCH}" title="{L_SEARCH_ADV_EXPLAIN}" role="menuitem">{L_SEARCH}</a></li>

+

+ <div class="action-bar compact">

+ <a href="{U_MARK_FORUMS}" class="mark-read rightside" data-ajax="mark_forums_read">{L_MARK_SUBFORUMS_READ}</a>

+ </div>

+

+ <!-- IF .quickmod -->

+ <div class="dropdown-container dropdown-container-{S_CONTENT_FLOW_BEGIN} dropdown-up dropdown-{S_CONTENT_FLOW_END} dropdown-button-control" id="quickmod">

+ <span title="{L_QUICK_MOD}" class="dropdown-trigger button icon-button modtools-icon dropdown-select">{L_QUICK_MOD}</span>

+ <div class="dropdown hidden">

+ <div class="pointer"><div class="pointer-inner"></div></div>

+ <ul class="dropdown-contents">

+ <!-- BEGIN quickmod -->

+ <!-- DEFINE $QUICKMOD_AJAX = (quickmod.VALUE in ['lock', 'unlock', 'delete_topic', 'restore_topic', 'make_normal', 'make_sticky', 'make_announce', 'make_global']) -->

+ <li><a href="{quickmod.LINK}"<!-- IF $QUICKMOD_AJAX --> data-ajax="true" data-refresh="true"<!-- ENDIF -->>{quickmod.TITLE}</a></li>

+ <!-- END quickmod -->

+ </ul>

+ </div>

+ </div>

+ <!-- ENDIF -->

+

+ <a href="{U_WATCH_TOPIC}" class="watch-topic-link" title="{S_WATCH_TOPIC_TITLE}" data-ajax="toggle_link" data-toggle-class="small-icon icon-<!-- IF not S_WATCHING_TOPIC -->unsubscribe<!-- ELSE -->subscribe<!-- ENDIF -->" data-toggle-text="{S_WATCH_TOPIC_TOGGLE}" data-toggle-url="{U_WATCH_TOPIC_TOGGLE}" data-update-all=".watch-topic-link">{S_WATCH_TOPIC_TITLE}</a>

+ <a href="{U_BOOKMARK_TOPIC}" class="bookmark-link" title="{L_BOOKMARK_TOPIC}" data-ajax="alt_text" data-alt-text="{S_BOOKMARK_TOGGLE}" data-update-all=".bookmark-link">{S_BOOKMARK_TOPIC}</a>

+* common.css

+.rtl ul.linklist > li {

+ margin-left: 7px;

+.rtl ul.linklist > li.rightside, .rtl p.rightside, .rtl a.rightside {

+ margin-right: 7px;

+.rtl ul.leftside > li, .rtl ul.rightside > li {

+.rtl ul.linklist.bulletin > li:before {

+.rtl ul.linklist li.responsive-menu a.responsive-menu-link:before {

+ left: auto;

+ right: 0;

+}

+

+.rtl .dropdown-extended .header {

+ text-align: right;

+}

+

+/* column[1-2] styles are containers for two column layouts

+.rtl #quick-links {

+ margin-left: 7px;

+ margin-right: 0;

+.rtl .header-avatar span:after {

+ float: left;

+ padding-left: 0;

+ padding-right: 2px;

+.rtl dd.lastpost > span, .rtl ul.topiclist dd.info > span, .rtl ul.topiclist dd.time > span, .rtl dd.redirect > span, .rtl dd.moderation > span {

+ padding-left: 0;

+ padding-right: 19px;

+ text-align: right;

+.dropdown-select {

+ padding-right: 24px;

+.dropdown-select.icon-button:before {

+ margin-right: 4px;

+}

+

+#jumpbox .dropdown-select {

+ margin: 0;

+}

+

+.modtools-icon {

+ font-size: 0;

+}

+

+.tools-icon:before, .modtools-icon:before {

+.modtools-icon:before { background-position: -225px 0; }

+.dropdown-visible .modtools-icon:before,

+.nojs .dropdown-container:hover .modtools-icon:before { background-position: -225px -20px; }

+

+ul.linklist.bulletin > li.small-icon:before {

+.post-buttons > li {

+ background-color: #F5F7FA;

+#wrap {

+ background-color: #FFF;

+ border-color: #E6E9ED;

+}

+

+ border-top-color: #FFFFFF;

+p.post-notice.deleted:before {

+p.post-notice.unapproved:before {

+p.post-notice.reported:before, p.post-notice.error:before {

+#search-box a, .navbg a, .forumbg .header a, .forabg .header a, th a {

+.postlink {

+.signature a, .signature a:hover {

+.button {

+ color: #D31141;

+}

+

+.dropdown-select, .dropdown-select:visited {

+ color: #536482;

+.icon-acp { background-image: url("./images/icon_acp.gif"); }

+.icon-bookmark { background-image: url("./images/icon_bookmark.gif"); }

+.icon-bump { background-image: url("./images/icon_bump.gif"); }

+.icon-contact { background-image: url("./images/icon_pm.gif"); }

+.icon-delete-cookies { background-image: url("./images/icon_delete_cookies.gif"); }

+.icon-download { background-image: url("./images/icon_download.gif"); }

+.icon-faq { background-image: url("./images/icon_faq.gif"); }

+.icon-home { background-image: url("./images/icon_home.gif"); }

+.icon-logout { background-image: url("./images/icon_logout.gif"); }

+.icon-mark { background-image: url("./images/icon_mark.gif"); }

+.icon-mcp { background-image: url("./images/icon_mcp.gif"); }

+.icon-members { background-image: url("./images/icon_members.gif"); }

+.icon-notification { background-image: url("./images/icon_notification.gif"); }

+.icon-pages { background-image: url("./images/icon_pages.gif"); }

+.icon-pm { background-image: url("./images/icon_pm.gif"); }

+.icon-print { background-image: url("./images/icon_print.gif"); }

+.icon-profile { background-image: url("./images/icon_profile.gif"); }

+.icon-quick-links { background-image: url("./images/icon_quick_links.gif"); }

+.icon-register { background-image: url("./images/icon_register.gif"); }

+.icon-search-active { background-image: url("./images/subforum_read.gif"); }

+.icon-search-advanced { background-image: url("./images/icon_search_adv.gif"); }

+.icon-search-new { background-image: url("./images/subforum_unread.gif"); }

+.icon-search-self { background-image: url("./images/icon_topic_latest.gif"); }

+.icon-search-unanswered { background-image: url("./images/icon_post_target.gif"); }

+.icon-search-unread { background-image: url("./images/subforum_unread.gif"); }

+.icon-sendemail { background-image: url("./images/icon_sendemail.gif"); }

+.icon-subscribe { background-image: url("./images/icon_subscribe.gif"); }

+.icon-team { background-image: url("./images/icon_team.gif"); }

+.icon-ucp { background-image: url("./images/icon_ucp.gif"); }

+.icon-unsubscribe { background-image: url("./images/icon_unsubscribe.gif"); }

+ color: #D31141;

+ border-color: #D31141;

+a.button1, a.button2 {

+ border-top-color: #B9B9B9;

+.dropdown li.separator {

+ border-color: #DCDCDC;

+}

+

+ padding: 0;

+ border: 1px solid transparent;

+ border-radius: 8px;

+ margin: 12px auto;

+ max-width: 1152px;

+ min-width: 625px;

+ padding: 15px;

+}

+

+@media only screen and (max-width: 1220px), only screen and (max-device-width: 1220px) {

+ #wrap {

+ margin: 12px;

+ }

+ padding: 3px 10px;

+.navbar ul.linklist {

+ padding: 2px 0;

+}

+

+ul.linklist > li {

+ list-style-type: none;

+ margin-right: 7px;

+ width: auto;

+ul.linklist > li.rightside, p.rightside, a.rightside {

+ margin-left: 7px;

+ border-top: 1px solid transparent;

+ line-height: 20px;

+ul.linklist .dropdown {

+ top: auto;

+ul.linklist.bulletin > li:before {

+ul.linklist.bulletin > li:first-child:before,

+ul.linklist.bulletin > li.rightside:last-child:before {

+ul.linklist.bulletin > li.no-bulletin:before {

+/* Profile in overall_header.html */

+.header-profile {

+ display: inline-block;

+ vertical-align: top;

+}

+

+.header-avatar:hover {

+ text-decoration: none;

+}

+

+ max-height: 20px;

+.header-avatar span:after {

+ content: '\25BC';

+ display: inline-block;

+ font-size: 9px;

+ float: right;

+ padding-left: 2px;

+ opacity: 0.7;

+}

+

+.dropdown-container-right {

+ float: right;

+}

+

+.dropdown-container-left {

+ float: left;

+}

+

+ max-height: 300px;

+ border-top: 1px dotted transparent;

+.dropdown-contents > li {

+ padding-right: 15px;

+}

+

+.dropdown-nonscroll > li {

+ padding-right: 0;

+}

+

+.dropdown li:first-child, .dropdown li.separator + li, .dropdown li li {

+ border-top: 0;

+.dropdown li.separator {

+ border-top: 1px solid transparent;

+ margin: 4px 0;

+ padding: 0;

+}

+

+.dropdown li.separator:first-child, .dropdown li.separator:last-child {

+ font-weight: bold;

+ left: 0;

+ right: 0;

+ margin: 0 auto;

+#jumpbox {

+ margin: 5px 0;

+}

+

+.stat-block {

+ clear: both;

+}

+

+ border-top: 1px solid;

+.dropdown-extended ul li:first-child {

+ border-top: none;

+.dropdown-extended ul li.no_notifications {

+ padding: 10px;

+ position: absolute;

+ width: 340px;

+}

+

+.nojs .dropdown-extended .dropdown-contents {

+ position: relative;

+ text-align: left;

+ text-transform: uppercase;

+/* Navbar specific list items

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

+

+#quick-links {

+ margin: 0 7px 0 0;

+}

+

+#quick-links a.responsive-menu-link {

+ display: block;

+ font-size: inherit;

+ line-height: inherit;

+ margin: 0;

+ width: auto;

+}

+

+#quick-links a.responsive-menu-link:before {

+ font-size: 16px;

+ line-height: 16.5px;

+}

+

+.compact #quick-links a.responsive-menu-link {

+ font-size: 0;

+}

+

+

+.dropdown .clone {

+ display: none;

+}

+

+.responsive .dropdown .clone {

+ display: inherit;

+}

+

+.dropdown .clone + li.separator {

+ display: none;

+}

+

+.responsive .dropdown .clone + li.separator {

+ display: inherit;

+}

+dd.lastpost > span, ul.topiclist dd.info > span, ul.topiclist dd.time > span, dd.redirect > span, dd.moderation > span {

+ margin: 0.5em 1px 0 15px;

+ width: auto;

+ padding: 0;

+/* CP tabbed menu

+.pmlist li.pm_marked_colour, .pm_marked_colour,

+ max-width: 40px;

+ #navigation {

+ padding: 0;

+ float: left;

+input[type="button"], input[type="submit"], input[type="reset"], input[type="checkbox"], input[type="radio"] {

+ cursor: pointer;

+a:hover { text-decoration: underline; }

+#search-box a, .navbg a, .forumbg .header a, .forabg .header a, th a {

+.signature a, .signature a:hover {

+.postprofile a, .postprofile dt.author a {

+/* Profile searchresults */

+ text-decoration: none;

+ text-decoration: underline;

+a.arrow-up {

+a.arrow-down {

+a.arrow-left {

+a.arrow-right {

+.postbody .author a:link, .postbody .author a:visited,

+html>body .postbody .author a:link:after,

+.postquote .quote-by a:link, .postquote .quote-by a:visited,

+html>body .postquote .quote-by a:link:after,

+.quote-by, blockquote cite {

+ border: none;

+ border-radius: 0;

+ margin: 0;

+ min-width: 290px;

+ padding: 0 5px;

+ height: 22px;

+ul.topiclist dd {

+ display: none;

+ul.topiclist dd.mark {

+ display: block;

+ .dropdown-extended .dropdown-contents {

+ width: auto;

+ text-align: left;

+These style definitions are IE 7 and 8 specific

+dd label input {

+ vertical-align: text-bottom;

+ *vertical-align: middle;

+ height: 20px;

+<!-- EVENT index_body_markforums_before -->

+<!-- EVENT index_body_markforums_after -->

+$viewonline_helper = $phpbb_container->get('viewonline_helper');

+ switch ($db->get_sql_layer())

+ $on_page = $viewonline_helper->get_user_page($row['session_page']);

+$s_quickmod_action = append_sid(

+ "{$phpbb_root_path}mcp.$phpEx",

+ array(

+ 'f' => $forum_id,

+ 't' => $topic_id,

+ 'start' => $start,

+ 'quickmod' => 1,

+ 'redirect' => urlencode(str_replace('&amp;', '&', $viewtopic_url)),

+ ),

+ true,

+ $user->session_id

+);

+

+ phpbb_add_quickmod_option($s_quickmod_action, $option, $qm_ary[0]);

+ 'S_MOD_ACTION' => $s_quickmod_action,

+ if (strpos($db->get_sql_layer(), 'mysql') === 0 && version_compare($db->sql_server_info(true, false), '5.6', '>='))

+ $like_expression = str_replace('*', $db->get_any_char(), $like_expression);

+ $like_expression = str_replace('#', $db->get_one_char(), $like_expression);

+ $this->db->set_multi_insert(false);

+ $this->db->set_multi_insert(false);

+ $this->db->set_multi_insert(false);

+ if (!$this->db->get_multi_insert())

+ "php": ">=5.3"

+ "display-name": "phpBB BarFoo Extension",

+ "soft-require": {

+ "phpbb/phpbb": "3.1.*@dev"

+ }

+ "php": ">=5.3"

+ "display-name": "phpBB Moo Extension",

+ "soft-require": {

+ "phpbb/phpbb": "3.1.*@dev"

+ }

+ "php": ">=5.3"

+ "display-name": "phpBB Bar Extension",

+ "soft-require": {

+ "phpbb/phpbb": "3.1.*@dev"

+ }

+ "php": ">=5.3"

+ "display-name": "phpBB Foo Extension",

+ "soft-require": {

+ "phpbb/phpbb": "3.1.*@dev"

+ }

+ public function test_all_available()

+ public function test_all_enabled()

+ public function test_all_configured()

+ public function test_is_enabled()

+ {

+ $this->assertSame(true, $this->extension_manager->is_enabled('vendor2/foo'));

+ $this->assertSame(false, $this->extension_manager->is_enabled('vendor/moo'));

+ $this->assertSame(false, $this->extension_manager->is_enabled('vendor2/bar'));

+ $this->assertSame(false, $this->extension_manager->is_enabled('bertie/worlddominationplan'));

+ }

+

+ public function test_is_disabled()

+ {

+ $this->assertSame(false, $this->extension_manager->is_disabled('vendor2/foo'));

+ $this->assertSame(true, $this->extension_manager->is_disabled('vendor/moo'));

+ $this->assertSame(false, $this->extension_manager->is_disabled('vendor2/bar'));

+ $this->assertSame(false, $this->extension_manager->is_disabled('bertie/worlddominationplan'));

+ }

+

+ public function test_is_purged()

+ {

+ $this->assertSame(false, $this->extension_manager->is_purged('vendor2/foo'));

+ $this->assertSame(false, $this->extension_manager->is_purged('vendor/moo'));

+ $this->assertSame(true, $this->extension_manager->is_purged('vendor2/bar'));

+ $this->assertSame(false, $this->extension_manager->is_purged('bertie/worlddominationplan'));

+ }

+

+ public function test_is_configured()

+ {

+ $this->assertSame(true, $this->extension_manager->is_configured('vendor2/foo'));

+ $this->assertSame(true, $this->extension_manager->is_configured('vendor/moo'));

+ $this->assertSame(false, $this->extension_manager->is_configured('vendor2/bar'));

+ $this->assertSame(false, $this->extension_manager->is_configured('bertie/worlddominationplan'));

+ }

+

+ public function test_is_available()

+ {

+ $this->assertSame(true, $this->extension_manager->is_available('vendor2/foo'));

+ $this->assertSame(true, $this->extension_manager->is_available('vendor/moo'));

+ $this->assertSame(true, $this->extension_manager->is_available('vendor2/bar'));

+ $this->assertSame(false, $this->extension_manager->is_available('bertie/worlddominationplan'));

+ }

+

+ protected $db_tools;

+ protected $table_prefix;

+ protected $migrator;

+ $container->set('migrator', $this->migrator);

+ catch (\phpbb\extension\exception $e)

+ {

+ $this->assertEquals((string) $e, $this->user->lang('FILE_NOT_FOUND', $this->phpbb_root_path . $this->extension_manager->get_extension_path($ext_name) . 'composer.json'));

+ }

+ catch (\phpbb\extension\exception $e)

+ public function validator_non_existing_data()

+ return array(

+ array('name'),

+ array('type'),

+ array('license'),

+ array('version'),

+ );

+ }

+ /**

+ * @dataProvider validator_non_existing_data

+ */

+ public function test_validator_non_existing($field_name)

+ {

+ $manager = $this->get_metadata_manager('validator');

+ $manager->validate($field_name);

+ $this->assertEquals((string) $e, $this->user->lang('META_FIELD_NOT_SET', $field_name));

+ }

+ public function test_validator_non_existing_authors()

+ {

+ $manager = $this->get_metadata_manager('validator');

+ catch (\phpbb\extension\exception $e)

+ catch (\phpbb\extension\exception $e)

+ public function validator_invalid_data()

+ return array(

+ array('name', 'asdf'),

+ array('type', 'asdf'),

+ array('license', ''),

+ array('version', ''),

+ );

+ }

+ /**

+ * @dataProvider validator_invalid_data

+ */

+ public function test_validator_invalid($field_name, $field_value)

+ {

+ $manager = $this->get_metadata_manager('validator');

+ $field_name => $field_value,

+ $manager->validate($field_name);

+ $this->assertEquals((string) $e, $this->user->lang('META_FIELD_INVALID', $field_name));

+ public function validator_requirements_data()

+ return array(

+ array(

+ '10.0.0',

+ '100.2.0',

+ false,

+ false,

+ 'Versions are not compared at the moment',

+ array(

+ '5.3.0',

+ '3.1.0-beta',

+ true,

+ true,

+ array(

+ '>' . phpversion(),

+ '>3.1.0',

+ false,

+ false,

+ 'Versions are not compared at the moment',

+ array(

+ '<' . phpversion(),

+ '<3.1.0',

+ false,

+ false,

+ 'Versions are not compared at the moment',

+ array(

+ phpversion(),

+ '3.1.0',

+ true,

+ true,

+ array(

+ '>=' . phpversion(),

+ '>=3.1.0',

+ true,

+ true,

+ array(

+ '<=' . phpversion(),

+ '<=3.1.0',

+ true,

+ true,

+ ),

+ );

+ }

+ /**

+ * @dataProvider validator_requirements_data

+ */

+ public function test_validator_requirements($php_version, $phpbb_version, $expected_php, $expected_phpbb, $incomplete_reason = '')

+ {

+ if ($incomplete_reason)

+ $this->markTestIncomplete($incomplete_reason);

+ $ext_name = 'validator';

+ $manager = $this->get_metadata_manager($ext_name);

+ // Too high of requirements

+ 'php' => $php_version,

+ ),

+ 'extra' => array(

+ 'soft-require' => array(

+ 'phpbb/phpbb' => $phpbb_version, // config is set to 3.1.0

+ ),

+ $this->assertEquals($expected_php, $manager->validate_require_php());

+ $this->assertEquals($expected_phpbb, $manager->validate_require_phpbb());

+ $crawler = $this->get_quickmod_page($this->data['topics']['Download Topic #1'], 'DELETE_TOPIC');

+ $crawler = $this->get_quickmod_page($this->data['topics']['Feeds #1 - Topic #2'], 'DELETE_TOPIC');

+ "php": ">=5.3"

+ "display-name": "phpBB 3.1 Extension Testing",

+ "soft-require": {

+ "phpbb/phpbb": "3.1.*@dev"

+ }

+ $this->crawler = $this->get_quickmod_page(1, 'MERGE_TOPIC');

+ $this->check_valid_jump('Your first forum');

+ $link = $this->crawler->filter('#jumpbox')->selectLink('Your first category')->link()->getUri();

+ $this->crawler = self::request('GET', substr($link, strpos($link, 'mcp.')));

+ $this->check_valid_jump('Your first category');

+ }

+ protected function check_valid_jump($forum)

+ {

+ $this->assertContains($this->lang('FORUM') . ": $forum", $this->crawler->filter('#cp-main h2')->text(), $this->crawler->text());

+ return $this->get_quickmod_page(0, 'MERGE_POSTS', $crawler);

+ $crawler = $this->get_quickmod_page($this->data['topics']['Soft Delete Topic #1'], 'MOVE_TOPIC');

+ $crawler = $this->get_quickmod_page($this->data['topics']['Soft Delete Topic #1'], 'DELETE_TOPIC');