+ $l_legend_cat_images = $user->lang['SETTINGS_CAT_IMAGES'] . ' [' . $user->lang['ASSIGNED_GROUP'] . ': ' . ((!empty($s_assigned_groups[ATTACHMENT_CATEGORY_IMAGE])) ? implode($user->lang['COMMA_SEPARATOR'], $s_assigned_groups[ATTACHMENT_CATEGORY_IMAGE]) : $user->lang['NO_EXT_GROUP']) . ']';

+ $notify[] = sprintf($user->lang['LOG_ATTACH_ORPHAN_DEL'], implode($user->lang['COMMA_SEPARATOR'], $delete_files));

+ $notify[] = sprintf($user->lang['LOG_ATTACHMENTS_DELETED'], implode($user->lang['COMMA_SEPARATOR'], $deleted_filenames));

+ );

+

+ self::display_ban_options($mode);

+ static public function display_ban_options($mode)

+ 'site_home_url' => array('lang' => 'SITE_HOME_URL', 'validate' => 'string', 'type' => 'text:40:255', 'explain' => true),

+ 'site_home_text' => array('lang' => 'SITE_HOME_TEXT', 'validate' => 'string', 'type' => 'text:40:255', 'explain' => true),

+ $factory = new phpbb_captcha_factory();

+ $captchas = $factory->get_captcha_types();

+<?php

+/**

+*

+* @package acp

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* @package acp

+*/

+class acp_extensions

+{

+ var $u_action;

+

+ private $db;

+ private $config;

+ private $template;

+ private $user;

+

+ function main()

+ {

+ // Start the page

+ global $config, $user, $template, $request, $phpbb_extension_manager, $db, $phpbb_root_path, $phpEx;

+

+ $this->db = $db;

+ $this->config = $config;

+ $this->template = $template;

+ $this->user = $user;

+

+ $user->add_lang(array('install', 'acp/extensions'));

+

+ $this->page_title = 'ACP_EXTENSIONS';

+

+ $action = $request->variable('action', 'list');

+ $ext_name = $request->variable('ext_name', '');

+

+ // Cancel action

+ if ($request->is_set_post('cancel'))

+ {

+ $action = 'list';

+ $ext_name = '';

+ }

+

+ // If they've specified an extension, let's load the metadata manager and validate it.

+ if ($ext_name)

+ {

+ $md_manager = new phpbb_extension_metadata_manager($ext_name, $db, $phpbb_extension_manager, $phpbb_root_path, ".$phpEx", $template, $config);

+

+ try

+ {

+ $md_manager->get_metadata('all');

+ }

+ catch(phpbb_extension_exception $e)

+ {

+ trigger_error($e);

+ }

+ }

+

+ // What are we doing?

+ switch ($action)

+ {

+ case 'list':

+ default:

+ $this->list_enabled_exts($phpbb_extension_manager);

+ $this->list_disabled_exts($phpbb_extension_manager);

+ $this->list_available_exts($phpbb_extension_manager);

+

+ $this->tpl_name = 'acp_ext_list';

+ break;

+

+ case 'enable_pre':

+ if (!$md_manager->validate_enable())

+ {

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

+ }

+

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

+ {

+ redirect($this->u_action);

+ }

+

+ $this->tpl_name = 'acp_ext_enable';

+

+ $template->assign_vars(array(

+ 'PRE' => true,

+ 'U_ENABLE' => $this->u_action . '&amp;action=enable&amp;ext_name=' . urlencode($ext_name),

+ ));

+ break;

+

+ case 'enable':

+ if (!$md_manager->validate_enable())

+ {

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

+ }

+

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

+ {

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

+

+ meta_refresh(0, $this->u_action . '&amp;action=enable&amp;ext_name=' . urlencode($ext_name));

+ }

+

+ $this->tpl_name = 'acp_ext_enable';

+

+ $template->assign_vars(array(

+ 'U_RETURN' => $this->u_action . '&amp;action=list',

+ ));

+ break;

+

+ case 'disable_pre':

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

+ {

+ redirect($this->u_action);

+ }

+

+ $this->tpl_name = 'acp_ext_disable';

+

+ $template->assign_vars(array(

+ 'PRE' => true,

+ 'U_DISABLE' => $this->u_action . '&amp;action=disable&amp;ext_name=' . urlencode($ext_name),

+ ));

+ break;

+

+ case 'disable':

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

+ {

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

+

+ meta_refresh(0, $this->u_action . '&amp;action=disable&amp;ext_name=' . urlencode($ext_name));

+ }

+

+ $this->tpl_name = 'acp_ext_disable';

+

+ $template->assign_vars(array(

+ 'U_RETURN' => $this->u_action . '&amp;action=list',

+ ));

+ break;

+

+ case 'purge_pre':

+ $this->tpl_name = 'acp_ext_purge';

+

+ $template->assign_vars(array(

+ 'PRE' => true,

+ 'U_PURGE' => $this->u_action . '&amp;action=purge&amp;ext_name=' . urlencode($ext_name),

+ ));

+ break;

+

+ case 'purge':

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

+ {

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

+

+ meta_refresh(0, $this->u_action . '&amp;action=purge&amp;ext_name=' . urlencode($ext_name));

+ }

+

+ $this->tpl_name = 'acp_ext_purge';

+

+ $template->assign_vars(array(

+ 'U_RETURN' => $this->u_action . '&amp;action=list',

+ ));

+ break;

+

+ case 'details':

+ // Output it to the template

+ $md_manager->output_template_data();

+

+ $template->assign_var('U_BACK', $this->u_action . '&amp;action=list');

+

+ $this->tpl_name = 'acp_ext_details';

+ break;

+ }

+ }

+

+ /**

+ * Lists all the enabled extensions and dumps to the template

+ *

+ * @param $phpbb_extension_manager An instance of the extension manager

+ * @return null

+ */

+ public function list_enabled_exts(phpbb_extension_manager $phpbb_extension_manager)

+ {

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

+ {

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

+

+ try

+ {

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

+ 'META_DISPLAY_NAME' => $md_manager->get_metadata('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),

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

+ ));

+ }

+ catch(phpbb_extension_exception $e)

+ {

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

+ 'META_DISPLAY_NAME' => $this->user->lang('EXTENSION_INVALID_LIST', $name, $e),

+ ));

+ }

+ }

+ }

+

+ /**

+ * Lists all the disabled extensions and dumps to the template

+ *

+ * @param $phpbb_extension_manager An instance of the extension manager

+ * @return null

+ */

+ public function list_disabled_exts(phpbb_extension_manager $phpbb_extension_manager)

+ {

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

+ {

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

+

+ try

+ {

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

+ 'META_DISPLAY_NAME' => $md_manager->get_metadata('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),

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

+ ));

+ }

+ catch(phpbb_extension_exception $e)

+ {

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

+ 'META_DISPLAY_NAME' => $this->user->lang('EXTENSION_INVALID_LIST', $name, $e),

+ ));

+ }

+ }

+ }

+

+ /**

+ * Lists all the available extensions and dumps to the template

+ *

+ * @param $phpbb_extension_manager An instance of the extension manager

+ * @return null

+ */

+ public function list_available_exts(phpbb_extension_manager $phpbb_extension_manager)

+ {

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

+

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

+ {

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

+

+ try

+ {

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

+ 'META_DISPLAY_NAME' => $md_manager->get_metadata('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),

+ ));

+ }

+ catch(phpbb_extension_exception $e)

+ {

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

+ 'META_DISPLAY_NAME' => $this->user->lang('EXTENSION_INVALID_LIST', $name, $e),

+ ));

+ }

+ }

+ }

+

+ /**

+ * Output actions to a block

+ *

+ * @param string $block

+ * @param array $actions

+ */

+ private function output_actions($block, $actions)

+ {

+ foreach ($actions as $lang => $url)

+ {

+ $this->template->assign_block_vars($block . '.actions', array(

+ 'L_ACTION' => $this->user->lang($lang),

+ 'U_ACTION' => $url,

+ ));

+ }

+ }

+}

+ global $db, $user, $auth, $template, $cache, $request, $phpbb_dispatcher;

+ /**

+ * Request forum data and operate on it (parse texts, etc.)

+ *

+ * @event core.acp_manage_forums_request_data

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

+ * @var array forum_data Array with new forum data

+ * @since 3.1-A1

+ */

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

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

+

+ // Initialise $row, so we always have it in the event

+ $row = array();

+

+ /**

+ * Initialise data before we display the add/edit form

+ *

+ * @event core.acp_manage_forums_initialise_data

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

+ * @var bool update Do we display the form only

+ * or did the user press submit

+ * @var int forum_id When editing: the forum id,

+ * when creating: the parent forum id

+ * @var array row Array with current forum data

+ * empty when creating new forum

+ * @var array forum_data Array with new forum data

+ * @var string parents_list List of parent options

+ * @since 3.1-A1

+ */

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

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

+

+ $template_data = array(

+ );

+

+ /**

+ * Modify forum template data before we display the form

+ *

+ * @event core.acp_manage_forums_display_form

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

+ * @var bool update Do we display the form only

+ * or did the user press submit

+ * @var int forum_id When editing: the forum id,

+ * when creating: the parent forum id

+ * @var array row Array with current forum data

+ * empty when creating new forum

+ * @var array forum_data Array with new forum data

+ * @var string parents_list List of parent options

+ * @var array errors Array of errors, if you add errors

+ * ensure to update the template variables

+ * S_ERROR and ERROR_MSG to display it

+ * @var array template_data Array with new forum data

+ * @since 3.1-A1

+ */

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

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

+

+ $template->assign_vars($template_data);

+ global $db, $user, $cache, $phpbb_root_path, $phpbb_dispatcher;

+ /**

+ * Validate the forum data before we create/update the forum

+ *

+ * @event core.acp_manage_forums_validate_data

+ * @var array forum_data Array with new forum data

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

+ * language key.

+ * @since 3.1-A1

+ */

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

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

+

+ /**

+ * Remove invalid values from forum_data_sql that should not be updated

+ *

+ * @event core.acp_manage_forums_update_data_before

+ * @var array forum_data Array with forum data

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

+ * If forum_data_sql[forum_id] is set, we update

+ * that forum, otherwise a new one is created.

+ * @since 3.1-A1

+ */

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

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

+

+ $is_new_forum = !isset($forum_data_sql['forum_id']);

+

+ if ($is_new_forum)

+ /**

+ * Event after a forum was updated or created

+ *

+ * @event core.acp_manage_forums_update_data_after

+ * @var array forum_data Array with forum data

+ * @var array forum_data_sql Array with data we updated

+ * @var bool is_new_forum Did we create a forum or update one

+ * If you want to overwrite this value,

+ * ensure to set forum_data_sql[forum_id]

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

+ * language key.

+ * @since 3.1-A1

+ */

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

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

+

+ global $db, $user, $phpbb_dispatcher;

+ /**

+ * Event when we move all children of one forum to another

+ *

+ * This event may be triggered, when a forum is deleted

+ *

+ * @event core.acp_manage_forums_move_children

+ * @var int from_id If of the current parent forum

+ * @var int to_id If of the new parent forum

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

+ * language key.

+ * @since 3.1-A1

+ */

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

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

+

+ // Return if there were errors

+ if (!empty($errors))

+ {

+ return $errors;

+ }

+

+ global $db, $phpbb_dispatcher;

+

+ $errors = array();

+

+ /**

+ * Event when we move content from one forum to another

+ *

+ * @event core.acp_manage_forums_move_children

+ * @var int from_id If of the current parent forum

+ * @var int to_id If of the new parent forum

+ * @var bool sync Shall we sync the "to"-forum's data

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

+ * language key. If this array is not empty,

+ * The content will not be moved.

+ * @since 3.1-A1

+ */

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

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

+

+ // Return if there were errors

+ if (!empty($errors))

+ {

+ return $errors;

+ }

+ global $request;

+ $uploadfile = $request->file('uploadfile');

+ if (!empty($uploadfile['tmp_name']) || $data['uploadurl'] || $data['remotelink'])

+ if ((!empty($uploadfile['tmp_name']) || $data['uploadurl']) && $can_upload)

+ phpbb_generate_template_pagination($template, $base_url, 'pagination', 'start', $total_members, $config['topics_per_page'], $start);

+

+

+ phpbb_generate_template_pagination($template, $this->u_action, 'pagination', 'start', $item_count, $config['smilies_per_page'], $pagination_start);

+ user_delete('retain', $mark, true);

+ phpbb_generate_template_pagination($template, $base_url, 'pagination', 'start', $inactive_count, $per_page, $start);

+

+ $transfer = new ftp(

+ request_var('host', ''),

+ request_var('username', ''),

+ htmlspecialchars_decode($request->untrimmed_variable('password', '')),

+ request_var('root_path', ''),

+ request_var('port', ''),

+ request_var('timeout', '')

+ );

+ $transfer = new ftp_fsock(

+ request_var('host', ''),

+ request_var('username', ''),

+ htmlspecialchars_decode($request->untrimmed_variable('password', '')),

+ request_var('root_path', ''),

+ request_var('port', ''),

+ request_var('timeout', '')

+ );

