<?php

/**

*

*

*/

exit;

}

unset($dbpasswd);

/**

* $convertor_data provides some basic information about this convertor which is

* used on the initial list of convertors and to populate the default settings

$convertor_data = array(

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

'version' => '1.0.3',

'dbms' => $dbms,

'dbhost' => $dbhost,

'dbport' => $dbport,

'avatar_max_width' => 'avatar_max_width',

'avatar_max_height' => 'avatar_max_height',

'default_dateformat' => 'phpbb_set_encoding(default_dateformat)',

'allow_privmsg' => 'not(privmsg_disable)',

'gzip_compress' => 'gzip_compress',

'coppa_enable' => '!is_empty(coppa_mail)',

update_folder_pm_count();

', '

update_unread_count();

', '

phpbb_convert_authentication(\'start\');

', '

array('is_orphan', 0, ''),

array('poster_id', 'attachments.user_id_1 AS poster_id', 'phpbb_user_id'),

array('physical_filename', 'attachments_desc.physical_filename', 'import_attachment'),

array('download_count', 'attachments_desc.download_count', ''),

array('attach_comment', 'attachments_desc.comment', array('function1' => 'phpbb_set_encoding', 'function2' => 'utf8_htmlspecialchars')),

array('extension', 'attachments_desc.extension', ''),

array('topic_title', 'topics.topic_title', 'phpbb_set_encoding'),

array('topic_time', 'topics.topic_time', ''),

array('topic_views', 'topics.topic_views', ''),

array('topic_last_post_id', 'topics.topic_last_post_id', ''),

array('topic_status', 'topics.topic_status', 'is_topic_locked'),

array('topic_moved_id', 0, ''),

array('topic_type', 'topics.topic_type', 'phpbb_convert_topic_type'),

array('topic_first_post_id', 'topics.topic_first_post_id', ''),

array('topic_last_view_time', 'posts.post_time', 'intval'),

array('poll_title', 'vote_desc.vote_text', array('function1' => 'null_to_str', 'function2' => 'phpbb_set_encoding', 'function3' => 'htmlspecialchars_decode', 'function4' => 'utf8_htmlspecialchars')),

array('poll_start', 'vote_desc.vote_start', 'null_to_zero'),

array('poll_length', 'vote_desc.vote_length', 'null_to_zero'),

array('topic_title', 'topics.topic_title', 'phpbb_set_encoding'),

array('topic_time', 'topics.topic_time', ''),

array('topic_views', 'topics.topic_views', ''),

array('topic_last_post_id', 'topics.topic_last_post_id', ''),

array('topic_status', ITEM_MOVED, ''),

array('topic_moved_id', 'topics.topic_moved_id', ''),

array('topic_type', 'topics.topic_type', 'phpbb_convert_topic_type'),

array('topic_first_post_id', 'topics.topic_first_post_id', ''),

array('poll_title', 'vote_desc.vote_text', array('function1' => 'null_to_str', 'function2' => 'phpbb_set_encoding', 'function3' => 'htmlspecialchars_decode', 'function4' => 'utf8_htmlspecialchars')),

array('poll_start', 'vote_desc.vote_start', 'null_to_zero'),

array('post_edit_count', 'posts.post_edit_count', ''),

array('post_edit_reason', '', ''),

array('post_edit_user', '', 'phpbb_post_edit_user'),

array('bbcode_uid', 'posts.post_time', 'make_uid'),

array('post_text', 'posts_text.post_text', 'phpbb_prepare_message'),

array(

'target' => GROUPS_TABLE,

'autoincrement' => 'group_id',

array('group_id', 'groups.group_id', ''),

array('group_type', 'groups.group_type', 'phpbb_convert_group_type'),

'query_first' => array('target', $convert->truncate_statement . USER_GROUP_TABLE),

'execute_first' => '

add_default_groups();

',

array('group_id', 'groups.group_id', ''),

'autoincrement' => 'user_id',

'query_first' => array(

array('target', 'DELETE FROM ' . USERS_TABLE . ' WHERE user_id <> ' . ANONYMOUS),

),

'execute_last' => '

array('user_regdate', 'users.user_regdate', ''),

array('username', 'users.username', 'phpbb_set_default_encoding'), // recode to utf8 with default lang

array('username_clean', 'users.username', array('function1' => 'phpbb_set_default_encoding', 'function2' => 'utf8_clean_string')),

array('user_posts', 'users.user_posts', 'intval'),

array('user_email', 'users.user_email', 'strtolower'),

array('user_email_hash', 'users.user_email', 'gen_email_hash'),

array('user_lastmark', 'users.user_lastvisit', 'intval'),

array('user_lang', $config['default_lang'], ''),

array('', 'users.user_lang', ''),

array('user_dateformat', 'users.user_dateformat', array('function1' => 'phpbb_set_encoding', 'function2' => 'fill_dateformat')),

array('user_inactive_reason', '', 'phpbb_inactive_reason'),

array('user_inactive_time', '', 'phpbb_inactive_time'),

array('user_jabber', '', ''),

array('user_rank', 'users.user_rank', 'intval'),

array('user_permissions', '', ''),

array('user_sig_bbcode_bitfield', '', 'get_bbcode_bitfield'),

array('', 'users.user_regdate AS post_time', ''),

'where' => 'users.user_id <> -1',

),

),

);

}

<?php

/**

*

*

*/

}

