+<?php

+/**

+*

+* @package install

+* @version $Id$

+* @copyright (c) 2006 phpBB Group

+* @license http://opensource.org/licenses/gpl-license.php GNU Public License

+*

+*/

+

+/**

+* Helper functions for phpBB 2.0.x to phpBB 3.0.x conversion

+*/

+

+/**

+* Set forum flags - only prune old polls by default

+*/

+function phpbb_forum_flags()

+{

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

+}

+

+/**

+* Insert/Convert forums

+*/

+function phpbb_insert_forums()

+{

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

+

+ $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 = $db->sql_query($sql);

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

+ $db->sql_freeresult($result);

+

+ $max_forum_id++;

+

+ // Insert categories

+ $sql = 'SELECT cat_id, cat_title

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

+ ORDER BY cat_order';

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

+

+ $cats_added = array();

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

+ {

+ $sql_ary = array(

+ 'forum_id' => $max_forum_id,

+ 'forum_name' => ($row['cat_title']) ? htmlspecialchars(phpbb_set_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'] = $cat_row['right_id'] + 1;

+ $sql_ary['right_id'] = $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++;

+ }

+ $db->sql_freeresult($result);

+

+ // Now insert the forums

+ $sql = 'SELECT f.*, 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

+ GROUP BY f.forum_id

+ ORDER BY f.cat_id, f.forum_order';

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

+

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

+ {

+ // Define the new forums sql ary

+ $sql_ary = array(

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

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

+ 'parent_id' => $cats_added[$row['cat_id']],

+ 'forum_parents' => '',

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

+ 'forum_type' => FORUM_POST,

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

+ 'enable_prune' => $row['prune_enable'],

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

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

+ 'prune_viewed' => 0,

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

+

+ 'forum_flags' => phpbb_forum_flags(),

+

+ // 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' => 0,

+ 'forum_topics' => 0,

+ 'forum_topics_real' => 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 . '

+ SET left_id = left_id + 2, right_id = right_id + 2

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

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . FORUMS_TABLE . '

+ SET right_id = right_id + 2

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

+ $db->sql_query($sql);

+

+ $sql_ary['left_id'] = $cat_row['right_id'];

+ $sql_ary['right_id'] = $cat_row['right_id'] + 1;

+

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

+ $db->sql_query($sql);

+ }

+ $db->sql_freeresult($result);

+}

+

+function phpbb_set_encoding($text)

+{

+ global $lang_enc_array, $config;

+

+ if (!isset($lang_enc_array[$config['default_lang']]))

+ {

+ global $phpEx, $convert;

+

+ include($convert->convertor_status['forum_path'] . '/language/lang_' . $config['default_lang'] . '/lang_main.' . $phpEx);

+ $lang_enc_array[$config['default_lang']] = $lang['ENCODING'];

+ unset($lang);

+ }

+

+ return utf8_recode($text, $lang_enc_array[$user_lang]);

+}

+

+

+/**

+* Convert Birthday from Birthday MOD to phpBB Format

+* @todo See which birthday MOD's this supports - there appear to be several

+*/

+function phpbb_get_birthday($birthday = '')

+{

+ $birthday = (int) $birthday;

+

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

+ {

+ return ' 0- 0- 0';

+ }

+

+ // @todo Can't this be done with one call to create_date?

+ $bday_day = create_date('j', $birthday * 86400 + 1, 0);

+ $bday_month = create_date('n', $birthday * 86400 + 1, 0);

+ $bday_year = create_date('Y', $birthday * 86400 + 1, 0);

+

+ return sprintf('%2d-%2d-%4d', $bday_day, $bday_month, $bday_year);

+}

+

+/**

+* Return correct user id value

+* Everyone's id will be one higher to allow the guest/anonymous user to have a positive id as well

+*/

+function phpbb_user_id($user_id)

+{

+ if (!$user_id)

+ {

+ return 0;

+ }

+

+ if ($user_id == -1)

+ {

+ return ANONYMOUS;

+ }

+

+ global $config;

+

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

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

+ {

+ global $db, $convert;

+

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

+ $sql = "SELECT user_id

+ FROM {$convert->src_table_prefix}users

+ WHERE user_id = 1";

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

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

+ $db->sql_freeresult($result);

+

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

+ if ($id === 1)

+ {

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

+ $config['increment_user_id'] = 1;

+ }

+ else

+ {

+ set_config('increment_user_id', 0, true);

+ $config['increment_user_id'] = 0;

+ }

+ }

+

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

+ {

+ $user_id++;

+ }

+

+ return $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()

+{

+}

+*/

+

+/**

+* Convert authentication

+* user, group and forum table has to be filled in order to work

+*/

+function phpbb_convert_authentication($mode)

+{

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

+

+ if ($mode == 'start')

+ {

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

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

+

+ // Grab user id of first user with user_level of ADMIN

+ $sql = "SELECT user_id

+ FROM {$convert->src_table_prefix}users

+ WHERE user_level = 1

+ ORDER BY user_regdate ASC";

+ $result = $db->sql_query_limit($sql, 1);

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

+ $db->sql_freeresult($result);

+

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

+

+ // Set a founder admin ... we'll assume it's the first user with admin level access

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_type = ' . USER_FOUNDER . "

+ WHERE user_id = $founder_id";

+ $db->sql_query($sql);

+ }

+

+ // Grab forum auth information

+ $sql = "SELECT *

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

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

+

+ $forum_access = array();

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

+ {

+ $forum_access[] = $row;

+ }

+ $db->sql_freeresult($result);

+

+ // Grab user auth information from 2.0.x board

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

+ FROM {$convert->src_table_prefix}auth_access aa, {$convert->src_table_prefix}user_group ug, {$convert->src_table_prefix}groups g

+ WHERE g.group_id = aa.group_id

+ AND g.group_single_user = 1

+ AND ug.group_id = g.group_id";

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

+

+ $user_access = array();

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

+ {

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

+ }

+ $db->sql_freeresult($result);

+

+ // Grab group auth information

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

+ FROM {$convert->src_table_prefix}auth_access aa, {$convert->src_table_prefix}groups g

+ WHERE g.group_id = aa.group_id

+ AND g.group_single_user <> 1";

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

+

+ $group_access = array();

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

+ {

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

+ }

+ $db->sql_freeresult($result);

+

+ // Add Forum Access List

+ $auth_map = array(

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

+ 'auth_read' => 'f_read',

+ 'auth_post' => array('f_post', 'f_bbcode', 'f_smilies', 'f_img', 'f_sigs', 'f_search', 'f_postcount'),

+ 'auth_reply' => 'f_reply',

+ 'auth_edit' => 'f_edit',

+ 'auth_delete' => 'f_delete',

+ 'auth_pollcreate' => 'f_poll',

+ 'auth_vote' => 'f_vote',

+ 'auth_announce' => 'f_announce',

+ 'auth_sticky' => 'f_sticky',

+ 'auth_attachments' => 'f_attach',

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

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

+

+ // Selecting from old table

+ $auth_sql = 'SELECT ';

+ $auth_sql .= (!empty($config['increment_user_id'])) ? 'user_id + 1 as user_id' : 'user_id';

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

+

+ user_group_auth('administrators', $auth_sql);

+ }

+ else if ($mode == 'first')

+ {

+ // Go through all 2.0.x forums (we saved those ids for reference)

+ 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_LIMITED_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, '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, $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, 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, $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, phpbb_user_id($access['user_id']), $new_acl, ACL_YES);

+ }

+ }

+ }

+ break;

+ }

+ }

+ break;

+ }

