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

array('pf_phpbb_interests', 'users.user_interests', array('function1' => 'phpbb_set_encoding')),

array('pf_phpbb_location', 'users.user_from', array('function1' => 'phpbb_set_encoding')),

array('pf_phpbb_icq', 'users.user_icq', array('function1' => 'phpbb_set_encoding')),

array('pf_phpbb_yahoo', 'users.user_yim', array('function1' => 'phpbb_set_encoding')),

array('pf_phpbb_aol', 'users.user_aim', array('function1' => 'phpbb_set_encoding')),

array('pf_phpbb_website', 'users.user_website', 'validate_website'),

'auth_delete' => 'f_delete',

'auth_pollcreate' => 'f_poll',

'auth_vote' => 'f_vote',

'auth_sticky' => 'f_sticky',

'auth_attachments' => array('f_attach', 'f_download'),

'auth_download' => 'f_download',

// We make sure that they have at least standard access to the forums they moderate in addition to the moderating permissions

$mod_post_map = array(

'auth_sticky' => 'f_sticky'

);

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

// Set up container (must be done here because extensions table may not exist)

// set up caching

/* @var $cache \phpbb\cache\service */

/* @var $migrator \phpbb\db\migrator */

$migrator = $phpbb_container->get('migrator');

$migrator->create_migrations_table();

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

// No more than 15 seconds so the user isn't sitting and waiting for a very long time

// While we're going to try limit this to half the max execution time,

// we want to try and take additional measures to prevent hitting the

$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './../';

$phpEx = substr(strrchr(__FILE__, '.'), 1);

{

}

function phpbb_require_updated($path, $optional = false)

// Set up container

$phpbb_config_php_file = new \phpbb\config_php_file($phpbb_root_path, $phpEx);

$other_config_path = $phpbb_root_path . 'install/update/new/config/';

$config_path = file_exists($other_config_path . 'services.yml') ? $other_config_path : $phpbb_root_path . 'config/';

'core.root_path' => $phpbb_root_path,

'core.adm_relative_path' => $phpbb_adm_relative_path,

'core.php_ext' => $phpEx,

$phpbb_container = $phpbb_container_builder->get_container();

$phpbb_container->register('dbal.conn.driver')->setSynthetic(true);

$phpbb_container->register('template.twig.environment')->setSynthetic(true);

$phpbb_container->compile();

$phpbb_class_loader->set_cache($phpbb_container->get('cache.driver'));

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

/* @var $symfony_request \phpbb\symfony_request */

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

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

/* @var $phpbb_path_helper \phpbb\path_helper */

$twig_environment = new \phpbb\template\twig\environment(

$config,

$phpbb_path_helper,

$phpbb_container,

$cache_path,

$phpbb_container->get('template.twig.loader')

);

$phpbb_container->set('template.twig.environment', $twig_environment);

$template = new \phpbb\template\twig\twig(

$phpbb_path_helper,

$config,

$twig_environment,

$cache_path,

array($phpbb_container->get('template.twig.extensions.phpbb'))

);

/** @var string */

protected $php_ext;

/**

* Variables used while converting, they are accessible from the global variable $convert

*/

$this->template = $template;

$this->phpbb_root_path = $phpbb_root_path;

$this->php_ext = $phpEx;

if (!$this->check_phpbb_installed())

