/phpunit.xml

/phpBB/cache/*.html

/phpBB/cache/*.php

/phpBB/composer.phar

/phpBB/config.php

/phpBB/config_dev.php

- 5.3.3

- 5.3

- 5.4

env:

- DB=mysql

- DB=postgres

before_script:

- sh -c "if [ '$DB' = 'postgres' ]; then psql -c 'DROP DATABASE IF EXISTS phpbb_tests;' -U postgres; fi"

- sh -c "if [ '$DB' = 'postgres' ]; then psql -c 'create database phpbb_tests;' -U postgres; fi"

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

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

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

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

<property name="versions" value="${oldversions}, ${newversion}" />

<!-- These are the main targets which you will probably want to use -->

<target name="build" depends="clean,prepare,composer,test,docs" />

<target name="prepare">

<delete dir="build/save" />

</target>

passthru="true" />

</target>

</target>

<exec dir="build" command="php -f package.php '${versions}' > logs/package.log" escape="false" />

<exec dir="build" command="php -f build_diff.php '${prevversion}' '${newversion}' > logs/build_diff.log" escape="false" />

command="git archive ${revision} | tar -xf - -C ../${dir}"

checkreturn="true" />

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

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

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

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

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

</target>

</project>

// We define the admin variables now, because the user is now able to use the admin related features...

define('IN_ADMIN', true);

// Some oft used variables

$safe_mode = (@ini_get('safe_mode') == '1' || strtolower(@ini_get('safe_mode')) === 'on') ? true : false;

// Set custom style for admin area

$phpbb_style->set_ext_dir_prefix('adm/');

$template->assign_var('T_ASSETS_PATH', $phpbb_root_path . 'assets');

$template->assign_var('T_TEMPLATE_PATH', $phpbb_admin_path . 'style');

<dt><label for="topics_per_page">{L_FORUM_TOPICS_PAGE}{L_COLON}</label><br /><span>{L_FORUM_TOPICS_PAGE_EXPLAIN}</span></dt>

<dd><input type="text" id="topics_per_page" name="topics_per_page" value="{TOPICS_PER_PAGE}" size="4" maxlength="4" /></dd>

</dl>

</fieldset>

<fieldset>

</div>

<!-- ENDIF -->

<table cellspacing="1">

<caption>{L_FORUM_STATS}</caption>

<col class="col1" /><col class="col2" /><col class="col1" /><col class="col2" />

<dd><input type="hidden" name="action" value="purge_cache" /><input class="button2" type="submit" id="action_purge_cache" name="action_purge_cache" value="{L_RUN}" /></dd>

</dl>

</form>

</fieldset>

<!-- ENDIF -->

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

<dd><input type="password" id="password_confirm" name="password_confirm" value="" autocomplete="off" /></dd>

</dl>

<p class="quick">

<input class="button1" type="submit" name="update" value="{L_SUBMIT}" />

"use strict";

up: $('.template-up-img'),

down: $('.template-down-img'),

};

/**

* an item is moved up. It moves the row up or down, and deactivates /

* activates any up / down icons that require it (the ones at the top or bottom).

*/

var el = $(this),

tr = el.parents('tr'),

/*

* If the element was the first one, we have to:

* - Add the up-link to the row we moved

* - Remove the up-link on the next row

*/

phpbb.ajaxify({

selector: tr.find('.up').children('a'),

overlay: false

});

}

/*

* As well as:

* - Remove the down-link on the moved row, if it is now the last row

* - Add the down-link to the next row, if it was the last row

*/

phpbb.ajaxify({

callback: 'row_down',

overlay: false

});

}

});

var el = $(this),

tr = el.parents('tr'),

/*

* If the element was the last one, we have to:

* - Add the down-link to the row we moved

* - Remove the down-link on the next row

*/

phpbb.ajaxify({

selector: tr.find('.down').children('a'),

overlay: false

});

}

/*

* As well as:

* - Remove the up-link on the moved row, if it is now the first row

* - Add the up-link to the previous row, if it was the first row

*/

phpbb.ajaxify({

callback: 'row_up',

overlay: false

});

* It does this by replacing the text, and replacing all instances of "activate"

* in the href with "deactivate", and vice versa.

*/

var el = $(this),

el.text(res.text);

}

});

/**

* The removes the parent row of the link or form that triggered the callback,

* and is good for stuff like the removal of forums.

*/

$(this).parents('tr').remove();

});

ajax = $this.attr('data-ajax'),

fn;

fn = (ajax !== 'true') ? ajax : null;

phpbb.ajaxify({

selector: this,

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

<title>{PAGE_TITLE}</title>

<script type="text/javascript">

// <![CDATA[

</form>

<!-- ENDIF -->

</div>

<div id="page-body">

<div id="tabs">

<ul>

<!-- END l_block2 -->

</ul>

</div>

<div id="main" class="install-body">

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

<title>{PAGE_TITLE}</title>

<script type="text/javascript">

// <![CDATA[

<!-- INCLUDEJS ajax.js -->

{SCRIPTS}

</body>

</html>

// ]]>

</script>

</head>

<body class="{S_CONTENT_DIRECTION}">

<script type="text/javascript" src="{T_JQUERY_LINK}"></script>

<!-- IF S_JQUERY_FALLBACK --><script type="text/javascript">window.jQuery || document.write(unescape('%3Cscript src="{T_ASSETS_PATH}/javascript/jquery.js?assets_version={T_ASSETS_VERSION}" type="text/javascript"%3E%3C/script%3E'));</script><!-- ENDIF -->

</body>

</html>

// ]]>

</script>

</head>

<body class="{S_CONTENT_DIRECTION}">

(function($) { // Avoid conflicts with other libraries

$('#tz_date').change(function() {

});

$(document).ready(

);

})(jQuery); // Avoid conflicts with other libraries

$auth->acl($user->data);

$user->setup();

// Set custom template for admin area

$template->set_filenames(array(

'body' => 'colour_swatch.html')

var phpbb = {};

(function($) { // Avoid conflicts with other libraries

};

var dark = $('#darkenwrapper');

/**

*

*/

// Wait five seconds and display an error if nothing has been returned by then.

phpbb.alert($('#phpbb_alert').attr('data-l-err'), $('#phpbb_alert').attr('data-l-timeout-processing-req'));

}

}, 5000);

});

}