+ }

+ }

+ else if ($mode == 'second')

+ {

+ // Assign permission roles

+

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

+ // @todo Review the implications of this - we might want to remove access to clear logs, view phpinfo, etc

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

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

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

+

+ // All registered users are assigned the standard user role

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

+

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

+ WHERE user_allowavatar = 0

+ AND user_id > 0';

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

+

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

+ {

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

+ }

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

+ WHERE user_allow_pm = 0

+ AND user_id > 0';

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

+

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

+ {

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

+ }

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

+ 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, phpbb_user_id($access['user_id']), 'MOD_STANDARD');

+ mass_auth('user_role', $forum_id, phpbb_user_id($access['user_id']), 'FORUM_STANDARD');

+ }

+ }

+ }

+

+ foreach ($group_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('group_role', $forum_id, $access['group_id'], 'MOD_STANDARD');

+ mass_auth('group_role', $forum_id, $access['group_id'], 'FORUM_STANDARD');

+ }

+ }

+ }

+

+ // We grant everyone readonly access to the categories to ensure that the forums are visible

+ $sql = 'SELECT forum_id, forum_name, parent_id, left_id, right_id

+ FROM ' . FORUMS_TABLE . '

+ ORDER BY left_id ASC';

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

+

+ $parent_forums = $forums = array();

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

