env: DB=mariadb

- php: 5.4

env: DB=postgres

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

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

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

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

<exec dir="${dir}" command="find . -type f|xargs chmod 644" escape="false" />

<chmod mode="0777" file="${dir}/images/avatars/upload" />

</target>

<target name="clean-diff-dir">

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

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

</rule>

<rule ref="Squiz.Functions.FunctionDeclarationArgumentSpacing.SpacingAfterHint" />

<!-- The ?> closing tag MUST be omitted from files containing only PHP. -->

<rule ref="Zend.Files.ClosingTag" />

<!-- PHP keywords MUST be in lower case. -->

<rule ref="Generic.PHP.LowerCaseKeyword" />

<!-- Classes etc. MUST be namespaced -->

<rule ref="PSR1.Classes.ClassDeclaration.MissingNamespace" />

<fieldset class="tabulated">

<legend>{L_TITLE}</legend>

<!-- IF .pagination or TOTAL_FILES -->

{L_NUMBER_FILES}{L_COLON} {TOTAL_FILES} &bull; {L_TOTAL_SIZE}{L_COLON} {TOTAL_SIZE}

<!-- IF .pagination -->

<!-- ENDIF -->

</div>

<table class="table1 zebra-table">

<thead>

<tr>

<th>{L_FILENAME}</th>

<th>{L_POSTED}</th>

</tr>

</thead>

<tbody>

<!-- ELSE --><a href="{attachments.U_FILE}" style="font-weight: bold;">{attachments.REAL_FILENAME}</a><br /><!-- IF attachments.COMMENT -->{attachments.COMMENT}<br /><!-- ENDIF -->{attachments.L_DOWNLOAD_COUNT}<br />{L_TOPIC}{L_COLON} <a href="{attachments.U_VIEW_TOPIC}">{attachments.TOPIC_TITLE}</a><!-- ENDIF -->

</td>

<td>{attachments.FILETIME}<br />{L_POST_BY_AUTHOR} {attachments.ATTACHMENT_POSTER}</td>

</tr>

<!-- END attachments -->

</tbody>

</table>

<!-- IF TOTAL_FILES -->

<div class="pagination">

{L_NUMBER_FILES}{L_COLON} {TOTAL_FILES} &bull; {L_TOTAL_SIZE}{L_COLON} {TOTAL_SIZE}

<!-- IF .pagination -->

</div>

<!-- ENDIF -->

{S_FORM_TOKEN}

</fieldset>

</form>

</fieldset>

<!-- IF .pagination -->

<!-- INCLUDE pagination.html -->

</div>

<!-- ENDIF -->

height: 1px;

}

.small {

font-size: 0.85em;

}

}

optgroup, select {

font-family: Verdana, Helvetica, Arial, sans-serif;

font-size: 0.85em;

font-weight: normal;

font-style: normal;

cursor: pointer;

vertical-align: middle;

width: auto;

color: #000;

border: none;

background-color: transparent;

text-align: center;

}

fieldset.display-options select, fieldset.display-options input, fieldset.display-options label {

/* Pagination

---------------------------------------- */

.pagination {

height: 1%; /* IE tweak (holly hack) */

width: auto;

text-align: right;

margin-top: 5px;

float: right;

}

.rtl .pagination {

if (!loadingIndicator.is(':visible')) {

loadingIndicator.fadeIn(phpbb.alertTime);

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

phpbbAlertTimer = setTimeout(function() {

if (loadingIndicator.is(':visible')) {

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

refresh = false;

}

if (refresh) {

window.location = res.REFRESH_DATA.url;

}

* please use the core.user_setup event instead!

*

* @event core.common

*/

$phpbb_dispatcher->dispatch('core.common');

{

"require": {

"lusitanian/oauth": "0.2.*",

"symfony/config": "2.3.*",

"This file locks the dependencies of your project to a known state",

"Read more about it at http://getcomposer.org/doc/01-basic-usage.md#composer-lock-the-lock-file"

],

"packages": [

{

"name": "lusitanian/oauth",

},

{

"name": "symfony/config",

"target-dir": "Symfony/Component/Config",

"source": {

"type": "git",

"url": "https://github.com/symfony/Config.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"Symfony\\Component\\Config\\": ""

}

},

"license": [

"MIT"

],

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

],

"description": "Symfony Config Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/console",

"target-dir": "Symfony/Component/Console",

"source": {

"type": "git",

"url": "https://github.com/symfony/Console.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

],

"description": "Symfony Console Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/debug",

"Symfony\\Component\\Debug\\": ""

}

},

"license": [

"MIT"

],

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

},

{

"name": "symfony/dependency-injection",

"target-dir": "Symfony/Component/DependencyInjection",

"source": {

"type": "git",

"url": "https://github.com/symfony/DependencyInjection.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"Symfony\\Component\\DependencyInjection\\": ""

}

},

"license": [

"MIT"

],

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

],

"description": "Symfony DependencyInjection Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/event-dispatcher",

"target-dir": "Symfony/Component/EventDispatcher",

"source": {

"type": "git",

"url": "https://github.com/symfony/EventDispatcher.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

],

"description": "Symfony EventDispatcher Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/filesystem",

"Symfony\\Component\\Filesystem\\": ""

}

},

"license": [

"MIT"

],

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

"Symfony/Component/HttpFoundation/Resources/stubs"

]

},

"license": [

"MIT"

],

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

},

{

"name": "symfony/http-kernel",

"target-dir": "Symfony/Component/HttpKernel",

"source": {

"type": "git",

"url": "https://github.com/symfony/HttpKernel.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"Symfony\\Component\\HttpKernel\\": ""

}

},

"license": [

"MIT"

],

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

],

"description": "Symfony HttpKernel Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/routing",

"target-dir": "Symfony/Component/Routing",

"source": {

"type": "git",

"url": "https://github.com/symfony/Routing.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"Symfony\\Component\\Routing\\": ""

}

},

"license": [

"MIT"

],

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

],

"description": "Symfony Routing Component",

"homepage": "http://symfony.com",

},

{

"name": "symfony/yaml",

"target-dir": "Symfony/Component/Yaml",

"source": {

"type": "git",

"url": "https://github.com/symfony/Yaml.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

],

"description": "Symfony Yaml Component",

"homepage": "http://symfony.com",

},

{

"name": "twig/twig",

"authors": [

{

"name": "Fabien Potencier",

}

],

"description": "A simple PHP Web Scraper",

},

{

"name": "squizlabs/php_codesniffer",

"source": {

"type": "git",

"url": "https://github.com/squizlabs/PHP_CodeSniffer.git",

},

"dist": {

"type": "zip",

"shasum": ""

},

"require": {

"phpcs",

"standards"

],

},

{

"name": "symfony/browser-kit",

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

"authors": [

{

"name": "Fabien Potencier",

},

{

"name": "Symfony Community",

"aliases": [

],

"stability-flags": [

],

function usage()

{

echo "\n";

echo "\n";

echo "\n";

exit(2);

}

{

{

}

}

{

}

{

}

{

}

default:

usage();

acp_simple_header_head_append

===

* Since: 3.1.0-a1

* Purpose: Add assets within the `<head>` tags in the simple header of the ACP

acp_users_overview_options_append

===

* Since: 3.1.0-a1

* Purpose: Add options and settings on user overview page

* Purpose: Add content before BBCode posting buttons in the ACP user signature

forumlist_body_category_header_after

* Locations:

+ styles/prosilver/template/forumlist_body.html

+ styles/subsilver2/template/forumlist_body.html

* Purpose: Add content after the header of the category on the forum list.

forumlist_body_category_header_before

* Locations:

+ styles/prosilver/template/forumlist_body.html

+ styles/subsilver2/template/forumlist_body.html

* Purpose: Add content before the header of the category on the forum list.

forumlist_body_last_post_title_prepend

* Locations:

+ styles/prosilver/template/forumlist_body.html

+ styles/subsilver2/template/forumlist_body.html

* Purpose: Add content before the post title of the latest post in a forum on the forum list.

forumlist_body_subforums_after

* Locations:

+ styles/prosilver/template/forumlist_body.html

+ styles/subsilver2/template/forumlist_body.html

* Purpose: Add content after the list of subforums (if any) for each forum on the forum list.

forumlist_body_subforums_before

* Locations:

+ styles/prosilver/template/forumlist_body.html

+ styles/subsilver2/template/forumlist_body.html

* Purpose: Add content before the list of subforums (if any) for each forum on the forum list.

forumlist_body_last_row_after

* Locations:

+ styles/prosilver/template/forumlist_body.html

+ styles/subsilver2/template/forumlist_body.html

* Since: 3.1.0-b3

* Purpose: Add content after the page-body, but before the footer

overall_header_body_before

===

* Locations:

===

* Locations:

+ styles/prosilver/template/simple_footer.html

* Since: 3.1.0-a1

* Purpose: Add content directly prior to the `</body>` tag of the simple footer

* Since: 3.1.0-a1

* Purpose: Add content into topic rows (inside the elements containing topic titles)

ucp_pm_viewmessage_custom_fields_after

===

* Locations:

ucp_friend_list_before

===

* Locations:

* Since: 3.1.0-a4

* Purpose: Add optional elements before list of friends in UCP

ucp_friend_list_after

===

* Locations:

* Since: 3.1.0-a4

* Purpose: Add optional elements after list of friends in UCP

}

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

// Initial var setup

$forum_id = request_var('f', 0);

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

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

'legend2' => $l_legend_cat_images,

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

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

if ($stats_error)

{

$error[] = $stats_error;

}

$template->assign_vars(array(

/**

* Set config attachment stat values

*

* @return null

*/

public function set_attachment_stats($stats)

/**

* Check accuracy of attachment statistics.

*

* @return bool|string Returns false if stats are correct or error message

* otherwise.

*/

// Get current files stats

$num_files = (int) $this->config['num_files'];

if (($num_files != $stats['num_files']) || ($total_size != $stats['upload_dir_size']))

{

}

return false;

}

'L_NO_BAN_CELL' => $l_no_ban_cell,

'S_USERNAME_BAN' => ($mode == 'user') ? true : false,

'U_ACTION' => $this->u_action,

'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&amp;form=acp_ban&amp;field=ban'),

));

