<?php

@set_time_limit(2400);
ob_end_clean();
//
//
//
$db = $dbhost = $dbuser = $dbpasswd = $dbport = $dbname = '';

define('IN_PHPBB', 1);
$phpbb_root_path='./../';

include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'config.'.$phpEx);
include($phpbb_root_path . 'includes/functions.'.$phpEx);
include($phpbb_root_path . 'db/' . $dbms . '.'.$phpEx);

$db = new sql_db($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false);

//
// Updates to this version ...
//
$version = '2.1.1 [20030221]';

// ----------------
// BEGIN VARS DEFNS
//
define('ACL_DENY', 2);
define('ACL_ALLOW', 4);
define('ACL_PERMIT', 8);

define('AUTH_ALL', 0);
define('AUTH_REG', 1);
define('AUTH_ACL', 2);
define('AUTH_MOD', 3);
define('AUTH_ADMIN', 5);

define('ANONYMOUS', 1);

$auth_map = array(
	'auth_view' => 'forum_list',
	'auth_read' => 'forum_read',
	'auth_post' => 'forum_post',
	'auth_reply' => 'forum_reply',
	'auth_edit' => 'forum_edit',
	'auth_delete' => 'forum_delete',
	'auth_pollcreate' => 'forum_poll',
	'auth_vote' => 'forum_vote',
	'auth_announce' => 'forum_announce',
	'auth_sticky' => 'forum_sticky',
	'auth_attachments' => 'forum_attach',
	'auth_download' => 'forum_download',
);

$auth_options = array(
	'forum_list',
	'forum_read',
	'forum_post',
	'forum_reply',
	'forum_edit',
	'forum_delete',
	'forum_poll',
	'forum_vote',
	'forum_announce',
	'forum_sticky',
	'forum_attach',
	'forum_download',
	'forum_html',
	'forum_bbcode',
	'forum_smilies',
	'forum_img',
	'forum_flash',
	'forum_sigs',
	'forum_search',
	'forum_email',
	'forum_rate',
	'forum_print',
	'forum_ignoreflood',
	'forum_ignorequeue'
);

$auth_mod_options = array(
	'mod_edit',
	'mod_delete',
	'mod_move',
	'mod_lock',
	'mod_split',
	'mod_merge',
	'mod_approve',
	'mod_unrate',
	'mod_auth'
);

$auth_admin_options = array(
	'admin_general',
	'admin_user',
	'admin_group',
	'admin_forum',
	'admin_post',
	'admin_ban',
	'admin_auth',
	'admin_email',
	'admin_styles',
	'admin_backup',
	'admin_clearlogs'
);

$new_groups = array(
	'guest_id' => "INSERT INTO " . $table_prefix . "groups (group_name, group_type) VALUES ('GUESTS', 0)",
	'reg_inactive_id' => "INSERT INTO " . $table_prefix . "groups (group_name, group_type) VALUES ('REGISTERED_INACTIVE', 0)",
	'reg_id' => "INSERT INTO " . $table_prefix . "groups (group_name, group_type) VALUES ('REGISTERED', 0)",
	'super_mod_id' => "INSERT INTO " . $table_prefix . "groups (group_name, group_type) VALUES ('SUPER_MODERATORS', 0)",
	'admin_id' => "INSERT INTO " . $table_prefix . "groups (group_name, group_type) VALUES ('ADMINISTRATORS', 0)"
);
//
// END VAR DEFNS
// -------------

$sql = "SELECT config_value
	FROM " . $table_prefix . "config
	WHERE config_name = 'version'";
$result = $db->sql_query($sql);

$row = $db->sql_fetchrow($result);
$this_version = $row['config_value'];

//
// Output page header
//
page_header();

?>

<h1>Pre-schema update data changes</h1>

<?php

switch ($this_version)
{
	case '.0.0':
	case '.0.1':
	case '.0.2':
	case '.1.0 [20020402]':
	case '.1.0 [20020420]':
	case '.1.0 [20020421]':
	case '.1.0 [20020430]':
	case '2.1.0 [20020430]':
		gen_str_init('* Updating from <b><= [20020430]</b>');

		$anon_id_tbl = array(
			'banlist' => array(
				'ban_userid'
			),
			'posts' => array(
				'poster_id'
			),
			'topics' => array(
				'topic_poster'
			),
			'user_group' => array(
				'user_id'
			)
		);

		$sql = '';
		foreach ($anon_id_tbl as $table => $field_ary)
		{
			foreach ($field_ary as $field)
			{
				$sql = "UPDATE " . $table_prefix . "$table
					SET $field = " . ANONYMOUS . "
					WHERE $field = -1";
				$db->sql_query($sql);
			}
		}

		unset($sql);

		gen_str_ok();
		break;

	default;
		print "<span class=\"updtext\">* No updates needed</span><br />\n";
}

?>

<h1>Updating current schema</h1>

