$user_id = (int) $src_db->sql_fetchfield('max_user_id');

$src_db->sql_freeresult($result);

}

else

{

}

// Overwrite maximum avatar width/height

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'),

// If there is a user id 1, we need to increment user ids. :/

if ($id === 1)

{

$config['increment_user_id'] = $max_id + 1;

}

else

{

$config['increment_user_id'] = 0;

}

}

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

);

}

$src_db->sql_freeresult($result);

// old attachment mod? Must be very old if this entry do not exist...

if (!empty($attach_config['display_order']))

{

}

/**

function phpbb_convert_timezone($timezone)

{

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

return $timezone_migration->convert_phpbb30_timezone($timezone, 0);

}

{

global $phpbb_container;

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

$hash = $manager->hash($hash, '$H$');

// do the case fold

$text = utf8_new_case_fold($text, $option);

// convert to NFKC

// FC_NFKC_Closure, http://www.unicode.org/Public/5.0.0/ucd/DerivedNormalizationProps.txt

$text = strtr($text, $fc_nfkc_closure);

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

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

require($phpbb_root_path . 'includes/utf/utf_tools.' . $phpEx);

// Set PHP error handler to ours

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

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

// Instantiate some basic classes

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

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

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

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

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

// Grab global variables, re-cache if necessary

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

if (!isset($config['version_update_from']))

{

require($phpbb_root_path . 'includes/hooks/index.' . $phpEx);

$phpbb_hook = new phpbb_hook(array('exit_handler', 'phpbb_user_session_handler', 'append_sid', array('template', 'display')));

$phpbb_hook_finder = $phpbb_container->get('hook_finder');

foreach ($phpbb_hook_finder->find() as $hook)

{

// End startup code

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

$migrator->create_migrations_table();

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

$migrations = $phpbb_extension_manager

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

if ($orig_version != $config['version'])

{

}

echo $user->lang['DATABASE_UPDATE_COMPLETE'] . '<br />';

*/

define('IN_PHPBB', true);

define('IN_INSTALL', true);

/**#@-*/

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

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

{

}

function phpbb_require_updated($path, $optional = false)

phpbb_require_updated('includes/functions_content.' . $phpEx, true);

phpbb_include_updated('includes/functions_admin.' . $phpEx);

phpbb_include_updated('includes/utf/utf_tools.' . $phpEx);

phpbb_require_updated('includes/functions_install.' . $phpEx);

// 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->compile();

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

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

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

// Try and load an appropriate language if required

$language = basename($request->variable('language', ''));

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

require($phpbb_root_path . 'includes/hooks/index.' . $phpEx);

$phpbb_hook = new phpbb_hook(array('exit_handler', 'phpbb_user_session_handler', 'append_sid', array('template', 'display')));

$phpbb_hook_finder = $phpbb_container->get('hook_finder');

foreach ($phpbb_hook_finder->find() as $hook)

{

'load_tplcompile' => '1'

));

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

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

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

$paths = array($phpbb_root_path . 'install/update/new/adm/style', $phpbb_admin_path . 'style');

$paths = array_filter($paths, 'is_dir');

