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;

}

{

"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": [

],

}

$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

*

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;

{

$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);

$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]);

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

);

return;

break;

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']);

}

}

$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(

$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;

}

/**

* Options to pick a timezone and date/time

*

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

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))

* 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 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

* @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

}

/**

* 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);

}

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

if ($censor_text)

$text = censor_text($text);

}

* 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

{

$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()

*

$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');

'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())',

);

/**

$ids = array($ids);

}

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

if ($type != 'topic')

break;

}

if (!$result)

{

return false;

$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;

{

$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;

'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;

'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,

'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>'),

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']))

}

$db->sql_query($sql);

if (sizeof($close_report_posts))

{

if ($pm)

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))

{

{

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

}

foreach ($attachments as $attachment)

{

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

}

}

}

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:

$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

'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',

'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',

'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.',

$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

case 'mssql':

case 'mssqlnative':

{

}

}

$statements[] = 'ALTER TABLE [' . $table_name . '] DROP COLUMN [' . $column_name . ']';

break;

case 'mysql_40':

case 'mssql':

case 'mssqlnative':

$statements[] = 'ALTER TABLE [' . $table_name . '] ALTER COLUMN [' . $column_name . '] ' . $column_data['column_type_sql'];

if (!empty($column_data['default']))

{

{

}

}

break;

case 'mysql_40':

return $this->_sql_run_sql($statements);

}

}

$num_args = 0;

if (!is_array($this->user->lang[$row['log_operation']]))

{

}

else

{

$operations = array();

foreach ($this->user->lang as $key => $value)

{

{

}

}

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

trigger_error($message);

}

$reported_post_text = $report_data['message_text'];

$reported_post_bitfield = $report_data['bbcode_bitfield'];

$reported_post_uid = $report_data['bbcode_uid'];

if ($user->data['user_last_search'] > time() - $interval)

{

$template->assign_var('S_NO_SEARCH', true);

}

}

* @param int Delay in ms until darkenwrapper's click event is triggered

*/

phpbb.closeDarkenWrapper = function(delay) {

$('#darkenwrapper').trigger('click');

}, delay);

};

var option = $(this);

var option_id = option.attr('data-poll-option-id');

var voted = (typeof res.user_votes[option_id] !== 'undefined') ? true : false;

var percent = (!res.total_votes) ? 0 : Math.round((res.vote_counts[option_id] / res.total_votes) * 100);

var percent_rel = (most_votes == 0) ? 0 : Math.round((res.vote_counts[option_id] / most_votes) * 100);

option.toggleClass('voted', voted);

// Update the bars

var bar = option.find('.resultbar div');

<div class="panel">

<div class="inner">

<p>{L_CONFIRM_EXPLAIN}</p>

<fieldset class="fields2">

<div class="panel">

<div class="inner">

<fieldset class="fields2">

<!-- ENDIF -->

<div class="panel">

<div class="inner">

<p>{L_CONFIRM_EXPLAIN}</p>

<fieldset class="fields2">

<div class="panel">

<div class="inner">

<p>{MESSAGE_TEXT}</p>

<fieldset class="submit-buttons">

<div class="panel">

<div class="inner">

<p>{MESSAGE_TEXT}</p>

<div class="panel">

<div class="inner">

<p>{L_LOAD_DRAFT_EXPLAIN}</p>

</div>

<!-- INCLUDE overall_header.html -->

<div class="panel bg1" id="faqlinks">

</div>

</div>

<!-- BEGIN faq_block -->

<div class="panel <!-- IF faq_block.S_ROW_COUNT is odd -->bg1<!-- ELSE -->bg2<!-- ENDIF -->">

<div class="inner">

<div class="content">

<!-- BEGIN faq_row -->

<dl class="faq">

<dt id="f{faq_block.S_ROW_COUNT}r{faq_block.faq_row.S_ROW_COUNT}"><strong>{faq_block.faq_row.FAQ_QUESTION}</strong></dt>

<div class="inner">

<div class="content">

<fieldset <!-- IF not S_CONFIRM_CODE -->class="fields1"<!-- ELSE -->class="fields2"<!-- ENDIF -->>

<!-- IF LOGIN_ERROR --><div class="error">{LOGIN_ERROR}</div><!-- ENDIF -->

