+ /** @var \phpbb\db\driver\driver_interface */

+ 'REAL_FILENAME' => (!$row['in_message']) ? utf8_basename((string) $row['real_filename']) : '',

+ * @param $stats array Array of config key => value pairs to set.

+ * @param $resync bool Resync stats if they're incorrect.

+ $total_size = (float) $this->config['upload_dir_size'];

+ $u_resync = $this->u_action . '&action=stats';

+

+ return $this->user->lang(

+ 'FILES_STATS_WRONG',

+ (int) $stats['num_files'],

+ get_formatted_filesize($stats['upload_dir_size']),

+ '<a href="' . $u_resync . '">',

+ '</a>'

+ );

+

+

+ $vars = array(

+ 'action',

+ 'sql_ary',

+ 'bbcode_id',

+ 'display_on_posting',

+ 'bbcode_match',

+ 'bbcode_tpl',

+ 'bbcode_helpline',

+ 'hidden_fields',

+ );

+

+ global $cache, $phpbb_container, $phpbb_dispatcher;

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

+ 'auth_method' => array('lang' => 'AUTH_METHOD', 'validate' => 'string', 'type' => 'select:1:toggable', 'method' => 'select_auth_method', 'explain' => false),

+ 'board_contact_name' => array('lang' => 'CONTACT_EMAIL_NAME', 'validate' => 'string', 'type' => 'text:25:50', 'explain' => true),

+ /**

+ * Event to add and/or modify acp_board configurations

+ *

+ * @event core.acp_board_config_edit_add

+ * @var array display_vars Array of config values to display and process

+ * @var string mode Mode of the config page we are displaying

+ * @var boolean submit Do we display the form or process the submission

+ * @since 3.1.0-a4

+ */

+ $vars = array('display_vars', 'mode', 'submit');

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

+

+ $auth_select .= "<option value=\"$method\"$selected data-toggle-setting=\"#auth_{$method}_settings\">" . ucfirst($method) . '</option>';

+

+

+

+

+

+

+

+

+

+

+

+

+

+ case 'sqlite3':

+ $extractor = new sqlite3_extractor($format, $filename, $time, $download, $store);

+ break;

+

+ case 'sqlite3':

+ case 'sqlite3':

+class sqlite3_extractor extends base_extractor

+{

+ function write_start($prefix)

+ {

+ $sql_data = "--\n";

+ $sql_data .= "-- phpBB Backup Script\n";

+ $sql_data .= "-- Dump of tables for $prefix\n";

+ $sql_data .= "-- DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

+ $sql_data .= "--\n";

+ $sql_data .= "BEGIN TRANSACTION;\n";

+ $this->flush($sql_data);

+ }

+

+ function write_table($table_name)

+ {

+ global $db;

+ $sql_data = '-- Table: ' . $table_name . "\n";

+ $sql_data .= "DROP TABLE $table_name;\n";

+

+ $sql = "SELECT sql

+ FROM sqlite_master

+ WHERE type = 'table'

+ AND name = '" . $db->sql_escape($table_name) . "'

+ ORDER BY name ASC;";

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

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

+ $db->sql_freeresult($result);

+

+ // Create Table

+ $sql_data .= $row['sql'] . ";\n";

+

+ $result = $db->sql_query("PRAGMA index_list('" . $db->sql_escape($table_name) . "');");

+

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

+ {

+ if (strpos($row['name'], 'autoindex') !== false)

+ {

+ continue;

+ }

+

+ $result2 = $db->sql_query("PRAGMA index_info('" . $db->sql_escape($row['name']) . "');");

+

+ $fields = array();

+ while ($row2 = $db->sql_fetchrow($result2))

+ {

+ $fields[] = $row2['name'];

+ }

+ $db->sql_freeresult($result2);

+

+ $sql_data .= 'CREATE ' . ($row['unique'] ? 'UNIQUE ' : '') . 'INDEX ' . $row['name'] . ' ON ' . $table_name . ' (' . implode(', ', $fields) . ");\n";

+ }

+ $db->sql_freeresult($result);

+

+ $this->flush($sql_data . "\n");

+ }

+

+ function write_data($table_name)

+ {

+ global $db;

+

+ $result = $db->sql_query("PRAGMA table_info('" . $db->sql_escape($table_name) . "');");

+

+ $col_types = array();

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

+ {

+ $col_types[$row['name']] = $row['type'];

+ }

+ $db->sql_freeresult($result);

+

+ $sql_insert = 'INSERT INTO ' . $table_name . ' (' . implode(', ', array_keys($col_types)) . ') VALUES (';

+

+ $sql = "SELECT *

+ FROM $table_name";

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

+

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

+ {

+ foreach ($row as $column_name => $column_data)

+ {

+ if (is_null($column_data))

+ {

+ $row[$column_name] = 'NULL';

+ }

+ else if ($column_data === '')

+ {

+ $row[$column_name] = "''";

+ }

+ else if (stripos($col_types[$column_name], 'text') !== false || stripos($col_types[$column_name], 'char') !== false || stripos($col_types[$column_name], 'blob') !== false)

+ {

+ $row[$column_name] = sanitize_data_generic(str_replace("'", "''", $column_data));

+ }

+ }

+ $this->flush($sql_insert . implode(', ', $row) . ");\n");

+ }

+ }

+

+ function write_end()

+ {

+ $this->flush("COMMIT;\n");

+ parent::write_end();

+ }

+}

+

+/**

+* @package acp

+*/

+ $enabled_extension_meta_data = array();

+

+ $enabled_extension_meta_data[$name] = $md_manager->get_metadata('display-name');

+

+ natcasesort($enabled_extension_meta_data);

+

+ foreach ($enabled_extension_meta_data as $name => $display_name)

+ {

+ $this->template->assign_block_vars('enabled', array(

+ 'META_DISPLAY_NAME' => $display_name,

+

+ 'U_DETAILS' => $this->u_action . '&amp;action=details&amp;ext_name=' . urlencode($name),

+ ));

+

+ $this->output_actions('enabled', array(

+ 'DISABLE' => $this->u_action . '&amp;action=disable_pre&amp;ext_name=' . urlencode($name),

+ ));

+ }

+ $disabled_extension_meta_data = array();

+

+ $disabled_extension_meta_data[$name] = $md_manager->get_metadata('display-name');

+

+ natcasesort($disabled_extension_meta_data);

+

+ foreach ($disabled_extension_meta_data as $name => $display_name)

+ {

+ $this->template->assign_block_vars('disabled', array(

+ 'META_DISPLAY_NAME' => $display_name,

+

+ 'U_DETAILS' => $this->u_action . '&amp;action=details&amp;ext_name=' . urlencode($name),

+ ));

+

+ $this->output_actions('disabled', array(

+ 'ENABLE' => $this->u_action . '&amp;action=enable_pre&amp;ext_name=' . urlencode($name),

+ 'DELETE_DATA' => $this->u_action . '&amp;action=delete_data_pre&amp;ext_name=' . urlencode($name),

+ ));

+ }

+ $available_extension_meta_data = array();

+

+ $available_extension_meta_data[$name] = $md_manager->get_metadata('display-name');

+

+ natcasesort($available_extension_meta_data);

+

+ foreach ($available_extension_meta_data as $name => $display_name)

+ {

+ $this->template->assign_block_vars('disabled', array(

+ 'META_DISPLAY_NAME' => $display_name,

+

+ 'U_DETAILS' => $this->u_action . '&amp;action=details&amp;ext_name=' . urlencode($name),

+ ));

+

+ $this->output_actions('disabled', array(

+ 'ENABLE' => $this->u_action . '&amp;action=enable_pre&amp;ext_name=' . urlencode($name),

+ ));

+ }

