'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();
?>
Pre-schema update data changes
<= [20020430]');
$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 "* No updates needed
\n";
}
?>
Updating current schema
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 $table");
$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 $table");
$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();
}
*/
?>
Updating table data
config 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 config 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 banlist.ban_ip');
$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 $table.$field");
$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 config 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 style 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 © 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 © 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 style 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 permissions');
// 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 post checksums');
$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 forum post info');
$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 . "
";
$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 "* No updates needed
\n";
}
$sql = "UPDATE " . $table_prefix . "config
SET config_value = '$version'
WHERE config_name = 'version'";
$result = $db->sql_query($sql);
?>
* Update completed to version
Update Script
 |
Update Script |
' . str_pad($str . ' ', 60, '.') . ' ';
flush();
}
function gen_str_ok()
{
print "OK
\n";
flush();
}
function gen_str_skip()
{
print "SKIPPED
\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
// -------------
?>