+ $transfer = new $method(

+ request_var('host', ''),

+ request_var('username', ''),

+ htmlspecialchars_decode($request->untrimmed_variable('password', '')),

+ request_var('root_path', ''),

+ request_var('port', ''),

+ request_var('timeout', '')

+ );

+

+ if ($auth->acl_get('a_server') && version_compare(PHP_VERSION, '5.3.3', '<'))

+ 'FORUM_NAMES' => implode($user->lang['COMMA_SEPARATOR'], $forum_names))

+ 'field_show_novalue'=> 0,

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

+ 'field_show_novalue',

+ 'S_FIELD_SHOW_NOVALUE'=> ($cp->vars['field_show_novalue']) ? true : false,

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

+ $this->get_prune_users($user_ids, $usernames);

+ user_delete('remove', $user_ids);

+ user_delete('retain', $user_ids, true);

+ 'USER_ID' => $user_id,

+ $s_group_list = '';

+ $sql = 'SELECT group_id, group_name

+ FROM ' . GROUPS_TABLE . '

+ WHERE group_type <> ' . GROUP_SPECIAL . '

+ ORDER BY group_name ASC';

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

+

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

+ {

+ $s_group_list .= '<option value="' . $row['group_id'] . '">' . $row['group_name'] . '</select>';

+ }

+ $db->sql_freeresult($result);

+

+ 'S_GROUP_LIST' => $s_group_list,

+ $users_by_name = request_var('users', '', true);

+ $users_by_id = request_var('user_ids', array(0));

+ $group_id = request_var('group_id', 0);

+ $posts_on_queue = request_var('posts_on_queue', 0);

+

+ if ($users_by_name)

+ $users = explode("\n", $users_by_name);

+ else if (!empty($users_by_id))

+ {

+ $user_ids = $users_by_id;

+ user_get_id_name($user_ids, $usernames);

+

+ $where_sql = ' AND ' . $db->sql_in_set('user_id', $user_ids);

+ }

+ $username = request_var('username', '', true);

+ $website = request_var('website', '');

+ $queue_select = request_var('queue_select', 'gt');

+ $joined_before = request_var('joined_before', '');

+ $joined_after = request_var('joined_after', '');

+ $count = request_var('count', 0);

+

+ $joined_before = ($joined_before) ? explode('-', $joined_before) : array();

+ $joined_after = ($joined_after) ? explode('-', $joined_after) : array();

+ // calculate the conditions required by the join time criteria

+ $joined_sql = '';

+ if (!empty($joined_before) && !empty($joined_after))

+ // if the two entered dates are equal, we need to adjust

+ // so that our time range is a full day instead of 1 second

+ if ($joined_after == $joined_before)

+ {

+ $joined_after[2] += 1;

+ }

+

+ $joined_sql = ' AND user_regdate BETWEEN ' . gmmktime(0, 0, 0, (int) $joined_after[1], (int) $joined_after[2], (int) $joined_after[0]) .

+ ' AND ' . gmmktime(0, 0, 0, (int) $joined_before[1], (int) $joined_before[2], (int) $joined_before[0]);

+ else if (empty($joined_before) && !empty($joined_after))

+ {

+ $joined_sql = ' AND user_regdate > ' . gmmktime(0, 0, 0, (int) $joined_after[1], (int) $joined_after[2], (int) $joined_after[0]);

+ }

+ else if (empty($joined_after) && !empty($joined_before))

+ {

+ $joined_sql = ' AND user_regdate < ' . gmmktime(0, 0, 0, (int) $joined_before[1], (int) $joined_before[2], (int) $joined_before[0]);

+ }

+ // implicit else when both arrays are empty do nothing

+ if ((sizeof($active) && sizeof($active) != 3) || (sizeof($joined_before) && sizeof($joined_before) != 3) || (sizeof($joined_after) && sizeof($joined_after) != 3))

+ {

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

+ }

+ $where_sql .= ($website) ? ' AND user_website ' . $db->sql_like_expression(str_replace('*', $db->any_char, $website)) . ' ' : '';

+ $where_sql .= $joined_sql;

+ $where_sql .= ($count) ? " AND user_posts " . $key_match[$count_select] . ' ' . (int) $count . ' ' : '';

+

+ if ($group_id)

+ {

+ $sql = 'SELECT user_id

+ FROM ' . USER_GROUP_TABLE . '

+ WHERE group_id = ' . (int) $group_id . '

+ AND user_pending = 0

+ AND ' . $db->sql_in_set('user_id', $user_ids, false, true);

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

+

+ // we're performing an intersection operation, so all the relevant users

+ // come from this most recent query (which was limited to the results of the

+ // previous query)

+ $user_ids = $usernames = array();

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

+ {

+ $user_ids[] = $row['poster_id'];

+ }

+ $db->sql_freeresult($result);

+

+ // only get usernames if they are needed (not part of some later query)

+ if (!$posts_on_queue)

+ {

+ // this is an additional query aginst the users table

+ user_get_id_name($user_ids, $usernames);

+ }

+ }

+

+ if ($posts_on_queue)

+ {

+ $sql = 'SELECT poster_id, COUNT(post_id) AS queue_posts

+ FROM ' . POSTS_TABLE . '

+ WHERE ' . $db->sql_in_set('poster_id', $user_ids, false, true) . '

+ GROUP BY poster_id

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

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

+

+ // same intersection logic as the above group ID portion

+ $user_ids = $usernames = array();

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

+ {

+ $user_ids[] = $row['poster_id'];

+ }

+ $db->sql_freeresult($result);

+

+ // do an additional query to get the correct set of usernames

+ user_get_id_name($user_ids, $usernames);

+ }

+

+

+ 'S_AVAILABLE_TITLES' => implode($user->lang['COMMA_SEPARATOR'], array_map('htmlspecialchars', array_keys($user->lang['report_reasons']['TITLE']))),

+

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

+ if (!class_exists($type) || !method_exists($type, 'keyword_search'))

+ $search = new $type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ global $db, $user, $phpbb_admin_path, $phpbb_root_path, $phpEx, $template, $request, $cache, $auth, $config;

+ $this->php_ext = $phpEx;

+ $this->u_base_action = append_sid("{$phpbb_admin_path}index.{$this->php_ext}", "i={$id}");

+ global $phpbb_dispatcher, $request;

+

+ default:

+ /**

+ * Run custom quicktool code

+ *

+ * @event core.acp_users_overview_run_quicktool

+ * @var array user_row Current user data

+ * @var string action Quick tool that should be run

+ * @since 3.1-A1

+ */

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

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

+ break;

+ 'new_password' => $request->variable('new_password', '', true),

+ 'password_confirm' => $request->variable('password_confirm', '', true),

+ /**

+ * Modify user data before we update it

+ *

+ * @event core.acp_users_overview_modify_data

+ * @var array user_row Current user data

+ * @var array data Submitted user data

+ * @var array sql_ary User data we udpate

+ * @since 3.1-A1

+ */

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

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

+

+ /**

+ * Add additional quick tool options and overwrite user data

+ *

+ * @event core.acp_users_display_overview

+ * @var array user_row Array with user data

+ * @var array quick_tool_ary Ouick tool options

+ * @since 3.1-A1

+ */

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

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

+

+ $s_action_options = '<option class="sep" value="">' . $user->lang['SELECT_OPTION'] . '</option>';

+ foreach ($quick_tool_ary as $value => $lang)

+ {

+ $s_action_options .= '<option value="' . $value . '">' . $user->lang['USER_ADMIN_' . $lang] . '</option>';

+ }

+

+

+ add_log('admin', 'LOG_ATTACHMENTS_DELETED', implode($user->lang['COMMA_SEPARATOR'], $log_attachments));

+

+ 'USER_GROUPS_DEFAULT' => ($user_mode == 'user' && isset($user_groups_default[$ug_id]) && sizeof($user_groups_default[$ug_id])) ? implode($user->lang['COMMA_SEPARATOR'], $user_groups_default[$ug_id]) : '',

+ 'USER_GROUPS_CUSTOM' => ($user_mode == 'user' && isset($user_groups_custom[$ug_id]) && sizeof($user_groups_custom[$ug_id])) ? implode($user->lang['COMMA_SEPARATOR'], $user_groups_custom[$ug_id]) : '',

+<?php

+/**

+*

+* @package acp

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @package module_install

+*/

+class acp_extensions_info

+{

+ function module()

+ {

+ return array(

+ 'filename' => 'acp_extensions',

+ 'title' => 'ACP_EXTENSIONS',

+ 'version' => '1.0.0',

+ 'modes' => array(

+ 'main' => array('title' => 'ACP_EXTENSIONS', 'auth' => 'acl_a_extensions', 'cat' => array('ACP_GENERAL_TASKS')),

+ ),

+ );

+ }

+

+ function install()

+ {

+ }

+

+ function uninstall()

+ {

+ }

+}

+ // Auth plugins get the password untrimmed.

+ // For compatibility we trim() here.

+ $password = trim($password);

+

+ <dt><label for="ldap_server">' . $user->lang['LDAP_SERVER'] . $user->lang['COLON'] . '</label><br /><span>' . $user->lang['LDAP_SERVER_EXPLAIN'] . '</span></dt>

+ <dt><label for="ldap_port">' . $user->lang['LDAP_PORT'] . $user->lang['COLON'] . '</label><br /><span>' . $user->lang['LDAP_PORT_EXPLAIN'] . '</span></dt>

+ <dt><label for="ldap_dn">' . $user->lang['LDAP_DN'] . $user->lang['COLON'] . '</label><br /><span>' . $user->lang['LDAP_DN_EXPLAIN'] . '</span></dt>

+ <dt><label for="ldap_uid">' . $user->lang['LDAP_UID'] . $user->lang['COLON'] . '</label><br /><span>' . $user->lang['LDAP_UID_EXPLAIN'] . '</span></dt>

+ <dt><label for="ldap_user_filter">' . $user->lang['LDAP_USER_FILTER'] . $user->lang['COLON'] . '</label><br /><span>' . $user->lang['LDAP_USER_FILTER_EXPLAIN'] . '</span></dt>

+ <dt><label for="ldap_email">' . $user->lang['LDAP_EMAIL'] . $user->lang['COLON'] . '</label><br /><span>' . $user->lang['LDAP_EMAIL_EXPLAIN'] . '</span></dt>

+ <dt><label for="ldap_user">' . $user->lang['LDAP_USER'] . $user->lang['COLON'] . '</label><br /><span>' . $user->lang['LDAP_USER_EXPLAIN'] . '</span></dt>

+ <dt><label for="ldap_password">' . $user->lang['LDAP_PASSWORD'] . $user->lang['COLON'] . '</label><br /><span>' . $user->lang['LDAP_PASSWORD_EXPLAIN'] . '</span></dt>

+ $template = new phpbb_template($phpbb_root_path, $phpEx, $config, $user, $style_resource_locator, new phpbb_template_context());

+

+ return $query_id;

+abstract class phpbb_cache_driver_memory extends phpbb_cache_driver_base

+

+ return $query_id;

+ public function __get($var)

+ {

+ return $this->driver->$var;

+ }

+

+ return $parsed_array;

+ // Re-parse cfg file

+

+

+ public function sql_load()

+ {

+ return call_user_func_array(array($this->driver, __FUNCTION__), func_get_args());

+ }

+

+ public function sql_save($query, &$query_result, $ttl)

+ {

+ return call_user_func_array(array($this->driver, __FUNCTION__), array($query, &$query_result, $ttl));

+ }

+

+ public function sql_exists()

+ {

+ return call_user_func_array(array($this->driver, __FUNCTION__), func_get_args());

+ }

+

+ public function sql_fetchrow()

+ {

+ return call_user_func_array(array($this->driver, __FUNCTION__), func_get_args());

+ }

+

+ public function sql_fetchfield()

+ {

+ return call_user_func_array(array($this->driver, __FUNCTION__), func_get_args());

+ }

+

+ public function sql_rowseek()

+ {

+ return call_user_func_array(array($this->driver, __FUNCTION__), func_get_args());

+ }

+

+ public function sql_freeresult()

+ {

+ return call_user_func_array(array($this->driver, __FUNCTION__), func_get_args());

+ }

+ static public function get_instance($name)

+ static public function get_instance()

+ static public function is_available()

+ return @extension_loaded('gd');

+ static public function get_name()

+ static public function get_instance()

+ static public function is_available()

+ return @extension_loaded('gd');

+ static public function get_name()

+ static public function get_instance()

+ static public function is_available()

+ static public function get_name()

+ static public function get_instance()

+ static public function is_installed()

+ static public function is_available()

+ if (!self::is_installed())

+ static public function get_name()

+ if (!self::is_installed())

+ static public function get_instance()

+ static public function is_available()

+ static public function get_name()

+ 'S_RECAPTCHA_AVAILABLE' => self::is_available(),

+define('SPHINX_TABLE', $table_prefix . 'sphinx');

+ protected $phpbb_root_path;

+ protected $php_ext;

+

+ * @param array|Traversable $tasks Provides an iterable set of task names

+ public function __construct($tasks, $phpbb_root_path, $php_ext)

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+