+ 'enable_shadow_prune' => request_var('enable_shadow_prune', false),

+ 'prune_shadow_days' => request_var('prune_shadow_days', 7),

+ 'prune_shadow_freq' => request_var('prune_shadow_freq', 1),

+ * @since 3.1.0-a1

+ 'enable_shadow_prune' => false,

+ 'prune_shadow_days' => 7,

+ 'prune_shadow_freq' => 1,

+ * @since 3.1.0-a1

+ 'PRUNE_SHADOW_FREQ' => $forum_data['prune_shadow_freq'],

+ 'PRUNE_SHADOW_DAYS' => $forum_data['prune_shadow_days'],

+ 'S_PRUNE_SHADOW_ENABLE' => ($forum_data['enable_shadow_prune']) ? true : false,

+ * @since 3.1.0-a1

+ $vars = array(

+ 'action',

+ 'update',

+ 'forum_id',

+ 'row',

+ 'forum_data',

+ 'parents_list',

+ 'errors',

+ 'template_data',

+ );

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ group_user_attributes('default', $group_id, $mark_ary, false, $group_name, $group_row);

+ case 'sqlite3':

+

+

+

+ global $phpbb_root_path, $phpbb_admin_path, $phpEx, $phpbb_container;

+ $perm_from = get_username_string('full', $user_row['user_id'], $user_row['username'], $user_row['user_colour']);

+ case 'sqlite3':

+ $config->increment('assets_version', 1);

+ case 'sqlite3':

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

+ try

+ $recheck = $request->variable('versioncheck_force', false);

+ $updates_available = $version_helper->get_suggested_updates($recheck);

+

+ $template->assign_var('S_VERSION_UP_TO_DATE', empty($updates_available));

+ catch (\RuntimeException $e)

+ 'S_VERSIONCHECK_FAIL' => true,

+ 'VERSIONCHECK_FAIL_REASON' => ($e->getMessage() !== $user->lang('VERSIONCHECK_FAIL')) ? $e->getMessage() : '',

+ {

+

+ case 'sqlite3':

+ 'field_is_contact' => 0,

+ 'field_contact_desc'=> '',

+ 'field_contact_url' => '',

+ 1 => array('field_ident', 'lang_name', 'lang_explain', 'field_option_none', 'field_show_on_reg', 'field_show_on_pm', 'field_show_on_vt', 'field_show_on_ml', 'field_required', 'field_show_novalue', 'field_hide', 'field_show_profile', 'field_no_view', 'field_is_contact', 'field_contact_desc', 'field_contact_url'),

+ 'field_is_contact',

+ $cp->vars['lang_name'] = $request->variable('lang_name', $field_row['lang_name'], true);

+ $cp->vars['lang_explain'] = $request->variable('lang_explain', $field_row['lang_explain'], true);

+ $cp->vars['lang_default_value'] = $request->variable('lang_default_value', $field_row['lang_default_value'], true);

+ $cp->vars['field_contact_desc'] = $request->variable('field_contact_desc', $field_row['field_contact_desc'], true);

+ $cp->vars['field_contact_url'] = $request->variable('field_contact_url', $field_row['field_contact_url'], true);

+ $cp->vars[$val] = ($submit || $save) ? $request->variable($val, 0) : $field_row[$val];

+ $cp->vars['field_no_view'] = $request->variable('field_no_view', (int) $field_row['field_no_view']);

+ 'S_FIELD_CONTACT' => $cp->vars['field_is_contact'],

+ 'FIELD_CONTACT_DESC'=> $cp->vars['field_contact_desc'],

+ 'FIELD_CONTACT_URL' => $cp->vars['field_contact_url'],

+ 'field_no_view' => $cp->vars['field_no_view'],

+ 'field_is_contact' => $cp->vars['field_is_contact'],

+ 'field_contact_desc' => $cp->vars['field_contact_desc'],

+ 'field_contact_url' => $cp->vars['field_contact_url'],

+ case 'sqlite3':

+ if (version_compare($db->sql_server_info(true), '3.0') == -1)

+

+

+

+

+

+

+ 'U_PROFILE' => get_username_string('profile', $user_id, $usernames[$user_id]),

+ }

+ AND ' . $db->sql_in_set('p.post_visibility', array(ITEM_UNAPPROVED, ITEM_REAPPROVE)) . '

+ case 'sqlite3':

+ $identifier = substr($type, strrpos($type, '\\') + 1);

+ $search_options .= "<option value=\"$type\"$selected data-toggle-setting=\"#search_{$identifier}_settings\">$name</option>";

+ 'NAME' => $name,

+ 'SETTINGS' => $vars['tpl'],

+ 'IDENTIFIER' => $identifier,

+ ));

+ $this->config->increment('assets_version', 1);

+ // Show page title

+ $this->welcome_message('ACP_STYLES', null);

+

+ global $config, $user, $template, $request;

+ global $phpbb_root_path, $phpEx, $phpbb_container;

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

+ try

+ $recheck = $request->variable('versioncheck_force', false);

+ $updates_available = $version_helper->get_suggested_updates($recheck);

+ catch (\RuntimeException $e)

+ {

+ $template->assign_var('S_VERSIONCHECK_FAIL', true);

+ $updates_available = array();

+ }

+ foreach ($updates_available as $branch => $version_data)

+ $template->assign_block_vars('updates_available', $version_data);

+ $update_link = append_sid($phpbb_root_path . 'install/index.' . $phpEx, 'mode=update');

+ 'S_UP_TO_DATE' => empty($updates_available),

+ 'U_ACTION' => $this->u_action,

+ 'U_VERSIONCHECK_FORCE' => append_sid($this->u_action . '&amp;versioncheck_force=1'),

+ 'CURRENT_VERSION' => $config['version'],

+ 'UPDATE_INSTRUCTIONS' => sprintf($user->lang['UPDATE_INSTRUCTIONS'], $update_link),

+ $this->page_title = $user_row['username'] . ' :: ' . $user->lang('ACP_USER_' . strtoupper($mode));

+

+ if ($delete)

+ // Founders can not be deleted.

+ if ($user_row['user_type'] == USER_FOUNDER)

+ {

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

+ }

+

+ && $topic_id_ary[$row['topic_id']][ITEM_REAPPROVE] == $row['topic_posts_unapproved']

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ $last_active = (!empty($user_row['session_time'])) ? $user_row['session_time'] : $user_row['user_lastvisit'];

+ AND ' . $db->sql_in_set('post_visibility', array(ITEM_UNAPPROVED, ITEM_REAPPROVE));

+ 'U_SEARCH_USER' => ($config['load_search'] && $auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", "author_id={$user_row['user_id']}&amp;sr=posts") : '',

+ 'USER_LASTACTIVE' => ($last_active) ? $user->format_date($last_active) : ' - ',

+ if ($log_warnings)

+ add_log('admin', 'LOG_WARNINGS_DELETED', $user_row['username'], $num_warnings);

+ }

+ else

