{

// Set forum flags

$forum_flags = 0;

// FORUM_FLAG_LINK_TRACK

$forum_flags += 0;

// FORUM_FLAG_PRUNE_POLL

$forum_flags += FORUM_FLAG_PRUNE_POLL;

// FORUM_FLAG_PRUNE_ANNOUNCE

$forum_flags += 0;

// FORUM_FLAG_PRUNE_STICKY

$forum_flags += 0;

// FORUM_FLAG_ACTIVE_TOPICS

$forum_flags += 0;

// FORUM_FLAG_POST_REVIEW

$forum_flags += FORUM_FLAG_POST_REVIEW;

return $forum_flags;

{

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

$db->sql_query($convert->truncate_statement . FORUMS_TABLE);

// Determine the highest id used within the old forums table (we add the categories after the forum ids)

$sql = 'SELECT MAX(forum_id) AS max_forum_id

FROM ' . $convert->src_table_prefix . 'forums';

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

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

$src_db->sql_freeresult($result);

$max_forum_id++;

// pruning disabled globally?

$sql = "SELECT config_value

WHERE config_name = 'prune_enable'";

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

$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

ORDER BY cat_order';

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

{

case 'mssql_odbc':

case 'mssqlnative':

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

break;

}

$cats_added = array();

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

{

$sql_ary = array(

'forum_id' => (int) $max_forum_id,

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

'parent_id' => 0,

'forum_parents' => '',

'forum_desc' => '',

'forum_type' => FORUM_CAT,

'forum_status' => ITEM_UNLOCKED,

'forum_rules' => '',

);

$sql = 'SELECT MAX(right_id) AS right_id

FROM ' . FORUMS_TABLE;

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

$cat_row = $db->sql_fetchrow($_result);

$db->sql_freeresult($_result);

$sql_ary['left_id'] = (int) ($cat_row['right_id'] + 1);

$sql_ary['right_id'] = (int) ($cat_row['right_id'] + 2);

$sql = 'INSERT INTO ' . FORUMS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);

$db->sql_query($sql);

$cats_added[$row['cat_id']] = $max_forum_id;

$max_forum_id++;

}

$src_db->sql_freeresult($result);

// There may be installations having forums with non-existant category ids.

// We try to catch them and add them to an "unknown" category instead of leaving them out.

$sql = 'SELECT cat_id

FROM ' . $convert->src_table_prefix . 'forums

GROUP BY cat_id';

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

$unknown_cat_id = false;

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

{

// Catch those categories not been added before

if (!isset($cats_added[$row['cat_id']]))

{

$unknown_cat_id = true;

}

}

$src_db->sql_freeresult($result);

// Is there at least one category not known?

if ($unknown_cat_id === true)

{

$unknown_cat_id = 'ghost';

$sql_ary = array(

'forum_id' => (int) $max_forum_id,

'forum_name' => (string) $user->lang['CATEGORY'],

'parent_id' => 0,

'forum_parents' => '',

'forum_desc' => '',

'forum_type' => FORUM_CAT,

'forum_status' => ITEM_UNLOCKED,

'forum_rules' => '',

);

$sql = 'SELECT MAX(right_id) AS right_id

FROM ' . FORUMS_TABLE;

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

$cat_row = $db->sql_fetchrow($_result);

$db->sql_freeresult($_result);

$sql_ary['left_id'] = (int) ($cat_row['right_id'] + 1);

$sql_ary['right_id'] = (int) ($cat_row['right_id'] + 2);

$sql = 'INSERT INTO ' . FORUMS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);

$db->sql_query($sql);

$cats_added[$unknown_cat_id] = $max_forum_id;

}

// Now insert the forums

$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

LEFT JOIN ' . $convert->src_table_prefix . 'forum_prune fp ON f.forum_id = fp.forum_id

ORDER BY f.cat_id, f.forum_order';

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