{

// Enable super globals to prevent issues with the new \phpbb\request\request object

$request->enable_super_globals();

// Create a normal container now

// Create cache

/* @var $cache \phpbb\cache\service */

unset($dbpasswd);

// We need to fill the config to let internal functions correctly work

// Detect if there is already a conversion in progress at this point and offer to resume

// It's quite possible that the user will get disconnected during a large conversion so they need to be able to resume it

$this->page_title = $lang['STAGE_SETTINGS'];

// We need to fill the config to let internal functions correctly work

$convertor_tag = $request->variable('tag', '');

{

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

global $convert, $convert_row, $message_parser, $skip_rows, $language;

extract($phpbb_config_php_file->get_all());

unset($dbpasswd);

// We need to fill the config to let internal functions correctly work

// Override a couple of config variables for the duration

$config['max_quote_depth'] = 0;

}

$error = false;

if ($error)

{

$this->p_master->error($user->lang['DEV_NO_TEST_FILE'], __LINE__, __FILE__);

}

{

if (!$local_path)

{

*/

class install_install extends module

{

function install_install(&$p_master)

{

$this->p_master = &$p_master;

}

function main($mode, $sub)

$request->enable_super_globals();

// Create a normal container now

// Sets the global variables

/* @var $cache \phpbb\cache\service */

// Test the minimum PHP version

$php_version = PHP_VERSION;

{

$result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

}

if (!file_exists($phpbb_root_path . $dir))

{

@mkdir($phpbb_root_path . $dir, 0777);

}

// Now really check

if (file_exists($phpbb_root_path . $dir) && is_dir($phpbb_root_path . $dir))

{

$exists = true;

}

$write = $exists = true;

if (file_exists($phpbb_root_path . $dir))

{

{

$write = false;

}

$config_data = phpbb_create_config_file_data($data, $available_dbms[$data['dbms']]['DRIVER']);

// Attempt to write out the config file directly. If it works, this is the easiest way to do it ...

{

// Assume it will work ... if nothing goes wrong below

$written = true;

if ($written)

{

// We may revert back to chmod() if we see problems with users not able to change their config.php file directly

}

}

foreach ($sql_query as $sql)

{

}

unset($sql_query);

}

include($phpbb_root_path . 'includes/constants.' . $phpEx);

}

$classes = $finder->core_path('phpbb/db/migration/data/')

->get_classes();

*/

function build_search_index($mode, $sub)

{

// Obtain any submitted data

$data = $this->get_submitted_data();

include_once($phpbb_root_path . 'phpbb/search/fulltext_native.' . $phpEx);

// We need to fill the config to let internal functions correctly work

$error = false;

$sql = 'SELECT post_id, post_subject, post_text, poster_id, forum_id

FROM ' . POSTS_TABLE;

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

}

$module_classes = array('acp', 'mcp', 'ucp');

// Add categories

);

// Add category

// Check for last sql error happened

if ($db->get_sql_error_triggered())

'module_auth' => '',

);

// Check for last sql error happened

if ($db->get_sql_error_triggered())

}

// Get the modules we want to add... returned sorted by name

foreach ($module_info as $module_basename => $fileinfo)

{

'module_auth' => $row['auth'],

);

// Check for last sql error happened

if ($db->get_sql_error_triggered())

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

$db->sql_freeresult($result);

// Move permissions intro screen module 4 up...

$sql = 'SELECT *

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

$db->sql_freeresult($result);

// Move manage users screen module 5 up...

$sql = 'SELECT *

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

$db->sql_freeresult($result);

// Move extension management module 1 up...

$sql = 'SELECT *

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

$db->sql_freeresult($result);

}

if ($module_class == 'mcp')

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

$db->sql_freeresult($result);

// Move closed pm reports module 3 down...

$sql = 'SELECT *

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

$db->sql_freeresult($result);

// Move open pm reports module 3 down...

$sql = 'SELECT *

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

$db->sql_freeresult($result);

}

if ($module_class == 'ucp')

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

$db->sql_freeresult($result);

// Move notification options module 4 down...

$sql = 'SELECT *

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

$db->sql_freeresult($result);

// Move OAuth module 5 down...

$sql = 'SELECT *

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

$db->sql_freeresult($result);

}

// And now for the special ones

'module_auth' => $row['module_auth'],

);

// Check for last sql error happened

if ($db->get_sql_error_triggered())

}

}

}

}

$data = $this->get_submitted_data();

// We need to fill the config to let internal functions correctly work

$sql = 'SELECT group_id

FROM ' . GROUPS_TABLE . "

$data = $this->get_submitted_data();

// We need to fill the config to let internal functions correctly work

$user->session_begin();

$auth->login($data['admin_name'], $data['admin_pass1'], false, true, true);