/**

* Display a simple alert similar to JSs native alert().

div.find('.alert_close').unbind('click');

fade = (typeof fadedark !== 'undefined' && !fadedark) ? div : dark;

div.hide();

});

e.preventDefault();

});

dark.append(div);

});

dark.append(div);

dark.append(div);

div.show();

}

return div;

/**

* Display a simple yes / no box to the user.

e.stopPropagation();

});

var res = this.className === 'button1';

var fade = (typeof fadedark !== 'undefined' && !fadedark && res) ? div : dark;

div.hide();

});

callback(res);

if (e) {

e.stopPropagation();

}

};

dark.one('click', function(e) {

div.find('.alert_close').unbind('click');

div.hide();

});

callback(false);

div.find('.alert_close').one('click', function(e) {

var fade = (typeof fadedark !== 'undefined' && fadedark) ? div : dark;

div.hide();

});

callback(false);

e.preventDefault();

});

dark.append(div);

});

dark.append(div);

dark.append(div);

div.show();

}

return div;

/**

* Turn a querystring into an array.

* @argument string string The querystring to parse.

* @returns object The object created.

*/

var params = {}, i, split;

string = string.split('&');

split = string[i].split('=');

params[split[0]] = decodeURIComponent(split[1]);

}

return params;

/**

refresh = options.refresh,

callback = options.callback,

overlay = (typeof options.overlay !== 'undefined') ? options.overlay : true,

var action, method, data, submit, that = this, $this = $(this);

return;

}

*

* @param object res The object sent back by the server.

*/

var alert;

// Is a confirmation required?

// If a confirmation is not required, display an alert and call the

// callbacks.

alert = phpbb.alert(res.MESSAGE_TITLE, res.MESSAGE_TEXT);

}

}

// If the server says to refresh the page, check whether the page should

// be refreshed and refresh page after specified time if required.

refresh = refresh(res.REFRESH_DATA.url);

refresh = false;

}

setTimeout(function() {

window.location = res.REFRESH_DATA.url;

}

// Hide the alert even if we refresh the page, in case the user

// presses the back button.

alert.hide();

});

}, res.REFRESH_DATA.time * 1000); // Server specifies time in seconds

}

// If confirmation is required, display a diologue to the user.

phpbb.confirm(res.MESSAGE_TEXT, function(del) {

data = $('<form>' + res.S_HIDDEN_FIELDS + '</form>').serialize();

$.ajax({

url: res.S_CONFIRM_ACTION,

type: 'POST',

data: data + '&confirm=' + res.YES_VALUE,

});

}

}, false);

}

}

var alert;

alert = phpbb.alert(dark.attr('data-ajax-error-title'), dark.attr('data-ajax-error-text'));

}

// If the element is a form, POST must be used and some extra data must

// be taken from the form.

action = $this.attr('action').replace('&amp;', '&');

data = $this.serializeArray();

method = $this.attr('method') || 'GET';

submit = $this.find('input[type="submit"][data-clicked]');

data.push({

name: submit.attr('name'),

value: submit.val()

});

}

action = this.href;

data = null;

method = 'GET';

// If filter function returns false, cancel the AJAX functionality,

// and return true (meaning that the HTTP request will be sent normally).

return;

}

if (overlay && (typeof $this.attr('data-overlay') === 'undefined' || $this.attr('data-overlay') == 'true'))

{

}

$.ajax({

url: action,

type: method,

data: data,

});

event.preventDefault();

});

elements.find('input:submit').click(function () {

var $this = $(this);

}

return this;

/**

* Hide the optgroups that are not the selected timezone

*

*/

if ($('#timezone_copy').length == 0) {

// We make a backup of the original dropdown, so we can remove optgroups

// instead of setting display to none, because IE and chrome will not

if ($("#timezone > optgroup[label='" + $('#tz_date').val() + "'] > option").size() == 1) {

// If there is only one timezone for the selected date, we just select that automatically.

$("#timezone > optgroup[label='" + $('#tz_date').val() + "'] > option:first").attr('selected', true);

}

}

/**

* Display the date/time select

*/

$('#tz_select_date').css('display', 'block');

/**

* Preselect a date/time or suggest one, if it is not picked.

*

*/

// The offset returned here is in minutes and negated.

// http://www.w3schools.com/jsref/jsref_getTimezoneOffset.asp

}

var prefix = 'GMT' + sign + hours + ':' + minutes;

// We do not select the option for the user, but notify him,

// that we would suggest a different setting.

$('#tz_select_date_suggest').css('display', 'inline');

} else {

option.selected = true;

$('#tz_select_date_suggest').css('display', 'none');

}

return;

}

}

/**

* Adds an AJAX callback to be used by phpbb.ajaxify.

* @param string id The name of the callback.

* @param function callback The callback to be called.

*/

}

return this;

/**

* the alt-text data attribute, and replaces the text in the attribute with the

* current text so that the process can be repeated.

*/

var el = $(this),

el.attr('data-alt-text', el.text());

});

/**

* Additionally it replaces the class of the link's parent

* and changes the link itself.

*/

var el = $(this),

// Toggle link text

el.attr('data-toggle-text', el.text());

// Toggle link url

el.attr('data-toggle-url', el.attr('href'));

// Toggle class of link parent

el.attr('data-toggle-class', el.parent().attr('class'));

});

})(jQuery); // Avoid conflicts with other libraries

exit;

}

// Include files

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

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

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

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

// Set PHP error handler to ours

$phpbb_class_loader_ext->register();