+ {

+ if ($row['parent_id'] == 0)

+ {

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

+ $parent_forums[] = $row;

+ }

+ else

+ {

+ $forums[] = $row;

+ }

+ }

+ $db->sql_freeresult($result);

+

+ global $auth;

+

+ // Let us see if guests/registered users have access to these forums...

+ foreach ($parent_forums as $row)

+ {

+ // Get the childs...

+ $branch = $forum_ids = array();

+

+ foreach ($forums as $key => $_row)

+ {

+ if ($_row['left_id'] > $row['left_id'] && $_row['left_id'] < $row['right_id'])

+ {

+ $branch[] = $_row;

+ $forum_ids[] = $_row['forum_id'];

+ continue;

+ }

+ }

+

+ // Now make sure the user is able to read these forums

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

+

+ if (!empty($hold_ary))

+ {

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

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

+ }

+ }

+ }

+}

+

+/**

+* Set primary group.

+* Really simple and only based on user_level (remaining groups will be assigned later)

+*/

+function phpbb_set_primary_group($user_level)

+{

+ global $convert_row;

+

+ if ($user_level == 1)

+ {

+ return get_group_id('administrators');

+ }

+/* else if ($user_level == 2)

+ {

+ return get_group_id('global_moderators');

+ }

+ else if ($user_level == 0 && $convert_row['user_active'])*/

+ else if ($convert_row['user_active'])

+ {

+ return get_group_id('registered');

+ }

+

+ return 0;

+}

+

+/**

+* Convert the group name, making sure to avoid conflicts with 3.0 special groups

+*/

+function phpbb_convert_group_name($group_name)

+{

+ $default_groups = array(

+ 'GUESTS',

+ 'REGISTERED',

+ 'REGISTERED_COPPA',

+ 'GLOBAL_MODERATORS',

+ 'ADMINISTRATORS',

+ 'BOTS',

+ );

+

+ if (in_array(strtoupper($group_name), $default_groups))

+ {

+ return 'phpBB2 - ' . $group_name;

+ }

+

+ return phpbb_set_encoding($group_name);

+}

+

+/**

+* Convert the group type constants

+*/

+function phpbb_convert_group_type($group_type)

+{

+ switch ($group_type)

+ {

+ case 0:

+ return GROUP_OPEN;

+ break;

+

+ case 1:

+ return GROUP_CLOSED;

+ break;

+

+ case 2:

+ return GROUP_HIDDEN;

+ break;

+ }

+

+ return GROUP_SPECIAL;

+}

+

+/**

+* Convert the topic type constants

+*/

+function phpbb_convert_topic_type($topic_type)