<!-- INCLUDE overall_header.html -->

<form id="login_forum" method="post" action="{S_LOGIN_ACTION}">

{S_FORM_TOKEN}

<div class="inner">

<div class="content">

<p>{L_LOGIN_FORUM}</p>

<div class="content">

<!-- IF ADDITIONAL_MSG --><p class="error">{ADDITIONAL_MSG}</p><!-- ENDIF -->

<fieldset>

</div>

</div>

</div>

<!-- INCLUDE overall_footer.html -->

<div id="cp-main" class="mcp-main panel-container">

<!-- IF MESSAGE -->

<div class="content">

<p class="error">{MESSAGE}</p>

<p><!-- BEGIN return_links -->{return_links.MESSAGE_LINK}<br /><br /><!-- END return_links --></p>

</div>

<!-- INCLUDE mcp_header.html -->

<div class="content">

<p>{MESSAGE_TEXT}</p>

</div>

<div class="inner">

<div class="content">

<!-- IF ADDITIONAL_MSG --><p>{ADDITIONAL_MSG}</p><!-- ENDIF -->

<fieldset>

<!-- IF S_SHOW_GROUP -->

<p>{GROUP_DESC} {GROUP_TYPE}</p>

<p>

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

<!-- INCLUDE overall_header.html -->

<form method="post" action="{S_PROFILE_ACTION}" id="viewprofile">

<div class="panel bg1<!-- IF S_ONLINE --> online<!-- ENDIF -->">

<!-- ENDIF -->

</dl>

</div>

<!-- EVENT memberlist_view_contact_before -->

<div class="panel bg2">

<div class="inner">

<h3>{L_CONTACT_USER} {USERNAME}</h3>

<dl class="details">

<!-- EVENT memberlist_view_user_statistics_after -->

</dl>

</div>

</div>

<!-- EVENT memberlist_view_contact_after -->

<div class="postbody"><div class="signature standalone">{SIGNATURE}</div></div>

</div>

<!-- ENDIF -->

<div class="panel" id="message">

<div class="inner">

<p>{MESSAGE_TEXT}</p>

<!-- IF SCRIPT_NAME == "search" and not S_BOARD_DISABLED and not S_NO_SEARCH and L_RETURN_TO_SEARCH_ADV --><p><a href="{U_SEARCH}" class="arrow-{S_CONTENT_FLOW_BEGIN}">{L_RETURN_TO_SEARCH_ADV}</a></p><!-- ENDIF -->

</div>

<div class="inner">

<ul class="linklist bulletin">

<!-- EVENT overall_footer_breadcrumb_append -->

</li>

<!-- IF not S_IS_BOT -->

<ul class="linklist navlinks">

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

<!-- EVENT overall_header_breadcrumb_append -->

</li>

<!-- IF S_REGISTERED_USER --><li id="username_logged_in" class="rightside"><!-- IF CURRENT_USER_AVATAR --><a href="{U_USER_PROFILE}" class="header-avatar">{CURRENT_USER_AVATAR}</a> <!-- ENDIF -->{USERNAME_FULL}</li><!-- ENDIF -->

<!-- IF S_DISPLAY_SEARCH and not S_IN_SEARCH --><li class="responsive-search rightside" style="display: none;"><a href="{U_SEARCH}" title="{L_SEARCH_ADV_EXPLAIN}">{L_SEARCH}</a></li><!-- ENDIF -->

</ul>

<!-- INCLUDE overall_header.html -->

<!-- IF TOPIC_TITLE -->

<!-- ELSE -->

<!-- ENDIF -->

<!-- IF S_FORUM_RULES -->

</dl>

</div>

<!-- ENDIF -->

<!-- ENDIF -->

</fieldset>

<!-- IF S_DISPLAY_PREVIEW --><!-- INCLUDE posting_preview.html --><!-- ENDIF -->

<div class="panel" id="pmheader-postingbox">

<div class="inner">

<!-- EVENT quickreply_editor_panel_before -->

<div class="panel">

<div class="inner">

<fieldset class="fields1">

<dl style="clear: left;">

<dt><label for="subject">{L_SUBJECT}{L_COLON}</label></dt>

<!-- INCLUDE overall_header.html -->