+ {

+ add_log('admin', 'LOG_WARNINGS_DELETED_ALL', $user_row['username']);

+ /**

+ * Modify users preferences data

+ *

+ * @event core.acp_users_prefs_modify_data

+ * @var array data Array with users preferences data

+ * @var array user_row Array with user data

+ * @since 3.1.0-b3

+ */

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

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

+

+ /**

+ * Modify SQL query before users preferences are updated

+ *

+ * @event core.acp_users_prefs_modify_sql

+ * @var array data Array with users preferences data

+ * @var array user_row Array with user data

+ * @var array sql_ary SQL array with users preferences data to update

+ * @var array error Array with errors data

+ * @since 3.1.0-b3

+ */

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

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

+ if (!sizeof($error))

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "

+ WHERE user_id = $user_id";

+ $db->sql_query($sql);

+

+ // Check if user has an active session

+ if ($user_row['session_id'])

+ // We'll update the session if user_allow_viewonline has changed and the user is a bot

+ // Or if it's a regular user and the admin set it to hide the session

+ if ($user_row['user_allow_viewonline'] != $sql_ary['user_allow_viewonline'] && $user_row['user_type'] == USER_IGNORE

+ || $user_row['user_allow_viewonline'] && !$sql_ary['user_allow_viewonline'])

+ {

+ // We also need to check if the user has the permission to cloak.

+ $user_auth = new \phpbb\auth\auth();

+ $user_auth->acl($user_row);

+ $session_sql_ary = array(

+ 'session_viewonline' => ($user_auth->acl_get('u_hideonline')) ? $sql_ary['user_allow_viewonline'] : true,

+ );

+ $sql = 'UPDATE ' . SESSIONS_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', $session_sql_ary) . "

+ WHERE session_user_id = $user_id";

+ $db->sql_query($sql);

+ unset($user_auth);

+ }

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

+ }

+ $user_prefs_data = array(

+ /**

+ * Modify users preferences data before assigning it to the template

+ *

+ * @event core.acp_users_prefs_modify_template_data

+ * @var array data Array with users preferences data

+ * @var array user_row Array with user data

+ * @var array user_prefs_data Array with users preferences data to be assigned to the template

+ * @since 3.1.0-b3

+ */

+ $vars = array('data', 'user_row', 'user_prefs_data');

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

+

+ $template->assign_vars($user_prefs_data);

+

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

+

+ 'USERNAME' => get_username_string('username', $row['user_id'], $row['username']),

+ 'U_PROFILE' => get_username_string('profile', $row['user_id'], $row['username']),

+ ));

+ 'users' => array('title' => 'ACP_PRUNE_USERS', 'auth' => 'acl_a_userdel', 'cat' => array('ACP_CAT_USERS')),

+ 'img' => '<img src="$1" class="postimage" alt="' . $user->lang['IMAGE'] . '" />',

+

+

+ $amp_y = mt_rand(2,4);

+

+