case 'create':

$sql_ary = $hidden_fields = array();

/**

* Modify custom bbcode data before the modify/create action

*

* submitting form when $warn_text is true

* @since 3.1.0-a3

*/

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

$warn_text = preg_match('%<[^>]*\{text[\d]*\}[^>]*>%i', $bbcode_tpl);

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

}

if (strlen($bbcode_helpline) > 255)

{

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

$db->sql_query('DELETE FROM ' . BBCODES_TABLE . " WHERE bbcode_id = $bbcode_id");

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

add_log('admin', 'LOG_BBCODE_DELETE', $row['bbcode_tag']);

if ($request->is_ajax())

{

$json_response = new \phpbb\json_response;

'email_function_name' => array('lang' => 'EMAIL_FUNCTION_NAME', 'validate' => 'string', 'type' => 'text:20:50', 'explain' => true),

'email_package_size' => array('lang' => 'EMAIL_PACKAGE_SIZE', 'validate' => 'int:0', 'type' => 'number:0:99999', 'explain' => true),

'board_contact' => array('lang' => 'CONTACT_EMAIL', 'validate' => 'email', 'type' => 'email:25:100', 'explain' => true),

'board_email' => array('lang' => 'ADMIN_EMAIL', 'validate' => 'email', 'type' => 'email:25:100', 'explain' => true),

'board_email_sig' => array('lang' => 'EMAIL_SIG', 'validate' => 'string', 'type' => 'textarea:5:30', 'explain' => true),

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

{

$error[] = $user->lang['ERR_BOT_NO_MATCHES'];

}

if ($bot_row['bot_ip'] && !preg_match('#^[\d\.,:]+$#', $bot_row['bot_ip']))

{

if (!$ip_list = gethostbynamel($bot_row['bot_ip']))

{

$error[] = $user->lang['ERR_BOT_AGENT_MATCHES_UA'];

}

$bot_name = false;

if ($bot_id)

{

{

$error[] = $user->lang['BOT_NAME_TAKEN'];

}

if (!sizeof($error))

{

// New bot? Create a new user and group entry

{

trigger_error($user->lang['NO_BOT_GROUP'] . adm_back_link($this->u_action . "&amp;id=$bot_id&amp;action=$action"), E_USER_WARNING);

}

$user_id = user_add(array(

'user_type' => (int) USER_IGNORE,

'user_style' => (int) $bot_row['bot_style'],

'user_allow_massemail' => 0,

));

$sql = 'INSERT INTO ' . BOTS_TABLE . ' ' . $db->sql_build_array('INSERT', array(

'user_id' => (int) $user_id,

'bot_name' => (string) $bot_row['bot_name'],

'bot_ip' => (string) $bot_row['bot_ip'])

);

$db->sql_query($sql);

$log = 'ADDED';

}

else if ($bot_id)

$log = 'UPDATED';

}

$cache->destroy('_bots');

add_log('admin', 'LOG_BOT_' . $log, $bot_row['bot_name']);

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

}

}

else if ($bot_id)

'U_ACTION' => $this->u_action . "&amp;id=$bot_id&amp;action=$action",

'U_BACK' => $this->u_action,

'ERROR_MSG' => (sizeof($error)) ? implode('<br />', $error) : '',

'BOT_NAME' => $bot_row['bot_name'],

'BOT_IP' => $bot_row['bot_ip'],

'BOT_AGENT' => $bot_row['bot_agent'],

'S_EDIT_BOT' => true,

'S_ACTIVE_OPTIONS' => $s_active_options,

'S_STYLE_OPTIONS' => $style_select,

break;

}

if ($request->is_ajax() && ($action == 'activate' || $action == 'deactivate'))

{

$json_response = new \phpbb\json_response;

}

$db->sql_freeresult($result);

}

/**

* Validate bot name against username table

*/

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

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

$db->sql_freeresult($result);

return ($row) ? false : true;

}

}

$selected = (isset($captchas['available'][$selected]) || isset($captchas['unavailable'][$selected])) ? $selected : $config['captcha_plugin'];

$configure = request_var('configure', false);

// Oh, they are just here for the view

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

{

}

$db->sql_freeresult($result);

// Get the listing of primary keys.

$sql_pri_keys = "SELECT ic.relname as index_name, bc.relname as tab_name, ta.attname as column_name, i.indisunique as unique_key, i.indisprimary as primary_key

FROM pg_class bc, pg_class ic, pg_index i, pg_attribute ta, pg_attribute ia

$ary_type[] = pg_field_type($result, $i);

$ary_name[] = pg_field_name($result, $i);

$sql = "SELECT pg_get_expr(d.adbin, d.adrelid) as rowdefault

FROM pg_attrdef d, pg_class c

WHERE (c.relname = '{$table_name}')

public function list_enabled_exts(\phpbb\extension\manager $phpbb_extension_manager)