<?php
/*
//
// Get schema
//
$schema = get_schema();

$table_def = $schema['table_def'];
$field_def = $schema['field_def'];
$key_def = $schema['key_def'];
$create_def = $schema['create_def'];

//
// Create array with tables in 'old' database
//
$result = $db->sql_query('SHOW TABLES');

$currenttables = array();
while($table = $db->sql_fetchrow($result))
{
	$currenttables[] = $table[0];
}

//
// Check what tables we need to CREATE
//
foreach($table_def as $table => $definition)
{
	if (!in_array($table, $currenttables))
	{
		gen_str_init("* Creating <b>$table</b>");

		$db->sql_query($definition);

		gen_str_ok();
	}
}

//
// Loop tables in schema
//
foreach ($field_def as $table => $table_def)
{
	// Loop fields in table
	gen_str_init("* Updating table <b>$table</b>");

	$sql = "SHOW FIELDS
		FROM $table";
	$result = $db->sql_query($sql);

	$current_fields = array();
	while ($row = $db->sql_fetchrow($result))
	{
		$current_fields[] = $row['Field'];
	}

	$alter_sql = "ALTER TABLE $table ";
	if (is_array($table_def))
	{
		foreach ($table_def as $field => $definition)
		{
			if ($field == '')
			{
				//
				// Skip empty fields if any (shouldn't be needed)
				//
				continue;
			}

			$type = $definition['type'];
			$size = $definition['size'];

			$default = isset($definition['default']) ? "DEFAULT " . $definition['default'] : '';

			$notnull = $definition['notnull'] == 1 ? 'NOT NULL' : '';

			$auto_increment = $definition['auto_increment'] == 1 ? 'auto_increment' : '';

			$oldfield = isset($rename[$table][$field]) ? $rename[$table][$field] : $field;

			//
			// If the current is not a key of $current_def and it is not a field that is
			// to be renamed then the field doesn't currently exist.
			//
			$changes[] = (!in_array($field, $current_fields) && $oldfield == $field) ? " ADD $field " . $create_def[$table][$field] : " CHANGE $oldfield $field " . $create_def[$table][$field];
		}
	}

	$alter_sql .= join(',', $changes);

	unset($changes);
	unset($current_fields);

	$sql = "SHOW INDEX
		FROM $table";
	$result = $db->sql_query($sql);

	$indices = array();
	while($row = $db->sql_fetchrow($result))
	{
		$indices[] = $row['Key_name'];
	}

	if (is_array($key_def[$table]))
	{
		foreach ($key_def[$table] as $key_name => $key_field)
		{
			if (!in_array($key_name, $indices))
			{
				$alter_sql .= ($key_name == 'PRIMARY') ? ", ADD PRIMARY KEY ($key_field)" : ", ADD INDEX $key_name ($key_field)";
			}
		}
	}

	$db->sql_query($alter_sql);
	$alter_sql = '';

	gen_str_ok();

}
*/
?>

<h1>Updating table data</h1>

<?php


