+ global $db, $src_db, $same_db, $convert, $user, $config;

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

+ $max_forum_id = (int) $src_db->sql_fetchfield('max_forum_id');

+ $src_db->sql_freeresult($result);

+ if ($convert->mysql_convert && $same_db)

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

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

+

+ if ($convert->mysql_convert && $same_db)

+ {

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

+ }

+ switch ($db->sql_layer)

+ case 'mssql':

+ case 'mssql_odbc':

+ $db->sql_query('SET IDENTITY_INSERT ' . FORUMS_TABLE . ' ON');

+ break;

+ while ($row = $src_db->sql_fetchrow($result))

+ 'forum_name' => ($row['cat_title']) ? htmlspecialchars(phpbb_set_default_encoding($row['cat_title']), ENT_COMPAT, 'UTF-8') : $user->lang['CATEGORY'],

+ $src_db->sql_freeresult($result);

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

+ while ($row = $src_db->sql_fetchrow($result))

+ $src_db->sql_freeresult($result);

+ $sql = 'SELECT f.forum_id, f.forum_name, f.cat_id, f.forum_desc, f.forum_status, f.prune_enable, f.prune_next, fp.prune_days, fp.prune_freq FROM ' . $convert->src_table_prefix . 'forums f

+ GROUP BY f.forum_id, f.forum_name, f.cat_id, f.forum_desc, f.forum_status, f.prune_enable, f.prune_next, f.forum_order, fp.prune_days, fp.prune_freq

+ if ($convert->mysql_convert && $same_db)

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

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

+ if ($convert->mysql_convert && $same_db)

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

+ while ($row = $src_db->sql_fetchrow($result))

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

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

+ $src_db->sql_freeresult($result);

+

+ switch ($db->sql_layer)

+ {

+ case 'mssql':

+ case 'mssql_odbc':

+ $db->sql_query('SET IDENTITY_INSERT ' . FORUMS_TABLE . ' OFF');

+ break;

+ }

+ global $src_db, $same_db;

+

+ if ($convert->mysql_convert && $same_db)

+ {

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

+ }

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

+ $get_lang = (string) $src_db->sql_fetchfield('user_lang');

+ $src_db->sql_freeresult($result);

+

+ if ($convert->mysql_convert && $same_db)

+ {

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

+ }

+ $birthday = (string) $birthday;

+

+ // We use the original mod code to retrieve the birthday (not ideal)

+ preg_match('/(..)(..)(....)/', sprintf('%08d', $birthday), $birthday_parts);

+ $month = $birthday_parts[1];

+ $day = $birthday_parts[2];

+ $year = $birthday_parts[3];

+ $birthday = (int) $birthday;

+

+ global $src_db, $same_db, $convert;

+

+ if ($convert->mysql_convert && $same_db)

+ {

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

+ }

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

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

+ $src_db->sql_freeresult($result);

+

+ // Try to get the maximum user id possible...

+ $sql = "SELECT MAX(user_id) AS max_user_id

+ FROM {$convert->src_table_prefix}users";

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

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

+ $src_db->sql_freeresult($result);

+

+ if ($convert->mysql_convert && $same_db)

+ {

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

+ }

+ set_config('increment_user_id', ($max_id + 1), true);

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

+ // If the old user id is -1 in 2.0.x it is the anonymous user...

+ if ($user_id == -1)

+ return ANONYMOUS;

+ if (!empty($config['increment_user_id']) && $user_id == 1)

+ {

+ return $config['increment_user_id'];

+ }

+

+ // A user id of 0 can happen, for example within the ban table if no user is banned...

+ // Within the posts and topics table this can be "dangerous" but is the fault of the user

+ // having mods installed (a poster id of 0 is not possible in 2.0.x).

+ // Therefore, we return the user id "as is".

+

+ return (int) $user_id;

+ global $db, $src_db, $same_db, $convert, $user, $config, $cache;

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

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

+ while ($row = $src_db->sql_fetchrow($result))

+ {

+ $user_id = (int) phpbb_user_id($row['user_id']);

+ // Set founder admin...

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_type = ' . USER_FOUNDER . "

+ WHERE user_id = $user_id";

+ $db->sql_query($sql);

+ }

+ $src_db->sql_freeresult($result);

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

+ while ($row = $src_db->sql_fetchrow($result))

+ $src_db->sql_freeresult($result);

+ if ($convert->mysql_convert && $same_db)

