<project name="phpBB" description="The phpBB forum software" default="all" basedir="../">

<!-- a few settings for the build -->

<!-- no configuration should be needed beyond this point -->

<property name="oldversions" value="${olderversions}, ${prevversion}" />

<dl>

<dt><label>{L_AVATAR_TYPE}{L_COLON}</label></dt>

<dd><select name="avatar_driver" id="avatar_driver" data-togglable-settings="true">

<!-- BEGIN avatar_drivers -->

<option value="{avatar_drivers.DRIVER}"<!-- IF avatar_drivers.SELECTED --> selected="selected"<!-- ENDIF --> data-toggle-setting="#avatar_option_{avatar_drivers.DRIVER}">{avatar_drivers.L_TITLE}</option>

<!-- END avatar_drivers -->

<dl>

<dt><label>{L_AVATAR_TYPE}</label></dt>

<dd><select name="avatar_driver" id="avatar_driver" data-togglable-settings="true">

<!-- BEGIN avatar_drivers -->

<option value="{avatar_drivers.DRIVER}"<!-- IF avatar_drivers.SELECTED --> selected="selected"<!-- ENDIF --> data-toggle-setting="#avatar_option_{avatar_drivers.DRIVER}">{avatar_drivers.L_TITLE}</option>

<!-- END avatar_drivers -->

- @passwords.manager

- @request

- @user

- %core.root_path%

- %core.php_ext%

tags:

- %tables.auth_provider_oauth_account_assoc%

- @auth.provider.oauth.service_collection

- %tables.users%

- %core.root_path%

- %core.php_ext%

tags:

- { resource: mimetype_guessers.yml }

- { resource: passwords.yml }

- { resource: profilefields.yml }

services:

acl.permissions:

user:

class: phpbb\user

user_loader:

class: phpbb\user_loader

<ol>

<li><a href="#changelog">Changelog</a>

<ol style="list-style-type: lower-roman;">

<li><a href="#v310b3">Changes since 3.1.0-b3</a></li>

<li><a href="#v310b2">Changes since 3.1.0-b2</a></li>

<li><a href="#v310b1">Changes since 3.1.0-b1</a></li>

<div class="content">

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-12829">PHPBB3-12829</a>] - Remove check for pgsql 8.3/8.2</li>

</ul>

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-12302">PHPBB3-12302</a>] - Upgrade composer.phar to 1.0.0-alpha8</li>

</ul>

<h4>Bug</h4>

<ul>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-12147">PHPBB3-12147</a>] - Remove Travis CI notification configuration</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11998">PHPBB3-11998</a>] - Add console / command line client environment </li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11913">PHPBB3-11913</a>] - Apply reorganisation of download.phpbb.com to build_announcement.php</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-11753">PHPBB3-11753</a>] - Upgrade mysql_upgrader.php schema data.</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10909">PHPBB3-10909</a>] - Update Travis Test Configuration: Travis no longer supports PHP 5.3.2</li>

</ul>

<h4>Bug</h4>

<ul>

<li>[<a href="http://tracker.phpbb.com/browse/PHPBB3-10480">PHPBB3-10480</a>] - Automate changelog building</li>

</ul>

<h4> Bug

</h4>

</ul>

<h4> Security

</h4>

<ul>

</ul>

<ul>