+ {

+

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

+

+ $rgb = $this->model_convert($colour, $mode, 'rgb');

+ $store = ($this->mode == 'rgb') ? $rgb : $this->model_convert($colour, $mode, $this->mode);

+ $colour = $this->model_convert($this->colours[$resource], $this->mode, $mode);

+ $colour = $this->model_convert($this->colours[$resource], $this->mode, $mode);

+

+ return $this->ah2h($colour);

+ return $this->rgb2hsv($colour);

+ return $this->h2ah($colour);

+ return $this->h2ah($this->rgb2hsv($colour));

+ return $this->hsv2rgb($colour);

+ return $this->hsv2rgb($this->ah2h($colour));

+ $this->normalize_hue($hsv[0]);

+ $this->normalize_hue($h);

+ $ahue[0] = $this->ah2h($ahue[0]);

+ $this->normalize_hue($ahue);

+ $hue[0] = $this->h2ah($hue[0]);

+ $this->normalize_hue($hue);

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

+/**

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+// set up caching

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

+

+// Instantiate some basic classes

+$phpbb_dispatcher = $phpbb_container->get('dispatcher');

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

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

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

+$db = $phpbb_container->get('dbal.conn');

+

+// make sure request_var uses this request instance

+request_var('', 0, false, false, $request); // "dependency injection" for a function

+

+// Grab global variables, re-cache if necessary

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

+set_config(null, null, null, $config);

+set_config_count(null, null, null, $config);

+

+$phpbb_log = $phpbb_container->get('log');

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

+$phpbb_filesystem = $phpbb_container->get('filesystem');

+$phpbb_path_helper = $phpbb_container->get('path_helper');

+

+// load extensions

+$phpbb_extension_manager = $phpbb_container->get('ext.manager');

+$phpbb_subscriber_loader = $phpbb_container->get('event.subscriber_loader');

+

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

+define('PHPBB_VERSION', '3.1.0-b4-dev');

+define('INACTIVE_REGISTER', 1); // Newly registered account

+define('INACTIVE_PROFILE', 2); // Profile details changed

+define('INACTIVE_MANUAL', 3); // Account deactivated by administrator

+define('INACTIVE_REMIND', 4); // Forced user account reactivation

+define('ITEM_REAPPROVE', 3); // => has been edited and needs to be re-approved

+ * @since 3.1.0-a1

+ global $config, $user, $phpbb_path_helper;

+ $php_ext = $phpbb_path_helper->get_php_ext();

+ // Remove 'app.php/' from the page, when rewrite is enabled

+ if ($config['enable_mod_rewrite'] && strpos($page, 'app.' . $php_ext . '/') === 0)

+ {

+ $page = substr($page, strlen('app.' . $php_ext . '/'));

+ }

+

+ $page = $phpbb_path_helper->get_phpbb_root_path() . $page;

+ if ($strip_vars !== false)

+ $redirect = $phpbb_path_helper->strip_url_params($redirect, $strip_vars, false);

+ else

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

+ return $redirect . ((strpos($redirect, '?') === false) ? '?' : '');

+ $url = redirect($url, true, $disable_cd_check);

+ 'url' => $url,

+ // For XHTML compatibility we change back & to &amp;

+ page_header((!isset($user->lang[$title])) ? $user->lang['CONFIRM'] : $user->lang[$title]);

+ page_header($user->lang['LOGIN']);

+ page_header($user->lang['LOGIN']);

+ $key = htmlspecialchars(strtolower(trim(substr($line, 0, $delim_pos))));

+ $value = htmlspecialchars(substr($value, 1, sizeof($value)-2));

+ }

+ else

+ {

+ $value = htmlspecialchars($value);

+

+ // If this is defined there already was some output

+ // So let's not break it

+ if (defined('IN_DB_UPDATE'))

+ {

+ echo '<div class="errorbox">' . $msg_text . '</div>';

+

+ $db->sql_return_on_error(true);

+ phpbb_end_update($cache, $config);

+ }

+ page_header($msg_title);

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

+* Get user avatar

+*

+* @param array $user_row Row from the users table

+* @param string $alt Optional language string for alt tag within image, can be a language key or text

+* @param bool $ignore_config Ignores the config-setting, to be still able to view the avatar in the UCP

+*

+* @return string Avatar html

+*/

+function phpbb_get_user_avatar($user_row, $alt = 'USER_AVATAR', $ignore_config = false)

+{

+ $row = \phpbb\avatar\manager::clean_row($user_row, 'user');

+ return phpbb_get_avatar($row, $alt, $ignore_config);

+}

+

+/**

+* Get group avatar

+*

+* @param array $group_row Row from the groups table

+* @param string $alt Optional language string for alt tag within image, can be a language key or text

+* @param bool $ignore_config Ignores the config-setting, to be still able to view the avatar in the UCP

+*

+* @return string Avatar html

+*/

+function phpbb_get_group_avatar($user_row, $alt = 'GROUP_AVATAR', $ignore_config = false)

+{

+ $row = \phpbb\avatar\manager::clean_row($user_row, 'group');

+ return phpbb_get_avatar($row, $alt, $ignore_config);

+}

+

+/**

+* Get avatar

+*

+* @param array $row Row cleaned by \phpbb\avatar\driver\driver::clean_row

+* @param string $alt Optional language string for alt tag within image, can be a language key or text

+* @param bool $ignore_config Ignores the config-setting, to be still able to view the avatar in the UCP

+*

+* @return string Avatar html

+*/

+function phpbb_get_avatar($row, $alt, $ignore_config = false)

+{

+ global $user, $config, $cache, $phpbb_root_path, $phpEx;

+ global $request;

+ global $phpbb_container;

+

+ if (!$config['allow_avatar'] && !$ignore_config)

+ {

+ return '';

+ }

+

+ $avatar_data = array(

+ 'src' => $row['avatar'],

+ 'width' => $row['avatar_width'],

+ 'height' => $row['avatar_height'],

+ );

+

+ $phpbb_avatar_manager = $phpbb_container->get('avatar.manager');

+ $driver = $phpbb_avatar_manager->get_driver($row['avatar_type'], $ignore_config);

+ $html = '';

+

+ if ($driver)

+ {

+ $html = $driver->get_custom_html($user, $row, $alt);

+ if (!empty($html))

+ {

+ return $html;

+ }

+

+ $avatar_data = $driver->get_data($row, $ignore_config);

+ }

+ else

+ {

+ $avatar_data['src'] = '';

+ }

+

+ if (!empty($avatar_data['src']))

+ {

+ $html = '<img src="' . $avatar_data['src'] . '" ' .

+ ($avatar_data['width'] ? ('width="' . $avatar_data['width'] . '" ') : '') .

+ ($avatar_data['height'] ? ('height="' . $avatar_data['height'] . '" ') : '') .

+ 'alt="' . ((!empty($user->lang[$alt])) ? $user->lang[$alt] : $alt) . '" />';

+ }

+

+ return $html;

+}

+

+/**

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

+ * @since 3.1.0-a1

+ $l_login_logout = $user->lang['LOGOUT'];

+ 'PRIVATE_MESSAGE_COUNT' => (!empty($user->data['user_unread_privmsg'])) ? $user->data['user_unread_privmsg'] : 0,

+ 'CURRENT_USER_AVATAR' => phpbb_get_user_avatar($user->data),

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

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

+ 'U_TEAM' => ($user->data['user_id'] != ANONYMOUS && !$auth->acl_get('u_viewprofile')) ? '' : append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=team'),

+ 'S_LOGIN_REDIRECT' => build_hidden_fields(array('redirect' => $phpbb_path_helper->remove_web_root_path(build_url()))),

+ 'T_JQUERY_LINK' => !empty($config['allow_cdn']) && !empty($config['load_jquery_url']) ? $config['load_jquery_url'] : "{$web_path}assets/javascript/jquery.min.js?assets_version=" . $config['assets_version'],

+ /**

+ * Execute code and/or overwrite _common_ template variables after they have been assigned.

+ *

+ * @event core.page_header_after

+ * @var string page_title Page title

+ * @var bool display_online_list Do we display online users list

+ * @var string item Restrict online users to a certain

+ * session item, e.g. forum for

+ * session_forum_id

+ * @var int item_id Restrict online users to item id

+ *

+ * @since 3.1.0-b3

+ */

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

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

+

+ * @since 3.1.0-a1

+ if (!defined('IN_CRON') && !$config['use_system_cron'] && $run_cron && !$config['board_disable'] && !$user->data['is_bot'] && !$cache->get('cron.lock_check'))

+ global $phpbb_container;

+ $cron = $phpbb_container->get('cron.manager');

+ else

+ {

+ $cache->put('cron.lock_check', true, 300);

+ }

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ 'T_JQUERY_LINK' => !empty($config['allow_cdn']) && !empty($config['load_jquery_url']) ? $config['load_jquery_url'] : "{$phpbb_root_path}assets/javascript/jquery.min.js",

+ $data_toggle = (!empty($tpl_type[2])) ? ' data-togglable-settings="true"' : '';

+ $tpl = '<select id="' . $key . '" name="' . $name . '"' . (($size > 1) ? ' size="' . $size . '"' : '') . $data_toggle . '>' . $return . '</select>';

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ global $db, $config, $phpbb_root_path, $phpEx, $auth, $user, $phpbb_container, $phpbb_dispatcher;

+

+ // 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 string where_type Variable containing posts deletion mode

+ * @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 bool post_count_sync Flag indicating if posts count should be resynchronized

+ * @var bool call_delete_topics Flag indicating if topics having no posts should be deleted

+ * @var array delete_notifications_types Array with notifications types to delete

+ * @since 3.1.0-a4

+ */

+ $vars = array(

+ 'where_type',

+ 'where_ids',

+ 'auto_sync',

+ 'posted_sync',

+ 'post_count_sync',

+ 'call_delete_topics',

+ 'delete_notifications_types',

+ );

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

+ /**

+ * Perform additional actions during post(s) deletion

+ *

+ * @event core.delete_posts_in_transaction

+ * @var array post_ids Array with deleted posts' ids

+ * @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 string where_type Variable containing posts deletion mode

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

+ */

+ $vars = array(

+ 'post_ids',

+ 'poster_ids',

+ 'topic_ids',

+ 'forum_ids',

+ 'where_type',

+ 'where_ids',

+ 'delete_notifications_types',

+ );

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

+

+ /**

+ * Perform additional actions after post(s) deletion

+ *

+ * @event core.delete_posts_after

+ * @var array post_ids Array with deleted posts' ids

+ * @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 string where_type Variable containing posts deletion mode

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

+ */

+ $vars = array(

+ 'post_ids',

+ 'poster_ids',

+ 'topic_ids',

+ 'forum_ids',

+ 'where_type',

+ 'where_ids',

+ 'delete_notifications_types',

+ );

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

+

+ $phpbb_notifications->delete_notifications($delete_notifications_types, $post_ids);

+ foreach ($update_ary as $visibility => $sql_where)

+ else if ($row['topic_visibility'] == ITEM_UNAPPROVED || $row['topic_visibility'] == ITEM_REAPPROVE)

+ else if ($row['post_visibility'] == ITEM_UNAPPROVED || $row['post_visibility'] == ITEM_REAPPROVE)

+ if ($topic_data[$topic_id]['visibility'] == ITEM_UNAPPROVED || $topic_data[$topic_id]['visibility'] == ITEM_REAPPROVE)

+ if ($prune_mode == 'shadow')

+ {

+ $sql_and .= ' AND topic_status = ' . ITEM_MOVED . " AND topic_last_post_time < $prune_date";

+ }

+

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

+ case 'sqlite3':

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

+ case 'sqlite3':

+ $sql = 'SELECT @@VERSION AS mssql_version';

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

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

+ $db->sql_freeresult($result);

+

+

+ if ($row)

+ {

+ // Azure stats are stored elsewhere

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

+ {

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

+ FROM sys.dm_db_partition_stats';

+ }

+ }

+

+/*

+ return phpbb_get_avatar($row, $alt, $ignore_config);

+}

+

+/**

+* Hash the password

+*

+* @deprecated 3.1.0-a2 (To be removed: 3.3.0)

+*

+* @param string $password Password to be hashed

+*

+* @return string|bool Password hash or false if something went wrong during hashing

+*/

+function phpbb_hash($password)

+{

+ global $phpbb_container;

+

+ $passwords_manager = $phpbb_container->get('passwords.manager');

+ return $passwords_manager->hash($password);

+}

+

+/**

+* Check for correct password

+*

+* @deprecated 3.1.0-a2 (To be removed: 3.3.0)

+*

+* @param string $password The password in plain text

+* @param string $hash The stored password hash

+*

+* @return bool Returns true if the password is correct, false if not.

+*/

+function phpbb_check_hash($password, $hash)

+{

+ global $phpbb_container;

+

+ $passwords_manager = $phpbb_container->get('passwords.manager');

+ return $passwords_manager->check($password, $hash);

+}

+

+/**

+* Eliminates useless . and .. components from specified path.

+*

+* Deprecated, use filesystem class instead

+*

+* @param string $path Path to clean

+* @return string Cleaned path

+*

+* @deprecated

+*/

+function phpbb_clean_path($path)

+{

+ global $phpbb_path_helper, $phpbb_container;

+

+ if (!$phpbb_path_helper && $phpbb_container)

+ {

+ $phpbb_path_helper = $phpbb_container->get('path_helper');

+ }

+ else if (!$phpbb_path_helper)

+ // The container is not yet loaded, use a new instance

+ if (!class_exists('\phpbb\path_helper'))

+ {

+ global $phpbb_root_path, $phpEx;

+ require($phpbb_root_path . 'phpbb/path_helper.' . $phpEx);

+ }

+ $phpbb_path_helper = new phpbb\path_helper(

+ new phpbb\symfony_request(

+ new phpbb\request\request()

+ ),

+ new phpbb\filesystem(),

+ $phpbb_root_path,

+ $phpEx

+ );

+ return $phpbb_path_helper->clean_path($path);

+}

+

+/**

+* Pick a timezone

+*

+* @param string $default A timezone to select

+* @param boolean $truncate Shall we truncate the options text

+*

+* @return string Returns the options for timezone selector only

+*

+* @deprecated

+*/

+function tz_select($default = '', $truncate = false)

+{

+ global $user;

+

+ $timezone_select = phpbb_timezone_select($user, $default, $truncate);

+ return $timezone_select['tz_select'];

+}

+

+/**

+* Cache moderators. Called whenever permissions are changed

+* via admin_permissions. Changes of usernames and group names

+* must be carried through for the moderators table.

+*

+* @deprecated 3.1

+* @return null

+*/

+function cache_moderators()

+{

+ global $db, $cache, $auth;

+ return phpbb_cache_moderators($db, $cache, $auth);

+}

+

+/**

+* Removes moderators and administrators from foe lists.

+*

+* @deprecated 3.1

+* @param array|bool $group_id If an array, remove all members of this group from foe lists, or false to ignore

+* @param array|bool $user_id If an array, remove this user from foe lists, or false to ignore

+* @return null

+*/

+function update_foes($group_id = false, $user_id = false)

+{

+ global $db, $auth;

+ return phpbb_update_foes($db, $auth, $group_id, $user_id);

+* @return \phpbb\db\driver\driver_interface

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

+* phpbb_clean_search_string()

+ global $config, $auth, $template, $user, $db, $phpbb_path_helper;

+ $url_parts = $phpbb_path_helper->get_url_parts($action);

+

+ 'S_DISPLAY_JUMPBOX' => $display_jumpbox,

+ 'S_JUMPBOX_ACTION' => $action,

+ 'HIDDEN_FIELDS_FOR_JUMPBOX' => build_hidden_fields($url_parts['params']),

+ ));