+ {

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

+ }

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

+ while ($row = $src_db->sql_fetchrow($result))

+ $src_db->sql_freeresult($result);

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

+ while ($row = $src_db->sql_fetchrow($result))

+ $src_db->sql_freeresult($result);

+

+ if ($convert->mysql_convert && $same_db)

+ {

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

+ }

+ 'auth_read' => array('f_read', 'f_search'),

+ 'auth_post' => array('f_post', 'f_bbcode', 'f_smilies', 'f_img', 'f_sigs', 'f_postcount', 'f_report', 'f_subscribe', 'f_print', 'f_email'),

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

+ user_group_auth('guests', 'SELECT user_id, {GUESTS} FROM ' . USERS_TABLE . ' WHERE user_id = ' . ANONYMOUS, false);

+ user_group_auth('registered', 'SELECT user_id, {REGISTERED} FROM ' . USERS_TABLE . ' WHERE user_id <> ' . ANONYMOUS, false);

+ if (!empty($config['increment_user_id']))

+ {

+ $auth_sql = 'SELECT user_id, {ADMINISTRATORS} FROM ' . $convert->src_table_prefix . 'users WHERE user_level = 1 AND user_id <> 1';

+ user_group_auth('administrators', $auth_sql, true);

+ $auth_sql = 'SELECT ' . $config['increment_user_id'] . ' as user_id, {ADMINISTRATORS} FROM ' . $convert->src_table_prefix . 'users WHERE user_level = 1 AND user_id = 1';

+ user_group_auth('administrators', $auth_sql, true);

+ }

+ else

+ {

+ $auth_sql = 'SELECT user_id, {ADMINISTRATORS} FROM ' . $convert->src_table_prefix . 'users WHERE user_level = 1';

+ user_group_auth('administrators', $auth_sql, true);

+ }

+ if (!empty($config['increment_user_id']))

+ {

+ $auth_sql = 'SELECT user_id, {GLOBAL_MODERATORS} FROM ' . $convert->src_table_prefix . 'users WHERE user_level = 1 AND user_id <> 1';

+ user_group_auth('global_moderators', $auth_sql, true);

+ $auth_sql = 'SELECT ' . $config['increment_user_id'] . ' as user_id, {GLOBAL_MODERATORS} FROM ' . $convert->src_table_prefix . 'users WHERE user_level = 1 AND user_id = 1';

+ user_group_auth('global_moderators', $auth_sql, true);

+ }

+ else

+ {

+ $auth_sql = 'SELECT user_id, {GLOBAL_MODERATORS} FROM ' . $convert->src_table_prefix . 'users WHERE user_level = 1';

+ user_group_auth('global_moderators', $auth_sql, true);

+ }

+ // Go through all 2.0.x forums

+ mass_auth('group_role', $new_forum_id, 'registered', 'FORUM_POLLS');

+ mass_auth('group', $new_forum_id, 'bots', $new_acl, ACL_YES);

+ // By default all converted administrators are given full access

+ mass_auth('group_role', 0, 'administrators', 'ADMIN_FULL');

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

+ while ($row = $src_db->sql_fetchrow($result))

+ $src_db->sql_freeresult($result);

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

+ while ($row = $src_db->sql_fetchrow($result))

+ $src_db->sql_freeresult($result);

+ mass_auth('group_role', $row['forum_id'], 'global_moderators', 'FORUM_FULL');

+ // Let us see which groups have access to these forums...

+ $hold_ary = $auth->acl_group_raw_data(false, 'f_list', $forum_ids);

+ if (empty($hold_ary))

+ continue;

+ }

+

+ foreach ($hold_ary as $g_id => $f_id_ary)