<li>[Sec] Do not expose forum content of forums with ACL entries but no actual permission in ATOM Feeds. (Bug #58595)</li>

</ul>

<ul>

<li>[Fix] Allow ban reason and length to be selected and copied in ACP and subsilver2 MCP. (Bug #51095)</li>

</ul>

<ul>

<li>[Fix] Allow whitespaces in avatar gallery names. (Bug #44955)</li>

<li>[Feature] Send anonymous statistical information to phpBB on installation and update (optional).</li>

</ul>

<ul>

<li>[Fix] Delete user entry from ban list table upon user deletion (Bug #40015 - Patch by TerraFrost)</li>

<li>[Sec] Only use forum id supplied for posting if global announcement detected. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Allow mixed-case template directories to be inherited (Bug #36725)</li>

<li>[Sec] Ask for forum password if post within passworded forum quoted in private message. (Reported by nickvergessen)</li>

</ul>

<ul>

<li>[Fix] Correctly set topic starter if first post in topic removed (Bug #30575 - Patch by blueray2048)</li>

<li>[Sec Precaution] Stricter validation of the HTTP_HOST header (Thanks to Techie-Micheal et al for pointing out possible issues in derived code)</li>

</ul>

<ul>

<li>[Fix] Ability to set permissions on non-mysql dbms (Bug #24955)</li>

<li>[Sec] Only allow urls gone through redirect() being used within login_box(). (thanks nookieman)</li>

</ul>

<ul>

<li>[Change] Validate birthdays (Bug #15004)</li>

<li>[Fix] Find and display colliding usernames correctly when converting from one database to another (Bug #23925)</li>

</ul>

<ul>

<li>[Fix] Cleaned usernames contain only single spaces, so &quot;a_name&quot; and &quot;a__name&quot; are treated as the same name (Bug #15634)</li>

<li>[Fix] Call garbage_collection() within database updater to correctly close connections (affects Oracle for example)</li>

</ul>

<ul>

<li>[Fix] Fixed MSSQL related bug in the update system</li>

<li>[Fix] No duplication of active topics (Bug #15474)</li>

</ul>

<ul>

<li>[Fix] Submitting language changes using acp_language (Bug #14736)</li>

<li>[Fix] Able to request new password (Bug #14743)</li>

</ul>

<ul>

<li>[Feature] Removing constant PHPBB_EMBEDDED in favor of using an exit_handler(); the constant was meant to achive this more or less.</li>

<li>[Sec] New password hashing mechanism for storing passwords (#i42)</li>

</ul>

<ul>

<li>[Fix] MySQL, PostgreSQL and SQLite related database fixes (Bug #13862)</li>

<li>[Fix] odbc_autocommit causing existing result sets to be dropped (Bug #14182)</li>

</ul>

<ul>

<li>[Fix] Fixing some subsilver2 and prosilver style issues</li>

</ul>

<ul>

<li>[Fix] Re-allow searching within the memberlist</li>

</ul>

<ul>

<li>[Fix] (X)HTML issues within the templates (Bug #11255, #11255)</li>

include($phpbb_root_path . 'common.' . $phpEx);

require($phpbb_root_path . 'includes/functions_download' . '.' . $phpEx);

$mode = request_var('mode', '');

$thumbnail = request_var('t', false);

trigger_error('ATTACHMENT_FUNCTIONALITY_DISABLED');

}

{

send_status_line(404, 'Not Found');

trigger_error('NO_ATTACHMENT_SELECTED');

$sql = 'SELECT attach_id, post_msg_id, topic_id, in_message, poster_id, is_orphan, physical_filename, real_filename, extension, mimetype, filesize, filetime

FROM ' . ATTACHMENTS_TABLE . "

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

$db->sql_freeresult($result);

{

send_status_line(404, 'Not Found');

trigger_error('ERROR_NO_ATTACHMENT');

send_status_line(403, 'Forbidden');

trigger_error($user->lang['LINKAGE_FORBIDDEN']);

}

{

if (!$attachment['in_message'] && !$config['allow_attachments'] || $attachment['in_message'] && !$config['allow_pm_attach'])

{

else

{

// Attachment is in a private message.

phpbb_download_handle_pm_auth($db, $auth, $user->data['user_id'], $attachment['post_msg_id']);

}

$extensions = array();

{

send_status_line(403, 'Forbidden');

trigger_error(sprintf($user->lang['EXTENSION_DISABLED_AFTER_POSTING'], $attachment['extension']));

}

}

}

function main($id, $mode)

{

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

$user->add_lang('acp/board');

$captchas = $factory->get_captcha_types();

$selected = request_var('select_captcha', $config['captcha_plugin']);

// Delegate

if ($configure)

{

$config_captcha->acp_page($id, $this);

}

else

// sanity check

if (isset($captchas['available'][$selected]))

{

$old_captcha->uninstall();

set_config('captcha_plugin', $selected);

$new_captcha->install();

add_log('admin', 'LOG_CONFIG_VISUAL');

$captcha_select .= '<option value="' . $value . '"' . $current . ' class="disabled-option">' . $user->lang($title) . '</option>';

}

foreach ($config_vars as $config_var => $options)

{

*/

function deliver_demo($selected)

{

$captcha->init(CONFIRM_REG);

$captcha->execute_demo();

}

}

// Did we submit?

if ($update)

{

if ($config['require_activation'] == USER_ACTIVATION_ADMIN)

{

$phpbb_notifications = $phpbb_container->get('notification_manager');

include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

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

}

// Delete old avatar if present

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

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

add_log('user', $user_id, 'LOG_USER_DEL_AVATAR_USER');

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

}

}

}

else

{

}

}

$selected_driver = $phpbb_avatar_manager->clean_driver_name($request->variable('avatar_driver', $user_row['user_avatar_type']));

foreach ($avatar_drivers as $current_driver)

*/

// phpBB Version

// QA-related

// define('PHPBB_QA', 1);

* @param array $allowed_units only allow these units (data array indexes)

*

* @return mixed data array if $string_only is false

*/

function get_formatted_filesize($value, $string_only = true, $allowed_units = false)

{

* @param int $perms Permissions to set

*

* @return bool true on success, otherwise false

*/

function phpbb_chmod($filename, $perms = CHMOD_READ)

{

foreach ($unsorted_timezones as $timezone)

{

$tz = new DateTimeZone($timezone);

$offset = $dt->getOffset();

$current_time = $dt->format($user->lang['DATETIME_FORMAT'], true);

$offset_string = phpbb_format_timezone_offset($offset);

// Mark all topic notifications read for this user

$phpbb_notifications->mark_notifications_read(array(

), false, $user->data['user_id'], $post_time);

if ($config['load_db_lastread'] && $user->data['is_registered'])

$phpbb_notifications = $phpbb_container->get('notification_manager');

$phpbb_notifications->mark_notifications_read_by_parent(array(

), $forum_id, $user->data['user_id'], $post_time);

// Mark all post/quote notifications read for this user in this forum

$db->sql_freeresult($result);

$phpbb_notifications->mark_notifications_read_by_parent(array(

), $topic_ids, $user->data['user_id'], $post_time);

// Add 0 to forums array to mark global announcements correctly

// Mark post notifications read for this user in this topic

$phpbb_notifications->mark_notifications_read(array(

), $topic_id, $user->data['user_id'], $post_time);

$phpbb_notifications->mark_notifications_read_by_parent(array(

), $topic_id, $user->data['user_id'], $post_time);

if ($config['load_db_lastread'] && $user->data['is_registered'])

*/

function add_form_key($form_name)

{

$now = time();

$token_sid = ($user->data['user_id'] == ANONYMOUS && !empty($config['form_token_sid_guests'])) ? $user->session_id : '';

'form_token' => $token,

));

$template->assign_vars(array(

'S_FORM_TOKEN' => $s_fields,

));

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

global $request, $phpbb_container;

$err = '';

// Make sure user->setup() has been called

{

case LOGIN_ERROR_ATTEMPTS:

$captcha->init(CONFIRM_LOGIN);

// $captcha->reset();

*/

function login_forum_box($forum_data)

{

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

$template->assign_var('LOGIN_ERROR', $user->lang['WRONG_PASSWORD']);

}

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

$template->assign_vars(array(

*

* @return mixed false if specified address is not valid,

* string otherwise

*/

function phpbb_ip_normalise($address)

{

*

* @return mixed false on failure,

* string otherwise

*/

function phpbb_inet_ntop($in_addr)

{

*

* @return mixed false if address is invalid,

* in_addr representation of the given address otherwise (string)

*/

function phpbb_inet_pton($address)

{

*

* Since null can also be returned, you probably want to compare the result

* with === true or === false,

*/

function phpbb_checkdnsrr($host, $type = 'MX')

{

/**

* Get avatar

*

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

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

*

}

}

$timezone_offset = 'GMT' . phpbb_format_timezone_offset($dt->getOffset());

$timezone_name = $user->timezone->getName();

if (isset($user->lang['timezones'][$timezone_name]))

'SITE_LOGO_IMG' => $user->img('site_logo'),

));

/**

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

*

* session item, e.g. forum for

* session_forum_id

* @var int item_id Restrict online users to item id

*

* @since 3.1.0-b3

*/

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

{

}

return;

* @param \phpbb\config\config $config Config object

* @param \phpbb\auth\auth $auth Auth object

* @param \phpbb\user $user User object

* @return string

*/

{

$debug_info = array();

}

}

return implode(' | ', $debug_info);

}

phpbb_check_and_display_sql_report($request, $auth, $db);

$template->assign_vars(array(

'TRANSLATION_INFO' => (!empty($user->lang['TRANSLATION_INFO'])) ? $user->lang['TRANSLATION_INFO'] : '',

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

'S_CONTENT_FLOW_END' => ($user->lang['DIRECTION'] == 'ltr') ? 'right' : 'left',

));

return;

}

phpbb_check_and_display_sql_report($request, $auth, $db);

$template->assign_vars(array(

'TRANSLATION_INFO' => (!empty($user->lang['TRANSLATION_INFO'])) ? $user->lang['TRANSLATION_INFO'] : '',

'S_COPYRIGHT_HTML' => $copyright_html,

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

* @param string $table constant or fullname of the table

* @param int $parent_id parent_id of the current set (default = 0)

* @param array $where contains strings to compare closer on the where statement (additional)

*/

function recalc_nested_sets(&$new_id, $pkey, $table, $parent_id = 0, $where = array())

{

* @param bool $add_log True if log entry should be added

*

* @return bool False on error

*/

function copy_forum_permissions($src_forum_id, $dest_forum_ids, $clear_dest_perms = true, $add_log = true)

{

$phpbb_notifications = $phpbb_container->get('notification_manager');

$phpbb_notifications->delete_notifications(array(

), $topic_ids);

return $return;

// Notifications types to delete

$delete_notifications_types = array(

);

/**

* @param bool $auto_sync Will call sync() if this is true

*

* @return array Array with affected forums

*/

function delete_topic_shadows($forum_id, $sql_more = '', $auto_sync = true)

{

* @param string $custom_profile_url optional parameter to specify a profile url. The user id get appended to this url as &amp;u={user_id}

*

* @return string A string consisting of what is wanted based on $mode.

*/

function get_username_string($mode, $user_id, $username, $username_colour = '', $guest_username = false, $custom_profile_url = false)

{

}

/**

* Prepare profile data

*/

function phpbb_show_profile($data, $user_notes_enabled = false, $warn_user_enabled = false)

}

/**

* Check if the browser is internet explorer version 7+

*

* @param string $user_agent User agent HTTP header

*/

function generate_message_id()

{

return md5(unique_id(time())) . '@' . $domain;

}

{

case 'post':

$phpbb_notifications->add_notifications(array(

), $notification_data);

break;

case 'reply':

case 'quote':

$phpbb_notifications->add_notifications(array(

), $notification_data);

break;

case 'edit':

case 'edit_last_post':

$phpbb_notifications->update_notifications(array(

), $notification_data);

break;

}

switch ($mode)

{

case 'post':

break;

case 'reply':

case 'quote':

break;

case 'edit_topic':

{

case 'edit_topic':

case 'edit_first_post':

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

// when his post got reapproved

break;

case 'edit':

case 'edit_last_post':

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

// when his post got reapproved

break;

case 'post':

$phpbb_notifications = $phpbb_container->get('notification_manager');

$sql = 'UPDATE ' . PRIVMSGS_TO_TABLE . "

SET pm_unread = 0

$phpbb_notifications = $phpbb_container->get('notification_manager');

// Now we have to check which messages we can delete completely

$sql = 'SELECT msg_id

AND ' . $db->sql_in_set('msg_id', $delivered_msg);

$db->sql_query($sql);

}

if (!empty($undelivered_msg))

WHERE ' . $db->sql_in_set('msg_id', $undelivered_msg);

$db->sql_query($sql);

}

}

WHERE ' . $db->sql_in_set('msg_id', $delete_ids);

$db->sql_query($sql);

}

}

if ($mode == 'edit')

{

}

else

{

}

/**

/**

* FTP fsock transfer class

*/

class ftp_fsock extends transfer

{

foreach ($add_id_ary as $user_id)

{

'group_id' => $group_id,

'user_id' => $user_id,

'group_name' => $group_name,

$phpbb_notifications = $phpbb_container->get('notification_manager');

// Return false - no error

return false;

$phpbb_notifications = $phpbb_container->get('notification_manager');

'user_ids' => $user_id_ary,

'group_id' => $group_id,

'group_name' => $group_name,

));

$log = 'LOG_USERS_APPROVED';

break;

$phpbb_notifications = $phpbb_container->get('notification_manager');

$pm_id = $report['pm_id'];

$report_id = $report['report_id'];

{

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

global $config, $phpbb_root_path, $phpEx, $action, $phpbb_container;

include_once($phpbb_root_path . 'includes/functions_posting.' . $phpEx);

{

$post_id = (int) $topic_info[$topic_id]['topic_first_post_id'];

}

else

{

}

}

$post_info = phpbb_get_post_data(array($post_id), 'm_approve', true);

// A single topic approval may also happen here, so handle deleting the respective notification.

if (!$post_data['topic_posts_approved'])

{

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

{

}

if ($post_data['post_visibility'] != ITEM_APPROVED)

{

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

{

$phpbb_notifications->add_notifications(array(

), $post_data);

}

}

$phpbb_notifications->mark_notifications_read(array(

), $post_data['post_id'], $user->data['user_id']);

// Notify Poster?

if (!$post_data['topic_posts_approved'])

{

}

else

{

}

}

}

'post_username' => $topic_data['topic_first_poster_name'],

));

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

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

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

{

$phpbb_notifications->add_notifications(array(

), $topic_data);

}

if ($notify_poster)

{

}

}

}

$topic_information[$topic_id]['topic_posts_softdeleted'] == 0 &&

$topic_information[$topic_id]['topic_posts_unapproved'] == $topic_posts_unapproved[$topic_id];

// Do we disapprove the whole topic? Remove potential notifications

if ($disapprove_all_posts_in_topic)

{

}

// Notify Poster?

{

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

// we send the user a "disapprove topic" notification...

}

else

{

// ... otherwise there are multiple unapproved posts and

// all of them are disapproved as posts.

}

}

}

$phpbb_notifications = $phpbb_container->get('notification_manager');

if (!$report_id && $report['report_closed'])

{

if ($pm)

{

add_log('mod', 0, 0, 'LOG_PM_REPORT_' . strtoupper($action) . 'D', $post_info[$report['pm_id']]['message_subject']);

}

else

{

add_log('mod', $post_info[$report['post_id']]['forum_id'], $post_info[$report['post_id']]['topic_id'], 'LOG_REPORT_' . strtoupper($action) . 'D', $post_info[$report['post_id']]['post_subject']);

}

}

if ($pm)

{

'reporter' => $reporter['user_id'],

'closer_id' => $user->data['user_id'],

'from_user_id' => $post_info[$post_id]['author_id'],

}

else

{

'reporter' => $reporter['user_id'],

'closer_id' => $user->data['user_id'],

)));

$message_parser = new parse_message();

$message_parser->parse(true, true, true, false, false, true, true);

$pm_data = array(

'address_list' => array('u' => array($user_row['user_id'] => 'to')),

);

}

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

if ($config['require_activation'] == USER_ACTIVATION_ADMIN && !$update_password)

{

$phpbb_notifications = $phpbb_container->get('notification_manager');

include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

function main($id, $mode)

{

$captcha->init(request_var('type', 0));

$captcha->execute();

$avatar_data = \phpbb\avatar\manager::clean_row($group_row, 'group');

}

// Did we submit?

if ($update)

{

$submit_ary = array_merge($submit_ary, $result);

}

}

// Merge any avatars errors into the primary error array

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

*/

protected function process_login_result($result)

{

$login_error = null;

{

case LOGIN_ERROR_ATTEMPTS:

$captcha->init(CONFIRM_LOGIN);

$template->assign_vars(array(

{

foreach($notification_methods as $method => $method_data)

{

{

$phpbb_notifications->add_subscription($type, 0, $method_data['id']);

}

{

$phpbb_notifications->delete_subscription($type, 0, $method_data['id']);

}

}

{

$phpbb_notifications->add_subscription($type);

}

{

$phpbb_notifications->delete_subscription($type);

}

'U_PM_ACTION' => $url . '&amp;mode=compose&amp;f=' . $folder_id . '&amp;p=' . $message_row['msg_id'],

'S_HAS_ATTACHMENTS' => (sizeof($attachments)) ? true : false,

'S_DISPLAY_NOTICE' => $display_notice && $message_row['message_attachment'],

'S_AUTHOR_DELETED' => ($author_id == ANONYMOUS) ? true : false,

'S_SPECIAL_FOLDER' => in_array($folder_id, array(PRIVMSGS_NO_BOX, PRIVMSGS_OUTBOX)),

// Display not already displayed Attachments for this post, we already parsed them. ;)

if (isset($attachments) && sizeof($attachments))

{

foreach ($attachments as $attachment)

{

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

trigger_error($message);

}

}

}

else

{

}

}

$selected_driver = $phpbb_avatar_manager->clean_driver_name($request->variable('avatar_driver', $user->data['user_avatar_type']));

foreach ($avatar_drivers as $current_driver)

// The CAPTCHA kicks in here. We can't help that the information gets lost on language change.

if ($config['enable_confirm'])

{

$captcha->init(CONFIRM_REG);

}

if ($config['require_activation'] == USER_ACTIVATION_ADMIN)

{

$phpbb_notifications = $phpbb_container->get('notification_manager');

'user_id' => $user_id,

'user_actkey' => $user_row['user_actkey'],

'user_regdate' => $user_row['user_regdate'],

$convertor_data = array(

'forum_name' => 'phpBB 2.0.x',

'version' => '1.0.3',

'author' => '<a href="https://www.phpbb.com/">phpBB Limited</a>',

'dbms' => $dbms,

'dbhost' => $dbhost,

// Set PHP error handler to ours

set_error_handler(defined('PHPBB_MSG_HANDLER') ? PHPBB_MSG_HANDLER : 'msg_handler');

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

// Add own hook handler, if present. :o

if (@extension_loaded('gd'))

{

$sql_ary[] = 'UPDATE ' . $data['table_prefix'] . "config

WHERE config_name = 'captcha_plugin'";

$sql_ary[] = 'UPDATE ' . $data['table_prefix'] . "config

"UINT",

0

],

""

],

""

],

"pf_phpbb_facebook": [

"VCHAR",

""

],

""

],

""

],

"VCHAR",

""

],

"VCHAR",

""

],

"VCHAR",

""

],

"pf_phpbb_aol": [

"VCHAR",

""

0

],

"topic_first_poster_name": [

],

"topic_first_poster_colour": [

"VCHAR:6",

INSERT INTO phpbb_config (config_name, config_value) VALUES ('bump_interval', '10');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('bump_type', 'd');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cache_gc', '7200');

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

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd_x_grid', '25');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_icons_path', 'images/upload_icons');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_path', 'files');

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_expire_days', '90');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_gc', '14400');

INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_on_ml, field_show_profile, field_hide, field_no_view, field_active, field_order, field_is_contact, field_contact_desc, field_contact_url) VALUES ('phpbb_googleplus', 'profilefields.type.googleplus', 'phpbb_googleplus', '20', '3', '255', '', '', '[\w]+', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 13, 1, 'VIEW_GOOGLEPLUS_PROFILE', 'http://plus.google.com/%s');

# User Notification Options (for first user)

# POSTGRES COMMIT #

'CLI_EXTENSION_PURGE_FAILURE' => 'Could not purge extension %s',

'CLI_EXTENSION_PURGE_SUCCESS' => 'Successfully purged extension %s',

'CLI_EXTENSION_NOT_FOUND' => 'No extensions were found.',

'CLI_FIXUP_RECALCULATE_EMAIL_HASH_SUCCESS' => 'Successfully recalculated all email hashes.',

));

'CONFIRM_CODE_EXPLAIN' => 'Enter the code exactly as it appears. All letters are case insensitive.',

'CONFIRM_CODE_WRONG' => 'The confirmation code you entered was incorrect.',

'CONFIRM_OPERATION' => 'Are you sure you wish to carry out this operation?',

'CONGRATULATIONS' => 'Congratulations to',

'CONNECTION_FAILED' => 'Connection failed.',

'CONNECTION_SUCCESS' => 'Connection was successful!',

'DISPLAY_MESSAGES' => 'Display messages from previous',

'DISPLAY_POSTS' => 'Display posts from previous',

'DISPLAY_TOPICS' => 'Display topics from previous',

'DOWNLOADED' => 'Downloaded',

'DOWNLOADING_FILE' => 'Downloading file',

'DOWNLOAD_COUNTS' => array(

'NO_AUTH_ADMIN_USER_DIFFER' => 'You are not able to re-authenticate as a different user.',

'NO_AUTH_OPERATION' => 'You do not have the necessary permissions to complete this operation.',

'NO_AVATARS' => 'No avatars currently available',

'NO_CONNECT_TO_SMTP_HOST' => 'Could not connect to smtp host : %1$s : %2$s',

'NO_BIRTHDAYS' => 'No birthdays today',

'NO_EMAIL_MESSAGE' => 'Email message was blank.',

protected $passwords_manager;

/**

* Database Authentication Constructor

*

* @param \phpbb\db\driver\driver_interface $db

* @param \phpbb\passwords\manager $passwords_manager

* @param \phpbb\request\request $request

* @param \phpbb\user $user

* @param string $phpbb_root_path

* @param string $php_ext

*/

{

$this->db = $db;

$this->config = $config;

$this->user = $user;

$this->phpbb_root_path = $phpbb_root_path;

$this->php_ext = $php_ext;

}

/**

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

if ($show_captcha)

{

$captcha->init(CONFIRM_LOGIN);

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

if ($vc_response)

protected $current_uri;

/**

* phpBB root path

*

* @var string

* @param string $auth_provider_oauth_token_account_assoc

* @param \phpbb\di\service_collection $service_providers Contains \phpbb\auth\provider\oauth\service_interface

* @param string $users_table

* @param string $phpbb_root_path

* @param string $php_ext

*/

{

$this->db = $db;

$this->config = $config;

$this->auth_provider_oauth_token_account_assoc = $auth_provider_oauth_token_account_assoc;

$this->service_providers = $service_providers;

$this->users_table = $users_table;

$this->phpbb_root_path = $phpbb_root_path;

$this->php_ext = $php_ext;

}

// Temporary workaround for only having one authentication provider available

if (!$this->request->is_set('oauth_service'))

{

return $provider->login($username, $password);

}

$row['avatar_width'] = $request->variable('avatar_gravatar_width', 0);

$row['avatar_height'] = $request->variable('avatar_gravatar_height', 0);

if (!function_exists('validate_data'))

{

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

if (empty($category) || empty($file))

{

return false;

}

$width = $request->variable('avatar_remote_width', 0);

$height = $request->variable('avatar_remote_height', 0);

if (!preg_match('#^(http|https|ftp)://#i', $url))

{

$url = 'http://' . $url;

}

else

{

return false;

}

static protected $default_row = array(

'avatar' => '',

'avatar_type' => '',

);

/**

return $error;

}

}

*

*/

{

var $width = 360;

var $height = 96;

);

}

}

*

*/

/**

* Wave3D CAPTCHA

*/

{

var $width = 360;

var $height = 96;

*

*/

/**

* Main non-gd captcha class

* @ignore

*/

{

var $filtered_pngs;

var $width = 320;

/**

* Define filtered pngs on init

*/

{

// If we can we will generate a single filtered png, we avoid nastiness via emulation of some Zlib stuff

$this->define_filtered_pngs();

*

*/

/**

* This class holds the code shared by the two default 3.0.x CAPTCHAs.

*/

{

var $confirm_id;

var $confirm_code;

var $solved = 0;

var $captcha_vars = false;

function init($type)

{

global $config, $db, $user;

// compute $seed % 0x7fffffff

$this->seed -= 0x7fffffff * floor($this->seed / 0x7fffffff);

define('IMAGE_OUTPUT', 1);

$captcha->execute($this->code, $this->seed);

}

return false;

}

}

define('IMAGE_OUTPUT', 1);

$captcha->execute($this->code, $this->seed);

}

// acp_captcha has a delivery function; let's use it

$template->assign_vars(array(

'CONFIRM_ID' => $this->confirm_id,

));

return false;

}

}

*

*/

{

var $captcha_vars = array(

'captcha_gd_x_grid' => 'CAPTCHA_GD_X_GRID',

'captcha_gd_y_grid' => 'CAPTCHA_GD_Y_GRID',

'captcha_gd_fonts' => 'CAPTCHA_GD_FONTS',

);

{

}

{

}

/**

return true;

}

{

return 'CAPTCHA_GD';

}

function acp_page($id, &$module)

{

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

$template->assign_vars(array(

'CAPTCHA_PREVIEW' => $this->get_demo_template($id),

'U_ACTION' => $module->u_action,

));

}

*

*/

/**

* And now to something completely different. Let's make a captcha without extending the abstract class.

* QA CAPTCHA sample implementation

*/

{

var $confirm_id;

var $answer;

// dirty trick: 0 is false, but can still encode that the captcha is not yet validated

var $solved = 0;

/**

* @param int $type as per the CAPTCHA API docs, the type

*/

// we need all defined questions - shouldn't be too many, so we can just grab them

// try the user's lang first

$sql = 'SELECT question_id

WHERE lang_iso = '" . $db->sql_escape($user->lang_name) . "'";

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

$this->question_lang = $config['default_lang'];

$sql = 'SELECT question_id

WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'";

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

}

/**

* See if the captcha has created its tables.

*/

{

global $db;

$db_tool = new \phpbb\db\tools($db);

}

/**

* API function - for the captcha to be available, it must have installed itself and there has to be at least one question in the board's default lang

*/

{

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

// load language file for pretty display in the ACP dropdown

$user->add_lang('captcha_qa');

{

return false;

}

$sql = 'SELECT COUNT(question_id) AS question_count

WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'";

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

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

}

/**

*/

{

}

/**

if ($this->is_available())

{

$sql = 'SELECT question_text

WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'";

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

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

global $db, $config;

$sql = 'SELECT c.confirm_id

LEFT JOIN ' . SESSIONS_TABLE . ' s

ON (c.session_id = s.session_id)

WHERE s.session_id IS NULL' .

if (sizeof($sql_in))

{

WHERE ' . $db->sql_in_set('confirm_id', $sql_in);

$db->sql_query($sql);

}

$db_tool = new \phpbb\db\tools($db);

$schemas = array(

'COLUMNS' => array(

'strict' => array('BOOL', 0),

'lang_id' => array('UINT', 0),

'lang_iso' => array('VCHAR:30', ''),

'lang' => array('INDEX', 'lang_iso'),

),

),

'COLUMNS' => array(

'question_id' => array('UINT', 0),

'answer_text' => array('STEXT_UNI', ''),

'qid' => array('INDEX', 'question_id'),

),

),

'COLUMNS' => array(

'session_id' => array('CHAR:32', ''),

'confirm_id' => array('CHAR:32', ''),

$this->confirm_id = md5(unique_id($user->ip));

$this->question = (int) array_rand($this->question_ids);