switch ($this_version)
{
	case '.0.0':
	case '.0.1':
	case '.0.2':
	case '.1.0 [20020402]':
		gen_str_init('* Inserting <b>config</b> data');

		$sql_ary = array();
		$sql_ary[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value)
			VALUES ('session_gc', '3600')";
		$sql_ary[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value)
			VALUES ('session_last_gc', '0')";

		$db->sql_return_on_error(true);
		for($i = 0; $i < count($sql_ary); $i++)
		{
			$db->sql_query($sql_ary[$i]);
		}
		$db->sql_return_on_error(false);

		gen_str_ok();

	case '.1.0 [20020420]':
	case '.1.0 [20020421]':
		gen_str_init('* Inserting <b>config</b> data');

		$sql = "SELECT COUNT(user_id) AS total_users, MAX(user_id) AS newest_user_id
			FROM " . $table_prefix . "users
			WHERE user_id <> " . ANONYMOUS;
		$result = $db->sql_query($sql);

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

		$user_count = $row['total_users'];
		$newest_user_id = $row['newest_user_id'];

		$sql = "SELECT username
			FROM " . $table_prefix . "users
			WHERE user_id = $newest_user_id";
		$result = $db->sql_query($sql);

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

		$newest_username = $row['username'];

		$sql_ary = array();
		$sql_ary[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value)
			VALUES ('newest_user_id', $newest_user_id)";
		$sql_ary[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value)
			VALUES ('newest_username', '$newest_username')";
		$sql_ary[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value)
			VALUES ('num_users', $user_count)";

		$db->sql_return_on_error(true);
		for($i = 0; $i < count($sql_ary); $i++)
		{
			$db->sql_query($sql_ary[$i]);
		}
		$db->sql_return_on_error(false);

		gen_str_ok();

	case '.1.0 [20020430]':
	case '2.1.0 [20020430]':

		gen_str_init('* Decoding <b>banlist.ban_ip</b>');

		$sql = "SELECT ban_id, ban_ip
			FROM " . $table_prefix . "banlist
			WHERE ban_ip NOT LIKE '%.%'";
		$result = $db->sql_query($sql);

		$sql_ary = array();
		if ($row = $db->sql_fetchrow($result))
		{
			do
			{
				$sql = "UPDATE " . $table_prefix . "banlist
					SET ban_ip = '" . str_replace('255', '*', decode_ip($row['ban_ip'])) . "'
					WHERE ban_id = " . $row['ban_id'];
				$db->sql_query($sql);
			}
			while ($row = $db->sql_fetchrow($result));
		}
		$db->sql_freeresult($result);

		gen_str_ok();

		$upd_ip_sql = array(
			'privmsgs' => array(
				'privmsgs_ip'
			),
			'vote_voters' => array(
				'vote_user_ip'
			),
		);
//			'posts' => array(
//				'poster_ip',
//			),

		$batchsize = 1000;
		foreach ($upd_ip_sql as $table => $field_ary)
		{
			foreach ($field_ary as $field)
			{
				gen_str_init("* Decoding <b>$table.$field</b>");

				$db->sql_return_on_error(true);
				$sql = "SELECT MAX($field) AS max_id
					FROM " . $table_prefix . "$table";
				if ($result = $db->sql_query($sql))
				{
					$db->sql_return_on_error(false);

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

					$maxid = $row['max_id'];

					for($i = 0; $i <= $maxid; $i += $batchsize)
					{
						$batchstart = $i;
						$batchend = $i + $batchsize;

						$sql = "SELECT DISTINCT $field
							FROM " . $table_prefix . "$table
							WHERE $field NOT LIKE '%.%'
								BETWEEN $batchstart
									AND $batchend";
						$result = $db->sql_query($sql);

						if ($row = $db->sql_fetchrow($result))
						{
							do
							{
								$sql = "UPDATE " . $table_prefix . "$table
									SET $field = '" . decode_ip($row[$field]) . "'
									WHERE $field LIKE '" . $row[$field] . "'";
								$db->sql_query($sql);
							}
							while ($row = $db->sql_fetchrow($result));
						}
						$db->sql_freeresult($result);
					}

					gen_str_ok();
				}
				else
				{
					gen_str_skip();
				}
				$db->sql_return_on_error(false);
			}
		}

		gen_str_init('* Inserting <b>config</b> data');

		$sql_ary = array(
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('ldap_server', '')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('ldap_base_dn', '')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('ldap_uid', '')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('limit_load', '2.0')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('active_sessions', '0')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('search_interval','0')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('min_search_chars','3')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('max_search_chars','20')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('pm_max_boxes','4')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('pm_max_msgs','50')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('max_post_chars', '0')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('max_post_smilies', '0')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('board_disable_msg','')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('email_enable','1')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('auth_method','db')",
			"INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('icons_path','images/icons')",
		);

		$db->sql_return_on_error(true);
		for($i = 0; $i < count($sql_ary); $i++)
		{
			$db->sql_query($sql_ary[$i]);
		}

		gen_str_ok();
		gen_str_init('* Inserting <b>style</b> data');

		$sql_ary = array(
			"INSERT INTO " . $table_prefix . "styles (style_id, template_id, theme_id, imageset_id, style_name) VALUES (1, 1, 1, 1, 'subSilver')",

			"INSERT INTO " . $table_prefix . "styles_imageset (imageset_id, imageset_name, imageset_path, post_new, post_locked, post_pm, reply_new, reply_pm, reply_locked, icon_quote, icon_edit, icon_search, icon_profile, icon_pm, icon_email, icon_www, icon_icq, icon_aim, icon_yim, icon_msnm, icon_no_email, icon_no_www, icon_no_icq, icon_no_aim, icon_no_yim, icon_no_msnm, icon_delete, icon_ip, goto_post, goto_post_new, goto_post_latest, goto_post_newest, forum, forum_new, forum_locked, folder, folder_new, folder_hot, folder_hot_new, folder_locked, folder_locked_new, folder_sticky, folder_sticky_new, folder_announce, folder_announce_new, topic_watch, topic_unwatch, poll_left, poll_center, poll_right, rating) VALUES (1, 'subSilver &copy; phpBB Group', 'subSilver', '\"imagesets/subSilver/{LANG}/post.gif\" width=\"82\" height=\"25\" border=\"0\"', '\"imagesets/subSilver/{LANG}/reply-locked.gif\" width=\"82\" height=\"25\" border=\"0\"', '\"imagesets/subSilver/{LANG}/post.gif\" width=\"82\" height=\"25\" border=\"0\"', '\"imagesets/subSilver/{LANG}/reply.gif\" width=\"88\" height=\"27\" border=\"0\"', '\"imagesets/subSilver/{LANG}/reply.gif\" width=\"88\" height=\"27\" border=\"0\"', '\"imagesets/subSilver/{LANG}/reply-locked.gif\" width=\"82\" height=\"25\" border=\"0\"', '\"imagesets/subSilver/{LANG}/icon_quote.gif\" width=\"59\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/{LANG}/icon_edit.gif\" width=\"59\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/{LANG}/icon_search.gif\" width=\"59\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/{LANG}/icon_profile.gif\" width=\"59\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/{LANG}/icon_pm.gif\" width=\"59\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/{LANG}/icon_email.gif\" width=\"59\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/{LANG}/icon_www.gif\" width=\"59\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/{LANG}/icon_icq_add.gif\" width=\"59\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/{LANG}/icon_aim.gif\" width=\"59\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/{LANG}/icon_yim.gif\" width=\"59\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/{LANG}/icon_msnm.gif\" width=\"59\" height=\"18\" border=\"0\"', '', '', '', '', '', '', '\"imagesets/subSilver/icon_delete.gif\" width=\"16\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/{LANG}/icon_ip.gif\" width=\"16\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/icon_minipost.gif\" width=\"12\" height=\"9\" border=\"0\"', '\"imagesets/subSilver/icon_minipost_new.gif\" width=\"12\" height=\"9\" border=\"0\"', '\"imagesets/subSilver/icon_latest_reply.gif\" width=\"18\" height=\"9\" border=\"0\"', '\"imagesets/subSilver/icon_newest_reply.gif\" width=\"18\" height=\"9\" border=\"0\"', '\"imagesets/subSilver/folder_big.gif\" width=\"46\" height=\"25\" border=\"0\"', '\"imagesets/subSilver/folder_new_big.gif\" width=\"46\" height=\"25\" border=\"0\"', '\"imagesets/subSilver/folder_locked_big.gif\" width=\"46\" height=\"25\" border=\"0\"', '\"imagesets/subSilver/folder.gif\" width=\"19\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/folder_new.gif\" width=\"19\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/folder_hot.gif\" width=\"19\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/folder_new_hot.gif\" width=\"19\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/folder_lock.gif\" width=\"19\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/folder_lock_new.gif\" width=\"19\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/folder_sticky.gif\" width=\"19\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/folder_sticky_new.gif\" width=\"19\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/folder_announce.gif\" width=\"19\" height=\"18\" border=\"0\"', '\"imagesets/subSilver/folder_announce_new.gif\" width=\"19\" height=\"18\" border=\"0\"', '', '', '\"imagesets/subSilver/voting_lcap.gif\" width=\"4\" height=\"12\" border=\"0\"', '\"imagesets/subSilver/voting_rcap.gif\" height=\"12\" border=\"0\"', '\"imagesets/subSilver/voting_bar

.gif\" width=\"4\" height=\"12\" border=\"0\"', '\"imagesets/subSilver/ratings/{RATE}.gif\" width=\"45\" height=\"17\" border=\"0\"')",

			"INSERT INTO " . $table_prefix . "styles_template (template_id, template_name, template_path, poll_length, pm_box_length, compile_crc) VALUES (1, 'subSilver &copy; phpBB Group', 'subSilver', 205, 175, '')",

			"INSERT INTO " . $table_prefix . "styles_theme (theme_id, css_data, css_external) VALUES (1, 'th	{ background-image: url(templates/subSilver/images/cellpic3.gif) }\r\ntd.cat { background-image: url(templates/subSilver/images/cellpic1.gif) }\r\ntd.rowpic { background-image: url(templates/subSilver/images/cellpic2.jpg); background-repeat: repeat-y }\r\ntd.icqback { background-image: url(templates/subSilver/images/icon_icq_add.gif); background-repeat: no-repeat }\r\ntd.catHead,td.catSides,td.catLeft,td.catRight,td.catBottom { background-image: url(templates/subSilver/images/cellpic1.gif) }\r\nth.thTop { background-image: url(templates/subSilver/images/cellpic3.gif) }', 'subSilver/subSilver.css')",

				"INSERT INTO " . $table_prefix . "icons (icons_id, icons_url, icons_width, icons_height) VALUES (1, '', 0, 0)",
		);

		for($i = 0; $i < count($sql_ary); $i++)
		{
			$db->sql_query($sql_ary[$i]);
		}

		gen_str_ok();
		gen_str_init('* Updating <b>style</b> defaults');

		$sql_ary = array(
			"UPDATE " . $table_prefix . "users SET user_style = 1",
			"UPDATE " . $table_prefix . "config SET config_value = '1' WHERE config_name = 'default_style'",
		);

		if (SQL_LAYER == 'mysql' || SQL_LAYER == 'mysql4')
		{
			$sql_ary[] = "ALTER TABLE " . $table_prefix . "users AUTO_INCREMENT = 1";
		}

		$sql_ary[] = "UPDATE " . $table_prefix . "users SET user_id = 0 WHERE username = 'Anonymous'";

		for($i = 0; $i < count($sql_ary); $i++)
		{
			$db->sql_query($sql_ary[$i]);
		}
		$db->sql_return_on_error(false);

		gen_str_ok();
		gen_str_init('* Updating <b>permissions</b>');

		// Grab user id of first user with user_level of ADMIN
		$sql = "SELECT user_id
			FROM " . $table_prefix . "users
			WHERE user_level = 1
			ORDER BY user_id ASC";
		$result = $db->sql_query($sql);

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

		$founder_id = $row['user_id'];

		//
		// Grab forum auth information
		//
		$sql = "SELECT *
			FROM " . $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
		//
		$sql = "SELECT ug.user_id, aa.*
			FROM " . $table_prefix . "auth_access aa, " . $table_prefix . "user_group ug, " . $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 " . $table_prefix . "auth_access aa, " . $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);

		//
		// Now delete 'single user groups' since they are no
		// longer needed. Need to clear both user_group and groups
		//
		$sql = "SELECT group_id
			FROM " . $table_prefix . "groups
			WHERE group_single_user <> 1";
		$result = $db->sql_query($sql);

		$delete_ug_sql = '';
		if ($row = $db->sql_fetchrow($result))
		{
			do
			{
				$delete_ug_sql .= (($delete_ug_sql != '') ? ', ' : '') . $row['group_id'];
			}
			while ($row = $db->sql_fetchrow($result));
		}
		$db->sql_freeresult($result);

		//
		// Clean up user_group and groups
		//
		if ($delete_ug_sql)
		{
			$sql = "DELETE FROM " . $table_prefix . "user_group
				WHERE group_id NOT IN ($delete_ug_sql)";
			$db->sql_query($sql);
		}

		$sql = "DELETE FROM " . $table_prefix . "groups
			WHERE group_single_user = 1";
		$db->sql_query($sql);

		unset($delete_ug_sql);

		//
		// Set a founder admin ... we'll assume it's the first user with admin level access
		//
		$sql = "UPDATE " . $table_prefix . "users
			SET user_founder = 1
			WHERE user_id = $founder_id";
		$db->sql_query($sql);

		//
		// Add all auth options to auth_options table
		//
		$all_options = array_merge($auth_options, array_merge($auth_mod_options, $auth_admin_options));
		$option_ids = array();

		foreach ($all_options as $value)
		{
			$sql = "INSERT INTO " . $table_prefix . "auth_options (auth_value)
				VALUES ('$value')";
			$db->sql_query($sql);

			$option_ids[$value] = $db->sql_nextid();
		}

		foreach ($new_groups as $k => $sql)
		{
			$db->sql_query($sql);
			$$k = $db->sql_nextid();
		}

		//
		// Update user_group table
		//
		$sql = "INSERT INTO " . $table_prefix . "user_group (user_id, group_id)
			SELECT user_id, $guest_id
				FROM " . $table_prefix . "users
				WHERE user_id = " . ANONYMOUS;
		$db->sql_query($sql);

		$sql = "INSERT INTO " . $table_prefix . "user_group (user_id, group_id)
			SELECT user_id, $reg_inactive_id
				FROM " . $table_prefix . "users
				WHERE user_id <> " . ANONYMOUS . "
					AND user_active <> 1";
		$db->sql_query($sql);

		$sql = "INSERT INTO " . $table_prefix . "user_group (user_id, group_id)
			SELECT user_id, $reg_id
				FROM " . $table_prefix . "users
				WHERE user_id <> " . ANONYMOUS . "
					AND user_active = 1";
		$db->sql_query($sql);

		$sql = "INSERT INTO " . $table_prefix . "user_group (user_id, group_id)
			SELECT user_id, $admin_id
				FROM " . $table_prefix . "users
				WHERE user_level = 1";
		$db->sql_query($sql);

		//
		// Construct equivalence entries
		//
		$group_acl = array();
		$user_acl = array();

		foreach ($forum_access as $forum)
		{
			foreach($auth_map as $k => $v)
			{
				switch ($forum[$k])
				{
					case AUTH_ALL:
						$group_acl[$guest_id][$forum['forum_id']][$v] = ACL_ALLOW;
						$group_acl[$reg_inactive_id][$forum['forum_id']][$v] = ACL_ALLOW;
						$group_acl[$reg_id][$forum['forum_id']][$v] = ACL_ALLOW;
						break;

					case AUTH_REG:
						$group_acl[$reg_id][$forum['forum_id']][$v] = ACL_ALLOW;
						break;

					case AUTH_ACL:
						foreach($group_access as $forum_id => $access)
						{
							if ($forum_id == $forum['forum_id'])
							{
								if (!empty($access[$k]))
								{
									$group_acl[$access['group_id']][$forum['forum_id']][$v] = ACL_ALLOW;
								}
							}
						}

						foreach($user_access as $forum_id => $access)
						{
							if ($forum_id == $forum['forum_id'])
							{
								if (!empty($access[$k]))
								{
									$user_acl[$access['user_id']][$forum['forum_id']][$v] = ACL_ALLOW;
								}
							}
						}
						break;

					case AUTH_MOD:
						$group_acl[$super_mod_id][$forum['forum_id']][$v] = ACL_ALLOW;

						foreach($group_access as $forum_id => $access)
						{
							if ($forum_id == $forum['forum_id'])
							{
								if (!empty($access[$k]))
								{
									$group_acl[$access['group_id']][$forum['forum_id']][$v] = ACL_ALLOW;
								}
							}
						}

						foreach($user_access as $forum_id => $access)
						{
							if ($forum_id == $forum['forum_id'])
							{
								if (!empty($access[$k]))
								{
									$user_acl[$access['user_id']][$forum['forum_id']][$v] = ACL_ALLOW;
								}
							}
						}
						break;
				}
			}
		}

		//
		// First add admin access, phpBB 2.0.x stored admin info in the user_level
		// field. We'll pull all user_id's with ADMIN user_level and add them to the
		// auth_user table. By default all admin options (bar clear logs) are enabled
		//
		$sql_ary = array();
		$sql_ary[] = "INSERT INTO " . $table_prefix . "auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny)
			SELECT $admin_id, 0, auth_option_id, " . ACL_ALLOW . "
				FROM " . $table_prefix . "auth_options
				WHERE auth_value LIKE 'admin_%'
					AND auth_value NOT LIKE 'admin_clearlogs'";

		$sql_ary[] = "INSERT INTO " . $table_prefix . "auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny)
			SELECT $admin_id, 0, auth_option_id, " . ACL_PERMIT . "
				FROM " . $table_prefix . "auth_options
				WHERE auth_value LIKE 'forum_%'";

		$sql_ary[] = "INSERT INTO " . $table_prefix . "auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny)
			SELECT $admin_id, 0, auth_option_id, " . ACL_PERMIT . "
				FROM " . $table_prefix . "auth_options
				WHERE auth_value LIKE 'mod_%'";

		//
		// Do Moderators
		//
		foreach($user_access as $forum_id => $access)
		{
			if (!empty($access['auth_mod']))
			{
				$sql_ary[] = "INSERT INTO " . $table_prefix . "auth_users (user_id, forum_id, auth_option_id, auth_allow_deny)
					SELECT " . $access['user_id'] . ", $forum_id, auth_option_id, " . ACL_ALLOW . "
						FROM " . $table_prefix . "auth_options
						WHERE auth_value LIKE 'mod_%'
							AND auth_value NOT LIKE 'mod_auth'";
				$sql_ary[] = "INSERT INTO " . $table_prefix . "auth_users (user_id, forum_id, auth_option_id, auth_allow_deny)
					SELECT " . $access['user_id'] . ", $forum_id, auth_option_id, " . ACL_PERMIT . "
						FROM " . $table_prefix . "auth_options
						WHERE auth_value LIKE 'forum_%'";
			}
		}

		foreach($group_access as $forum_id => $access)
		{
			if (!empty($access['auth_mod']))
			{
				$sql_ary[] = "INSERT INTO " . $table_prefix . "auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny)
					SELECT " . $access['group_id'] . ", $forum_id, auth_option_id, " . ACL_ALLOW . "
						FROM " . $table_prefix . "auth_options
						WHERE auth_value LIKE 'mod_%'
							AND auth_value NOT LIKE 'mod_auth'";
				$sql_ary[] = "INSERT INTO " . $table_prefix . "auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny)
					SELECT " . $access['group_id'] . ", $forum_id, auth_option_id, " . ACL_PERMIT . "
						FROM " . $table_prefix . "auth_options
						WHERE auth_value LIKE 'forum_%'";
			}
		}

		//
		// Rest of access list
		//
		foreach ($user_acl as $user_id => $user_acl_ary)
		{
			foreach ($user_acl_ary as $forum_id => $auth)
			{
				foreach ($auth as $auth_value => $allow)
				{
					$auth_option_id = $option_ids[$auth_value];
					$sql_ary[] = "INSERT INTO " . $table_prefix . "auth_users (user_id, forum_id, auth_option_id, auth_allow_deny) VALUES ($user_id, $forum_id, $auth_option_id, $allow)";
				}
			}
		}

		foreach ($group_acl as $group_id => $group_acl_ary)
		{
			foreach ($group_acl_ary as $forum_id => $auth)
			{
				foreach ($auth as $auth_value => $allow)
				{
					$auth_option_id = $option_ids[$auth_value];
					$sql_ary[] = "INSERT INTO " . $table_prefix . "auth_groups (group_id, forum_id, auth_option_id, auth_allow_deny) VALUES ($group_id, $forum_id,  $auth_option_id, $allow)";
				}
			}
		}

		foreach ($sql_ary as $sql)
		{
			$db->sql_query($sql);
		}

		gen_str_ok();

	case '2.1.1 [20030221]':

		$sql_ary = array();

		gen_str_init('* Updating <b>post checksums</b>');

		$sql_ary[] = "UPDATE " . $table_prefix . "posts_text
			SET post_checksum = MD5(post_text)";

		foreach ($sql_ary as $sql)
		{
			$db->sql_query($sql);
		}

		gen_str_ok();
		gen_str_init('* Updating <b>forum post info</b>');

		$sql = "SELECT topic_id, MIN(post_id) AS first_post_id, MAX(post_id) AS last_post_id, COUNT(post_id) AS total_posts 
			FROM {$table_prefix}posts 
			GROUP BY topic_id";
		$result = $db->sql_query($sql);

		while ($row = $db->sql_fetchrow($result))
		{
			$sql = "UPDATE {$table_prefix}topics 
				SET topic_first_post_id = " . $row['first_post_id'] . ", topic_last_post_id = " . $row['last_post_id'] . ", topic_replies = " . ($row['total_posts'] - 1) . "
				WHERE topic_id = " . $row['topic_id'];
			$db->sql_query($sql);
		}
		$db->sql_freeresult($result);

		switch (SQL_LAYER)
		{
			case 'oracle':
				$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
					FROM " . $table_prefix . "forums f, " . $table_prefix . "posts p, " . $table_prefix . "users u
					WHERE p.post_id = f.forum_last_post_id(+)
						AND u.user_id = p.poster_id(+)";
				break;

			default:
				$sql = "SELECT f.forum_id, p.post_time, p.post_username, u.username, u.user_id
					FROM ((" . $table_prefix . "forums f
					LEFT JOIN " . $table_prefix . "posts p ON p.post_id = f.forum_last_post_id)
					LEFT JOIN " . $table_prefix . "users u ON u.user_id = p.poster_id)";
				break;
		}
		$result = $db->sql_query($sql);

		$sql_ary = array();
		while ($row = $db->sql_fetchrow($result))
		{
			$forum_id = $row['forum_id'];

			$sql_ary[] = "UPDATE " . $table_prefix . "forums
				SET forum_last_poster_id = " . (($row['user_id'] != ANONYMOUS) ? $row['user_id'] : ANONYMOUS) . ", forum_last_poster_name = '" . (($row['user_id'] !=  ANONYMOUS) ? addslashes($row['username']) : addslashes($row['post_username'])) . "', forum_last_post_time = " . $row['post_time'] . "
				WHERE forum_id = $forum_id";

			$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
				FROM " . $table_prefix . "topics t, " . $table_prefix . "users u, " . $table_prefix . "posts p, " . $table_prefix . "posts p2, " . $table_prefix . "users u2
				WHERE t.forum_id = $forum_id
					AND u.user_id = t.topic_poster
					AND p.post_id = t.topic_first_post_id
					AND p2.post_id = t.topic_last_post_id
					AND u2.user_id = p2.poster_id";
			$result2 = $db->sql_query($sql);

			while ($row2 = $db->sql_fetchrow($result2))
			{
				$sql_ary[] = "UPDATE " . $table_prefix . "topics
					SET topic_poster = " . $row['user_id'] . ", topic_first_poster_name = '" . (($row2['user_id'] != ANONYMOUS && $row2['user_id']) ? addslashes($row2['username']) : addslashes($row2['post_username'])) . "', topic_last_poster_id = " . (($row2['id2'] != ANONYMOUS && $row2['id2']) ? $row2['id2'] : ANONYMOUS) . ", topic_last_post_time = " . $row2['post_time'] . ", topic_last_poster_name = '" . (($row2['id2'] !=  ANONYMOUS && $row2['id2']) ? addslashes($row2['user2']) : addslashes($row2['post_username2'])) . "'
					WHERE topic_id = " . $row2['topic_id'];
			}
			$db->sql_freeresult($result2);

			unset($row2);
		}
		$db->sql_freeresult($result);

		foreach ($sql_ary as $sql)
		{
			echo $sql . "<br />";
			$db->sql_query($sql);
		}

		gen_str_ok();

	case '2.1.0 [20020817]':