/**

*/

/**

$prune_enabled = (int) $src_db->sql_fetchfield('config_value');

$src_db->sql_freeresult($result);

// Insert categories

$sql = 'SELECT cat_id, cat_title

FROM ' . $convert->src_table_prefix . 'categories

$src_db->sql_query("SET NAMES 'utf8'");

}

{

case 'mssql':

case 'mssql_odbc':

'forum_desc' => htmlspecialchars(phpbb_set_default_encoding($row['forum_desc']), ENT_COMPAT, 'UTF-8'),

'forum_type' => FORUM_POST,

'forum_status' => is_item_locked($row['forum_status']),

'prune_next' => (int) null_to_zero($row['prune_next']),

'prune_days' => (int) null_to_zero($row['prune_days']),

'prune_viewed' => 0,

'forum_rules_options' => 7,

'forum_rules_uid' => '',

'forum_topics_per_page' => 0,

'forum_last_post_id' => 0,

'forum_last_poster_id' => 0,

'forum_last_post_subject' => '',

}

$src_db->sql_freeresult($result);

{

case 'postgres':

$db->sql_query("SELECT SETVAL('" . FORUMS_TABLE . "_seq',(select case when max(forum_id)>0 then max(forum_id)+1 else 1 end from " . FORUMS_TABLE . '));');

{

$birthday = (int) $birthday;

{

return ' 0- 0- 0';

}

return (int) $user_id;

}

/* Copy additional table fields from old forum to new forum if user wants this (for Mod compatibility for example)

function phpbb_copy_table_fields()

{

// What we will do is handling all 2.0.x admins as founder to replicate what is common in 2.0.x.

// After conversion the main admin need to make sure he is removing permissions and the founder status if wanted.

// Grab user ids of users with user_level of ADMIN

$sql = "SELECT user_id

FROM {$convert->src_table_prefix}users

}

/**

* Obtain list of forums in which different attachment categories can be used

*/

function phpbb_attachment_forum_perms($forum_permissions)

global $db, $src_db, $convert, $table_prefix, $user, $lang;

$map_dbms = '';

{

case 'mysql':

$map_dbms = 'mysql_40';

break;

default:

break;

}

$drop_sql = 'DROP TABLE ' . USERCONV_TABLE;

switch ($map_dbms)

{

case 'mssql':

$create_sql = 'CREATE TABLE [' . USERCONV_TABLE . '] (

[user_id] [int] NOT NULL ,

break;

case 'sqlite':

$create_sql = 'CREATE TABLE ' . USERCONV_TABLE . ' (

user_id INTEGER NOT NULL DEFAULT \'0\',

username_clean varchar(255) NOT NULL DEFAULT \'\'

$db->sql_query($drop_sql);

}