+ $this->load_tasks($tasks);

+ * @param array|Traversable $tasks Array of instances of phpbb_cron_task

+ public function load_tasks($tasks)

+ foreach ($tasks as $task)

+ $this->tasks[] = $this->wrap_task($task);

+ * Wraps a task inside an instance of phpbb_cron_task_wrapper.

+ * @param phpbb_cron_task $task The task.

+ * @return phpbb_cron_task_wrapper The wrapped task.

+ public function wrap_task(phpbb_cron_task $task)

+ return new phpbb_cron_task_wrapper($task, $this->phpbb_root_path, $this->php_ext);

+ private $name;

+

+ /**

+ * Returns the name of the task.

+ *

+ * @return string Name of wrapped task.

+ */

+ public function get_name()

+ {

+ return $this->name;

+ }

+

+ /**

+ * Sets the name of the task.

+ *

+ * @param string $name The task name

+ */

+ public function set_name($name)

+ {

+ $this->name = $name;

+ }

+

+ protected $phpbb_root_path;

+ protected $php_ext;

+ protected $config;

+ protected $db;

+

+ /**

+ * Constructor.

+ *

+ * @param string $phpbb_root_path The root path

+ * @param string $php_ext The PHP extension

+ * @param phpbb_config $config The config

+ * @param dbal $db The db connection

+ */

+ public function __construct($phpbb_root_path, $php_ext, phpbb_config $config, phpbb_db_driver $db)

+ {

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ $this->config = $config;

+ $this->db = $db;

+ }

+

+ include($this->phpbb_root_path . 'includes/functions_admin.' . $this->php_ext);

+ WHERE enable_prune = 1

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

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

+ $this->db->sql_freeresult($result);

+ return (bool) $this->config['use_system_cron'];

+ protected $phpbb_root_path;

+ protected $php_ext;

+ protected $config;

+ protected $db;

+ */

+ protected $forum_data;

+

+ /**

+ * Constructor.

+ *

+ * @param string $phpbb_root_path The root path

+ * @param string $php_ext The PHP extension

+ * @param phpbb_config $config The config

+ * @param dbal $db The db connection

+ */

+ public function __construct($phpbb_root_path, $php_ext, phpbb_config $config, phpbb_db_driver $db)

+ {

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ $this->config = $config;

+ $this->db = $db;

+ }

+

+ /**

+ * Manually set forum data.

+ public function set_forum_data($forum_data)

+ $this->forum_data = $forum_data;

+ include($this->phpbb_root_path . 'includes/functions_admin.' . $this->php_ext);

+ return !$this->config['use_system_cron'] && $this->forum_data;

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

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

+ $this->db->sql_freeresult($result);

+ protected $phpbb_root_path;

+ protected $php_ext;

+ protected $config;

+

+ /**

+ * Constructor.

+ *

+ * @param string $phpbb_root_path The root path

+ * @param string $php_ext The PHP extension

+ * @param phpbb_config $config The config

+ */

+ public function __construct($phpbb_root_path, $php_ext, phpbb_config $config)

+ {

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ $this->config = $config;

+ }

+

+ include($this->phpbb_root_path . 'includes/functions_messenger.' . $this->php_ext);

+ return file_exists($this->phpbb_root_path . 'cache/queue.' . $this->php_ext);

+ return $this->config['last_queue_run'] < time() - $this->config['queue_interval_config'];

+ protected $config;

+ protected $cache;

+

+ /**

+ * Constructor.

+ *

+ * @param phpbb_config $config The config

+ * @param phpbb_cache_driver_interface $cache The cache driver

+ */

+ public function __construct(phpbb_config $config, phpbb_cache_driver_interface $cache)

+ {

+ $this->config = $config;

+ $this->cache = $cache;

+ }

+

+ $this->cache->tidy();

+ return true;

+ return $this->config['cache_last_gc'] < time() - $this->config['cache_gc'];

+ protected $phpbb_root_path;

+ protected $php_ext;

+ protected $config;

+

+ /**

+ * Constructor.

+ *

+ * @param string $phpbb_root_path The root path

+ * @param string $php_ext The PHP extension

+ * @param phpbb_config $config The config

+ */

+ public function __construct($phpbb_root_path, $php_ext, phpbb_config $config)

+ {

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ $this->config = $config;

+ }

+

+ include($this->phpbb_root_path . 'includes/functions_admin.' . $this->php_ext);

+ return $this->config['database_last_gc'] < time() - $this->config['database_gc'];

+ protected $phpbb_root_path;

+ protected $php_ext;

+ protected $auth;

+ protected $config;

+ protected $db;

+ protected $user;

+

+ /**

+ * Constructor.

+ *

+ * @param string $phpbb_root_path The root path

+ * @param string $php_ext The PHP extension

+ * @param phpbb_auth $auth The auth

+ * @param phpbb_config $config The config

+ * @param dbal $db The db connection

+ * @param phpbb_user $user The user

+ */

+ public function __construct($phpbb_root_path, $php_ext, phpbb_auth $auth, phpbb_config $config, phpbb_db_driver $db, phpbb_user $user)

+ {

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ $this->auth = $auth;

+ $this->config = $config;

+ $this->db = $db;

+ $this->user = $user;

+ }

+

+ $search_type = basename($this->config['search_type']);

+ include($this->phpbb_root_path . "includes/search/$search_type." . $this->php_ext);

+ $search = new $search_type($error, $this->phpbb_root_path, $this->php_ext, $this->auth, $this->config, $this->db, $this->user);

+ $search_type = basename($this->config['search_type']);

+ return file_exists($this->phpbb_root_path . 'includes/search/' . $search_type . '.' . $this->php_ext);

+ return $this->config['search_last_gc'] < time() - $this->config['search_gc'];

+ protected $config;

+ protected $user;

+

+ /**

+ * Constructor.

+ *

+ * @param phpbb_config $config The config

+ * @param phpbb_user $user The user

+ */

+ public function __construct(phpbb_config $config, phpbb_user $user)

+ {

+ $this->config = $config;

+ $this->user = $user;

+ }

+

+ $this->user->session_gc();

+ return $this->config['session_last_gc'] < time() - $this->config['session_gc'];

+ protected $phpbb_root_path;

+ protected $php_ext;

+ protected $config;

+

+ /**

+ * Constructor.

+ *

+ * @param string $phpbb_root_path The root path

+ * @param string $php_ext The PHP extension

+ * @param phpbb_config $config The config

+ */

+ public function __construct($phpbb_root_path, $php_ext, phpbb_config $config)

+ {

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ $this->config = $config;

+ }

+

+ include($this->phpbb_root_path . 'includes/functions_admin.' . $this->php_ext);

+ return (bool) $this->config['warnings_expire_days'];

+ return $this->config['warnings_last_gc'] < time() - $this->config['warnings_gc'];

+use Symfony\Component\DependencyInjection\TaggedContainerInterface;

+

+class phpbb_cron_task_provider implements IteratorAggregate

+ private $container;

+

+ public function __construct(TaggedContainerInterface $container)

+ {

+ $this->container = $container;

+ }

+

+ * Retrieve an iterator over all items

+ * @return ArrayIterator An iterator for the array of cron tasks

+ public function getIterator()

+ $definitions = $this->container->findTaggedServiceIds('cron.task');

+

+ $tasks = array();

+ foreach ($definitions as $name => $definition)

+ {

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

+ if ($task instanceof phpbb_cron_task_base)

+ {

+ $task->set_name($name);

+ }

+

+ $tasks[] = $task;

+ }

+ return new ArrayIterator($tasks);

+ * Returns the name of the task.

+ *

+ * @return string Name of wrapped task.

+ */

+ public function get_name();

+

+ /**

+ protected $task;

+ protected $phpbb_root_path;

+ protected $php_ext;

+

+ public function __construct(phpbb_cron_task $task, $phpbb_root_path, $php_ext)

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ $url = append_sid($this->phpbb_root_path . 'cron.' . $this->php_ext, 'cron_type=' . $name . $extra);

+<?php

+/**

+*

+* @package dbal

+* @copyright (c) 2005 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Database Abstraction Layer

+* @package dbal

+*/

+class dbal

+{

+ var $db_connect_id;

+ var $query_result;

+ var $return_on_error = false;

+ var $transaction = false;

+ var $sql_time = 0;

+ var $num_queries = array();

+ var $open_queries = array();

+

+ var $curtime = 0;

+ var $query_hold = '';

+ var $html_hold = '';

+ var $sql_report = '';

+

+ var $persistency = false;

+ var $user = '';

+ var $server = '';

+ var $dbname = '';

+

+ // Set to true if error triggered

+ var $sql_error_triggered = false;

+

+ // Holding the last sql query on sql error

+ var $sql_error_sql = '';

+ // Holding the error information - only populated if sql_error_triggered is set

+ var $sql_error_returned = array();

+

+ // Holding transaction count

+ var $transactions = 0;

+

+ // Supports multi inserts?

+ var $multi_insert = false;

+

+ /**

+ * Current sql layer

+ */

+ var $sql_layer = '';

+

+ /**

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

+ */

+ var $any_char;

+ var $one_char;

+

+ /**

+ * Exact version of the DBAL, directly queried

+ */

+ var $sql_server_version = false;

+

+ /**

+ * Constructor

+ */

+ function dbal()

+ {

+ $this->num_queries = array(

+ 'cached' => 0,

+ 'normal' => 0,

+ 'total' => 0,

+ );

+

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

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

+ $this->sql_layer = substr(get_class($this), 5);

+

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

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

+ $this->one_char = chr(0) . '_';

+ }

+

+ /**

+ * return on error or display error message

+ */

+ function sql_return_on_error($fail = false)

+ {

+ $this->sql_error_triggered = false;

+ $this->sql_error_sql = '';

+

+ $this->return_on_error = $fail;

+ }

+

+ /**

+ * Return number of sql queries and cached sql queries used

+ */

+ function sql_num_queries($cached = false)

+ {

+ return ($cached) ? $this->num_queries['cached'] : $this->num_queries['normal'];

+ }

+

+ /**

+ * Add to query count

+ */

+ function sql_add_num_queries($cached = false)

+ {

+ $this->num_queries['cached'] += ($cached !== false) ? 1 : 0;

+ $this->num_queries['normal'] += ($cached !== false) ? 0 : 1;

+ $this->num_queries['total'] += 1;

+ }

+

+ /**

+ * DBAL garbage collection, close sql connection

+ */

+ function sql_close()

+ {

+ if (!$this->db_connect_id)

+ {

+ return false;

+ }

+

+ if ($this->transaction)

+ {

+ do

+ {

+ $this->sql_transaction('commit');

+ }

+ while ($this->transaction);

+ }

+

+ foreach ($this->open_queries as $query_id)

+ {

+ $this->sql_freeresult($query_id);

+ }

+

+ // Connection closed correctly. Set db_connect_id to false to prevent errors

+ if ($result = $this->_sql_close())

+ {

+ $this->db_connect_id = false;

+ }

+

+ return $result;

+ }

+

+ /**

+ * Build LIMIT query

+ * Doing some validation here.

+ */

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

+ {

+ if (empty($query))

+ {

+ return false;

+ }

+

+ // Never use a negative total or offset

+ $total = ($total < 0) ? 0 : $total;

+ $offset = ($offset < 0) ? 0 : $offset;

+

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

+ }

+

+ /**

+ * Fetch all rows

+ */

+ function sql_fetchrowset($query_id = false)

+ {

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

+ if ($query_id !== false)

+ {

+ $result = array();

+ while ($row = $this->sql_fetchrow($query_id))

+ {

+ $result[] = $row;

+ }

+

+ return $result;

+ }

+

+ return false;

+ }

+

+ /**

+ * Seek to given row number

+ * rownum is zero-based

+ */

+ function sql_rowseek($rownum, &$query_id)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

+ if ($cache->sql_exists($query_id))

+ {

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

+ }

+

+ if ($query_id === false)

+ {

+ return false;

+ }

+

+ $this->sql_freeresult($query_id);

+ $query_id = $this->sql_query($this->last_query_text);

+

+ if ($query_id === false)

+ {

+ return false;

+ }

+

+ // We do not fetch the row for rownum == 0 because then the next resultset would be the second row

+ for ($i = 0; $i < $rownum; $i++)

+ {

+ if (!$this->sql_fetchrow($query_id))

+ {

+ return false;

+ }

+ }

+

+ return true;

+ }

+

+ /**

+ * Fetch field

+ * if rownum is false, the current row is used, else it is pointing to the row (zero-based)

+ */

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

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

+ if ($query_id !== false)

+ {

+ if ($rownum !== false)

+ {

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

+ }

+

+ if (!is_object($query_id) && $cache->sql_exists($query_id))

+ {

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

+ }

+

+ $row = $this->sql_fetchrow($query_id);

+ return (isset($row[$field])) ? $row[$field] : false;

+ }

+

+ return false;

+ }

+

+ /**

+ * Correctly adjust LIKE expression for special characters

+ * Some DBMS are handling them in a different way

+ *

+ * @param string $expression The expression to use. Every wildcard is escaped, except $this->any_char and $this->one_char

+ * @return string LIKE expression including the keyword!

+ */

