+ $s_hidden_fields .= '<input type="hidden" name="redirect" value="adm/index.php" />';

+ $s_hidden_fields .= '<input type="hidden" name="redirect" value="adm/index.php" />';

+<link rel="stylesheet" href="../adm/subSilver.css" type="text/css">

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

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

+ <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"><?php echo $lang['Welcome_install']; ?></span> &nbsp; &nbsp; &nbsp;</td>

+$version = '2.1.1 [20030221]';

+switch ($this_version)

+ foreach ($anon_id_tbl as $table => $field_ary)

+ foreach ($field_ary as $field)

+/*

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

+foreach($table_def as $table => $definition)

+ if (!in_array($table, $currenttables))

+foreach ($field_def as $table => $table_def)

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

+ if (is_array($table_def))

+ foreach ($table_def as $field => $definition)

+ if ($field == '')

+ $changes[] = (!in_array($field, $current_fields) && $oldfield == $field) ? " ADD $field " . $create_def[$table][$field] : " CHANGE $oldfield $field " . $create_def[$table][$field];

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

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

+*/

+switch ($this_version)

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

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

+ foreach ($upd_ip_sql as $table => $field_ary)

+ foreach ($field_ary as $field)

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

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

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

+ if (SQL_LAYER == 'mysql' || SQL_LAYER == 'mysql4')

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

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

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

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

+ $delete_ug_sql .= (($delete_ug_sql != '') ? ', ' : '') . $row['group_id'];

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

+ if ($delete_ug_sql)

+ foreach ($all_options as $value)

+ foreach ($new_groups as $k => $sql)

+ foreach ($forum_access as $forum)

+ foreach($auth_map as $k => $v)

+ switch ($forum[$k])

+ foreach($group_access as $forum_id => $access)

+ if ($forum_id == $forum['forum_id'])

+ if (!empty($access[$k]))

+ foreach($user_access as $forum_id => $access)

+ if ($forum_id == $forum['forum_id'])

+ if (!empty($access[$k]))

+ foreach($group_access as $forum_id => $access)

+ if ($forum_id == $forum['forum_id'])

+ if (!empty($access[$k]))

+ foreach($user_access as $forum_id => $access)

+ if ($forum_id == $forum['forum_id'])

+ if (!empty($access[$k]))

+ foreach($user_access as $forum_id => $access)

+ if (!empty($access['auth_mod']))

+ foreach($group_access as $forum_id => $access)

+ if (!empty($access['auth_mod']))

+ foreach ($user_acl as $user_id => $user_acl_ary)

+ foreach ($user_acl_ary as $forum_id => $auth)

+ foreach ($auth as $auth_value => $allow)

+ foreach ($group_acl as $group_id => $group_acl_ary)

+ foreach ($group_acl_ary as $forum_id => $auth)

+ foreach ($auth as $auth_value => $allow)

+ foreach ($sql_ary as $sql)

+ case '2.1.1 [20030221]':

+ foreach ($sql_ary as $sql)

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

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

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

+ 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'] . "

+ while ($row2 = $db->sql_fetchrow($result2))

+ 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'])) . "'

+ foreach ($sql_ary as $sql)

+ echo $sql . "<br />";

+// $sql = "INSERT INTO phpbb_config (config_name, config_value)

+// VALUES ('ip_check', '4')";

+// $db->sql_query($sql);

+ break;

+<link rel="stylesheet" href="../adm/subSilver.css" type="text/css">

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

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

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

+ if (preg_match('/^CREATE TABLE (\w+)/i', $line, $matches))

+ if (preg_match('/^\);/', $line))

+ if ($tabledata == 1)

+ if (preg_match('/^\s*(\w+)\s+(\w+)\(([\d,]+)\)(.*)$/', $line, $matches))

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

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

+ if (preg_match('/\s*PRIMARY\s+KEY\s*\((.*)\).*/', $line, $matches))

+ else if (preg_match('/\s*KEY\s+(\w+)\s*\((.*)\)/', $line, $matches))

+ else if (preg_match('/^\s*(\w+)\s*(.*?),?\s*$/', $line, $matches))

+ if (preg_match('/(INSERT INTO (\w+)\s.*);/i', str_replace('phpbb_', $table_prefix, $insertfile[$i]), $matches))

+@import url("templates/subSilver/formIE.css");

+<table width="100%" border="0" cellspacing="0" cellpadding="10" align="center">

+

+

