*/

$convertor_data = array(

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

'author' => '<a href="http://www.phpbb.com/">phpBB Group</a>',

'dbms' => $dbms,

'dbhost' => $dbhost,

{

$src_db->sql_freeresult($result);

}

/**

* Tests for further MODs can be included here.

* - empty string == execute nothing

* - string == function to execute

* - array == complex execution instructions

* Complex execution instructions:

* @todo test complex execution instructions - in theory they will work fine

*

array('target', $convert->truncate_statement . SEARCH_WORDMATCH_TABLE),

array('target', $convert->truncate_statement . LOG_TABLE),

),

// with this you are able to import all attachment files on the fly. For large boards this is not an option, therefore commented out by default.

// Instead every file gets copied while processing the corresponding attachment entry.

// if (defined("MOD_ATTACHMENT")) { import_attachment_files(); phpbb_copy_thumbnails(); }

array('poll_max_options', 1, ''),

array('poll_vote_change', 0, ''),

'topics LEFT JOIN posts ON topics.topic_last_post_id = posts.post_id',

),

'where' => 'topics.topic_moved_id = 0',

array('user_id', 'users.user_id', 'phpbb_user_id'),

array('folder_name', $user->lang['CONV_SAVED_MESSAGES'], ''),

array('pm_count', 0, ''),

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

),

'where' => 'privmsgs.privmsgs_id = privmsgs_text.privmsgs_text_id

AND (privmsgs.privmsgs_type = 0 OR privmsgs.privmsgs_type = 1 OR privmsgs.privmsgs_type = 5)',

),

// Outbox

array(

'target' => PRIVMSGS_TO_TABLE,

*

*/

// Return if we "just include it" to find out for which version the database update is responsible for

if (defined('IN_PHPBB') && defined('IN_INSTALL'))

// Include essential scripts

include($phpbb_root_path . 'config.' . $phpEx);

{

die("Please read: <a href='../docs/INSTALL.html'>INSTALL.html</a> before attempting to update.");

}

GROUPS_TABLE => array('group_legend'),

),

),

);

// Determine mapping database type

}

$db->sql_freeresult($result);

echo $lang['PREVIOUS_VERSION'] . ' :: <strong>' . $config['version'] . '</strong><br />';

echo $lang['UPDATED_VERSION'] . ' :: <strong>' . $updates_to_version . '</strong></p>';

// Checks/Operations that have to be completed prior to starting the update itself

$exit = false;

{

// Define missing language entries...

if (!isset($lang['CLEANING_USERNAMES']))

foreach ($user_ids as $i => $user_id)

{

$row = $users[$user_id];

$rank_title = $rank_img = '';

get_user_rank($row['user_rank'], $row['user_posts'], $rank_title, $rank_img, $rank_img_src);

$next_version = (isset($versions[$i + 1])) ? $versions[$i + 1] : $updates_to_version;

{

continue;

}

{

continue;

}

flush();

$no_updates = true;

// some code magic

for ($i = 0; $i < sizeof($versions); $i++)

continue;

}

}

_write_result($no_updates, $errored, $error_ary);

flush();

// update the version

$sql = "UPDATE " . CONFIG_TABLE . "

SET config_value = '$updates_to_version'

user_perm_from = 0";

_sql($sql, $errored, $error_ary);

/* Optimize/vacuum analyze the tables where appropriate

// this should be done for each version in future along with

// the version number update

</div>

</div>

</div>

<div id="page-footer">

Powered by phpBB &copy; 2000, 2002, 2005, 2007 <a href="http://www.phpbb.com/">phpBB Group</a>

</div>

/**

* Function where all data changes are executed

*/

{

global $db, $map_dbms, $errored, $error_ary, $config, $phpbb_root_path;

$smileys[$row['smiley_id']] = $row['code'];

}

$db->sql_freeresult($result);

foreach ($smileys as $id => $code)

{

// 2.0 only entitized lt and gt; We need to do something about double quotes.

sql_create_index($map_dbms, 'ath_op_id', ACL_ROLES_DATA_TABLE, array('auth_option_id'));

}

break;

case '3.0.RC3':

set_config('allow_birthdays', '1');

set_config('cron_lock', '0', true);

break;

case '3.0.RC4':

set_config('ldap_port', '');

set_config('ldap_user_filter', '');

break;

case '3.0.RC5':

$sql = 'SELECT forum_id, forum_password

FROM ' . FORUMS_TABLE;

$result = _sql($sql, $errored, $error_ary);

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

{

if (!empty($row['forum_password']))

}

}

$db->sql_freeresult($result);

$db->sql_transaction('commit');