// Set up container

$phpbb_class_loader->set_cache($phpbb_container->get('cache.driver'));

$phpbb_class_loader_ext->set_cache($phpbb_container->get('cache.driver'));

// Add own hook handler

require($phpbb_root_path . 'includes/hooks/index.' . $phpEx);

$phpbb_hook = new phpbb_hook(array('exit_handler', 'phpbb_user_session_handler', 'append_sid', array('phpbb_template', 'display')));

{

@include($phpbb_root_path . 'includes/hooks/' . $hook . '.' . $phpEx);

}

- %core.php_ext%

- @config

- @dbal.conn

tags:

- { name: cron.task }

- %core.php_ext%

- @config

- @dbal.conn

tags:

- { name: cron.task }

- %core.root_path%

- %core.php_ext%

- @config

tags:

- { name: cron.task }

arguments:

- @config

- @cache.driver

tags:

- { name: cron.task }

- %core.root_path%

- %core.php_ext%

- @config

tags:

- { name: cron.task }

- @config

- @dbal.conn

- @user

tags:

- { name: cron.task }

arguments:

- @config

- @user

tags:

- { name: cron.task }

- %core.root_path%

- %core.php_ext%

- @config

tags:

- { name: cron.task }

class: phpbb_cache_service

arguments:

- @cache.driver

cache.driver:

class: %cache.driver.class%

- @service_container

- @ext.finder

cron.task_collection:

class: phpbb_di_service_collection

arguments:

- @dispatcher

- @controller.resolver

kernel_request_subscriber:

class: phpbb_event_kernel_request_subscriber

arguments:

- @user

- @style.resource_locator

- @template_context

template_context:

class: phpbb_template_context

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

<li><a href="#templates">General Templating</a></li>

<li><a href="#stylestree">Styles Tree</a></li>

</ol></li>

<li><a href="#charsets">Character Sets and Encodings</a></li>

<li><a href="#translation">Translation (<abbr title="Internationalisation">i18n</abbr>/<abbr title="Localisation">L10n</abbr>) Guidelines</a>

parent = prosilver

</pre></div>

</div>

<div class="back2top"><a href="#wrap" class="top">Back to Top</a></div>

sql_query_pre = UPDATE phpbb_sphinx SET max_doc_id = MAX(post_id) WHERE counter_id = 1

sql_query_range = SELECT MIN(post_id), MAX(post_id) FROM phpbb_posts

sql_range_step = 5000

AND p.post_id >= $start AND p.post_id <= $end

sql_query_post =

sql_query_post_index = UPDATE phpbb_sphinx SET max_doc_id = $maxid WHERE counter_id = 1

{

sql_query_range =

sql_range_step =

AND p.post_id >= ( SELECT max_doc_id FROM phpbb_sphinx WHERE counter_id=1 )

sql_query_pre =

}

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

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

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

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

$phpbb_class_loader_ext->register();

// Set up container

$phpbb_class_loader->set_cache($phpbb_container->get('cache.driver'));

$phpbb_class_loader_ext->set_cache($phpbb_container->get('cache.driver'));

($action != 'edit' || empty($forum_id) || ($auth->acl_get('a_fauth') && $auth->acl_get('a_authusers') && $auth->acl_get('a_authgroups') && $auth->acl_get('a_mauth'))))

{

copy_forum_permissions($forum_perm_from, $forum_data['forum_id'], ($action == 'edit') ? true : false);

$copied_permissions = true;

}

/* Commented out because of questionable UI workflow - re-visit for 3.0.7

add_log('admin', 'LOG_FORUM_' . strtoupper($action), $row['forum_name'], $move_forum_name);

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

}

if ($request->is_ajax())

{

$json_response = new phpbb_json_response;

if (!empty($forum_perm_from) && $forum_perm_from != $forum_id)

{

copy_forum_permissions($forum_perm_from, $forum_id, true);

$auth->acl_clear_prefetch();

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

function main($id, $mode)

{

global $phpbb_root_path, $phpbb_admin_path, $phpEx;

// Show restore permissions notice

set_config('record_online_users', 1, true);

set_config('record_online_date', time(), true);

add_log('admin', 'LOG_RESET_ONLINE');

if ($request->is_ajax())

{

trigger_error('RESET_ONLINE_SUCCESS');

update_last_username();

add_log('admin', 'LOG_RESYNC_STATS');

if ($request->is_ajax())

{

trigger_error('RESYNC_STATS_SUCCESS');

}

add_log('admin', 'LOG_RESYNC_POSTCOUNTS');

if ($request->is_ajax())

{

trigger_error('RESYNC_POSTCOUNTS_SUCCESS');

set_config('board_startdate', time() - 1);

add_log('admin', 'LOG_RESET_DATE');

if ($request->is_ajax())

{

trigger_error('RESET_DATE_SUCCESS');

}

add_log('admin', 'LOG_RESYNC_POST_MARKING');

if ($request->is_ajax())

{

trigger_error('RESYNC_POST_MARKING_SUCCESS');

// Clear permissions

$auth->acl_clear_prefetch();

add_log('admin', 'LOG_PURGE_CACHE');

if ($request->is_ajax())

{

trigger_error('PURGE_CACHE_SUCCESS');

$db->sql_query($sql);

add_log('admin', 'LOG_PURGE_SESSIONS');

if ($request->is_ajax())

{

trigger_error('PURGE_SESSIONS_SUCCESS');

*/

function remove_cache_file()

{

// Sanitise for future path use, it's escaped as appropriate for queries

$p_class = str_replace(array('.', '/', '\\'), '', basename($this->module_class));

// Additionally remove sql cache

}

/**

*/

function set_permissions($mode, $permission_type, &$auth_admin, &$user_id, &$group_id)