+{

+ switch ($topic_type)

+ {

+ case 0:

+ return POST_NORMAL;

+ break;

+

+ case 1:

+ return POST_STICKY;

+ break;

+

+ case 2:

+ return POST_ANNOUNCE;

+ break;

+

+ case 3:

+ return POST_GLOBAL;

+ break;

+ }

+

+ return POST_NORMAL;

+}

+

+/**

+* Reparse the message stripping out the bbcode_uid values and adding new ones and setting the bitfield

+* @todo What do we want to do about HTML in messages - currently it gets converted to the entities, but there may be some objections to this

+*/

+function phpbb_prepare_message($message)

+{

+ global $phpbb_root_path, $phpEx, $db, $convert, $user, $config, $cache, $convert_row, $message_parser;

+ global $lang_enc_array;

+

+ /*static $lang_enc_array = array(

+ 'korean' => 'euc-kr',

+ 'serbian' => 'windows-1250',

+ 'polish' => 'iso-8859-2',

+ 'kurdish' => 'windows-1254',

+ 'slovak' => 'Windows-1250',

+ 'russian' => 'windows-1251',

+ 'estonian' => 'iso-8859-4',

+ 'chinese_simplified' => 'gb2312',

+ 'macedonian' => 'windows-1251',

+ 'azerbaijani' => 'UTF-8',

+ 'romanian' => 'iso-8859-2',

+ 'romanian_diacritice' => 'iso-8859-2',

+ 'lithuanian' => 'windows-1257',

+ 'turkish' => 'iso-8859-9',

+ 'ukrainian' => 'windows-1251',

+ 'japanese' => 'shift_jis',

+ 'hungarian' => 'ISO-8859-2',

+ 'romanian_no_diacritics' => 'iso-8859-2',

+ 'mongolian' => 'UTF-8',

+ 'slovenian' => 'windows-1250',

+ 'bosnian' => 'windows-1250',

+ 'czech' => 'Windows-1250',

+ 'farsi' => 'Windows-1256',

+ 'croatian' => 'windows-1250',

+ 'greek' => 'iso-8859-7',

+ 'russian_tu' => 'windows-1251',

+ 'sakha' => 'UTF-8',

+ 'serbian_cyrillic' => 'windows-1251',

+ 'bulgarian' => 'windows-1251',

+ 'chinese_traditional_taiwan' => 'big5',

+ 'chinese_traditional' => 'big5',

+ 'arabic' => 'windows-1256',

+ 'hebrew' => 'WINDOWS-1255',

+ 'thai' => 'windows-874',

+ //'chinese_traditional_taiwan' => 'utf-8' // custom modified, we may have to do an include :-(

+ );*/

+

+ if (!$message)

+ {

+ $convert->row['mp_bbcode_bitfield'] = $convert_row = 0;

+ return '';

+ }

+

+ // Decode phpBB 2.0.x Message

+ if (isset($convert->row['old_bbcode_uid']) && $convert->row['old_bbcode_uid'] != '')

+ {

+ $message = preg_replace('/\:(([a-z0-9]:)?)' . $convert->row['old_bbcode_uid'] . '/s', '', $message);

+ }

+

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

+ {

+ $message = preg_replace('/\[quote="(.*?)"\]/s', '[quote=&quot;\1&quot;]', $message);

+ }

+

+ $user_id = $convert->row['poster_id'];

+

+ $sql = 'SELECT user_lang

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

+ WHERE user_id = ' . (int) $user_id;

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

+ $user_lang = $db->sql_fetchfield('user_lang');

+ $db->sql_freeresult($result);

+

+ if (empty($lang_enc_array))

+ {

+ $lang_enc_array = array();

+ }

+

+ if (!isset($lang_enc_array[$user_lang]))

+ {

+ $filename = $convert->convertor_status['forum_path'] . '/language/lang_' . $user_lang . '/lang_main.' . $phpEx;

+

+ if (!file_exists($filename))

+ {

+ $user_lang = $config['default_lang'];

+ }

+

+ if (!isset($lang_enc_array[$user_lang]))

+ {

+ include($convert->convertor_status['forum_path'] . '/language/lang_' . $user_lang . '/lang_main.' . $phpEx);

+ $lang_enc_array[$user_lang] = $lang['ENCODING'];

+ unset($lang);

+ }

+ }

+

+ $encoding = $lang_enc_array[$user_lang];

+

+ $message = str_replace('<', '&lt;', $message);

+ $message = str_replace('>', '&gt;', $message);

+ $message = str_replace('<br />', "\n", $message);

+

+ // make the post UTF-8

+ $message = utf8_recode($message, $encoding);

+

+ $message_parser->warn_msg = array(); // Reset the errors from the previous message

+ $message_parser->bbcode_uid = make_uid($convert->row['post_time']);

+ $message_parser->message = $message;

+ unset($message);

+

+ // Make sure options are set.

+// $enable_html = (!isset($row['enable_html'])) ? false : $row['enable_html'];

+ $enable_bbcode = (!isset($convert->row['enable_bbcode'])) ? true : $convert->row['enable_bbcode'];

+ $enable_smilies = (!isset($convert->row['enable_smilies'])) ? true : $convert->row['enable_smilies'];

+ $enable_magic_url = (!isset($convert->row['enable_magic_url'])) ? true : $convert->row['enable_magic_url'];

+

+ // parse($allow_bbcode, $allow_magic_url, $allow_smilies, $allow_img_bbcode = true, $allow_flash_bbcode = true, $allow_quote_bbcode = true, $allow_url_bbcode = true, $update_this_message = true, $mode = 'post')

+ $message_parser->parse($enable_bbcode, $enable_magic_url, $enable_smilies);

+

+ if (sizeof($message_parser->warn_msg))

+ {

+ $msg_id = isset($convert->row['post_id']) ? $convert->row['post_id'] : $convert->row['privmsgs_id'];

+ $convert->p_master->error('<span style="color:red">' . $user->lang['POST_ID'] . ': ' . $msg_id . ' ' . $user->lang['CONV_ERROR_MESSAGE_PARSER'] . ': <br /><br />' . implode('<br />', $message_parser->warn_msg), __LINE__, __FILE__, true);

+ }

+

+ $convert->row['mp_bbcode_bitfield'] = $convert_row['mp_bbcode_bitfield'] = $message_parser->bbcode_bitfield;

+

+ $message = $message_parser->message;

+ unset($message_parser->message);

+

+ return $message;

+}