+ function sql_like_expression($expression)

+ {

+ $expression = utf8_str_replace(array('_', '%'), array("\_", "\%"), $expression);

+ $expression = utf8_str_replace(array(chr(0) . "\_", chr(0) . "\%"), array('_', '%'), $expression);

+

+ return $this->_sql_like_expression('LIKE \'' . $this->sql_escape($expression) . '\'');

+ }

+

+ /**

+ * Build a case expression

+ *

+ * Note: The two statements action_true and action_false must have the same data type (int, vchar, ...) in the database!

+ *

+ * @param string $condition The condition which must be true, to use action_true rather then action_else

+ * @param string $action_true SQL expression that is used, if the condition is true

+ * @param string $action_else SQL expression that is used, if the condition is false, optional

+ * @return string CASE expression including the condition and statements

+ */

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

+ {

+ $sql_case = 'CASE WHEN ' . $condition;

+ $sql_case .= ' THEN ' . $action_true;

+ $sql_case .= ($action_false !== false) ? ' ELSE ' . $action_false : '';

+ $sql_case .= ' END';

+ return $sql_case;

+ }

+

+ /**

+ * Build a concatenated expression

+ *

+ * @param string $expr1 Base SQL expression where we append the second one

+ * @param string $expr2 SQL expression that is appended to the first expression

+ * @return string Concatenated string

+ */

+ public function sql_concatenate($expr1, $expr2)

+ {

+ return $expr1 . ' || ' . $expr2;

+ }

+

+ /**

+ * Returns whether results of a query need to be buffered to run a transaction while iterating over them.

+ *

+ * @return bool Whether buffering is required.

+ */

+ function sql_buffer_nested_transactions()

+ {

+ return false;

+ }

+

+ /**

+ * SQL Transaction

+ * @access private

+ */

+ function sql_transaction($status = 'begin')

+ {

+ switch ($status)

+ {

+ case 'begin':

+ // If we are within a transaction we will not open another one, but enclose the current one to not loose data (prevening auto commit)

+ if ($this->transaction)

+ {

+ $this->transactions++;

+ return true;

+ }

+

+ $result = $this->_sql_transaction('begin');

+

+ if (!$result)

+ {

+ $this->sql_error();

+ }

+

+ $this->transaction = true;

+ break;

+

+ case 'commit':

+ // If there was a previously opened transaction we do not commit yet... but count back the number of inner transactions

+ if ($this->transaction && $this->transactions)

+ {

+ $this->transactions--;

+ return true;

+ }

+

+ // Check if there is a transaction (no transaction can happen if there was an error, with a combined rollback and error returning enabled)

+ // This implies we have transaction always set for autocommit db's

+ if (!$this->transaction)

+ {

+ return false;

+ }

+

+ $result = $this->_sql_transaction('commit');

+

+ if (!$result)

+ {

+ $this->sql_error();

+ }

+

+ $this->transaction = false;

+ $this->transactions = 0;

+ break;

+

+ case 'rollback':

+ $result = $this->_sql_transaction('rollback');

+ $this->transaction = false;

+ $this->transactions = 0;

+ break;

+

+ default:

+ $result = $this->_sql_transaction($status);

+ break;

+ }

+

+ return $result;

+ }

+

+ /**

+ * Build sql statement from array for insert/update/select statements

+ *

+ * Idea for this from Ikonboard

+ * Possible query values: INSERT, INSERT_SELECT, UPDATE, SELECT

+ *

+ */

+ function sql_build_array($query, $assoc_ary = false)

+ {

+ if (!is_array($assoc_ary))

+ {

+ return false;

+ }

+

+ $fields = $values = array();

+

+ if ($query == 'INSERT' || $query == 'INSERT_SELECT')

+ {

+ foreach ($assoc_ary as $key => $var)

+ {

+ $fields[] = $key;

+

+ if (is_array($var) && is_string($var[0]))

+ {

+ // This is used for INSERT_SELECT(s)

+ $values[] = $var[0];

+ }

+ else

+ {

+ $values[] = $this->_sql_validate_value($var);

+ }

+ }

+

+ $query = ($query == 'INSERT') ? ' (' . implode(', ', $fields) . ') VALUES (' . implode(', ', $values) . ')' : ' (' . implode(', ', $fields) . ') SELECT ' . implode(', ', $values) . ' ';

+ }

+ else if ($query == 'MULTI_INSERT')

+ {

+ trigger_error('The MULTI_INSERT query value is no longer supported. Please use sql_multi_insert() instead.', E_USER_ERROR);

+ }

+ else if ($query == 'UPDATE' || $query == 'SELECT')

+ {

+ $values = array();

+ foreach ($assoc_ary as $key => $var)

+ {

+ $values[] = "$key = " . $this->_sql_validate_value($var);

+ }

+ $query = implode(($query == 'UPDATE') ? ', ' : ' AND ', $values);

+ }

+

+ return $query;

+ }

+

+ /**

+ * Build IN or NOT IN sql comparison string, uses <> or = on single element

+ * arrays to improve comparison speed

+ *

+ * @access public

+ * @param string $field name of the sql column that shall be compared

+ * @param array $array array of values that are allowed (IN) or not allowed (NOT IN)

+ * @param bool $negate true for NOT IN (), false for IN () (default)

+ * @param bool $allow_empty_set If true, allow $array to be empty, this function will return 1=1 or 1=0 then. Default to false.

+ */

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

+ {

+ if (!sizeof($array))

+ {

+ if (!$allow_empty_set)

+ {

+ // Print the backtrace to help identifying the location of the problematic code

+ $this->sql_error('No values specified for SQL IN comparison');

+ }

+ else

+ {

+ // NOT IN () actually means everything so use a tautology

+ if ($negate)

+ {

+ return '1=1';

+ }

+ // IN () actually means nothing so use a contradiction

+ else

+ {

+ return '1=0';

+ }

+ }

+ }

+

+ if (!is_array($array))

+ {

+ $array = array($array);

+ }

+

+ if (sizeof($array) == 1)

+ {

+ @reset($array);

+ $var = current($array);

+

+ return $field . ($negate ? ' <> ' : ' = ') . $this->_sql_validate_value($var);

+ }

+ else

+ {

+ return $field . ($negate ? ' NOT IN ' : ' IN ') . '(' . implode(', ', array_map(array($this, '_sql_validate_value'), $array)) . ')';

+ }

+ }

+

+ /**

+ * Run binary AND operator on DB column.

+ * Results in sql statement: "{$column_name} & (1 << {$bit}) {$compare}"

+ *

+ * @param string $column_name The column name to use

+ * @param int $bit The value to use for the AND operator, will be converted to (1 << $bit). Is used by options, using the number schema... 0, 1, 2...29

+ * @param string $compare Any custom SQL code after the check (for example "= 0")

+ */

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

+ {

+ if (method_exists($this, '_sql_bit_and'))

+ {

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

+ }

+

+ return $column_name . ' & ' . (1 << $bit) . (($compare) ? ' ' . $compare : '');

+ }

+

+ /**

+ * Run binary OR operator on DB column.

+ * Results in sql statement: "{$column_name} | (1 << {$bit}) {$compare}"

+ *

+ * @param string $column_name The column name to use

+ * @param int $bit The value to use for the OR operator, will be converted to (1 << $bit). Is used by options, using the number schema... 0, 1, 2...29

+ * @param string $compare Any custom SQL code after the check (for example "= 0")

+ */

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

+ {

+ if (method_exists($this, '_sql_bit_or'))

+ {

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

+ }

+

+ return $column_name . ' | ' . (1 << $bit) . (($compare) ? ' ' . $compare : '');

+ }

+

+ /**

+ * Returns SQL string to cast a string expression to an int.

+ *

+ * @param string $expression An expression evaluating to string

+ * @return string Expression returning an int

+ */

+ function cast_expr_to_bigint($expression)

+ {

+ return $expression;

+ }

+

+ /**

+ * Returns SQL string to cast an integer expression to a string.

+ *

+ * @param string $expression An expression evaluating to int

+ * @return string Expression returning a string

+ */

+ function cast_expr_to_string($expression)

+ {

+ return $expression;

+ }

+

+ /**

+ * Run LOWER() on DB column of type text (i.e. neither varchar nor char).

+ *

+ * @param string $column_name The column name to use

+ *

+ * @return string A SQL statement like "LOWER($column_name)"

+ */

+ function sql_lower_text($column_name)

+ {

+ return "LOWER($column_name)";

+ }

+

+ /**

+ * Run more than one insert statement.

+ *

+ * @param string $table table name to run the statements on

+ * @param array &$sql_ary multi-dimensional array holding the statement data.

+ *

+ * @return bool false if no statements were executed.

+ * @access public

+ */

+ function sql_multi_insert($table, &$sql_ary)

+ {

+ if (!sizeof($sql_ary))

+ {

+ return false;

+ }

+

+ if ($this->multi_insert)

+ {

+ $ary = array();

+ foreach ($sql_ary as $id => $_sql_ary)

+ {

+ // If by accident the sql array is only one-dimensional we build a normal insert statement

+ if (!is_array($_sql_ary))

+ {

+ return $this->sql_query('INSERT INTO ' . $table . ' ' . $this->sql_build_array('INSERT', $sql_ary));

+ }

+

+ $values = array();

+ foreach ($_sql_ary as $key => $var)

+ {

+ $values[] = $this->_sql_validate_value($var);

+ }

+ $ary[] = '(' . implode(', ', $values) . ')';

+ }

+

+ return $this->sql_query('INSERT INTO ' . $table . ' ' . ' (' . implode(', ', array_keys($sql_ary[0])) . ') VALUES ' . implode(', ', $ary));

+ }

+ else

+ {

+ foreach ($sql_ary as $ary)

+ {

+ if (!is_array($ary))

+ {

+ return false;

+ }

+

+ $result = $this->sql_query('INSERT INTO ' . $table . ' ' . $this->sql_build_array('INSERT', $ary));

+

+ if (!$result)

+ {

+ return false;

+ }

+ }

+ }

+

+ return true;

+ }

+

+ /**

+ * Function for validating values

+ * @access private

+ */

+ function _sql_validate_value($var)

+ {

+ if (is_null($var))

+ {

+ return 'NULL';

+ }

+ else if (is_string($var))

+ {

+ return "'" . $this->sql_escape($var) . "'";

+ }

+ else

+ {

+ return (is_bool($var)) ? intval($var) : $var;

+ }

+ }

+

+ /**

+ * Build sql statement from array for select and select distinct statements

+ *

+ * Possible query values: SELECT, SELECT_DISTINCT

+ */

+ function sql_build_query($query, $array)

+ {

+ $sql = '';

+ switch ($query)

+ {

+ case 'SELECT':

+ case 'SELECT_DISTINCT';

+

+ $sql = str_replace('_', ' ', $query) . ' ' . $array['SELECT'] . ' FROM ';

+

+ // Build table array. We also build an alias array for later checks.

+ $table_array = $aliases = array();

+ $used_multi_alias = false;

+

+ foreach ($array['FROM'] as $table_name => $alias)

+ {

+ if (is_array($alias))

+ {

+ $used_multi_alias = true;

+

+ foreach ($alias as $multi_alias)

+ {

+ $table_array[] = $table_name . ' ' . $multi_alias;

+ $aliases[] = $multi_alias;

+ }

+ }

+ else

+ {

+ $table_array[] = $table_name . ' ' . $alias;

+ $aliases[] = $alias;

+ }

+ }

+

+ // We run the following code to determine if we need to re-order the table array. ;)

+ // The reason for this is that for multi-aliased tables (two equal tables) in the FROM statement the last table need to match the first comparison.

+ // DBMS who rely on this: Oracle, PostgreSQL and MSSQL. For all other DBMS it makes absolutely no difference in which order the table is.

+ if (!empty($array['LEFT_JOIN']) && sizeof($array['FROM']) > 1 && $used_multi_alias !== false)

+ {

+ // Take first LEFT JOIN

+ $join = current($array['LEFT_JOIN']);

+

+ // Determine the table used there (even if there are more than one used, we only want to have one

+ preg_match('/(' . implode('|', $aliases) . ')\.[^\s]+/U', str_replace(array('(', ')', 'AND', 'OR', ' '), '', $join['ON']), $matches);

+

+ // If there is a first join match, we need to make sure the table order is correct

+ if (!empty($matches[1]))

+ {

+ $first_join_match = trim($matches[1]);

+ $table_array = $last = array();

+

+ foreach ($array['FROM'] as $table_name => $alias)

+ {

+ if (is_array($alias))

+ {

+ foreach ($alias as $multi_alias)

+ {

+ ($multi_alias === $first_join_match) ? $last[] = $table_name . ' ' . $multi_alias : $table_array[] = $table_name . ' ' . $multi_alias;

+ }

+ }

+ else

+ {

+ ($alias === $first_join_match) ? $last[] = $table_name . ' ' . $alias : $table_array[] = $table_name . ' ' . $alias;

+ }

+ }

+

+ $table_array = array_merge($table_array, $last);

+ }

+ }

+

+ $sql .= $this->_sql_custom_build('FROM', implode(' CROSS JOIN ', $table_array));

+

+ if (!empty($array['LEFT_JOIN']))

+ {

+ foreach ($array['LEFT_JOIN'] as $join)

+ {

+ $sql .= ' LEFT JOIN ' . key($join['FROM']) . ' ' . current($join['FROM']) . ' ON (' . $join['ON'] . ')';

+ }

+ }

+

+ if (!empty($array['WHERE']))

+ {

+ $sql .= ' WHERE ' . $this->_sql_custom_build('WHERE', $array['WHERE']);

+ }

+

+ if (!empty($array['GROUP_BY']))

+ {

+ $sql .= ' GROUP BY ' . $array['GROUP_BY'];

+ }

+

+ if (!empty($array['ORDER_BY']))

+ {

+ $sql .= ' ORDER BY ' . $array['ORDER_BY'];

+ }

+

+ break;

+ }

+

+ return $sql;

+ }