+ {

+ $set_group = false;

+

+ foreach ($f_id_ary as $f_id => $auth_ary)

+ {

+ foreach ($auth_ary as $auth_option => $setting)

+ {

+ if ($setting == ACL_YES)

+ {

+ $set_group = true;

+ break 2;

+ }

+ }

+ }

+

+ if ($set_group)

+ {

+ mass_auth('group', $row['forum_id'], $g_id, 'f_list', ACL_YES);

+ }

+ return phpbb_set_default_encoding($group_name);

+ // Never return GROUP_SPECIAL here, because only phpBB3's default groups are allowed to have this type set.

+ return GROUP_HIDDEN;

+function phpbb_replace_size($matches)

+{

+ return '[size=' . min(200, ceil(100.0 * (((double) $matches[1])/12.0))) . ':' . $matches[2] . ']';

+}

+

+ // Adjust size...

+ if (strpos($message, '[size=') !== false)

+ {

+ $message = preg_replace_callback('/\[size=(\d*):(' . $convert->row['old_bbcode_uid'] . ')\]/', 'phpbb_replace_size', $message);

+ }

+

+ // Already the new user id ;)

+ global $src_db, $same_db, $convert, $user, $config, $cache;

+ if ($convert->mysql_convert && $same_db)

+ {

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

+ }

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

+ $upload_path = $src_db->sql_fetchfield('upload_dir');

+ $src_db->sql_freeresult($result);

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

+ $ftp_upload = (int) $src_db->sql_fetchfield('ftp_upload');

+ $src_db->sql_freeresult($result);

+

+ if ($convert->mysql_convert && $same_db)

+ {

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

+ }

+ return import_avatar($user_avatar, false, $convert_row['user_id']);

+

+/**

+* Find out about the avatar's dimensions

+*/

+function phpbb_get_avatar_height($user_avatar)

+{

+ global $convert_row;

+

+ if (empty($convert_row['user_avatar_type']))

+ {

+ return 0;

+ }

+ return get_avatar_height($user_avatar, 'phpbb_avatar_type', $convert_row['user_avatar_type']);

+}

+

+

+/**

+* Find out about the avatar's dimensions

+*/

+function phpbb_get_avatar_width($user_avatar)

+{

+ global $convert_row;

+

+ if (empty($convert_row['user_avatar_type']))

+ {

+ return 0;

+ }

+

+ return get_avatar_width($user_avatar, 'phpbb_avatar_type', $convert_row['user_avatar_type']);

+}

+

+

+ global $db, $src_db, $same_db, $convert, $config;

+

+ if ($convert->mysql_convert && $same_db)

+ {

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

+ }

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

+

+ if ($convert->mysql_convert && $same_db)

+ {

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

+ }

+ while ($row = $src_db->sql_fetchrow($result))

+ $src_db->sql_freeresult($result);

+/**

+* Adjust 2.0.x disallowed names to 3.0.x format

+*/

+function phpbb_disallowed_username($username)

+{

+ // Replace * with %

+ $username = phpbb_set_default_encoding(str_replace('*', '%', $username));

+ return utf8_htmlspecialchars($username);

+}

+

+/**

+* Checks whether there are any usernames on the old board that would map to the same

+* username_clean on phpBB3. Prints out a list if any exist and exits.

+*/

+function phpbb_check_username_collisions()

+{

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

+

+ $map_dbms = '';

+ switch ($db->sql_layer)

+ {

+ case 'mysql':

+ $map_dbms = 'mysql_40';

+ break;

+

+ case 'mysql4':

+ if (version_compare($db->mysql_version, '4.1.3', '>='))

+ {

+ $map_dbms = 'mysql_41';

+ }

+ else

+ {

+ $map_dbms = 'mysql_40';

+ }

+ break;

+

+ case 'mysqli':

+ $map_dbms = 'mysql_41';

+ break;

+

+ case 'mssql':

+ case 'mssql_odbc':

+ $map_dbms = 'mssql';

+ break;

+

+ default:

+ $map_dbms = $db->sql_layer;

+ break;

+ }

+

+ // create a temporary table in which we store the clean usernames

+ $drop_sql = 'DROP TABLE ' . $table_prefix . 'userconv';

+ switch ($map_dbms)

+ {

+ case 'firebird':

+ $create_sql = 'CREATE TABLE ' . $table_prefix . 'userconv (

+ user_id INTEGER NOT NULL,

+ username_clean VARCHAR(255) CHARACTER SET UTF8 DEFAULT \'\' NOT NULL COLLATE UNICODE

+ )';

+ break;

+

+ case 'mssql':

+ $create_sql = 'CREATE TABLE [' . $table_prefix . 'userconv] (

+ [user_id] [int] NOT NULL ,

+ [username_clean] [varchar] (255) DEFAULT (\'\') NOT NULL

+ )';

+ break;

+

+ case 'mysql_40':

+ $create_sql = 'CREATE TABLE ' . $table_prefix . 'userconv (

+ user_id mediumint(8) NOT NULL,

+ username_clean blob NOT NULL

+ )';

+ break;

+

+ case 'mysql_41':

+ $create_sql = 'CREATE TABLE ' . $table_prefix . 'userconv (

+ user_id mediumint(8) NOT NULL,

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

+ ) CHARACTER SET `utf8` COLLATE `utf8_bin`';