//		$sql = "INSERT INTO phpbb_config (config_name, config_value)
//			VALUES ('ip_check', '4')";
//		$db->sql_query($sql);
		break;

	default;
		print "<span class=\"updtext\">* No updates needed</span><br />\n";
}

$sql = "UPDATE " . $table_prefix . "config
	SET config_value = '$version'
	WHERE config_name = 'version'";
$result = $db->sql_query($sql);

?>

<br clear="all" />

<span class="updtext">* Update completed to version <?php echo $version; ?></span>

<br clear="all" /><br />

<?php

page_footer();
exit;

//
// END MAIN PROG
//

// ---------------
// Begin functions
//

//
// Decode encoded IPs
//
function decode_ip($int_ip)
{
	$hexipbang = explode('.', chunk_split($int_ip, 2, '.'));
	return hexdec($hexipbang[0]). '.' . hexdec($hexipbang[1]) . '.' . hexdec($hexipbang[2]) . '.' . hexdec($hexipbang[3]);
}

//
// Common page header
//
function page_header()
{

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-15">
<meta http-equiv="Content-Style-Type" content="text/css">
<link rel="stylesheet" href="../adm/subSilver.css" type="text/css">
<style type="text/css">
<!--
th		{ background-image: url('../adm/images/cellpic3.gif') }
td.cat	{ background-image: url('../adm/images/cellpic1.gif') }

h1 { margin-left:15px }

.ok { font-family: 'Courier New',courier; color:green; font-size:10pt }
.skip { font-family: 'Courier New',courier; color:blue; font-size:10pt }
.updtext { font-family: 'Courier New', courier; font-size:10pt;margin-left:25px}

//-->
</style>
<title>Update Script</title>
</head>
<body>

<a name="top"></a>

<table width="100%" cellspacing="0" cellpadding="0" border="0">
	<tr>
		<td><img src="../adm/images/header_left.jpg" width="200" height="60" alt="phpBB Logo" title="phpBB Logo" border="0"/></td>
		<td width="100%" background="../adm/images/header_bg.jpg" height="60" align="right" nowrap="nowrap"><span class="maintitle">Update Script</span> &nbsp; &nbsp; &nbsp;</td>
	</tr>
</table>

<br clear="all" /><br />

<?
	return;
}

