+ 'version' => '1.0.RC3',

+ array('code', 'smilies.code', array('function1' => 'phpbb_smilie_html_decode', 'function2' => 'phpbb_set_encoding', 'function3' => 'utf8_htmlspecialchars')),

+ array('user_dateformat', 'users.user_dateformat', array('function1' => 'phpbb_set_encoding', 'function2' => 'fill_dateformat')),

+ 'prune_next' => (int) null_to_zero($row['prune_next']),

+ 'prune_days' => (int) null_to_zero($row['prune_days']),

+ 'prune_freq' => (int) null_to_zero($row['prune_freq']),

+

+/**

+* Just undos the replacing of '<' and '>'

+*/

+function phpbb_smilie_html_decode($code)

+{

+ $code = str_replace('&lt;', '<', $code);

+ return str_replace('&gt;', '>', $code);

+}

+

+$updates_to_version = '3.0.RC3';

+ // Changes from 3.0.RC2 to the next version

+ '3.0.RC2' => array(

+ // Remove the following keys

+ 'change_columns' => array(

+ BANLIST_TABLE => array(

+ 'ban_reason' => array('VCHAR_UNI', ''),

+ 'ban_give_reason' => array('VCHAR_UNI', ''),

+ ),

+ ),

+ ),

+if (version_compare($current_version, '3.0.RC2', '<='))

+{

+ $smileys = array();

+ $sql = 'SELECT smiley_id, code

+ FROM ' . SMILIES_TABLE;

+

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

+

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

+ {

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

+ }

+ $db->sql_freeresult($result);

+

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

+ {

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

+ if (strchr($code, '"') === false)

+ {

+ continue;

+ }

+ $new_code = str_replace('&amp;', '&', $code);

+ $new_code = str_replace('&lt;', '<', $new_code);

+ $new_code = str_replace('&gt;', '>', $new_code);

+ $new_code = utf8_htmlspecialchars($new_code);

+ $sql = 'UPDATE ' . SMILIES_TABLE . '

+ SET code = \'' . $db->sql_escape($new_code) . '\'

+ WHERE smiley_id = ' . (int)$id;

+ $db->sql_query($sql);

+ }

+

+ $index_list = sql_list_index($map_dbms, ACL_ROLES_DATA_TABLE);

+

+ if (in_array('ath_opt_id', $index_list))

+ {

+ sql_index_drop($map_dbms, 'ath_opt_id', ACL_ROLES_DATA_TABLE);

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

+ }

+

+ $no_updates = false;

+}

+// Reset permissions

+$sql = 'UPDATE ' . USERS_TABLE . "

+ SET user_permissions = ''";

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

+ echo '<li>' . $lang['ERROR'] . ' :: <strong>' . htmlspecialchars($error_ary['error_code'][$i]['message']) . '</strong><br />';

+ echo $lang['SQL'] . ' :: <strong>' . htmlspecialchars($error_ary['sql'][$i]) . '</strong><br /><br /></li>';

+// List all of the indices that belong to a table,

+// does not count:

+// * UNIQUE indices

+// * PRIMARY keys

+function sql_list_index($dbms, $table_name)

+{

+ global $dbms_type_map, $db;

+ global $errored, $error_ary;

+

+ $index_array = array();

+

+ if ($dbms == 'mssql')

+ {

+ $sql = "EXEC sp_statistics '$table_name'";

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

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

+ {

+ if ($row['TYPE'] == 3)

+ {

+ $index_array[] = $row['INDEX_NAME'];

+ }

+ }

+ $db->sql_freeresult($result);

+ }

+ else

+ {

+ switch ($dbms)

+ {

+ case 'firebird':

+ $sql = "SELECT LOWER(RDB$INDEX_NAME) as index_name

+ FROM RDB$INDICES

+ WHERE RDB$RELATION_NAME = " . strtoupper($table_name) . "

+ AND RDB$UNIQUE_FLAG IS NULL

+ AND RDB$FOREIGN_KEY IS NULL";

+ $col = 'index_name';

+ break;

+

+ case 'postgres':

+ $sql = "SELECT ic.relname as index_name

+ FROM pg_class bc, pg_class ic, pg_index i

+ WHERE (bc.oid = i.indrelid)

+ AND (ic.oid = i.indexrelid)

+ AND (bc.relname = '" . $table_name . "')

+ AND (i.indisunique != 't')

+ AND (i.indisprimary != 't')";

+ $col = 'index_name';

+ break;

+

+ case 'mysql_40':

+ case 'mysql_41':

+ $sql = 'SHOW KEYS

+ FROM ' . $table_name .'

+ WHERE Non_unique = 1';

+ $col = 'Key_name';

+ break;

+

+ case 'oracle':

+ $sql = "SELECT index_name

+ FROM user_indexes

+ WHERE table_name = '" . $table_name . "'

+ AND generated = 'N'";

+ break;

+

+ case 'sqlite':

+ $sql = "PRAGMA index_info('" . $table_name . "');";

+ $col = 'name';

+ break;

+ }

+

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

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

+ {

+ $index_array[] = $row[$col];

+ }

+ $db->sql_freeresult($result);

+ }

+

+ return array_map('strtolower', $index_array);

+}

+

+ $default_pos = strpos($column_data['column_type_sql'], ' DEFAULT');

+

+ if ($default_pos === false)

+ {

+ $sql = 'ALTER TABLE ' . $table_name . ' ALTER COLUMN ' . $column_name . ' TYPE ' . $column_data['column_type_sql'];

+ }