{

// Some might have forums here with an id not being "possible"...

// To be somewhat friendly we "change" the category id for those to a previously created ghost category

if (!isset($cats_added[$row['cat_id']]) && $unknown_cat_id !== false)

{

$row['cat_id'] = $unknown_cat_id;

}

if (!isset($cats_added[$row['cat_id']]))

{

continue;

}

// Define the new forums sql ary

$sql_ary = array(

'forum_id' => (int) $row['forum_id'],

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

'parent_id' => (int) $cats_added[$row['cat_id']],

'forum_parents' => '',

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

'enable_prune' => ($prune_enabled) ? (int) $row['prune_enable'] : 0,

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

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

'prune_viewed' => 0,

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

'forum_flags' => phpbb_forum_flags(),

'forum_options' => 0,

// Default values

'forum_desc_bitfield' => '',

'forum_desc_options' => 7,

'forum_desc_uid' => '',

'forum_link' => '',

'forum_password' => '',

'forum_style' => 0,

'forum_image' => '',

'forum_rules' => '',

'forum_rules_link' => '',

'forum_rules_bitfield' => '',

'forum_rules_options' => 7,

'forum_rules_uid' => '',

'forum_topics_per_page' => 0,

'forum_posts_approved' => 0,

'forum_posts_unapproved' => 0,

'forum_posts_softdeleted' => 0,

'forum_topics_approved' => 0,

'forum_topics_unapproved' => 0,

'forum_topics_softdeleted' => 0,

'forum_last_post_id' => 0,

'forum_last_poster_id' => 0,

'forum_last_post_subject' => '',

'forum_last_post_time' => 0,

'forum_last_poster_name' => '',

'forum_last_poster_colour' => '',

'display_on_index' => 1,

'enable_indexing' => 1,

'enable_icons' => 0,

);

// Now add the forums with proper left/right ids

$sql = 'SELECT left_id, right_id

FROM ' . FORUMS_TABLE . '

WHERE forum_id = ' . $cats_added[$row['cat_id']];

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

$cat_row = $db->sql_fetchrow($_result);

$db->sql_freeresult($_result);

$sql = 'UPDATE ' . FORUMS_TABLE . '

WHERE left_id > ' . $cat_row['right_id'];

$db->sql_query($sql);

$sql = 'UPDATE ' . FORUMS_TABLE . '

WHERE ' . $cat_row['left_id'] . ' BETWEEN left_id AND right_id';

$db->sql_query($sql);

$sql_ary['left_id'] = (int) $cat_row['right_id'];

$sql_ary['right_id'] = (int) ($cat_row['right_id'] + 1);

$sql = 'INSERT INTO ' . FORUMS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);

$db->sql_query($sql);

}

$src_db->sql_freeresult($result);

switch ($db->get_sql_layer())

{

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

break;

case 'mssql_odbc':

case 'mssqlnative':

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

break;

case 'oracle':

$result = $db->sql_query('SELECT MAX(forum_id) as max_id FROM ' . FORUMS_TABLE);

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

$db->sql_freeresult($result);

$largest_id = (int) $row['max_id'];

if ($largest_id)

{

$db->sql_query('DROP SEQUENCE ' . FORUMS_TABLE . '_seq');

$db->sql_query('CREATE SEQUENCE ' . FORUMS_TABLE . '_seq START WITH ' . ($largest_id + 1));

}

break;

}