<!-- IF SEARCHED_QUERY --> <p>{L_SEARCHED_QUERY}{L_COLON} <strong>{SEARCHED_QUERY}</strong></p><!-- ENDIF -->

<!-- IF IGNORED_WORDS --> <p>{L_IGNORED_TERMS}{L_COLON} <strong>{IGNORED_WORDS}</strong></p><!-- ENDIF -->

<!-- IF PHRASE_SEARCH_DISABLED --> <p><strong>{L_PHRASE_SEARCH_DISABLED}</strong></p><!-- ENDIF -->

<div class="panel">

<div class="inner">

<div class="content">

<p><!-- IF S_SHOW_COPPA -->{L_COPPA_BIRTHDAY}<!-- ELSE -->{L_TERMS_OF_USE}<!-- ENDIF --></p>

</div>

</div>

<div class="panel">

<div class="inner">

<div class="content">

<p>{AGREEMENT_TEXT}</p>

<hr class="dashed" />

<p><a href="{U_BACK}" class="button2">{L_BACK}</a></p>

</div>

</div>

</div>

<!-- IF S_COMPOSE_PM -->

<div>{S_FORM_TOKEN}</div>

<!-- INCLUDE overall_header.html -->

<div id="tabs">

<ul>

</div>

<!-- ENDIF -->

<!-- IF TOTAL_MESSAGES or S_VIEW_MESSAGE -->

<ul class="linklist">

<li class="rightside pagination">

<!-- INCLUDE overall_header.html -->

<!-- IF U_MCP or U_ACP --><p class="responsive-center">[&nbsp;<!-- IF U_ACP --><a href="{U_ACP}" title="{L_ACP}" data-responsive-text="{L_ACP_SHORT}">{L_ACP}</a><!-- IF U_MCP -->&nbsp;|&nbsp;<!-- ENDIF --><!-- ENDIF --><!-- IF U_MCP --><a href="{U_MCP}" title="{L_MCP}" data-responsive-text="{L_MCP_SHORT}">{L_MCP}</a><!-- ENDIF -->&nbsp;]</p><!-- ENDIF -->

<!-- IF FORUM_DESC or MODERATORS or U_MCP -->

<div>

<!-- INCLUDE overall_header.html -->

<p>{TOTAL_GUEST_USERS_ONLINE}<!-- IF S_SWITCH_GUEST_DISPLAY --> &bull; <a href="{U_SWITCH_GUEST_DISPLAY}">{L_SWITCH_GUEST_DISPLAY}</a><!-- ENDIF --></p>

<ul class="linklist">

<!-- INCLUDE simple_header.html -->

<div class="panel">

<div class="inner">

<!-- INCLUDE overall_header.html -->

<!-- IF U_MCP or U_ACP --><p class="responsive-center">[&nbsp;<!-- IF U_ACP --><a href="{U_ACP}" title="{L_ACP}" data-responsive-text="{L_ACP_SHORT}">{L_ACP}</a><!-- IF U_MCP -->&nbsp;|&nbsp;<!-- ENDIF --><!-- ENDIF --><!-- IF U_MCP --><a href="{U_MCP}" title="{L_MCP}" data-responsive-text="{L_MCP_SHORT}">{L_MCP}</a><!-- ENDIF -->&nbsp;]</p><!-- ENDIF -->

<!-- NOTE: remove the style="display: none" when you want to have the forum description on the topic body -->

<!-- IF FORUM_DESC --><div style="display: none !important;">{FORUM_DESC}<br /></div><!-- ENDIF -->

<div class="inner">

<div class="content">

<p class="author">{L_POLL_LENGTH}<!-- IF S_CAN_VOTE and L_POLL_LENGTH --><br /><!-- ENDIF --><!-- IF S_CAN_VOTE --><span class="poll_max_votes">{L_MAX_VOTES}</span><!-- ENDIF --></p>

<fieldset class="polls">

<!-- BEGIN poll_option -->

<dt><!-- IF S_CAN_VOTE --><label for="vote_{poll_option.POLL_OPTION_ID}">{poll_option.POLL_OPTION_CAPTION}</label><!-- ELSE -->{poll_option.POLL_OPTION_CAPTION}<!-- ENDIF --></dt>