+ else

+ {

+ $sql = 'ALTER TABLE ' . $table_name . ' ALTER COLUMN ' . $column_name . ' TYPE ' . substr($column_data['column_type_sql'], 0, $default_pos) . ', ALTER COLUMN ' . $column_name . ' SET ' . substr($column_data['column_type_sql'], $default_pos + 1);

+ }

+ $exe = (DIRECTORY_SEPARATOR == '\\') ? '.exe' : '';

+ $load_extensions[] = $dll . '.' . PHP_SHLIB_SUFFIX;

+ @chmod($phpbb_root_path . 'cache/install_lock', 0666);

+

+ if (!($fp = @fopen($phpbb_root_path . 'config.' . $phpEx, 'w')))

+

+ if ($written)

+ {

+ @chmod($phpbb_root_path . 'config.' . $phpEx, 0644);

+ }

+ // Refresh prosilver css data - this may cause some unhappy users, but

+ $sql = 'SELECT *

+ FROM ' . STYLES_THEME_TABLE . "

+ WHERE theme_name = 'prosilver'";

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

+ $theme = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ if ($theme)

+ {

+ $recache = (empty($theme['theme_data'])) ? true : false;

+ $update_time = time();

+

+ // We test for stylesheet.css because it is faster and most likely the only file changed on common themes

+ if (!$recache && $theme['theme_mtime'] < @filemtime("{$phpbb_root_path}styles/" . $theme['theme_path'] . '/theme/stylesheet.css'))

+ {

+ $recache = true;

+ $update_time = @filemtime("{$phpbb_root_path}styles/" . $theme['theme_path'] . '/theme/stylesheet.css');

+ }

+ else if (!$recache)

+ {

+ $last_change = $theme['theme_mtime'];

+

+ foreach (glob("{$phpbb_root_path}styles/{$theme['theme_path']}/theme/*.css", GLOB_NOSORT) as $file)

+ {

+ if ($last_change < @filemtime($file))

+ {

+ $recache = true;

+ break;

+ }

+ }

+ }

+

+ if ($recache)

+ {

+ include_once($phpbb_root_path . 'includes/acp/acp_styles.' . $phpEx);

+

+ $theme['theme_data'] = acp_styles::db_theme_data($theme);

+ $theme['theme_mtime'] = $update_time;

+

+ // Save CSS contents

+ $sql_ary = array(

+ 'theme_mtime' => $theme['theme_mtime'],

+ 'theme_data' => $theme['theme_data']

+ );

+

+ $sql = 'UPDATE ' . STYLES_THEME_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '

+ WHERE theme_id = ' . $theme['theme_id'];

+ $db->sql_query($sql);

+

+ $cache->destroy('sql', STYLES_THEME_TABLE);

+ }

+ }

+

+ $cache->purge();

+

+ // Got the diff template itself updated? If so, we are able to directly use it

+ if (in_array('adm/style/install_update_diff.html', $this->update_info['files']))

+ {

+ $this->tpl_name = '../../install/update/new/adm/style/install_update_diff';

+ }

+

+ $diff_mode = request_var('diff_mode', 'side_by_side');

+

+ $diff = $this->return_diff($phpbb_root_path . $file, $diff->merged_output());

+ // Do not include style-related or language-related content

+ if (strpos($file, 'styles/') !== 0 && strpos($file, 'language/') !== 0)

+ {

+ $update_list['no_update'][] = $file;

+ }

+ // There is one special case... users having merged with a conflicting file... we need to check this

+ $tmp = array(

+ 'file1' => file_get_contents($phpbb_root_path . $file),

+ 'file2' => implode("\n", $diff->merged_orig_output()),

+ );

+

+ $diff = &new diff($tmp['file1'], $tmp['file2'], false);

+ $empty = $diff->is_empty();

+

+ if ($empty)

+ {

+ unset($update_ary['conflicts']);

+ unset($diff);

+ $update_list['up_to_date'][] = $update_ary;

+ return;

+ }

+

+ $update_list['conflict'][] = $update_ary;

+ unset($diff);

+

+

+ // If info is false the fsockopen function may not be working. Instead get the latest version from our update file (and pray it is up-to-date)

+ if ($info === false)

+ {

+ $update_info = array();

+ include($phpbb_root_path . 'install/update/index.php');

+ $info = (empty($update_info) || !is_array($update_info)) ? false : $update_info;

+

+ if ($info !== false)

+ {

+ $info = (!empty($info['version']['to'])) ? trim($info['version']['to']) : false;

+ }

+ }

+ ban_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

+ ban_give_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE

+ [ban_reason] [varchar] (255) DEFAULT ('') NOT NULL ,

+ [ban_give_reason] [varchar] (255) DEFAULT ('') NOT NULL

+ ban_reason varchar(255) DEFAULT '' NOT NULL,

+ ban_give_reason varchar(255) DEFAULT '' NOT NULL,

+ ban_reason varchar2(765) DEFAULT '' ,

+ ban_give_reason varchar2(765) DEFAULT '' ,

+ ban_reason varchar(255) DEFAULT '' NOT NULL,

+ ban_give_reason varchar(255) DEFAULT '' NOT NULL,

+INSERT INTO phpbb_config (config_name, config_value) VALUES ('load_tplcompile', '1');

+INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '3.0.RC3');

+ ban_reason varchar(255) NOT NULL DEFAULT '',

+ ban_give_reason varchar(255) NOT NULL DEFAULT ''