{

global $lang_enc_array, $convert_row;

global $convert, $phpEx;

/*static $lang_enc_array = array(

if (empty($lang_enc_array))

{

$lang_enc_array = array();

}

$get_lang = trim(get_config_value('default_lang'));

// Do we need the users language encoding?

if ($grab_user_lang && !empty($convert_row))

{

if (!empty($convert_row['user_lang']))

{

$get_lang = trim($convert_row['user_lang']);

}

else if (!empty($convert_row['poster_id']))

{

global $src_db, $same_db;

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

{

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

}

$sql = 'SELECT user_lang

FROM ' . $convert->src_table_prefix . 'users

WHERE user_id = ' . (int) $convert_row['poster_id'];

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

}

$get_lang = (!trim($get_lang)) ? trim(get_config_value('default_lang')) : trim($get_lang);

}

}

if (!isset($lang_enc_array[$get_lang]))

{

$filename = $convert->options['forum_path'] . '/language/lang_' . $get_lang . '/lang_main.' . $phpEx;

if (!file_exists($filename))

{

$get_lang = trim(get_config_value('default_lang'));

}

if (!isset($lang_enc_array[$get_lang]))

{

include($convert->options['forum_path'] . '/language/lang_' . $get_lang . '/lang_main.' . $phpEx);

$lang_enc_array[$get_lang] = $lang['ENCODING'];

unset($lang);

}

}

return utf8_recode($text, $lang_enc_array[$get_lang]);

{

if (defined('MOD_BIRTHDAY_TERRA'))

{

$birthday = (string) $birthday;

// stored as month, day, year

if (!$birthday)

{

return ' 0- 0- 0';

}

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

return sprintf('%2d-%2d-%4d', $day, $month, $year);

}

else

{

$birthday = (int) $birthday;

if (!$birthday || $birthday == 999999)

{

return ' 0- 0- 0';

}

// The birthday mod from niels is using this code to transform to day/month/year

return sprintf('%2d-%2d-%4d', gmdate('j', $birthday * 86400 + 1), gmdate('n', $birthday * 86400 + 1), gmdate('Y', $birthday * 86400 + 1));

}

{

global $config;

// Increment user id if the old forum is having a user with the id 1

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

{

global $src_db, $same_db, $convert;

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

{

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

}

// Now let us set a temporary config variable for user id incrementing

$sql = "SELECT user_id

WHERE user_id = 1";

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

}

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

if ($id === 1)

{

$config->set('increment_user_id', ($max_id + 1), false);

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

}

else

{

$config->set('increment_user_id', 0, false);

$config['increment_user_id'] = 0;

}

}

// 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, $config;

if ($mode == 'start')

{

$db->sql_query($convert->truncate_statement . ACL_USERS_TABLE);

$db->sql_query($convert->truncate_statement . ACL_GROUPS_TABLE);

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

ORDER BY user_regdate ASC";

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

$sql = 'SELECT group_id

FROM ' . GROUPS_TABLE . "

WHERE group_name = '" . $db->sql_escape('BOTS') . "'";

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

$bot_group_id = (int) $db->sql_fetchfield('group_id');

$db->sql_freeresult($result);

}

// Grab forum auth information

$sql = "SELECT *

FROM {$convert->src_table_prefix}forums";

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

$forum_access = array();

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

{

$forum_access[$row['forum_id']] = $row;

}

$src_db->sql_freeresult($result);

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

{

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

}

// Grab user auth information from 2.0.x board

$sql = "SELECT ug.user_id, aa.*

AND f.forum_id = aa.forum_id";

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

$user_access = array();

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

{

$user_access[$row['forum_id']][] = $row;

}

$src_db->sql_freeresult($result);

// Grab group auth information

$sql = "SELECT g.group_id, aa.*

AND g.group_single_user <> 1";

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

$group_access = array();

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

{

$group_access[$row['forum_id']][] = $row;

}

$src_db->sql_freeresult($result);

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

{

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

}

// Add Forum Access List

$auth_map = array(

'auth_view' => array('f_', 'f_list'),

'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_reply' => 'f_reply',

'auth_edit' => 'f_edit',

'auth_delete' => 'f_delete',

'auth_pollcreate' => 'f_poll',

'auth_vote' => 'f_vote',

'auth_announce' => array('f_announce', 'f_announce_global'),

'auth_sticky' => 'f_sticky',

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

'auth_download' => 'f_download',

);

// Define the ACL constants used in 2.0 to make the code slightly more readable

define('AUTH_ALL', 0);

define('AUTH_REG', 1);

define('AUTH_ACL', 2);

define('AUTH_MOD', 3);

define('AUTH_ADMIN', 5);

// A mapping of the simple permissions used by 2.0

$simple_auth_ary = array(

'public' => array(

'auth_view' => AUTH_ALL,

'auth_read' => AUTH_ALL,

'auth_post' => AUTH_ALL,

'auth_reply' => AUTH_ALL,

'auth_edit' => AUTH_REG,

'auth_delete' => AUTH_REG,

'auth_sticky' => AUTH_MOD,

'auth_announce' => AUTH_MOD,

'auth_vote' => AUTH_REG,

'auth_pollcreate' => AUTH_REG,

),

'registered' => array(

'auth_view' => AUTH_ALL,

'auth_read' => AUTH_ALL,

'auth_post' => AUTH_REG,

'auth_reply' => AUTH_REG,

'auth_edit' => AUTH_REG,

'auth_delete' => AUTH_REG,

'auth_sticky' => AUTH_MOD,

'auth_announce' => AUTH_MOD,

'auth_vote' => AUTH_REG,

'auth_pollcreate' => AUTH_REG,

),

'registered_hidden' => array(

'auth_view' => AUTH_REG,

'auth_read' => AUTH_REG,

'auth_post' => AUTH_REG,

'auth_reply' => AUTH_REG,

'auth_edit' => AUTH_REG,

'auth_delete' => AUTH_REG,

'auth_sticky' => AUTH_MOD,

'auth_announce' => AUTH_MOD,

'auth_vote' => AUTH_REG,

'auth_pollcreate' => AUTH_REG,

),

'private' => array(

'auth_view' => AUTH_ALL,

'auth_read' => AUTH_ACL,

'auth_post' => AUTH_ACL,

'auth_reply' => AUTH_ACL,

'auth_edit' => AUTH_ACL,

'auth_delete' => AUTH_ACL,

'auth_sticky' => AUTH_ACL,

'auth_announce' => AUTH_MOD,

'auth_vote' => AUTH_ACL,

'auth_pollcreate' => AUTH_ACL,

),

'private_hidden' => array(

'auth_view' => AUTH_ACL,

'auth_read' => AUTH_ACL,

'auth_post' => AUTH_ACL,

'auth_reply' => AUTH_ACL,

'auth_edit' => AUTH_ACL,

'auth_delete' => AUTH_ACL,

'auth_sticky' => AUTH_ACL,

'auth_announce' => AUTH_MOD,

'auth_vote' => AUTH_ACL,

'auth_pollcreate' => AUTH_ACL,

),

'moderator' => array(

'auth_view' => AUTH_ALL,

'auth_read' => AUTH_MOD,

'auth_post' => AUTH_MOD,

'auth_reply' => AUTH_MOD,

'auth_edit' => AUTH_MOD,

'auth_delete' => AUTH_MOD,

'auth_sticky' => AUTH_MOD,

'auth_announce' => AUTH_MOD,

'auth_vote' => AUTH_MOD,

'auth_pollcreate' => AUTH_MOD,

),

'moderator_hidden' => array(

'auth_view' => AUTH_MOD,

'auth_read' => AUTH_MOD,

'auth_post' => AUTH_MOD,

'auth_reply' => AUTH_MOD,

'auth_edit' => AUTH_MOD,

'auth_delete' => AUTH_MOD,

'auth_sticky' => AUTH_MOD,

'auth_announce' => AUTH_MOD,

'auth_vote' => AUTH_MOD,

'auth_pollcreate' => AUTH_MOD,

),

);

if ($mode == 'start')

{

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 . " AND group_id <> $bot_group_id", false);

// Selecting from old table

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

}

}

else if ($mode == 'first')

{

// Go through all 2.0.x forums

foreach ($forum_access as $forum)

{

$new_forum_id = (int) $forum['forum_id'];

// Administrators have full access to all forums whatever happens

mass_auth('group_role', $new_forum_id, 'administrators', 'FORUM_FULL');

$matched_type = '';

foreach ($simple_auth_ary as $key => $auth_levels)

{

$matched = 1;

foreach ($auth_levels as $k => $level)

{

if ($forum[$k] != $auth_levels[$k])

{

$matched = 0;

}

}

if ($matched)

{

$matched_type = $key;

break;

}

}

switch ($matched_type)

{

case 'public':

mass_auth('group_role', $new_forum_id, 'guests', 'FORUM_LIMITED');

mass_auth('group_role', $new_forum_id, 'registered', 'FORUM_LIMITED_POLLS');

mass_auth('group_role', $new_forum_id, 'bots', 'FORUM_BOT');

break;

case 'registered':

mass_auth('group_role', $new_forum_id, 'guests', 'FORUM_READONLY');

mass_auth('group_role', $new_forum_id, 'bots', 'FORUM_BOT');

// no break;

case 'registered_hidden':

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

break;

case 'private':

case 'private_hidden':

case 'moderator':

case 'moderator_hidden':

default:

// The permissions don't match a simple set, so we're going to have to map them directly

// No post approval for all, in 2.0.x this feature does not exist

mass_auth('group', $new_forum_id, 'guests', 'f_noapprove', ACL_YES);

mass_auth('group', $new_forum_id, 'registered', 'f_noapprove', ACL_YES);

// Go through authentication map

foreach ($auth_map as $old_auth_key => $new_acl)

{

// If old authentication key does not exist we continue

// This is helpful for mods adding additional authentication fields, we need to add them to the auth_map array

if (!isset($forum[$old_auth_key]))

{

continue;

}

// Now set the new ACL correctly

switch ($forum[$old_auth_key])

{

// AUTH_ALL

case AUTH_ALL:

mass_auth('group', $new_forum_id, 'guests', $new_acl, ACL_YES);

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

mass_auth('group', $new_forum_id, 'registered', $new_acl, ACL_YES);

break;

// AUTH_REG

case AUTH_REG:

mass_auth('group', $new_forum_id, 'registered', $new_acl, ACL_YES);

break;

// AUTH_ACL

case AUTH_ACL:

// Go through the old group access list for this forum

if (isset($group_access[$forum['forum_id']]))

{

foreach ($group_access[$forum['forum_id']] as $index => $access)

{

// We only check for ACL_YES equivalence entry

if (isset($access[$old_auth_key]) && $access[$old_auth_key] == 1)

{

mass_auth('group', $new_forum_id, (int) $access['group_id'], $new_acl, ACL_YES);

}

}

}

if (isset($user_access[$forum['forum_id']]))

{

foreach ($user_access[$forum['forum_id']] as $index => $access)

{

// We only check for ACL_YES equivalence entry

if (isset($access[$old_auth_key]) && $access[$old_auth_key] == 1)

{

mass_auth('user', $new_forum_id, (int) phpbb_user_id($access['user_id']), $new_acl, ACL_YES);

}

}

}

break;

// AUTH_MOD

case AUTH_MOD:

if (isset($group_access[$forum['forum_id']]))

{

foreach ($group_access[$forum['forum_id']] as $index => $access)

{

// We only check for ACL_YES equivalence entry

if (isset($access[$old_auth_key]) && $access[$old_auth_key] == 1)

{

mass_auth('group', $new_forum_id, (int) $access['group_id'], $new_acl, ACL_YES);

}

}

}

if (isset($user_access[$forum['forum_id']]))

{

foreach ($user_access[$forum['forum_id']] as $index => $access)

{

// We only check for ACL_YES equivalence entry

if (isset($access[$old_auth_key]) && $access[$old_auth_key] == 1)

{

mass_auth('user', $new_forum_id, (int) phpbb_user_id($access['user_id']), $new_acl, ACL_YES);

}

}

}

break;

}

}

break;

}

}

}

else if ($mode == 'second')

{

// Assign permission roles and other default permissions

// guests having u_download and u_search ability

$db->sql_query('INSERT INTO ' . ACL_GROUPS_TABLE . ' (group_id, forum_id, auth_option_id, auth_role_id, auth_setting) SELECT ' . get_group_id('guests') . ', 0, auth_option_id, 0, 1 FROM ' . ACL_OPTIONS_TABLE . " WHERE auth_option IN ('u_', 'u_download', 'u_search')");

// administrators/global mods having full user features

mass_auth('group_role', 0, 'administrators', 'USER_FULL');

mass_auth('group_role', 0, 'global_moderators', 'USER_FULL');

// By default all converted administrators are given full access

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

// All registered users are assigned the standard user role

mass_auth('group_role', 0, 'registered', 'USER_STANDARD');

mass_auth('group_role', 0, 'registered_coppa', 'USER_STANDARD');

// Instead of administrators being global moderators we give the MOD_FULL role to global mods (admins already assigned to this group)

mass_auth('group_role', 0, 'global_moderators', 'MOD_FULL');

// And now those who have had their avatar rights removed get assigned a more restrictive role

$sql = 'SELECT user_id FROM ' . $convert->src_table_prefix . 'users

AND user_id > 0';

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

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

{

mass_auth('user_role', 0, (int) phpbb_user_id($row['user_id']), 'USER_NOAVATAR');

}

$src_db->sql_freeresult($result);

// And the same for those who have had their PM rights removed

$sql = 'SELECT user_id FROM ' . $convert->src_table_prefix . 'users

AND user_id > 0';

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

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

{

mass_auth('user_role', 0, (int) phpbb_user_id($row['user_id']), 'USER_NOPM');

}

$src_db->sql_freeresult($result);

}

else if ($mode == 'third')

{

// And now the moderators

// 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_announce' => array('f_announce', 'f_announce_global'),

'auth_sticky' => 'f_sticky'

);

foreach ($user_access as $forum_id => $access_map)

{

$forum_id = (int) $forum_id;

foreach ($access_map as $access)

{

if (isset($access['auth_mod']) && $access['auth_mod'] == 1)

{

mass_auth('user_role', $forum_id, (int) phpbb_user_id($access['user_id']), 'MOD_STANDARD');