{

global $request;

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

// Do we need to recache the moderator lists?

if ($permission_type == 'm_')

{

}

// Remove users who are now moderators or admins from everyones foes list

if ($permission_type == 'm_' || $permission_type == 'a_')

{

}

$this->log_action($mode, 'add', $permission_type, $ug_type, $ug_id, $forum_id);

*/

function set_all_permissions($mode, $permission_type, &$auth_admin, &$user_id, &$group_id)

{

global $request;

// User or group to be set?

// Do we need to recache the moderator lists?

if ($permission_type == 'm_')

{

}

// Remove users who are now moderators or admins from everyones foes list

if ($permission_type == 'm_' || $permission_type == 'a_')

{

}

$this->log_action($mode, 'add', $permission_type, $ug_type, $ug_ids, $forum_ids);

*/

function remove_permissions($mode, $permission_type, &$auth_admin, &$user_id, &$group_id, &$forum_id)

{

// User or group to be set?

$ug_type = (sizeof($user_id)) ? 'user' : 'group';

// Do we need to recache the moderator lists?

if ($permission_type == 'm_')

{

}

$this->log_action($mode, 'del', $permission_type, $ug_type, (($ug_type == 'user') ? $user_id : $group_id), (sizeof($forum_id) ? $forum_id : array(0 => 0)));

if ($user_id != $user->data['user_id'])

{

}

else

{

*/

function copy_forum_permissions()

{

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

{

if (copy_forum_permissions($src, $dest))

{

$auth->acl_clear_prefetch();

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

'rank_min' => $min_posts,

'rank_image' => htmlspecialchars_decode($rank_image)

);

if ($rank_id)

{

$sql = 'UPDATE ' . RANKS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . " WHERE rank_id = $rank_id";

$cache->destroy('_ranks');

add_log('admin', 'LOG_RANK_REMOVED', $rank_title);

if ($request->is_ajax())

{

$json_response = new phpbb_json_response;

case 'add':

$data = $ranks = $existing_imgs = array();

$sql = 'SELECT *

FROM ' . RANKS_TABLE . '

ORDER BY rank_min ASC, rank_special ASC';

'RANK_TITLE' => (isset($ranks['rank_title'])) ? $ranks['rank_title'] : '',

'S_FILENAME_LIST' => $filename_list,

'S_SPECIAL_RANK' => (isset($ranks['rank_special']) && $ranks['rank_special']) ? true : false,

'MIN_POSTS' => (isset($ranks['rank_min']) && !$ranks['rank_special']) ? $ranks['rank_min'] : 0)

);

return;

break;

}

$template->assign_vars(array(

'U_ACTION' => $this->u_action)

);

'U_EDIT' => $this->u_action . '&amp;action=edit&amp;id=' . $row['rank_id'],

'U_DELETE' => $this->u_action . '&amp;action=delete&amp;id=' . $row['rank_id'])

}

$db->sql_freeresult($result);

*/

protected function action_cache()

{

$this->cache->purge();

// Clear permissions

$this->auth->acl_clear_prefetch();

add_log('admin', 'LOG_PURGE_CACHE');

{

return array(

'filename' => 'acp_extensions',

'version' => '1.0.0',

'modes' => array(

),

);

}

'title' => 'ACP_LANGUAGE',

'version' => '1.0.0',

'modes' => array(

),

);

}

}

/**

* Fill ACL array with relevant bitstrings from user_permissions column

* @access private

*/

/**

* Get forums with the specified permission setting

*

* @param bool $clean set to true if only values needs to be returned which are set/unset

*/

$style_resource_locator = new phpbb_style_resource_locator();

$style_path_provider = new phpbb_style_extension_path_provider($phpbb_extension_manager, new phpbb_style_path_provider());

$style = new phpbb_style($phpbb_root_path, $phpEx, $config, $user, $style_resource_locator, $style_path_provider, $template);

$style->set_style();

$template->set_filenames(array('bbcode.html' => 'bbcode.html'));

}

/**

*/