break;

case '3.0.0':

SET topic_last_view_time = topic_last_post_time

WHERE topic_last_view_time = 0";

_sql($sql, $errored, $error_ary);

// Update smiley sizes

$smileys = array('icon_e_surprised.gif', 'icon_eek.gif', 'icon_cool.gif', 'icon_lol.gif', 'icon_mad.gif', 'icon_razz.gif', 'icon_redface.gif', 'icon_cry.gif', 'icon_evil.gif', 'icon_twisted.gif', 'icon_rolleyes.gif', 'icon_exclaim.gif', 'icon_question.gif', 'icon_idea.gif', 'icon_arrow.gif', 'icon_neutral.gif', 'icon_mrgreen.gif', 'icon_e_ugeek.gif');

if (file_exists($phpbb_root_path . 'images/smilies/' . $smiley))

{

list($width, $height) = getimagesize($phpbb_root_path . 'images/smilies/' . $smiley);

$sql = 'UPDATE ' . SMILIES_TABLE . '

SET smiley_width = ' . $width . ', smiley_height = ' . $height . "

WHERE smiley_url = '" . $db->sql_escape($smiley) . "'";

_sql($sql, $errored, $error_ary);

}

}

break;

}

}

if (isset($convertor_data))

{

$sort[strtolower($convertor_data['forum_name'])] = sizeof($convertors);

$convertors[] = array(

'tag' => $m[1],

'forum_name' => $convertor_data['forum_name'],

function convert_data($sub)

{

global $template, $user, $phpbb_root_path, $phpEx, $db, $lang, $config, $cache;

require($phpbb_root_path . 'config.' . $phpEx);

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

{

$table = $convert->src_table_prefix . $m[1];

$tables_list[$table] = $table;

if (!empty($m[3]))

{

$aliases[] = $convert->src_table_prefix . $m[3];

// Throw an error if some tables are missing

// We used to do some guessing here, but since we have a suggestion of possible values earlier, I don't see it adding anything here to do it again

if (sizeof($missing_tables) == sizeof($tables_list))

{

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

if ($errored)

{

$db->sql_return_on_error(true);

// Because it errored out we will try to insert the rows one by one... most of the time this

// is caused by duplicate entries - but we also do not want to miss one...

foreach ($waiting_rows as $waiting_sql)

'TITLE' => $user->lang['UPDATE_TOPICS_POSTED'],

'RESULT' => $user->lang['DONE'],

));

if ($db->sql_error_triggered)

{

$template->assign_vars(array(

));

}

$db->sql_return_on_error(false);

$this->finish_conversion();

return;

}

$firstkey_set = false;

$firstkey = 0;

foreach ($fields[1] as $inner_key => $inner_value)

{

if (!$firstkey_set)

{

$sql_flag = true;

}

// No function assigned?

if (empty($fields[2]))

{

// HTTP_HOST is having the correct browser url in most cases...

$server_name = (!empty($_SERVER['HTTP_HOST'])) ? strtolower($_SERVER['HTTP_HOST']) : ((!empty($_SERVER['SERVER_NAME'])) ? $_SERVER['SERVER_NAME'] : getenv('SERVER_NAME'));

$data['email_enable'] = ($data['email_enable'] !== '') ? $data['email_enable'] : true;

$data['server_name'] = ($data['server_name'] !== '') ? $data['server_name'] : $server_name;

$data['server_port'] = ($data['server_port'] !== '') ? $data['server_port'] : ((!empty($_SERVER['SERVER_PORT'])) ? (int) $_SERVER['SERVER_PORT'] : (int) getenv('SERVER_PORT'));

// HTTP_HOST is having the correct browser url in most cases...

$server_name = (!empty($_SERVER['HTTP_HOST'])) ? strtolower($_SERVER['HTTP_HOST']) : ((!empty($_SERVER['SERVER_NAME'])) ? $_SERVER['SERVER_NAME'] : getenv('SERVER_NAME'));

$cookie_domain = ($data['server_name'] != '') ? $data['server_name'] : $server_name;

// Try to come up with the best solution for cookie domain...

INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd_foreground_noise', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd_x_grid', '25');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('captcha_gd_y_grid', '25');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('check_dnsbl', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('chg_passforce', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_name_chars', '3');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_pass_chars', '6');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('min_search_author_chars', '3');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pass_complex', 'PASS_TYPE_ANY');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_edit_time', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('queue_interval', '600');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('ranks_path', 'images/ranks');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_block_size', '250');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('search_gc', '7200');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('tpl_allow_php', '0');

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 ('warnings_expire_days', '90');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_gc', '14400');