+* Cleans a search string by removing single wildcards from it and replacing multiple spaces with a single one.

+*

+* @param string $search_string The full search string which should be cleaned.

+*

+* @return string The cleaned search string without any wildcards and multiple spaces.

+*/

+function phpbb_clean_search_string($search_string)

+{

+ // This regular expressions matches every single wildcard.

+ // That means one after a whitespace or the beginning of the string or one before a whitespace or the end of the string.

+ $search_string = preg_replace('#(?<=^|\s)\*+(?=\s|$)#', '', $search_string);

+ $search_string = trim($search_string);

+ $search_string = preg_replace(array('#\s+#u', '#\*+#u'), array(' ', '*'), $search_string);

+ return $search_string;

+}

+

+/**

+ * @since 3.1.0-a1

+ {

+ * @since 3.1.0-a1

+*

+ * @since 3.1.0-a1

+ $vars = array(

+ 'text',

+ 'uid',

+ 'bitfield',

+ 'flags',

+ 'allow_bbcode',

+ 'allow_urls',

+ 'allow_smilies',

+ );

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+

+ * @since 3.1.0-a1

+ $vars = array(

+ 'mode',

+ 'user_id',

+ 'username',

+ 'username_colour',

+ 'guest_username',

+ 'custom_profile_url',

+ 'username_string',

+ '_profile_cache',

+ );

+* Concatenate an array into a string list.

+*

+* @param array $items Array of items to concatenate

+* @param object $user The phpBB $user object.

+*

+* @return string String list. Examples: "A"; "A and B"; "A, B, and C"

+*/

+function phpbb_generate_string_list($items, $user)

+{

+ if (empty($items))

+ {

+ return '';

+ }

+

+ $count = sizeof($items);

+ $last_item = array_pop($items);

+ $lang_key = 'STRING_LIST_MULTI';

+

+ if ($count == 1)

+ {

+ return $last_item;

+ }

+ else if ($count == 2)

+ {

+ $lang_key = 'STRING_LIST_SIMPLE';

+ }

+ $list = implode($user->lang['COMMA_SEPARATOR'], $items);

+

+ return $user->lang($lang_key, $list, $last_item);

+}

+

+/**

+ case 'sqlite3':

+ case 'sqlite3':

+* @param \phpbb\db\driver\driver_interface $db Database object

+function phpbb_update_rows_avoiding_duplicates(\phpbb\db\driver\driver_interface $db, $table, $column, $from_values, $to_value)

+* @param \phpbb\db\driver\driver_interface $db Database object

+function phpbb_update_rows_avoiding_duplicates_notify_status(\phpbb\db\driver\driver_interface $db, $table, $column, $from_values, $to_value)

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ $l_subforums = (sizeof($subforums[$forum_id]) == 1) ? $user->lang['SUBFORUM'] : $user->lang['SUBFORUMS'];

+ * @since 3.1.0-a1

+ 'BBCODE_TAG_CLEAN' => str_replace('=', '-', $row['bbcode_tag']),

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+* @param \phpbb\db\driver\driver_interface $db The database object

+* @param \phpbb\db\driver\driver_interface $db The database object

+* @param \phpbb\db\driver\driver_interface $db The database object

+* @param \phpbb\db\driver\driver_interface $db The database object

+ 'sqlite3' => array(

+ 'LABEL' => 'SQLite3',

+ 'SCHEMA' => 'sqlite',

+ 'MODULE' => 'sqlite3',

+ 'DELIM' => ';',

+ 'DRIVER' => 'phpbb\db\driver\sqlite3',

+ 'AVAILABLE' => true,

+ '2.0.x' => false,

+ ),

+ if ($dbms_details['DRIVER'] != 'phpbb\db\driver\sqlite' && $dbms_details['DRIVER'] != 'phpbb\db\driver\sqlite3' && $dbms_details['DRIVER'] != 'phpbb\db\driver\oracle' && $dbname === '')

+ if (($dbms_details['DRIVER'] == 'phpbb\db\driver\sqlite' || $dbms_details['DRIVER'] == 'phpbb\db\driver\sqlite3') && stripos(phpbb_realpath($dbhost), phpbb_realpath('../')) === 0)

+ case 'phpbb\db\driver\sqlite3':

+ case 'phpbb\db\driver\sqlite3':

+ $version = \SQLite3::version();

+ if (version_compare($version['versionString'], '3.6.15', '<'))

+ {

+ $error[] = $lang['INST_ERR_DB_NO_SQLITE3'];

+ }

+ break;

+

+* @param bool $debug_container If the container should be compiled on

+* every page load or not

+function phpbb_create_config_file_data($data, $dbms, $debug = false, $debug_container = false, $debug_test = false)

+ if ($debug_container)

+ {

+ $config_data .= "@define('DEBUG_CONTAINER', true);\n";

+ }

+ else

+ {

+ $config_data .= "// @define('DEBUG_CONTAINER', true);\n";

+ }

+

+

+/**

+* Check whether phpBB is installed.

+*

+* @param string $phpbb_root_path Path to the phpBB board root.

+* @param string $php_ext PHP file extension.

+*

+* @return bool Returns true if phpBB is installed.

+*/