+

+ /**

+ * display sql error page

+ */

+ function sql_error($sql = '')

+ {

+ global $auth, $user, $config;

+

+ // Set var to retrieve errored status

+ $this->sql_error_triggered = true;

+ $this->sql_error_sql = $sql;

+

+ $this->sql_error_returned = $this->_sql_error();

+

+ if (!$this->return_on_error)

+ {

+ $message = 'SQL ERROR [ ' . $this->sql_layer . ' ]<br /><br />' . $this->sql_error_returned['message'] . ' [' . $this->sql_error_returned['code'] . ']';

+

+ // Show complete SQL error and path to administrators only

+ // Additionally show complete error on installation or if extended debug mode is enabled

+ // The DEBUG constant is for development only!

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

+ {

+ $message .= ($sql) ? '<br /><br />SQL<br /><br />' . htmlspecialchars($sql) : '';

+ }

+ else

+ {

+ // If error occurs in initiating the session we need to use a pre-defined language string

+ // This could happen if the connection could not be established for example (then we are not able to grab the default language)

+ if (!isset($user->lang['SQL_ERROR_OCCURRED']))

+ {

+ $message .= '<br /><br />An sql error occurred while fetching this page. Please contact an administrator if this problem persists.';

+ }

+ else

+ {

+ if (!empty($config['board_contact']))

+ {

+ $message .= '<br /><br />' . sprintf($user->lang['SQL_ERROR_OCCURRED'], '<a href="mailto:' . htmlspecialchars($config['board_contact']) . '">', '</a>');

+ }

+ else

+ {

+ $message .= '<br /><br />' . sprintf($user->lang['SQL_ERROR_OCCURRED'], '', '');

+ }

+ }

+ }

+

+ if ($this->transaction)

+ {

+ $this->sql_transaction('rollback');

+ }

+

+ if (strlen($message) > 1024)

+ {

+ // We need to define $msg_long_text here to circumvent text stripping.

+ global $msg_long_text;

+ $msg_long_text = $message;

+

+ trigger_error(false, E_USER_ERROR);

+ }

+

+ trigger_error($message, E_USER_ERROR);

+ }

+

+ if ($this->transaction)

+ {

+ $this->sql_transaction('rollback');

+ }

+

+ return $this->sql_error_returned;

+ }

+

+ /**

+ * Explain queries

+ */

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

+ {

+ global $cache, $starttime, $phpbb_root_path, $user;

+ global $request;

+

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

+ {

+ return false;

+ }

+

+ if (!$query && $this->query_hold != '')

+ {

+ $query = $this->query_hold;

+ }

+

+ switch ($mode)

+ {

+ case 'display':

+ if (!empty($cache))

+ {

+ $cache->unload();

+ }

+ $this->sql_close();

+

+ $mtime = explode(' ', microtime());

+ $totaltime = $mtime[0] + $mtime[1] - $starttime;

+

+ echo '<!DOCTYPE html>

+ <html dir="ltr">

+ <head>

+ <meta charset="utf-8">

+ <title>SQL Report</title>

+ <link href="' . $phpbb_root_path . 'adm/style/admin.css" rel="stylesheet" type="text/css" media="screen" />

+ </head>

+ <body id="errorpage">

+ <div id="wrap">

+ <div id="page-header">

+ <a href="' . build_url('explain') . '">Return to previous page</a>

+ </div>

+ <div id="page-body">

+ <div id="acp">

+ <div class="panel">

+ <span class="corners-top"><span></span></span>

+ <div id="content">

+ <h1>SQL Report</h1>

+ <br />

+ <p><b>Page generated in ' . round($totaltime, 4) . " seconds with {$this->num_queries['normal']} queries" . (($this->num_queries['cached']) ? " + {$this->num_queries['cached']} " . (($this->num_queries['cached'] == 1) ? 'query' : 'queries') . ' returning data from cache' : '') . '</b></p>

+

+ <p>Time spent on ' . $this->sql_layer . ' queries: <b>' . round($this->sql_time, 5) . 's</b> | Time spent on PHP: <b>' . round($totaltime - $this->sql_time, 5) . 's</b></p>

+

+ <br /><br />

+ ' . $this->sql_report . '

+ </div>

+ <span class="corners-bottom"><span></span></span>

+ </div>

+ </div>

+ </div>

+ <div id="page-footer">

+ Powered by <a href="http://www.phpbb.com/">phpBB</a>&reg; Forum Software &copy; phpBB Group

+ </div>

+ </div>

+ </body>

+ </html>';

+

+ exit_handler();

+

+ break;

+

+ case 'stop':

+ $endtime = explode(' ', microtime());

+ $endtime = $endtime[0] + $endtime[1];

+

+ $this->sql_report .= '

+

+ <table cellspacing="1">

+ <thead>

+ <tr>

+ <th>Query #' . $this->num_queries['total'] . '</th>

+ </tr>

+ </thead>

+ <tbody>

+ <tr>

+ <td class="row3"><textarea style="font-family:\'Courier New\',monospace;width:99%" rows="5" cols="10">' . preg_replace('/\t(AND|OR)(\W)/', "\$1\$2", htmlspecialchars(preg_replace('/[\s]*[\n\r\t]+[\n\r\s\t]*/', "\n", $query))) . '</textarea></td>

+ </tr>

+ </tbody>

+ </table>

+

+ ' . $this->html_hold . '

+

+ <p style="text-align: center;">

+ ';

+

+ if ($this->query_result)

+ {

+ if (preg_match('/^(UPDATE|DELETE|REPLACE)/', $query))

+ {

+ $this->sql_report .= 'Affected rows: <b>' . $this->sql_affectedrows($this->query_result) . '</b> | ';

+ }

+ $this->sql_report .= 'Before: ' . sprintf('%.5f', $this->curtime - $starttime) . 's | After: ' . sprintf('%.5f', $endtime - $starttime) . 's | Elapsed: <b>' . sprintf('%.5f', $endtime - $this->curtime) . 's</b>';

+ }

+ else

+ {

+ $error = $this->sql_error();

+ $this->sql_report .= '<b style="color: red">FAILED</b> - ' . $this->sql_layer . ' Error ' . $error['code'] . ': ' . htmlspecialchars($error['message']);

+ }

+

+ $this->sql_report .= '</p><br /><br />';

+

+ $this->sql_time += $endtime - $this->curtime;

+ break;

+

+ case 'start':

+ $this->query_hold = $query;

+ $this->html_hold = '';

+

+ $this->_sql_report($mode, $query);

+

+ $this->curtime = explode(' ', microtime());

+ $this->curtime = $this->curtime[0] + $this->curtime[1];

+

+ break;

+

+ case 'add_select_row':

+

+ $html_table = func_get_arg(2);

+ $row = func_get_arg(3);

+

+ if (!$html_table && sizeof($row))

+ {

+ $html_table = true;

+ $this->html_hold .= '<table cellspacing="1"><tr>';

+

+ foreach (array_keys($row) as $val)

+ {

+ $this->html_hold .= '<th>' . (($val) ? ucwords(str_replace('_', ' ', $val)) : '&nbsp;') . '</th>';

+ }

+ $this->html_hold .= '</tr>';

+ }

+ $this->html_hold .= '<tr>';

+

+ $class = 'row1';

+ foreach (array_values($row) as $val)

+ {

+ $class = ($class == 'row1') ? 'row2' : 'row1';

+ $this->html_hold .= '<td class="' . $class . '">' . (($val) ? $val : '&nbsp;') . '</td>';

+ }

+ $this->html_hold .= '</tr>';

+

+ return $html_table;

+

+ break;

+

+ case 'fromcache':

+

+ $this->_sql_report($mode, $query);

+

+ break;

+

+ case 'record_fromcache':

+

+ $endtime = func_get_arg(2);

+ $splittime = func_get_arg(3);

+

+ $time_cache = $endtime - $this->curtime;

+ $time_db = $splittime - $endtime;

+ $color = ($time_db > $time_cache) ? 'green' : 'red';

+

+ $this->sql_report .= '<table cellspacing="1"><thead><tr><th>Query results obtained from the cache</th></tr></thead><tbody><tr>';

+ $this->sql_report .= '<td class="row3"><textarea style="font-family:\'Courier New\',monospace;width:99%" rows="5" cols="10">' . preg_replace('/\t(AND|OR)(\W)/', "\$1\$2", htmlspecialchars(preg_replace('/[\s]*[\n\r\t]+[\n\r\s\t]*/', "\n", $query))) . '</textarea></td></tr></tbody></table>';

+ $this->sql_report .= '<p style="text-align: center;">';

+ $this->sql_report .= 'Before: ' . sprintf('%.5f', $this->curtime - $starttime) . 's | After: ' . sprintf('%.5f', $endtime - $starttime) . 's | Elapsed [cache]: <b style="color: ' . $color . '">' . sprintf('%.5f', ($time_cache)) . 's</b> | Elapsed [db]: <b>' . sprintf('%.5f', $time_db) . 's</b></p><br /><br />';

+

+ // Pad the start time to not interfere with page timing

+ $starttime += $time_db;

+

+ break;

+

+ default:

+

+ $this->_sql_report($mode, $query);

+

+ break;

+ }

+

+ return true;

+ }

+

+ /**

+ * Gets the estimated number of rows in a specified table.

+ *

+ * @param string $table_name Table name

+ *

+ * @return string Number of rows in $table_name.

+ * Prefixed with ~ if estimated (otherwise exact).

+ *

+ * @access public

+ */

+ function get_estimated_row_count($table_name)

+ {

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

+ }

+

+ /**

+ * Gets the exact number of rows in a specified table.

+ *

+ * @param string $table_name Table name

+ *

+ * @return string Exact number of rows in $table_name.

+ *

+ * @access public

+ */

+ function get_row_count($table_name)

+ {

+ $sql = 'SELECT COUNT(*) AS rows_total

+ FROM ' . $this->sql_escape($table_name);

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

+ $rows_total = $this->sql_fetchfield('rows_total');

+ $this->sql_freeresult($result);

+

+ return $rows_total;

+ }

+}

+

+/**

+* This variable holds the class name to use later

+*/

+$sql_db = (!empty($dbms)) ? 'dbal_' . basename($dbms) : 'dbal';

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\DependencyInjection\ContainerBuilder;

+

+/**

+* Configure the container for phpBB's services though

+* user-defined parameters defined in the config.php file.

+*/

+class phpbb_di_processor_config implements phpbb_di_processor_interface