<!-- IF S_CAN_VOTE --><dd style="width: auto;" class="poll_option_select"><!-- IF S_IS_MULTI_CHOICE --><input type="checkbox" name="vote_id[]" id="vote_{poll_option.POLL_OPTION_ID}" value="{poll_option.POLL_OPTION_ID}"<!-- IF poll_option.POLL_OPTION_VOTED --> checked="checked"<!-- ENDIF --> /><!-- ELSE --><input type="radio" name="vote_id[]" id="vote_{poll_option.POLL_OPTION_ID}" value="{poll_option.POLL_OPTION_ID}"<!-- IF poll_option.POLL_OPTION_VOTED --> checked="checked"<!-- ENDIF --> /><!-- ENDIF --></dd><!-- ENDIF -->

<dd class="resultbar<!-- IF not S_DISPLAY_RESULTS --> hidden<!-- ENDIF -->"><div class="<!-- IF poll_option.POLL_OPTION_PCT < 20 -->pollbar1<!-- ELSEIF poll_option.POLL_OPTION_PCT < 40 -->pollbar2<!-- ELSEIF poll_option.POLL_OPTION_PCT < 60 -->pollbar3<!-- ELSEIF poll_option.POLL_OPTION_PCT < 80 -->pollbar4<!-- ELSE -->pollbar5<!-- ENDIF -->" style="width:{poll_option.POLL_OPTION_PERCENT_REL};">{poll_option.POLL_OPTION_RESULT}</div></dd>

<div class="dropdown-container dropdown-button-control topic-tools">

<span title="{L_TOPIC_TOOLS}" class="dropdown-trigger dropdown-select dropdown-select-icon tools-icon"><span></span></span>

<div class="dropdown hidden">

</li>

<!-- ENDIF -->

<!-- IF U_BUMP_TOPIC --><li class="small-icon icon-bump"><a href="{U_BUMP_TOPIC}" title="{L_BUMP_TOPIC}" data-ajax="true">{L_BUMP_TOPIC}</a></li><!-- ENDIF -->

<!-- IF S_HAS_ATTACHMENTS -->

<li class="small-icon icon-download">

<a class="dropdown-toggle-submenu" href="{U_DOWNLOAD_ALL_ATTACHMENTS}" title="{L_DOWNLOAD_ALL_ATTACHMENTS}">{L_DOWNLOAD_ALL_ATTACHMENTS}</a>

margin: 0 1px 0 5px;

}

/* Icon images

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

.rtl .small-icon {

.dropdown-visible .dropdown-select.tools-icon:before,

.nojs .dropdown-container:hover .dropdown-select.tools-icon:before { background-position: -80px -20px; }

/* Icon images

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

.small-icon {

Colours and backgrounds for buttons.css

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

.buttons div a, .dropdown-select {

border-color: #C7C3BF;

background-color: #FFFFFF;

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

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

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

/* Profile & navigation icons */

.email-icon, .email-icon a { background-image: url("./images/icon_contact_email.gif"); }

}

ul.linklist.bulletin li:first-child:before, ul.linklist.bulletin li.rightside:last-child:before {

}

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

}