+function phpbb_check_installation_exists($phpbb_root_path, $php_ext)

+{

+ // Try opening config file

+ if (file_exists($phpbb_root_path . 'config.' . $php_ext))

+ {

+ include($phpbb_root_path . 'config.' . $php_ext);

+ }

+

+ return defined('PHPBB_INSTALLED');

+}

+ $contact_name = htmlspecialchars_decode($config['board_contact_name']);

+ $board_contact = (($contact_name !== '') ? '"' . mail_encode($contact_name) . '" ' : '') . '<' . $config['board_contact'] . '>';

+

+ $this->replyto = $board_contact;

+ $this->from = $board_contact;

+ $messenger = new messenger();

+ $messenger->error('JABBER', $user->lang['ERR_JAB_CONNECT']);

+ $messenger = new messenger();

+ $messenger->error('JABBER', $user->lang['ERR_JAB_AUTH']);

+ $messenger = new messenger();

+ $messenger->error('EMAIL', $err_msg);

+ $messenger = new messenger();

+ $messenger->error('JABBER', $this->jabber->get_log());

+ global $config, $phpbb_root_path, $phpEx, $phpbb_dispatcher;

+

+ $hide_categories = array();

+ // When the module has no mode (category) we check whether it has visible children

+ // before listing it as well.

+ if (!$row['module_mode'])

+ {

+ $hide_categories[(int) $row['module_id']] = $key;

+ }

+

+

+ if ($row['module_mode'])

+ {

+ // The parent category has a visible child

+ // So remove it and all its parents from the hide array

+ unset($hide_categories[(int) $row['parent_id']]);

+ foreach ($this->module_cache['parents'][$row['module_id']] as $module_id => $row_id)

+ {

+ unset($hide_categories[$module_id]);

+ }

+ }

+ }

+

+ foreach ($hide_categories as $module_id => $row_id)

+ {

+ unset($this->module_cache['modules'][$row_id]);

+ /**

+ * This event allows to modify parameters for building modules list

+ *

+ * @event core.modify_module_row

+ * @var string url_func Function for building 'url_extra'

+ * @var string lang_func Function for building the language name

+ * @var string custom_func Custom function for calling parameters on module init

+ * @var array row Array holding the basic module data

+ * @var array module_row Array holding the module display parameters

+ * @since 3.1.0-b3

+ */

+ $vars = array('url_func', 'lang_func', 'custom_func', 'row', 'module_row');

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

+

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

+ * @since 3.1.0-a3

+ trigger_error('MODULE_NOT_ACCESS', E_USER_ERROR);

+ trigger_error($user->lang('MODULE_NOT_FIND', "$module_path/{$this->p_name}.$phpEx"), E_USER_ERROR);

+ trigger_error($user->lang('MODULE_FILE_INCORRECT_CLASS', "$module_path/{$this->p_name}.$phpEx", $this->p_name), E_USER_ERROR);

+ function display($page_title, $display_online_list = false)

+ global $phpEx, $phpbb_root_path, $phpbb_container, $phpbb_path_helper;

+ $root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $phpbb_path_helper->get_web_root_path();

+ * @since 3.1.0-a1

+ else if (!$config['check_attachment_content'])

+ {

+ $upload->set_disallowed_content(array());

+ }

+ 'L_IGNORE_POST' => ($row['foe']) ? sprintf($user->lang['POST_BY_FOE'], get_username_string('full', $poster_id, $row['username'], $row['user_colour'], $row['post_username']), "<a href=\"{$u_show_post}\" onclick=\"phpbb.toggleDisplay('{$post_anchor}', 1); return false;\">", '</a>') : '',

+ else if ($data['topic_visibility'] == ITEM_UNAPPROVED || $data['post_visibility'] == ITEM_REAPPROVE)

+ else if ($data['post_visibility'] == ITEM_UNAPPROVED || $data['post_visibility'] == ITEM_REAPPROVE)

+ $vars = array(

+ 'mode',

+ 'subject',

+ 'username',

+ 'topic_type',

+ 'poll',

+ 'data',

+ 'update_message',

+ 'update_search_index',

+ );

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

+ switch ($post_mode)

+ {

+ case 'edit_first_post':

+ case 'edit':

+ case 'edit_last_post':

+ case 'edit_topic':

+ $post_visibility = ITEM_REAPPROVE;

+ break;

+ }

+ $post_visibility = (in_array((int) $data['force_approved_state'], array(ITEM_APPROVED, ITEM_UNAPPROVED, ITEM_DELETED, ITEM_REAPPROVE))) ? (int) $data['force_approved_state'] : $post_visibility;

+ $post_visibility = (in_array((int) $data['force_visibility'], array(ITEM_APPROVED, ITEM_UNAPPROVED, ITEM_DELETED, ITEM_REAPPROVE))) ? (int) $data['force_visibility'] : $post_visibility;

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

+ $is_starter = ($post_mode == 'edit_first_post' || $post_mode == 'edit_topic' || $data['post_visibility'] != ITEM_APPROVED);

+ // Nothing to do here

+ else if ($post_visibility == ITEM_REAPPROVE)

+ case 'edit_topic':

+ case 'edit_first_post':

+ $phpbb_notifications->add_notifications('topic_in_queue', $notification_data);

+

+ // Delete the approve_post notification so we can notify the user again,

+ // when his post got reapproved

+ $phpbb_notifications->delete_notifications('approve_post', $notification_data['post_id']);

+ break;

+

+ case 'edit':

+ case 'edit_last_post':

+ $phpbb_notifications->add_notifications('post_in_queue', $notification_data);

+

+ // Delete the approve_post notification so we can notify the user again,

+ // when his post got reapproved

+ $phpbb_notifications->delete_notifications('approve_post', $notification_data['post_id']);

+ break;

+

+ }

+ }

+ else if ($post_visibility == ITEM_DELETED)