{

// Remove extra spaces and tabs

$query = preg_replace('/[\n\r\s\t]+/', ' ', $query);

* result to persistent storage. In other words, there is no need

* to call save() afterwards.

*

* @param string $query SQL query, should be used for generating storage key

* @param mixed $query_result The result from dbal::sql_query, to be passed to

* dbal::sql_fetchrow to get all rows and store them

* representing the query should be returned. Otherwise

* the original $query_result should be returned.

*/

/**

* Check if result for a given SQL query exists in cache.

}

/**

*/

{

// Remove extra spaces and tabs

$query = preg_replace('/[\n\r\s\t]+/', ' ', $query);

$hash = md5($query);

}

/**

*/

{

return $query_result;

}

*/

class phpbb_cache_service

{

/**

* Creates a cache service around a cache driver

*

* @param phpbb_cache_driver_interface $driver The cache driver

*/

{

$this->set_driver($driver);

}

/**

*/

function obtain_word_list()

{

if (($censors = $this->driver->get('_word_censors')) === false)

{

$sql = 'SELECT word, replacement

FROM ' . WORDS_TABLE;

$censors = array();

{

$censors['match'][] = get_censor_preg_expression($row['word']);

$censors['replace'][] = $row['replacement'];

}

$this->driver->put('_word_censors', $censors);

}

{

if (($icons = $this->driver->get('_icons')) === false)

{

// Topic icons

$sql = 'SELECT *

FROM ' . ICONS_TABLE . '

ORDER BY icons_order';

$icons = array();

{

$icons[$row['icons_id']]['img'] = $row['icons_url'];

$icons[$row['icons_id']]['width'] = (int) $row['icons_width'];

$icons[$row['icons_id']]['height'] = (int) $row['icons_height'];

$icons[$row['icons_id']]['display'] = (bool) $row['display_on_posting'];

}

$this->driver->put('_icons', $icons);

}

{

if (($ranks = $this->driver->get('_ranks')) === false)

{

$sql = 'SELECT *

FROM ' . RANKS_TABLE . '

ORDER BY rank_min DESC';

$ranks = array();

{

if ($row['rank_special'])

{

);

}

}

$this->driver->put('_ranks', $ranks);

}

{

if (($extensions = $this->driver->get('_extensions')) === false)

{

$extensions = array(

'_allowed_post' => array(),

'_allowed_pm' => array(),

FROM ' . EXTENSIONS_TABLE . ' e, ' . EXTENSION_GROUPS_TABLE . ' g

WHERE e.group_id = g.group_id

AND (g.allow_group = 1 OR g.allow_in_pm = 1)';

{

$extension = strtolower(trim($row['extension']));

$extensions['_allowed_pm'][$extension] = 0;

}

}

$this->driver->put('_extensions', $extensions);

}

{

if (($bots = $this->driver->get('_bots')) === false)

{

{

case 'mssql':

case 'mssql_odbc':

ORDER BY LENGTH(bot_agent) DESC';

break;

}

$bots = array();

{

$bots[] = $row;

}

$this->driver->put('_bots', $bots);

}

*/

function obtain_cfg_items($style)

{

$parsed_array = $this->driver->get('_cfg_' . $style['style_path']);

if ($parsed_array === false)

$parsed_array = array();

}

if (!file_exists($filename))

{

return $parsed_array;

}

{

// Re-parse cfg file

$parsed_array = parse_cfg_file($filename);

{

if (($usernames = $this->driver->get('_disallowed_usernames')) === false)

{

$sql = 'SELECT disallow_username

FROM ' . DISALLOW_TABLE;

$usernames = array();

{

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

}

$this->driver->put('_disallowed_usernames', $usernames);

}

return $usernames;

}

}

$new_line = '';

$end = strlen($scanline) - ceil($width/2);

{

$pixel = ord($scanline{$i});

/**

* Database connection

*/

protected $db;

/**

* Creates a configuration container with a default set of values

*

* @param phpbb_cache_driver_interface $cache Cache instance

* @param string $table Configuration table name

*/

{

$this->db = $db;

$this->cache = $cache;

* @param string $phpbb_root_path The root path

* @param string $php_ext The PHP extension

* @param phpbb_config $config The config

*/

{

$this->phpbb_root_path = $phpbb_root_path;

$this->php_ext = $php_ext;

* @param string $phpbb_root_path The root path

* @param string $php_ext The PHP extension

* @param phpbb_config $config The config

*/

{

$this->phpbb_root_path = $phpbb_root_path;

$this->php_ext = $php_ext;

* @param string $php_ext The PHP extension

* @param phpbb_auth $auth The auth

* @param phpbb_config $config The config

* @param phpbb_user $user The user

*/

{

$this->phpbb_root_path = $phpbb_root_path;

$this->php_ext = $php_ext;

/**

* Constructor. Set DB Object and set {@link $return_statements return_statements}.

*

* @param bool $return_statements True if only statements should be returned and no SQL being executed

*/

function phpbb_db_tools(&$db, $return_statements = false)

* Database Abstraction Layer

* @package dbal

*/

{

var $db_connect_id;

var $query_result;

/**

* Constructor

*/

{

$this->num_queries = array(

);

// Fill default sql layer based on the class being called.

// This can be changed by the specified layer itself later if needed.

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

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

$query_id = $this->query_result;

}

{

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

}

$this->sql_rowseek($rownum, $query_id);

}

{

return $cache->sql_fetchfield($query_id, $field);

}

*/

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

{

global $request;

if (is_object($request) && !$request->variable('explain', false))

<head>

<meta charset="utf-8">

<title>SQL Report</title>

</head>

<body id="errorpage">

<div id="wrap">

return $rows_total;

}

}

exit;

}

/**

* Firebird/Interbase Database Abstraction Layer

* Minimum Requirement is Firebird 2.1

* @package dbal

*/

{

var $last_query_text = '';

var $service_handle = false;

}

$this->last_query_text = $query;

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

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

}

}

{

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

}

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

{

$query_id = $this->query_result;

}

{

return $cache->sql_fetchrow($query_id);

}

$query_id = $this->query_result;

}

{

return $cache->sql_freeresult($query_id);

}

exit;

}

/**

* MSSQL Database Abstraction Layer

* Minimum Requirement is MSSQL 2000+

* @package dbal

*/

{

/**

* Connect to server

*/

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

{

$this->persistency = $persistency;

$this->user = $sqluser;

$this->dbname = $database;

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

}

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

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

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

}

{

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

}

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

{

$query_id = $this->query_result;

}

{

return $cache->sql_fetchrow($query_id);

}

$query_id = $this->query_result;

}

{

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

}

$query_id = $this->query_result;

}

{

return $cache->sql_freeresult($query_id);

}

*/

function _sql_error()

{

{

{

}

}

return $error;

exit;

}

/**

* Unified ODBC functions

* Unified ODBC functions support any database having ODBC driver, for example Adabas D, IBM DB2, iODBC, Solid, Sybase SQL Anywhere...

*

* @package dbal

*/

{

var $last_query_text = '';

/**

* Connect to server

@ini_set('odbc.defaultlrl', $max_size);

}

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

}

}

$this->last_query_text = $query;

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

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

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

}

{

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

}

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

{

$query_id = $this->query_result;

}

{

return $cache->sql_fetchrow($query_id);

}

$query_id = $this->query_result;

}

{

return $cache->sql_freeresult($query_id);

}

*/

function _sql_error()

{

}

/**

exit;

}

/**

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

* and maintain our own cursor index into that array.

/**

* @package dbal

*/

{

var $m_insert_id = NULL;

var $last_query_text = '';

var $query_options = array();

/**

* Connect to server

*/

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

{

if (!function_exists('sqlsrv_connect'))

{

}

//set up connection variables

}

$this->last_query_text = $query;

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

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

if ($cache_ttl)

{

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

}

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

{

*/

function _sql_error()

{

{

{

}

}

else

{

}

}

/**

exit;

}

/**

* MySQL4 Database Abstraction Layer

* Compatible with:

* MySQL 5.0+

* @package dbal

*/

{

var $multi_insert = true;

/**

* Connect to server

$this->sql_layer = 'mysql4';

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

{

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

}

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

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

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

}

{

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

}

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

{

$query_id = $this->query_result;

}

{

return $cache->sql_fetchrow($query_id);

}

$query_id = $this->query_result;

}

{

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

}

$query_id = $this->query_result;

}

{

return $cache->sql_freeresult($query_id);

}

*/

function _sql_error()

{

{

'message' => @mysql_error(),

);

}

}

/**

exit;

}

/**

* MySQLi Database Abstraction Layer

* mysqli-extension has to be compiled with:

* MySQL 4.1+ or MySQL 5.0+

* @package dbal

*/

{

var $multi_insert = true;

/**

* Connect to server

*/

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

{

// Mysqli extension supports persistent connection since PHP 5.3.0

$this->persistency = (version_compare(PHP_VERSION, '5.3.0', '>=')) ? $persistency : false;

$this->user = $sqluser;

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

}

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

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

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

}

{

}

}

else if (defined('DEBUG'))

$query_id = $this->query_result;

}

{

return $cache->sql_fetchrow($query_id);

}

$query_id = $this->query_result;

}

{

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

}

$query_id = $this->query_result;

}

{

return $cache->sql_freeresult($query_id);

}

*/

function _sql_error()

{

{

'message' => @mysqli_connect_error(),

);

}

}

/**

exit;

}

/**

* Oracle Database Abstraction Layer

* @package dbal

*/

{

var $last_query_text = '';

/**

* Connect to server

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

}

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

}

}

$this->last_query_text = $query;

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

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

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

}

{

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

}

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

{

$query_id = $this->query_result;

}

{

return $cache->sql_fetchrow($query_id);

}

$query_id = $this->query_result;

}

{

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

}

$query_id = $this->query_result;

}

{

return $cache->sql_freeresult($query_id);

}

*/

function _sql_error()

{

{

}

else

{

}

return $error;

exit;

}

/**

* PostgreSQL Database Abstraction Layer

* Minimum Requirement is Version 7.3+

* @package dbal

*/

{

var $last_query_text = '';

var $connect_error = '';

}

$this->last_query_text = $query;

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

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

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

}

{

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

}

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

{

$query_id = $this->query_result;

}

{

return $cache->sql_fetchrow($query_id);

}

$query_id = $this->query_result;

}