//
// Common page footer
//
function page_footer()
{
?>

<div align="center"><span class="copyright">Powered by phpBB &copy; 2002 <a href="http://www.phpbb.com/" target="_phpbb" class="copyright">phpBB Group</a></span></div>

<br clear="all" />

</body>
</html>
<?
	return;
}

function gen_str_init($str)
{
	print '<span class="updtext">' . str_pad($str . ' ', 60, '.') . ' </span>';
	flush();
}

function gen_str_ok()
{
	print "<span class=\"ok\"><b>OK</b></span><br />\n";
	flush();
}

function gen_str_skip()
{
	print "<span class=\"skip\"><b>SKIPPED</b></span><br />\n";
	flush();
}

//
//
//
function get_schema()
{
	global $table_prefix, $dbms;

	$schemafile = file('schemas/mysql_schema.sql');
	$tabledata = 0;

	for($i=0; $i < count($schemafile); $i++)
	{
		$line = $schemafile[$i];

		if (preg_match('/^CREATE TABLE (\w+)/i', $line, $matches))
		{
			// Start of a new table definition, set some variables and go to the next line.
			$tabledata = 1;
			// Replace the 'phpbb_' prefix by the user defined prefix.
			$table = str_replace('phpbb_', $table_prefix, $matches[1]);
			$table_def[$table] = "CREATE TABLE $table (\n";
			continue;
		}

		if (preg_match('/^\);/', $line))
		{
			// End of the table definition
			// After this we will skip everything until the next 'CREATE' line
			$tabledata = 0;
			$table_def[$table] .= ')'; // We don't need the closing semicolon
		}

		if ($tabledata == 1)
		{
			// We are inside a table definition, parse this line.
			// Add the current line to the complete table definition:
			$table_def[$table] .= $line;
			if (preg_match('/^\s*(\w+)\s+(\w+)\(([\d,]+)\)(.*)$/', $line, $matches))
			{
				// This is a column definition
				$field = $matches[1];
				$type = $matches[2];
				$size = $matches[3];

				preg_match('/DEFAULT (NULL|\'.*?\')[,\s](.*)$/i', $matches[4], $match);
				$default = $match[1];

				$notnull = (preg_match('/NOT NULL/i', $matches[4])) ? 1 : 0;
				$auto_increment = (preg_match('/auto_increment/i', $matches[4])) ? 1 : 0;

				$field_def[$table][$field] = array(
					'type' => $type,
					'size' => $size,
					'default' => $default,
					'notnull' => $notnull,
					'auto_increment' => $auto_increment
				);
			}

			if (preg_match('/\s*PRIMARY\s+KEY\s*\((.*)\).*/', $line, $matches))
			{
				// Primary key
				$key_def[$table]['PRIMARY'] = $matches[1];
			}
			else if (preg_match('/\s*KEY\s+(\w+)\s*\((.*)\)/', $line, $matches))
			{
				// Normal key
				$key_def[$table][$matches[1]] = $matches[2];
			}
			else if (preg_match('/^\s*(\w+)\s*(.*?),?\s*$/', $line, $matches))
			{
				// Column definition
				$create_def[$table][$matches[1]] = $matches[2];
			}
			else
			{
				// It's a bird! It's a plane! It's something we didn't expect ;(
			}
		}
	}

	$schema['field_def'] = $field_def;
	$schema['table_def'] = $table_def;
	$schema['create_def'] = $create_def;
	$schema['key_def'] = $key_def;

	return $schema;
}

//
//
//
function get_inserts()
{
	global $table_prefix, $dbms;

	$insertfile = file('schemas/mysql_basic.sql');

	for($i = 0; $i < count($insertfile); $i++)
	{
		if (preg_match('/(INSERT INTO (\w+)\s.*);/i', str_replace('phpbb_', $table_prefix, $insertfile[$i]), $matches))
		{
			$returnvalue[$matches[2]][] = $matches[1];
		}
	}

	return $returnvalue;
}
//
// End functions
// -------------

?>