+ 'max_attachments' => array('lang' => 'MAX_ATTACHMENTS', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => false),

+ 'max_attachments_pm' => array('lang' => 'MAX_ATTACHMENTS_PM', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => false),

+ 'img_max_thumb_width' => array('lang' => 'MAX_THUMB_WIDTH', 'validate' => 'int:0:999999999999999', 'type' => 'number:0:999999999999999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'img_min_thumb_filesize' => array('lang' => 'MIN_THUMB_FILESIZE', 'validate' => 'int:0:999999999999999', 'type' => 'number:0:999999999999999', 'explain' => true, 'append' => ' ' . $user->lang['BYTES']),

+ 'img_max' => array('lang' => 'MAX_IMAGE_SIZE', 'validate' => 'int:0:9999', 'type' => 'dimension:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'img_link' => array('lang' => 'IMAGE_LINK_SIZE', 'validate' => 'int:0:9999', 'type' => 'dimension:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ FROM ' . ATTACHMENTS_TABLE . ' a

+ LEFT JOIN ' . USERS_TABLE . ' u ON (u.user_id = a.poster_id)

+ // size="8" and maxlength="15" attributes as a fallback for browsers that do not support type="number" yet.

+ return '<input type="number" id="' . $key . '" size="8" maxlength="15" min="0" name="config[' . $key . ']" value="' . $value . '" /> <select name="' . $key . '">' . size_select_options($size_var) . '</select>';

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

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

+ 'warnings_expire_days' => array('lang' => 'WARNINGS_EXPIRE', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

+ 'avatar_min' => array('lang' => 'MIN_AVATAR_SIZE', 'validate' => 'int:0', 'type' => 'dimension:0', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'avatar_max' => array('lang' => 'MAX_AVATAR_SIZE', 'validate' => 'int:0', 'type' => 'dimension:0', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'pm_max_boxes' => array('lang' => 'BOXES_MAX', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'pm_max_msgs' => array('lang' => 'BOXES_LIMIT', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'pm_edit_time' => array('lang' => 'PM_EDIT_TIME', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

+ 'pm_max_recipients' => array('lang' => 'PM_MAX_RECIPIENTS', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true),

+ 'edit_time' => array('lang' => 'EDIT_TIME', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

+ 'delete_time' => array('lang' => 'DELETE_TIME', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

+ 'flood_interval' => array('lang' => 'FLOOD_INTERVAL', 'validate' => 'int:0:9999999999', 'type' => 'number:0:9999999999', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

+ 'topics_per_page' => array('lang' => 'TOPICS_PER_PAGE', 'validate' => 'int:1:9999', 'type' => 'number:1:9999', 'explain' => false),

+ 'posts_per_page' => array('lang' => 'POSTS_PER_PAGE', 'validate' => 'int:1:9999', 'type' => 'number:1:9999', 'explain' => false),

+ 'smilies_per_page' => array('lang' => 'SMILIES_PER_PAGE', 'validate' => 'int:1:9999', 'type' => 'number:1:9999', 'explain' => false),

+ 'hot_threshold' => array('lang' => 'HOT_THRESHOLD', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_poll_options' => array('lang' => 'MAX_POLL_OPTIONS', 'validate' => 'int:2:127', 'type' => 'number:2:127', 'explain' => false),

+ 'max_post_chars' => array('lang' => 'CHAR_LIMIT', 'validate' => 'int:0:999999', 'type' => 'number:0:999999', 'explain' => true),

+ 'min_post_chars' => array('lang' => 'MIN_CHAR_LIMIT', 'validate' => 'int:1:999999', 'type' => 'number:1:999999', 'explain' => true),

+ 'max_post_smilies' => array('lang' => 'SMILIES_LIMIT', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_post_urls' => array('lang' => 'MAX_POST_URLS', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_post_font_size' => array('lang' => 'MAX_POST_FONT_SIZE', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' %'),

+ 'max_quote_depth' => array('lang' => 'QUOTE_DEPTH_LIMIT', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_post_img_width' => array('lang' => 'MAX_POST_IMG_WIDTH', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'max_post_img_height' => array('lang' => 'MAX_POST_IMG_HEIGHT', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'max_sig_chars' => array('lang' => 'MAX_SIG_LENGTH', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_sig_urls' => array('lang' => 'MAX_SIG_URLS', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_sig_font_size' => array('lang' => 'MAX_SIG_FONT_SIZE', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' %'),

+ 'max_sig_smilies' => array('lang' => 'MAX_SIG_SMILIES', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'max_sig_img_width' => array('lang' => 'MAX_SIG_IMG_WIDTH', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'max_sig_img_height' => array('lang' => 'MAX_SIG_IMG_HEIGHT', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

+ 'new_member_post_limit' => array('lang' => 'NEW_MEMBER_POST_LIMIT', 'validate' => 'int:0:255', 'type' => 'number:0:255', 'explain' => true, 'append' => ' ' . $user->lang['POSTS']),

+ 'chg_passforce' => array('lang' => 'FORCE_PASS_CHANGE', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

+ 'max_login_attempts' => array('lang' => 'MAX_LOGIN_ATTEMPTS', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => true),

+ 'max_reg_attempts' => array('lang' => 'REG_LIMIT', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'feed_limit_post' => array('lang' => 'ACP_FEED_LIMIT', 'validate' => 'int:5:9999', 'type' => 'number:5:9999', 'explain' => true),

+ 'feed_limit_topic' => array('lang' => 'ACP_FEED_LIMIT', 'validate' => 'int:5:9999', 'type' => 'number:5:9999', 'explain' => true),

+ 'limit_load' => array('lang' => 'LIMIT_LOAD', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'session_length' => array('lang' => 'SESSION_LENGTH', 'validate' => 'int:60:9999999999', 'type' => 'number:60:9999999999', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

+ 'active_sessions' => array('lang' => 'LIMIT_SESSIONS', 'validate' => 'int:0:9999', 'type' => 'number:0:9999', 'explain' => true),

+ 'load_online_time' => array('lang' => 'ONLINE_LENGTH', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

+ 'server_port' => array('lang' => 'SERVER_PORT', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true),

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

+ 'max_autologin_time' => array('lang' => 'AUTOLOGIN_LENGTH', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

+ 'chg_passforce' => array('lang' => 'FORCE_PASS_CHANGE', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

+ 'max_login_attempts' => array('lang' => 'MAX_LOGIN_ATTEMPTS', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => true),

+ 'ip_login_limit_max' => array('lang' => 'IP_LOGIN_LIMIT_MAX', 'validate' => 'int:0:999', 'type' => 'number:0:999', 'explain' => true),

+ 'ip_login_limit_time' => array('lang' => 'IP_LOGIN_LIMIT_TIME', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

+ 'form_token_lifetime' => array('lang' => 'FORM_TIME_MAX', 'validate' => 'int:-1:99999', 'type' => 'number:-1:99999', 'explain' => true, 'append' => ' ' . $user->lang['SECONDS']),

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

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

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

+ 'smtp_port' => array('lang' => 'SMTP_PORT', 'validate' => 'int:0:99999', 'type' => 'number:0:99999', 'explain' => true),

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

+ $updated_auth_settings = false;

+ $old_auth_config = array();

+ foreach ($auth_providers as $provider)

+ if ($fields = $provider->acp($this->new_config))

+ // Check if we need to create config fields for this plugin and save config when submit was pressed

+ foreach ($fields['config'] as $field)

+ if (!isset($config[$field]))

+ {

+ set_config($field, '');

+ }

+ if (!isset($cfg_array[$field]) || strpos($field, 'legend') !== false)

+ {

+ continue;

+ }

+ $old_auth_config[$field] = $this->new_config[$field];

+ $config_value = $cfg_array[$field];

+ $this->new_config[$field] = $config_value;

+ if ($submit)

+ $updated_auth_settings = true;

+ set_config($field, $config_value);

+ unset($fields);

+ if (array_key_exists('auth.provider.' . $method, $auth_providers))

+ $provider = $auth_providers['auth.provider.' . $method];

+ if ($error = $provider->init())

+ foreach ($old_auth_config as $config_name => $config_value)

+ set_config($config_name, $config_value);

+ trigger_error($error . adm_back_link($this->u_action), E_USER_WARNING);

+ foreach ($auth_providers as $provider)

+ $fields = $provider->acp($this->new_config);

+ if ($fields['tpl'])

+ {

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

+ 'TPL' => $fields['tpl'],

+ ));

+ unset($fields);

+ global $phpbb_root_path, $phpEx, $phpbb_container;

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

+ foreach($auth_providers as $key => $value)

+ $auth_plugins[] = str_replace('auth.provider.', '', $key);

+ }

+ return '<input id="' . $key . '" type="number" size="3" maxlength="3" min="1" max="999" name="config[min_name_chars]" value="' . $value . '" /> ' . $user->lang['MIN_CHARS'] . '&nbsp;&nbsp;<input type="number" size="3" maxlength="3" min="8" max="180" name="config[max_name_chars]" value="' . $this->new_config['max_name_chars'] . '" /> ' . $user->lang['MAX_CHARS'];

+ return '<input id="' . $key . '" type="number" size="3" maxlength="3" min="1" max="999" name="config[min_pass_chars]" value="' . $value . '" /> ' . $user->lang['MIN_CHARS'] . '&nbsp;&nbsp;<input type="number" size="3" maxlength="3" min="8" max="255" name="config[max_pass_chars]" value="' . $this->new_config['max_pass_chars'] . '" /> ' . $user->lang['MAX_CHARS'];

+

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

+ // What is a safe limit of execution time? Half the max execution time should be safe.

+ $safe_time_limit = (ini_get('max_execution_time') / 2);

+ $start_time = time();

+

+ $md_manager = new phpbb_extension_metadata_manager($ext_name, $config, $phpbb_extension_manager, $template, $phpbb_root_path);

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

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

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

+ // Are we approaching the time limit? If so we want to pause the update and continue after refreshing

+ if ((time() - $start_time) >= $safe_time_limit)

+ {

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

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

+ }

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

+ // Are we approaching the time limit? If so we want to pause the update and continue after refreshing

+ if ((time() - $start_time) >= $safe_time_limit)

+ {

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

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

+ }

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

+ // Are we approaching the time limit? If so we want to pause the update and continue after refreshing

+ if ((time() - $start_time) >= $safe_time_limit)

+ {

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

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

+ }

+ if (!check_form_key($form_key))

+ {

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

+ }

+

+ break;

+ if (confirm_box(true))

+ {

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

+ $start = 0;

+

+ do

+ {

+ $sql = 'SELECT user_id

+ FROM ' . USER_GROUP_TABLE . "

+ WHERE group_id = $group_id

+ ORDER BY user_id";

+ $result = $db->sql_query_limit($sql, 200, $start);

+

+ $mark_ary = array();

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

+ do

+ $mark_ary[] = $row['user_id'];

+ }

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

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

+ $start = (sizeof($mark_ary) < 200) ? 0 : $start + 200;

+ else

+ {

+ $start = 0;

+ }

+ $db->sql_freeresult($result);

+ while ($start);

+

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

+ }

+ else

+ {

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(

+ 'mark' => $mark_ary,

+ 'g' => $group_id,

+ 'i' => $id,

+ 'mode' => $mode,

+ 'action' => $action))

+ );

+ }

+

+ if (!check_form_key($form_key))

+ {

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

+ }

+

+

+ // Merge any avatar errors into the primary error array

+ $error = array_merge($error, $phpbb_avatar_manager->localize_errors($user, $avatar_error));

+ /*

+ * Validate the length of "Maximum number of allowed recipients per

+ * private message" setting. We use 16777215 as a maximum because it matches

+ * MySQL unsigned mediumint maximum value which is the lowest amongst DBMSes

+ * supported by phpBB3. Also validate the submitted colour value.

+ */

+ $validation_checks = array(

+ 'max_recipients' => array('num', false, 0, 16777215),

+ 'colour' => array('hex_colour', true),

+ );

+

+ if ($validation_error = validate_data($submit_ary, $validation_checks))

+ $error = array_merge($error, array_map(array(&$user, 'lang'), $validation_error));

+ if (isset($phpbb_avatar_manager) && !$update)

+ {

+ // Merge any avatar errors into the primary error array

+ $error = array_merge($error, $phpbb_avatar_manager->localize_errors($user, $avatar_error));

+ }

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

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

+ $messenger->set_addresses($row);

+ $messenger->set_addresses($row);

+ global $phpbb_extension_manager, $phpbb_root_path, $phpEx;

+ $finder = $phpbb_extension_manager->get_finder();

+ $modules = $finder

+ ->extension_suffix('_module')

+ ->extension_directory("/$module_class")

+ ->core_path("includes/$module_class/info/")

+ ->core_prefix($module_class . '_')

+ ->get_classes(true, $use_all_available);

+ foreach ($modules as $cur_module)

+ {

+ // Skip entries we do not need if we know the module we are

+ // looking for

+ if ($module && strpos($cur_module, $module) === false)

+ continue;

+ $info_class = preg_replace('/_module$/', '_info', $cur_module);

+ // If the class does not exist it might be following the old

+ // format. phpbb_acp_info_acp_foo needs to be turned into

+ // acp_foo_info and the respective file has to be included

+ // manually because it does not support auto loading

+ $info_class_file = str_replace("phpbb_{$module_class}_info_", '', $cur_module);

+ $info_class = $info_class_file . '_info';

+ if (!class_exists($info_class) && file_exists($directory . $info_class_file . '.' . $phpEx))

+ include($directory . $info_class_file . '.' . $phpEx);

+ $main_class = (isset($module_info['filename'])) ? $module_info['filename'] : $cur_module;

+ ksort($fileinfo);

+

+ protected $auth_admin;

+ $this->auth_admin = new auth_admin();

+ $this->auth_admin->acl_set_role($role_id, $auth_settings);

+ $hold_ary = $this->auth_admin->get_role_mask($role_id);

+ $this->auth_admin->display_role_mask($hold_ary);

+ $hold_ary = $this->auth_admin->get_role_mask($display_item);

+ $this->auth_admin->display_role_mask($hold_ary);

+ $this->auth_admin->build_permission_array($auth_options, $content_array, $categories, $key_sort_array);

+ $hold_ary = $this->auth_admin->get_role_mask($role_id);

+ $this->auth_admin->acl_set('user', $forum_id, $forum_ary['users'], $auth_settings, 0, false);

+ $this->auth_admin->acl_set('group', $forum_id, $forum_ary['groups'], $auth_settings, 0, false);

+ $this->auth_admin->acl_clear_prefetch();

+ $s_group_list = '<option value="0"></option>';

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

+ $sql = 'SELECT u.user_id, u.username

+ FROM ' . USER_GROUP_TABLE . ' ug, ' . USERS_TABLE . ' u

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

+ AND ug.user_pending = 0

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

+ AND u.user_id = ug.user_id';

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

+ $usernames[$row['user_id']] = $row['username'];

+ $sql = 'SELECT u.user_id, u.username, COUNT(p.post_id) AS queue_posts

+ FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

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

+ AND u.user_id = p.poster_id

+ GROUP BY p.poster_id

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

+ $usernames[$row['user_id']] = $row['username'];

+

+ if ($action && in_array($action, $post_actions) && !check_link_hash($request->variable('hash', ''), $action))

+ {

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

+ }

+

+ if ($this->request->is_set_post($key))

+

+ // Activate/Deactive

+ $action_name = ($style['style_active'] ? 'de' : '') . 'activate';

+

+ 'U_ACTION' => $this->u_action . '&amp;action=' . $action_name . '&amp;hash=' . generate_link_hash($action_name) . '&amp;id=' . $style['style_id'],

+ 'U_ACTION' => $this->u_action . '&amp;action=export&amp;hash=' . generate_link_hash('export') . '&amp;id=' . $style['style_id'],

+ 'U_ACTION' => $this->u_action . '&amp;action=uninstall&amp;hash=' . generate_link_hash('uninstall') . '&amp;id=' . $style['style_id'],

+ 'U_ACTION' => $this->u_action . '&amp;action=install&amp;hash=' . generate_link_hash('install') . '&amp;dir=' . urlencode($style['style_path']),

+ if (empty($info))

+ $messenger->set_addresses($user_row);

+ $messenger->set_addresses($user_row);

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

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

+ if ($provider)

+ $login = $provider->login($username, $password);

+<?php

+/**

+*

+* @package auth

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+ * Apache authentication provider for phpBB3

+ *

+ * @package auth

+ */

+class phpbb_auth_provider_apache implements phpbb_auth_provider_interface

+{

+ /**

+ * Apache Authentication Constructor

+ *

+ * @param phpbb_db_driver $db

+ * @param phpbb_config $config

+ * @param phpbb_request $request

+ * @param phpbb_user $user

+ * @param string $phpbb_root_path

+ * @param string $php_ext

+ */

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

+ {

+ $this->db = $db;

+ $this->config = $config;

+ $this->request = $request;

+ $this->user = $user;

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function init()

+ {

+ if (!$this->request->is_set('PHP_AUTH_USER', phpbb_request_interface::SERVER) || $this->user->data['username'] !== htmlspecialchars_decode($this->request->server('PHP_AUTH_USER')))

+ {

+ return $this->user->lang['APACHE_SETUP_BEFORE_USE'];

+ }

+ return false;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function login($username, $password)

+ {

+ // do not allow empty password

+ if (!$password)

+ {

+ return array(

+ 'status' => LOGIN_ERROR_PASSWORD,

+ 'error_msg' => 'NO_PASSWORD_SUPPLIED',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ if (!$username)

+ {

+ return array(

+ 'status' => LOGIN_ERROR_USERNAME,

+ 'error_msg' => 'LOGIN_ERROR_USERNAME',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ if (!$this->request->is_set('PHP_AUTH_USER', phpbb_request_interface::SERVER))

+ {

+ return array(

+ 'status' => LOGIN_ERROR_EXTERNAL_AUTH,

+ 'error_msg' => 'LOGIN_ERROR_EXTERNAL_AUTH_APACHE',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ $php_auth_user = htmlspecialchars_decode($this->request->server('PHP_AUTH_USER'));

+ $php_auth_pw = htmlspecialchars_decode($this->request->server('PHP_AUTH_PW'));

+

+ if (!empty($php_auth_user) && !empty($php_auth_pw))

+ {

+ if ($php_auth_user !== $username)

+ {

+ return array(

+ 'status' => LOGIN_ERROR_USERNAME,

+ 'error_msg' => 'LOGIN_ERROR_USERNAME',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ $sql = 'SELECT user_id, username, user_password, user_passchg, user_email, user_type

+ FROM ' . USERS_TABLE . "

+ WHERE username = '" . $this->db->sql_escape($php_auth_user) . "'";

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

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

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

+

+ if ($row)

+ {

+ // User inactive...

+ if ($row['user_type'] == USER_INACTIVE || $row['user_type'] == USER_IGNORE)

+ {

+ return array(

+ 'status' => LOGIN_ERROR_ACTIVE,

+ 'error_msg' => 'ACTIVE_ERROR',

+ 'user_row' => $row,

+ );

+ }

+

+ // Successful login...

+ return array(

+ 'status' => LOGIN_SUCCESS,

+ 'error_msg' => false,

+ 'user_row' => $row,

+ );

+ }

+

+ // this is the user's first login so create an empty profile

+ return array(

+ 'status' => LOGIN_SUCCESS_CREATE_PROFILE,

+ 'error_msg' => false,

+ 'user_row' => user_row_apache($php_auth_user, $php_auth_pw),

+ );

+ }

+

+ // Not logged into apache

+ return array(

+ 'status' => LOGIN_ERROR_EXTERNAL_AUTH,

+ 'error_msg' => 'LOGIN_ERROR_EXTERNAL_AUTH_APACHE',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function autologin()

+ {

+ if (!$this->request->is_set('PHP_AUTH_USER', phpbb_request_interface::SERVER))

+ {

+ return array();

+ }

+

+ $php_auth_user = htmlspecialchars_decode($this->request->server('PHP_AUTH_USER'));

+ $php_auth_pw = htmlspecialchars_decode($this->request->server('PHP_AUTH_PW'));

+

+ if (!empty($php_auth_user) && !empty($php_auth_pw))

+ {

+ set_var($php_auth_user, $php_auth_user, 'string', true);

+ set_var($php_auth_pw, $php_auth_pw, 'string', true);

+

+ $sql = 'SELECT *

+ FROM ' . USERS_TABLE . "

+ WHERE username = '" . $this->db->sql_escape($php_auth_user) . "'";

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

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

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

+

+ if ($row)

+ {

+ return ($row['user_type'] == USER_INACTIVE || $row['user_type'] == USER_IGNORE) ? array() : $row;

+ }

+

+ if (!function_exists('user_add'))

+ {

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

+ }

+

+ // create the user if he does not exist yet

+ user_add(user_row_apache($php_auth_user, $php_auth_pw));

+

+ $sql = 'SELECT *

+ FROM ' . USERS_TABLE . "

+ WHERE username_clean = '" . $this->db->sql_escape(utf8_clean_string($php_auth_user)) . "'";

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

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

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

+

+ if ($row)

+ {

+ return $row;

+ }

+ }

+

+ return array();

+ }

+

+ /**

+ * This function generates an array which can be passed to the user_add

+ * function in order to create a user

+ *

+ * @param string $username The username of the new user.

+ * @param string $password The password of the new user.

+ * @return array Contains data that can be passed directly to

+ * the user_add function.

+ */

+ private function user_row($username, $password)

+ {

+ // first retrieve default group id

+ $sql = 'SELECT group_id

+ FROM ' . GROUPS_TABLE . "

+ WHERE group_name = '" . $this->db->sql_escape('REGISTERED') . "'

+ AND group_type = " . GROUP_SPECIAL;

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

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

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

+

+ if (!$row)

+ {

+ trigger_error('NO_GROUP');

+ }

+

+ // generate user account data

+ return array(

+ 'username' => $username,

+ 'user_password' => phpbb_hash($password),

+ 'user_email' => '',

+ 'group_id' => (int) $row['group_id'],

+ 'user_type' => USER_NORMAL,

+ 'user_ip' => $this->user->ip,

+ 'user_new' => ($this->config['new_member_post_limit']) ? 1 : 0,

+ );

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function validate_session($user)

+ {

+ // Check if PHP_AUTH_USER is set and handle this case

+ if ($this->request->is_set('PHP_AUTH_USER', phpbb_request_interface::SERVER))

+ {

+ $php_auth_user = $this->request->server('PHP_AUTH_USER');

+

+ return ($php_auth_user === $user['username']) ? true : false;

+ }

+

+ // PHP_AUTH_USER is not set. A valid session is now determined by the user type (anonymous/bot or not)

+ if ($user['user_type'] == USER_IGNORE)

+ {

+ return true;

+ }

+

+ return false;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function acp($new)

+ {

+ return;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function logout($data, $new_session)

+ {

+ return;

+ }

+}

+<?php

+/**

+*

+* @package auth

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+ * Database authentication provider for phpBB3

+ *

+ * This is for authentication via the integrated user table

+ *

+ * @package auth

+ */

+class phpbb_auth_provider_db implements phpbb_auth_provider_interface

+{

+

+ /**

+ * Database Authentication Constructor

+ *

+ * @param phpbb_db_driver $db

+ * @param phpbb_config $config

+ * @param phpbb_request $request

+ * @param phpbb_user $user

+ * @param string $phpbb_root_path

+ * @param string $php_ext

+ */

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

+ {

+ $this->db = $db;

+ $this->config = $config;

+ $this->request = $request;

+ $this->user = $user;

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function init()

+ {

+ return;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function login($username, $password)

+ {

+ // Auth plugins get the password untrimmed.

+ // For compatibility we trim() here.

+ $password = trim($password);

+

+ // do not allow empty password

+ if (!$password)

+ {

+ return array(

+ 'status' => LOGIN_ERROR_PASSWORD,

+ 'error_msg' => 'NO_PASSWORD_SUPPLIED',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ if (!$username)

+ {

+ return array(

+ 'status' => LOGIN_ERROR_USERNAME,

+ 'error_msg' => 'LOGIN_ERROR_USERNAME',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ $username_clean = utf8_clean_string($username);

+

+ $sql = 'SELECT user_id, username, user_password, user_passchg, user_pass_convert, user_email, user_type, user_login_attempts

+ FROM ' . USERS_TABLE . "

+ WHERE username_clean = '" . $this->db->sql_escape($username_clean) . "'";

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

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

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

+

+ if (($this->user->ip && !$this->config['ip_login_limit_use_forwarded']) ||

+ ($this->user->forwarded_for && $this->config['ip_login_limit_use_forwarded']))

+ {

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

+ FROM ' . LOGIN_ATTEMPT_TABLE . '

+ WHERE attempt_time > ' . (time() - (int) $this->config['ip_login_limit_time']);

+ if ($this->config['ip_login_limit_use_forwarded'])

+ {

+ $sql .= " AND attempt_forwarded_for = '" . $this->db->sql_escape($this->user->forwarded_for) . "'";

+ }

+ else

+ {

+ $sql .= " AND attempt_ip = '" . $this->db->sql_escape($this->user->ip) . "' ";

+ }

+

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

+ $attempts = (int) $this->db->sql_fetchfield('attempts');

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

+

+ $attempt_data = array(

+ 'attempt_ip' => $this->user->ip,

+ 'attempt_browser' => trim(substr($this->user->browser, 0, 149)),

+ 'attempt_forwarded_for' => $this->user->forwarded_for,

+ 'attempt_time' => time(),

+ 'user_id' => ($row) ? (int) $row['user_id'] : 0,

+ 'username' => $username,

+ 'username_clean' => $username_clean,

+ );

+ $sql = 'INSERT INTO ' . LOGIN_ATTEMPT_TABLE . $this->db->sql_build_array('INSERT', $attempt_data);

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

+ }

+ else

+ {

+ $attempts = 0;

+ }

+

+ if (!$row)

+ {

+ if ($this->config['ip_login_limit_max'] && $attempts >= $this->config['ip_login_limit_max'])

+ {

+ return array(

+ 'status' => LOGIN_ERROR_ATTEMPTS,

+ 'error_msg' => 'LOGIN_ERROR_ATTEMPTS',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ return array(

+ 'status' => LOGIN_ERROR_USERNAME,

+ 'error_msg' => 'LOGIN_ERROR_USERNAME',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ $show_captcha = ($this->config['max_login_attempts'] && $row['user_login_attempts'] >= $this->config['max_login_attempts']) ||

+ ($this->config['ip_login_limit_max'] && $attempts >= $this->config['ip_login_limit_max']);

+

+ // If there are too many login attempts, we need to check for a confirm image

+ // Every auth module is able to define what to do by itself...

+ if ($show_captcha)

+ {

+ // Visual Confirmation handling

+ if (!class_exists('phpbb_captcha_factory', false))

+ {

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

+ }

+

+ $captcha = phpbb_captcha_factory::get_instance($this->config['captcha_plugin']);

+ $captcha->init(CONFIRM_LOGIN);

+ $vc_response = $captcha->validate($row);

+ if ($vc_response)

+ {

+ return array(

+ 'status' => LOGIN_ERROR_ATTEMPTS,

+ 'error_msg' => 'LOGIN_ERROR_ATTEMPTS',

+ 'user_row' => $row,

+ );

+ }

+ else

+ {

+ $captcha->reset();

+ }

+

+ }

+

+ // If the password convert flag is set we need to convert it

+ if ($row['user_pass_convert'])

+ {

+ // enable super globals to get literal value

+ // this is needed to prevent unicode normalization

+ $super_globals_disabled = $this->request->super_globals_disabled();

+ if ($super_globals_disabled)

+ {

+ $this->request->enable_super_globals();

+ }

+

+ // in phpBB2 passwords were used exactly as they were sent, with addslashes applied

+ $password_old_format = isset($_REQUEST['password']) ? (string) $_REQUEST['password'] : '';

+ $password_old_format = (!STRIP) ? addslashes($password_old_format) : $password_old_format;

+ $password_new_format = $this->request->variable('password', '', true);

+

+ if ($super_globals_disabled)

+ {

+ $this->request->disable_super_globals();

+ }

+

+ if ($password == $password_new_format)

+ {

+ if (!function_exists('utf8_to_cp1252'))

+ {

+ include($this->phpbb_root_path . 'includes/utf/data/recode_basic.' . $this->php_ext);

+ }

+

+ // cp1252 is phpBB2's default encoding, characters outside ASCII range might work when converted into that encoding

+ // plain md5 support left in for conversions from other systems.

+ if ((strlen($row['user_password']) == 34 && (phpbb_check_hash(md5($password_old_format), $row['user_password']) || phpbb_check_hash(md5(utf8_to_cp1252($password_old_format)), $row['user_password'])))

+ || (strlen($row['user_password']) == 32 && (md5($password_old_format) == $row['user_password'] || md5(utf8_to_cp1252($password_old_format)) == $row['user_password'])))

+ {

+ $hash = phpbb_hash($password_new_format);

+

+ // Update the password in the users table to the new format and remove user_pass_convert flag

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_password = \'' . $this->db->sql_escape($hash) . '\',

+ user_pass_convert = 0

+ WHERE user_id = ' . $row['user_id'];

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

+

+ $row['user_pass_convert'] = 0;

+ $row['user_password'] = $hash;

+ }

+ else

+ {

+ // Although we weren't able to convert this password we have to

+ // increase login attempt count to make sure this cannot be exploited

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_login_attempts = user_login_attempts + 1

+ WHERE user_id = ' . (int) $row['user_id'] . '

+ AND user_login_attempts < ' . LOGIN_ATTEMPTS_MAX;

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

+

+ return array(

+ 'status' => LOGIN_ERROR_PASSWORD_CONVERT,

+ 'error_msg' => 'LOGIN_ERROR_PASSWORD_CONVERT',

+ 'user_row' => $row,

+ );

+ }

+ }

+ }

+

+ // Check password ...

+ if (!$row['user_pass_convert'] && phpbb_check_hash($password, $row['user_password']))

+ {

+ // Check for old password hash...

+ if (strlen($row['user_password']) == 32)

+ {

+ $hash = phpbb_hash($password);

+

+ // Update the password in the users table to the new format

+ $sql = 'UPDATE ' . USERS_TABLE . "

+ SET user_password = '" . $this->db->sql_escape($hash) . "',

+ user_pass_convert = 0

+ WHERE user_id = {$row['user_id']}";

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

+

+ $row['user_password'] = $hash;

+ }

+

+ $sql = 'DELETE FROM ' . LOGIN_ATTEMPT_TABLE . '

+ WHERE user_id = ' . $row['user_id'];

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

+

+ if ($row['user_login_attempts'] != 0)

+ {

+ // Successful, reset login attempts (the user passed all stages)

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_login_attempts = 0

+ WHERE user_id = ' . $row['user_id'];

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

+ }

+

+ // User inactive...

+ if ($row['user_type'] == USER_INACTIVE || $row['user_type'] == USER_IGNORE)

+ {

+ return array(

+ 'status' => LOGIN_ERROR_ACTIVE,

+ 'error_msg' => 'ACTIVE_ERROR',

+ 'user_row' => $row,

+ );

+ }

+

+ // Successful login... set user_login_attempts to zero...

+ return array(

+ 'status' => LOGIN_SUCCESS,

+ 'error_msg' => false,

+ 'user_row' => $row,

+ );

+ }

+

+ // Password incorrect - increase login attempts

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_login_attempts = user_login_attempts + 1

+ WHERE user_id = ' . (int) $row['user_id'] . '

+ AND user_login_attempts < ' . LOGIN_ATTEMPTS_MAX;

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

+

+ // Give status about wrong password...

+ return array(

+ 'status' => ($show_captcha) ? LOGIN_ERROR_ATTEMPTS : LOGIN_ERROR_PASSWORD,

+ 'error_msg' => ($show_captcha) ? 'LOGIN_ERROR_ATTEMPTS' : 'LOGIN_ERROR_PASSWORD',

+ 'user_row' => $row,

+ );

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function autologin()

+ {

+ return;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function acp($new)

+ {

+ return;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function logout($data, $new_session)

+ {

+ return;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function validate_session($user)

+ {

+ return;

+ }

+}

+<html>

+<head>

+<title></title>

+<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

+</head>

+

+<body bgcolor="#FFFFFF" text="#000000">

+

+</body>

+</html>

+<?php

+/**

+*

+* @package auth

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+ * The interface authentication provider classes have to implement.

+ *

+ * @package auth

+ */

+interface phpbb_auth_provider_interface

+{

+ /**

+ * Checks whether the user is currently identified to the authentication

+ * provider.

+ * Called in acp_board while setting authentication plugins.

+ * Changing to an authentication provider will not be permitted in acp_board

+ * if there is an error.

+ *

+ * @return boolean|string False if the user is identified, otherwise an

+ * error message, or null if not implemented.

+ */

+ public function init();

+

+ /**

+ * Performs login.

+ *

+ * @param string $username The name of the user being authenticated.

+ * @param string $password The password of the user.

+ * @return array An associative array of the format:

+ * array(

+ * 'status' => status constant

+ * 'error_msg' => string

+ * 'user_row' => array

+ * )

+ */

+ public function login($username, $password);

+

+ /**

+ * Autologin function

+ *

+ * @return array|null containing the user row, empty if no auto login

+ * should take place, or null if not impletmented.

+ */

+ public function autologin();

+

+ /**

+ * This function is used to output any required fields in the authentication

+ * admin panel. It also defines any required configuration table fields.

+ *

+ * @param array $new Contains the new configuration values that have

+ * been set in acp_board.

+ * @return array|null Returns null if not implemented or an array of the

+ * form:

+ * array(

+ * 'tpl' => string

+ * 'config' => array

+ * )

+ */

+ public function acp($new);

+

+ /**

+ * Performs additional actions during logout.

+ *

+ * @param array $data An array corresponding to

+ * phpbb_session::data

+ * @param boolean $new_session True for a new session, false for no new

+ * session.

+ */

+ public function logout($data, $new_session);

+

+ /**

+ * The session validation function checks whether the user is still logged

+ * into phpBB.

+ *

+ * @param array $user

+ * @return boolean true if the given user is authenticated, false if the

+ * session should be closed, or null if not implemented.

+ */

+ public function validate_session($user);

+}

+<?php

+/**

+*

+* @package auth

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+ * Database authentication provider for phpBB3

+ *

+ * This is for authentication via the integrated user table

+ *

+ * @package auth

+ */

+class phpbb_auth_provider_ldap implements phpbb_auth_provider_interface

+{

+ /**

+ * LDAP Authentication Constructor

+ *

+ * @param phpbb_db_driver $db

+ * @param phpbb_config $config

+ * @param phpbb_user $user

+ */

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

+ {

+ $this->db = $db;

+ $this->config = $config;

+ $this->user = $user;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function init()

+ {

+ if (!@extension_loaded('ldap'))

+ {

+ return $this->user->lang['LDAP_NO_LDAP_EXTENSION'];

+ }

+

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

+ if ($this->config['ldap_port'])

+ {

+ $ldap = @ldap_connect($this->config['ldap_server'], $this->config['ldap_port']);

+ }

+ else

+ {

+ $ldap = @ldap_connect($this->config['ldap_server']);

+ }

+

+ if (!$ldap)

+ {

+ return $this->user->lang['LDAP_NO_SERVER_CONNECTION'];

+ }

+

+ @ldap_set_option($ldap, LDAP_OPT_PROTOCOL_VERSION, 3);

+ @ldap_set_option($ldap, LDAP_OPT_REFERRALS, 0);

+

+ if ($this->config['ldap_user'] || $this->config['ldap_password'])

+ {

+ if (!@ldap_bind($ldap, htmlspecialchars_decode($this->config['ldap_user']), htmlspecialchars_decode($this->config['ldap_password'])))

+ {

+ return $this->user->lang['LDAP_INCORRECT_USER_PASSWORD'];

+ }

+ }

+

+ // ldap_connect only checks whether the specified server is valid, so the connection might still fail

+ $search = @ldap_search(

+ $ldap,

+ htmlspecialchars_decode($this->config['ldap_base_dn']),

+ $this->ldap_user_filter($this->user->data['username']),

+ (empty($this->config['ldap_email'])) ?

+ array(htmlspecialchars_decode($this->config['ldap_uid'])) :

+ array(htmlspecialchars_decode($this->config['ldap_uid']), htmlspecialchars_decode($this->config['ldap_email'])),

+ 0,

+ 1

+ );

+

+ if ($search === false)

+ {

+ return $this->user->lang['LDAP_SEARCH_FAILED'];

+ }

+

+ $result = @ldap_get_entries($ldap, $search);

+

+ @ldap_close($ldap);

+

+

+ if (!is_array($result) || sizeof($result) < 2)

+ {

+ return sprintf($this->user->lang['LDAP_NO_IDENTITY'], $this->user->data['username']);

+ }

+

+ if (!empty($this->config['ldap_email']) && !isset($result[0][htmlspecialchars_decode($this->config['ldap_email'])]))

+ {

+ return $this->user->lang['LDAP_NO_EMAIL'];

+ }

+

+ return false;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function login($username, $password)

+ {

+ // do not allow empty password

+ if (!$password)

+ {

+ return array(

+ 'status' => LOGIN_ERROR_PASSWORD,

+ 'error_msg' => 'NO_PASSWORD_SUPPLIED',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ if (!$username)

+ {

+ return array(

+ 'status' => LOGIN_ERROR_USERNAME,

+ 'error_msg' => 'LOGIN_ERROR_USERNAME',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ if (!@extension_loaded('ldap'))

+ {

+ return array(

+ 'status' => LOGIN_ERROR_EXTERNAL_AUTH,

+ 'error_msg' => 'LDAP_NO_LDAP_EXTENSION',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

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

+ if ($this->config['ldap_port'])

+ {

+ $ldap = @ldap_connect($this->config['ldap_server'], $this->config['ldap_port']);

+ }

+ else

+ {

+ $ldap = @ldap_connect($this->config['ldap_server']);

+ }

+

+ if (!$ldap)

+ {

+ return array(

+ 'status' => LOGIN_ERROR_EXTERNAL_AUTH,

+ 'error_msg' => 'LDAP_NO_SERVER_CONNECTION',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ @ldap_set_option($ldap, LDAP_OPT_PROTOCOL_VERSION, 3);

+ @ldap_set_option($ldap, LDAP_OPT_REFERRALS, 0);

+

+ if ($this->config['ldap_user'] || $this->config['ldap_password'])

+ {

+ if (!@ldap_bind($ldap, htmlspecialchars_decode($this->config['ldap_user']), htmlspecialchars_decode($this->config['ldap_password'])))

+ {

+ return array(

+ 'status' => LOGIN_ERROR_EXTERNAL_AUTH,

+ 'error_msg' => 'LDAP_NO_SERVER_CONNECTION',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+ }

+

+ $search = @ldap_search(

+ $ldap,

+ htmlspecialchars_decode($this->config['ldap_base_dn']),

+ $this->ldap_user_filter($username),

+ (empty($this->config['ldap_email'])) ?

+ array(htmlspecialchars_decode($this->config['ldap_uid'])) :

+ array(htmlspecialchars_decode($this->config['ldap_uid']), htmlspecialchars_decode($this->config['ldap_email'])),

+ 0,

+ 1

+ );

+

+ $ldap_result = @ldap_get_entries($ldap, $search);

+

+ if (is_array($ldap_result) && sizeof($ldap_result) > 1)

+ {

+ if (@ldap_bind($ldap, $ldap_result[0]['dn'], htmlspecialchars_decode($password)))

+ {

+ @ldap_close($ldap);

+

+ $sql ='SELECT user_id, username, user_password, user_passchg, user_email, user_type

+ FROM ' . USERS_TABLE . "

+ WHERE username_clean = '" . $this->db->sql_escape(utf8_clean_string($username)) . "'";

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

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

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

+

+ if ($row)

+ {

+ unset($ldap_result);

+

+ // User inactive...

+ if ($row['user_type'] == USER_INACTIVE || $row['user_type'] == USER_IGNORE)

+ {

+ return array(

+ 'status' => LOGIN_ERROR_ACTIVE,

+ 'error_msg' => 'ACTIVE_ERROR',

+ 'user_row' => $row,

+ );

+ }

+

+ // Successful login... set user_login_attempts to zero...

+ return array(

+ 'status' => LOGIN_SUCCESS,

+ 'error_msg' => false,

+ 'user_row' => $row,

+ );

+ }

+ else

+ {

+ // retrieve default group id

+ $sql = 'SELECT group_id

+ FROM ' . GROUPS_TABLE . "

+ WHERE group_name = '" . $this->db->sql_escape('REGISTERED') . "'

+ AND group_type = " . GROUP_SPECIAL;

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

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

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

+

+ if (!$row)

+ {

+ trigger_error('NO_GROUP');

+ }

+

+ // generate user account data

+ $ldap_user_row = array(

+ 'username' => $username,

+ 'user_password' => phpbb_hash($password),

+ 'user_email' => (!empty($this->config['ldap_email'])) ? utf8_htmlspecialchars($ldap_result[0][htmlspecialchars_decode($this->config['ldap_email'])][0]) : '',

+ 'group_id' => (int) $row['group_id'],

+ 'user_type' => USER_NORMAL,

+ 'user_ip' => $this->user->ip,

+ 'user_new' => ($this->config['new_member_post_limit']) ? 1 : 0,

+ );

+

+ unset($ldap_result);

+

+ // this is the user's first login so create an empty profile

+ return array(

+ 'status' => LOGIN_SUCCESS_CREATE_PROFILE,

+ 'error_msg' => false,

+ 'user_row' => $ldap_user_row,

+ );

+ }

+ }

+ else

+ {

+ unset($ldap_result);

+ @ldap_close($ldap);

+

+ // Give status about wrong password...

+ return array(

+ 'status' => LOGIN_ERROR_PASSWORD,

+ 'error_msg' => 'LOGIN_ERROR_PASSWORD',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+ }

+

+ @ldap_close($ldap);

+

+ return array(

+ 'status' => LOGIN_ERROR_USERNAME,

+ 'error_msg' => 'LOGIN_ERROR_USERNAME',

+ 'user_row' => array('user_id' => ANONYMOUS),

+ );

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function autologin()

+ {

+ return;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function acp($new)

+ {

+ $tpl = '

+

+ <dl>

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

+ <dd><input type="text" id="ldap_server" size="40" name="config[ldap_server]" value="' . $new['ldap_server'] . '" /></dd>

+ </dl>

+ <dl>

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

+ <dd><input type="text" id="ldap_port" size="40" name="config[ldap_port]" value="' . $new['ldap_port'] . '" /></dd>

+ </dl>

+ <dl>

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

+ <dd><input type="text" id="ldap_dn" size="40" name="config[ldap_base_dn]" value="' . $new['ldap_base_dn'] . '" /></dd>

+ </dl>

+ <dl>

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

+ <dd><input type="text" id="ldap_uid" size="40" name="config[ldap_uid]" value="' . $new['ldap_uid'] . '" /></dd>

+ </dl>

+ <dl>

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

+ <dd><input type="text" id="ldap_user_filter" size="40" name="config[ldap_user_filter]" value="' . $new['ldap_user_filter'] . '" /></dd>

+ </dl>

+ <dl>

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

+ <dd><input type="email" id="ldap_email" size="40" name="config[ldap_email]" value="' . $new['ldap_email'] . '" /></dd>

+ </dl>

+ <dl>

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

+ <dd><input type="text" id="ldap_user" size="40" name="config[ldap_user]" value="' . $new['ldap_user'] . '" /></dd>

+ </dl>

+ <dl>

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

+ <dd><input type="password" id="ldap_password" size="40" name="config[ldap_password]" value="' . $new['ldap_password'] . '" autocomplete="off" /></dd>

+ </dl>

+ ';

+

+ // These are fields required in the config table

+ return array(

+ 'tpl' => $tpl,

+ 'config' => array('ldap_server', 'ldap_port', 'ldap_base_dn', 'ldap_uid', 'ldap_user_filter', 'ldap_email', 'ldap_user', 'ldap_password')

+ );

+ }

+

+ /**

+ * Generates a filter string for ldap_search to find a user

+ *

+ * @param $username string Username identifying the searched user

+ *

+ * @return string A filter string for ldap_search

+ */

+ private function ldap_user_filter($username)

+ {

+ $filter = '(' . $this->config['ldap_uid'] . '=' . $this->ldap_escape(htmlspecialchars_decode($username)) . ')';

+ if ($this->config['ldap_user_filter'])

+ {

+ $_filter = ($this->config['ldap_user_filter'][0] == '(' && substr($this->config['ldap_user_filter'], -1) == ')') ? $this->config['ldap_user_filter'] : "({$this->config['ldap_user_filter']})";

+ $filter = "(&{$filter}{$_filter})";

+ }

+ return $filter;

+ }

+

+ /**

+ * Escapes an LDAP AttributeValue

+ *

+ * @param string $string The string to be escaped

+ * @return string The escaped string

+ */

+ private function ldap_escape($string)

+ {

+ return str_replace(array('*', '\\', '(', ')'), array('\\*', '\\\\', '\\(', '\\)'), $string);

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function logout($data, $new_session)

+ {

+ return;

+ }

+

+ /**

+ * {@inheritdoc}

+ */

+ public function validate_session($user)

+ {

+ return;

+ }

+}

+ require($this->phpbb_root_path . 'includes/functions_user.' . $this->php_ext);

+ require($this->phpbb_root_path . 'includes/functions_user.' . $this->php_ext);

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

+ 'src' => $this->phpbb_root_path . 'download/file.' . $this->php_ext . '?avatar=' . $row['avatar'],

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

+ 'avatar_filesize' => array('lang' => 'MAX_FILESIZE', 'validate' => 'int:0', 'type' => 'number:0', 'explain' => true, 'append' => ' ' . $user->lang['BYTES']),

+ * Default avatar data row

+ * @var array

+ */

+ static protected $default_row = array(

+ 'avatar' => '',

+ 'avatar_type' => '',

+ 'avatar_width' => '',

+ 'avatar_height' => '',

+ );

+

+ /**

+ // Upon creation of a user/group $row might be empty

+ if (empty($row))

+ {

+ return self::$default_row;

+ }

+

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

+ trigger_error('RECAPTCHA_SOCKET_ERROR', E_USER_ERROR);

+ public function __construct($prefix, $path, $php_ext = 'php', phpbb_cache_driver_interface $cache = null)

+ return $this->path . $this->cached_paths[$class] . '.' . $this->php_ext;

+ if (!file_exists($this->path . $relative_path . '.' . $this->php_ext))

+ return $this->path . $relative_path . '.' . $this->php_ext;

+define('CONFIRM_REPORT', 4);

+ * Generate a URL

+ * @param string $route The route to travel

+ * @param mixed $params String or array of additional url parameters

+ * @param bool $is_amp Is url using &amp; (true) or & (false)

+ * @param string $session_id Possibility to use a custom session id instead of the global one

+ * @return string The URL already passed through append_sid()

+ public function url($route, $params = false, $is_amp = true, $session_id = false)

+ $route_params = '';

+ if (($route_delim = strpos($route, '?')) !== false)

+ {

+ $route_params = substr($route, $route_delim);

+ $route = substr($route, 0, $route_delim);

+ }

+

+ if (is_array($params) && !empty($params))

+ {

+ $params = array_merge(array(

+ 'controller' => $route,

+ ), $params);

+ }

+ else if (is_string($params) && $params)

+ {

+ $params = 'controller=' . $route . (($is_amp) ? '&amp;' : '&') . $params;

+ }

+ else

+ {

+ $params = array('controller' => $route);

+ }

+

+ return append_sid($this->phpbb_root_path . 'app.' . $this->php_ext . $route_params, $params, $is_amp, $session_id);

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

+ function sql_multi_insert($table, $sql_ary)

+<?php

+/**

+*

+* @package dbal

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* MSSQL Database Base Abstraction Layer

+* @package dbal

+ */

+abstract class phpbb_db_driver_mssql_base extends phpbb_db_driver

+{

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_concatenate($expr1, $expr2)

+ {

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

+ }

+

+ /**

+ * Escape string used in sql query

+ */

+ function sql_escape($msg)

+ {

+ return str_replace(array("'", "\0"), array("''", ''), $msg);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ function sql_lower_text($column_name)

+ {

+ return "LOWER(SUBSTRING($column_name, 1, DATALENGTH($column_name)))";

+ }

+

+ /**

+ * Build LIKE expression

+ * @access private

+ */

+ function _sql_like_expression($expression)

+ {

+ return $expression . " ESCAPE '\\'";

+ }

+

+ /**

+ * Build db-specific query data

+ * @access private

+ */

+ function _sql_custom_build($stage, $data)

+ {

+ return $data;

+ }

+}

+class phpbb_db_driver_mssql_odbc extends phpbb_db_driver_mssql_base

+ function sql_fetchrow($query_id = false)

+class phpbb_db_driver_mssqlnative extends phpbb_db_driver_mssql_base

+ if ($cache && $cache_ttl)

+ return ($this->db_connect_id) ? @sqlsrv_rows_affected($this->query_result) : false;

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

+ if (isset($this->open_queries[(int) $query_id]))

+ unset($this->open_queries[(int) $query_id]);

+class phpbb_db_driver_mysql extends phpbb_db_driver_mysql_base

+<?php

+/**

+*

+* @package dbal

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Abstract MySQL Database Base Abstraction Layer

+* @package dbal

+*/

+abstract class phpbb_db_driver_mysql_base extends phpbb_db_driver

+{

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_concatenate($expr1, $expr2)

+ {

+ return 'CONCAT(' . $expr1 . ', ' . $expr2 . ')';

+ }

+

+ /**

+ * Build LIMIT query

+ */

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

+ {

+ $this->query_result = false;

+

+ // if $total is set to 0 we do not want to limit the number of rows

+ if ($total == 0)

+ {

+ // MySQL 4.1+ no longer supports -1 in limit queries

+ $total = '18446744073709551615';

+ }

+

+ $query .= "\n LIMIT " . ((!empty($offset)) ? $offset . ', ' . $total : $total);

+

+ return $this->sql_query($query, $cache_ttl);

+ }

+

+ /**

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

+ {

+ $table_status = $this->get_table_status($table_name);

+

+ if (isset($table_status['Engine']))

+ {

+ if ($table_status['Engine'] === 'MyISAM')

+ {

+ return $table_status['Rows'];

+ }

+ else if ($table_status['Engine'] === 'InnoDB' && $table_status['Rows'] > 100000)

+ {

+ return '~' . $table_status['Rows'];

+ }

+ }

+

+ return parent::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)

+ {

+ $table_status = $this->get_table_status($table_name);

+

+ if (isset($table_status['Engine']) && $table_status['Engine'] === 'MyISAM')

+ {

+ return $table_status['Rows'];

+ }

+

+ return parent::get_row_count($table_name);

+ }

+

+ /**

+ * Gets some information about the specified table.

+ *

+ * @param string $table_name Table name

+ *

+ * @return array

+ *

+ * @access protected

+ */

+ function get_table_status($table_name)

+ {

+ $sql = "SHOW TABLE STATUS

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

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

+ $table_status = $this->sql_fetchrow($result);

+ $this->sql_freeresult($result);

+

+ return $table_status;

+ }

+

+ /**

+ * Build LIKE expression

+ * @access private

+ */

+ function _sql_like_expression($expression)

+ {

+ return $expression;

+ }

+

+ /**

+ * Build db-specific query data

+ * @access private

+ */

+ function _sql_custom_build($stage, $data)

+ {

+ switch ($stage)

+ {

+ case 'FROM':

+ $data = '(' . $data . ')';

+ break;

+ }

+

+ return $data;

+ }

+}

+class phpbb_db_driver_mysqli extends phpbb_db_driver_mysql_base

+ * @param bool $raw if true, only return the fetched sql_server_version

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_310_boardindex extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return isset($this->config['board_index_text']);

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('board_index_text', '')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_310_forgot_password extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return isset($this->config['allow_password_reset']);

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_30x_3_0_11');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('allow_password_reset', 1)),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_310_jquery_update extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ return $this->config['load_jquery_url'] !== '//ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js';

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ 'phpbb_db_migration_data_310_dev',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('load_jquery_url', '//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js')),

+ );

+ }

+

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_310_notifications_schema_fix extends phpbb_db_migration

+{

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_310_notifications');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'notification_types',

+ $this->table_prefix . 'notifications',

+ ),

+ 'add_tables' => array(

+ $this->table_prefix . 'notification_types' => array(

+ 'COLUMNS' => array(

+ 'notification_type_id' => array('USINT', NULL, 'auto_increment'),

+ 'notification_type_name' => array('VCHAR:255', ''),

+ 'notification_type_enabled' => array('BOOL', 1),

+ ),

+ 'PRIMARY_KEY' => array('notification_type_id'),

+ 'KEYS' => array(

+ 'type' => array('UNIQUE', array('notification_type_name')),

+ ),

+ ),

+ $this->table_prefix . 'notifications' => array(

+ 'COLUMNS' => array(

+ 'notification_id' => array('UINT:10', NULL, 'auto_increment'),

+ 'notification_type_id' => array('USINT', 0),

+ 'item_id' => array('UINT', 0),

+ 'item_parent_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'notification_read' => array('BOOL', 0),

+ 'notification_time' => array('TIMESTAMP', 1),

+ 'notification_data' => array('TEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'notification_id',

+ 'KEYS' => array(

+ 'item_ident' => array('INDEX', array('notification_type_id', 'item_id')),

+ 'user' => array('INDEX', array('user_id', 'notification_read')),

+ ),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'notification_types',

+ $this->table_prefix . 'notifications',

+ ),

+ 'add_tables' => array(

+ $this->table_prefix . 'notification_types' => array(

+ 'COLUMNS' => array(

+ 'notification_type' => array('VCHAR:255', ''),

+ 'notification_type_enabled' => array('BOOL', 1),

+ ),

+ 'PRIMARY_KEY' => array('notification_type', 'notification_type_enabled'),

+ ),

+ $this->table_prefix . 'notifications' => array(

+ 'COLUMNS' => array(

+ 'notification_id' => array('UINT', NULL, 'auto_increment'),

+ 'item_type' => array('VCHAR:255', ''),

+ 'item_id' => array('UINT', 0),

+ 'item_parent_id' => array('UINT', 0),

+ 'user_id' => array('UINT', 0),

+ 'notification_read' => array('BOOL', 0),

+ 'notification_time' => array('TIMESTAMP', 1),

+ 'notification_data' => array('TEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'notification_id',

+ 'KEYS' => array(

+ 'item_ident' => array('INDEX', array('item_type', 'item_id')),

+ 'user' => array('INDEX', array('user_id', 'notification_read')),

+ ),

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+class phpbb_db_migration_data_310_signature_module_auth extends phpbb_db_migration

+{

+ public function effectively_installed()

+ {

+ $sql = 'SELECT module_auth

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = 'ucp'

+ AND module_basename = 'ucp_profile'

+ AND module_mode = 'signature'";

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

+ $module_auth = $this->db_sql_fetchfield('module_auth');

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

+

+ return $module_auth === 'acl_u_sig' || $module_auth === false;

+ }

+

+ static public function depends_on()

+ {

+ return array('phpbb_db_migration_data_31x_dev');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(

+ array($this, 'update_signature_module_auth'),

+ ),

+ ),

+ );

+ }

+

+ public function update_signature_module_auth()

+ {

+ $sql = 'UPDATE ' . MODULES_TABLE . "

+ SET module_auth = 'acl_u_sig'

+ WHERE module_class = 'ucp'

+ AND module_basename = 'ucp_profile'

+ AND module_mode = 'signature'

+ AND module_auth = ''";

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

+ }

+}

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

+ $this->table_prefix . 'styles' => array(

+ 'style_path' => array('VCHAR:100', ''),

+ 'bbcode_bitfield' => array('VCHAR:255', 'kNg='),

+ 'style_parent_id' => array('UINT', 0),

+ 'style_parent_tree' => array('TEXT', ''),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

+ $this->table_prefix . 'styles' => array(

+ 'style_path',

+ 'bbcode_bitfield',

+ 'style_parent_id',

+ 'style_parent_tree',

+ ),

+ ),

+ );

+ }

+

+ $module_log_name = ((isset($this->user->lang[$data['module_langname']])) ? $this->user->lang[$data['module_langname']] : $data['module_langname']);

+ add_log('admin', 'LOG_MODULE_ADD', $module_log_name);

+ // reverse order of steps if reverting

+ if ($revert === true)

+ {

+ $steps = array_reverse($steps);

+ }

+

+<?php

+/**

+*

+* @package dbal

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Collects rows for insert into a database until the buffer size is reached.

+* Then flushes the buffer to the database and starts over again.

+*

+* Benefits over collecting a (possibly huge) insert array and then using

+* $db->sql_multi_insert() include:

+*

+* - Going over max packet size of the database connection is usually prevented

+* because the data is submitted in batches.

+*

+* - Reaching database connection timeout is usually prevented because

+* submission of batches talks to the database every now and then.

+*

+* - Usage of less PHP memory because data no longer needed is discarded on

+* buffer flush.

+*

+* Attention:

+* Please note that users of this class have to call flush() to flush the

+* remaining rows to the database after their batch insert operation is

+* finished.

+*

+* Usage:

+* <code>

+* $buffer = new phpbb_db_sql_insert_buffer($db, 'test_table', 1234);

+*

+* while (do_stuff())

+* {

+* $buffer->insert(array(

+* 'column1' => 'value1',

+* 'column2' => 'value2',

+* ));

+* }

+*

+* $buffer->flush();

+* </code>

+*

+* @package dbal

+*/

+class phpbb_db_sql_insert_buffer

+{

+ /** @var phpbb_db_driver */

+ protected $db;

+

+ /** @var string */

+ protected $table_name;

+

+ /** @var int */

+ protected $max_buffered_rows;

+

+ /** @var array */

+ protected $buffer = array();

+

+ /**

+ * @param phpbb_db_driver $db

+ * @param string $table_name

+ * @param int $max_buffered_rows

+ */

+ public function __construct(phpbb_db_driver $db, $table_name, $max_buffered_rows = 500)

+ {

+ $this->db = $db;

+ $this->table_name = $table_name;

+ $this->max_buffered_rows = $max_buffered_rows;

+ }

+

+ /**

+ * Inserts a single row into the buffer if multi insert is supported by the

+ * database (otherwise an insert query is sent immediately). Then flushes

+ * the buffer if the number of rows in the buffer is now greater than or

+ * equal to $max_buffered_rows.

+ *

+ * @param array $row

+ *

+ * @return bool True when some data was flushed to the database.

+ * False otherwise.

+ */

+ public function insert(array $row)

+ {

+ $this->buffer[] = $row;

+

+ // Flush buffer if it is full or when DB does not support multi inserts.

+ // In the later case, the buffer will always only contain one row.

+ if (!$this->db->multi_insert || sizeof($this->buffer) >= $this->max_buffered_rows)

+ {

+ return $this->flush();

+ }

+

+ return false;

+ }

+

+ /**

+ * Inserts a row set, i.e. an array of rows, by calling insert().

+ *

+ * Please note that it is in most cases better to use insert() instead of

+ * first building a huge rowset. Or at least sizeof($rows) should be kept

+ * small.

+ *

+ * @param array $rows

+ *

+ * @return bool True when some data was flushed to the database.

+ * False otherwise.

+ */

+ public function insert_all(array $rows)

+ {

+ // Using bitwise |= because PHP does not have logical ||=

+ $result = 0;

+

+ foreach ($rows as $row)

+ {

+ $result |= (int) $this->insert($row);

+ }

+

+ return (bool) $result;

+ }

+

+ /**

+ * Flushes the buffer content to the DB and clears the buffer.

+ *

+ * @return bool True when some data was flushed to the database.

+ * False otherwise.

+ */

+ public function flush()

+ {

+ if (!empty($this->buffer))

+ {

+ $this->db->sql_multi_insert($this->table_name, $this->buffer);

+ $this->buffer = array();

+

+ return true;

+ }

+

+ return false;

+ }

+}

+ /** @var phpbb_extension_finder */

+ protected $finder;

+

+ /** @var phpbb_db_migrator */

+ protected $migrator;

+

+ /** @var string */

+ protected $extension_name;

+

+ /** @var string */

+ protected $extension_path;

+

+ * @param phpbb_extension_finder $extension_finder

+ * @param string $extension_name Name of this extension (from ext.manager)

+ * @param string $extension_path Relative path to this extension

+ public function __construct(ContainerInterface $container, phpbb_extension_finder $extension_finder, phpbb_db_migrator $migrator, $extension_name, $extension_path)

+ $this->extension_finder = $extension_finder;

+ $this->migrator = $migrator;

+

+ $this->extension_name = $extension_name;

+ $this->extension_path = $extension_path;

+ * Single enable step that installs any included migrations

+ $migrations = $this->get_migration_file_list();

+

+ $this->migrator->set_migrations($migrations);

+

+ $this->migrator->update();

+

+ return !$this->migrator->finished();

+ * Single purge step that reverts any included and installed migrations

+ $migrations = $this->get_migration_file_list();

+

+ $this->migrator->set_migrations($migrations);

+

+ foreach ($migrations as $migration)

+ {

+ while ($this->migrator->migration_state($migration) !== false)

+ {

+ $this->migrator->revert($migration);

+

+ return true;

+ }

+ }

+

+

+ /**

+ * Get the list of migration files from this extension

+ *

+ * @return array

+ */

+ protected function get_migration_file_list()

+ {

+ static $migrations = false;

+

+ if ($migrations !== false)

+ {

+ return $migrations;

+ }

+

+ // Only have the finder search in this extension path directory

+ $migrations = $this->extension_finder

+ ->extension_directory('/migrations')

+ ->find_from_extension($this->extension_name, $this->extension_path);

+ $migrations = $this->extension_finder->get_classes_from_files($migrations);

+

+ return $migrations;

+ }

+ protected $filesystem;

+ * @param phpbb_filesystem $filesystem Filesystem instance

+ public function __construct(phpbb_extension_manager $extension_manager, phpbb_filesystem $filesystem, $phpbb_root_path = '', phpbb_cache_driver_interface $cache = null, $php_ext = 'php', $cache_name = '_ext_finder')

+ $this->filesystem = $filesystem;

+ $directory = $this->filesystem->clean_path($directory);

+ $this->query['extension_suffix'] .= '.' . $this->php_ext;

+ $this->query['core_suffix'] .= '.' . $this->php_ext;

+ $classes[] = 'phpbb_' . str_replace('/', '_', substr($file, 0, -strlen('.' . $this->php_ext)));

+

+ /**

+ * Finds all file system entries matching the configured options for one

+ * specific extension

+ *

+ * @param string $extension_name Name of the extension

+ * @param string $extension_path Relative path to the extension root directory

+ * @param bool $cache Whether the result should be cached

+ * @param bool $is_dir Directories will be returned when true, only files

+ * otherwise

+ * @return array An array of paths to found items

+ */

+ public function find_from_extension($extension_name, $extension_path, $cache = true, $is_dir = false)

+ {

+ $extensions = array(

+ $extension_name => $extension_path,

+ );

+

+ $files = array();

+ $file_list = $this->find_from_paths($extensions, $cache, $is_dir);

+

+ foreach ($file_list as $file)

+ {

+ $files[$file['named_path']] = $file['ext_name'];

+ }

+

+ return $files;

+ }

+ * @param phpbb_filesystem $filesystem

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

+ $this->filesystem = $filesystem;

+ $migrator = $this->container->get('migrator');

+

+ return new $extension_class_name($this->container, $this->get_finder(), $migrator, $name, $this->get_extension_path($name, true));

+ return new phpbb_extension_base($this->container, $this->get_finder(), $migrator, $name, $this->get_extension_path($name, true));

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

+ $sql = 'SELECT COUNT(ext_name) as row_count

+ FROM ' . $this->extension_table . "

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

+ $count = $this->db->sql_fetchfield('row_count');

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

+ if ($count)

+ {

+ $sql = 'UPDATE ' . $this->extension_table . '

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

+ WHERE ext_name = '" . $this->db->sql_escape($name) . "'";

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

+ }

+ else

+ if ($file_info->isFile() && $file_info->getFilename() == 'ext.' . $this->php_ext)

+ return new phpbb_extension_finder($this, $this->filesystem, $this->phpbb_root_path, $this->cache, $this->php_ext, $this->cache_name . '_finder');

+ /**

+ * phpBB Config instance

+ * @var phpbb_config

+ */

+ protected $config;

+

+ /**

+ * phpBB Extension Manager

+ * @var phpbb_extension_manager

+ */

+

+ /**

+ * phpBB Template instance

+ * @var phpbb_template

+ */

+

+ /**

+ * phpBB root path

+ * @var string

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * Name (including vendor) of the extension

+ * @var string

+ */

+

+ /**

+ * Metadata from the composer.json file

+ * @var array

+ */

+

+ /**

+ * Link (including root path) to the metadata file

+ * @var string

+ */

+ * @param string $ext_name Name (including vendor) of the extension

+ * @param phpbb_config $config phpBB Config instance

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

+ * @param phpbb_template $template phpBB Template instance

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

+ public function __construct($ext_name, phpbb_config $config, phpbb_extension_manager $extension_manager, phpbb_template $template, $phpbb_root_path)

+ $this->template = $template;

+ $this->phpbb_root_path = $phpbb_root_path;

+

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Base class with some generic functions and settings.

+*

+* @package phpBB3

+*/

+abstract class phpbb_feed_base

+{

+ /**

+ * Feed helper object

+ * @var phpbb_feed_helper

+ */

+ protected $helper;

+

+ /** @var phpbb_config */

+ protected $config;

+

+ /** @var phpbb_db_driver */

+ protected $db;

+

+ /** @var phpbb_cache_driver_interface */

+ protected $cache;

+

+ /** @var phpbb_user */

+ protected $user;

+

+ /** @var phpbb_auth */

+ protected $auth;

+

+ /** @var string */

+ protected $phpEx;

+

+ /**

+ * SQL Query to be executed to get feed items

+ */

+ var $sql = array();

+

+ /**

+ * Keys specified for retrieval of title, content, etc.

+ */

+ var $keys = array();

+

+ /**

+ * Number of items to fetch. Usually overwritten by $config['feed_something']

+ */

+ var $num_items = 15;

+

+ /**

+ * Separator for title elements to separate items (for example forum / topic)

+ */

+ var $separator = "\xE2\x80\xA2"; // &bull;

+

+ /**

+ * Separator for the statistics row (Posted by, post date, replies, etc.)

+ */

+ var $separator_stats = "\xE2\x80\x94"; // &mdash;

+

+ /**

+ * Constructor

+ *

+ * @param phpbb_feed_helper $helper Feed helper

+ * @param phpbb_config $config Config object

+ * @param phpbb_db_driver $db Database connection

+ * @param phpbb_cache_driver_interface $cache Cache object

+ * @param phpbb_user $user User object

+ * @param phpbb_auth $auth Auth object

+ * @param string $phpEx php file extension

+ * @return null

+ */

+ function __construct(phpbb_feed_helper $helper, phpbb_config $config, phpbb_db_driver $db, phpbb_cache_driver_interface $cache, phpbb_user $user, phpbb_auth $auth, $phpEx)

+ {

+ $this->config = $config;

+ $this->helper = $helper;

+ $this->db = $db;

+ $this->cache = $cache;

+ $this->user = $user;

+ $this->auth = $auth;

+ $this->phpEx = $phpEx;

+

+ $this->set_keys();

+

+ // Allow num_items to be string

+ if (is_string($this->num_items))

+ {

+ $this->num_items = (int) $this->config[$this->num_items];

+

+ // A precaution

+ if (!$this->num_items)

+ {

+ $this->num_items = 10;

+ }

+ }

+ }

+

+ /**

+ * Set keys.

+ */

+ function set_keys()

+ {

+ }

+

+ /**

+ * Open feed

+ */

+ function open()

+ {

+ }

+

+ /**

+ * Close feed

+ */

+ function close()

+ {

+ if (!empty($this->result))

+ {

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

+ }

+ }

+

+ /**

+ * Set key

+ */

+ function set($key, $value)

+ {

+ $this->keys[$key] = $value;

+ }

+

+ /**

+ * Get key

+ */

+ function get($key)

+ {

+ return (isset($this->keys[$key])) ? $this->keys[$key] : NULL;

+ }

+

+ function get_readable_forums()

+ {

+ static $forum_ids;

+

+ if (!isset($forum_ids))

+ {

+ $forum_ids = array_keys($this->auth->acl_getf('f_read', true));

+ }

+

+ return $forum_ids;

+ }

+

+ function get_moderator_approve_forums()

+ {

+ static $forum_ids;

+

+ if (!isset($forum_ids))

+ {

+ $forum_ids = array_keys($this->auth->acl_getf('m_approve', true));

+ }

+

+ return $forum_ids;

+ }

+

+ function is_moderator_approve_forum($forum_id)

+ {

+ static $forum_ids;

+

+ if (!isset($forum_ids))

+ {

+ $forum_ids = array_flip($this->get_moderator_approve_forums());

+ }

+

+ return (isset($forum_ids[$forum_id])) ? true : false;

+ }

+

+ function get_excluded_forums()

+ {

+ static $forum_ids;

+

+ // Matches acp/acp_board.php

+ $cache_name = 'feed_excluded_forum_ids';

+

+ if (!isset($forum_ids) && ($forum_ids = $this->cache->get('_' . $cache_name)) === false)

+ {

+ $sql = 'SELECT forum_id

+ FROM ' . FORUMS_TABLE . '

+ WHERE ' . $this->db->sql_bit_and('forum_options', FORUM_OPTION_FEED_EXCLUDE, '<> 0');

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

+

+ $forum_ids = array();

+ while ($forum_id = (int) $this->db->sql_fetchfield('forum_id'))

+ {

+ $forum_ids[$forum_id] = $forum_id;

+ }

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

+

+ $this->cache->put('_' . $cache_name, $forum_ids);

+ }

+

+ return $forum_ids;

+ }

+

+ function is_excluded_forum($forum_id)

+ {

+ $forum_ids = $this->get_excluded_forums();

+

+ return isset($forum_ids[$forum_id]) ? true : false;

+ }

+

+ function get_passworded_forums()

+ {

+ return $this->user->get_passworded_forums();

+ }

+

+ function get_item()

+ {

+ static $result;

+

+ if (!isset($result))

+ {

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

+ {

+ return false;

+ }

+

+ // Query database

+ $sql = $this->db->sql_build_query('SELECT', $this->sql);

+ $result = $this->db->sql_query_limit($sql, $this->num_items);

+ }

+

+ return $this->db->sql_fetchrow($result);

+ }

+

+ function user_viewprofile($row)

+ {

+ $author_id = (int) $row[$this->get('author_id')];

+

+ if ($author_id == ANONYMOUS)

+ {

+ // Since we cannot link to a profile, we just return GUEST

+ // instead of $row['username']

+ return $this->user->lang['GUEST'];

+ }

+

+ return '<a href="' . $this->helper->append_sid('memberlist.' . $this->phpEx, 'mode=viewprofile&amp;u=' . $author_id) . '">' . $row[$this->get('creator')] . '</a>';

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Factory class to return correct object

+* @package phpBB3

+*/

+class phpbb_feed_factory

+{

+ /**

+ * Service container object

+ * @var object

+ */

+ protected $container;

+

+ /** @var phpbb_config */

+ protected $config;

+

+ /** @var phpbb_db_driver */

+ protected $db;

+

+ /**

+ * Constructor

+ *

+ * @param objec $container Container object

+ * @param phpbb_config $config Config object

+ * @param phpbb_db_driver $db Database connection

+ * @return null

+ */

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

+ {

+ $this->container = $container;

+ $this->config = $config;

+ $this->db = $db;

+ }

+

+ /**

+ * Return correct object for specified mode

+ *

+ * @param string $mode The feeds mode.

+ * @param int $forum_id Forum id specified by the script if forum feed provided.

+ * @param int $topic_id Topic id specified by the script if topic feed provided.

+ *

+ * @return object Returns correct feeds object for specified mode.

+ */

+ function get_feed($mode, $forum_id, $topic_id)

+ {

+ switch ($mode)

+ {

+ case 'forums':

+ if (!$this->config['feed_overall_forums'])

+ {

+ return false;

+ }

+

+ return $this->container->get('feed.forums');

+ break;

+

+ case 'topics':

+ case 'topics_new':

+ if (!$this->config['feed_topics_new'])

+ {

+ return false;

+ }

+

+ return $this->container->get('feed.topics');

+ break;

+

+ case 'topics_active':

+ if (!$this->config['feed_topics_active'])

+ {

+ return false;

+ }

+

+ return $this->container->get('feed.topics_active');

+ break;

+

+ case 'news':

+ // Get at least one news forum

+ $sql = 'SELECT forum_id

+ FROM ' . FORUMS_TABLE . '

+ WHERE ' . $this->db->sql_bit_and('forum_options', FORUM_OPTION_FEED_NEWS, '<> 0');

+ $result = $this->db->sql_query_limit($sql, 1, 0, 600);

+ $s_feed_news = (int) $this->db->sql_fetchfield('forum_id');

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

+

+ if (!$s_feed_news)

+ {

+ return false;

+ }

+

+ return $this->container->get('feed.news');

+ break;

+

+ default:

+ if ($topic_id && $this->config['feed_topic'])

+ {

+ return $this->container->get('feed.topic')

+ ->set_topic_id($topic_id);

+ }

+ else if ($forum_id && $this->config['feed_forum'])

+ {

+ return $this->container->get('feed.forum')

+ ->set_forum_id($forum_id);

+ }

+ else if ($this->config['feed_overall'])

+ {

+ return $this->container->get('feed.overall');

+ }

+

+ return false;

+ break;

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Forum feed

+*

+* This will give you the last {$this->num_items} posts made

+* within a specific forum.

+*

+* @package phpBB3

+*/

+class phpbb_feed_forum extends phpbb_feed_post_base

+{

+ var $forum_id = 0;

+ var $forum_data = array();

+

+ /**

+ * Set the Forum ID

+ *

+ * @param int $forum_id Forum ID

+ * @return phpbb_feed_forum

+ */

+ public function set_forum_id($topic_id)

+ {

+ $this->forum_id = (int) $forum_id;

+

+ return $this;

+ }

+

+ function open()

+ {

+ // Check if forum exists

+ $sql = 'SELECT forum_id, forum_name, forum_password, forum_type, forum_options

+ FROM ' . FORUMS_TABLE . '

+ WHERE forum_id = ' . $this->forum_id;

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

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

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

+

+ if (empty($this->forum_data))

+ {

+ trigger_error('NO_FORUM');

+ }

+

+ // Forum needs to be postable

+ if ($this->forum_data['forum_type'] != FORUM_POST)

+ {

+ trigger_error('NO_FEED');

+ }

+

+ // Make sure forum is not excluded from feed

+ if (phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $this->forum_data['forum_options']))

+ {

+ trigger_error('NO_FEED');

+ }

+

+ // Make sure we can read this forum

+ if (!$this->auth->acl_get('f_read', $this->forum_id))

+ {

+ trigger_error('SORRY_AUTH_READ');

+ }

+

+ // Make sure forum is not passworded or user is authed

+ if ($this->forum_data['forum_password'])

+ {

+ $forum_ids_passworded = $this->get_passworded_forums();

+

+ if (isset($forum_ids_passworded[$this->forum_id]))

+ {

+ trigger_error('SORRY_AUTH_READ');

+ }

+

+ unset($forum_ids_passworded);

+ }

+ }

+

+ function get_sql()

+ {

+ $sql_visibility = phpbb_content_visibility::get_visibility_sql('topic', $this->forum_id);

+

+ // Determine topics with recent activity

+ $sql = 'SELECT topic_id, topic_last_post_time

+ FROM ' . TOPICS_TABLE . '

+ WHERE forum_id = ' . $this->forum_id . '

+ AND topic_moved_id = 0

+ ' . (($sql_visibility) ? ' AND ' . $sql_visibility : '') . '

+ ORDER BY topic_last_post_time DESC';

+ $result = $this->db->sql_query_limit($sql, $this->num_items);

+

+ $topic_ids = array();

+ $min_post_time = 0;

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

+ {

+ $topic_ids[] = (int) $row['topic_id'];

+

+ $min_post_time = (int) $row['topic_last_post_time'];

+ }

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

+

+ if (empty($topic_ids))

+ {

+ return false;

+ }

+

+ $sql_visibility = phpbb_content_visibility::get_visibility_sql('post', $this->forum_id, 'p.');

+

+ $this->sql = array(

+ 'SELECT' => 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_visibility, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ 'u.username, u.user_id',

+ 'FROM' => array(

+ POSTS_TABLE => 'p',

+ USERS_TABLE => 'u',

+ ),

+ 'WHERE' => $this->db->sql_in_set('p.topic_id', $topic_ids) . '

+ ' . (($sql_visibility) ? ' AND ' . $sql_visibility : '') . '

+ AND p.post_time >= ' . $min_post_time . '

+ AND p.poster_id = u.user_id',

+ 'ORDER_BY' => 'p.post_time DESC',

+ );

+

+ return true;

+ }

+

+ function adjust_item(&$item_row, &$row)

+ {

+ parent::adjust_item($item_row, $row);

+

+ $item_row['title'] = (isset($row['forum_name']) && $row['forum_name'] !== '') ? $row['forum_name'] . ' ' . $this->separator . ' ' . $item_row['title'] : $item_row['title'];

+ }

+

+ function get_item()

+ {

+ return ($row = parent::get_item()) ? array_merge($this->forum_data, $row) : $row;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* 'All Forums' feed

+*

+* This will give you a list of all postable forums where feeds are enabled

+* including forum description, topic stats and post stats

+*

+* @package phpBB3

+*/

+class phpbb_feed_forums extends phpbb_feed_base

+{

+ var $num_items = 0;

+

+ function set_keys()

+ {

+ $this->set('title', 'forum_name');

+ $this->set('text', 'forum_desc');

+ $this->set('bitfield', 'forum_desc_bitfield');

+ $this->set('bbcode_uid','forum_desc_uid');

+ $this->set('updated', 'forum_last_post_time');

+ $this->set('options', 'forum_desc_options');

+ }

+

+ function get_sql()

+ {

+ $in_fid_ary = array_diff($this->get_readable_forums(), $this->get_excluded_forums());

+ if (empty($in_fid_ary))

+ {

+ return false;

+ }

+

+ // Build SQL Query

+ $this->sql = array(

+ 'SELECT' => 'f.forum_id, f.left_id, f.forum_name, f.forum_last_post_time,

+ f.forum_desc, f.forum_desc_bitfield, f.forum_desc_uid, f.forum_desc_options,

+ f.forum_topics_approved, f.forum_posts_approved',

+ 'FROM' => array(FORUMS_TABLE => 'f'),

+ 'WHERE' => 'f.forum_type = ' . FORUM_POST . '

+ AND ' . $this->db->sql_in_set('f.forum_id', $in_fid_ary),

+ 'ORDER_BY' => 'f.left_id ASC',

+ );

+

+ return true;

+ }

+

+ function adjust_item(&$item_row, &$row)

+ {

+ $item_row['link'] = $this->helper->append_sid('viewforum.' . $this->phpEx, 'f=' . $row['forum_id']);

+

+ if ($this->config['feed_item_statistics'])

+ {

+ $item_row['statistics'] = $this->user->lang('TOTAL_TOPICS', (int) $row['forum_topics_approved'])

+ . ' ' . $this->separator_stats . ' ' . $this->user->lang('TOTAL_POSTS_COUNT', (int) $row['forum_posts_approved']);

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Class with some helpful functions used in feeds

+* @package phpBB3

+*/

+class phpbb_feed_helper

+{

+ /** @var phpbb_config */

+ protected $config;

+

+ /** @var phpbb_user */

+ protected $user;

+

+ /** @var string */

+ protected $phpbb_root_path;

+

+ /**

+ * Constructor

+ *

+ * @param phpbb_config $config Config object

+ * @param phpbb_user $user User object

+ * @param string $phpbb_root_path Root path

+ * @return null

+ */

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

+ {

+ $this->config = $config;

+ $this->user = $user;

+ $this->phpbb_root_path = $phpbb_root_path;

+ }

+

+ /**

+ * Run links through append_sid(), prepend generate_board_url() and remove session id

+ */

+ public function get_board_url()

+ {

+ static $board_url;

+

+ if (empty($board_url))

+ {

+ $board_url = generate_board_url();

+ }

+

+ return $board_url;

+ }

+

+ /**

+ * Run links through append_sid(), prepend generate_board_url() and remove session id

+ */

+ public function append_sid($url, $params)

+ {

+ return append_sid($this->get_board_url() . '/' . $url, $params, true, '');

+ }

+

+ /**

+ * Generate ISO 8601 date string (RFC 3339)

+ */

+ public function format_date($time)

+ {

+ static $zone_offset;

+ static $offset_string;

+

+ if (empty($offset_string))

+ {

+ $zone_offset = $this->user->create_datetime()->getOffset();

+ $offset_string = phpbb_format_timezone_offset($zone_offset);

+ }

+

+ return gmdate("Y-m-d\TH:i:s", $time + $zone_offset) . $offset_string;

+ }

+

+ /**

+ * Generate text content

+ */

+ public function generate_content($content, $uid, $bitfield, $options)

+ {

+ if (empty($content))

+ {

+ return '';

+ }

+

+ // Prepare some bbcodes for better parsing

+ $content = preg_replace("#\[quote(=&quot;.*?&quot;)?:$uid\]\s*(.*?)\s*\[/quote:$uid\]#si", "[quote$1:$uid]<br />$2<br />[/quote:$uid]", $content);

+

+ $content = generate_text_for_display($content, $uid, $bitfield, $options);

+

+ // Add newlines

+ $content = str_replace('<br />', '<br />' . "\n", $content);

+

+ // Convert smiley Relative paths to Absolute path, Windows style

+ $content = str_replace($this->phpbb_root_path . $this->config['smilies_path'], $this->get_board_url() . '/' . $this->config['smilies_path'], $content);

+

+ // Remove "Select all" link and mouse events

+ $content = str_replace('<a href="#" onclick="selectCode(this); return false;">' . $this->user->lang['SELECT_ALL_CODE'] . '</a>', '', $content);

+ $content = preg_replace('#(onkeypress|onclick)="(.*?)"#si', '', $content);

+

+ // Firefox does not support CSS for feeds, though

+

+ // Remove font sizes

+ // $content = preg_replace('#<span style="font-size: [0-9]+%; line-height: [0-9]+%;">([^>]+)</span>#iU', '\1', $content);

+

+ // Make text strong :P

+ // $content = preg_replace('#<span style="font-weight: bold?">(.*?)</span>#iU', '<strong>\1</strong>', $content);

+

+ // Italic

+ // $content = preg_replace('#<span style="font-style: italic?">([^<]+)</span>#iU', '<em>\1</em>', $content);

+

+ // Underline

+ // $content = preg_replace('#<span style="text-decoration: underline?">([^<]+)</span>#iU', '<u>\1</u>', $content);

+

+ // Remove embed Windows Media Streams

+ $content = preg_replace( '#<\!--\[if \!IE\]>-->([^[]+)<\!--<!\[endif\]-->#si', '', $content);

+

+ // Do not use &lt; and &gt;, because we want to retain code contained in [code][/code]

+

+ // Remove embed and objects

+ $content = preg_replace( '#<(object|embed)(.*?) (value|src)=(.*?) ([^[]+)(object|embed)>#si',' <a href=$4 target="_blank"><strong>$1</strong></a> ',$content);

+

+ // Remove some specials html tag, because somewhere there are a mod to allow html tags ;)

+ $content = preg_replace( '#<(script|iframe)([^[]+)\1>#siU', ' <strong>$1</strong> ', $content);

+

+ // Remove Comments from inline attachments [ia]

+ $content = preg_replace('#<div class="(inline-attachment|attachtitle)">(.*?)<!-- ia(.*?) -->(.*?)<!-- ia(.*?) -->(.*?)</div>#si','$4',$content);

+

+ // Replace some entities with their unicode counterpart

+ $entities = array(

+ '&nbsp;' => "\xC2\xA0",

+ '&bull;' => "\xE2\x80\xA2",

+ '&middot;' => "\xC2\xB7",

+ '&copy;' => "\xC2\xA9",

+ );

+

+ $content = str_replace(array_keys($entities), array_values($entities), $content);

+

+ // Remove CDATA blocks. ;)

+ $content = preg_replace('#\<\!\[CDATA\[(.*?)\]\]\>#s', '', $content);

+

+ // Other control characters

+ $content = preg_replace('#(?:[\x00-\x1F\x7F]+|(?:\xC2[\x80-\x9F])+)#', '', $content);

+

+ return $content;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* News feed

+*

+* This will give you {$this->num_items} first posts

+* of all topics in the selected news forums.

+*

+* @package phpBB3

+*/

+class phpbb_feed_news extends phpbb_feed_topic_base

+{

+ function get_news_forums()

+ {

+ static $forum_ids;

+

+ // Matches acp/acp_board.php

+ $cache_name = 'feed_news_forum_ids';

+

+ if (!isset($forum_ids) && ($forum_ids = $this->cache->get('_' . $cache_name)) === false)

+ {

+ $sql = 'SELECT forum_id

+ FROM ' . FORUMS_TABLE . '

+ WHERE ' . $this->db->sql_bit_and('forum_options', FORUM_OPTION_FEED_NEWS, '<> 0');

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

+

+ $forum_ids = array();

+ while ($forum_id = (int) $this->db->sql_fetchfield('forum_id'))

+ {

+ $forum_ids[$forum_id] = $forum_id;

+ }

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

+

+ $this->cache->put('_' . $cache_name, $forum_ids);

+ }

+

+ return $forum_ids;

+ }

+

+ function get_sql()

+ {

+ // Determine forum ids

+ $in_fid_ary = array_intersect($this->get_news_forums(), $this->get_readable_forums());

+ if (empty($in_fid_ary))

+ {

+ return false;

+ }

+

+ $in_fid_ary = array_diff($in_fid_ary, $this->get_passworded_forums());

+ if (empty($in_fid_ary))

+ {

+ return false;

+ }

+

+ // We really have to get the post ids first!

+ $sql = 'SELECT topic_first_post_id, topic_time

+ FROM ' . TOPICS_TABLE . '

+ WHERE ' . $this->db->sql_in_set('forum_id', $in_fid_ary) . '

+ AND topic_moved_id = 0

+ AND topic_visibility = ' . ITEM_APPROVED . '

+ ORDER BY topic_time DESC';

+ $result = $this->db->sql_query_limit($sql, $this->num_items);

+

+ $post_ids = array();

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

+ {

+ $post_ids[] = (int) $row['topic_first_post_id'];

+ }

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

+

+ if (empty($post_ids))

+ {

+ return false;

+ }

+

+ $this->sql = array(

+ 'SELECT' => 'f.forum_id, f.forum_name,

+ t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_posts_approved, t.topic_posts_unapproved, t.topic_posts_softdeleted, t.topic_views, t.topic_time, t.topic_last_post_time,

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url',

+ 'FROM' => array(

+ TOPICS_TABLE => 't',

+ POSTS_TABLE => 'p',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(FORUMS_TABLE => 'f'),

+ 'ON' => 'p.forum_id = f.forum_id',

+ ),

+ ),

+ 'WHERE' => 'p.topic_id = t.topic_id

+ AND ' . $this->db->sql_in_set('p.post_id', $post_ids),

+ 'ORDER_BY' => 'p.post_time DESC',

+ );

+

+ return true;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Board wide feed (aka overall feed)

+*

+* This will give you the newest {$this->num_items} posts

+* from the whole board.

+*

+* @package phpBB3

+*/

+class phpbb_feed_overall extends phpbb_feed_post_base

+{

+ function get_sql()

+ {

+ $forum_ids = array_diff($this->get_readable_forums(), $this->get_excluded_forums(), $this->get_passworded_forums());

+ if (empty($forum_ids))

+ {

+ return false;

+ }

+

+ // Determine topics with recent activity

+ $sql = 'SELECT topic_id, topic_last_post_time

+ FROM ' . TOPICS_TABLE . '

+ WHERE topic_moved_id = 0

+ AND ' . phpbb_content_visibility::get_forums_visibility_sql('topic', $forum_ids) . '

+ ORDER BY topic_last_post_time DESC';

+ $result = $this->db->sql_query_limit($sql, $this->num_items);

+

+ $topic_ids = array();

+ $min_post_time = 0;

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

+ {

+ $topic_ids[] = (int) $row['topic_id'];

+

+ $min_post_time = (int) $row['topic_last_post_time'];

+ }

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

+

+ if (empty($topic_ids))

+ {

+ return false;

+ }

+

+ $sql_visibility = phpbb_content_visibility::get_visibility_sql('post', array(), 'p.');

+

+ // Get the actual data

+ $this->sql = array(

+ 'SELECT' => 'f.forum_id, f.forum_name, ' .

+ 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_visibility, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ 'u.username, u.user_id',

+ 'FROM' => array(

+ USERS_TABLE => 'u',

+ POSTS_TABLE => 'p',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(FORUMS_TABLE => 'f'),

+ 'ON' => 'f.forum_id = p.forum_id',

+ ),

+ ),

+ 'WHERE' => $this->db->sql_in_set('p.topic_id', $topic_ids) . '

+ ' . (($sql_visibility) ? ' AND ' . $sql_visibility : '') . '

+ AND p.post_time >= ' . $min_post_time . '

+ AND u.user_id = p.poster_id',

+ 'ORDER_BY' => 'p.post_time DESC',

+ );

+

+ return true;

+ }

+

+ function adjust_item(&$item_row, &$row)

+ {

+ parent::adjust_item($item_row, $row);

+

+ $item_row['title'] = (isset($row['forum_name']) && $row['forum_name'] !== '') ? $row['forum_name'] . ' ' . $this->separator . ' ' . $item_row['title'] : $item_row['title'];

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Abstract class for post based feeds

+*

+* @package phpBB3

+*/

+abstract class phpbb_feed_post_base extends phpbb_feed_base

+{

+ var $num_items = 'feed_limit_post';

+

+ function set_keys()

+ {

+ $this->set('title', 'post_subject');

+ $this->set('title2', 'topic_title');

+

+ $this->set('author_id', 'user_id');

+ $this->set('creator', 'username');

+ $this->set('published', 'post_time');

+ $this->set('updated', 'post_edit_time');

+ $this->set('text', 'post_text');

+

+ $this->set('bitfield', 'bbcode_bitfield');

+ $this->set('bbcode_uid','bbcode_uid');

+

+ $this->set('enable_bbcode', 'enable_bbcode');

+ $this->set('enable_smilies', 'enable_smilies');

+ $this->set('enable_magic_url', 'enable_magic_url');

+ }

+

+ function adjust_item(&$item_row, &$row)

+ {

+ $item_row['link'] = $this->helper->append_sid('viewtopic.' . $this->phpEx, "t={$row['topic_id']}&amp;p={$row['post_id']}#p{$row['post_id']}");

+

+ if ($this->config['feed_item_statistics'])

+ {

+ $item_row['statistics'] = $this->user->lang['POSTED'] . ' ' . $this->user->lang['POST_BY_AUTHOR'] . ' ' . $this->user_viewprofile($row)

+ . ' ' . $this->separator_stats . ' ' . $this->user->format_date($row[$this->get('published')])

+ . (($this->is_moderator_approve_forum($row['forum_id']) && $row['post_visibility'] !== ITEM_APPROVED) ? ' ' . $this->separator_stats . ' ' . $this->user->lang['POST_UNAPPROVED'] : '');

+ }

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Topic feed for a specific topic

+*

+* This will give you the last {$this->num_items} posts made within this topic.

+*

+* @package phpBB3

+*/

+class phpbb_feed_topic extends phpbb_feed_post_base

+{

+ var $topic_id = 0;

+ var $forum_id = 0;

+ var $topic_data = array();

+

+ /**

+ * Set the Topic ID

+ *

+ * @param int $topic_id Topic ID

+ * @return phpbb_feed_topic

+ */

+ public function set_topic_id($topic_id)

+ {

+ $this->topic_id = (int) $topic_id;

+

+ return $this;

+ }

+

+ function open()

+ {

+ $sql = 'SELECT f.forum_options, f.forum_password, t.topic_id, t.forum_id, t.topic_visibility, t.topic_title, t.topic_time, t.topic_views, t.topic_replies, t.topic_type

+ FROM ' . TOPICS_TABLE . ' t

+ LEFT JOIN ' . FORUMS_TABLE . ' f

+ ON (f.forum_id = t.forum_id)

+ WHERE t.topic_id = ' . $this->topic_id;

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

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

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

+

+ if (empty($this->topic_data))

+ {

+ trigger_error('NO_TOPIC');

+ }

+

+ $this->forum_id = (int) $this->topic_data['forum_id'];

+

+ // Make sure topic is either approved or user authed

+ if (!$this->topic_data['topic_approved'] && !$this->auth->acl_get('m_approve', $this->forum_id))

+ {

+ trigger_error('SORRY_AUTH_READ');

+ }

+

+ // Make sure forum is not excluded from feed

+ if (phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $this->topic_data['forum_options']))

+ {

+ trigger_error('NO_FEED');

+ }

+

+ // Make sure we can read this forum

+ if (!$this->auth->acl_get('f_read', $this->forum_id))

+ {

+ trigger_error('SORRY_AUTH_READ');

+ }

+

+ // Make sure forum is not passworded or user is authed

+ if ($this->topic_data['forum_password'])

+ {

+ $forum_ids_passworded = $this->get_passworded_forums();

+

+ if (isset($forum_ids_passworded[$this->forum_id]))

+ {

+ trigger_error('SORRY_AUTH_READ');

+ }

+

+ unset($forum_ids_passworded);

+ }

+ }

+

+ function get_sql()

+ {

+ $sql_visibility = phpbb_content_visibility::get_visibility_sql('post', $this->forum_id, 'p.');

+

+ $this->sql = array(

+ 'SELECT' => 'p.post_id, p.post_time, p.post_edit_time, p.post_visibility, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ 'u.username, u.user_id',

+ 'FROM' => array(

+ POSTS_TABLE => 'p',

+ USERS_TABLE => 'u',

+ ),

+ 'WHERE' => 'p.topic_id = ' . $this->topic_id . '

+ ' . (($sql_visibility) ? ' AND ' . $sql_visibility : '') . '

+ AND p.poster_id = u.user_id',

+ 'ORDER_BY' => 'p.post_time DESC',

+ );

+

+ return true;

+ }

+

+ function get_item()

+ {

+ return ($row = parent::get_item()) ? array_merge($this->topic_data, $row) : $row;

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2013 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+/**

+* Abstract class for topic based feeds

+*

+* @package phpBB3

+*/

+abstract class phpbb_feed_topic_base extends phpbb_feed_base

+{

+ var $num_items = 'feed_limit_topic';

+

+ function set_keys()

+ {

+ $this->set('title', 'topic_title');

+ $this->set('title2', 'forum_name');

+

+ $this->set('author_id', 'topic_poster');

+ $this->set('creator', 'topic_first_poster_name');

+ $this->set('published', 'post_time');

+ $this->set('updated', 'post_edit_time');

+ $this->set('text', 'post_text');

+