{

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

}

$query_id = $this->query_result;

}

{

return $cache->sql_freeresult($query_id);

}

exit;

}

/**

* Sqlite Database Abstraction Layer

* Minimum Requirement: 2.8.2+

* @package dbal

*/

{

/**

* Connect to server

*/

$this->dbname = $database;

$error = '';

if ($this->db_connect_id)

{

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

}

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

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

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

}

{

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

}

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

{

$query_id = $this->query_result;

}

{

return $cache->sql_fetchrow($query_id);

}

$query_id = $this->query_result;

}

{

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

}

$query_id = $this->query_result;

}

{

return $cache->sql_freeresult($query_id);

}

*/

function _sql_error()

{

}

/**

{

require($this->config_file);

$container->setParameter('core.table_prefix', $table_prefix);

$container->setParameter('dbal.dbhost', $dbhost);

$container->setParameter('dbal.dbuser', $dbuser);

$container->setParameter('dbal.dbpasswd', $dbpasswd);

}

/**

*

*/

{

if (preg_match('#^[a-z]+$#', $acm_type))

{

public function add($name)

{

$task = $this->container->get($name);

$this->offsetSet($name, $task);

}

}

*

* @param mixed $old_state The return value of the previous call

* of this method, or false on the first call

*/

public function disable_step($old_state);

/**

* Creates a manager and loads information from database

*

* @param phpbb_config $config phpbb_config

* @param string $extension_table The name of the table holding extensions

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

* @param phpbb_cache_driver_interface $cache A cache instance or null

* @param string $cache_name The name of the cache variable, defaults to _ext

*/

{

$this->phpbb_root_path = $phpbb_root_path;

$this->db = $db;

}

$iterator = new RecursiveIteratorIterator(

RecursiveIteratorIterator::SELF_FIRST);

foreach ($iterator as $file_info)

{

/**

* Creates the metadata manager

*

* @param string $extension_manager An instance of the phpbb extension manager

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

* @param string $phpEx php file extension

*/

{

$this->phpbb_root_path = $phpbb_root_path;

$this->db = $db;

}

/**

* Generate page header

*/

function page_header($page_title = '', $display_online_list = true, $item_id = 0, $item = 'forum')

{

global $db, $config, $template, $SID, $_SID, $_EXTRA_URL, $user, $auth, $phpEx, $phpbb_root_path;

if (defined('HEADER_INC'))

{

$timezone_name = $user->lang['timezones'][$timezone_name];

}

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

$template->assign_vars(array(

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

'RECORD_USERS' => $l_online_record,

'PRIVATE_MESSAGE_INFO' => $l_privmsgs_text,

'PRIVATE_MESSAGE_INFO_UNREAD' => $l_privmsgs_text_unread,

'S_USER_NEW_PRIVMSG' => $user->data['user_new_privmsg'],

'S_USER_UNREAD_PRIVMSG' => $user->data['user_unread_privmsg'],

function page_footer($run_cron = true, $display_template = true, $exit_handler = true)

{

global $db, $config, $template, $user, $auth, $cache, $starttime, $phpbb_root_path, $phpEx;

// A listener can set this variable to `true` when it overrides this function

$page_footer_override = false;

'TRANSLATION_INFO' => (!empty($user->lang['TRANSLATION_INFO'])) ? $user->lang['TRANSLATION_INFO'] : '',

'CREDIT_LINE' => $user->lang('POWERED_BY', '<a href="https://www.phpbb.com/">phpBB</a>&reg; Forum Software &copy; phpBB Group'),

);

// Call cron-type script

}

/**

* Create a Symfony Request object from phpbb_request object

*

* @param phpbb_request $request Request object

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

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

'S_USER_LANG' => $user->lang['USER_LANG'],

'S_CONTENT_DIRECTION' => $user->lang['DIRECTION'],

}

/**

*/

{

// Remove cached sql results

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

}

/**

* View log

* If $log_count is set to false, we will skip counting all entries in the database.

*/

}

/**

*/

{

// update foes for some user

if (is_array($user_id) && sizeof($user_id))

{

}

/**

* Lists inactive users

*/

function view_inactive_users(&$users, &$user_count, $limit = 0, $offset = 0, $limit_days = 0, $sort_by = 'user_inactive_time DESC')

return $container;

}

function phpbb_create_dumped_container(array $extensions, array $passes, $phpbb_root_path, $php_ext)

{

// Check for our cached container; if it exists, use it

return $container;

}

function phpbb_create_dumped_container_unless_debug(array $extensions, array $passes, $phpbb_root_path, $php_ext)

{

$container_factory = defined('DEBUG') ? 'phpbb_create_compiled_container' : 'phpbb_create_dumped_container';

return $container_factory($extensions, $passes, $phpbb_root_path, $php_ext);

}

function phpbb_container_filename($phpbb_root_path, $php_ext)

{

$filename = str_replace(array('/', '.'), array('slash', 'dot'), $phpbb_root_path);

{

markread('all', false, false, request_var('mark_time', 0));

trigger_error(

$user->lang['FORUMS_MARKED'] . '<br /><br />' .

sprintf($user->lang['RETURN_INDEX'], '<a href="' . $redirect . '">', '</a>')

$message = sprintf($user->lang['RETURN_FORUM'], '<a href="' . $redirect . '">', '</a>');

meta_refresh(3, $redirect);

trigger_error($user->lang['FORUMS_MARKED'] . '<br /><br />' . $message);

}

else

/**

* Increments the download count of all provided attachments

*

* @param array|int $ids The attach_id of each attachment

*

* @return null

/**

* Handles authentication when downloading attachments from a post or topic

*

* @param phpbb_auth $auth The authentication object

* @param int $topic_id The id of the topic that we are downloading from

*

/**

* Handles authentication when downloading attachments from PMs

*

* @param phpbb_auth $auth The authentication object

* @param int $user_id The user id

* @param int $msg_id The id of the PM that we are downloading from

/**

* Checks whether a user can download from a particular PM

*

* @param int $user_id The user id

* @param int $msg_id The id of the PM that we are downloading from

*

'SCHEMA' => 'firebird',

'MODULE' => 'interbase',

'DELIM' => ';;',

'AVAILABLE' => true,

'2.0.x' => false,

),

'mysqli' => array(

'LABEL' => 'MySQL with MySQLi Extension',

'SCHEMA' => 'mysql_41',

'MODULE' => 'mysqli',

'DELIM' => ';',

'AVAILABLE' => true,

'2.0.x' => true,

),

'SCHEMA' => 'mysql',

'MODULE' => 'mysql',

'DELIM' => ';',

'AVAILABLE' => true,

'2.0.x' => true,

),

'SCHEMA' => 'mssql',

'MODULE' => 'mssql',

'DELIM' => 'GO',

'AVAILABLE' => true,

'2.0.x' => true,

),

'SCHEMA' => 'mssql',

'MODULE' => 'odbc',

'DELIM' => 'GO',

'AVAILABLE' => true,

'2.0.x' => true,

),

'SCHEMA' => 'mssql',

'MODULE' => 'sqlsrv',

'DELIM' => 'GO',

'AVAILABLE' => true,

'2.0.x' => false,

),

'SCHEMA' => 'oracle',

'MODULE' => 'oci8',

'DELIM' => '/',

'AVAILABLE' => true,

'2.0.x' => false,

),

'SCHEMA' => 'postgres',

'MODULE' => 'pgsql',

'DELIM' => ';',

'AVAILABLE' => true,

'2.0.x' => true,

),

'SCHEMA' => 'sqlite',

'MODULE' => 'sqlite',

'DELIM' => ';',

'AVAILABLE' => true,

'2.0.x' => false,

),

$dbms = $dbms_details['DRIVER'];

// Instantiate it and set return on error true

$db->sql_return_on_error(true);

// Check that we actually have a database name before going any further.....

{

$error[] = $lang['INST_ERR_DB_NO_NAME'];

return false;

}

// Make sure we don't have a daft user who thinks having the SQLite database in the forum directory is a good idea

{

$error[] = $lang['INST_ERR_DB_FORUM_PATH'];

return false;

// Check the prefix length to ensure that index names are not too long and does not contain invalid characters

switch ($dbms_details['DRIVER'])

{

if (strspn($table_prefix, '-./\\') !== 0)

{

$error[] = $lang['INST_ERR_PREFIX_INVALID'];

// no break;

$prefix_length = 36;

break;

$prefix_length = 90;

break;

$prefix_length = 200;

break;

$prefix_length = 6;

break;

}

// Make sure that the user has selected a sensible DBAL for the DBMS actually installed

switch ($dbms_details['DRIVER'])

{

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

{

$error[] = $lang['INST_ERR_DB_NO_MYSQLI'];

}

break;

if (version_compare(sqlite_libversion(), '2.8.2', '<'))

{

$error[] = $lang['INST_ERR_DB_NO_SQLITE'];

}

break;

// check the version of FB, use some hackery if we can't get access to the server info

if ($db->service_handle !== false && function_exists('ibase_server_info'))

{

}

break;

if ($unicode_check)

{

$sql = "SELECT *

}

break;

if ($unicode_check)

{

$sql = "SHOW server_encoding;";

'dbuser' => $data['dbuser'],

'dbpasswd' => htmlspecialchars_decode($data['dbpasswd']),

'table_prefix' => $data['table_prefix'],

'acm_type' => 'phpbb_cache_driver_file',

);

{

$style_resource_locator = new phpbb_style_resource_locator();

$style_path_provider = new phpbb_style_extension_path_provider($phpbb_extension_manager, new phpbb_style_path_provider());

$style = new phpbb_style($phpbb_root_path, $phpEx, $config, $user, $style_resource_locator, $style_path_provider, $tpl);

$this->tpl_msg[$template_lang . $template_file] = $tpl;

}

}

$tpl->set_filenames(array(

'body' => $template_file . '.txt',

// The variable name should be $post_approved, because it indicates if the post is approved or not

$post_approval = 1;

{

// Post not approved, but in queue

$post_approval = 0;

$this->mimetype = 'application/octetstream';

}

// Try to get real filesize from temporary folder (not always working) ;)

$this->filesize = (@filesize($this->filename)) ? @filesize($this->filename) : $this->filesize;

/**

* Get file extension

*/

{

if (strpos($filename, '.') === false)

{

}

// Check image type

if (!isset($types[$this->image_info[2]]) || !in_array($this->extension, $types[$this->image_info[2]]))

{

}

/**

*/

{

return array(

IMAGETYPE_GIF => array('gif'),

*/

function group_delete($group_id, $group_name = false)

{

if (!$group_name)

{

extract($phpbb_dispatcher->trigger_event('core.delete_group_after', compact($vars)));

// Re-cache moderators

{

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

}

add_log('admin', 'LOG_GROUP_DELETE', $group_name);

*/

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

{

if (empty($user_id_ary))

{

}

// Because some tables/caches use usercolour-specific data we need to purge this here.

}

/**

*/

function group_update_listings($group_id)

{

$hold_ary = $auth->acl_group_raw_data($group_id, array('a_', 'm_'));

if ($mod_permissions)

{

{

global $phpbb_root_path, $phpEx;

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

}

}

if ($mod_permissions || $admin_permissions)

{

{

global $phpbb_root_path, $phpEx;

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

}

}

}

/**

* A database connection

*/

private $db;

*

* @param string $config_name A config variable to be used for locking

* @param array $config The phpBB configuration

*/

{

$this->config_name = $config_name;

$this->config = $config;

// Message and return links

$success_msg = 'POSTS_MERGED_SUCCESS';

// Link to the new topic

$return_link .= (($return_link) ? '<br /><br />' : '') . sprintf($user->lang['RETURN_NEW_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $to_forum_id . '&amp;t=' . $to_topic_id) . '">', '</a>');

}

}

$sql = 'SELECT user_id, notify_status

FROM ' . TOPICS_WATCH_TABLE . '

WHERE topic_id = ' . $topic_id;

{

$db->sql_multi_insert(TOPICS_WATCH_TABLE, $sql_ary);

}

}

// Sync new topics, parent forums and board stats

$message = bbcode_nl2br($message);

$message = smiley_text($message);

if ($pm_info['message_attachment'] && $auth->acl_get('u_pm_download'))

{

WHERE post_id = {$post_id_list[0]}";

$db->sql_query($sql);

$success_msg = 'TOPIC_SPLIT_SUCCESS';

// Update forum statistics

}

else

{

// If the topic no longer exist, we will update the topic watch table.

}

// Link to the new topic

{

global $config, $user;

$in = str_replace("\r\n", "\n", str_replace('\"', '"', trim($in)));

if (!$in)

include("{$phpbb_root_path}config.$phpEx");

unset($dbhost, $dbport, $dbname, $dbuser, $dbpasswd); // Just a precaution

// Only send certain config vars

$config_vars = array(

'active_sessions' => true,

protected $config;

/**

*/

protected $db;

protected $config;

/**

*/

protected $db;

protected $config;

/**

*/

protected $db;

$tmp_sql_match[] = "to_tsvector ('" . $this->db->sql_escape($this->config['fulltext_postgres_ts_name']) . "', " . $sql_match_column . ") @@ to_tsquery ('" . $this->db->sql_escape($this->config['fulltext_postgres_ts_name']) . "', '" . $this->db->sql_escape($this->tsearch_query) . "')";

}

$sql = "SELECT $sql_select

ORDER BY $sql_sort";

$result = $this->db->sql_query_limit($sql, $this->config['search_block_size'], $start);

// if the total result count is not cached yet, retrieve it from the db

if (!$result_count)

{

if (!$result_count)

{

}

}

// store the ids, from start on then delete anything that isn't on the current page because we only need ids for one page

$this->save_ids($search_key, implode(' ', $this->split_words), $author_ary, $result_count, $id_ary, $start, $sort_dir);

$id_ary = array_slice($id_ary, 0, (int) $per_page);

$field = 'topic_id';

}

// Only read one block of posts from the db and then cache it

$result = $this->db->sql_query_limit($sql, $this->config['search_block_size'], $start);

// retrieve the total result count if needed

if (!$result_count)

{

if (!$result_count)

{

}

}

if (sizeof($id_ary))

{

$this->save_ids($search_key, '', $author_ary, $result_count, $id_ary, $start, $sort_dir);

protected $config;

/**

*/

protected $db;

</dl>

<dl>

<dt><label for="fulltext_sphinx_indexer_mem_limit">' . $this->user->lang['FULLTEXT_SPHINX_INDEXER_MEM_LIMIT'] . $this->user->lang['COLON'] . '</label><br /><span>' . $this->user->lang['FULLTEXT_SPHINX_INDEXER_MEM_LIMIT_EXPLAIN'] . '</span></dt>

</dl>

<dl>

<dt><label for="fulltext_sphinx_config_file">' . $this->user->lang['FULLTEXT_SPHINX_CONFIG_FILE'] . $this->user->lang['COLON'] . '</label><br /><span>' . $this->user->lang['FULLTEXT_SPHINX_CONFIG_FILE_EXPLAIN'] . '</dt>