$template->set_custom_style(array(

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

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

switch ($sub)

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

if ($new_conversion)

{

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

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

if (empty($convertor_tag))

{

$submit = (isset($_POST['submit'])) ? true : false;

// Default URL of the old board

// @todo Are we going to use this for attempting to convert URL references in posts, or should we remove it?

// -> We should convert old urls to the new relative urls format

// strip trailing slash from old forum path

$forum_path = (strlen($forum_path) && $forum_path[strlen($forum_path) - 1] == '/') ? substr($forum_path, 0, -1) : $forum_path;

{

$prefixes = array();

$tables_existing = array_map('strtolower', $tables_existing);

foreach ($tables_existing as $table_name)

{

if (!sizeof($error))

{

// Save convertor Status

'step' => '',

'table_prefix' => $src_table_prefix,

'tag' => $convertor_tag,

'dbms' => $src_dbms,

'dbhost' => $src_dbhost,

'dbport' => $src_dbport,

'dbname' => $src_dbname,

'dbuser' => $src_dbuser,

'dbpasswd' => $src_dbpasswd,

// Save options

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

'TITLE' => $lang['VERIFY_OPTIONS'],

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;

if (!class_exists($search_type))

{

$search_type = '\phpbb\search\fulltext_native';

}

if (!class_exists($search_type))

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

$message_parser = new parse_message();

// We are running sync...

if ($sync_batch >= 0)

return;

}

$old_current_table = min(-1, $current_table - 1);

if (!$current_table && !$skip_rows)

{

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

}

{

if (!$local_path)

{

*/

function save_convert_progress($step)

{

// Save convertor Status

'step' => $step,

'table_prefix' => $convert->src_table_prefix,

'tag' => $convert->convertor_tag,

'dbms' => $convert->src_dbms,

'dbhost' => $convert->src_dbhost,

'dbport' => $convert->src_dbport,

'dbname' => $convert->src_dbname,

'dbuser' => $convert->src_dbuser,

'dbpasswd' => $convert->src_dbpasswd,

return $this->p_master->module_url . "?mode={$this->mode}&amp;sub=in_progress&amp;tag={$convert->convertor_tag}$step&amp;language=$language";

}

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

// And finally, add a note to the log

$url = $this->p_master->module_url . "?mode={$this->mode}&amp;sub=final&amp;language=$language";

if (!isset($config['board_startdate']) || ($row['board_startdate'] < $config['board_startdate'] && $row['board_startdate'] > 0))

{

$db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_regdate = ' . $row['board_startdate'] . ' WHERE user_id = ' . ANONYMOUS);

}

*/

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

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

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

$this->build_search_index($mode, $sub);

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

}

}

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

}

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

->get_classes();

$sqlite_db = new \phpbb\db\driver\sqlite();

$db_table_schema = $schema_generator->get_schema();

}

define('CONFIG_TABLE', $data['table_prefix'] . 'config');

}

foreach ($db_table_schema as $table_name => $table_data)

{

$db_tools->sql_create_table(

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

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

$error = false;

$search = new \phpbb\search\fulltext_native($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user, $phpbb_dispatcher);

// modules require an extension manager

if (empty($phpbb_extension_manager))

{

$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 . "

*/

function email_admin($mode, $sub)

{

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

$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);

}

// And finally, add a note to the log

$template->assign_vars(array(

'TITLE' => $lang['INSTALL_CONGRATS'],

*/

function disable_avatars_if_unwritable()

{

{

}

}

*/

function get_submitted_data()

{

return array(

);

}

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();

// Writes into global $cache

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

));

// Get current and latest version

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

try

{

// Fill DB version

if (empty($config['dbms_version']))

{

}

if ($this->test_update === false)

$this->page_title = 'STAGE_FILE_CHECK';

// Now make sure our update list is correct if the admin refreshes

// We are directly within an update. To make sure our update list is correct we check its status.

$update_list = ($request->variable('check_again', false, false, \phpbb\request\request_interface::POST)) ? false : $cache->get('_update_list');

if ($all_up_to_date)

{

global $phpbb_container;

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

// Add database update to log

$s_hidden_fields = '';

$params = array();

foreach ($conflicts as $filename => $merge_option)

{

$params[] = 'modified[' . urlencode($filename) . ']=' . urlencode($merge_option);

}

foreach ($no_update as $index => $filename)

{

{

$this->include_file('includes/functions_compress.' . $phpEx);

$methods = array('.tar');

$available_methods = array('.tar.gz' => 'zlib', '.tar.bz2' => 'bz2', '.zip' => 'zlib');

$this->include_file('includes/functions_transfer.' . $phpEx);

// Choose FTP, if not available use fsock...

$submit = (isset($_POST['submit'])) ? true : false;

if (!$method || !class_exists($method))

{

if ($test_ftp_connection || $submit)

{

$transfer = new $method(

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

);

$test_connection = $transfer->open_session();

// Now init the connection

if ($update_mode == 'download')

{

{

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

}

else

{

$transfer = new $method(

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

);

$transfer->open_session();

}

*/

function show_diff(&$update_list)

{

$this->tpl_name = 'install_update_diff';

$this->page_title = 'VIEWING_FILE_DIFF';

// First of all make sure the file is within our file update list with the correct status

$found_entry = array();

switch ($status)

{

case 'conflict':

switch ($option)

{

break;

case 'modified':

switch ($option)

{

// Get custom installed styles...

$sql = 'SELECT style_name, style_path

FROM ' . STYLES_TABLE . "

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

$templates = array();

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');

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');

# -- 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);

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 #