+ {

+ switch ($mode)

+ {

+ case 'post':

+ case 'reply':

+ case 'quote':

+ // Nothing to do here

+ * @since 3.1.0-a3

+ $return['message'] = $user->lang('FOLDER_STATUS_MSG', $user->lang('MESSAGES_COUNT', (int) $return['max']), $return['cur'], $return['percent']);

+ global $db, $auth, $config, $phpEx, $template, $user, $phpbb_root_path, $phpbb_container, $phpbb_dispatcher;

+ /**

+ * Get all parts of the PM that are to be submited to the DB.

+ *

+ * @event core.submit_pm_before

+ * @var string mode PM Post mode - post|reply|quote|quotepost|forward|edit

+ * @var string subject Subject of the private message

+ * @var array data The whole row data of the PM.

+ * @since 3.1.0-b3

+ */

+ $vars = array('mode', 'subject', 'data');

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

+

+

+

+ $this->transfer();

+ $this->transfer();

+ $name = trim(utf8_basename($name));

+ var $disallowed_content = array('body', 'head', 'html', 'img', 'plaintext', 'a href', 'pre', 'script', 'table', 'title');

+* @param \phpbb\extension\manager $manager Extension manager

+function phpbb_get_url_matcher(\phpbb\extension\manager $manager, RequestContext $context, $root_path, $php_ext)

+ return phpbb_create_url_matcher($manager, $context, $root_path);

+ phpbb_create_dumped_url_matcher($manager, $root_path, $php_ext);

+* @param \phpbb\extension\manager $manager Extension manager

+function phpbb_create_dumped_url_matcher(\phpbb\extension\manager $manager, $root_path, $php_ext)

+ $provider->find_routing_files($manager->get_finder());

+ $routes = $provider->find($root_path)->get_routes();

+* @param \phpbb\extension\manager $manager Extension manager

+function phpbb_create_url_matcher(\phpbb\extension\manager $manager, RequestContext $context, $root_path)

+ $provider->find_routing_files($manager->get_finder());

+ $routes = $provider->find($root_path)->get_routes();

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ if (is_array($function))

+ {

+ $result = call_user_func_array(array($function[0], 'validate_' . $function[1]), $validate);

+ }

+ else

+ {

+ $function_prefix = (function_exists('phpbb_validate_' . $function)) ? 'phpbb_validate_' : 'validate_';

+ $result = call_user_func_array($function_prefix . $function, $validate);

+ }

+

+ if ($result)

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+ * @since 3.1.0-a1

+* @param bool|int $ban_end Bool True to get users currently banned

+* Bool False to only get permanently banned users

+* Int Unix timestamp to get users banned until that time

+function phpbb_get_banned_user_ids($user_ids = array(), $ban_end = true)

+ AND ban_exclude <> 1";

+

+ if ($ban_end === true)

+ {

+ // Banned currently

+ $sql .= " AND (ban_end > " . time() . '

+ }

+ else if ($ban_end === false)

+ {

+ // Permanently banned

+ $sql .= " AND ban_end = 0";

+ }

+ else

+ {

+ // Banned until a specified time

+ $sql .= " AND (ban_end > " . (int) $ban_end . '

+ OR ban_end = 0)';

+ }

+

+ 'pm_reports' => array('title' => 'MCP_PM_REPORTS_OPEN', 'auth' => 'aclf_m_report', 'cat' => array('MCP_REPORTS')),

+

+ $topic_unapproved = (($row['topic_visibility'] == ITEM_UNAPPROVED || $row['topic_visibility'] == ITEM_REAPPROVE) && $auth->acl_get('m_approve', $row['forum_id'])) ? true : false;

+ * @since 3.1.0-a1

+ AND ' . $db->sql_in_set('post_visibility', array(ITEM_UNAPPROVED, ITEM_REAPPROVE));

+ AND ' . $db->sql_in_set('post_visibility', array(ITEM_UNAPPROVED, ITEM_REAPPROVE)) . '

+ global $auth, $user, $db, $template, $phpbb_log, $request;

+ elseif ($topic_info['topic_visibility'] == ITEM_UNAPPROVED || $topic_info['topic_visibility'] == ITEM_REAPPROVE)

+ // Get the list of forums to resync

+

+ // We add the $to_forum_id twice, because 'forum_id' is updated

+ // when the topic is moved again later.

+ $phpbb_log->add('mod', $user->data['user_id'], $user->ip, 'LOG_MOVE', false, array(

+ 'forum_id' => (int) $to_forum_id,

+ 'topic_id' => (int) $topic_id,

+ $row['forum_name'],

+ $forum_data['forum_name'],

+ (int) $row['forum_id'],

+ (int) $forum_data['forum_id'],

+ ));

+ case ITEM_REAPPROVE:

+ case ITEM_REAPPROVE:

+

+

+ 'S_POST_UNAPPROVED' => ($post_info['post_visibility'] == ITEM_UNAPPROVED || $post_info['post_visibility'] == ITEM_REAPPROVE) ? true : false,

+ 'REPORTER' => get_username_string('username', $row['user_id'], $row['username']),

+ 'U_REPORTER' => get_username_string('profile', $row['user_id'], $row['username']),

+ 'USERNAME' => get_username_string('username', $user_id, $user_row['username']),

+ 'U_PROFILE' => get_username_string('profile', $user_id, $user_row['username']),

+ $post_visibility = ($mode == 'deleted_topics') ? ITEM_DELETED : array(ITEM_UNAPPROVED, ITEM_REAPPROVE);

+ WHERE ' . $db->sql_in_set('post_visibility', $post_visibility) . '

+ 'S_POST_UNAPPROVED' => $post_info['post_visibility'] == ITEM_UNAPPROVED || $post_info['post_visibility'] == ITEM_REAPPROVE,

+ $visibility_const = (!$is_restore) ? array(ITEM_UNAPPROVED, ITEM_REAPPROVE) : ITEM_DELETED;

+ AND ' . $db->sql_in_set('p.post_visibility', $visibility_const) . '

+ AND ' . $db->sql_in_set('topic_visibility', $visibility_const) . "

+ // Only add notifications, if we are not reapproving post

+ // When the topic was already approved, but was edited and

+ // now needs re-approval, we don't want to notify the users

+ // again.

+ if ($post_data['post_visibility'] == ITEM_UNAPPROVED)

+ {

+ $phpbb_notifications->add_notifications(array(

+ 'quote',

+ 'bookmark',

+ 'post',

+ ), $post_data);

+ }

+

+ // Only add notifications, if we are not reapproving post

+ // When the topic was already approved, but was edited and

+ // now needs re-approval, we don't want to notify the users

+ // again.

+ if ($topic_data['topic_visibility'] == ITEM_UNAPPROVED)

+ {

+ $phpbb_notifications->add_notifications(array(

+ 'quote',

+ 'topic',

+ ), $topic_data);

+ }

+ add_log('mod', $log_data['forum_id'], $log_data['topic_id'], $l_log_message, $log_data['post_subject'], $disapprove_reason, $log_data['post_username']);

+ // If we came from viewtopic, we try to go back to it.

+ if (strpos($redirect, $phpbb_root_path . 'viewtopic.' . $phpEx) === 0)

+ {

+ if ($num_disapproved_topics == 0)

+ {

+ // So we need to remove the post id part from the Url

+ $redirect = str_replace("&amp;p={$post_id_list[0]}#p{$post_id_list[0]}", '', $redirect);

+ }

+ else

+ {

+ // However this is only possible if the topic still exists,

+ // Otherwise we go back to the viewforum page

+ $redirect = append_sid($phpbb_root_path . 'viewforum.' . $phpEx, 'f=' . $request->variable('f', 0));

+ }

+ }

+

+

+ $parse_post_flags += $report['reported_post_enable_magic_url'] ? OPTION_FLAG_LINKS : 0;

+ $message = generate_text_for_display(

+ $report['reported_post_text'],

+ $report['reported_post_uid'],

+ $report['reported_post_bitfield'],

+ $parse_post_flags,

+ false

+ );

+ AND filetime <= ' . (int) $report['report_time'] . '

+ parse_attachments($post_info['forum_id'], $message, $attachments, $update_count);

+ 'S_POST_UNAPPROVED' => $post_info['post_visibility'] == ITEM_UNAPPROVED || $post_info['post_visibility'] == ITEM_REAPPROVE,

+ 'POST_PREVIEW' => $message,

+ if ($row['post_visibility'] == ITEM_UNAPPROVED || $row['post_visibility'] == ITEM_REAPPROVE)

+ 'S_POST_UNAPPROVED' => (($row['post_visibility'] == ITEM_UNAPPROVED || $row['post_visibility'] == ITEM_REAPPROVE) && $auth->acl_get('m_approve', $topic_info['forum_id'])),

+ if (($row['post_visibility'] == ITEM_UNAPPROVED || $row['post_visibility'] == ITEM_REAPPROVE) && !$auth->acl_get('m_approve', $row['forum_id']))

+ if (!function_exists('get_user_rank'))

+ if (!function_exists('get_user_rank'))

+

+ if ($config['max_quote_depth'] == 1)

+ {

+ // Depth 1 - no nesting is allowed

+ $error_ary['quote_depth'] = $user->lang('QUOTE_NO_NESTING');

+ }

+ else

+ {

+ // There are too many nested quotes

+ $error_ary['quote_depth'] = $user->lang('QUOTE_DEPTH_EXCEEDED', (int) $config['max_quote_depth']);

+ }

+ $this->warn_msg[] = $user->lang('CHARS_' . strtoupper($mode) . '_CONTAINS', $message_length) . '<br />' . $user->lang('TOO_MANY_CHARS_LIMIT', (int) $config['max_' . $mode . '_chars']);

+ $this->warn_msg[] = (!$message_length) ? $user->lang['TOO_FEW_CHARS'] : ($user->lang('CHARS_POST_CONTAINS', $message_length) . '<br />' . $user->lang('TOO_FEW_CHARS_LIMIT', (int) $config['min_post_chars']));

+ 'auth_link' => array('title' => 'UCP_AUTH_LINK_MANAGE', 'auth' => 'authmethod_oauth', 'cat' => array('UCP_PROFILE')),

+ 'LAST_ACTIVE' => (empty($last_active)) ? ' - ' : $user->format_date($last_active),

+ 'S_UNREAD_FORUM' => $unread_forum,

+

+

+ 'S_VIEW_MESSAGE' => true,

+ 'L_RETURN_TO_FOLDER' => $user->lang('RETURN_TO', $folder_status['folder_name']),

+ 'MSG_ID' => $msg_id,

+ ));