{

$enabled_extension_meta_data = array();

foreach ($phpbb_extension_manager->all_enabled() as $name => $location)

{

$md_manager = $phpbb_extension_manager->create_extension_metadata_manager($name, $this->template);

public function list_disabled_exts(\phpbb\extension\manager $phpbb_extension_manager)

{

$disabled_extension_meta_data = array();

foreach ($phpbb_extension_manager->all_disabled() as $name => $location)

{

$md_manager = $phpbb_extension_manager->create_extension_metadata_manager($name, $this->template);

$uninstalled = array_diff_key($phpbb_extension_manager->all_available(), $phpbb_extension_manager->all_configured());

$available_extension_meta_data = array();

foreach ($uninstalled as $name => $location)

{

$md_manager = $phpbb_extension_manager->create_extension_metadata_manager($name, $this->template);

* @event core.acp_manage_forums_request_data

* @var string action Type of the action: add|edit

* @var array forum_data Array with new forum data

*/

$vars = array('action', 'forum_data');

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

* empty when creating new forum

* @var array forum_data Array with new forum data

* @var string parents_list List of parent options

*/

$vars = array('action', 'update', 'forum_id', 'row', 'forum_data', 'parents_list');

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

* ensure to update the template variables

* S_ERROR and ERROR_MSG to display it

* @var array template_data Array with new forum data

*/

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

$template->assign_vars($template_data);

* @var array forum_data Array with new forum data

* @var array errors Array of errors, should be strings and not

* language key.

*/

$vars = array('forum_data', 'errors');

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

* @var array forum_data_sql Array with data we are going to update

* If forum_data_sql[forum_id] is set, we update

* that forum, otherwise a new one is created.

*/

$vars = array('forum_data', 'forum_data_sql');

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

* ensure to set forum_data_sql[forum_id]

* @var array errors Array of errors, should be strings and not

* language key.

*/

$vars = array('forum_data', 'forum_data_sql', 'is_new_forum', 'errors');

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

* @var int to_id If of the new parent forum

* @var array errors Array of errors, should be strings and not

* language key.

*/

$vars = array('from_id', 'to_id', 'errors');

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

* @var array errors Array of errors, should be strings and not

* language key. If this array is not empty,

* The content will not be moved.

*/

$vars = array('from_id', 'to_id', 'sync', 'errors');

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

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

$update = (isset($_POST['update'])) ? true : false;

// Clear some vars

$group_row = array();

if (confirm_box(true))

{

$group_name = ($group_row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $group_row['group_name']] : $group_row['group_name'];

trigger_error($user->lang['GROUP_DEFS_UPDATED'] . adm_back_link($this->u_action . '&amp;action=list&amp;g=' . $group_id));

}

else

}

}

// Did we submit?

if ($update)

{

unset($_images[$row[$fields . '_url']]);

}

if ($row[$fields . '_id'] == $icon_id)

{

$after = true;

$cache->destroy('_icons');

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

if ($request->is_ajax())

{

$json_response = new \phpbb\json_response;

if ($mode == 'mod')

{

$forum_box = '<option value="0">' . $user->lang['ALL_FORUMS'] . '</option>' . make_forum_select($forum_id);

$template->assign_vars(array(

'S_SHOW_FORUMS' => true,

'S_FORUM_BOX' => $forum_box)

foreach ($log_data as $row)

{

$data = array();

$checks = array('viewtopic', 'viewlogs', 'viewforum');

foreach ($checks as $check)

{

case 'edit':

if ($action == 'edit')

$sql = 'SELECT *

FROM ' . ACL_ROLES_TABLE . '

WHERE role_id = ' . $role_id;

}

}

// Setting permissions screen

$s_hidden_fields = build_hidden_fields(array(

'user_id' => $user_id,

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

}

function remove_spaces($matches)

{

return '<a name="' . str_replace(' ', '_', $matches[1]) . '">';

}

$db->sql_freeresult($result);

$sql = 'SELECT lang_id, lang_name, lang_explain, lang_default_value

FROM ' . PROFILE_LANG_TABLE . '

WHERE lang_id <> ' . $this->edit_lang_id . "

}

}

$db->sql_transaction('begin');

if ($action == 'create')

$prune_posted = request_var('prune_days', 0);

$prune_viewed = request_var('prune_vieweddays', 0);

$prune_all = (!$prune_posted && !$prune_viewed) ? true : false;

$prune_flags = 0;

$prune_flags += (request_var('prune_old_polls', 0)) ? 2 : 0;

$prune_flags += (request_var('prune_announce', 0)) ? 4 : 0;

$p_result['topics'] = 0;

$p_result['posts'] = 0;

$log_data = '';

do

{

if (!$auth->acl_get('f_list', $row['forum_id']))

$p_result['topics'] += $return['topics'];

$p_result['posts'] += $return['posts'];

}

if ($prune_viewed)

{

$return = prune($row['forum_id'], 'viewed', $prunedate_viewed, $prune_flags, false);

'NUM_TOPICS' => $p_result['topics'],

'NUM_POSTS' => $p_result['posts'])

);

$log_data .= (($log_data != '') ? ', ' : '') . $row['forum_name'];

}

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

// Sync all pruned forums at once

sync('forum', 'forum_id', $prune_ids, true, true);

add_log('admin', 'LOG_PRUNE', $log_data);

if ($deleteposts)

{

user_delete('remove', $user_ids);

$l_log = 'LOG_PRUNE_USER_DEL_DEL';

}

else

if (sizeof($active) && (int) $active[0] == 0 && (int) $active[1] == 0 && (int) $active[2] == 0)

{

$where_sql .= ' AND user_lastvisit = 0';

else if (sizeof($active) && $active_select != 'lt')

{

$where_sql .= ' AND user_lastvisit ' . $key_match[$active_select] . ' ' . gmmktime(0, 0, 0, (int) $active[1], (int) $active[2], (int) $active[0]);

WHERE u.user_id <> ' . ANONYMOUS . '

AND u.user_type <> ' . USER_FOUNDER .

((!empty($user_ids)) ? 'AND ' . $db->sql_in_set('p.poster_id', $user_ids) : '') . '

AND u.user_id = p.poster_id

GROUP BY p.poster_id

HAVING queue_posts ' . $key_match[$queue_select] . ' ' . $posts_on_queue;

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

);

return;

break;

{

if ($topic_id_ary[$row['topic_id']][ITEM_APPROVED] == $row['topic_posts_approved']

&& $topic_id_ary[$row['topic_id']][ITEM_UNAPPROVED] == $row['topic_posts_unapproved']

&& $topic_id_ary[$row['topic_id']][ITEM_DELETED] == $row['topic_posts_softdeleted'])

{

$move_topic_ary[] = $row['topic_id'];

sync('forum', 'forum_id', $forum_id_ary, false, true);

}

add_log('admin', 'LOG_USER_MOVE_POSTS', $user_row['username'], $forum_info['forum_name']);

add_log('user', $user_id, 'LOG_USER_MOVE_POSTS_USER', $forum_info['forum_name']);

* @event core.acp_users_overview_run_quicktool

* @var array user_row Current user data

* @var string action Quick tool that should be run

*/

$vars = array('action', 'user_row');

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

* @var array user_row Current user data

* @var array data Submitted user data

* @var array sql_ary User data we udpate

*/

$vars = array('user_row', 'data', 'sql_ary');

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

* @event core.acp_users_display_overview

* @var array user_row Array with user data

* @var array quick_tool_ary Ouick tool options

*/

$vars = array('user_row', 'quick_tool_ary');

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

$sql = 'SELECT COUNT(post_id) as posts_in_queue

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $user_id . '

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

$user_row['posts_in_queue'] = (int) $db->sql_fetchfield('posts_in_queue');

$db->sql_freeresult($result);

}

}

$template->assign_block_vars('warn', array(

'ID' => $row['warning_id'],

'USERNAME' => ($row['log_operation']) ? get_username_string('full', $row['mod_user_id'], $row['mod_username'], $row['mod_user_colour']) : '-',

$data['bday_year'] = request_var('bday_year', $data['bday_year']);

$data['user_birthday'] = sprintf('%2d-%2d-%4d', $data['bday_day'], $data['bday_month'], $data['bday_year']);

if ($submit)

{

$error = validate_data($data, array(

'notify' => request_var('notify', $user_row['user_notify']),

);

if ($submit)

{

$error = validate_data($data, array(

'user_notify' => $data['notify'],

);

{

{

}

}

// Replace "error" strings with their real, localised form

}

$timezone_selects = phpbb_timezone_select($user, $data['tz'], true);

'S_PREFS' => true,

'S_JABBER_DISABLED' => ($config['jab_enable'] && $user_row['user_jabber'] && @extension_loaded('xml')) ? false : true,

'S_STYLE_OPTIONS' => style_select($data['style']),

'S_TZ_OPTIONS' => $timezone_selects['tz_select'],

'S_TZ_DATE_OPTIONS' => $timezone_selects['tz_dates'],

);

break;

case 'avatar':

$error = array();

}

$sql = 'SELECT ug.*, g.*

FROM ' . GROUPS_TABLE . ' g, ' . USER_GROUP_TABLE . " ug

WHERE ug.user_id = $user_id

'word' => $word,

'replacement' => $replacement

);

if ($word_id)

{

$db->sql_query('UPDATE ' . WORDS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . ' WHERE word_id = ' . $word_id);

break;

}

$template->assign_vars(array(

'U_ACTION' => $this->u_action,

'S_HIDDEN_FIELDS' => $s_hidden_fields)

$auth2 = &$auth;

}

$hold_ary[$userdata['user_id']] = array();

foreach ($forum_ids as $f_id)

{

function execute($code, $seed)

{

global $config;

mt_srand($seed);

// Create image

function wave($img)

{

global $config;

$period_x = mt_rand(12,18);

$period_y = mt_rand(7,14);

$amp_x = mt_rand(5,10);

$socket = mt_rand(0,100);

$dampen_x = mt_rand($this->width/5, $this->width/2);

$dampen_y = mt_rand($this->height/5, $this->height/2);

$direction_x = (mt_rand (0, 1));

}

return $img;

}

/**

* Noise line

*/

}

function captcha_noise_bg_bitmaps()

return array(

'width' => 15,

'height' => 5,

function captcha_bitmaps()

{

global $config;

$chars = array(

'A' => array(

array(

'J' => $chars['J'][mt_rand(0, min(sizeof($chars['J']), $config['captcha_gd_fonts']) -1)],

'K' => $chars['K'][mt_rand(0, min(sizeof($chars['K']), $config['captcha_gd_fonts']) -1)],

'L' => $chars['L'][mt_rand(0, min(sizeof($chars['L']), $config['captcha_gd_fonts']) -1)],

'N' => $chars['N'][mt_rand(0, min(sizeof($chars['N']), $config['captcha_gd_fonts']) -1)],

'O' => $chars['O'][mt_rand(0, min(sizeof($chars['O']), $config['captcha_gd_fonts']) -1)],

'P' => $chars['P'][mt_rand(0, min(sizeof($chars['P']), $config['captcha_gd_fonts']) -1)],

{

$mode = $this->mode;

}

if (!is_array($colour))

{

if (isset($this->named_rgb[$colour]))

$colour3[0] += 180;

$colour4[0] += 210;

$results[] = $this->allocate($colour2, $mode);

$results[] = $this->allocate($colour3, $mode);

$results[] = $this->allocate($colour4, $mode);

}

// This is a hard problem. I chicken out and try to maintain readability at the cost of less randomness.

while ($count > 0)

{

$colour[1] = ($colour[1] + mt_rand(40,60)) % 99;

define('ITEM_UNAPPROVED', 0); // => has not yet been approved

define('ITEM_APPROVED', 1); // => has been approved, and has not been soft deleted

define('ITEM_DELETED', 2); // => has been soft deleted

// Forum Flags

define('FORUM_FLAG_LINK_TRACK', 1);

}

/**

* Options to pick a timezone and date/time

*

* @param \phpbb\user $user Object of the current user

* the global one (false)

* @var bool|string append_sid_overwrite Overwrite function (string

* URL) or not (false)

*/

$vars = array('url', 'params', 'is_amp', 'session_id', 'append_sid_overwrite');

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

WHERE user_id = " . $user->data['user_id'];

$db->sql_query($sql);

if ($request->is_ajax())

{

$u_action .= '&confirm_uid=' . $user->data['user_id'] . '&sess=' . $user->session_id . '&sid=' . $user->session_id;

if (defined('IN_INSTALL') || defined('DEBUG') || isset($auth) && $auth->acl_get('a_'))

{

$msg_text = $log_text;

}

if ((defined('IN_CRON') || defined('IMAGE_OUTPUT')) && isset($db))

* @var int item_id Restrict online users to item id

* @var bool page_header_override Shall we return instead of running

* the rest of page_header()

*/

$vars = array('page_title', 'display_online_list', 'item_id', 'item', 'page_header_override');

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

* @var bool run_cron Shall we run cron tasks

* @var bool page_footer_override Shall we return instead of running

* the rest of page_footer()

*/

$vars = array('run_cron', 'page_footer_override');

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

* Unload some objects, to free some memory, before we finish our task

*

* @event core.garbage_collection

*/

$phpbb_dispatcher->dispatch('core.garbage_collection');

}

* @var string page_title Page title

* @var bool adm_page_header_override Shall we return instead of

* running the rest of adm_page_header()

*/

$vars = array('page_title', 'adm_page_header_override');

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

* @var bool copyright_html Shall we display the copyright?

* @var bool adm_page_footer_override Shall we return instead of

* running the rest of adm_page_footer()

*/

$vars = array('copyright_html', 'adm_page_footer_override');

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

* @var string name Should be used for the name attribute

* @var array vars Array with the options for the config

* @var string tpl The resulting html code we display

*/

$vars = array('tpl_type', 'key', 'new', 'name', 'vars', 'tpl');

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

* @var array error Array of errors, the errors should

* be strings only, language keys are

* not replaced afterwards

*/

$vars = array('cfg_array', 'config_name', 'config_definition', 'error');

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

// Notifications types to delete

$delete_notifications_types = array(

'quote',

'approve_post',

'post_in_queue',

);

* Perform additional actions before post(s) deletion

*

* @event core.delete_posts_before

* @var mixed where_ids Array or comma separated list of posts ids to delete

* @var bool auto_sync Flag indicating if topics/forums should be synchronized

* @var bool posted_sync Flag indicating if topics_posted table should be resynchronized

* @var array delete_notifications_types Array with notifications types to delete

* @since 3.1.0-a4

*/

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

if ($where_type === 'range')

* @var array poster_ids Array with deleted posts' author ids

* @var array topic_ids Array with deleted posts' topic ids

* @var array forum_ids Array with deleted posts' forum ids

* @var mixed where_ids Array or comma separated list of posts ids to delete

* @var array delete_notifications_types Array with notifications types to delete

* @since 3.1.0-a4

*/

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

$db->sql_transaction('commit');

* @var array poster_ids Array with deleted posts' author ids

* @var array topic_ids Array with deleted posts' topic ids

* @var array forum_ids Array with deleted posts' forum ids

* @var mixed where_ids Array or comma separated list of posts ids to delete

* @var array delete_notifications_types Array with notifications types to delete

* @since 3.1.0-a4

*/

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

// Resync topics_posted table

ITEM_DELETED => (!empty($topics_softdeleted)) ? ' WHERE ' . $db->sql_in_set('topic_id', $topics_softdeleted) : '',

);

{

if ($sql_where)

{

{

$forum_data[$forum_id]['topics_approved'] = $row['total_topics'];

}

{

$forum_data[$forum_id]['topics_unapproved'] = $row['total_topics'];

}

{

$topic_data[$topic_id]['posts_approved'] = $row['total_posts'];

}

{

$topic_data[$topic_id]['posts_unapproved'] = $row['total_posts'];

}

$topic_data[$topic_id]['first_post_id'] = (!empty($topic_data[$topic_id]['first_post_id'])) ? min($topic_data[$topic_id]['first_post_id'], $row['first_post_id']) : $row['first_post_id'];

$topic_data[$topic_id]['last_post_id'] = max($topic_data[$topic_id]['last_post_id'], $row['last_post_id']);

{

// Soft delete status is stronger than unapproved.

$topic_data[$topic_id]['visibility'] = $row['post_visibility'];

}

/**

* View log

*

* @param string $mode The mode defines which log_type is used and from which log the entry is retrieved

}

/**

* Lists inactive users

*/

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

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

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

$db->sql_freeresult($result);

$sql = 'SELECT ((SUM(size) * 8.0) * 1024.0) as dbsize

FROM sysfiles';

// Azure stats are stored elsewhere

if (strpos($row['mssql_version'], 'SQL Azure') !== false)

{

FROM sys.dm_db_partition_stats';

}

}

return $phpbb_path_helper->clean_path($path);

}

* make_jumpbox()

* bump_topic_allowed()

* get_context()

* decode_message()

* strip_bbcode()

* generate_text_for_display()

}

/**

* Decode text whereby text is coming from the db and expected to be pre-parsed content

* We are placing this outside of the message parser because we are often in need of it...

*/

* @var string bitfield The BBCode Bitfield

* @var int flags The BBCode Flags

* @var bool censor_text Whether or not to apply word censors

*/

$vars = array('text', 'uid', 'bitfield', 'flags', 'censor_text');

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

if ($censor_text)

$text = censor_text($text);

}

* @var string uid The BBCode UID

* @var string bitfield The BBCode Bitfield

* @var int flags The BBCode Flags

*/

$vars = array('text', 'uid', 'bitfield', 'flags');

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

* For parsing custom parsed text to be stored within the database.

* This function additionally returns the uid and bitfield that needs to be stored.

* Expects $text to be the value directly from request_var() and in it's non-parsed form

* @param string $text The text to be replaced with the parsed one

* @param string $uid The BBCode uid for this parse

* @param string $bitfield The BBCode bitfield for this parse

* @var bool allow_bbcode Whether or not to parse BBCode

* @var bool allow_urls Whether or not to parse URLs

* @var bool allow_smilies Whether or not to parse Smilies

*/

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

$uid = $bitfield = '';

* @var string uid The BBCode UID

* @var string bitfield The BBCode Bitfield

* @var int flags The BBCode Flags

*/

$vars = array('text', 'uid', 'bitfield', 'flags');

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

* @var string text The text to parse

* @var string uid The BBCode UID

* @var int flags The BBCode Flags

*/

$vars = array('text', 'uid', 'flags');

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

* @event core.modify_text_for_edit_after

* @var string text The text to parse

* @var int flags The BBCode Flags

*/

$vars = array('text', 'flags');

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

{

$username_string = str_replace(array('{PROFILE_URL}', '{USERNAME_COLOUR}', '{USERNAME}'), array($profile_url, $username_colour, $username), (!$username_colour) ? $_profile_cache['tpl_profile'] : $_profile_cache['tpl_profile_colour']);

}

/**

* Use this event to change the output of get_username_string()

*

* profile url.

* @var string username_string The string that has been generated

* @var array _profile_cache Array of original return templates

*/

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

return $username_string;

*

* @event core.display_forums_modify_sql

* @var array sql_ary The SQL array to get the data of the forums

*/

$vars = array('sql_ary');

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

* @event core.display_forums_modify_row

* @var int branch_root_id Last top-level forum

* @var array row The data of the forum

*/

$vars = array('branch_root_id', 'row');

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

* @var int branch_root_id Current top-level forum

* @var int parent_id Current parent forum

* @var array row The data of the forum

*/

$vars = array('forum_rows', 'subforums', 'branch_root_id', 'parent_id', 'row');

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

* @event core.display_forums_modify_template_vars

* @var array forum_row Template data of the forum

* @var array row The data of the forum

*/

$vars = array('forum_row', 'row');

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

$folder_new .= '_locked';

}

$folder_img = ($unread_topic) ? $folder_new : $folder;

$folder_alt = ($unread_topic) ? 'UNREAD_POSTS' : (($topic_row['topic_status'] == ITEM_LOCKED) ? 'TOPIC_LOCKED' : 'NO_UNREAD_POSTS');

* @event core.display_custom_bbcodes_modify_row

* @var array custom_tags Template data of the bbcode

* @var array row The data of the bbcode

*/

$vars = array('custom_tags', 'row');

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

* Display custom bbcodes

*

* @event core.display_custom_bbcodes

*/

$phpbb_dispatcher->dispatch('core.display_custom_bbcodes');

}

$use_queue = true;

}

if (empty($this->replyto))

{

}

if (empty($this->from))

{

}

$encode_eol = ($config['smtp_delivery']) ? "\r\n" : $this->eol;

'cfg_([a-z0-9_]+)' => '(int) $config[\'\\1\']',

'request_([a-zA-Z0-9_]+)' => '$request->variable(\'\\1\', false)',

'ext_([a-zA-Z0-9_/]+)' => 'array_key_exists(\'\\1\', $phpbb_extension_manager->all_enabled())',

);

/**

* @var string module_auth The module_auth of the current

* module

* @var int forum_id The current forum_id

*/

$vars = array('valid_tokens', 'module_auth', 'forum_id');

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

* @var string mode Mode of the smilies: window|inline

* @var int forum_id The forum ID we are currently in

* @var bool display_link Shall we display the "more smilies" link?

*/

$vars = array('mode', 'forum_id', 'display_link');

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

$ids = array($ids);

}

$update_sql = $empty_forums = $not_empty_forums = array();

if ($type != 'topic')

{

$sql_data[FORUMS_TABLE] .= 'forum_posts_approved = forum_posts_approved - 1, forum_topics_approved = forum_topics_approved - 1';

}

{

$sql_data[FORUMS_TABLE] .= 'forum_posts_unapproved = forum_posts_unapproved - 1, forum_topics_unapproved = forum_topics_unapproved - 1';

}

{

$phpbb_content_visibility->remove_post_from_statistic($data, $sql_data);

}

{

$sql_data[FORUMS_TABLE] = (($sql_data[FORUMS_TABLE]) ? $sql_data[FORUMS_TABLE] . ', ' : '') . 'forum_posts_unapproved = forum_posts_unapproved - 1';

$sql_data[TOPICS_TABLE] = (($sql_data[TOPICS_TABLE]) ? $sql_data[TOPICS_TABLE] . ', ' : '') . 'topic_posts_unapproved = topic_posts_unapproved - 1';

* @var bool update_search_index Flag indicating if the search index will be updated

* @since 3.1.0-a4

*/

// We do not handle erasing posts here

if ($mode == 'delete')

{

// Post not approved, but in queue

$post_visibility = ITEM_UNAPPROVED;

}

// MODs/Extensions are able to force any visibility on posts

if (isset($data['force_approved_state']))

{

}

if (isset($data['force_visibility']))

{

}

// Start the transaction here

$first_post_has_topic_info = ($post_mode == 'edit_first_post' &&

(($post_visibility == ITEM_DELETED && $data['topic_posts_softdeleted'] == 1) ||

($post_visibility == ITEM_UNAPPROVED && $data['topic_posts_unapproved'] == 1) ||

($post_visibility == ITEM_APPROVED && $data['topic_posts_approved'] == 1)));

// Fix the post's and topic's visibility and first/last post information, when the post is edited

if (($post_mode != 'post' && $post_mode != 'reply') && $data['post_visibility'] != $post_visibility)

// If the post was not approved, it could also be the starter,

// so we sync the starter after approving/restoring, to ensure that the stats are correct

// Same applies for the last post

$is_latest = ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || $data['post_visibility'] != ITEM_APPROVED);

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

case 'edit_first_post':

case 'edit':

case 'edit_last_post':

break;

}

}

{

switch ($mode)

{

case 'post':

case 'reply':

case 'quote':

// Nothing to do here

break;

case 'edit_topic':

case 'edit_first_post':

case 'edit':

case 'edit_last_post':

break;

}

}

* @var string url The "Return to topic" URL

* @var array data Array of post data about the

* submitted post

*/

$vars = array('url', 'data');

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

break;

}