{

global $config, $phpbb_root_path;

{

$config->set('allow_avatar', 0);

$config->set('allow_avatar_upload', 0);

var $update_to_version;

// Set to false

var $test_update = false;

$request->enable_super_globals();

// Create a normal container now

if (file_exists($phpbb_root_path . 'install/update/new/config'))

{

}

$phpbb_container = $phpbb_container_builder->get_container();

/* @var $cache \phpbb\cache\service */

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

$this->tpl_name = 'install_update';

$this->page_title = 'UPDATE_INSTALLATION';

unset($dbpasswd);

// We need to fill the config to let internal functions correctly work

// Force template recompile

$config['load_tplcompile'] = 1;

// Now init the connection

if ($update_mode == 'download')

{

{

trigger_error(sprintf('The directory “%s” is not writable.', $phpbb_root_path . 'store/'), E_USER_ERROR);

}

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig_smilies', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_topic_notify', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('assets_version', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('attachment_quota', '52428800');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('auth_bbcode_pm', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_package_size', '20');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '1');

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_pm_icons', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_post_confirm', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_enable', '1');

# -- Forum related auth options

INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_', 1);

INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_announce', 1);

INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_attach', 1);

INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_bbcode', 1);

INSERT INTO phpbb_acl_options (auth_option, is_local) VALUES ('f_bump', 1);

# -- Global moderator auth option (not a local option)

INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_ban', 0, 1);

INSERT INTO phpbb_acl_options (auth_option, is_local, is_global) VALUES ('m_warn', 0, 1);

# -- Admin related auth options

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 11, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%' AND auth_option NOT IN ('m_ban', 'm_chgposter');

# Simple Moderator (m_)

# Queue Moderator (m_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 13, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%' AND auth_option IN ('m_', 'm_approve', 'm_edit');

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 14, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%';

# Standard Access (f_)

# No Access (f_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 16, auth_option_id, 0 FROM phpbb_acl_options WHERE auth_option = 'f_';

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 17, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%' AND auth_option IN ('f_', 'f_download', 'f_list', 'f_read', 'f_search', 'f_subscribe', 'f_print');

# Limited Access (f_)

# Bot Access (f_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 19, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%' AND auth_option IN ('f_', 'f_download', 'f_list', 'f_read', 'f_print');

# On Moderation Queue (f_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 20, auth_option_id, 0 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%' AND auth_option IN ('f_noapprove');

# Standard Access + Polls (f_)

# Limited Access + Polls (f_)

# New Member (u_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 23, auth_option_id, 0 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option IN ('u_sendpm', 'u_masspm', 'u_masspm_group', 'u_chgprofileinfo');

INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('ARCHIVES', 0, 1, 1, '', 0, '');

INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('PLAIN_TEXT', 0, 0, 1, '', 0, '');

INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('DOCUMENTS', 0, 0, 1, '', 0, '');

INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('FLASH_FILES', 5, 0, 1, '', 0, '');

INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('DOWNLOADABLE_FILES', 0, 0, 1, '', 0, '');

# -- extensions

INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'odt');

INSERT INTO phpbb_extensions (group_id, extension) VALUES (4, 'rtf');

# Add default profile fields

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_location', 'profilefields.type.string', 'phpbb_location', '20', '2', '100', '', '', '.*', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 1, 0, '', '');

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_occupation', 'profilefields.type.text', 'phpbb_occupation', '3|30', '2', '500', '', '', '.*', 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 4, 0, '', '');

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_aol', 'profilefields.type.string', 'phpbb_aol', '40', '5', '255', '', '', '.*', 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 5, 1, '', '');

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_icq', 'profilefields.type.string', 'phpbb_icq', '20', '3', '15', '', '', '[0-9]+', 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 6, 1, 'SEND_ICQ_MESSAGE', 'https://www.icq.com/people/%s/');

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_yahoo', 'profilefields.type.string', 'phpbb_yahoo', '40', '5', '255', '', '', '.*', 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 8, 1, 'SEND_YIM_MESSAGE', 'ymsgr:sendim?%s');

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_facebook', 'profilefields.type.string', 'phpbb_facebook', '20', '5', '50', '', '', '[\w.]+', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 9, 1, 'VIEW_FACEBOOK_PROFILE', 'http://facebook.com/%s/');

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_twitter', 'profilefields.type.string', 'phpbb_twitter', '20', '1', '15', '', '', '[\w_]+', 0, 0, 0, 1, 1, 1, 1, 0, 0, 1, 10, 1, 'VIEW_TWITTER_PROFILE', 'http://twitter.com/%s');

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)

INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.post', 0, 2, 'notification.method.email');

INSERT INTO phpbb_user_notifications (item_type, item_id, user_id, method) VALUES('notification.type.topic', 0, 2, 'notification.method.email');

# POSTGRES COMMIT #