+{

+ private $config_file;

+ private $phpbb_root_path;

+ private $php_ext;

+

+ /**

+ * Constructor.

+ *

+ * @param string $config_file The config file

+ * @param string $phpbb_root_path The root path

+ * @param string $php_ext The PHP extension

+ */

+ public function __construct($config_file, $phpbb_root_path, $php_ext)

+ {

+ $this->config_file = $config_file;

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function process(ContainerBuilder $container)

+ {

+ require $this->config_file;

+

+ $container->setParameter('core.root_path', $this->phpbb_root_path);

+ $container->setParameter('core.php_ext', $this->php_ext);

+

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

+ $container->setParameter('cache.driver.class', $this->fix_acm_type($acm_type));

+ $container->setParameter('dbal.driver.class', 'phpbb_db_driver_'.$dbms);

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

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

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

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

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

+ $container->setParameter('dbal.new_link', defined('PHPBB_DB_NEW_LINK') && PHPBB_DB_NEW_LINK);

+

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

+ }

+

+ protected function fix_acm_type($acm_type)

+ {

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

+ {

+ return 'phpbb_cache_driver_'.$acm_type;

+ }

+

+ return $acm_type;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\Config\FileLocator;

+use Symfony\Component\DependencyInjection\ContainerBuilder;

+use Symfony\Component\DependencyInjection\Loader\YamlFileLoader;

+

+/**

+* Load the service configurations from all extensions into the container.

+*/

+class phpbb_di_processor_ext implements phpbb_di_processor_interface

+{

+ private $extension_manager;

+

+ /**

+ * Constructor.

+ *

+ * @param string $extension_manager The extension manager

+ */

+ public function __construct($extension_manager)

+ {

+ $this->extension_manager = $extension_manager;

+ }

+

+ /**

+ * @inheritdoc

+ */

+ public function process(ContainerBuilder $container)

+ {

+ $enabled_exts = $this->extension_manager->all_enabled();

+ foreach ($enabled_exts as $name => $path)

+ {

+ if (file_exists($path . '/config/services.yml'))

+ {

+ $loader = new YamlFileLoader($container, new FileLocator($path . '/config'));

+ $loader->load('services.yml');

+ }

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+use Symfony\Component\DependencyInjection\ContainerBuilder;

+

+interface phpbb_di_processor_interface

+{

+ /**

+ * Mutate the container.

+ *

+ * @param ContainerBuilder $container The container

+ */

+ public function process(ContainerBuilder $container);

+}

+ * Request class object

+ * @var phpbb_request

+ * DBAL class object

+ * @var dbal

+ * User class object

+ * @var phpbb_user

+ * Template class object

+ * @var phpbb_template

+ * Config object

+ * @var phpbb_config

+ * PHP Extension

+ * @var string

+ * Relative path to board root

+ * @var string

+ global $phpEx, $phpbb_root_path;

+ $this->php_ext = $phpEx;

+<?php

+/**

+*

+* @package extension

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+ * Exception class for metadata

+ */

+class phpbb_extension_exception extends UnexpectedValueException

+{

+ public function __toString()

+ {

+ return $this->getMessage();

+ }

+} \ No newline at end of file

+ protected $db;

+ protected $config;

+ * @param phpbb_config $config phpbb_config

+ public function __construct(phpbb_db_driver $db, phpbb_config $config, $extension_table, $phpbb_root_path, $php_ext = '.php', phpbb_cache_driver_interface $cache = null, $cache_name = '_ext')

+ $this->config = $config;

+ $this->extensions = array();

+

+ // Do not try to load any extensions when installing or updating

+ // Note: database updater invokes this code, and in 3.0

+ // there is no extension table therefore the rest of this function

+ // fails

+ if (defined('IN_INSTALL'))

+ {

+ return;

+ }

+

+ * Instantiates the metadata manager for the extension with the given name

+ *

+ * @param string $name The extension name

+ * @param string $template The template manager

+ * @return phpbb_extension_metadata_manager Instance of the metadata manager

+ */

+ public function create_extension_metadata_manager($name, phpbb_template $template)

+ {

+ return new phpbb_extension_metadata_manager($name, $this->db, $this, $this->phpbb_root_path, $this->php_ext, $template, $this->config);

+ }

+

+ /**

+<?php

+/**

+*

+* @package extension

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* The extension metadata manager validates and gets meta-data for extensions

+*

+* @package extension

+*/

+class phpbb_extension_metadata_manager

+{

+ protected $phpEx;

+ protected $extension_manager;

+ protected $db;

+ protected $phpbb_root_path;

+ protected $template;

+ protected $ext_name;

+ protected $metadata;

+ protected $metadata_file;

+

+ /**

+ * Creates the metadata manager

+ *

+ * @param dbal $db A database connection

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

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

+ * @param string $phpEx php file extension

+ */

+ public function __construct($ext_name, phpbb_db_driver $db, phpbb_extension_manager $extension_manager, $phpbb_root_path, $phpEx = '.php', phpbb_template $template, phpbb_config $config)

+ {

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->db = $db;

+ $this->config = $config;

+ $this->phpEx = $phpEx;

+ $this->template = $template;

+ $this->extension_manager = $extension_manager;

+ $this->ext_name = $ext_name;

+ $this->metadata = array();

+ $this->metadata_file = '';

+ }

+

+ /**

+ * Processes and gets the metadata requested

+ *

+ * @param string $element All for all metadata that it has and is valid, otherwise specify which section you want by its shorthand term.

+ * @return array Contains all of the requested metadata, throws an exception on failure

+ */

+ public function get_metadata($element = 'all')

+ {

+ $this->set_metadata_file();

+

+ // Fetch the metadata

+ $this->fetch_metadata();

+

+ // Clean the metadata

+ $this->clean_metadata_array();

+

+ switch ($element)

+ {

+ case 'all':

+ default:

+ // Validate the metadata

+ if (!$this->validate())

+ {

+ return false;

+ }

+

+ return $this->metadata;

+ break;

+

+ case 'name':

+ return ($this->validate('name')) ? $this->metadata['name'] : false;

+ break;

+

+ case 'display-name':

+ if (isset($this->metadata['extra']['display-name']))

+ {

+ return $this->metadata['extra']['display-name'];

+ }

+ else

+ {

+ return ($this->validate('name')) ? $this->metadata['name'] : false;

+ }

+ break;

+ }

+ }

+

+ /**

+ * Sets the filepath of the metadata file

+ *

+ * @return boolean Set to true if it exists, throws an exception on failure

+ */

+ private function set_metadata_file()

+ {

+ $ext_filepath = $this->extension_manager->get_extension_path($this->ext_name);

+ $metadata_filepath = $this->phpbb_root_path . $ext_filepath . 'composer.json';

+

+ $this->metadata_file = $metadata_filepath;

+

+ if (!file_exists($this->metadata_file))

+ {

+ throw new phpbb_extension_exception('The required file does not exist: ' . $this->metadata_file);

+ }

+ }

+

+ /**

+ * Gets the contents of the composer.json file

+ *

+ * @return bool True if success, throws an exception on failure

+ */

+ private function fetch_metadata()

+ {

+ if (!file_exists($this->metadata_file))

+ {

+ throw new phpbb_extension_exception('The required file does not exist: ' . $this->metadata_file);

+ }

+ else

+ {

+ if (!($file_contents = file_get_contents($this->metadata_file)))

+ {

+ throw new phpbb_extension_exception('file_get_contents failed on ' . $this->metadata_file);

+ }

+

+ if (($metadata = json_decode($file_contents, true)) === NULL)

+ {

+ throw new phpbb_extension_exception('json_decode failed on ' . $this->metadata_file);

+ }

+

+ $this->metadata = $metadata;

+

+ return true;

+ }

+ }

+

+ /**

+ * This array handles the cleaning of the array

+ *

+ * @return array Contains the cleaned metadata array

+ */

+ private function clean_metadata_array()

+ {

+ return $this->metadata;

+ }

+

+ /**

+ * Validate fields

+ *

+ * @param string $name ("all" for display and enable validation

+ * "display" for name, type, and authors

+ * "name", "type")

+ * @return Bool True if valid, throws an exception if invalid

+ */

+ public function validate($name = 'display')

+ {

+ // Basic fields

+ $fields = array(

+ 'name' => '#^[a-zA-Z0-9_\x7f-\xff]{2,}/[a-zA-Z0-9_\x7f-\xff]{2,}$#',

+ 'type' => '#^phpbb3-extension$#',

+ 'licence' => '#.+#',

+ 'version' => '#.+#',

+ );

+

+ switch ($name)

+ {

+ case 'all':

+ $this->validate('display');

+

+ $this->validate_enable();

+ break;

+

+ case 'display':

+ foreach ($fields as $field => $data)

+ {

+ $this->validate($field);

+ }

+

+ $this->validate_authors();

+ break;

+

+ default:

+ if (isset($fields[$name]))

+ {

+ if (!isset($this->metadata[$name]))

+ {

+ throw new phpbb_extension_exception("Required meta field '$name' has not been set.");

+ }

+

+ if (!preg_match($fields[$name], $this->metadata[$name]))

+ {

+ throw new phpbb_extension_exception("Meta field '$name' is invalid.");

+ }

+ }

+ break;

+ }

+

+ return true;

+ }

+

+ /**

+ * Validates the contents of the authors field

+ *

+ * @return boolean True when passes validation, throws exception if invalid

+ */

+ public function validate_authors()

+ {

+ if (empty($this->metadata['authors']))

+ {

+ throw new phpbb_extension_exception("Required meta field 'authors' has not been set.");

+ }

+

+ foreach ($this->metadata['authors'] as $author)

+ {

+ if (!isset($author['name']))

+ {

+ throw new phpbb_extension_exception("Required meta field 'author name' has not been set.");

+ }

+ }

+

+ return true;

+ }

+

+ /**

+ * This array handles the verification that this extension can be enabled on this board

+ *

+ * @return bool True if validation succeeded, False if failed

+ */

+ public function validate_enable()

+ {

+ // Check for phpBB, PHP versions

+ if (!$this->validate_require_phpbb() || !$this->validate_require_php())

+ {

+ return false;

+ }

+

+ return true;

+ }

+

+

+ /**

+ * Validates the contents of the phpbb requirement field

+ *

+ * @return boolean True when passes validation

+ */

+ public function validate_require_phpbb()

+ {

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

+ {

+ return true;

+ }

+

+ return $this->_validate_version($this->metadata['require']['phpbb'], $this->config['version']);

+ }

+

+ /**

+ * Validates the contents of the php requirement field

+ *

+ * @return boolean True when passes validation

+ */

+ public function validate_require_php()

+ {

+ if (!isset($this->metadata['require']['php']))

+ {

+ return true;

+ }

+

+ return $this->_validate_version($this->metadata['require']['php'], phpversion());

+ }

+

+ /**

+ * Version validation helper

+ *

+ * @param string $string The string for comparing to a version

+ * @param string $current_version The version to compare to

+ * @return bool True/False if meets version requirements

+ */

+ private function _validate_version($string, $current_version)

+ {

+ // Allow them to specify their own comparison operator (ex: <3.1.2, >=3.1.0)

+ $comparison_matches = false;

+ preg_match('#[=<>]+#', $string, $comparison_matches);

+

+ if (!empty($comparison_matches))

+ {

+ return version_compare($current_version, str_replace(array($comparison_matches[0], ' '), '', $string), $comparison_matches[0]);

+ }

+

+ return version_compare($current_version, $string, '>=');

+ }

+

+ /**

+ * Outputs the metadata into the template

+ *

+ * @return null

+ */

+ public function output_template_data()

+ {

+ $this->template->assign_vars(array(

+ 'META_NAME' => htmlspecialchars($this->metadata['name']),

+ 'META_TYPE' => htmlspecialchars($this->metadata['type']),

+ 'META_DESCRIPTION' => (isset($this->metadata['description'])) ? htmlspecialchars($this->metadata['description']) : '',

+ 'META_HOMEPAGE' => (isset($this->metadata['homepage'])) ? $this->metadata['homepage'] : '',

+ 'META_VERSION' => (isset($this->metadata['version'])) ? htmlspecialchars($this->metadata['version']) : '',

+ 'META_TIME' => (isset($this->metadata['time'])) ? htmlspecialchars($this->metadata['time']) : '',

+ 'META_LICENCE' => htmlspecialchars($this->metadata['licence']),

+

+ 'META_REQUIRE_PHP' => (isset($this->metadata['require']['php'])) ? htmlspecialchars($this->metadata['require']['php']) : '',

+ 'META_REQUIRE_PHP_FAIL' => !$this->validate_require_php(),

+

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

+ 'META_REQUIRE_PHPBB_FAIL' => !$this->validate_require_phpbb(),

+

+ 'META_DISPLAY_NAME' => (isset($this->metadata['extra']['display-name'])) ? htmlspecialchars($this->metadata['extra']['display-name']) : '',

+ ));

+

+ foreach ($this->metadata['authors'] as $author)

+ {

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

+ 'AUTHOR_NAME' => htmlspecialchars($author['name']),

+ 'AUTHOR_EMAIL' => (isset($author['email'])) ? $author['email'] : '',

+ 'AUTHOR_HOMEPAGE' => (isset($author['homepage'])) ? $author['homepage'] : '',

+ 'AUTHOR_ROLE' => (isset($author['role'])) ? htmlspecialchars($author['role']) : '',

+ ));

+ }

+ }

+}

+* Provides a set of items found in extensions.

+*

+* This abstract class is essentially a wrapper around item-specific

+* finding logic. It handles storing the extension manager via constructor

+* for the finding logic to use to find the items, and provides an

+* iterator interface over the items found by the finding logic.

+*

+* Items could be anything, for example template paths or cron task names.

+* Derived classes completely define what the items are.

+ * Finds items using the extension manager.

+/**

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

+*

+* @param string $path Path to clean

+* @return string Cleaned path

+*/

+function phpbb_clean_path($path)

+{

+ $exploded = explode('/', $path);

+ $filtered = array();

+ foreach ($exploded as $part)

+ {

+ if ($part === '.' && !empty($filtered))

+ {

+ continue;

+ }

+

+ if ($part === '..' && !empty($filtered) && $filtered[sizeof($filtered) - 1] !== '..')

+ {

+ array_pop($filtered);

+ }

+ else

+ {

+ $filtered[] = $part;

+ }

+ }

+ $path = implode('/', $filtered);

+ return $path;

+}

+

+* @param string $mode (all, topics, topic, post)

+* @param int|bool $forum_id Used in all, topics, and topic mode

+* @param int|bool $topic_id Used in topic and post mode

+* @param int $post_time 0 means current time(), otherwise to set a specific mark time

+ $post_time = ($post_time === 0 || $post_time > time()) ? time() : (int) $post_time;

+

+ $tables = array(TOPICS_TRACK_TABLE, FORUMS_TRACK_TABLE);

+ foreach ($tables as $table)

+ {

+ $sql = 'DELETE FROM ' . $table . "

+ WHERE user_id = {$user->data['user_id']}

+ AND mark_time < $post_time";

+ $db->sql_query($sql);

+ }

+

+ $sql = 'UPDATE ' . USERS_TABLE . "

+ SET user_lastmark = $post_time

+ WHERE user_id = {$user->data['user_id']}

+ AND user_lastmark < $post_time";

+ $db->sql_query($sql);

+ $tracking_topics['l'] = base_convert($post_time - $config['board_startdate'], 10, 36);

+ $user->set_cookie('track', tracking_serialize($tracking_topics), $post_time + 31536000);

+ $sql = 'UPDATE ' . USERS_TABLE . "

+ SET user_lastmark = $post_time

+ WHERE user_id = {$user->data['user_id']}

+ AND user_lastmark < $post_time";

+ $db->sql_query($sql);

+ AND mark_time < $post_time

+ AND mark_time < $post_time

+ $sql = 'UPDATE ' . FORUMS_TRACK_TABLE . "

+ SET mark_time = $post_time

+ AND mark_time < $post_time

+ 'mark_time' => $post_time,

+ $tracking['f'][$f_id] = base_convert($post_time - $config['board_startdate'], 10, 36);

+ $user->set_cookie('track', tracking_serialize($tracking), $post_time + 31536000);

+ $sql = 'UPDATE ' . TOPICS_TRACK_TABLE . "

+ SET mark_time = $post_time

+ AND mark_time < $post_time

+ 'mark_time' => $post_time,

+

+ $sql = 'UPDATE ' . USERS_TABLE . "

+ SET user_lastmark = $post_time

+ WHERE user_id = {$user->data['user_id']}

+ AND mark_time < $post_time";

+ $db->sql_query($sql);

+ $user->set_cookie('track', tracking_serialize($tracking), $post_time + 31536000);

+ 'topic_posted' => 1,

+

+ // do this by assuming pagination is "centered" around the currently active page with

+ // the three previous and three next page links displayed. Anything more than that and

+ // we display the ellipsis, likewise anything less.

+ if ($on_page != 1)

+ 'PAGE_NUMBER' => '',

+ 'PAGE_URL' => $base_url . $url_delim . $start_name . '=' . (($on_page - 2) * $per_page),

+ 'S_IS_CURRENT' => false,

+ 'S_IS_PREV' => true,

+ 'S_IS_NEXT' => false,

+ 'S_IS_ELLIPSIS' => false,

+ }

+ // to display the first and last page in the list plus any ellipsis. We use this loop to jump

+ // around a little within the list depending on where we're starting (and ending).

+ 'PAGE_NUMBER' => $at_page,

+ 'S_IS_CURRENT' => (!$ignore_on_page && $at_page == $on_page),

+ 'S_IS_NEXT' => false,

+ 'S_IS_PREV' => false,

+ 'S_IS_ELLIPSIS' => ($at_page == 2 && $start_page > 2) || ($at_page == $total_pages - 1 && $end_page < $total_pages - 1),

+ // We may need to jump around in the list depending on whether we have or need to display

+ // of the list? Yes? Then we jump to the start of the list. Likewise are we at the end of

+ if ($on_page != $total_pages)

+ 'PAGE_NUMBER' => '',

+ 'PAGE_URL' => $base_url . $url_delim . $start_name . '=' . ($on_page * $per_page),

+ 'S_IS_CURRENT' => false,

+ 'S_IS_PREV' => false,

+ 'S_IS_NEXT' => true,

+ 'S_IS_ELLIPSIS' => false,

+

+ // If the block_var_name is a nested block, we will use the last (most

+ // inner) block as a prefix for the template variables. If the last block

+ // name is pagination, the prefix is empty. If the rest of the

+ // block_var_name is not empty, we will modify the last row of that block

+ // and add our pagination items.

+ $tpl_block_name = $tpl_prefix = '';

+ if (strrpos($block_var_name, '.') !== false)

+ {

+ $tpl_block_name = substr($block_var_name, 0, strrpos($block_var_name, '.'));

+ $tpl_prefix = strtoupper(substr($block_var_name, strrpos($block_var_name, '.') + 1));

+ }

+ else

+ {

+ $tpl_prefix = strtoupper($block_var_name);

+ }

+ $tpl_prefix = ($tpl_prefix == 'PAGINATION') ? '' : $tpl_prefix . '_';

+

+ $previous_page = ($on_page != 1) ? $base_url . $url_delim . $start_name . '=' . (($on_page - 2) * $per_page) : '';

+

+ $template_array = array(

+ $tpl_prefix . 'BASE_URL' => $base_url,

+ 'A_' . $tpl_prefix . 'BASE_URL' => addslashes($base_url),

+ $tpl_prefix . 'PER_PAGE' => $per_page,

+ $tpl_prefix . 'PREVIOUS_PAGE' => $previous_page,

+ $tpl_prefix . 'PREV_PAGE' => $previous_page,

+ $tpl_prefix . 'NEXT_PAGE' => ($on_page != $total_pages) ? $base_url . $url_delim . $start_name . '=' . ($on_page * $per_page) : '',

+ $tpl_prefix . 'TOTAL_PAGES' => $total_pages,

+ $tpl_prefix . 'CURRENT_PAGE' => $on_page,

+ );

+

+ if ($tpl_block_name)

+ {

+ $template->alter_block_array($tpl_block_name, $template_array, true, 'change');

+ }

+ else

+ {

+ $template->assign_vars($template_array);

+ }

+* Return current page

+ 'ON_PAGE' => $on_page,

+ 'A_BASE_URL' => addslashes($base_url),

+ global $phpbb_dispatcher;

+ $append_sid_overwrite = false;

+

+ /**

+ * This event can either supplement or override the append_sid() function

+ *

+ * To override this function, the event must set $append_sid_overwrite to

+ * the new URL value, which will be returned following the event

+ *

+ * @event core.append_sid

+ * @var string url The url the session id needs

+ * to be appended to (can have

+ * params)

+ * @var mixed params String or array of additional

+ * url parameters

+ * @var bool is_amp Is url using &amp; (true) or

+ * & (false)

+ * @var bool|string session_id Possibility to use a custom

+ * session id (string) instead of

+ * the global one (false)

+ * @var bool|string append_sid_overwrite Overwrite function (string

+ * URL) or not (false)

+ * @since 3.1-A1

+ */

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

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

+

+ if ($append_sid_overwrite)

+ {

+ return $append_sid_overwrite;

+ }

+

+ // The following hook remains for backwards compatibility, though use of

+ // the event above is preferred.

+ if (defined('DEBUG_TEST') || $diff && ($diff <= $timespan || $timespan === -1))

+ $password = $request->untrimmed_variable('password_' . $credential, '', true);

+ $password = $request->untrimmed_variable('password', '', true);

+

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

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

+ echo ' Powered by <a href="https://www.phpbb.com/">phpBB</a>&reg; Forum Software &copy; phpBB Group';

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

+ $page_header_override = false;

+

+ /**

+ * Execute code and/or overwrite page_header()

+ *

+ * @event core.page_header

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

+ * @var bool page_header_override Shall we return instead of running

+ * the rest of page_header()

+ * @since 3.1-A1

+ */

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

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

+

+ if ($page_header_override)

+ {

+ return;

+ }

+

+ 'L_SITE_HOME' => ($config['site_home_text'] !== '') ? $config['site_home_text'] : $user->lang['HOME'],

+ 'U_SITE_HOME' => $config['site_home_url'],

+ global $request, $phpbb_dispatcher;

+

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

+ $page_footer_override = false;

+

+ /**

+ * Execute code and/or overwrite page_footer()

+ *

+ * @event core.page_footer

+ * @var bool run_cron Shall we run cron tasks

+ * @var bool page_footer_override Shall we return instead of running

+ * the rest of page_footer()

+ * @since 3.1-A1

+ */

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

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

+

+ if ($page_footer_override)

+ {

+ return;

+ }

+ if ($request->variable('explain', false) && $auth->acl_get('a_') && defined('DEBUG') && method_exists($db, 'sql_report'))

+ if ($auth->acl_get('a_') && defined('DEBUG'))

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

+ global $phpbb_dispatcher;

+

+ /**

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

+ *

+ * @event core.garbage_collection

+ * @since 3.1-A1

+ */

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

+ global $phpbb_dispatcher;

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

+ $adm_page_header_override = false;

+

+ /**

+ * Execute code and/or overwrite adm_page_header()

+ *

+ * @event core.adm_page_header

+ * @var string page_title Page title

+ * @var bool adm_page_header_override Shall we return instead of

+ * running the rest of adm_page_header()

+ * @since 3.1-A1

+ */

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

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

+

+ if ($adm_page_header_override)

+ {

+ return;

+ }

+

+ global $request, $phpbb_dispatcher;

+

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

+ $adm_page_footer_override = false;

+

+ /**

+ * Execute code and/or overwrite adm_page_footer()

+ *

+ * @event core.adm_page_footer

+ * @var bool copyright_html Shall we display the copyright?

+ * @var bool adm_page_footer_override Shall we return instead of

+ * running the rest of adm_page_footer()

+ * @since 3.1-A1

+ */

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

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

+

+ if ($adm_page_footer_override)

+ {

+ return;

+ }

+ if ($request->variable('explain', false) && $auth->acl_get('a_') && defined('DEBUG') && method_exists($db, 'sql_report'))

+ if ($auth->acl_get('a_') && defined('DEBUG'))

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

+ global $user, $module, $phpbb_dispatcher;

+ /**

+ * Overwrite the html code we display for the config value

+ *

+ * @event core.build_config_template

+ * @var array tpl_type Config type array:

+ * 0 => data type

+ * 1 [optional] => string: size, int: minimum

+ * 2 [optional] => string: max. length, int: maximum

+ * @var string key Should be used for the id attribute in html

+ * @var array new Array with the config values we display

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

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

+ * @var string tpl The resulting html code we display

+ * @since 3.1-A1

+ */

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

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

+

+ global $phpbb_root_path, $user, $phpbb_dispatcher;

+

+

+ default:

+ /**

+ * Validate a config value

+ *

+ * @event core.validate_config_variable

+ * @var array cfg_array Array with config values

+ * @var string config_name Name of the config we validate

+ * @var array config_definition Array with the options for

+ * this config

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

+ * be strings only, language keys are

+ * not replaced afterwards

+ * @since 3.1-A1

+ */

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

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

+ break;

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

+ $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ * @var array

+ */

+ protected $filelist = array();

+

+ /**

+ * Checks if a file by that name as already been added and, if it has,

+ * returns a new, unique name.

+ *

+ * @param string $name The filename

+ * @return string A unique filename

+ */

+ protected function unique_filename($name)

+ {

+ if (isset($this->filelist[$name]))

+ {

+ $start = $name;

+ $ext = '';

+ $this->filelist[$name]++;

+

+ // Separate the extension off the end of the filename to preserve it

+ $pos = strrpos($name, '.');

+ if ($pos !== false)

+ {

+ $start = substr($name, 0, $pos);

+ $ext = substr($name, $pos);

+ }

+

+ return $start . '_' . $this->filelist[$name] . $ext;

+ }

+

+ $this->filelist[$name] = 0;

+ return $name;

+ }

+

+ /**

+ *

+ * @return array Array of strings of available compression methods (.tar, .tar.gz, .zip, etc.)

+ static public function methods()

+ $name = $this->unique_filename($name);

+ $name = $this->unique_filename($name);

+function generate_text_for_display($text, $uid, $bitfield, $flags, $censor_text = true)

+ global $phpbb_dispatcher;

+ /**

+ * Use this event to modify the text before it is parsed

+ *

+ * @event core.modify_text_for_display_before

+ * @var string text The text to parse

+ * @var string uid The BBCode UID

+ * @var string bitfield The BBCode Bitfield

+ * @var int flags The BBCode Flags

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

+ * @since 3.1-A1

+ */

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

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

+

+ if ($censor_text)

+ {

+ $text = censor_text($text);

+ }

+ /**

+ * Use this event to modify the text after it is parsed

+ *

+ * @event core.modify_text_for_display_after

+ * @var string text The text to parse

+ * @var string uid The BBCode UID

+ * @var string bitfield The BBCode Bitfield

+ * @var int flags The BBCode Flags

+ * @since 3.1-A1

+ */

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

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

+

+ global $phpbb_root_path, $phpEx, $phpbb_dispatcher;

+

+ /**

+ * Use this event to modify the text before it is prepared for storage

+ *

+ * @event core.modify_text_for_storage_before

+ * @var string text The text to parse

+ * @var string uid The BBCode UID

+ * @var string bitfield The BBCode Bitfield

+ * @var int flags The BBCode Flags

+ * @var bool allow_bbcode Whether or not to parse BBCode

+ * @var bool allow_urls Whether or not to parse URLs

+ * @var bool allow_smilies Whether or not to parse Smilies

+ * @since 3.1-A1

+ */

+ $vars = array('text', 'uid', 'bitfield', 'flags', 'allow_bbcode', 'allow_urls', 'allow_smilies');

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

+ /**

+ * Use this event to modify the text after it is prepared for storage

+ *

+ * @event core.modify_text_for_storage_after

+ * @var string text The text to parse

+ * @var string uid The BBCode UID

+ * @var string bitfield The BBCode Bitfield

+ * @var int flags The BBCode Flags

+ * @since 3.1-A1

+ */

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

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

+

+ global $phpbb_root_path, $phpEx, $phpbb_dispatcher;

+

+ /**

+ * Use this event to modify the text before it is decoded for editing

+ *

+ * @event core.modify_text_for_edit_before

+ * @var string text The text to parse

+ * @var string uid The BBCode UID

+ * @var int flags The BBCode Flags

+ * @since 3.1-A1

+ */

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

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

+ /**

+ * Use this event to modify the text after it is decoded for editing

+ *

+ * @event core.modify_text_for_edit_after

+ * @var string text The text to parse

+ * @var int flags The BBCode Flags

+ * @since 3.1-A1

+ */

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

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

+

+ global $phpbb_dispatcher;

+ $username_string = str_replace(array('{USERNAME_COLOUR}', '{USERNAME}'), array($username_colour, $username), (!$username_colour) ? $_profile_cache['tpl_noprofile'] : $_profile_cache['tpl_noprofile_colour']);

+ }

+ else

+ {

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

+ *

+ * @event core.modify_username_string

+ * @var string mode profile|username|colour|full|no_profile

+ * @var int user_id String or array of additional url

+ * parameters

+ * @var string username The user's username

+ * @var string username_colour The user's colour

+ * @var string guest_username Optional parameter to specify the

+ * guest username.

+ * @var string custom_profile_url Optional parameter to specify a

+ * profile url.

+ * @var string username_string The string that has been generated

+ * @var array _profile_cache Array of original return templates

+ * @since 3.1-A1

+ */

+ $vars = array('mode', 'user_id', 'username', 'username_colour', 'guest_username', 'custom_profile_url', 'username_string', '_profile_cache');

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

+ return $username_string;

+ global $request, $phpbb_dispatcher;

+ $redirect = build_url(array('mark', 'hash', 'mark_time'));

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

+ /**

+ * Event to modify the SQL query before the forum data is queried

+ *

+ * @event core.display_forums_modify_sql

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

+ * @since 3.1-A1

+ */

+ $vars = array('sql_ary');

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

+

+ /**

+ * Event to modify the data set of a forum

+ *

+ * This event is triggered once per forum

+ *

+ * @event core.display_forums_modify_row

+ * @var int branch_root_id Last top-level forum

+ * @var array row The data of the forum

+ * @since 3.1-A1

+ */

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

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

+

+

+ /**

+ * Event to modify the forum rows data set

+ *

+ * This event is triggered once per forum

+ *

+ * @event core.display_forums_modify_forum_rows

+ * @var array forum_rows Data array of all forums we display

+ * @var array subforums Data array of all subforums we display

+ * @var int branch_root_id Current top-level forum

+ * @var int parent_id Current parent forum

+ * @var array row The data of the forum

+ * @since 3.1-A1

+ */

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

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

+ $redirect = build_url(array('mark', 'hash', 'mark_time'));

+ markread('topics', $forum_ids, false, request_var('mark_time', 0));

+ $moderators_list = implode($user->lang['COMMA_SEPARATOR'], $forum_moderators[$forum_id]);

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

+ $forum_row = array(

+ 'U_LAST_POST' => $last_post_url,

+ /**

+ * Modify the template data block of the forum

+ *

+ * This event is triggered once per forum

+ *

+ * @event core.display_forums_modify_template_vars

+ * @var array forum_row Template data of the forum

+ * @var array row The data of the forum

+ * @since 3.1-A1

+ */

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

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

+

+ $template->assign_block_vars('forumrow', $forum_row);

+

+ 'U_MARK_FORUMS' => ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'hash=' . generate_link_hash('global') . '&amp;f=' . $root_data['forum_id'] . '&amp;mark=forums&amp;mark_time=' . time()) : '',

+ global $db, $template, $user, $phpbb_dispatcher;

+ $custom_tags = array(

+ );

+

+ /**

+ * Modify the template data block of a bbcode

+ *

+ * This event is triggered once per bbcode

+ *

+ * @event core.display_custom_bbcodes_modify_row

+ * @var array custom_tags Template data of the bbcode

+ * @var array row The data of the bbcode

+ * @since 3.1-A1

+ */

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

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

+

+ $template->assign_block_vars('custom_tags', $custom_tags);

+

+ /**

+ * Display custom bbcodes

+ *

+ * @event core.display_custom_bbcodes

+ * @since 3.1-A1

+ */

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

+ global $phpbb_dispatcher;

+

+ $overwrite_avatar = '';

+

+ /**

+ * Overwrite users avatar

+ *

+ * @event core.display_custom_bbcodes_modify_row

+ * @var string avatar Users assigned avatar name

+ * @var int avatar_type Type of avatar

+ * @var string avatar_width Width of users avatar

+ * @var string avatar_height Height of users avatar

+ * @var string alt Language string for alt tag within image

+ * Can be a language key or text

+ * @var bool ignore_config Ignores config and force displaying avatar

+ * @var string overwrite_avatar If set, this string will be the avatar

+ * @since 3.1-A1

+ */

+ $vars = array('avatar', 'avatar_type', 'avatar_width', 'avatar_height', 'alt', 'ignore_config', 'overwrite_avatar');

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

+

+ if ($overwrite_avatar)

+ {

+ return $overwrite_avatar;

+ }

+

+/**

+* Generate a list of archive types available for compressing attachments

+*

+* @param string $param_key Either topic_id or post_id

+* @param string $param_val The value of the topic or post id

+* @param string $phpbb_root_path The root path of the phpBB installation

+* @param string $phpEx The PHP extension

+*

+* @return array Array containing the link and the type of compression

+*/

+function phpbb_gen_download_links($param_key, $param_val, $phpbb_root_path, $phpEx)

+{

+ if (!class_exists('compress'))

+ {

+ require $phpbb_root_path . 'includes/functions_compress.' . $phpEx;

+ }

+

+ $methods = compress::methods();

+ $links = array();

+

+ foreach ($methods as $method)

+ {

+ $exploded = explode('.', $method);

+ $type = array_pop($exploded);

+ $params = array('archive' => $method);

+ $params[$param_key] = $param_val;

+

+ $links[] = array(

+ 'LINK' => append_sid("{$phpbb_root_path}download/file.$phpEx", $params),

+ 'TYPE' => $type,

+ );

+ }

+

+ return $links;

+}

+

+/**

+* Increments the download count of all provided attachments

+*

+* @param dbal $db The database object

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

+*

+* @return null

+*/

+function phpbb_increment_downloads($db, $ids)

+{

+ if (!is_array($ids))

+ {

+ $ids = array($ids);

+ }

+

+ $sql = 'UPDATE ' . ATTACHMENTS_TABLE . '

+ SET download_count = download_count + 1

+ WHERE ' . $db->sql_in_set('attach_id', $ids);

+ $db->sql_query($sql);

+}

+

+/**

+* Handles authentication when downloading attachments from a post or topic

+*

+* @param dbal $db The database object

+* @param phpbb_auth $auth The authentication object

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

+*

+* @return null

+*/

+function phpbb_download_handle_forum_auth($db, $auth, $topic_id)

+{

+ $sql = 'SELECT t.forum_id, f.forum_password, f.parent_id

+ FROM ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE . " f

+ WHERE t.topic_id = " . (int) $topic_id . "

+ AND t.forum_id = f.forum_id";

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

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

+ $db->sql_freeresult($result);

+

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

+ {

+ if ($row && $row['forum_password'])

+ {

+ // Do something else ... ?

+ login_forum_box($row);

+ }

+ }

+ else

+ {

+ send_status_line(403, 'Forbidden');

+ trigger_error('SORRY_AUTH_VIEW_ATTACH');

+ }

+}

+

+/**

+* Handles authentication when downloading attachments from PMs

+*

+* @param dbal $db The database object

+* @param phpbb_auth $auth The authentication object

+* @param int $user_id The user id

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

+*

+* @return null

+*/

+function phpbb_download_handle_pm_auth($db, $auth, $user_id, $msg_id)

+{

+ if (!$auth->acl_get('u_pm_download'))

+ {

+ send_status_line(403, 'Forbidden');

+ trigger_error('SORRY_AUTH_VIEW_ATTACH');

+ }

+

+ $allowed = phpbb_download_check_pm_auth($db, $user_id, $msg_id);

+

+ if (!$allowed)

+ {

+ send_status_line(403, 'Forbidden');

+ trigger_error('ERROR_NO_ATTACHMENT');

+ }

+}

+

+/**

+* Checks whether a user can download from a particular PM

+*

+* @param dbal $db The database object

+* @param int $user_id The user id

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

+*

+* @return bool Whether the user is allowed to download from that PM or not

+*/

+function phpbb_download_check_pm_auth($db, $user_id, $msg_id)

+{

+ // Check if the attachment is within the users scope...

+ $sql = 'SELECT msg_id

+ FROM ' . PRIVMSGS_TO_TABLE . '

+ WHERE msg_id = ' . (int) $msg_id . '

+ AND (

+ user_id = ' . (int) $user_id . '

+ OR author_id = ' . (int) $user_id . '

+ )';

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

+ $allowed = (bool) $db->sql_fetchfield('msg_id');

+ $db->sql_freeresult($result);

+

+ return $allowed;

+}

+

+/**

+* Cleans a filename of any characters that could potentially cause a problem on

+* a user's filesystem.

+*

+* @param string $filename The filename to clean

+*

+* @return string The cleaned filename

+*/

+function phpbb_download_clean_filename($filename)

+{

+ $bad_chars = array("'", "\\", ' ', '/', ':', '*', '?', '"', '<', '>', '|');

+

+ // rawurlencode to convert any potentially 'bad' characters that we missed

+ $filename = rawurlencode(str_replace($bad_chars, '_', $filename));

+

+ // Turn the %xx entities created by rawurlencode to _

+ $filename = preg_replace("/%(\w{2})/", '_', $filename);

+

+ return $filename;

+}

+ if ($return_unavailable)

+ $available_dbms[$db_name]['AVAILABLE'] = false;

+ }

+ else

+ {

+ unset($available_dbms[$db_name]);

+ continue;

+* @param bool $debug_test If the DEBUG_TEST constant should be added

+* NOTE: Only for use within the testing framework

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

+ 'acm_type' => 'phpbb_cache_driver_file',

+ }

+

+ if ($debug_test)

+ {

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

+ $this->use_ssl = ($use_ssl && self::can_use_ssl()) ? true : false;

+ static public function can_use_ssl()

+ static public function can_use_tls()

+ if (!$this->session['ssl'] && self::can_use_tls() && self::can_use_ssl() && isset($xml['stream:features'][0]['#']['starttls']))

+ $tpl = new phpbb_template($phpbb_root_path, $phpEx, $config, $user, $style_resource_locator, new phpbb_template_context());

+ global $db, $user, $config, $template, $phpbb_dispatcher;

+ /**

+ * This event is called after the smilies are populated

+ *

+ * @event core.generate_smilies_after

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

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

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

+ * @since 3.1-A1

+ */

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

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

+

+ $root_path = (defined('PHPBB_USE_BOARD_URL_PATH') && PHPBB_USE_BOARD_URL_PATH) ? generate_board_url() . '/' : $phpbb_root_path;

+

+ 'ICON_IMG' => $root_path . $config['icons_path'] . '/' . $data['img'],

+function user_notification($mode, $subject, $topic_title, $forum_name, $forum_id, $topic_id, $post_id, $author_name = '')

+ 'AUTHOR_NAME' => htmlspecialchars_decode($author_name),

+ $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

+ $username = ($username) ? $username : $user->data['username'];

+ user_notification($mode, $subject, $data['topic_title'], $data['forum_name'], $data['forum_id'], $data['topic_id'], $data['post_id'], $username);

+

+

+

+

+

+

+

+

+

+

+ return phpbb_delete_users_pms(array($user_id));

+}

+

+/**

+* Delete all PM(s) for given users and delete the ones without references

+*

+* @param array $user_ids IDs of the users whose private messages we want to delete

+*

+* @return boolean False if there were no pms found, true otherwise.

+*/

+function phpbb_delete_users_pms($user_ids)

+{

+ global $db, $user, $phpbb_root_path, $phpEx;

+

+ $user_id_sql = $db->sql_in_set('user_id', $user_ids);

+ $author_id_sql = $db->sql_in_set('author_id', $user_ids);

+

+ WHERE ' . $user_id_sql;

+ // Part 2: get PMs the users sent, but are yet to be received.

+ // We cannot simply delete them. First we have to check

+ WHERE ' . $author_id_sql . '

+ WHERE ' . $author_id_sql . '

+ WHERE ' . $author_id_sql . '

+ WHERE ' . $user_id_sql;

+ WHERE ' . $user_id_sql;

+ WHERE ' . $author_id_sql;

+ WHERE ' . $author_id_sql;

+ 'FOLDER' => implode($user->lang['COMMA_SEPARATOR'], $row['folder']),