if (!$result)

{

return false;

*/

function submit_pm($mode, $subject, &$data, $put_in_outbox = true)

{

// We do not handle erasing pms here

if ($mode == 'delete')

$current_time = time();

// Collect some basic information about which tables and which rows to update/insert

$sql_data = array();

$root_level = 0;

$decoded_message = bbcode_nl2br($decoded_message);

}

$parse_flags = ($row['bbcode_bitfield'] ? OPTION_FLAG_BBCODE : 0);

$parse_flags |= ($row['enable_smilies'] ? OPTION_FLAG_SMILIES : 0);

$message = generate_text_for_display($message, $row['bbcode_uid'], $row['bbcode_bitfield'], $parse_flags, false);

$subject = censor_text($subject);

class fileupload

{

var $allowed_extensions = array();

var $max_filesize = 0;

var $min_width = 0;

var $min_height = 0;

* @event core.update_username

* @var string old_name The old username that is replaced

* @var string new_name The new username

*/

$vars = array('old_name', 'new_name');

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

*

* @event core.user_add_modify_data

* @var array sql_ary Array of data to be inserted when a user is added

*/

$vars = array('sql_ary');

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

* @var array user_ids IDs of the deleted user

* @var mixed retain_username True if username should be retained

* or false if not

*/

$vars = array('mode', 'user_ids', 'retain_username');

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

* @var array user_ids IDs of the deleted user

* @var mixed retain_username True if username should be retained

* or false if not

*/

$vars = array('mode', 'user_ids', 'retain_username');

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

{

$function = array_shift($validate);

array_unshift($validate, $data[$var]);

{

// Since errors are checked later for their language file existence, we need to make sure custom errors are not adjusted.

$error[] = (empty($user->lang[$result . '_' . strtoupper($var)])) ? $result : $result . '_' . strtoupper($var);

{

global $config;

if ($avatar_entry[0] === 'g')

{

$avatar_group = true;

* @event core.delete_group_after

* @var int group_id ID of the deleted group

* @var string group_name Name of the deleted group

*/

$vars = array('group_id', 'group_name');

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

* @var string group_name Name of the group

* @var array user_id_ary IDs of the users which are removed

* @var array username_ary names of the users which are removed

*/

$vars = array('group_id', 'group_name', 'user_id_ary', 'username_ary');

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

* @var array group_attributes Group attributes which were changed

* @var array update_listing Update the list of moderators and foes

* @var array sql_ary User attributes which were changed

*/

$vars = array('group_id', 'user_id_ary', 'group_attributes', 'update_listing', 'sql_ary');

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

'title' => 'MCP_PM_REPORTS',

'version' => '1.0.0',

'modes' => array(

'pm_reports_closed' => array('title' => 'MCP_PM_REPORTS_CLOSED', 'auth' => 'aclf_m_report', 'cat' => array('MCP_REPORTS')),

'pm_report_details' => array('title' => 'MCP_PM_REPORT_DETAILS', 'auth' => 'aclf_m_report', 'cat' => array('MCP_REPORTS')),

),

case 'user':

$pre_fill = (string) $db->sql_fetchfield('username');

break;

case 'ip':

$pre_fill = (string) $db->sql_fetchfield('user_ip');

break;

$topic_title = censor_text($row['topic_title']);

$posts_unapproved = ($row['topic_visibility'] == ITEM_APPROVED && $row['topic_posts_unapproved'] && $auth->acl_get('m_approve', $row['forum_id'])) ? true : false;

$topic_deleted = $row['topic_visibility'] == ITEM_DELETED;

$u_mcp_queue = ($topic_unapproved || $posts_unapproved) ? $url . '&amp;i=queue&amp;mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . '&amp;t=' . $row['topic_id'] : '';

* @event core.mcp_view_forum_modify_topicrow

* @var array row Array with topic data

* @var array topic_row Template array with topic data

*/

$vars = array('row', 'topic_row');

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

$sql = 'SELECT COUNT(post_id) AS total

FROM ' . POSTS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $forum_list) . '

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

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

$db->sql_freeresult($result);

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

WHERE ' . $db->sql_in_set('forum_id', $forum_list) . '

ORDER BY post_time DESC';

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

{

$topics_moved++;

}

{

$topics_moved_unapproved++;

}

$total_topics++;

break;

case ITEM_UNAPPROVED:

$total_topics_unapproved++;

break;

case ITEM_DELETED:

$total_posts++;

break;

case ITEM_UNAPPROVED:

$total_posts_unapproved++;

break;

case ITEM_DELETED:

'U_MCP_USER_NOTES' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $pm_info['author_id']),

'U_MCP_WARN_REPORTER' => ($auth->acl_get('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&amp;mode=warn_user&amp;u=' . $report['user_id']) : '',

'U_MCP_WARN_USER' => ($auth->acl_get('m_warn')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=warn&amp;mode=warn_user&amp;u=' . $pm_info['author_id']) : '',

'EDIT_IMG' => $user->img('icon_post_edit', $user->lang['EDIT_POST']),

'MINI_POST_IMG' => $user->img('icon_post_target', 'POST'),

$template->assign_vars(array(

'L_EXPLAIN' => ($mode == 'pm_reports') ? $user->lang['MCP_PM_REPORTS_OPEN_EXPLAIN'] : $user->lang['MCP_PM_REPORTS_CLOSED_EXPLAIN'],

'L_TITLE' => ($mode == 'pm_reports') ? $user->lang['MCP_PM_REPORTS_OPEN'] : $user->lang['MCP_PM_REPORTS_CLOSED'],

'S_PM' => true,

'S_MCP_ACTION' => $this->u_action,

'S_CLOSED' => ($mode == 'pm_reports_closed') ? true : false,

'S_CAN_DELETE_POST' => $auth->acl_get('m_delete', $post_info['forum_id']),

'S_POST_REPORTED' => ($post_info['post_reported']) ? true : false,

'S_POST_DELETED' => ($post_info['post_visibility'] == ITEM_DELETED) ? true : false,

'S_POST_LOCKED' => ($post_info['post_edit_locked']) ? true : false,

'S_USER_NOTES' => true,

if (!empty($topic_id_list))

{

$sql = 'SELECT post_id

FROM ' . POSTS_TABLE . '

AND ' . $db->sql_in_set('topic_id', $topic_id_list);

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

'U_APPROVE_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue&amp;p=$post_id&amp;f=$forum_id"),

'S_CAN_VIEWIP' => $auth->acl_get('m_info', $post_info['forum_id']),

'S_POST_REPORTED' => $post_info['post_reported'],

'S_POST_LOCKED' => $post_info['post_edit_locked'],

'S_USER_NOTES' => true,

'S_POST_DELETED' => ($post_info['post_visibility'] == ITEM_DELETED),

'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'),

'RETURN_QUEUE' => sprintf($user->lang['RETURN_QUEUE'], '<a href="' . append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue' . (($topic_id) ? '&amp;mode=unapproved_topics' : '&amp;mode=unapproved_posts')) . '&amp;start=' . $start . '">', '</a>'),

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

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

$m_perm = 'm_approve';

$is_topics = ($mode == 'unapproved_topics' || $mode == 'deleted_topics') ? true : false;

$is_restore = ($mode == 'deleted_posts' || $mode == 'deleted_topics') ? true : false;

$user->add_lang(array('viewtopic', 'viewforum'));

$sql = 'SELECT p.post_id

FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t' . (($sort_order_sql[0] == 'u') ? ', ' . USERS_TABLE . ' u' : '') . '

WHERE ' . $db->sql_in_set('p.forum_id', $forum_list) . '

' . (($sort_order_sql[0] == 'u') ? 'AND u.user_id = p.poster_id' : '') . '

' . (($topic_id) ? 'AND p.topic_id = ' . $topic_id : '') . "

AND t.topic_id = p.topic_id

$sql = 'SELECT t.forum_id, t.topic_id, t.topic_title, t.topic_title AS post_subject, t.topic_time AS post_time, t.topic_poster AS poster_id, t.topic_first_post_id AS post_id, t.topic_attachment AS post_attachment, t.topic_first_poster_name AS username, t.topic_first_poster_colour AS user_colour

FROM ' . TOPICS_TABLE . ' t

WHERE ' . $db->sql_in_set('forum_id', $forum_list) . '

AND topic_delete_user <> 0

$limit_time_sql

ORDER BY $sort_order_sql";

}

$phpbb_notifications->delete_notifications('post_in_queue', $post_id);

$phpbb_notifications->mark_notifications_read(array(

'quote',

));

$phpbb_notifications->delete_notifications('topic_in_queue', $topic_id);

$phpbb_notifications->mark_notifications_read('quote', $topic_data['post_id'], $user->data['user_id']);

$phpbb_notifications->mark_notifications_read('topic', $topic_id, $user->data['user_id']);

if ($is_disapproving)

{

$l_log_message = ($log_data['type'] == 'topic') ? 'LOG_TOPIC_DISAPPROVED' : 'LOG_POST_DISAPPROVED';

}

else

{

$post_data['disapprove_reason'] .= ($reason) ? "\n\n" . $reason : '';

}

if ($disapprove_all_posts_in_topic && $topic_information[$topic_id]['topic_posts_unapproved'] == 1)

{

// If there is only 1 post when disapproving the topic,

unset($lang_reasons, $post_info, $disapprove_reason, $disapprove_reason_lang);

if ($num_disapproved_topics)

{

$success_msg = ($num_disapproved_topics == 1) ? 'TOPIC' : 'TOPICS';

$post_id = $report['post_id'];

$report_id = $report['report_id'];

$parse_post_flags = $report['reported_post_enable_bbcode'] ? OPTION_FLAG_BBCODE : 0;

$parse_post_flags += $report['reported_post_enable_smilies'] ? OPTION_FLAG_SMILIES : 0;

$post_info = get_post_data(array($post_id), 'm_report', true);

$post_unread = (isset($topic_tracking_info[$post_info['topic_id']]) && $post_info['post_time'] > $topic_tracking_info[$post_info['topic_id']]) ? true : false;

$report['report_text'] = make_clickable(bbcode_nl2br($report['report_text']));

if ($post_info['post_attachment'] && $auth->acl_get('u_download') && $auth->acl_get('f_download', $post_info['forum_id']))

'S_CLOSE_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports&amp;mode=report_details&amp;f=' . $post_info['forum_id'] . '&amp;p=' . $post_id),

'S_CAN_VIEWIP' => $auth->acl_get('m_info', $post_info['forum_id']),

'S_POST_REPORTED' => $post_info['post_reported'],

'S_POST_LOCKED' => $post_info['post_edit_locked'],

'S_REPORT_CLOSED' => $report['report_closed'],

'S_USER_NOTES' => true,

}

$db->sql_query($sql);

if (sizeof($close_report_posts))

{

if ($pm)

parse_attachments($topic_info['forum_id'], $message, $attachments[$row['post_id']], $update_count);

}

{

$has_unapproved_posts = true;

}

'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'UNREAD_POST') : $user->img('icon_post_target', 'POST'),

'S_POST_REPORTED' => ($row['post_reported'] && $auth->acl_get('m_report', $topic_info['forum_id'])),

'S_POST_DELETED' => ($row['post_visibility'] == ITEM_DELETED && $auth->acl_get('m_approve', $topic_info['forum_id'])),

'S_CHECKED' => (($submitted_id_list && !in_array(intval($row['post_id']), $submitted_id_list)) || in_array(intval($row['post_id']), $checked_ids)) ? true : false,

'S_HAS_ATTACHMENTS' => (!empty($attachments[$row['post_id']])) ? true : false,

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

{

// If split from selected post (split_beyond), we split the unapproved items too.

{

// continue;

}

function bbcode_init($allow_custom_bbcode = true)

{

global $phpbb_dispatcher;

static $rowset;

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

'title' => 'UCP_AUTH_LINK',

'version' => '1.0.0',

'modes' => array(

),

);

}

break;

}

$template->assign_vars(array(

'L_TITLE' => $user->lang['UCP_MAIN_' . strtoupper($mode)],

AND t.topic_id = tw.topic_id

AND ' . $db->sql_in_set('t.forum_id', $forbidden_forum_ary, true, true),

'ORDER_BY' => 't.topic_last_post_time DESC'

);

meta_refresh(3, $this->u_action);

$message = $user->lang['NOTIFICATIONS_MARK_ALL_READ_SUCCESS'];

if ($request->is_ajax())

{

$json_response = new \phpbb\json_response();

trigger_error('NO_AUTH_READ_HOLD_MESSAGE');

}

// First Handle Mark actions and moving messages

$submit_mark = (isset($_POST['submit_mark'])) ? true : false;

$move_pm = (isset($_POST['move_pm'])) ? true : false;

);

$s_hidden_fields .= build_address_field($address_list);

confirm_box(false, 'SAVE_DRAFT', $s_hidden_fields);

}

}

$return_box_url = ($action === 'post' || $action === 'edit') ? $outbox_folder_url : $inbox_folder_url;

$return_box_lang = ($action === 'post' || $action === 'edit') ? 'PM_OUTBOX' : 'PM_INBOX';

$save_message = ($action === 'edit') ? $user->lang['MESSAGE_EDITED'] : $user->lang['MESSAGE_STORED'];

$message = $save_message . '<br /><br />' . $user->lang('VIEW_PRIVATE_MESSAGE', '<a href="' . $return_message_url . '">', '</a>');

// Build hidden address list

$s_hidden_address_field = build_address_field($address_list);

$bbcode_checked = (isset($enable_bbcode)) ? !$enable_bbcode : (($config['allow_bbcode'] && $auth->acl_get('u_pm_bbcode')) ? !$user->optionget('bbcode') : 1);

$smilies_checked = (isset($enable_smilies)) ? !$enable_smilies : (($config['allow_smilies'] && $auth->acl_get('u_pm_smilies')) ? !$user->optionget('smilies') : 1);

$urls_checked = (isset($enable_urls)) ? !$enable_urls : 0;

trigger_error($message);

}

}

// Add Folder

if (isset($_POST['addfolder']))

{

// Move Messages

case 1:

$num_moved = move_pm($user->data['user_id'], $user->data['message_limit'], $msg_ids, $move_to, $remove_folder_id);

// Something went wrong, only partially moved?

if ($num_moved != $folder_row['pm_count'])

{

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

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

$db->sql_freeresult($result);

$folder[PRIVMSGS_INBOX] = array(

'folder_name' => $user->lang['PM_INBOX'],

'message_status' => $user->lang('FOLDER_MESSAGE_STATUS', $user->lang('MESSAGES_COUNT', (int) $user->data['message_limit']), $num_messages),

function define_cond_option($hardcoded, $cond_option, $rule_option, $global_rule_conditions)

{

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

$template->assign_vars(array(

'S_COND_DEFINED' => true,

'S_COND_SELECT' => (!$hardcoded && isset($global_rule_conditions[$rule_option])) ? true : false)

{

case 'text':

$rule_string = utf8_normalize_nfc(request_var('rule_string', '', true));

$template->assign_vars(array(

'S_TEXT_CONDITION' => true,

'CURRENT_STRING' => $rule_string,

case 'user':

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

$rule_string = utf8_normalize_nfc(request_var('rule_string', '', true));

if ($rule_string && !$rule_user_id)

{

$sql = 'SELECT user_id

{

$sql .= 'WHERE';

}

ORDER BY g.group_type DESC, g.group_name ASC';

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

$s_group_options = '';

$s_class = ($row['group_type'] == GROUP_SPECIAL) ? ' class="sep"' : '';

$s_selected = ($row['group_id'] == $rule_group_id) ? ' selected="selected"' : '';

$s_group_options .= '<option value="' . $row['group_id'] . '"' . $s_class . $s_selected . '>' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

}

$db->sql_freeresult($result);

WHERE user_id = ' . $user_id . '

ORDER BY rule_id ASC';

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

$count = 0;

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

{

* @var array message_row Array with message data

* @var array cp_row Array with senders custom profile field data

* @var array msg_data Template array with message data

*/

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

$template->assign_vars($msg_data);

{

$template->assign_block_vars('dl_method', $method);

}

foreach ($attachments as $attachment)

{

$template->assign_block_vars('attachment', array(

* @var bool submit Do we display the form only

* or did the user press submit

* @var array data Array with current ucp options data

*/

$vars = array('submit', 'data');

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

* @event core.ucp_prefs_personal_update_data

* @var array data Submitted display options data

* @var array sql_ary Display options data we udpate

*/

$vars = array('data', 'sql_ary');

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

* @var bool submit Do we display the form only

* or did the user press submit

* @var array data Array with current ucp options data

*/

$vars = array('submit', 'data');

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

* @event core.ucp_prefs_view_update_data

* @var array data Submitted display options data

* @var array sql_ary Display options data we udpate

*/

$vars = array('data', 'sql_ary');

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

* @var bool submit Do we display the form only

* or did the user press submit

* @var array data Array with current ucp options data

*/

$vars = array('submit', 'data');

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

* @event core.ucp_prefs_post_update_data

* @var array data Submitted display options data

* @var array sql_ary Display options data we udpate

*/

$vars = array('data', 'sql_ary');

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

* @event core.ucp_remove_zebra

* @var string mode Zebra type: friends|foes

* @var array user_ids User ids we remove

*/

$vars = array('mode', 'user_ids');

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

* friends|foes

* @var array sql_ary Array of

* entries we add

*/

$vars = array('mode', 'sql_ary');

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

}

}

}

if ($request->is_ajax())

{

$message = ($updated) ? $user->lang[$l_mode . '_UPDATED'] : implode('<br />', $error);

$json_response = new \phpbb\json_response;

$json_response->send(array(

'success' => $updated,

'MESSAGE_TITLE' => $user->lang['INFORMATION'],

'MESSAGE_TEXT' => $message,

'REFRESH_DATA' => array(

continue;

}

// STEP 1: Decompose current char

// We have found a character that is either:

$utf_seq = array($utf_char);

}

// STEP 2: Capture the starter

// Check out the combining class of the first character of the UTF sequence

}

}

// STEP 3: Capture following combining modifiers

while ($pos < $len)

}

}

// STEP 4: Sort and combine

// Here we sort...

$tmp_pos = $last_cc = $sort = $dump = 0;

$utf_sort = array();

// Main loop

do

{

continue;

}

// STEP 1: Decide what to do with current char

// Now, in that order:

redirect(append_sid($phpbb_root_path . $redirect));

}

}

}

}

*

* @event core.index_modify_page_title

* @var string page_title Title of the index page

*/

$vars = array('page_title');

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

$prune_enabled = (int) $src_db->sql_fetchfield('config_value');

$src_db->sql_freeresult($result);

// Insert categories

$sql = 'SELECT cat_id, cat_title

FROM ' . $convert->src_table_prefix . 'categories

// What we will do is handling all 2.0.x admins as founder to replicate what is common in 2.0.x.

// After conversion the main admin need to make sure he is removing permissions and the founder status if wanted.

// Grab user ids of users with user_level of ADMIN

$sql = "SELECT user_id

FROM {$convert->src_table_prefix}users

<?php

/**

* @todo firebird/mysql update?

*/

'S_LEGEND' => false,

));

// Check for getimagesize

if (@function_exists('getimagesize'))

{

$url = (!in_array(false, $passed)) ? $this->p_master->module_url . "?mode=$mode&amp;sub=database&amp;language=$language" : $this->p_master->module_url . "?mode=$mode&amp;sub=requirements&amp;language=$language ";

$submit = (!in_array(false, $passed)) ? $lang['INSTALL_START'] : $lang['INSTALL_TEST'];

$template->assign_vars(array(

'L_SUBMIT' => $submit,

'S_HIDDEN' => $s_hidden_fields,

$_module->move_module_by($row, 'move_up', 5);

}

if ($module_class == 'ucp')

{

// Move attachment module 4 down...

$db->sql_freeresult($result);

$_module->move_module_by($row, 'move_down', 4);

}

// And now for the special ones

INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path', 'images/avatars/upload');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_salt', 'phpbb_avatar');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_contact', 'contact@yourdomain.tld');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable_msg', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email', 'address@yourdomain.tld');

'EXT_GROUP_REAL_MEDIA' => 'Real Media',

'EXT_GROUP_WINDOWS_MEDIA' => 'Windows Media',

'GO_TO_EXTENSIONS' => 'Go to extension management screen',

'GROUP_NAME' => 'Group name',

'NOT_ALLOWED_IN_PM' => 'Only allowed in posts',

'NOT_ALLOWED_IN_PM_POST' => 'Not allowed',

'NOT_ASSIGNED' => 'Not assigned',

'NO_EXT_GROUP' => 'None',

'NO_EXT_GROUP_NAME' => 'No group name entered',

'NO_EXT_GROUP_SPECIFIED' => 'No extension group specified.',

'ORDER_ALLOW_DENY' => 'Allow',

'ORDER_DENY_ALLOW' => 'Deny',

'SEARCH_IMAGICK' => 'Search for Imagemagick',

'SECURE_ALLOW_DENY' => 'Allow/Deny list',

'BOARD_HIDE_EMAILS_EXPLAIN' => 'This function keeps email addresses completely private.',

'CONTACT_EMAIL' => 'Contact email address',

'CONTACT_EMAIL_EXPLAIN' => 'This address will be used whenever a specific contact point is needed, e.g. spam, error output, etc. It will always be used as the <samp>From</samp> and <samp>Reply-To</samp> address in emails.',

'EMAIL_FUNCTION_NAME' => 'Email function name',

'EMAIL_FUNCTION_NAME_EXPLAIN' => 'The email function used to send mails through PHP.',

'EMAIL_PACKAGE_SIZE' => 'Email package size',

'ACP_EXTENSION_MANAGEMENT' => 'Extension management',

'ACP_EXTENSIONS' => 'Manage extensions',

'ACP_FORUM_BASED_PERMISSIONS' => 'Forum based permissions',

'ACP_FORUM_LOGS' => 'Forum logs',

'ACP_FORUM_MANAGEMENT' => 'Forum management',

'EXPORT_DOWNLOAD' => 'Download',

'EXPORT_STORE' => 'Store',

'GENERAL_OPTIONS' => 'General options',

'GENERAL_SETTINGS' => 'General settings',

'GLOBAL_MASK' => 'Global permission mask',

'REMIND' => 'Remind',

'RESYNC' => 'Resynchronise',

'SELECT_ANONYMOUS' => 'Select anonymous user',

'SELECT_OPTION' => 'Select option',

'RESET_ONLINE' => 'Reset most users ever online',

'RESET_ONLINE_CONFIRM' => 'Are you sure you wish to reset the most users ever online counter?',

'RESET_ONLINE_SUCCESS' => 'Most users ever online reset',

'RESYNC_POSTCOUNTS' => 'Resynchronise post counts',

'RESYNC_POSTCOUNTS_EXPLAIN' => 'Only existing posts will be taken into consideration. Pruned posts will not be counted.',

'RESYNC_POSTCOUNTS_CONFIRM' => 'Are you sure you wish to resynchronise post counts?',

'LOG_PM_REPORT_CLOSED' => '<strong>Closed PM report</strong><br />» %s',

'LOG_PM_REPORT_DELETED' => '<strong>Deleted PM report</strong><br />» %s',

'LOG_POST_APPROVED' => '<strong>Approved post</strong><br />» %s',

'LOG_POST_EDITED' => '<strong>Edited post “%1$s” written by</strong><br />» %2$s',

'LOG_POST_RESTORED' => '<strong>Restored post</strong><br />» %s',

'LOG_REPORT_CLOSED' => '<strong>Closed report</strong><br />» %s',

'LOG_TOPIC_APPROVED' => '<strong>Approved topic</strong><br />» %s',

'LOG_TOPIC_RESTORED' => '<strong>Restored topic</strong><br />» %s',

'LOG_TOPIC_RESYNC' => '<strong>Resynchronised topic counters</strong><br />» %s',

'LOG_TOPIC_TYPE_CHANGED' => '<strong>Changed topic type</strong><br />» %s',

'LOG_UNLOCK' => '<strong>Unlocked topic</strong><br />» %s',

'LOG_PURGE_CACHE' => '<strong>Purged cache</strong>',

'LOG_PURGE_SESSIONS' => '<strong>Purged sessions</strong>',

'LOG_RANK_ADDED' => '<strong>Added new rank</strong><br />» %s',

'LOG_RANK_REMOVED' => '<strong>Removed rank</strong><br />» %s',

'LOG_RANK_UPDATED' => '<strong>Updated rank</strong><br />» %s',

'LOG_REFERER_INVALID' => '<strong>Referer validation failed</strong><br />»Referer was “<em>%1$s</em>”. The request was rejected and the session killed.',

'LOG_RESET_DATE' => '<strong>Board start date reset</strong>',

'LOG_RESET_ONLINE' => '<strong>Most users online reset</strong>',

'LOG_RESYNC_POSTCOUNTS' => '<strong>User post counts resynchronised</strong>',

'LOG_RESYNC_POST_MARKING' => '<strong>Dotted topics resynchronised</strong>',

'LOG_RESYNC_STATS' => '<strong>Post, topic and user statistics resynchronised</strong>',

// equally where a string contains only two placeholders which are used to wrap text

// in a url you again do not need to specify an order e.g., 'Click %sHERE%s' is fine

$lang = array_merge($lang, array(

'EXTENSION' => 'Extension',

'EXTENSIONS' => 'Extensions',

'ROLE_USER_STANDARD' => 'Standard Features',

'ROLE_USER_NEW_MEMBER' => 'Newly Registered User Features',

'ROLE_DESCRIPTION_ADMIN_FORUM' => 'Can access the forum management and forum permission settings.',

'ROLE_DESCRIPTION_ADMIN_FULL' => 'Has access to all administrative functions of this board.<br />Not recommended.',

'ROLE_DESCRIPTION_ADMIN_STANDARD' => 'Has access to most administrative features but is not allowed to use server or system related tools.',

'URL' => 'A valid URL using any protocol (http, ftp, etc… cannot be used for javascript exploits). If none is given, “http://” is prefixed to the string.',

'LOCAL_URL' => 'A local URL. The URL must be relative to the topic page and cannot contain a server name or protocol, as links are prefixed with “%s”',

'RELATIVE_URL' => 'A relative URL. You can use this to match parts of a URL, but be careful: a full URL is a valid relative URL. When you want to use relative URLs of your board, use the LOCAL_URL token.',

));

// Smilies and topic icons

'DISPLAY_POSTING' => 'On posting page',

'DISPLAY_POSTING_NO' => 'Not on posting page',

'EDIT_ICONS' => 'Edit icons',

'EDIT_SMILIES' => 'Edit smilies',

'EMOTION' => 'Emotion',

'NOT_WATCHING_FORUM' => 'You are no longer subscribed to updates on this forum.',

'NOT_WATCHING_TOPIC' => 'You are no longer subscribed to this topic.',

'NOTIFICATIONS' => 'Notifications',

// %1$s will return a list of users that's concatenated using "," and "and" - see STRING_LIST

// Once the user count reaches 5 users or more, the list is trimmed using NOTIFICATION_X_OTHERS

// Examples:

// A replied...

// A and B replied...

// A, B and C replied...

// A, B, C and 2 others replied...

'NOTIFICATION_BOOKMARK' => array(

1 => '%1$s replied to the topic “%2$s” you have bookmarked.',

),

'NOTIFICATION_TOPIC_IN_QUEUE' => 'A new topic titled "%2$s" was posted by %1$s and needs approval.',

'NOTIFICATION_TYPE_NOT_EXIST' => 'The notification type "%s" is missing from the file system.',

'NOTIFICATION_ADMIN_ACTIVATE_USER' => 'The user “%1$s” is newly registered and requires activation.',

'NOTIFICATION_X_OTHERS' => array(

2 => '%d others',

),

'D M d, Y g:i a' => 'Mon Jan 01, 2007 1:37 pm',

'F jS, Y, g:i a' => 'January 1st, 2007, 1:37 pm',

'|d M Y|, H:i' => 'Today, 13:37 / 01 Jan 2007, 13:37',

),

// The default dateformat which will be used on new installs in this language

Use this link to activate the account:

{U_ACTIVATE}

{MESSAGE}

{EMAIL_SIG}

Your password has been securely stored in our database and cannot be retrieved. In the event that it is forgotten, you will be able to reset it using the email address associated with your account.

Thank you for registering.

----------

In order to keep your board safe and secure, we highly recommended keeping current with software releases. For your convenience, a mailing list is available at the page referenced above.

You are receiving this notification because the report you filed regarding the private message "{PM_SUBJECT}" at "{SITENAME}" has been tended to by a moderator or administrator. The report is now closed. If you have further questions, please contact {CLOSER_NAME} by private message.

You are receiving this notification because the report you filed regarding the private message "{PM_SUBJECT}" at "{SITENAME}" was deleted by a moderator or administrator.

If you want to view the topic, click the following link:

{U_VIEW_TOPIC}

If you want to view the topic, click the following link:

{U_VIEW_TOPIC}

{U_ACTIVATE}

Your account on "{SITENAME}" has been deactivated, most likely due to changes made to your profile. The administrator of the board will need to activate it before you can log in. You will receive another notification when this has occurred.

You can of course change this password yourself via the profile page. If you have any difficulties please contact the board administrator.

{U_ACTIVATE}

Thank you for registering at "{SITENAME}", we look forward to your participation.

Thank you for registering.

Thank you for registering.

Thank you for registering.

'NOT_LEADER_OF_GROUP' => 'The requested operation cannot be taken because you are not a leader of the selected group.',

'NOT_MEMBER_OF_GROUP' => 'The requested operation cannot be taken because you are not a member of the selected group or your membership has not been approved yet.',

'NOT_RESIGN_FROM_DEFAULT_GROUP' => 'You are not allowed to resign from your default group.',

'PRIMARY_GROUP' => 'Primary group',

'REMOVE_SELECTED' => 'Remove selected',

array(

0 => 'Can I add my own tags?',

1 => 'If you are an administrator on this board and have the proper permissions, you can add further BBCodes through the Custom BBCodes section.'

);

array(

0 => 'Who do I contact about abusive and/or legal matters related to this board?',

1 => 'Any of the administrators listed on the “The team” page should be an appropriate point of contact for your complaints. If this still gets no response then you should contact the owner of the domain (do a <a href="http://www.google.com/search?q=whois">whois lookup</a>) or, if this is running on a free service (e.g. Yahoo!, free.fr, f2s.com, etc.), the management or abuse department of that service. Please note that the phpBB Group has <strong>absolutely no jurisdiction</strong> and cannot in any way be held liable over how, where or by whom this board is used. Do not contact the phpBB Group in relation to any legal (cease and desist, liable, defamatory comment, etc.) matter <strong>not directly related</strong> to the phpBB.com website or the discrete software of phpBB itself. If you do email phpBB Group <strong>about any third party</strong> use of this software then you should expect a terse response or no response at all.'

);

'SPAM' => 'The reported message has the only purpose to advertise for a website or another product.',

'OFF_TOPIC' => 'The reported message is off topic.',

'OTHER' => 'The reported message does not fit into any other category, please use the further information field.',

),

));

'BBCODE_IS_OFF' => '%sBBCode%s is <em>OFF</em>',

'BBCODE_IS_ON' => '%sBBCode%s is <em>ON</em>',

'BBCODE_I_HELP' => 'Italic text: [i]text[/i]',

'BBCODE_LISTITEM_HELP' => 'List item: [*]text',

'BBCODE_O_HELP' => 'Ordered list: e.g. [list=1][*]First point[/list] or [list=a][*]Point a[/list]',

'BBCODE_P_HELP' => 'Insert image: [img]http://image_url[/img]',

'NO_RECENT_SEARCHES' => 'No searches have been carried out recently.',

'NO_SEARCH' => 'Sorry but you are not permitted to use the search system.',

'NO_SEARCH_RESULTS' => 'No suitable matches were found.',

'NO_SEARCH_UNREADS' => 'Sorry but searching for unread posts has been disabled on this board.',

'WORD_IN_NO_POST' => 'No posts were found because the word <strong>%s</strong> is not contained in any post.',

'WORDS_IN_NO_POST' => 'No posts were found because the words <strong>%s</strong> are not contained in any post.',

'PM_SENTBOX' => 'Sent messages',

'PM_SUBJECT' => 'Message subject',

'PM_TO' => 'Send to',

'PM_USERS_REMOVED_NO_PM' => 'Some users couldn’t be added as they have disabled private message receipt.',

'POST_EDIT_PM' => 'Edit message',

'POST_FORWARD_PM' => 'Forward message',

'PLACE_INTO_FOLDER' => 'Place into folder',

'MARK_AS_READ' => 'Mark as read',

'MARK_AS_IMPORTANT' => 'Mark message',

),

'PM_CHECK' => array(

'SUBJECT' => 'Subject',

'SENDER' => 'Sender',

'MESSAGE' => 'Message',

'STATUS' => 'Message status',

),

'PM_RULE' => array(

'IS_LIKE' => 'is like',

'ANSWERED' => 'answered',

'FORWARDED' => 'forwarded',

'TO_GROUP' => 'to my default usergroup',

),

'GROUPS_EXPLAIN' => 'Usergroups enable board admins to better administer users. By default you will be placed in a specific group, this is your default group. This group defines how you may appear to other users, for example your username colouration, avatar, rank, etc. Depending on whether the administrator allows it you may be allowed to change your default group. You may also be placed in or allowed to join other groups. Some groups may give you additional permissions to view content or increase your capabilities in other areas.',

'GROUP_LEADER' => 'Leaderships',

'GROUP_MEMBER' => 'Memberships',

1 => 'Last edited by %2$s on %3$s, edited %1$d time in total.',

2 => 'Last edited by %2$s on %3$s, edited %1$d times in total.',

),