+

+/**

+* Return the bitfield calculated by the previous function

+*/

+function get_bbcode_bitfield()

+{

+ global $convert_row;

+

+ return $convert_row['mp_bbcode_bitfield'];

+}

+

+/**

+* Determine the last user to edit a post

+* In practice we only tracked edits by the original poster in 2.0.x so this will only be set if they had edited their own post

+*/

+function phpbb_post_edit_user()

+{

+ global $convert_row, $config;

+

+ if (isset($convert_row['post_edit_count']))

+ {

+ return phpbb_user_id($convert_row['poster_id']);

+ }

+

+ return 0;

+}

+

+/**

+* Obtain the path to uploaded files on the 2.0.x forum

+* This is only used if the Attachment MOD was installed

+*/

+function phpbb_get_files_dir()

+{

+ if (!defined('MOD_ATTACHMENT'))

+ {

+ return;

+ }

+

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

+

+ $sql = 'SELECT config_value AS upload_dir

+ FROM ' . $convert->src_table_prefix . "attachments_config

+ WHERE config_name = 'upload_dir'";

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

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

+ $db->sql_freeresult($result);

+

+ $sql = 'SELECT config_value AS ftp_upload

+ FROM ' . $convert->src_table_prefix . "attachments_config

+ WHERE config_name = 'allow_ftp_upload'";

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

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

+ $db->sql_freeresult($result);

+

+ if ($ftp_upload)

+ {

+ $convert->p_master->error($user->lang['CONV_ERROR_ATTACH_FTP_DIR'], __LINE__, __FILE__);

+ }

+

+ return $upload_path;

+}