.responsive-menu:before {

/* Responsive breadcrumbs

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

.breadcrumbs .crumb {

word-wrap: normal;

}

.breadcrumbs .crumb a {

display: inline-block;

white-space: nowrap;

.dropdown-extended .footer {

text-align: center;

}

.dropdown-extended ul li a, .notification_list dt > a, .dropdown-extended .footer > a {

.notification_list ul li p {

margin: 0;

}

.notification_list div.notifications {

input.inputbox { width: 85%; }

input.medium { width: 50%; }

input.narrow { width: 25%; }

textarea.inputbox {

width: 85%;

<!-- BEGIN poll_option -->

<tr>

<!-- IF S_CAN_VOTE -->

<!-- IF S_IS_MULTI_CHOICE -->

<input type="checkbox" class="radio" name="vote_id[]" value="{poll_option.POLL_OPTION_ID}"<!-- IF poll_option.POLL_OPTION_VOTED --> checked="checked"<!-- ENDIF --> />

<!-- ELSE -->

$option_pct_txt = sprintf("%.1d%%", round($option_pct * 100));

$option_pct_rel = ($poll_most > 0) ? $poll_option['poll_option_total'] / $poll_most : 0;

$option_pct_rel_txt = sprintf("%.1d%%", round($option_pct_rel * 100));

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

'POLL_OPTION_ID' => $poll_option['poll_option_id'],

'POLL_OPTION_PCT' => round($option_pct * 100),

'POLL_OPTION_WIDTH' => round($option_pct * 250),

'POLL_OPTION_VOTED' => (in_array($poll_option['poll_option_id'], $cur_voted_id)) ? true : false,

));

}

* You can use this event to modify the page title of the viewtopic page

*

* @event core.viewtopic_modify_page_title

* @var array topic_data Array with topic data

* @var int forum_id Forum ID of the topic

* @var int start Start offset used to calculate the page

class phpbb_dbal_db_tools_test extends phpbb_database_test_case

{

protected $db;

protected $tools;

protected $table_exists;

protected $table_data;

$this->assertFalse($this->tools->sql_column_exists('prefix_table_name', 'column_does_not_exist'));

}

public function test_column_remove()

{

$this->assertTrue($this->tools->sql_column_exists('prefix_table_name', 'c_int_size'));

$this->assertFalse($this->tools->sql_column_exists('prefix_table_name', 'c_int_size'));

}

public function test_column_remove_primary()

{

$this->assertTrue($this->tools->sql_column_exists('prefix_table_name', 'c_id'));

$this->assertFalse($this->tools->sql_table_exists('prefix_test_table'));

}

{

$db_tools = $this->getMock('\phpbb\db\tools', array(

'sql_table_exists',

));

}

{

$db_tools = $this->getMock('\phpbb\db\tools', array(

'sql_column_exists',

{

return array(

array('config.add', array('foobartest', 0)),

);

}

}

public function test_revert()

{

// Make sure there are no other migrations in the db, this could cause issues

$this->db->sql_query("DELETE FROM phpbb_migrations");

$this->migrator->load_migration_state();

$this->migrator->set_migrations(array('phpbb_dbal_migration_revert', 'phpbb_dbal_migration_revert_with_dependency'));

$this->assertFalse($this->migrator->migration_state('phpbb_dbal_migration_revert'));

{

$this->fail('Revert did not remove test_column.');

}

}

public function test_fail()

<value>LOG_USER</value>

<value>a:1:{i:0;s:5:"guest";}</value>

</row>

</table>

<table name="phpbb_users">

<column>user_id</column>

'viewforum' => '',

'action' => 'LOG_USER guest',

),

);

$test_cases = array(

'user', 0, 5, 0, 0, 0, 2,

),

array(

'expected_returned' => 0,

'users', 0,

),

);

foreach ($test_cases as $case => $case_data)

'LOG_INSTALL_INSTALLED' => 'installed: %s',

'LOG_USER' => 'User<br /> %s',

'LOG_MOD2' => 'Mod2',

);

$phpbb_log = new \phpbb\log\log($db, $user, $auth, $phpbb_dispatcher, $phpbb_root_path, 'adm/', $phpEx, LOG_TABLE);

array(),

'event_loop0|event_loop1|event_loop2',

),

);

}

/**

* @dataProvider template_data

*/

{

// Reset the engine state

$this->setup_engine_for_events($dataset, $style_names);

array(),

"barbarbar1bar1",

),

/* Does not pass with the current implementation.

array(

'loop_reuse.html',

/**

* @dataProvider template_data

*/

{

$this->run_template($file, $vars, $block_vars, $destroy, $expected, $lang_vars);

}

class phpbb_database_test_connection_manager

{

private $config;

private $dbms;

private $pdo;

/**

$table_name,

$table_data

);

foreach ($queries as $query)

{

}

}

}

}

else

{

'style_id' => $style_id,

'style_name' => $style_path,

'style_copyright' => '',

'bbcode_bitfield' => 'kNg=',

'style_parent_id' => $parent_style_id,

'style_parent_tree' => $parent_style_path,

}

}

'user_email' => 'nobody@example.com',

'user_type' => 0,

'user_lang' => 'en',

'user_password' => $passwords_manager->hash($username . $username),

);

return user_add($user_row);