+ $sql = 'SELECT attach_id, is_orphan, attach_comment, real_filename, filesize

+ 'S_ATTACH_DATA' => json_encode($message_parser->attachment_data),

+ $max_files = ($auth->acl_gets('a_', 'm_')) ? 0 : (int) $config['max_attachments_pm'];

+ $plupload->configure($cache, $template, $s_action, false, $max_files);

+ $can_ignore_allow_pm = $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_');

+

+ // Administrator deactivated users check and we need to check their

+ // PM status (do they want to receive PM's?)

+ // Only check PM status if not a moderator or admin, since they

+ // are allowed to override this user setting

+ $sql = 'SELECT user_id, user_allow_pm

+ FROM ' . USERS_TABLE . '

+ WHERE ' . $db->sql_in_set('user_id', array_keys($address_list['u'])) . '

+ AND (

+ (user_type = ' . USER_INACTIVE . '

+ AND user_inactive_reason = ' . INACTIVE_MANUAL . ')

+ ' . ($can_ignore_allow_pm ? '' : ' OR user_allow_pm = 0') . '

+ )';

+

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

+

+ $removed_no_pm = $removed_no_permission = false;

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

+ if (!$can_ignore_allow_pm && !$row['user_allow_pm'])

+ {

+ $removed_no_pm = true;

+ }

+ else

+ {

+ $removed_no_permission = true;

+ }

+ unset($address_list['u'][$row['user_id']]);

+ }

+ $db->sql_freeresult($result);

+

+ // print a notice about users not being added who do not want to receive pms

+ if ($removed_no_pm)

+ {

+ $error[] = $user->lang['PM_USERS_REMOVED_NO_PM'];

+ }

+

+ // print a notice about users not being added who do not have permission to receive PMs

+ if ($removed_no_permission)

+ {

+ $error[] = $user->lang['PM_USERS_REMOVED_NO_PERMISSION'];

+ }

+

+ if (!sizeof(array_keys($address_list['u'])))

+ {

+ return;

+ }

+

+ // Check if users have permission to read PMs

+ $can_read = $auth->acl_get_list(array_keys($address_list['u']), 'u_readpm');

+ $can_read = (empty($can_read) || !isset($can_read[0]['u_readpm'])) ? array() : $can_read[0]['u_readpm'];

+ $cannot_read_list = array_diff(array_keys($address_list['u']), $can_read);

+ if (!empty($cannot_read_list))

+ {

+ foreach ($cannot_read_list as $cannot_read)

+ unset($address_list['u'][$cannot_read]);

+ $error[] = $user->lang['PM_USERS_REMOVED_NO_PERMISSION'];

+ }

+

+ // Check if users are banned

+ $banned_user_list = phpbb_get_banned_user_ids(array_keys($address_list['u']), false);

+ if (!empty($banned_user_list))

+ {

+ foreach ($banned_user_list as $banned_user)

+ unset($address_list['u'][$banned_user]);

+

+ $error[] = $user->lang['PM_USERS_REMOVED_NO_PERMISSION'];

+

+

+ trigger_error($user->lang('MOVE_PM_ERROR', $user->lang('MESSAGES_COUNT', (int) $folder_row['pm_count']), $num_moved));

+

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

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

+

+

+

+

+ $sql .= " (g.group_name NOT IN ('GUESTS', 'BOTS') OR g.group_type <> " . GROUP_SPECIAL . ')

+

+

+

+ $profile_fields = $cp->grab_profile_fields_data($author_id);

+ $cp_row = $cp->generate_profile_fields_template_data($profile_fields[$author_id]);

+ $u_pm = $u_jabber = '';

+

+ if ($config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($user_info['user_allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_')))

+ {

+ $u_pm = append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;mode=compose&amp;u=' . $author_id);

+ }

+

+ if ($user_info['user_jabber'] && $auth->acl_get('u_sendim'))

+ {

+ $u_jabber = append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=contact&amp;action=jabber&amp;u=' . $author_id);

+ }

+

+ 'U_PM' => $u_pm,

+ 'U_JABBER' => $u_jabber,

+ * @since 3.1.0-a1

+ $vars = array(

+ 'id',

+ 'mode',

+ 'folder_id',

+ 'msg_id',

+ 'folder',

+ 'message_row',

+ 'cp_row',

+ 'msg_data',

+ );

+ $contact_fields = array(

+ array(

+ 'ID' => 'pm',

+ 'NAME' => $user->lang['PRIVATE_MESSAGE'],

+ 'U_CONTACT' => $u_pm,

+ ),

+ array(

+ 'ID' => 'email',

+ 'NAME' => $user->lang['SEND_EMAIL'],

+ 'U_CONTACT' => $user_info['email'],

+ ),

+ array(

+ 'ID' => 'jabber',

+ 'NAME' => $user->lang['JABBER'],

+ 'U_CONTACT' => $u_jabber,

+ ),

+ );

+

+ foreach ($contact_fields as $field)

+ {

+ if ($field['U_CONTACT'])

+ {

+ $template->assign_block_vars('contact', $field);

+ }

+ }

+

+

+ if ($cp_block_row['S_PROFILE_CONTACT'])

+ {

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

+ 'ID' => $cp_block_row['PROFILE_FIELD_IDENT'],

+ 'NAME' => $cp_block_row['PROFILE_FIELD_NAME'],

+ 'U_CONTACT' => $cp_block_row['PROFILE_FIELD_CONTACT'],

+ ));

+ }

+

+ $user_row['avatar'] = ($user->optionget('viewavatars')) ? phpbb_get_user_avatar($user_row) : '';

+

+ if (!function_exists('get_user_rank'))

+ * @since 3.1.0-a1