+{

+ {

+ {

+ return true;

+ }

+ }

+ return false;

+ query("DROP TABLE themes", "Couldn't drop table 'themes'");

+

+

+

+

+

+

+ $sql = "SELECT *

+ $sql = "REPLACE INTO " . CONFIG_TABLE . " (config_name, config_value)

+

+ $sql = "UPDATE " . CONFIG_TABLE . "

+ SET config_value = 'dutch'

+

+ $names = array(

+ ),

+ PRIVMSGS_TABLE => array(

+ 'id' => 'msg_id',

+ ),

+ BANLIST_TABLE => array(

+ 'id' => 'ban_id',

+ $sql = "SELECT MAX(" . $data_array['id'] . ") AS max_id

+ $sql = "SELECT $field_id, $field

+ FROM $table

+ WHERE $field_id

+ BETWEEN $batchstart

+ $sql = "UPDATE $table

+ SET $field = '" . encode_ip($row[$field]) . "'

+ TOPICS_TABLE => array('topic_time'),

+ $sql = "UPDATE $table

+ $sql = "UPDATE $table

+ $sql = "SELECT p.post_id

+ FROM " . POSTS_TABLE . " p

+ LEFT JOIN " . TOPICS_TABLE . " t ON p.topic_id = t.topic_id

+

+ $sql = "DELETE FROM " . POSTS_TABLE . "

+ $sql = "DELETE FROM " . USERS_TABLE . "

+ $sql = "SELECT COUNT(*) AS total, MAX(user_id) AS maxid

+ $sql = "ALTER TABLE " . USERS_TABLE . "

+

+ $sql = "SELECT *

+ FROM " . USERS_TABLE . "

+ WHERE user_id

+ BETWEEN $batchstart

+ $sql = "INSERT INTO " . GROUPS_TABLE . " (group_name, group_description, group_single_user)

+ $sql = "INSERT INTO " . USER_GROUP_TABLE . " (group_id, user_id, user_pending)

+

+

+ $sql = "UPDATE " . USERS_TABLE . "

+ SET

+ user_sig_bbcode_uid = '$uid',

+ user_intrest = '" . $row['user_intrest'] . "',

+ user_level = '" . $row['user_level'] . "',

+ user_desmile = NOT(user_desmile),

+ user_bbcode = 1,

+ user_theme = 1

+ $sql = "SELECT forum_id

+

+ $sql = "ALTER TABLE " . POSTS_TABLE . "

+

+ $sql = "ALTER TABLE " . POSTS_TEXT_TABLE . "

+ $sql = "ALTER TABLE " . POSTS_TEXT_TABLE . "

+

+ $sql = "ALTER TABLE " . POSTS_TABLE . "

+ $sql = "ALTER TABLE " . POSTS_TABLE . "

+ $sql = "SELECT COUNT(*) as total, MAX(post_id) as maxid

+

+ $sql = "SELECT *

+ WHERE post_id

+ BETWEEN $batchstart

+

+ $sql = "UPDATE " . POSTS_TEXT_TABLE . "

+ $sql = "UPDATE " . POSTS_TABLE . "

+ SET enable_sig = $enable_sig" . $edited_sql . "

+ $sql = "SELECT DISTINCT p.post_id

+ FROM " . POSTS_TABLE . " p

+ LEFT JOIN " . USERS_TABLE . " u ON p.poster_id = u.user_id

+

+ $sql = "UPDATE " . POSTS_TABLE . "

+ SET poster_id = " . ANONYMOUS . ", enable_sig = 0

+ $sql = "SELECT COUNT(*) as total, max(msg_id) as maxid

+ $sql = "ALTER TABLE " . PRIVMSGS_TABLE . "

+

+ $sql = "SELECT *

+ WHERE msg_id

+ BETWEEN $batchstart

+

+

+

+ $sql = "UPDATE " . PRIVMSGS_TABLE . "

+ $sql = "SELECT *

+ $sql = "SELECT user_id

+ FROM " . USERS_TABLE . ", " . FORUMS_TABLE . "

+ WHERE user_id = " . $row['user_id'] . "

+ $sql = "SELECT g.group_id

+ FROM " . GROUPS_TABLE . " g, " . USER_GROUP_TABLE . " ug

+ WHERE g.group_id = ug.group_id

+ $sql = "SELECT DISTINCT u.user_id

+ FROM " . USERS_TABLE . " u, " . USER_GROUP_TABLE . " ug, " . AUTH_ACCESS_TABLE . " aa

+ WHERE aa.auth_mod = 1

+ AND ug.group_id = aa.group_id

+ AND u.user_id = ug.user_id

+ $sql = "UPDATE " . USERS_TABLE . "

+ SET user_level = " . MOD . "

+

+ $sql = "SELECT fa.*, f.forum_name

+ FROM forum_access fa

+ LEFT JOIN " . FORUMS_TABLE . " f ON fa.forum_id = f.forum_id

+ "user_allowbbcode" => "user_bbcode",

+ "user_style" => "user_theme"

+ "privmsgs_type" => "msg_status"

+

+ $sql = "SHOW FIELDS

+

+ // If the current is not a key of $current_def and it is not a field that is

+

+

+ $sql = "SHOW INDEX

+

+

+ $sql = "SELECT *

+

+ // Make it really private ...

+ $sql = "SELECT COUNT(*) as total, MAX(post_id) as max_post_id

+

+ WHERE post_id

+ BETWEEN $batchstart

+ {

+

+ $sql = "SELECT MAX(topic_id) AS max_topic

+

+ WHERE topic_id

+ BETWEEN $batchstart

+ AND $batchend

+ GROUP BY topic_id

+ $sql = "UPDATE " . TOPICS_TABLE . "

+ SET topic_first_post_id = " . $row['first_post_id'] . "

+ $sql = "SELECT forum_id, forum_name

+ WHERE forum_id = $id

+ $sql = "SELECT MIN(user_regdate) AS oldest_time

+ FROM " . USERS_TABLE . "

+ $sql = "INSERT INTO " . $table_prefix . "config (config_name, config_value)

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

+ SET config_value = '" . $server_name . "'

+ WHERE config_name = 'server_name'

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

+

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

+

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

+

+ $sql = "ALTER TABLE " . $table_prefix . "sessions

+ FORUMS_TABLE => array("forum_access", "forum_moderator", "forum_type"),

+ PRIVMSGS_TABLE => array("msg_text"),

+ RANKS_TABLE => array("rank_max"),

+ $sql = "ALTER TABLE $table