+

+/**

+* Copy thumbnails of uploaded images from the 2.0.x forum

+* This is only used if the Attachment MOD was installed

+*/

+function phpbb_copy_thumbnails()

+{

+ global $db, $convert, $user, $config, $cache, $phpbb_root_path;

+

+ $src_path = $convert->convertor_status['forum_path'] . '/' . phpbb_get_files_dir() . '/thumbs/';

+

+ if ($handle = @opendir($src_path))

+ {

+ while ($entry = readdir($handle))

+ {

+ if ($entry[0] == '.')

+ {

+ continue;

+ }

+

+ if (is_dir($src_path . $entry))

+ {

+ continue;

+ }

+ else

+ {

+ copy_file($src_path . $entry, $config['upload_path'] . '/' . preg_replace('/^t_/', 'thumb_', $entry));

+ @unlink($phpbb_root_path . $config['upload_path'] . '/thumbs/' . $entry);

+ }

+ }

+ closedir($handle);

+ }

+}

+

+/**

+* Convert the attachment category constants

+* This is only used if the Attachment MOD was installed

+*/

+function phpbb_attachment_category($cat_id)

+{

+ switch ($cat_id)

+ {

+ case 1:

+ return ATTACHMENT_CATEGORY_IMAGE;

+ break;

+

+ case 2:

+ return ATTACHMENT_CATEGORY_WM;

+ break;

+

+ case 3:

+ return ATTACHMENT_CATEGORY_FLASH;

+ break;

+ }

+

+ return ATTACHMENT_CATEGORY_NONE;

+}

+

+/**

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

+*/

+function phpbb_attachment_forum_perms($forum_permissions)

+{

+ if (empty($forum_permissions))

+ {

+ return '';

+ }

+

+ // Decode forum permissions

+ $forum_ids = array();

+

+ $one_char_encoding = '#';

+ $two_char_encoding = '.';

+

+ $auth_len = 1;

+ for ($pos = 0; $pos < strlen($forum_permissions); $pos += $auth_len)

+ {

+ $forum_auth = substr($forum_permissions, $pos, 1);

+ if ($forum_auth == $one_char_encoding)

+ {

+ $auth_len = 1;

+ continue;

+ }

+ else if ($forum_auth == $two_char_encoding)

+ {

+ $auth_len = 2;

+ $pos--;

+ continue;

+ }

+

+ $forum_auth = substr($forum_permissions, $pos, $auth_len);

+ $forum_id = base64_unpack($forum_auth);

+

+ $forum_ids[] = (int) $forum_id;

+ }

+

+ if (sizeof($forum_ids))

+ {

+ return attachment_forum_perms($forum_ids);

+ }

+

+ return '';

+}

+

+/**

+* Convert the avatar type constants

+*/

+function phpbb_avatar_type($type)

+{

+ switch ($type)

+ {

+ case 1:

+ return AVATAR_UPLOAD;

+ break;

+

+ case 2:

+ return AVATAR_REMOTE;

+ break;

+

+ case 3:

+ return AVATAR_GALLERY;

+ break;

+ }

+

+ return 0;

+}

+

+/**

+* Transfer avatars, copying the image if it was uploaded

+*/

+function phpbb_import_avatar($user_avatar)

+{

+ global $convert_row;

+

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

+ {

+ return '';

+ }

+ else if ($convert_row['user_avatar_type'] == 1)

+ {

+ // Uploaded avatar

+ return import_avatar($user_avatar, '');

+ }

+ else if ($convert_row['user_avatar_type'] == 2)

+ {

+ // Remote avatar

+ return $user_avatar;

+ }

+ else if ($convert_row['user_avatar_type'] == 3)

+ {

+ // Gallery avatar

+ return $user_avatar;

+ }

+

+ return '';

+}