'ERROR_NO_ATTACHMENT' => 'The selected attachment does not exist anymore.',

'FILE_NOT_FOUND_404' => 'The file <strong>%s</strong> does not exist.',

* @var bool is_valid_action Flag indicating if the action was handled properly

* @since 3.1.0-a4

*/

if (!$is_valid_action)

{

* @var int id Parent module id

* @since 3.1.0-b2

*/

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

// Load and execute the relevant module

case 'unapproved_posts':

case 'deleted_posts':

$type = 'posts';

$default_key = 't';

$default_dir = 'd';

$sql = 'SELECT COUNT(p.post_id) AS total

FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . " t

$where_sql " . $db->sql_in_set('p.forum_id', ($forum_id) ? array($forum_id) : array_intersect(get_forum_list('f_read'), get_forum_list('m_approve'))) . '

AND t.topic_id = p.topic_id

AND t.topic_visibility <> p.post_visibility';

case 'unapproved_topics':

case 'deleted_topics':

$type = 'topics';

$default_key = 't';

$default_dir = 'd';

$sql = 'SELECT COUNT(topic_id) AS total

FROM ' . TOPICS_TABLE . "

$where_sql " . $db->sql_in_set('forum_id', ($forum_id) ? array($forum_id) : array_intersect(get_forum_list('f_read'), get_forum_list('m_approve'))) . '

if ($min_time)

{

* enabled?

* @var bool friend Is the user friend?

* @var bool foe Is the user foe?

* @changed 3.1.0-b2 Added friend and foe status

*/

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

$template->assign_vars(show_profile($member, $user_notes_enabled, $warn_user_enabled));

$sql = 'SELECT COUNT(post_id) as posts_in_queue

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $user_id . '

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

$member['posts_in_queue'] = (int) $db->sql_fetchfield('posts_in_queue');

$db->sql_freeresult($result);

* @event core.memberlist_prepare_profile_data

* @var array data Array with user's data

* @var array template_data Template array with user's data

*/

$vars = array('data', 'template_data');

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

/**

* Change visibility status of one post or all posts of a topic

*

* @param $post_id mixed Post ID or array of post IDs to act on,

* if it is empty, all posts of topic_id will be modified

* @param $topic_id int Topic where $post_id is found

* @param $forum_id int Forum where $topic_id is found

* @param $user_id int User performing the action

* @param $time int Timestamp when the action is performed

* @param $is_starter bool Is this the first post of the topic changed?

* @param $is_latest bool Is this the last post of the topic changed?

* @param $limit_visibility mixed Limit updating per topic_id to a certain visibility

* @param $limit_delete_time mixed Limit updating per topic_id to a certain deletion time

*/

public function set_post_visibility($visibility, $post_id, $topic_id, $forum_id, $user_id, $time, $reason, $is_starter, $is_latest, $limit_visibility = false, $limit_delete_time = false)

{

{

return array();

}

// Update users postcounts

foreach ($postcounts as $num_posts => $poster_ids)

{

{

$sql = 'UPDATE ' . $this->users_table . '

SET user_posts = 0

// Update the topic's reply count and the forum's post count

if ($update_topic_postcount)

{

foreach ($postcount_visibility as $post_visibility => $visibility_posts)

{

}

$sql_ary = array();

{

{

}

}

{

}

if (sizeof($sql_ary))

* as soft deleted.

* If you want to update all posts, use the force option.

*

* @param $topic_id mixed Topic ID to act on

* @param $forum_id int Forum where $topic_id is found

* @param $user_id int User performing the action

*/

public function set_topic_visibility($visibility, $topic_id, $forum_id, $user_id, $time, $reason, $force_update_all = false)

{

{

return array();

}

}

else if (!$force_update_all && $original_topic_data['topic_visibility'] == ITEM_APPROVED && $visibility == ITEM_DELETED)

{

$this->set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true, $original_topic_data['topic_visibility']);

}

else

$limit = 10;

$converted_forums = 0;

$sql = 'SELECT forum_id, topic_visibility, COUNT(topic_id) AS sum_topics, SUM(topic_posts_approved) AS sum_posts_approved, SUM(topic_posts_unapproved) AS sum_posts_unapproved

FROM ' . $this->table_prefix . 'topics

GROUP BY forum_id, topic_visibility

throw new \phpbb\db\migration\exception('MIGRATION_INVALID_DATA_CUSTOM_NOT_CALLABLE', $step);

}

break;

default:

var $dbms_type_map = array();

/**

* Get the column types for every database we support

*

* @return array

}

}

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

{

foreach ($schema_changes['add_unique_index'] as $table => $index_array)

}

/**

*

* @param string $table_name Table to check the index at

* @param string $index_name The index name to check

case 'mssql':

case 'mssqlnative':