+ break;

+

+ case 'oracle':

+ $create_sql = 'CREATE TABLE ' . $table_prefix . 'userconv

+ user_id number(8) NOT NULL,

+ username_clean varchar2(255) DEFAULT \'\'

+ )';

+ break;

+

+ case 'postgres':

+ $create_sql = 'CREATE TABLE ' . $table_prefix . 'userconv (

+ user_id INT4 DEFAULT \'0\',

+ username_clean varchar_ci DEFAULT \'\' NOT NULL

+ )';

+ break;

+

+ case 'sqlite':

+ $create_sql = 'CREATE TABLE ' . $table_prefix . 'userconv (

+ user_id INTEGER NOT NULL DEFAULT \'0\',

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

+ )';

+ break;

+ }

+

+ $db->sql_return_on_error(true);

+ $db->sql_query($drop_sql);

+ $db->sql_query($create_sql);

+ $db->sql_return_on_error(false);

+

+ // now select all user_ids and usernames and then convert the username (this can take quite a while!)

+ $sql = 'SELECT user_id, username

+ FROM ' . $convert->src_table_prefix . 'users';

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

+

+ $insert_ary = array();

+ $i = 0;

+ while ($row = $src_db->sql_fetchrow($result))

+ {

+ $clean_name = utf8_clean_string(phpbb_set_default_encoding($row['username']));

+ $insert_ary[] = array('user_id' => $row['user_id'], 'username_clean' => $clean_name);

+

+ if ($i % 1000 == 999)

+ {

+ $db->sql_multi_insert($table_prefix . 'userconv', $insert_ary);

+ $insert_ary = array();

+ }

+ $i++;

+ }

+ $src_db->sql_freeresult($result);

+

+ if (sizeof($insert_ary))

+ {

+ $db->sql_multi_insert($table_prefix . 'userconv', $insert_ary);

+ }

+ unset($insert_ary);

+

+ // now find the clean version of the usernames that collide

+ $sql = 'SELECT username_clean

+ FROM ' . $table_prefix . 'userconv

+ GROUP BY username_clean

+ HAVING COUNT(user_id) > 1';

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

+

+ $colliding_names = array();

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

+ {

+ $colliding_names[] = $row['username_clean'];

+ }

+ $db->sql_freeresult($result);

+

+ // there was at least one collision, the admin will have to solve it before conversion can continue

+ if (sizeof($colliding_names))

+ {

+ $sql = 'SELECT user_id, username_clean

+ FROM ' . $table_prefix . 'userconv

+ WHERE ' . $db->sql_in_set('username_clean', $colliding_names);

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

+ unset($colliding_names);

+

+ $colliding_user_ids = array();

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

+ {

+ $colliding_user_ids[(int) $row['user_id']] = $row['username_clean'];

+ }

+ $db->sql_freeresult($result);

+

+ $sql = 'SELECT username, user_id, user_posts

+ FROM ' . $convert->src_table_prefix . 'users

+ WHERE ' . $src_db->sql_in_set('user_id', array_keys($colliding_user_ids));

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

+

+ $colliding_users = array();

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

+ {

+ $row['user_id'] = (int) $row['user_id'];

+ if (isset($colliding_user_ids[$row['user_id']]))

+ {

+ $colliding_users[$colliding_user_ids[$row['user_id']]][] = $row;

+ }

+ }

+ $db->sql_freeresult($result);

+ unset($colliding_user_ids);

+

+ $list = '';

+ foreach ($colliding_users as $username_clean => $users)

+ {

+ $list .= sprintf($user->lang['COLLIDING_CLEAN_USERNAME'], $username_clean) . "<br />\n";

+ foreach ($users as $i => $row)

+ {

+ $list .= sprintf($user->lang['COLLIDING_USER'], $row['user_id'], phpbb_set_default_encoding($row['username']), $row['user_posts']) . "<br />\n";

+ }

+ }

+

+ $lang['INST_ERR_FATAL'] = $user->lang['CONV_ERR_FATAL'];

+ $convert->p_master->error('<span style="color:red">' . $user->lang['COLLIDING_USERNAMES_FOUND'] . '</span></b><br /><br />' . $list . '<b>', __LINE__, __FILE__);

+ }

+

+ $db->sql_query($drop_sql);

+}

+