+@set_time_limit(600);

+ob_end_clean();

+//

+$db = $dbhost = $dbuser = $dbpasswd = $dbport = $dbname = '';

+

+include($phpbb_root_path . 'db/' . $dbms . '.'.$phpEx);

+

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

+

+//

+// Updates to this version ...

+//

+$version = '2.1.0 [20020816]';

+

+// ----------------

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

+ 'auth_read' => 'read',

+ 'auth_post' => 'post',

+ 'auth_reply' => 'reply',

+ 'auth_edit' => 'edit',

+ 'auth_delete' => 'delete',

+ 'auth_pollcreate' => 'poll',

+ 'auth_vote' => 'vote',

+ 'auth_announce' => 'announce',

+ 'auth_sticky' => 'sticky',

+ 'auth_attachments' => 'attach',

+ 'auth_download' => 'download',

+);

+

+$auth_options = array(

+ 'forum' => array(

+ 'list',

+ 'read',

+ 'post',

+ 'reply',

+ 'edit',

+ 'delete',

+ 'poll',

+ 'vote',

+ 'announce',

+ 'sticky',

+ 'attach',

+ 'download',

+ 'html',

+ 'bbcode',

+ 'smilies',

+ 'img',

+ 'flash',

+ 'sigs',

+ 'search',

+ 'email',

+ 'rate',

+ 'print',

+ 'ignoreflood',

+ 'ignorequeue'

+ )

+);

+

+$auth_mod_options = array(

+ 'mod' => array(

+ 'edit',

+ 'delete',

+ 'move',

+ 'lock',

+ 'split',

+ 'merge',

+ 'approve',

+ 'unrate',

+ 'auth'

+ )

+);

+

+$auth_admin_options = array(

+ 'admin' => array(

+ 'general',

+ 'user',

+ 'group',

+ 'forum',

+ 'post',

+ 'ban',

+ 'auth',

+ 'email',

+ 'styles',

+ 'backup',

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

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

+

+ $sql = "SELECT MAX($field) AS max_id

+ FROM " . $table_prefix . "$table";

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

+

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

+ }

+ }

+

+ 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

+ //

+ $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 $type => $option_ary )

+ {

+ foreach ( $option_ary as $option )

+ $sql = "INSERT INTO " . $table_prefix . "auth_options (auth_type, auth_option)

+ VALUES ('$type', '$option')";

+ $db->sql_query($sql);

+

+ $option_ids[$type][$option] = $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']]['forum'][$v] = ACL_ALLOW;

+ $group_acl[$reg_inactive_id][$forum['forum_id']]['forum'][$v] = ACL_ALLOW;

+ $group_acl[$reg_id][$forum['forum_id']]['forum'][$v] = ACL_ALLOW;

+ break;

+

+ case AUTH_REG:

+ $group_acl[$reg_id][$forum['forum_id']]['forum'][$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']]['forum'][$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']]['forum'][$v] = ACL_ALLOW;

+ }

+ }

+ }

+ break;

+

+ case AUTH_MOD:

+ $group_acl[$super_mod_id][$forum['forum_id']]['forum'][$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']]['forum'][$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']]['forum'][$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_type LIKE 'admin' AND auth_option NOT LIKE '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_type 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_type 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_type LIKE 'mod' AND auth_option NOT LIKE '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_type 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_type LIKE 'mod' AND auth_option NOT LIKE '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_type 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_type => $auth_option_ary )

+ foreach ( $auth_option_ary as $auth_option => $allow )

+ {

+ $auth_option_id = $option_ids[$auth_type][$auth_option];

+ $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_type => $auth_option_ary )

+ {

+ foreach ( $auth_option_ary as $auth_option => $allow )

+ {

+ $auth_option_id = $option_ids[$auth_type][$auth_option];

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

+ break;

+

+ default;

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

+

+$sql = "UPDATE " . $table_prefix . "config

+ SET config_value = '$version'

+

+<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="../admin/subSilver.css" type="text/css">

+<style type="text/css">

+<!--

+th { background-image: url('../admin/images/cellpic3.gif') }

+td.cat { background-image: url('../admin/images/cellpic1.gif') }

+

+h1 { margin-left:15px }

+

+.ok { font-family: 'Courier New',courier; color:green; 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="../admin/images/header_left.jpg" width="200" height="60" alt="phpBB Logo" title="phpBB Logo" border="0"/></td>

+ <td width="100%" background="../admin/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" />

+

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

+// -------------

+

+?> \ No newline at end of file