+

+/**

+* Calculate the correct to_address field for private messages

+*/

+function phpbb_privmsgs_to_userid($to_userid)

+{

+ global $config;

+

+ return 'u_' . phpbb_user_id($to_userid);

+}

+

+/**

+* Calculate whether a private message was unread using the bitfield

+*/

+function phpbb_unread_pm($pm_type)

+{

+ return ($pm_type == 5) ? 1 : 0;

+}

+

+/**

+* Calculate whether a private message was new using the bitfield

+*/

+function phpbb_new_pm($pm_type)

+{

+ return ($pm_type == 1) ? 1 : 0;

+}

+

+/**

+* Obtain the folder_id for the custom folder created to replace the savebox from 2.0.x (used to store saved private messages)

+*/

+function phpbb_get_savebox_id($user_id)

+{

+ global $db;

+

+ $user_id = phpbb_user_id($user_id);

+

+ // Only one custom folder, check only one

+ $sql = 'SELECT folder_id

+ FROM ' . PRIVMSGS_FOLDER_TABLE . '

+ WHERE user_id = ' . $user_id;

+ $result = $db->sql_query_limit($sql, 1);

+ $folder_id = (int) $db->sql_fetchfield('folder_id');

+ $db->sql_freeresult($result);

+

+ return $folder_id;

+}

+

+/**

+* Transfer attachment specific configuration options

+* These were not stored in the main config table on 2.0.x

+* This is only used if the Attachment MOD was installed

+*/

+function phpbb_import_attach_config()

+{

+ global $db, $convert, $config;

+

+ $sql = 'SELECT *

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

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

+

+ $attach_config = array();

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

+ {

+ $attach_config[$row['config_name']] = $row['config_value'];

+ }

+ $db->sql_freeresult($result);

+

+ set_config('allow_attachments', 1);

+ set_config('display_order', $attach_config['display_order']);

+ set_config('max_filesize', $attach_config['max_filesize']);

+ set_config('max_filesize_pm', $attach_config['max_filesize_pm']);

+ set_config('attachment_quota', $attach_config['attachment_quota']);

+ set_config('max_attachments', $attach_config['max_attachments']);

+ set_config('max_attachments_pm', $attach_config['max_attachments_pm']);

+ set_config('allow_pm_attach', $attach_config['allow_pm_attach']);

+

+ set_config('img_display_inlined', $attach_config['img_display_inlined']);

+ set_config('img_max_width', $attach_config['img_max_width']);

+ set_config('img_max_height', $attach_config['img_max_height']);

+ set_config('img_link_width', $attach_config['img_link_width']);

+ set_config('img_link_height', $attach_config['img_link_height']);

+ set_config('img_create_thumbnail', $attach_config['img_create_thumbnail']);

+ set_config('img_max_thumb_width', 400);

+ set_config('img_min_thumb_filesize', $attach_config['img_min_thumb_filesize']);

+ set_config('img_imagick', $attach_config['img_imagick']);

+}

+

+/**

+* Calculate the date a user became inactive

+*/

+function phpbb_inactive_time()

+{

+ global $convert_row;

+

+ if ($convert_row['user_active'])

+ {

+ return 0;

+ }

+

+ if ($convert_row['user_lastvisit'])

+ {

+ return $convert_row['user_lastvisit'];

+ }

+

+ return $convert_row['user_regdate'];

+}

+

+/**

+* Calculate the reason a user became inactive

+* We can't actually tell the difference between a manual deactivation and one for profile changes

+* from the data available to assume the latter

+*/

+function phpbb_inactive_reason()

+{

+ global $convert_row;

+

+ if ($convert_row['user_active'])

+ {

+ return 0;

+ }

+

+ if ($convert_row['user_lastvisit'])

+ {

+ return INACTIVE_PROFILE;

+ }

+

+ return INACTIVE_REGISTER;

+}

+

+?> \ No newline at end of file