2555 lines
106 KiB
PHP
2555 lines
106 KiB
PHP
<?php
|
||
|
||
/**
|
||
* Copyright (C) 2008-2012 FluxBB
|
||
* based on code by Rickard Andersson copyright (C) 2002-2008 PunBB
|
||
* License: http://www.gnu.org/licenses/gpl.html GPL version 2 or higher
|
||
*/
|
||
|
||
// Turn on full PHP error reporting
|
||
error_reporting(E_ALL);
|
||
|
||
// Force POSIX locale (to prevent functions such as strtolower() from messing up UTF-8 strings)
|
||
setlocale(LC_CTYPE, 'C');
|
||
|
||
mb_language('uni');
|
||
mb_internal_encoding('UTF-8');
|
||
mb_substitute_character(0xFFFD);
|
||
|
||
// The FluxBB version this script updates to
|
||
define('UPDATE_TO', '1.5.11');
|
||
|
||
define('UPDATE_TO_VER_REVISION', 85); // номер сборки - Visman
|
||
define('LATEST_REV_DB_CHANGES', 79); // последняя ревизия с изменениями БД - Visman
|
||
|
||
define('UPDATE_TO_DB_REVISION', 21);
|
||
define('UPDATE_TO_SI_REVISION', 2.1);
|
||
define('UPDATE_TO_PARSER_REVISION', 2);
|
||
|
||
define('MIN_PHP_VERSION', '7.2.0');
|
||
define('MIN_MYSQL_VERSION', '5.5.3');
|
||
define('MIN_PGSQL_VERSION', '7.0.0');
|
||
define('PUN_SEARCH_MIN_WORD', 3);
|
||
define('PUN_SEARCH_MAX_WORD', 20);
|
||
|
||
// The MySQL connection character set that was used for FluxBB 1.2 - in 99% of cases this should be detected automatically,
|
||
// but can be overridden using the below constant if required.
|
||
//define('FORUM_DEFAULT_CHARSET', 'latin1');
|
||
define('FORUM_DEFAULT_CHARSET', 'cp1251'); // For RUSSIAN - Visman
|
||
|
||
// The number of items to process per page view (lower this if the update script times out during UTF-8 conversion)
|
||
define('PER_PAGE', 300);
|
||
|
||
// Don't set to UTF-8 until after we've found out what the default character set is
|
||
define('FORUM_NO_SET_NAMES', 1);
|
||
|
||
// Make sure we are running at least MIN_PHP_VERSION
|
||
if (!function_exists('version_compare') || version_compare(PHP_VERSION, MIN_PHP_VERSION, '<'))
|
||
exit('You are running PHP version '.PHP_VERSION.'. FluxBB '.UPDATE_TO.' requires at least PHP '.MIN_PHP_VERSION.' to run properly. You must upgrade your PHP installation before you can continue.');
|
||
|
||
define('PUN_ROOT', dirname(__FILE__).'/');
|
||
|
||
// Attempt to load the configuration file config.php
|
||
if (file_exists(PUN_ROOT.'include/config.php'))
|
||
include PUN_ROOT.'include/config.php';
|
||
|
||
// If we have the 1.3-legacy constant defined, define the proper 1.4 constant so we don't get an incorrect "need to install" message
|
||
if (defined('FORUM'))
|
||
define('PUN', FORUM);
|
||
|
||
// If PUN isn't defined, config.php is missing or corrupt
|
||
if (!defined('PUN'))
|
||
{
|
||
header('Location: install.php');
|
||
exit;
|
||
}
|
||
|
||
// Enable debug mode
|
||
if (!defined('PUN_DEBUG'))
|
||
define('PUN_DEBUG', 1);
|
||
|
||
// Load the functions script
|
||
require PUN_ROOT.'include/functions.php';
|
||
|
||
// Strip out "bad" UTF-8 characters
|
||
forum_remove_bad_characters();
|
||
|
||
// If a cookie name is not specified in config.php, we use the default (forum_cookie)
|
||
if (empty($cookie_name))
|
||
$cookie_name = 'pun_cookie';
|
||
|
||
// If the cache directory is not specified, we use the default setting
|
||
if (!defined('FORUM_CACHE_DIR'))
|
||
define('FORUM_CACHE_DIR', PUN_ROOT.'cache/');
|
||
|
||
// Turn off PHP time limit
|
||
@set_time_limit(0);
|
||
|
||
// Define a few commonly used constants
|
||
define('PUN_UNVERIFIED', 0);
|
||
define('PUN_ADMIN', 1);
|
||
define('PUN_MOD', 2);
|
||
define('PUN_GUEST', 3);
|
||
define('PUN_MEMBER', 4);
|
||
|
||
// Load DB abstraction layer and try to connect
|
||
require PUN_ROOT.'include/dblayer/common_db.php';
|
||
|
||
$db->start_transaction();
|
||
|
||
// Check what the default character set is - since 1.2 didn't specify any we will use whatever the default was (usually latin1)
|
||
$old_connection_charset = defined('FORUM_DEFAULT_CHARSET') ? FORUM_DEFAULT_CHARSET : $db->get_names();
|
||
|
||
// Set the connection to UTF-8 now
|
||
$db->set_names('utf8');
|
||
|
||
// Get the forum config
|
||
$result = $db->query('SELECT * FROM '.$db->prefix.'config') or error('Unable to fetch config.', __FILE__, __LINE__, $db->error());
|
||
while ($cur_config_item = $db->fetch_row($result))
|
||
$pun_config[$cur_config_item[0]] = $cur_config_item[1];
|
||
|
||
// Load language file
|
||
$default_lang = $pun_config['o_default_lang'];
|
||
|
||
if (!file_exists(PUN_ROOT.'lang/'.$default_lang.'/update.php'))
|
||
$default_lang = 'English';
|
||
|
||
require PUN_ROOT.'lang/'.$default_lang.'/common.php';
|
||
require PUN_ROOT.'lang/'.$default_lang.'/update.php';
|
||
|
||
// Check current version
|
||
$cur_version = $pun_config['o_cur_version'];
|
||
|
||
if (version_compare($cur_version, '1.2', '<'))
|
||
error(sprintf($lang_update['Version mismatch error'], $db_name));
|
||
|
||
// Do some DB type specific checks
|
||
$mysql = false;
|
||
switch ($db_type)
|
||
{
|
||
case 'mysql':
|
||
case 'mysqli':
|
||
case 'mysql_innodb':
|
||
case 'mysqli_innodb':
|
||
$mysql_info = $db->get_version();
|
||
if (version_compare($mysql_info['version'], MIN_MYSQL_VERSION, '<'))
|
||
error(sprintf($lang_update['You are running error'], 'MySQL', $mysql_info['version'], UPDATE_TO, MIN_MYSQL_VERSION));
|
||
|
||
$mysql = true;
|
||
break;
|
||
|
||
case 'pgsql':
|
||
$pgsql_info = $db->get_version();
|
||
if (version_compare($pgsql_info['version'], MIN_PGSQL_VERSION, '<'))
|
||
error(sprintf($lang_update['You are running error'], 'PostgreSQL', $pgsql_info['version'], UPDATE_TO, MIN_PGSQL_VERSION));
|
||
|
||
break;
|
||
}
|
||
|
||
// Check the database, search index and parser revision and the current version
|
||
if (isset($pun_config['o_database_revision']) && $pun_config['o_database_revision'] >= UPDATE_TO_DB_REVISION &&
|
||
isset($pun_config['o_searchindex_revision']) && $pun_config['o_searchindex_revision'] >= UPDATE_TO_SI_REVISION &&
|
||
isset($pun_config['o_parser_revision']) && $pun_config['o_parser_revision'] >= UPDATE_TO_PARSER_REVISION &&
|
||
isset($pun_config['o_cur_ver_revision']) && $pun_config['o_cur_ver_revision'] >= UPDATE_TO_VER_REVISION &&
|
||
version_compare($pun_config['o_cur_version'], UPDATE_TO, '>='))
|
||
error($lang_update['No update error']);
|
||
|
||
$default_style = $pun_config['o_default_style'];
|
||
if (!file_exists(PUN_ROOT.'style/'.$default_style.'.css'))
|
||
$default_style = 'Air';
|
||
|
||
// Start a session, used to queue up errors if duplicate users occur when converting from FluxBB v1.2.
|
||
session_start();
|
||
|
||
//
|
||
// Determines whether $str is UTF-8 encoded or not
|
||
//
|
||
function seems_utf8($str)
|
||
{
|
||
$str_len = strlen($str);
|
||
for ($i = 0; $i < $str_len; ++$i)
|
||
{
|
||
if (ord($str[$i]) < 0x80) continue; # 0bbbbbbb
|
||
else if ((ord($str[$i]) & 0xE0) == 0xC0) $n=1; # 110bbbbb
|
||
else if ((ord($str[$i]) & 0xF0) == 0xE0) $n=2; # 1110bbbb
|
||
else if ((ord($str[$i]) & 0xF8) == 0xF0) $n=3; # 11110bbb
|
||
else if ((ord($str[$i]) & 0xFC) == 0xF8) $n=4; # 111110bb
|
||
else if ((ord($str[$i]) & 0xFE) == 0xFC) $n=5; # 1111110b
|
||
else return false; # Does not match any model
|
||
|
||
for ($j = 0; $j < $n; ++$j) # n bytes matching 10bbbbbb follow ?
|
||
{
|
||
if ((++$i == strlen($str)) || ((ord($str[$i]) & 0xC0) != 0x80))
|
||
return false;
|
||
}
|
||
}
|
||
|
||
return true;
|
||
}
|
||
|
||
|
||
//
|
||
// Translates the number from a HTML numeric entity into an UTF-8 character
|
||
//
|
||
function dcr2utf8($src)
|
||
{
|
||
$dest = '';
|
||
if ($src < 0)
|
||
return false;
|
||
else if ($src <= 0x007f)
|
||
$dest .= chr($src);
|
||
else if ($src <= 0x07ff)
|
||
{
|
||
$dest .= chr(0xc0 | ($src >> 6));
|
||
$dest .= chr(0x80 | ($src & 0x003f));
|
||
}
|
||
else if ($src == 0xFEFF)
|
||
{
|
||
// nop -- zap the BOM
|
||
}
|
||
else if ($src >= 0xD800 && $src <= 0xDFFF)
|
||
{
|
||
// found a surrogate
|
||
return false;
|
||
}
|
||
else if ($src <= 0xffff)
|
||
{
|
||
$dest .= chr(0xe0 | ($src >> 12));
|
||
$dest .= chr(0x80 | (($src >> 6) & 0x003f));
|
||
$dest .= chr(0x80 | ($src & 0x003f));
|
||
}
|
||
else if ($src <= 0x10ffff)
|
||
{
|
||
$dest .= chr(0xf0 | ($src >> 18));
|
||
$dest .= chr(0x80 | (($src >> 12) & 0x3f));
|
||
$dest .= chr(0x80 | (($src >> 6) & 0x3f));
|
||
$dest .= chr(0x80 | ($src & 0x3f));
|
||
}
|
||
else
|
||
{
|
||
// out of range
|
||
return false;
|
||
}
|
||
|
||
return $dest;
|
||
}
|
||
|
||
|
||
//
|
||
// Attempts to convert $str from $old_charset to UTF-8. Also converts HTML entities (including numeric entities) to UTF-8 characters
|
||
//
|
||
function convert_to_utf8(&$str, $old_charset)
|
||
{
|
||
if (is_null($str) || $str == '')
|
||
return false;
|
||
|
||
$save = $str;
|
||
|
||
if ($old_charset != 'UTF-8' && !seems_utf8($str))
|
||
{
|
||
// Visman
|
||
if (function_exists('iconv') && strpos($old_charset, '1251') !== false)
|
||
$str = iconv('CP1251', 'UTF-8//IGNORE//TRANSLIT', $str);
|
||
else if (function_exists('mb_convert_encoding') && strpos($old_charset, '1251') !== false)
|
||
$str = mb_convert_encoding($str, 'UTF-8', 'CP1251');
|
||
// Visman
|
||
else if (function_exists('iconv'))
|
||
$str = iconv(!empty($old_charset) ? $old_charset : 'ISO-8859-1', 'UTF-8', $str);
|
||
else if (function_exists('mb_convert_encoding'))
|
||
$str = mb_convert_encoding($str, 'UTF-8', !empty($old_charset) ? $old_charset : 'ISO-8859-1');
|
||
}
|
||
|
||
// Replace literal entities (for UTF-8 compliant html_entity_encode)
|
||
$str = html_entity_decode($str, ENT_QUOTES, 'UTF-8');
|
||
|
||
// Replace numeric entities
|
||
$str = preg_replace_callback('%&#([0-9]+);%', 'utf8_callback_1', $str);
|
||
$str = preg_replace_callback('%&#x([a-f0-9]+);%i', 'utf8_callback_2', $str);
|
||
|
||
// Remove "bad" characters
|
||
$str = remove_bad_characters($str);
|
||
|
||
return ($save != $str);
|
||
}
|
||
|
||
|
||
function utf8_callback_1($matches)
|
||
{
|
||
return dcr2utf8($matches[1]);
|
||
}
|
||
|
||
|
||
function utf8_callback_2($matches)
|
||
{
|
||
return dcr2utf8(hexdec($matches[1]));
|
||
}
|
||
|
||
|
||
//
|
||
// Alter a table to be utf8. MySQL only
|
||
// Function based on update_convert_table_utf8() from the Drupal project (http://drupal.org/)
|
||
//
|
||
function alter_table_utf8($table)
|
||
{
|
||
global $mysql, $db;
|
||
static $types;
|
||
|
||
if (!$mysql)
|
||
return;
|
||
|
||
if (!isset($types))
|
||
{
|
||
$types = array(
|
||
'char' => 'binary',
|
||
'varchar' => 'varbinary',
|
||
'tinytext' => 'tinyblob',
|
||
'mediumtext' => 'mediumblob',
|
||
'text' => 'blob',
|
||
'longtext' => 'longblob'
|
||
);
|
||
}
|
||
|
||
// Set table default charset to utf8
|
||
$db->query('ALTER TABLE '.$table.' CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci') or error('Unable to set table character set', __FILE__, __LINE__, $db->error());
|
||
|
||
// Find out which columns need converting and build SQL statements
|
||
$result = $db->query('SHOW FULL COLUMNS FROM '.$table) or error('Unable to fetch column information', __FILE__, __LINE__, $db->error());
|
||
while ($cur_column = $db->fetch_assoc($result))
|
||
{
|
||
if (is_null($cur_column['Collation']))
|
||
continue;
|
||
|
||
list($type) = explode('(', $cur_column['Type']);
|
||
if (isset($types[$type]) && strpos($cur_column['Collation'], 'utf8mb4') === false)
|
||
{
|
||
$allow_null = $cur_column['Null'] == 'YES';
|
||
$collate = substr($cur_column['Collation'], -3) == 'bin' ? 'utf8mb4_bin' : 'utf8mb4_unicode_ci';
|
||
|
||
// $db->alter_field($table, $cur_column['Field'], preg_replace('%'.$type.'%i', $types[$type], $cur_column['Type']), $allow_null, $cur_column['Default'], null, true) or error('Unable to alter field to binary', __FILE__, __LINE__, $db->error());
|
||
$db->alter_field($table, $cur_column['Field'], $cur_column['Type'].' CHARACTER SET utf8mb4 COLLATE '.$collate, $allow_null, $cur_column['Default'], null, true) or error('Unable to alter field to utf8mb4', __FILE__, __LINE__, $db->error());
|
||
}
|
||
}
|
||
}
|
||
|
||
//
|
||
// Safely converts text type columns into utf8
|
||
// If finished returns true, otherwise returns $end_at
|
||
//
|
||
function convert_table_utf8($table, $callback, $old_charset, $key = null, $start_at = null, $error_callback = null)
|
||
{
|
||
global $mysql, $db, $old_connection_charset;
|
||
|
||
$finished = true;
|
||
$end_at = 0;
|
||
if ($mysql)
|
||
{
|
||
// Only set up the tables if we are doing this in 1 go, or it's the first go
|
||
if (is_null($start_at) || $start_at == 0)
|
||
{
|
||
// Drop any temp table that exists, in-case it's left over from a failed update
|
||
$db->drop_table($table.'_utf8', true) or error('Unable to drop left over temp table', __FILE__, __LINE__, $db->error());
|
||
|
||
// Copy the table
|
||
$db->query('CREATE TABLE '.$table.'_utf8 LIKE '.$table) or error('Unable to create new table', __FILE__, __LINE__, $db->error());
|
||
|
||
// Set table default charset to utf8
|
||
alter_table_utf8($table.'_utf8');
|
||
}
|
||
|
||
// Change to the old character set so MySQL doesn't attempt to perform conversion on the data from the old table
|
||
$db->set_names($old_connection_charset);
|
||
|
||
// Move & Convert everything
|
||
$result = $db->query('SELECT * FROM '.$table.(is_null($start_at) ? '' : ' WHERE '.$key.'>'.$start_at).' ORDER BY '.$key.' ASC'.(is_null($start_at) ? '' : ' LIMIT '.PER_PAGE), false) or error('Unable to select from old table', __FILE__, __LINE__, $db->error());
|
||
|
||
// Change back to utf8 mode so we can insert it into the new table
|
||
$db->set_names('utf8');
|
||
|
||
while ($cur_item = $db->fetch_assoc($result))
|
||
{
|
||
$cur_item = call_user_func($callback, $cur_item, $old_charset);
|
||
|
||
$temp = array();
|
||
foreach ($cur_item as $idx => $value)
|
||
$temp[$idx] = is_null($value) ? 'NULL' : '\''.$db->escape($value).'\'';
|
||
|
||
$db->query('INSERT INTO '.$table.'_utf8('.implode(',', array_keys($temp)).') VALUES ('.implode(',', array_values($temp)).')') or (is_null($error_callback) ? error('Unable to insert data to new table', __FILE__, __LINE__, $db->error()) : call_user_func($error_callback, $cur_item));
|
||
|
||
$end_at = $cur_item[$key];
|
||
}
|
||
|
||
// If we aren't doing this all in 1 go and $end_at has a value (i.e. we have processed at least 1 row), figure out if we have more to do or not
|
||
if (!is_null($start_at) && $end_at > 0)
|
||
{
|
||
$result = $db->query('SELECT 1 FROM '.$table.' WHERE '.$key.'>'.$end_at.' ORDER BY '.$key.' ASC LIMIT 1') or error('Unable to check for next row', __FILE__, __LINE__, $db->error());
|
||
$finished = empty($db->result($result));
|
||
}
|
||
|
||
// Only swap the tables if we are doing this in 1 go, or it's the last go
|
||
if ($finished)
|
||
{
|
||
// Delete old table
|
||
$db->drop_table($table, true) or error('Unable to drop old table', __FILE__, __LINE__, $db->error());
|
||
|
||
// Rename table
|
||
$db->query('ALTER TABLE '.$table.'_utf8 RENAME '.$table) or error('Unable to rename new table', __FILE__, __LINE__, $db->error());
|
||
|
||
return true;
|
||
}
|
||
|
||
return $end_at;
|
||
}
|
||
else
|
||
{
|
||
// Convert everything
|
||
$result = $db->query('SELECT * FROM '.$table.(is_null($start_at) ? '' : ' WHERE '.$key.'>'.$start_at).' ORDER BY '.$key.' ASC'.(is_null($start_at ) ? '' : ' LIMIT '.PER_PAGE)) or error('Unable to select from table', __FILE__, __LINE__, $db->error());
|
||
while ($cur_item = $db->fetch_assoc($result))
|
||
{
|
||
$cur_item = call_user_func($callback, $cur_item, $old_charset);
|
||
|
||
$temp = array();
|
||
foreach ($cur_item as $idx => $value)
|
||
$temp[] = $idx.'='.(is_null($value) ? 'NULL' : '\''.$db->escape($value).'\'');
|
||
|
||
if (!empty($temp))
|
||
$db->query('UPDATE '.$table.' SET '.implode(', ', $temp).' WHERE '.$key.'=\''.$db->escape($cur_item[$key]).'\'') or error('Unable to update data', __FILE__, __LINE__, $db->error());
|
||
|
||
$end_at = $cur_item[$key];
|
||
}
|
||
|
||
if (!is_null($start_at) && $end_at > 0)
|
||
{
|
||
$result = $db->query('SELECT 1 FROM '.$table.' WHERE '.$key.'>'.$end_at.' ORDER BY '.$key.' ASC LIMIT 1') or error('Unable to check for next row', __FILE__, __LINE__, $db->error());
|
||
|
||
if (empty($db->result($result)))
|
||
return true;
|
||
|
||
return $end_at;
|
||
}
|
||
|
||
return true;
|
||
}
|
||
}
|
||
|
||
|
||
header('Content-type: text/html; charset=utf-8');
|
||
|
||
// Empty all output buffers and stop buffering
|
||
while (@ob_end_clean());
|
||
|
||
|
||
$stage = is_string($_REQUEST['stage'] ?? null) ? $_REQUEST['stage'] : '';
|
||
$old_charset = is_string($_REQUEST['req_old_charset'] ?? null) ? str_replace('ISO8859', 'ISO-8859', strtoupper($_REQUEST['req_old_charset'])) : 'ISO-8859-1';
|
||
$start_at = is_numeric($_REQUEST['start_at'] ?? null) ? intval($_REQUEST['start_at']) : 0;
|
||
$query_str = '';
|
||
|
||
if (0 !== preg_match('%[^\w-]%', $old_charset))
|
||
exit('Bad charset. Invalid character found.');
|
||
|
||
// Show form
|
||
if (empty($stage))
|
||
{
|
||
if (file_exists(FORUM_CACHE_DIR.'db_update.lock'))
|
||
{
|
||
// Deal with newlines, tabs and multiple spaces
|
||
$pattern = array("\t", ' ', ' ');
|
||
$replace = array('    ', '  ', '  ');
|
||
$message = str_replace($pattern, $replace, $pun_config['o_maintenance_message']);
|
||
|
||
?>
|
||
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<?php echo $lang_common['lang_identifier'] ?>" lang="<?php echo $lang_common['lang_identifier'] ?>" dir="<?php echo $lang_common['lang_direction'] ?>">
|
||
<head>
|
||
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
<title><?php echo $lang_update['Maintenance'] ?></title>
|
||
<link rel="stylesheet" type="text/css" href="style/<?php echo $default_style ?>.css" />
|
||
</head>
|
||
<body>
|
||
|
||
<div id="punmaint" class="pun">
|
||
<div class="top-box"><div><!-- Top Corners --></div></div>
|
||
<div class="punwrap">
|
||
|
||
<div id="brdmain">
|
||
<div class="block">
|
||
<h2><?php echo $lang_update['Maintenance'] ?></h2>
|
||
<div class="box">
|
||
<div class="inbox">
|
||
<p><?php echo $message ?></p>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
</div>
|
||
<div class="end-box"><div><!-- Bottom Corners --></div></div>
|
||
</div>
|
||
|
||
</body>
|
||
</html>
|
||
<?php
|
||
|
||
}
|
||
else
|
||
{
|
||
|
||
?>
|
||
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
|
||
|
||
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<?php echo $lang_common['lang_identifier'] ?>" lang="<?php echo $lang_common['lang_identifier'] ?>" dir="<?php echo $lang_common['lang_direction'] ?>">
|
||
<head>
|
||
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
<title><?php echo $lang_update['Update'] ?></title>
|
||
<link rel="stylesheet" type="text/css" href="style/<?php echo $default_style ?>.css" />
|
||
</head>
|
||
<body onload="document.getElementById('install').req_db_pass.focus();document.getElementById('install').start.disabled=false;">
|
||
|
||
<div id="pundb_update" class="pun">
|
||
<div class="top-box"><div><!-- Top Corners --></div></div>
|
||
<div class="punwrap">
|
||
|
||
<div id="brdheader" class="block">
|
||
<div class="box">
|
||
<div id="brdtitle" class="inbox">
|
||
<h1><span><?php echo $lang_update['Update'] ?></span></h1>
|
||
<div id="brddesc"><p><?php echo $lang_update['Update message'] ?></p><p><strong><?php echo $lang_update['Note']; ?></strong> <?php echo $lang_update['Members message']; ?></p></div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
<div id="brdmain">
|
||
<div class="blockform">
|
||
<h2><span><?php echo $lang_update['Update'] ?></span></h2>
|
||
<div class="box">
|
||
<form id="install" method="post" action="db_update.php">
|
||
<div class="inform">
|
||
<input type="hidden" name="stage" value="start" />
|
||
<fieldset>
|
||
<legend><?php echo $lang_update['Administrator only'] ?></legend>
|
||
<div class="infldset">
|
||
<p><?php echo $lang_update['Database password info'] ?></p>
|
||
<p><strong><?php echo $lang_update['Note']; ?></strong> <?php echo $lang_update['Database password note'] ?></p>
|
||
<label class="required"><strong><?php echo $lang_update['Database password'] ?> <span><?php echo $lang_update['Required'] ?></span></strong><br /><input type="password" id="req_db_pass" name="req_db_pass" /><br /></label>
|
||
<p><?php echo $lang_update['Maintenance message info'] ?></p>
|
||
<div class="txtarea">
|
||
<label class="required"><strong><?php echo $lang_update['Maintenance message'] ?> <span><?php echo $lang_update['Required'] ?></span></strong><br />
|
||
<textarea name="req_maintenance_message" rows="4" cols="65"><?php echo pun_htmlspecialchars($pun_config['o_maintenance_message']) ?></textarea><br /></label>
|
||
</div>
|
||
</div>
|
||
</fieldset>
|
||
</div>
|
||
<div class="inform">
|
||
<div class="forminfo">
|
||
<p><?php echo $lang_update['Intro 1'] ?></p>
|
||
<p><?php echo $lang_update['Intro 2'] ?></p>
|
||
<?php
|
||
|
||
if (strpos($cur_version, '1.2') === 0)
|
||
{
|
||
if (!function_exists('iconv') && !function_exists('mb_convert_encoding'))
|
||
{
|
||
|
||
?>
|
||
<p><?php echo $lang_update['No charset conversion'] ?></p>
|
||
<?php
|
||
|
||
}
|
||
|
||
?>
|
||
</div>
|
||
</div>
|
||
<div class="inform">
|
||
<div class="forminfo">
|
||
<p><?php echo $lang_update['Enable conversion'] ?></p>
|
||
<p><?php echo $lang_update['Current character set'] ?></p>
|
||
</div>
|
||
<fieldset>
|
||
<legend><?php echo $lang_update['Charset conversion'] ?></legend>
|
||
<div class="infldset">
|
||
<div class="rbox">
|
||
<label><input type="checkbox" name="convert_charset" value="1" checked="checked" /><?php echo $lang_update['Enable conversion label'] ?><br /></label>
|
||
</div>
|
||
<label>
|
||
<strong><?php echo $lang_update['Current character set label'] ?></strong><br /><?php echo $lang_update['Current character set info'] ?><br />
|
||
<input type="text" name="req_old_charset" size="12" maxlength="20" value="<?php echo $old_charset ?>" /><br />
|
||
</label>
|
||
</div>
|
||
</fieldset>
|
||
<?php
|
||
|
||
}
|
||
else
|
||
echo "\t\t\t\t".'</div>'."\n";
|
||
|
||
?>
|
||
</div>
|
||
<p class="buttons"><input type="submit" name="start" value="<?php echo $lang_update['Start update'] ?>" /></p>
|
||
</form>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
</div>
|
||
<div class="end-box"><div><!-- Bottom Corners --></div></div>
|
||
</div>
|
||
|
||
</body>
|
||
</html>
|
||
<?php
|
||
|
||
}
|
||
$db->end_transaction();
|
||
$db->close();
|
||
exit;
|
||
|
||
}
|
||
|
||
// Read the lock file
|
||
$lock = file_exists(FORUM_CACHE_DIR.'db_update.lock') ? trim(file_get_contents(FORUM_CACHE_DIR.'db_update.lock')) : false;
|
||
$lock_error = false;
|
||
|
||
// Generate or fetch the UID - this confirms we have a valid admin
|
||
if (isset($_POST['req_db_pass']))
|
||
{
|
||
$req_db_pass = strtolower(pun_trim($_POST['req_db_pass']));
|
||
|
||
switch ($db_type)
|
||
{
|
||
// For SQLite we compare against the database file name, since the password is left blank
|
||
case 'sqlite3':
|
||
if ($req_db_pass != strtolower($db_name))
|
||
error(sprintf($lang_update['Invalid file error'], 'config.php'));
|
||
|
||
break;
|
||
// For everything else, check the password matches
|
||
default:
|
||
if ($req_db_pass != strtolower($db_password))
|
||
error(sprintf($lang_update['Invalid password error'], 'config.php'));
|
||
|
||
break;
|
||
}
|
||
|
||
// Visman - test for DB for a list of actions required to update
|
||
if (empty($pun_config['o_cur_ver_revision']) || $pun_config['o_cur_ver_revision'] < LATEST_REV_DB_CHANGES)
|
||
{
|
||
$test_table = 'test_tb_for_update';
|
||
|
||
if ($db->table_exists($test_table))
|
||
error("The {$test_table} table already exists. Delete it.");
|
||
|
||
$schema = array(
|
||
'FIELDS' => array(
|
||
'id' => array(
|
||
'datatype' => 'SERIAL',
|
||
'allow_null' => false
|
||
),
|
||
),
|
||
'INDEXES' => array(
|
||
'id_idx' => array('id')
|
||
)
|
||
);
|
||
|
||
$db->create_table($test_table, $schema) or error("Unable to create {$test_table} table", __FILE__, __LINE__, $db->error());
|
||
$db->add_field($test_table, 'test_field', 'VARCHAR(80)', false, '') or error('Unable to add test_field field', __FILE__, __LINE__, $db->error());
|
||
$db->query('INSERT INTO '.$db->prefix.$test_table.' (test_field) VALUES (\'TEST_VALUE\')') or error("Unable to insert line to {$test_table} table" , __FILE__, __LINE__, $db->error());
|
||
$db->drop_field($test_table, 'test_field') or error('Unable to drop test_field field', __FILE__, __LINE__, $db->error());
|
||
$db->drop_table($test_table) or error("Unable to drop {$test_table} table", __FILE__, __LINE__, $db->error());
|
||
}
|
||
// Visman - test for DB for a list of actions required to update
|
||
|
||
// Generate a unique id to identify this session, only if this is a valid session
|
||
$uid = pun_hash($req_db_pass.'|'.random_key(11));
|
||
if ($lock) // We already have a lock file
|
||
$lock_error = true;
|
||
else // Create the lock file
|
||
{
|
||
$fh = @fopen(FORUM_CACHE_DIR.'db_update.lock', 'wb');
|
||
if (!$fh)
|
||
error(sprintf($lang_update['Unable to lock error'], 'cache'));
|
||
|
||
fwrite($fh, $uid);
|
||
fclose($fh);
|
||
|
||
// Update maintenance message
|
||
if (! empty($_POST['req_maintenance_message']))
|
||
$maintenance_message = pun_linebreaks(pun_trim($_POST['req_maintenance_message']));
|
||
else
|
||
{
|
||
// Load the admin_options.php language file
|
||
require PUN_ROOT.'lang/'.$default_lang.'/admin_options.php';
|
||
|
||
$maintenance_message = $lang_admin_options['Default maintenance message'];
|
||
}
|
||
|
||
$db->query('UPDATE '.$db->prefix.'config SET conf_value=\''.$db->escape($maintenance_message).'\' WHERE conf_name=\'o_maintenance_message\'') or error('Unable to update board config', __FILE__, __LINE__, $db->error());
|
||
|
||
// Regenerate the config cache
|
||
if (!defined('FORUM_CACHE_FUNCTIONS_LOADED'))
|
||
require PUN_ROOT.'include/cache.php';
|
||
|
||
generate_config_cache();
|
||
}
|
||
}
|
||
else if (isset($_GET['uid']))
|
||
{
|
||
$uid = pun_trim($_GET['uid']);
|
||
if (!$lock || $lock !== $uid) // The lock doesn't exist or doesn't match the given UID
|
||
$lock_error = true;
|
||
}
|
||
else
|
||
error($lang_update['No password error']);
|
||
|
||
// If there is an error with the lock file
|
||
if ($lock_error)
|
||
error(sprintf($lang_update['Script runs error'], FORUM_CACHE_DIR.'db_update.lock'));
|
||
|
||
switch ($stage)
|
||
{
|
||
// Start by updating the database structure
|
||
case 'start':
|
||
$query_str = '?stage=preparse_posts';
|
||
|
||
// If we don't need to update the database, skip this stage
|
||
if (isset($pun_config['o_database_revision']) && $pun_config['o_database_revision'] >= UPDATE_TO_DB_REVISION)
|
||
break;
|
||
|
||
// Make all email fields VARCHAR(80)
|
||
$db->alter_field('bans', 'email', 'VARCHAR(80)', true) or error('Unable to alter email field', __FILE__, __LINE__, $db->error());
|
||
$db->alter_field('posts', 'poster_email', 'VARCHAR(80)', true) or error('Unable to alter poster_email field', __FILE__, __LINE__, $db->error());
|
||
$db->alter_field('users', 'email', 'VARCHAR(80)', false, '') or error('Unable to alter email field', __FILE__, __LINE__, $db->error());
|
||
$db->alter_field('users', 'jabber', 'VARCHAR(80)', true) or error('Unable to alter jabber field', __FILE__, __LINE__, $db->error());
|
||
$db->alter_field('users', 'msn', 'VARCHAR(80)', true) or error('Unable to alter msn field', __FILE__, __LINE__, $db->error());
|
||
$db->alter_field('users', 'activate_string', 'VARCHAR(255)', true) or error('Unable to alter activate_string field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Make all IP fields VARCHAR(39) to support IPv6
|
||
$db->alter_field('posts', 'poster_ip', 'VARCHAR(39)', true) or error('Unable to alter poster_ip field', __FILE__, __LINE__, $db->error());
|
||
$db->alter_field('users', 'registration_ip', 'VARCHAR(39)', false, '0.0.0.0') or error('Unable to alter registration_ip field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Make the message field MEDIUMTEXT to allow proper conversion of 65535 character posts to UTF-8
|
||
$db->alter_field('posts', 'message', 'MEDIUMTEXT', true) or error('Unable to alter message field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add the DST option to the users table
|
||
$db->add_field('users', 'dst', 'TINYINT(1)', false, 0, 'timezone') or error('Unable to add dst field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add the last_post column to the online table
|
||
$db->add_field('online', 'last_post', 'INT(10) UNSIGNED', true, null, null) or error('Unable to add last_post field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add the last_search column to the online table
|
||
$db->add_field('online', 'last_search', 'INT(10) UNSIGNED', true, null, null) or error('Unable to add last_search field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add the last_search column to the users table
|
||
$db->add_field('users', 'last_search', 'INT(10) UNSIGNED', true, null, 'last_post') or error('Unable to add last_search field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Drop use_avatar column from users table
|
||
$db->drop_field('users', 'use_avatar') or error('Unable to drop use_avatar field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Drop save_pass column from users table
|
||
$db->drop_field('users', 'save_pass') or error('Unable to drop save_pass field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Drop g_edit_subjects_interval column from groups table
|
||
$db->drop_field('groups', 'g_edit_subjects_interval');
|
||
|
||
// Add database revision number
|
||
if (!array_key_exists('o_database_revision', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_database_revision\', \'0\')') or error('Unable to insert config value \'o_database_revision\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add search index revision number
|
||
if (!array_key_exists('o_searchindex_revision', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_searchindex_revision\', \'0\')') or error('Unable to insert config value \'o_searchindex_revision\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add parser revision number
|
||
if (!array_key_exists('o_parser_revision', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_parser_revision\', \'0\')') or error('Unable to insert config value \'o_parser_revision\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add default email setting option
|
||
if (!array_key_exists('o_default_email_setting', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_default_email_setting\', \'1\')') or error('Unable to insert config value \'o_default_email_setting\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Make sure we have o_additional_navlinks (was added in 1.2.1)
|
||
if (!array_key_exists('o_additional_navlinks', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_additional_navlinks\', \'\')') or error('Unable to insert config value \'o_additional_navlinks\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Insert new config option o_topic_views
|
||
if (!array_key_exists('o_topic_views', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_topic_views\', \'1\')') or error('Unable to insert config value \'o_topic_views\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Insert new config option o_signatures
|
||
if (!array_key_exists('o_signatures', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_signatures\', \'1\')') or error('Unable to insert config value \'o_signatures\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Insert new config option o_smtp_ssl
|
||
if (!array_key_exists('o_smtp_ssl', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_smtp_ssl\', \'0\')') or error('Unable to insert config value \'o_smtp_ssl\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Insert new config option o_default_dst
|
||
if (!array_key_exists('o_default_dst', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_default_dst\', \'0\')') or error('Unable to insert config value \'o_default_dst\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Insert new config option o_quote_depth
|
||
if (!array_key_exists('o_quote_depth', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_quote_depth\', \'3\')') or error('Unable to insert config value \'o_quote_depth\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Insert new config option o_feed_type
|
||
if (!array_key_exists('o_feed_type', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_feed_type\', \'2\')') or error('Unable to insert config value \'o_feed_type\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Insert new config option o_feed_ttl
|
||
if (!array_key_exists('o_feed_ttl', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_feed_ttl\', \'0\')') or error('Unable to insert config value \'o_feed_ttl\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Insert config option o_base_url which was removed in 1.3
|
||
if (!array_key_exists('o_base_url', $pun_config))
|
||
{
|
||
// If it isn't in $pun_config['o_base_url'] it should be in $base_url, but just in-case it isn't we can make a guess at it
|
||
if (!isset($base_url))
|
||
{
|
||
// Make an educated guess regarding base_url
|
||
$base_url = !empty($_SERVER['HTTPS']) && strtolower($_SERVER['HTTPS']) != 'off' ? 'https://' : 'http://'; // protocol
|
||
$base_url .= preg_replace('%:(80|443)$%', '', $_SERVER['HTTP_HOST']); // host[:port]
|
||
$base_url .= str_replace('\\', '/', dirname($_SERVER['SCRIPT_NAME'])); // path
|
||
}
|
||
|
||
if (substr($base_url, -1) == '/')
|
||
$base_url = substr($base_url, 0, -1);
|
||
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_base_url\', \''.$db->escape($base_url).'\')') or error('Unable to insert config value \'o_base_url\'', __FILE__, __LINE__, $db->error());
|
||
}
|
||
|
||
if (strpos($cur_version, '1.2') === 0)
|
||
{
|
||
// Groups are almost the same as 1.2:
|
||
// unverified: 32000 -> 0
|
||
|
||
$db->query('UPDATE '.$db->prefix.'users SET group_id = 0 WHERE group_id = 32000') or error('Unable to update unverified users', __FILE__, __LINE__, $db->error());
|
||
}
|
||
else if (strpos($cur_version, '1.3') === 0)
|
||
{
|
||
// Groups have changed quite a lot from 1.3:
|
||
// unverified: 0 -> 0
|
||
// admin: 1 -> 1
|
||
// mod: ? -> 2
|
||
// guest: 2 -> 3
|
||
// member: ? -> 4
|
||
|
||
$result = $db->query('SELECT MAX(g_id) + 1 FROM '.$db->prefix.'groups') or error('Unable to select temp group ID', __FILE__, __LINE__, $db->error());
|
||
$temp_id = $db->result($result);
|
||
|
||
$result = $db->query('SELECT g_id FROM '.$db->prefix.'groups WHERE g_moderator = 1 AND g_id > 1 LIMIT 1') or error('Unable to select moderator group', __FILE__, __LINE__, $db->error());
|
||
$mod_gid = $db->result($result);
|
||
|
||
if (empty($mod_gid))
|
||
{
|
||
$db->query('INSERT INTO '.$db->prefix.'groups (g_title, g_user_title, g_moderator, g_mod_edit_users, g_mod_rename_users, g_mod_change_passwords, g_mod_ban_users, g_read_board, g_view_users, g_post_replies, g_post_topics, g_edit_posts, g_delete_posts, g_delete_topics, g_set_title, g_search, g_search_users, g_send_email, g_post_flood, g_search_flood, g_email_flood, g_report_flood) VALUES ('."'Moderators', 'Moderator', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0)") or error('Unable to add group', __FILE__, __LINE__, $db->error());
|
||
$mod_gid = $db->insert_id();
|
||
}
|
||
|
||
$member_gid = $pun_config['o_default_user_group'];
|
||
|
||
// move the mod group to a temp place
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_id = '.$temp_id.' WHERE g_id = '.$mod_gid) or error('Unable to update group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'users SET group_id = '.$temp_id.' WHERE group_id = '.$mod_gid) or error('Unable to update users group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'forum_perms SET group_id = '.$temp_id.' WHERE group_id = '.$mod_gid) or error('Unable to forum_perms group ID', __FILE__, __LINE__, $db->error());
|
||
if ($member_gid == $mod_gid) $member_gid = $temp_id;
|
||
|
||
// move whoever is in 3 to a spare slot
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_id = '.$mod_gid.' WHERE g_id = 3') or error('Unable to update group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'users SET group_id = '.$mod_gid.' WHERE group_id = 3') or error('Unable to update users group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'forum_perms SET group_id = '.$mod_gid.' WHERE group_id = 3') or error('Unable to forum_perms group ID', __FILE__, __LINE__, $db->error());
|
||
if ($member_gid == 3) $member_gid = $mod_gid;
|
||
|
||
// move guest to 3
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_id = 3 WHERE g_id = 2') or error('Unable to update group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'users SET group_id = 3 WHERE group_id = 2') or error('Unable to update users group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'forum_perms SET group_id = 3 WHERE group_id = 2') or error('Unable to forum_perms group ID', __FILE__, __LINE__, $db->error());
|
||
if ($member_gid == 2) $member_gid = 3;
|
||
|
||
// move mod group in temp place to 2
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_id = 2 WHERE g_id = '.$temp_id) or error('Unable to update group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'users SET group_id = 2 WHERE group_id = '.$temp_id) or error('Unable to update users group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'forum_perms SET group_id = 2 WHERE group_id = '.$temp_id) or error('Unable to forum_perms group ID', __FILE__, __LINE__, $db->error());
|
||
if ($member_gid == $temp_id) $member_gid = 2;
|
||
|
||
// Only move stuff around if it isn't already in the right place
|
||
if ($member_gid != $mod_gid || $member_gid != 4)
|
||
{
|
||
// move members to temp place
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_id = '.$temp_id.' WHERE g_id = '.$member_gid) or error('Unable to update group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'users SET group_id = '.$temp_id.' WHERE group_id = '.$member_gid) or error('Unable to update users group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'forum_perms SET group_id = '.$temp_id.' WHERE group_id = '.$member_gid) or error('Unable to forum_perms group ID', __FILE__, __LINE__, $db->error());
|
||
|
||
// move whoever is in 4 to members place
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_id = '.$member_gid.' WHERE g_id = 4') or error('Unable to update group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'users SET group_id = '.$member_gid.' WHERE group_id = 4') or error('Unable to update users group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'forum_perms SET group_id = '.$member_gid.' WHERE group_id = 4') or error('Unable to forum_perms group ID', __FILE__, __LINE__, $db->error());
|
||
|
||
// move members in temp place to 4
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_id = 4 WHERE g_id = '.$temp_id) or error('Unable to update group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'users SET group_id = 4 WHERE group_id = '.$temp_id) or error('Unable to update users group ID', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'forum_perms SET group_id = 4 WHERE group_id = '.$temp_id) or error('Unable to forum_perms group ID', __FILE__, __LINE__, $db->error());
|
||
}
|
||
|
||
$db->query('UPDATE '.$db->prefix.'config SET conf_value=\''.$member_gid.'\' WHERE conf_name=\'o_default_user_group\'') or error('Unable to update default user group ID', __FILE__, __LINE__, $db->error());
|
||
}
|
||
|
||
// Server time zone is now simply the default time zone
|
||
if (!array_key_exists('o_default_timezone', $pun_config))
|
||
$db->query('UPDATE '.$db->prefix.'config SET conf_name = \'o_default_timezone\' WHERE conf_name = \'o_server_timezone\'') or error('Unable to update time zone config', __FILE__, __LINE__, $db->error());
|
||
|
||
// Increase visit timeout to 30 minutes (only if it hasn't been changed from the default)
|
||
if (!array_key_exists('o_database_revision', $pun_config) && $pun_config['o_timeout_visit'] == '600')
|
||
$db->query('UPDATE '.$db->prefix.'config SET conf_value = \'1800\' WHERE conf_name = \'o_timeout_visit\'') or error('Unable to update visit timeout config', __FILE__, __LINE__, $db->error());
|
||
|
||
// Remove obsolete g_post_polls permission from groups table
|
||
$db->drop_field('groups', 'g_post_polls');
|
||
|
||
// Make room for multiple moderator groups
|
||
if (!$db->field_exists('groups', 'g_moderator'))
|
||
{
|
||
// Add g_moderator column to groups table
|
||
$db->add_field('groups', 'g_moderator', 'TINYINT(1)', false, 0, 'g_user_title') or error('Unable to add g_moderator field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Give the moderator group moderator privileges
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_moderator = 1 WHERE g_id = 2') or error('Unable to update moderator powers', __FILE__, __LINE__, $db->error());
|
||
}
|
||
|
||
// Replace obsolete p_mod_edit_users config setting with new per-group permission
|
||
if (array_key_exists('p_mod_edit_users', $pun_config))
|
||
{
|
||
$db->query('DELETE FROM '.$db->prefix.'config WHERE conf_name = \'p_mod_edit_users\'') or error('Unable to update moderator powers', __FILE__, __LINE__, $db->error());
|
||
|
||
$db->add_field('groups', 'g_mod_edit_users', 'TINYINT(1)', false, 0, 'g_moderator') or error('Unable to add g_mod_edit_users field', __FILE__, __LINE__, $db->error());
|
||
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_mod_edit_users = '.$pun_config['p_mod_edit_users'].' WHERE g_moderator = 1') or error('Unable to update moderator powers', __FILE__, __LINE__, $db->error());
|
||
}
|
||
|
||
// Replace obsolete p_mod_rename_users config setting with new per-group permission
|
||
if (array_key_exists('p_mod_rename_users', $pun_config))
|
||
{
|
||
$db->query('DELETE FROM '.$db->prefix.'config WHERE conf_name = \'p_mod_rename_users\'') or error('Unable to update moderator powers', __FILE__, __LINE__, $db->error());
|
||
|
||
$db->add_field('groups', 'g_mod_rename_users', 'TINYINT(1)', false, 0, 'g_mod_edit_users') or error('Unable to add g_mod_rename_users field', __FILE__, __LINE__, $db->error());
|
||
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_mod_rename_users = '.$pun_config['p_mod_rename_users'].' WHERE g_moderator = 1') or error('Unable to update moderator powers', __FILE__, __LINE__, $db->error());
|
||
}
|
||
|
||
// Replace obsolete p_mod_change_passwords config setting with new per-group permission
|
||
if (array_key_exists('p_mod_change_passwords', $pun_config))
|
||
{
|
||
$db->query('DELETE FROM '.$db->prefix.'config WHERE conf_name = \'p_mod_change_passwords\'') or error('Unable to update moderator powers', __FILE__, __LINE__, $db->error());
|
||
|
||
$db->add_field('groups', 'g_mod_change_passwords', 'TINYINT(1)', false, 0, 'g_mod_rename_users') or error('Unable to add g_mod_change_passwords field', __FILE__, __LINE__, $db->error());
|
||
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_mod_change_passwords = '.$pun_config['p_mod_change_passwords'].' WHERE g_moderator = 1') or error('Unable to update moderator powers', __FILE__, __LINE__, $db->error());
|
||
}
|
||
|
||
// Replace obsolete p_mod_ban_users config setting with new per-group permission
|
||
if (array_key_exists('p_mod_ban_users', $pun_config))
|
||
{
|
||
$db->query('DELETE FROM '.$db->prefix.'config WHERE conf_name = \'p_mod_ban_users\'') or error('Unable to update moderator powers', __FILE__, __LINE__, $db->error());
|
||
|
||
$db->add_field('groups', 'g_mod_ban_users', 'TINYINT(1)', false, 0, 'g_mod_change_passwords') or error('Unable to add g_mod_ban_users field', __FILE__, __LINE__, $db->error());
|
||
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_mod_ban_users = '.$pun_config['p_mod_ban_users'].' WHERE g_moderator = 1') or error('Unable to update moderator powers', __FILE__, __LINE__, $db->error());
|
||
}
|
||
|
||
// We need to add a unique index to avoid users having multiple rows in the online table
|
||
if (!$db->index_exists('online', 'user_id_ident_idx'))
|
||
{
|
||
$db->truncate_table('online') or error('Unable to clear online table', __FILE__, __LINE__, $db->error());
|
||
|
||
if ($mysql)
|
||
$db->add_index('online', 'user_id_ident_idx', array('user_id', 'ident(25)'), true) or error('Unable to add user_id_ident_idx index', __FILE__, __LINE__, $db->error());
|
||
else
|
||
$db->add_index('online', 'user_id_ident_idx', array('user_id', 'ident'), true) or error('Unable to add user_id_ident_idx index', __FILE__, __LINE__, $db->error());
|
||
}
|
||
|
||
// Remove the redundant user_id_idx on the online table
|
||
$db->drop_index('online', 'user_id_idx') or error('Unable to drop user_id_idx index', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add an index to ident on the online table
|
||
if ($mysql)
|
||
$db->add_index('online', 'ident_idx', array('ident(25)')) or error('Unable to add ident_idx index', __FILE__, __LINE__, $db->error());
|
||
else
|
||
$db->add_index('online', 'ident_idx', array('ident')) or error('Unable to add ident_idx index', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add an index to logged in the online table
|
||
$db->add_index('online', 'logged_idx', array('logged')) or error('Unable to add logged_idx index', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add an index to last_post in the topics table
|
||
$db->add_index('topics', 'last_post_idx', array('last_post')) or error('Unable to add last_post_idx index', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add an index to username on the bans table
|
||
if ($mysql)
|
||
$db->add_index('bans', 'username_idx', array('username(25)')) or error('Unable to add username_idx index', __FILE__, __LINE__, $db->error());
|
||
else
|
||
$db->add_index('bans', 'username_idx', array('username')) or error('Unable to add username_idx index', __FILE__, __LINE__, $db->error());
|
||
|
||
// Change the username_idx on users to a unique index of max size 25
|
||
$db->drop_index('users', 'username_idx') or error('Unable to drop old username_idx index', __FILE__, __LINE__, $db->error());
|
||
$field = $mysql ? 'username(25)' : 'username';
|
||
|
||
// Attempt to add a unique index. If the user doesn't use a transactional database this can fail due to multiple matching usernames in the
|
||
// users table. This is bad, but just giving up if it happens is even worse! If it fails just add a regular non-unique index.
|
||
if (!$db->add_index('users', 'username_idx', array($field), true))
|
||
$db->add_index('users', 'username_idx', array($field)) or error('Unable to add username_idx field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add g_view_users column to groups table
|
||
$db->add_field('groups', 'g_view_users', 'TINYINT(1)', false, 1, 'g_read_board') or error('Unable to add g_view_users field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add the last_email_sent column to the users table and the g_send_email and
|
||
// g_email_flood columns to the groups table
|
||
$db->add_field('users', 'last_email_sent', 'INT(10) UNSIGNED', true, null, 'last_search') or error('Unable to add last_email_sent field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('groups', 'g_send_email', 'TINYINT(1)', false, 1, 'g_search_users') or error('Unable to add g_send_email field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('groups', 'g_email_flood', 'SMALLINT(6)', false, 60, 'g_search_flood') or error('Unable to add g_email_flood field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add the last_report_sent column to the users table and the g_report_flood
|
||
// column to the groups table
|
||
$db->add_field('users', 'last_report_sent', 'INT(10) UNSIGNED', true, null, 'last_email_sent') or error('Unable to add last_report_sent field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('groups', 'g_report_flood', 'SMALLINT(6)', false, 60, 'g_email_flood') or error('Unable to add g_report_flood field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Set non-default g_send_email, g_flood_email and g_flood_report values properly
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_send_email = 0 WHERE g_id = 3') or error('Unable to update group email permissions', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_email_flood = 0, g_report_flood = 0 WHERE g_id IN (1,2,3)') or error('Unable to update group email permissions', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add the auto notify/subscription option to the users table
|
||
$db->add_field('users', 'auto_notify', 'TINYINT(1)', false, 0, 'notify_with_post') or error('Unable to add auto_notify field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add the first_post_id column to the topics table
|
||
if (!$db->field_exists('topics', 'first_post_id'))
|
||
{
|
||
$db->add_field('topics', 'first_post_id', 'INT(10) UNSIGNED', false, 0, 'posted') or error('Unable to add first_post_id field', __FILE__, __LINE__, $db->error());
|
||
$db->add_index('topics', 'first_post_id_idx', array('first_post_id')) or error('Unable to add first_post_id_idx index', __FILE__, __LINE__, $db->error());
|
||
|
||
// Now that we've added the column and indexed it, we need to give it correct data
|
||
$result = $db->query('SELECT MIN(id) AS first_post, topic_id FROM '.$db->prefix.'posts GROUP BY topic_id') or error('Unable to fetch first_post_id', __FILE__, __LINE__, $db->error());
|
||
|
||
while ($cur_post = $db->fetch_assoc($result))
|
||
$db->query('UPDATE '.$db->prefix.'topics SET first_post_id = '.$cur_post['first_post'].' WHERE id = '.$cur_post['topic_id']) or error('Unable to update first_post_id', __FILE__, __LINE__, $db->error());
|
||
}
|
||
|
||
// Move any users with the old unverified status to their new group
|
||
$db->query('UPDATE '.$db->prefix.'users SET group_id=0 WHERE group_id=32000') or error('Unable to move unverified users', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add the ban_creator column to the bans table
|
||
$db->add_field('bans', 'ban_creator', 'INT(10) UNSIGNED', false, 0) or error('Unable to add ban_creator field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add the time/date format settings to the user table
|
||
$db->add_field('users', 'time_format', 'TINYINT(1)', false, 0, 'dst') or error('Unable to add time_format field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('users', 'date_format', 'TINYINT(1)', false, 0, 'dst') or error('Unable to add date_format field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Change the search_data column to mediumtext
|
||
$db->alter_field('search_cache', 'search_data', 'MEDIUMTEXT', true) or error('Unable to alter search_data field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add the group promotion columns to the groups table
|
||
$db->add_field('groups', 'g_promote_min_posts', 'INT(10) UNSIGNED', false, 0, 'g_user_title') or error('Unable to add g_promote_min_posts field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('groups', 'g_promote_next_group', 'INT(10) UNSIGNED', false, 0, 'g_promote_min_posts') or error('Unable to add g_promote_next_group field', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add a field for the per-group permission to post links
|
||
$db->add_field('groups', 'g_post_links', 'TINYINT(1)', false, 1, 'g_delete_topics') or error('Unable to add per-group permission to post links', __FILE__, __LINE__, $db->error());
|
||
|
||
// Add a field for the per-group permission to promote users to the next auto-promote group
|
||
$db->add_field('groups', 'g_mod_promote_users', 'TINYINT(1)', false, 0, 'g_mod_ban_users') or error('Unable to add per-group permission to promote users', __FILE__, __LINE__, $db->error());
|
||
|
||
// In case we had the fulltext search extension installed (1.3-legacy), remove it
|
||
$db->drop_index('topics', 'subject_idx') or error('Unable to drop subject_idx index', __FILE__, __LINE__, $db->error());
|
||
$db->drop_index('posts', 'message_idx') or error('Unable to drop message_idx index', __FILE__, __LINE__, $db->error());
|
||
// In case we had the fulltext search mod installed (1.2), remove it
|
||
$db->drop_index('topics', 'subject_fulltext_search') or error('Unable to drop subject_fulltext_search index', __FILE__, __LINE__, $db->error());
|
||
$db->drop_index('posts', 'message_fulltext_search') or error('Unable to drop message_fulltext_search index', __FILE__, __LINE__, $db->error());
|
||
|
||
// If the search_cache table has been dropped by the fulltext search extension, recreate it
|
||
if (!$db->table_exists('search_cache'))
|
||
{
|
||
$schema = array(
|
||
'FIELDS' => array(
|
||
'id' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'ident' => array(
|
||
'datatype' => 'VARCHAR(200)',
|
||
'allow_null' => false,
|
||
'default' => '\'\''
|
||
),
|
||
'search_data' => array(
|
||
'datatype' => 'MEDIUMTEXT',
|
||
'allow_null' => true
|
||
)
|
||
),
|
||
'PRIMARY KEY' => array('id'),
|
||
'INDEXES' => array(
|
||
'ident_idx' => array('ident')
|
||
)
|
||
);
|
||
|
||
if ($db_type == 'mysql' || $db_type == 'mysqli' || $db_type == 'mysql_innodb' || $db_type == 'mysqli_innodb')
|
||
$schema['INDEXES']['ident_idx'] = array('ident(8)');
|
||
|
||
$db->create_table('search_cache', $schema);
|
||
}
|
||
|
||
// If the search_matches table has been dropped by the fulltext search extension, recreate it
|
||
if (!$db->table_exists('search_matches'))
|
||
{
|
||
$schema = array(
|
||
'FIELDS' => array(
|
||
'post_id' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'word_id' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'subject_match' => array(
|
||
'datatype' => 'TINYINT(1)',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
)
|
||
),
|
||
'INDEXES' => array(
|
||
'word_id_idx' => array('word_id'),
|
||
'post_id_idx' => array('post_id')
|
||
)
|
||
);
|
||
|
||
$db->create_table('search_matches', $schema);
|
||
}
|
||
|
||
// If the search_words table has been dropped by the fulltext search extension, recreate it
|
||
if (!$db->table_exists('search_words'))
|
||
{
|
||
$schema = array(
|
||
'FIELDS' => array(
|
||
'id' => array(
|
||
'datatype' => 'SERIAL',
|
||
'allow_null' => false
|
||
),
|
||
'word' => array(
|
||
'datatype' => 'VARCHAR(20)',
|
||
'allow_null' => false,
|
||
'default' => '\'\'',
|
||
'collation' => 'bin'
|
||
)
|
||
),
|
||
'PRIMARY KEY' => array('word'),
|
||
'INDEXES' => array(
|
||
'id_idx' => array('id')
|
||
)
|
||
);
|
||
|
||
if ($db_type == 'sqlite3')
|
||
{
|
||
$schema['PRIMARY KEY'] = array('id');
|
||
$schema['UNIQUE KEYS'] = array('word_idx' => array('word'));
|
||
}
|
||
|
||
$db->create_table('search_words', $schema);
|
||
}
|
||
|
||
// Rename the subscription table
|
||
$db->rename_table('subscriptions', 'topic_subscriptions');
|
||
|
||
// if we don't have the forum_subscriptions table, create it
|
||
if (!$db->table_exists('forum_subscriptions'))
|
||
{
|
||
$schema = array(
|
||
'FIELDS' => array(
|
||
'user_id' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'forum_id' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
)
|
||
),
|
||
'PRIMARY KEY' => array('user_id', 'forum_id')
|
||
);
|
||
|
||
$db->create_table('forum_subscriptions', $schema) or error('Unable to create forum subscriptions table', __FILE__, __LINE__, $db->error());
|
||
}
|
||
|
||
// Insert new config option o_forum_subscriptions
|
||
if (!array_key_exists('o_forum_subscriptions', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_forum_subscriptions\', \'1\')') or error('Unable to insert config value \'o_forum_subscriptions\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Rename config option o_subscriptions to o_topic_subscriptions
|
||
if (!array_key_exists('o_topic_subscriptions', $pun_config))
|
||
$db->query('UPDATE '.$db->prefix.'config SET conf_name=\'o_topic_subscriptions\' WHERE conf_name=\'o_subscriptions\'') or error('Unable to rename config value \'o_subscriptions\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Change the default style if the old doesn't exist anymore
|
||
if ($pun_config['o_default_style'] != $default_style)
|
||
$db->query('UPDATE '.$db->prefix.'config SET conf_value = \''.$db->escape($default_style).'\' WHERE conf_name = \'o_default_style\'') or error('Unable to update default style config', __FILE__, __LINE__, $db->error());
|
||
|
||
// For MySQL(i) without InnoDB, change the engine of the online table (for performance reasons)
|
||
if ($db_type == 'mysql' || $db_type == 'mysqli')
|
||
$db->query('ALTER TABLE '.$db->prefix.'online ENGINE = MyISAM') or error('Unable to change engine type of online table to MyISAM', __FILE__, __LINE__, $db->error());
|
||
|
||
// Remove config option o_ranks
|
||
if (array_key_exists('o_ranks', $pun_config))
|
||
$db->query('DELETE FROM '.$db->prefix.'config WHERE conf_name=\'o_ranks\'') or error('Unable to remove config value \'o_ranks\'', __FILE__, __LINE__, $db->error());
|
||
|
||
// Remove the ranks table
|
||
if ($db->table_exists('ranks'))
|
||
$db->drop_table('ranks') or error('Unable to drop ranks table', __FILE__, __LINE__, $db->error());
|
||
|
||
// Should we do charset conversion or not?
|
||
if (strpos($cur_version, '1.2') === 0 && isset($_POST['convert_charset']))
|
||
$query_str = '?stage=conv_bans&req_old_charset='.$old_charset;
|
||
|
||
break;
|
||
|
||
|
||
// Convert bans
|
||
case 'conv_bans':
|
||
$query_str = '?stage=conv_categories&req_old_charset='.$old_charset;
|
||
|
||
function _conv_bans($cur_item, $old_charset)
|
||
{
|
||
global $lang_update;
|
||
|
||
echo sprintf($lang_update['Converting item'], $lang_update['ban'], $cur_item['id']).'<br />'."\n";
|
||
|
||
convert_to_utf8($cur_item['username'], $old_charset);
|
||
convert_to_utf8($cur_item['message'], $old_charset);
|
||
|
||
return $cur_item;
|
||
}
|
||
|
||
$end_at = convert_table_utf8($db->prefix.'bans', '_conv_bans', $old_charset, 'id', $start_at);
|
||
|
||
if ($end_at !== true)
|
||
$query_str = '?stage=conv_bans&req_old_charset='.$old_charset.'&start_at='.$end_at;
|
||
|
||
break;
|
||
|
||
|
||
// Convert categories
|
||
case 'conv_categories':
|
||
$query_str = '?stage=conv_censors&req_old_charset='.$old_charset;
|
||
|
||
echo sprintf($lang_update['Converting'], $lang_update['categories']).'<br />'."\n";
|
||
|
||
function _conv_categories($cur_item, $old_charset)
|
||
{
|
||
convert_to_utf8($cur_item['cat_name'], $old_charset);
|
||
|
||
return $cur_item;
|
||
}
|
||
|
||
convert_table_utf8($db->prefix.'categories', '_conv_categories', $old_charset, 'id');
|
||
|
||
break;
|
||
|
||
|
||
// Convert censor words
|
||
case 'conv_censors':
|
||
$query_str = '?stage=conv_config&req_old_charset='.$old_charset;
|
||
|
||
echo sprintf($lang_update['Converting'], $lang_update['censor words']).'<br />'."\n";
|
||
|
||
function _conv_censoring($cur_item, $old_charset)
|
||
{
|
||
convert_to_utf8($cur_item['search_for'], $old_charset);
|
||
convert_to_utf8($cur_item['replace_with'], $old_charset);
|
||
|
||
return $cur_item;
|
||
}
|
||
|
||
convert_table_utf8($db->prefix.'censoring', '_conv_censoring', $old_charset, 'id');
|
||
|
||
break;
|
||
|
||
|
||
// Convert config
|
||
case 'conv_config':
|
||
$query_str = '?stage=conv_forums&req_old_charset='.$old_charset;
|
||
|
||
echo sprintf($lang_update['Converting'], $lang_update['configuration']).'<br />'."\n";
|
||
|
||
function _conv_config($cur_item, $old_charset)
|
||
{
|
||
convert_to_utf8($cur_item['conf_value'], $old_charset);
|
||
|
||
return $cur_item;
|
||
}
|
||
|
||
convert_table_utf8($db->prefix.'config', '_conv_config', $old_charset, 'conf_name');
|
||
|
||
break;
|
||
|
||
|
||
// Convert forums
|
||
case 'conv_forums':
|
||
$query_str = '?stage=conv_perms&req_old_charset='.$old_charset;
|
||
|
||
echo sprintf($lang_update['Converting'], $lang_update['forums']).'<br />'."\n";
|
||
|
||
function _conv_forums($cur_item, $old_charset)
|
||
{
|
||
$moderators = $cur_item['moderators'] != '' ? unserialize($cur_item['moderators']) : array();
|
||
$moderators_utf8 = array();
|
||
foreach ($moderators as $mod_username => $mod_user_id)
|
||
{
|
||
convert_to_utf8($mod_username, $old_charset);
|
||
$moderators_utf8[$mod_username] = $mod_user_id;
|
||
}
|
||
|
||
convert_to_utf8($cur_item['forum_name'], $old_charset);
|
||
convert_to_utf8($cur_item['forum_desc'], $old_charset);
|
||
convert_to_utf8($cur_item['last_poster'], $old_charset);
|
||
|
||
if (!empty($moderators_utf8))
|
||
$cur_item['moderators'] = serialize($moderators_utf8);
|
||
|
||
return $cur_item;
|
||
}
|
||
|
||
convert_table_utf8($db->prefix.'forums', '_conv_forums', $old_charset, 'id');
|
||
|
||
break;
|
||
|
||
|
||
// Convert forum permissions
|
||
case 'conv_perms':
|
||
$query_str = '?stage=conv_groups&req_old_charset='.$old_charset;
|
||
|
||
alter_table_utf8($db->prefix.'forum_perms');
|
||
|
||
break;
|
||
|
||
|
||
// Convert groups
|
||
case 'conv_groups':
|
||
$query_str = '?stage=conv_online&req_old_charset='.$old_charset;
|
||
|
||
echo sprintf($lang_update['Converting'], $lang_update['groups']).'<br />'."\n";
|
||
|
||
function _conv_groups($cur_item, $old_charset)
|
||
{
|
||
convert_to_utf8($cur_item['g_title'], $old_charset);
|
||
convert_to_utf8($cur_item['g_user_title'], $old_charset);
|
||
|
||
return $cur_item;
|
||
}
|
||
|
||
convert_table_utf8($db->prefix.'groups', '_conv_groups', $old_charset, 'g_id');
|
||
|
||
break;
|
||
|
||
|
||
// Convert online
|
||
case 'conv_online':
|
||
$query_str = '?stage=conv_posts&req_old_charset='.$old_charset;
|
||
|
||
// Truncate the table
|
||
$db->truncate_table('online') or error('Unable to empty online table', __FILE__, __LINE__, $db->error());
|
||
|
||
alter_table_utf8($db->prefix.'online');
|
||
|
||
break;
|
||
|
||
|
||
// Convert posts
|
||
case 'conv_posts':
|
||
$query_str = '?stage=conv_reports&req_old_charset='.$old_charset;
|
||
|
||
function _conv_posts($cur_item, $old_charset)
|
||
{
|
||
global $lang_update;
|
||
|
||
echo sprintf($lang_update['Converting item'], $lang_update['post'], $cur_item['id']).'<br />'."\n";
|
||
|
||
convert_to_utf8($cur_item['poster'], $old_charset);
|
||
convert_to_utf8($cur_item['message'], $old_charset);
|
||
convert_to_utf8($cur_item['edited_by'], $old_charset);
|
||
|
||
return $cur_item;
|
||
}
|
||
|
||
$end_at = convert_table_utf8($db->prefix.'posts', '_conv_posts', $old_charset, 'id', $start_at);
|
||
|
||
if ($end_at !== true)
|
||
$query_str = '?stage=conv_posts&req_old_charset='.$old_charset.'&start_at='.$end_at;
|
||
|
||
break;
|
||
|
||
|
||
// Convert reports
|
||
case 'conv_reports':
|
||
$query_str = '?stage=conv_search_cache&req_old_charset='.$old_charset;
|
||
|
||
function _conv_reports($cur_item, $old_charset)
|
||
{
|
||
global $lang_update;
|
||
|
||
echo sprintf($lang_update['Converting item'], $lang_update['report'], $cur_item['id']).'<br />'."\n";
|
||
|
||
convert_to_utf8($cur_item['message'], $old_charset);
|
||
|
||
return $cur_item;
|
||
}
|
||
|
||
$end_at = convert_table_utf8($db->prefix.'reports', '_conv_reports', $old_charset, 'id', $start_at);
|
||
|
||
if ($end_at !== true)
|
||
$query_str = '?stage=conv_reports&req_old_charset='.$old_charset.'&start_at='.$end_at;
|
||
|
||
break;
|
||
|
||
|
||
// Convert search cache
|
||
case 'conv_search_cache':
|
||
$query_str = '?stage=conv_search_matches&req_old_charset='.$old_charset;
|
||
|
||
// Truncate the table
|
||
$db->truncate_table('search_cache') or error('Unable to empty search cache table', __FILE__, __LINE__, $db->error());
|
||
|
||
alter_table_utf8($db->prefix.'search_cache');
|
||
|
||
break;
|
||
|
||
|
||
// Convert search matches
|
||
case 'conv_search_matches':
|
||
$query_str = '?stage=conv_search_words&req_old_charset='.$old_charset;
|
||
|
||
// Truncate the table
|
||
$db->truncate_table('search_matches') or error('Unable to empty search index match table', __FILE__, __LINE__, $db->error());
|
||
|
||
alter_table_utf8($db->prefix.'search_matches');
|
||
|
||
break;
|
||
|
||
|
||
// Convert search words
|
||
case 'conv_search_words':
|
||
$query_str = '?stage=conv_subscriptions&req_old_charset='.$old_charset;
|
||
|
||
// Truncate the table
|
||
$db->truncate_table('search_words') or error('Unable to empty search index words table', __FILE__, __LINE__, $db->error());
|
||
|
||
// Reset the sequence for the search words (not needed for SQLite)
|
||
switch ($db_type)
|
||
{
|
||
case 'mysql':
|
||
case 'mysqli':
|
||
case 'mysql_innodb':
|
||
case 'mysqli_innodb':
|
||
$db->query('ALTER TABLE '.$db->prefix.'search_words auto_increment=1') or error('Unable to update table auto_increment', __FILE__, __LINE__, $db->error());
|
||
break;
|
||
|
||
case 'pgsql';
|
||
$db->query('SELECT setval(\''.$db->prefix.'search_words_id_seq\', 1, false)') or error('Unable to update sequence', __FILE__, __LINE__, $db->error());
|
||
break;
|
||
}
|
||
|
||
alter_table_utf8($db->prefix.'search_words');
|
||
|
||
break;
|
||
|
||
|
||
// Convert subscriptions
|
||
case 'conv_subscriptions':
|
||
$query_str = '?stage=conv_topics&req_old_charset='.$old_charset;
|
||
|
||
// By this stage we should have already renamed the subscription table
|
||
alter_table_utf8($db->prefix.'topic_subscriptions');
|
||
alter_table_utf8($db->prefix.'forum_subscriptions'); // This should actually already be utf8, but for consistency...
|
||
|
||
break;
|
||
|
||
|
||
// Convert topics
|
||
case 'conv_topics':
|
||
$query_str = '?stage=conv_users&req_old_charset='.$old_charset;
|
||
|
||
function _conv_topics($cur_item, $old_charset)
|
||
{
|
||
global $lang_update;
|
||
|
||
echo sprintf($lang_update['Converting item'], $lang_update['topic'], $cur_item['id']).'<br />'."\n";
|
||
|
||
convert_to_utf8($cur_item['poster'], $old_charset);
|
||
convert_to_utf8($cur_item['subject'], $old_charset);
|
||
convert_to_utf8($cur_item['last_poster'], $old_charset);
|
||
|
||
return $cur_item;
|
||
}
|
||
|
||
$end_at = convert_table_utf8($db->prefix.'topics', '_conv_topics', $old_charset, 'id', $start_at);
|
||
|
||
if ($end_at !== true)
|
||
$query_str = '?stage=conv_topics&req_old_charset='.$old_charset.'&start_at='.$end_at;
|
||
|
||
break;
|
||
|
||
|
||
// Convert users
|
||
case 'conv_users':
|
||
$query_str = '?stage=preparse_posts';
|
||
|
||
if ($start_at == 0)
|
||
$_SESSION['dupe_users'] = array();
|
||
|
||
function _conv_users($cur_item, $old_charset)
|
||
{
|
||
global $lang_update;
|
||
|
||
echo sprintf($lang_update['Converting item'], $lang_update['user'], $cur_item['id']).'<br />'."\n";
|
||
|
||
convert_to_utf8($cur_item['username'], $old_charset);
|
||
convert_to_utf8($cur_item['title'], $old_charset);
|
||
convert_to_utf8($cur_item['realname'], $old_charset);
|
||
convert_to_utf8($cur_item['location'], $old_charset);
|
||
convert_to_utf8($cur_item['signature'], $old_charset);
|
||
convert_to_utf8($cur_item['admin_note'], $old_charset);
|
||
|
||
return $cur_item;
|
||
}
|
||
|
||
function _error_users($cur_user)
|
||
{
|
||
$_SESSION['dupe_users'][$cur_user['id']] = $cur_user;
|
||
}
|
||
|
||
$end_at = convert_table_utf8($db->prefix.'users', '_conv_users', $old_charset, 'id', $start_at, '_error_users');
|
||
|
||
if ($end_at !== true)
|
||
$query_str = '?stage=conv_users&req_old_charset='.$old_charset.'&start_at='.$end_at;
|
||
else if (!empty($_SESSION['dupe_users']))
|
||
$query_str = '?stage=conv_users_dupe';
|
||
|
||
break;
|
||
|
||
|
||
// Handle any duplicate users which occured due to conversion
|
||
case 'conv_users_dupe':
|
||
$query_str = '?stage=preparse_posts';
|
||
|
||
if (!$mysql || empty($_SESSION['dupe_users']))
|
||
break;
|
||
|
||
if (isset($_POST['form_sent']))
|
||
{
|
||
$errors = array();
|
||
|
||
require PUN_ROOT.'include/email.php';
|
||
|
||
foreach ($_SESSION['dupe_users'] as $id => $cur_user)
|
||
{
|
||
$errors[$id] = array();
|
||
|
||
$username = pun_trim($_POST['dupe_users'][$id] ?? '');
|
||
|
||
if (pun_strlen($username) < 2)
|
||
$errors[$id][] = $lang_update['Username too short error'];
|
||
else if (pun_strlen($username) > 25) // This usually doesn't happen since the form element only accepts 25 characters
|
||
$errors[$id][] = $lang_update['Username too long error'];
|
||
else if (!strcasecmp($username, 'Guest'))
|
||
$errors[$id][] = $lang_update['Username Guest reserved error'];
|
||
else if (preg_match('%[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}%', $username) || preg_match('%((([0-9A-Fa-f]{1,4}:){7}[0-9A-Fa-f]{1,4})|(([0-9A-Fa-f]{1,4}:){6}:[0-9A-Fa-f]{1,4})|(([0-9A-Fa-f]{1,4}:){5}:([0-9A-Fa-f]{1,4}:)?[0-9A-Fa-f]{1,4})|(([0-9A-Fa-f]{1,4}:){4}:([0-9A-Fa-f]{1,4}:){0,2}[0-9A-Fa-f]{1,4})|(([0-9A-Fa-f]{1,4}:){3}:([0-9A-Fa-f]{1,4}:){0,3}[0-9A-Fa-f]{1,4})|(([0-9A-Fa-f]{1,4}:){2}:([0-9A-Fa-f]{1,4}:){0,4}[0-9A-Fa-f]{1,4})|(([0-9A-Fa-f]{1,4}:){6}((\b((25[0-5])|(1\d{2})|(2[0-4]\d)|(\d{1,2}))\b)\.){3}(\b((25[0-5])|(1\d{2})|(2[0-4]\d)|(\d{1,2}))\b))|(([0-9A-Fa-f]{1,4}:){0,5}:((\b((25[0-5])|(1\d{2})|(2[0-4]\d)|(\d{1,2}))\b)\.){3}(\b((25[0-5])|(1\d{2})|(2[0-4]\d)|(\d{1,2}))\b))|(::([0-9A-Fa-f]{1,4}:){0,5}((\b((25[0-5])|(1\d{2})|(2[0-4]\d)|(\d{1,2}))\b)\.){3}(\b((25[0-5])|(1\d{2})|(2[0-4]\d)|(\d{1,2}))\b))|([0-9A-Fa-f]{1,4}::([0-9A-Fa-f]{1,4}:){0,5}[0-9A-Fa-f]{1,4})|(::([0-9A-Fa-f]{1,4}:){0,6}[0-9A-Fa-f]{1,4})|(([0-9A-Fa-f]{1,4}:){1,7}:))%', $username))
|
||
$errors[$id][] = $lang_update['Username IP format error'];
|
||
else if ((strpos($username, '[') !== false || strpos($username, ']') !== false) && strpos($username, '\'') !== false && strpos($username, '"') !== false)
|
||
$errors[$id][] = $lang_update['Username bad characters error'];
|
||
else if (preg_match('%(?:\[/?(?:b|u|s|ins|del|em|i|h|colou?r|quote|code|img|url|email|list|\*)\]|\[(?:img|url|quote|list)=)%i', $username))
|
||
$errors[$id][] = $lang_update['Username BBCode error'];
|
||
|
||
$result = $db->query('SELECT username FROM '.$db->prefix.'users WHERE (UPPER(username)=UPPER(\''.$db->escape($username).'\') OR UPPER(username)=UPPER(\''.$db->escape(preg_replace('%[^\p{L}\p{N}]%u', '', $username)).'\')) AND id>1') or error('Unable to fetch user info', __FILE__, __LINE__, $db->error());
|
||
$busy = $db->fetch_row($result);
|
||
|
||
if (is_array($busy))
|
||
{
|
||
$errors[$id][] = sprintf($lang_update['Username duplicate error'], pun_htmlspecialchars($busy[0]));
|
||
}
|
||
|
||
if (empty($errors[$id]))
|
||
{
|
||
$old_username = $cur_user['username'];
|
||
$_SESSION['dupe_users'][$id]['username'] = $cur_user['username'] = $username;
|
||
|
||
$temp = array();
|
||
foreach ($cur_user as $idx => $value)
|
||
$temp[$idx] = is_null($value) ? 'NULL' : '\''.$db->escape($value).'\'';
|
||
|
||
// Insert the renamed user
|
||
$db->query('INSERT INTO '.$db->prefix.'users('.implode(',', array_keys($temp)).') VALUES ('.implode(',', array_values($temp)).')') or error('Unable to insert data to new table', __FILE__, __LINE__, $db->error());
|
||
|
||
// Renaming a user also affects a bunch of other stuff, lets fix that too...
|
||
$db->query('UPDATE '.$db->prefix.'posts SET poster=\''.$db->escape($username).'\' WHERE poster_id='.$id) or error('Unable to update posts', __FILE__, __LINE__, $db->error());
|
||
|
||
// TODO: The following must compare using collation utf8_bin otherwise we will accidently update posts/topics/etc belonging to both of the duplicate users, not just the one we renamed!
|
||
$db->query('UPDATE '.$db->prefix.'posts SET edited_by=\''.$db->escape($username).'\' WHERE edited_by=\''.$db->escape($old_username).'\' COLLATE utf8mb4_bin') or error('Unable to update posts', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'topics SET poster=\''.$db->escape($username).'\' WHERE poster=\''.$db->escape($old_username).'\' COLLATE utf8mb4_bin') or error('Unable to update topics', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'topics SET last_poster=\''.$db->escape($username).'\' WHERE last_poster=\''.$db->escape($old_username).'\' COLLATE utf8mb4_bin') or error('Unable to update topics', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'forums SET last_poster=\''.$db->escape($username).'\' WHERE last_poster=\''.$db->escape($old_username).'\' COLLATE utf8mb4_bin') or error('Unable to update forums', __FILE__, __LINE__, $db->error());
|
||
$db->query('UPDATE '.$db->prefix.'online SET ident=\''.$db->escape($username).'\' WHERE ident=\''.$db->escape($old_username).'\' COLLATE utf8mb4_bin') or error('Unable to update online list', __FILE__, __LINE__, $db->error());
|
||
|
||
// If the user is a moderator or an administrator we have to update the moderator lists
|
||
$result = $db->query('SELECT g_moderator FROM '.$db->prefix.'groups WHERE g_id='.$cur_user['group_id']) or error('Unable to fetch group', __FILE__, __LINE__, $db->error());
|
||
$group_mod = $db->result($result);
|
||
|
||
if ($cur_user['group_id'] == PUN_ADMIN || $group_mod == '1')
|
||
{
|
||
$result = $db->query('SELECT id, moderators FROM '.$db->prefix.'forums') or error('Unable to fetch forum list', __FILE__, __LINE__, $db->error());
|
||
|
||
while ($cur_forum = $db->fetch_assoc($result))
|
||
{
|
||
$cur_moderators = $cur_forum['moderators'] != '' ? unserialize($cur_forum['moderators']) : array();
|
||
|
||
if (in_array($id, $cur_moderators))
|
||
{
|
||
unset($cur_moderators[$old_username]);
|
||
$cur_moderators[$username] = $id;
|
||
uksort($cur_moderators, 'pun_strcasecmp');
|
||
|
||
$db->query('UPDATE '.$db->prefix.'forums SET moderators=\''.$db->escape(serialize($cur_moderators)).'\' WHERE id='.$cur_forum['id']) or error('Unable to update forum', __FILE__, __LINE__, $db->error());
|
||
}
|
||
}
|
||
}
|
||
|
||
// Email the user alerting them of the change
|
||
if (file_exists(PUN_ROOT.'lang/'.$cur_user['language'].'/mail_templates/rename.tpl'))
|
||
$mail_tpl = trim(file_get_contents(PUN_ROOT.'lang/'.$cur_user['language'].'/mail_templates/rename.tpl'));
|
||
else if (file_exists(PUN_ROOT.'lang/'.$pun_config['o_default_lang'].'/mail_templates/rename.tpl'))
|
||
$mail_tpl = trim(file_get_contents(PUN_ROOT.'lang/'.$pun_config['o_default_lang'].'/mail_templates/rename.tpl'));
|
||
else
|
||
$mail_tpl = trim(file_get_contents(PUN_ROOT.'lang/English/mail_templates/rename.tpl'));
|
||
|
||
// The first row contains the subject
|
||
$first_crlf = strpos($mail_tpl, "\n");
|
||
$mail_subject = trim(substr($mail_tpl, 8, $first_crlf-8));
|
||
$mail_message = trim(substr($mail_tpl, $first_crlf));
|
||
|
||
$mail_subject = str_replace('<board_title>', $pun_config['o_board_title'], $mail_subject);
|
||
$mail_message = str_replace('<base_url>', get_base_url().'/', $mail_message);
|
||
$mail_message = str_replace('<old_username>', $old_username, $mail_message);
|
||
$mail_message = str_replace('<new_username>', $username, $mail_message);
|
||
$mail_message = str_replace('<board_mailer>', $pun_config['o_board_title'], $mail_message);
|
||
|
||
pun_mail($cur_user['email'], $mail_subject, $mail_message);
|
||
|
||
unset($_SESSION['dupe_users'][$id]);
|
||
}
|
||
}
|
||
}
|
||
|
||
if (!empty($_SESSION['dupe_users']))
|
||
{
|
||
$query_str = '';
|
||
|
||
?>
|
||
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
|
||
|
||
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<?php echo $lang_common['lang_identifier'] ?>" lang="<?php echo $lang_common['lang_identifier'] ?>" dir="<?php echo $lang_common['lang_direction'] ?>">
|
||
<head>
|
||
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
<title><?php echo $lang_update['Update'] ?></title>
|
||
<link rel="stylesheet" type="text/css" href="style/<?php echo $default_style ?>.css" />
|
||
</head>
|
||
<body>
|
||
|
||
<div id="pundb_update" class="pun">
|
||
<div class="top-box"><div><!-- Top Corners --></div></div>
|
||
<div class="punwrap">
|
||
|
||
<div class="blockform">
|
||
<h2><span><?php echo $lang_update['Error converting users'] ?></span></h2>
|
||
<div class="box">
|
||
<form method="post" action="db_update.php?stage=conv_users_dupe&uid=<?php echo $uid ?>">
|
||
<div class="inform">
|
||
<input type="hidden" name="form_sent" value="1" />
|
||
<div class="forminfo">
|
||
<p style="font-size: 1.1em"><?php echo $lang_update['Error info 1'] ?></p>
|
||
<p style="font-size: 1.1em"><?php echo $lang_update['Error info 2'] ?></p>
|
||
</div>
|
||
</div>
|
||
<?php
|
||
|
||
foreach ($_SESSION['dupe_users'] as $id => $cur_user)
|
||
{
|
||
|
||
?>
|
||
<div class="inform">
|
||
<fieldset>
|
||
<legend><?php echo pun_htmlspecialchars($cur_user['username']); ?></legend>
|
||
<div class="infldset">
|
||
<label class="required"><strong><?php echo $lang_update['New username'] ?> <span><?php echo $lang_update['Required'] ?></span></strong><br /><input type="text" name="<?php echo 'dupe_users['.$id.']'; ?>" value="<?php if (isset($_POST['dupe_users'][$id])) echo pun_htmlspecialchars($_POST['dupe_users'][$id]); ?>" size="25" maxlength="25" /><br /></label>
|
||
</div>
|
||
</fieldset>
|
||
<?php if (!empty($errors[$id])): ?> <div class="forminfo error-info">
|
||
<h3><?php echo $lang_update['Correct errors'] ?></h3>
|
||
<ul class="error-list">
|
||
<?php
|
||
|
||
foreach ($errors[$id] as $cur_error)
|
||
echo "\t\t\t\t\t\t".'<li><strong>'.$cur_error.'</strong></li>'."\n";
|
||
?>
|
||
</ul>
|
||
</div>
|
||
<?php endif; ?> </div>
|
||
<?php
|
||
|
||
}
|
||
|
||
?>
|
||
<p class="buttons"><input type="submit" name="rename" value="<?php echo $lang_update['Rename users'] ?>" /></p>
|
||
</form>
|
||
</div>
|
||
</div>
|
||
|
||
</div>
|
||
<div class="end-box"><div><!-- Bottom Corners --></div></div>
|
||
</div>
|
||
|
||
</body>
|
||
</html>
|
||
<?php
|
||
|
||
}
|
||
|
||
break;
|
||
|
||
|
||
// Preparse posts
|
||
case 'preparse_posts':
|
||
$query_str = '?stage=preparse_sigs';
|
||
|
||
// If we don't need to parse the posts, skip this stage
|
||
if (isset($pun_config['o_parser_revision']) && $pun_config['o_parser_revision'] >= UPDATE_TO_PARSER_REVISION)
|
||
break;
|
||
|
||
if (! isset($smilies))
|
||
$smilies = [];
|
||
if (! isset($pun_user))
|
||
$pun_user = ['g_post_links' => 1];
|
||
|
||
require PUN_ROOT.'include/parser.php';
|
||
|
||
// Fetch posts to process this cycle
|
||
$result = $db->query('SELECT id, message FROM '.$db->prefix.'posts WHERE id > '.$start_at.' ORDER BY id ASC LIMIT '.PER_PAGE) or error('Unable to fetch posts', __FILE__, __LINE__, $db->error());
|
||
|
||
$temp = array();
|
||
$end_at = 0;
|
||
while ($cur_item = $db->fetch_assoc($result))
|
||
{
|
||
echo sprintf($lang_update['Preparsing item'], $lang_update['post'], $cur_item['id']).'<br />'."\n";
|
||
// перекодировка bb-кодов списков из v 1.2 - Visman
|
||
$cur_item['message'] = str_replace('[li]','[*]',$cur_item['message']);
|
||
$cur_item['message'] = str_replace('[/li]','[/*]',$cur_item['message']);
|
||
$cur_item['message'] = str_replace('[list]','[list=*]',$cur_item['message']);
|
||
$cur_item['message'] = str_replace('[listo]','[list=1]',$cur_item['message']);
|
||
$cur_item['message'] = str_replace('[/listo]','[/list]',$cur_item['message']);
|
||
$db->query('UPDATE '.$db->prefix.'posts SET message = \''.$db->escape(preparse_bbcode($cur_item['message'], $temp)).'\' WHERE id = '.$cur_item['id']) or error('Unable to update post', __FILE__, __LINE__, $db->error());
|
||
|
||
$end_at = $cur_item['id'];
|
||
}
|
||
|
||
// Check if there is more work to do
|
||
if ($end_at > 0)
|
||
{
|
||
$result = $db->query('SELECT 1 FROM '.$db->prefix.'posts WHERE id > '.$end_at.' ORDER BY id ASC LIMIT 1') or error('Unable to fetch next ID', __FILE__, __LINE__, $db->error());
|
||
|
||
if ($db->result($result))
|
||
$query_str = '?stage=preparse_posts&start_at='.$end_at;
|
||
}
|
||
|
||
break;
|
||
|
||
|
||
// Preparse signatures
|
||
case 'preparse_sigs':
|
||
$query_str = '?stage=rebuild_idx';
|
||
|
||
// If we don't need to parse the sigs, skip this stage
|
||
if (isset($pun_config['o_parser_revision']) && $pun_config['o_parser_revision'] >= UPDATE_TO_PARSER_REVISION)
|
||
break;
|
||
|
||
if (! isset($smilies))
|
||
$smilies = [];
|
||
if (! isset($pun_user))
|
||
$pun_user = ['g_post_links' => 1];
|
||
|
||
require PUN_ROOT.'include/parser.php';
|
||
|
||
// Fetch users to process this cycle
|
||
$result = $db->query('SELECT id, signature FROM '.$db->prefix.'users WHERE id > '.$start_at.' AND signature IS NOT NULL ORDER BY id ASC LIMIT '.PER_PAGE) or error('Unable to fetch users', __FILE__, __LINE__, $db->error());
|
||
|
||
$temp = array();
|
||
$end_at = 0;
|
||
while ($cur_item = $db->fetch_assoc($result))
|
||
{
|
||
echo sprintf($lang_update['Preparsing item'], $lang_update['signature'], $cur_item['id']).'<br />'."\n";
|
||
$db->query('UPDATE '.$db->prefix.'users SET signature = \''.$db->escape(preparse_bbcode($cur_item['signature'], $temp, true)).'\' WHERE id = '.$cur_item['id']) or error('Unable to update user', __FILE__, __LINE__, $db->error());
|
||
|
||
$end_at = $cur_item['id'];
|
||
}
|
||
|
||
// Check if there is more work to do
|
||
if ($end_at > 0)
|
||
{
|
||
$result = $db->query('SELECT 1 FROM '.$db->prefix.'users WHERE id > '.$end_at.' ORDER BY id ASC LIMIT 1') or error('Unable to fetch next ID', __FILE__, __LINE__, $db->error());
|
||
|
||
if ($db->result($result))
|
||
$query_str = '?stage=preparse_sigs&start_at='.$end_at;
|
||
}
|
||
|
||
break;
|
||
|
||
|
||
// Rebuild the search index
|
||
case 'rebuild_idx':
|
||
$query_str = '?stage=visman';
|
||
|
||
// If we don't need to update the search index, skip this stage
|
||
if (isset($pun_config['o_searchindex_revision']) && $pun_config['o_searchindex_revision'] >= UPDATE_TO_SI_REVISION)
|
||
break;
|
||
|
||
if ($start_at == 0)
|
||
{
|
||
// Truncate the tables just in-case we didn't already (if we are coming directly here without converting the tables)
|
||
$db->truncate_table('search_cache') or error('Unable to empty search cache table', __FILE__, __LINE__, $db->error());
|
||
$db->truncate_table('search_matches') or error('Unable to empty search index match table', __FILE__, __LINE__, $db->error());
|
||
$db->truncate_table('search_words') or error('Unable to empty search index words table', __FILE__, __LINE__, $db->error());
|
||
|
||
// Reset the sequence for the search words (not needed for SQLite)
|
||
switch ($db_type)
|
||
{
|
||
case 'mysql':
|
||
case 'mysqli':
|
||
case 'mysql_innodb':
|
||
case 'mysqli_innodb':
|
||
$db->query('ALTER TABLE '.$db->prefix.'search_words auto_increment=1') or error('Unable to update table auto_increment', __FILE__, __LINE__, $db->error());
|
||
break;
|
||
|
||
case 'pgsql';
|
||
$db->query('SELECT setval(\''.$db->prefix.'search_words_id_seq\', 1, false)') or error('Unable to update sequence', __FILE__, __LINE__, $db->error());
|
||
break;
|
||
}
|
||
}
|
||
|
||
require PUN_ROOT.'include/search_idx.php';
|
||
|
||
// Fetch posts to process this cycle
|
||
$result = $db->query('SELECT p.id, p.message, t.subject, t.first_post_id FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'topics AS t ON t.id=p.topic_id WHERE p.id > '.$start_at.' ORDER BY p.id ASC LIMIT '.PER_PAGE) or error('Unable to fetch posts', __FILE__, __LINE__, $db->error());
|
||
|
||
$end_at = 0;
|
||
while ($cur_item = $db->fetch_assoc($result))
|
||
{
|
||
echo sprintf($lang_update['Rebuilding index item'], $lang_update['post'], $cur_item['id']).'<br />'."\n";
|
||
|
||
if ($cur_item['id'] == $cur_item['first_post_id'])
|
||
update_search_index('post', $cur_item['id'], $cur_item['message'], $cur_item['subject']);
|
||
else
|
||
update_search_index('post', $cur_item['id'], $cur_item['message']);
|
||
|
||
$end_at = $cur_item['id'];
|
||
}
|
||
|
||
// Check if there is more work to do
|
||
if ($end_at > 0)
|
||
{
|
||
$result = $db->query('SELECT 1 FROM '.$db->prefix.'posts WHERE id > '.$end_at.' ORDER BY id ASC LIMIT 1') or error('Unable to fetch next ID', __FILE__, __LINE__, $db->error());
|
||
|
||
if ($db->result($result))
|
||
$query_str = '?stage=rebuild_idx&start_at='.$end_at;
|
||
}
|
||
|
||
break;
|
||
|
||
|
||
// Visman
|
||
case 'visman':
|
||
$query_str = '?stage=finish';
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 16)
|
||
{
|
||
$db->add_field('groups', 'g_deledit_interval', 'INT(10)', false, 0) or error('Unable to add g_deledit_interval field', __FILE__, __LINE__, $db->error());
|
||
|
||
$db->add_field('posts', 'edit_post', 'TINYINT(1)', false, 0) or error('Unable to add edit_post field', __FILE__, __LINE__, $db->error());
|
||
|
||
$db->add_field('users', 'gender', 'TINYINT(4) UNSIGNED', false, 0) or error('Unable to add gender field', __FILE__, __LINE__, $db->error());
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_cur_ver_revision\', \'0\')') or error('Unable to insert config value \'o_cur_ver_revision\'', __FILE__, __LINE__, $db->error());
|
||
|
||
if (!array_key_exists('o_merge_timeout', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_merge_timeout\', \'86400\')') or error('Unable to insert config value \'o_merge_timeout\'', __FILE__, __LINE__, $db->error());
|
||
|
||
if (!array_key_exists('o_coding_forms', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_coding_forms\', \'0\')') or error('Unable to insert config value \'o_coding_forms\'', __FILE__, __LINE__, $db->error());
|
||
|
||
if (!array_key_exists('o_check_ip', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_check_ip\', \'0\')') or error('Unable to insert config value \'o_check_ip\'', __FILE__, __LINE__, $db->error());
|
||
} // rev.16
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 21)
|
||
{
|
||
$db->add_field('groups', 'g_pm', 'TINYINT(1)', false, 1) or error('Unable to add g_pm field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('groups', 'g_pm_limit', 'INT(10) UNSIGNED', false, 100) or error('Unable to add g_pm_limit field', __FILE__, __LINE__, $db->error());
|
||
|
||
$db->add_field('users', 'messages_enable', 'TINYINT(1)', false, 1) or error('Unable to add messages_enable field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('users', 'messages_email', 'TINYINT(1)', false, 0) or error('Unable to add messages_email field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('users', 'messages_new', 'INT(10) UNSIGNED', false, 0) or error('Unable to add messages_new field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('users', 'messages_all', 'INT(10) UNSIGNED', false, 0) or error('Unable to add messages_all field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('users', 'pmsn_last_post', 'INT(10) UNSIGNED', true) or error('Unable to add pmsn_last_post field', __FILE__, __LINE__, $db->error());
|
||
|
||
$db->query('UPDATE '.$db->prefix.'groups SET g_pm_limit=0 WHERE g_id='.PUN_ADMIN) or error('Unable to merge groups', __FILE__, __LINE__, $db->error());
|
||
|
||
if (!array_key_exists('o_pms_enabled', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_pms_enabled\', \'1\')') or error('Unable to insert config value \'o_pms_enabled\'', __FILE__, __LINE__, $db->error());
|
||
|
||
if (!$db->table_exists('pms_new_block'))
|
||
{
|
||
$schema = array(
|
||
'FIELDS' => array(
|
||
'bl_id' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'bl_user_id' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
)
|
||
),
|
||
'INDEXES' => array(
|
||
'bl_id_idx' => array('bl_id'),
|
||
'bl_user_id_idx' => array('bl_user_id')
|
||
)
|
||
);
|
||
|
||
$db->create_table('pms_new_block', $schema) or error('Unable to create pms_new_block table', __FILE__, __LINE__, $db->error());
|
||
}
|
||
|
||
if (!$db->table_exists('pms_new_posts'))
|
||
{
|
||
$schema = array(
|
||
'FIELDS' => array(
|
||
'id' => array(
|
||
'datatype' => 'SERIAL',
|
||
'allow_null' => false
|
||
),
|
||
'poster' => array(
|
||
'datatype' => 'VARCHAR(200)',
|
||
'allow_null' => false,
|
||
'default' => '\'\''
|
||
),
|
||
'poster_id' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '1'
|
||
),
|
||
'poster_ip' => array(
|
||
'datatype' => 'VARCHAR(39)',
|
||
'allow_null' => true
|
||
),
|
||
'message' => array(
|
||
'datatype' => 'TEXT',
|
||
'allow_null' => true
|
||
),
|
||
'hide_smilies' => array(
|
||
'datatype' => 'TINYINT(1)',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'posted' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'edited' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => true
|
||
),
|
||
'edited_by' => array(
|
||
'datatype' => 'VARCHAR(200)',
|
||
'allow_null' => true
|
||
),
|
||
'post_new' => array(
|
||
'datatype' => 'TINYINT(1)',
|
||
'allow_null' => false,
|
||
'default' => '1'
|
||
),
|
||
'topic_id' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
)
|
||
),
|
||
'PRIMARY KEY' => array('id'),
|
||
'INDEXES' => array(
|
||
'topic_id_idx' => array('topic_id'),
|
||
'multi_idx' => array('poster_id', 'topic_id')
|
||
)
|
||
);
|
||
|
||
$db->create_table('pms_new_posts', $schema) or error('Unable to create pms_new_posts table', __FILE__, __LINE__, $db->error());
|
||
}
|
||
|
||
if (!$db->table_exists('pms_new_topics'))
|
||
{
|
||
$schema = array(
|
||
'FIELDS' => array(
|
||
'id' => array(
|
||
'datatype' => 'SERIAL',
|
||
'allow_null' => false
|
||
),
|
||
'topic' => array(
|
||
'datatype' => 'VARCHAR(255)',
|
||
'allow_null' => false,
|
||
'default' => '\'\''
|
||
),
|
||
'starter' => array(
|
||
'datatype' => 'VARCHAR(200)',
|
||
'allow_null' => false,
|
||
'default' => '\'\''
|
||
),
|
||
'starter_id' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'to_user' => array(
|
||
'datatype' => 'VARCHAR(200)',
|
||
'allow_null' => false,
|
||
'default' => '\'\''
|
||
),
|
||
'to_id' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'replies' => array(
|
||
'datatype' => 'MEDIUMINT(8) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'last_posted' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'last_poster' => array(
|
||
'datatype' => 'TINYINT(1)',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'see_st' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'see_to' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'topic_st' => array(
|
||
'datatype' => 'TINYINT(4)',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'topic_to' => array(
|
||
'datatype' => 'TINYINT(4)',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
),
|
||
'PRIMARY KEY' => array('id'),
|
||
'INDEXES' => array(
|
||
'multi_idx_st' => array('starter_id', 'topic_st'),
|
||
'multi_idx_to' => array('to_id', 'topic_to')
|
||
)
|
||
);
|
||
|
||
$db->create_table('pms_new_topics', $schema) or error('Unable to create pms_new_topics table', __FILE__, __LINE__, $db->error());
|
||
}
|
||
} // rev.21
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 23)
|
||
{
|
||
$db->add_field('forums', 'no_sum_mess', 'TINYINT(1)', false, 0) or error('Unable to add no_sum_mess field', __FILE__, __LINE__, $db->error());
|
||
} // rev.23
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 24)
|
||
{
|
||
if (!$db->table_exists('smilies'))
|
||
{
|
||
// Create "smilies" table
|
||
$schema = array(
|
||
'FIELDS' => array(
|
||
'id' => array(
|
||
'datatype' => 'SERIAL',
|
||
'allow_null' => false
|
||
),
|
||
'image' => array(
|
||
'datatype' => 'VARCHAR(40)',
|
||
'allow_null' => false,
|
||
'default' => '\'\''
|
||
),
|
||
'text' => array(
|
||
'datatype' => 'VARCHAR(20)',
|
||
'allow_null' => false,
|
||
'default' => '\'\''
|
||
),
|
||
'disp_position' => array(
|
||
'datatype' => 'TINYINT(4) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
)
|
||
),
|
||
'PRIMARY KEY' => array('id')
|
||
);
|
||
$db->create_table('smilies', $schema) or error('Unable to create smilies table', __FILE__, __LINE__, $db->error());
|
||
|
||
// ВНИМАНИЕ!!! ATTENTION!!!
|
||
// Если на вашем форуме используются другие смайлы,
|
||
// то перед обновлением замените этот массив на свой!
|
||
// Брать из файла parser.php
|
||
$smilies = array(
|
||
':)' => 'smile.png',
|
||
'=)' => 'smile.png',
|
||
':|' => 'neutral.png',
|
||
'=|' => 'neutral.png',
|
||
':(' => 'sad.png',
|
||
'=(' => 'sad.png',
|
||
':D' => 'big_smile.png',
|
||
'=D' => 'big_smile.png',
|
||
':o' => 'yikes.png',
|
||
':O' => 'yikes.png',
|
||
';)' => 'wink.png',
|
||
':/' => 'hmm.png',
|
||
':P' => 'tongue.png',
|
||
':p' => 'tongue.png',
|
||
':lol:' => 'lol.png',
|
||
':mad:' => 'mad.png',
|
||
':rolleyes:' => 'roll.png',
|
||
':cool:' => 'cool.png',
|
||
);
|
||
|
||
$i = 0;
|
||
foreach ($smilies as $text => $img)
|
||
{
|
||
$db->query('INSERT INTO '.$db->prefix.'smilies (image, text, disp_position) VALUES (\''.$img.'\', \''.$db->escape($text).'\', '.$i.')') or error('Unable to add smiley', __FILE__, __LINE__, $db->error());
|
||
$i++;
|
||
}
|
||
}
|
||
} // rev.24
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 26)
|
||
{
|
||
$db->add_field('topics', 'stick_fp', 'TINYINT(1)', false, 0) or error('Unable to add stick_fp field', __FILE__, __LINE__, $db->error());
|
||
} // rev.26
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 27)
|
||
{
|
||
$db->add_field('users', 'messages_flag', 'TINYINT(1)', false, 0) or error('Unable to add messages_flag field', __FILE__, __LINE__, $db->error());
|
||
} // rev.27
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 28)
|
||
{
|
||
// Create warnings table - Visman
|
||
$schema = array(
|
||
'FIELDS' => array(
|
||
'id' => array(
|
||
'datatype' => 'SERIAL',
|
||
'allow_null' => false
|
||
),
|
||
'poster' => array(
|
||
'datatype' => 'VARCHAR(200)',
|
||
'allow_null' => false,
|
||
'default' => '\'\''
|
||
),
|
||
'poster_id' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'posted' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'message' => array(
|
||
'datatype' => 'TEXT',
|
||
'allow_null' => true
|
||
)
|
||
),
|
||
'PRIMARY KEY' => array('id')
|
||
);
|
||
|
||
$db->create_table('warnings', $schema) or error('Unable to create warnings table', __FILE__, __LINE__, $db->error());
|
||
// Create warnings table - Visman
|
||
} // rev.28
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 29)
|
||
{
|
||
$db->add_field('users', 'warning_flag', 'TINYINT(1)', false, 0) or error('Unable to add messages_flag field', __FILE__, __LINE__, $db->error());
|
||
} // rev.29
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 31)
|
||
{
|
||
$db->add_field('users', 'warning_all', 'INT(10) UNSIGNED', false, 0) or error('Unable to add messages_all field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('posts', 'user_agent', 'VARCHAR( 255 )', true);
|
||
|
||
if (!array_key_exists('o_pms_min_kolvo', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_pms_min_kolvo\', \'0\')') or error('Unable to insert config value \'o_pms_min_kolvo\'', __FILE__, __LINE__, $db->error());
|
||
} // rev.31
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 32)
|
||
{
|
||
if (!array_key_exists('o_board_redirect', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_board_redirect\', \'\')') or error('Unable to insert config value \'o_board_redirect\'', __FILE__, __LINE__, $db->error());
|
||
if (!array_key_exists('o_board_redirectg', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_board_redirectg\', \'0\')') or error('Unable to insert config value \'o_board_redirectg\'', __FILE__, __LINE__, $db->error());
|
||
} // rev.32
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 33)
|
||
{
|
||
$db->add_field('topics', 'poll_type', 'TINYINT(4)', false, 0) or error('Unable to add poll_type field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('topics', 'poll_time', 'INT(10) UNSIGNED', false, 0) or error('Unable to add poll_time field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('topics', 'poll_term', 'TINYINT(4)', false, 0) or error('Unable to add poll_term field', __FILE__, __LINE__, $db->error());
|
||
$db->add_field('topics', 'poll_kol', 'INT(10) UNSIGNED', false, 0) or error('Unable to add poll_kol field', __FILE__, __LINE__, $db->error());
|
||
|
||
$schema = array(
|
||
'FIELDS' => array(
|
||
'tid' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'question' => array(
|
||
'datatype' => 'TINYINT(4)',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'field' => array(
|
||
'datatype' => 'TINYINT(4)',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
),
|
||
'choice' => array(
|
||
'datatype' => 'VARCHAR(255)',
|
||
'allow_null' => false,
|
||
'default' => '\'\''
|
||
),
|
||
'votes' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false,
|
||
'default' => '0'
|
||
)
|
||
),
|
||
'PRIMARY KEY' => array('tid', 'question', 'field')
|
||
);
|
||
|
||
$db->create_table('poll', $schema) or error('Unable to create table poll', __FILE__, __LINE__, $db->error());
|
||
|
||
$schema = array(
|
||
'FIELDS' => array(
|
||
'tid' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false
|
||
),
|
||
'uid' => array(
|
||
'datatype' => 'INT(10) UNSIGNED',
|
||
'allow_null' => false
|
||
),
|
||
'rez' => array(
|
||
'datatype' => 'TEXT',
|
||
'allow_null' => true
|
||
)
|
||
),
|
||
'PRIMARY KEY' => array('tid', 'uid')
|
||
);
|
||
|
||
$db->create_table('poll_voted', $schema) or error('Unable to create table poll_voted', __FILE__, __LINE__, $db->error());
|
||
|
||
if (!array_key_exists('o_poll_enabled', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_poll_enabled\', \'0\')') or error('Unable to insert config value \'o_poll_enabled\'', __FILE__, __LINE__, $db->error());
|
||
if (!array_key_exists('o_poll_max_ques', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_poll_max_ques\', \'3\')') or error('Unable to insert config value \'o_poll_max_ques\'', __FILE__, __LINE__, $db->error());
|
||
if (!array_key_exists('o_poll_max_field', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_poll_max_field\', \'20\')') or error('Unable to insert config value \'o_poll_max_field\'', __FILE__, __LINE__, $db->error());
|
||
if (!array_key_exists('o_poll_time', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_poll_time\', \'60\')') or error('Unable to insert config value \'o_poll_time\'', __FILE__, __LINE__, $db->error());
|
||
if (!array_key_exists('o_poll_term', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_poll_term\', \'3\')') or error('Unable to insert config value \'o_poll_term\'', __FILE__, __LINE__, $db->error());
|
||
if (!array_key_exists('o_poll_guest', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_poll_guest\', \'0\')') or error('Unable to insert config value \'o_poll_guest\'', __FILE__, __LINE__, $db->error());
|
||
} // rev.33
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 40)
|
||
{
|
||
if (!array_key_exists('o_fbox_guest', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_fbox_guest\', \'0\')') or error('Unable to insert config value \'o_fbox_guest\'', __FILE__, __LINE__, $db->error());
|
||
if (!array_key_exists('o_fbox_files', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_fbox_files\', \'viewtopic.php,search.php,pmsnew.php\')') or error('Unable to insert config value \'o_fbox_files\'', __FILE__, __LINE__, $db->error());
|
||
} // rev.40
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 42)
|
||
{
|
||
$db->add_field('online', 'witt_data', 'VARCHAR(255)', false, '') or error('Unable to add witt_data field', __FILE__, __LINE__, $db->error());
|
||
} // rev.42
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 47)
|
||
{
|
||
$db->query('DELETE FROM '.$db->prefix.'config WHERE conf_name LIKE \'o\_uploadile\_%\'') or error('Unable to remove config entries', __FILE__, __LINE__, $db->error());
|
||
|
||
if (!array_key_exists('o_crypto_enable', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_crypto_enable\', \'1\')') or error('Unable to insert config value \'o_crypto_enable\'', __FILE__, __LINE__, $db->error());
|
||
if (!array_key_exists('o_crypto_pas', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_crypto_pas\', \''.$db->escape(random_pass(25)).'\')') or error('Unable to insert config value \'o_crypto_pas\'', __FILE__, __LINE__, $db->error());
|
||
if (!array_key_exists('o_crypto_salt', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_crypto_salt\', \''.$db->escape(random_pass(13)).'\')') or error('Unable to insert config value \'o_crypto_salt\'', __FILE__, __LINE__, $db->error());
|
||
} // rev.47
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 52)
|
||
{
|
||
@unlink(PUN_ROOT.'include/footer.php');
|
||
@unlink(PUN_ROOT.'include/header.php');
|
||
} // rev.52
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 57)
|
||
{
|
||
$db->add_field('forums', 'parent_forum_id', 'INT(10) UNSIGNED', false, 0);
|
||
$db->add_field('forums', 'last_topic', 'VARCHAR(255)', true, null, 'last_poster');
|
||
$db->query('UPDATE '.$db->prefix.'forums AS f, '.$db->prefix.'posts AS p, '.$db->prefix.'topics AS t SET f.last_topic=t.subject WHERE f.last_post_id=p.id AND p.topic_id=t.id') or error('Unable to update last topic', __FILE__, __LINE__, $db->error());
|
||
} // rev.57
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 58)
|
||
{
|
||
$stat = array();
|
||
if (file_exists(FORUM_CACHE_DIR.'cache_maxusers.php'))
|
||
include FORUM_CACHE_DIR.'cache_maxusers.php';
|
||
|
||
if (!defined('PUN_MAXUSERS_LOADED'))
|
||
{
|
||
$stats['max_users'] = 1;
|
||
$stats['max_users_time'] = time();
|
||
}
|
||
|
||
if (!array_key_exists('st_max_users', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'st_max_users\', \''.$db->escape($stats['max_users']).'\')') or error('Unable to insert config value \'st_max_users\'', __FILE__, __LINE__, $db->error());
|
||
if (!array_key_exists('st_max_users_time', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'st_max_users_time\', \''.$db->escape($stats['max_users_time']).'\')') or error('Unable to insert config value \'st_max_users_time\'', __FILE__, __LINE__, $db->error());
|
||
} // rev.58
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 59)
|
||
{
|
||
@unlink(PUN_ROOT.'include/cache_smilies.php');
|
||
} // rev.59
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 63)
|
||
{
|
||
$conf_contents = file_get_contents(PUN_ROOT.'include/config.php');
|
||
|
||
if ($conf_contents === false)
|
||
error('Unable to read config file include/config.php.', __FILE__, __LINE__);
|
||
|
||
$conf_define = array(
|
||
'PUN_DEBUG' => array('1', true, ''),
|
||
'PUN_SHOW_QUERIES' => array('1', false, ''),
|
||
'PUN_MAX_POSTSIZE' => array('65535', true, ''),
|
||
'FORUM_EOL' => array('"\r\n"', false, 'possible values can be PHP_EOL, "\r\n", "\n" or "\r"'),
|
||
'FORUM_UA_OFF' => array('1', false, ''),
|
||
'FORUM_AJAX_JQUERY' => array('\'js/jquery-1.12.4.min.js\'', true, ''),
|
||
);
|
||
|
||
$conf_add = array();
|
||
foreach ($conf_define as $conf_name => $conf_value)
|
||
{
|
||
if (!preg_match('%[\'"]'.$conf_name.'[\'"]%u', $conf_contents))
|
||
{
|
||
$conf_add[] = ($conf_value[1] ? '' : '//').'define(\''.$conf_name.'\', '.$conf_value[0].');'.(empty($conf_value[2]) ? '' : ' // '.$conf_value[2]);
|
||
}
|
||
}
|
||
|
||
if (!empty($conf_add))
|
||
{
|
||
$fn = @fopen(PUN_ROOT.'include/config.php', 'wb');
|
||
if (!$fn)
|
||
error('Unable to write config file include/config.php.', __FILE__, __LINE__);
|
||
|
||
if (fwrite($fn, pun_trim($conf_contents, " \n\r")."\n\n".implode("\n", $conf_add)."\n") === false)
|
||
error('Unable to write config file include/config.php.', __FILE__, __LINE__);
|
||
|
||
fclose($fn);
|
||
}
|
||
} // rev.63
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 65)
|
||
{
|
||
@unlink(PUN_ROOT.'lang/English/bbcode.php');
|
||
@unlink(PUN_ROOT.'lang/Russian/bbcode.php');
|
||
} // rev.65
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 68)
|
||
{
|
||
$db->query('DELETE FROM '.$db->prefix.'config WHERE conf_name LIKE \'o\_blocking\_%\'') or error('Unable to remove config entries', __FILE__, __LINE__, $db->error());
|
||
|
||
if ($db->table_exists('blocking'))
|
||
$db->drop_table('blocking') or error('Unable to drop blocking table', __FILE__, __LINE__, $db->error());
|
||
|
||
if (!array_key_exists('o_enable_acaptcha', $pun_config))
|
||
$db->query('INSERT INTO '.$db->prefix.'config (conf_name, conf_value) VALUES (\'o_enable_acaptcha\', \'1\')') or error('Unable to insert config value \'o_enable_acaptcha\'', __FILE__, __LINE__, $db->error());
|
||
} // rev.68
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 72)
|
||
{
|
||
@unlink(PUN_ROOT.'js/minmax.js');
|
||
@unlink(PUN_ROOT.'install.php');
|
||
} // rev.72
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 74)
|
||
{
|
||
$db->drop_field('pms_new_block', 'bl_user') or error('Unable to drop bl_user field', __FILE__, __LINE__, $db->error());
|
||
$db->drop_field('pms_new_posts', 'post_seen') or error('Unable to drop post_seen field', __FILE__, __LINE__, $db->error());
|
||
} // rev.74
|
||
|
||
if (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 78)
|
||
{
|
||
$db->alter_field('users', 'password', 'VARCHAR(255)', false, '') or error('Unable to alter password field', __FILE__, __LINE__, $db->error());
|
||
$db->alter_field('users', 'activate_string', 'VARCHAR(255)', true) or error('Unable to alter activate_string field', __FILE__, __LINE__, $db->error());
|
||
} // rev.78
|
||
|
||
if ($mysql && (!array_key_exists('o_cur_ver_revision', $pun_config) || $pun_config['o_cur_ver_revision'] < 79))
|
||
{
|
||
echo 'Update DB to utf8mb4...<br />'."\n";
|
||
|
||
$db->alter_field('config', 'conf_name', 'VARCHAR(190)', false, '') or error('Unable to alter password field', __FILE__, __LINE__, $db->error());
|
||
|
||
$db->query('ALTER DATABASE `'.$db_name.'` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci') or error('Unable to update CHARACTER SET for DB', __FILE__, __LINE__, $db->error());
|
||
|
||
$db_tables = [
|
||
'bans',
|
||
'categories',
|
||
'censoring',
|
||
'config',
|
||
'forums',
|
||
'forum_perms',
|
||
'forum_subscriptions',
|
||
'groups',
|
||
'online',
|
||
'pms_new_block',
|
||
'pms_new_posts',
|
||
'pms_new_topics',
|
||
'poll',
|
||
'poll_voted',
|
||
'posts',
|
||
'reports',
|
||
'search_cache',
|
||
'search_matches',
|
||
'search_words',
|
||
'sec_of_login',
|
||
'sec_of_post',
|
||
'sec_of_register',
|
||
'smilies',
|
||
'topics',
|
||
'topic_subscriptions',
|
||
'users',
|
||
'warnings',
|
||
];
|
||
|
||
foreach ($db_tables as $t)
|
||
{
|
||
if (!$db->table_exists($t))
|
||
{
|
||
continue;
|
||
}
|
||
echo 'Update `' . $t . '` to utf8mb4...<br />'."\n";
|
||
|
||
alter_table_utf8($db_prefix . $t);
|
||
}
|
||
} // rev.79
|
||
// Visman
|
||
break;
|
||
|
||
// Show results page
|
||
case 'finish':
|
||
// We update the version number
|
||
$db->query('UPDATE '.$db->prefix.'config SET conf_value = \''.UPDATE_TO.'\' WHERE conf_name = \'o_cur_version\'') or error('Unable to update version', __FILE__, __LINE__, $db->error());
|
||
|
||
// Обновляем номер сборки - Visman
|
||
$db->query('UPDATE '.$db->prefix.'config SET conf_value = \''.UPDATE_TO_VER_REVISION.'\' WHERE conf_name = \'o_cur_ver_revision\'') or error('Unable to update revision', __FILE__, __LINE__, $db->error());
|
||
|
||
// And the database revision number
|
||
$db->query('UPDATE '.$db->prefix.'config SET conf_value = \''.UPDATE_TO_DB_REVISION.'\' WHERE conf_name = \'o_database_revision\'') or error('Unable to update database revision number', __FILE__, __LINE__, $db->error());
|
||
|
||
// And the search index revision number
|
||
$db->query('UPDATE '.$db->prefix.'config SET conf_value = \''.UPDATE_TO_SI_REVISION.'\' WHERE conf_name = \'o_searchindex_revision\'') or error('Unable to update search index revision number', __FILE__, __LINE__, $db->error());
|
||
|
||
// And the parser revision number
|
||
$db->query('UPDATE '.$db->prefix.'config SET conf_value = \''.UPDATE_TO_PARSER_REVISION.'\' WHERE conf_name = \'o_parser_revision\'') or error('Unable to update parser revision number', __FILE__, __LINE__, $db->error());
|
||
|
||
// Check the default language still exists!
|
||
if (!file_exists(PUN_ROOT.'lang/'.$pun_config['o_default_lang'].'/common.php'))
|
||
$db->query('UPDATE '.$db->prefix.'config SET conf_value = \'English\' WHERE conf_name = \'o_default_lang\'') or error('Unable to update default language', __FILE__, __LINE__, $db->error());
|
||
|
||
// Check the default style still exists!
|
||
if (!file_exists(PUN_ROOT.'style/'.$pun_config['o_default_style'].'.css'))
|
||
$db->query('UPDATE '.$db->prefix.'config SET conf_value = \'Air\' WHERE conf_name = \'o_default_style\'') or error('Unable to update default style', __FILE__, __LINE__, $db->error());
|
||
|
||
// This feels like a good time to synchronize the forums
|
||
$result = $db->query('SELECT id FROM '.$db->prefix.'forums') or error('Unable to fetch forum IDs', __FILE__, __LINE__, $db->error());
|
||
|
||
while ($row = $db->fetch_row($result))
|
||
update_forum($row[0]);
|
||
|
||
// Empty the PHP cache
|
||
forum_clear_cache();
|
||
|
||
// Delete the update lock file
|
||
@unlink(FORUM_CACHE_DIR.'db_update.lock');
|
||
|
||
?>
|
||
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
|
||
|
||
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<?php echo $lang_common['lang_identifier'] ?>" lang="<?php echo $lang_common['lang_identifier'] ?>" dir="<?php echo $lang_common['lang_direction'] ?>">
|
||
<head>
|
||
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
<title><?php echo $lang_update['Update'] ?></title>
|
||
<link rel="stylesheet" type="text/css" href="style/<?php echo $default_style ?>.css" />
|
||
</head>
|
||
<body>
|
||
|
||
<div id="pundb_update" class="pun">
|
||
<div class="top-box"><div><!-- Top Corners --></div></div>
|
||
<div class="punwrap">
|
||
|
||
<div class="blockform">
|
||
<h2><span><?php echo $lang_update['Update'] ?></span></h2>
|
||
<div class="box">
|
||
<div class="fakeform">
|
||
<div class="inform">
|
||
<div class="forminfo">
|
||
<p style="font-size: 1.1em"><?php printf($lang_update['Successfully updated'], sprintf('<a href="index.php">%s</a>', $lang_update['go to index'])) ?></p>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
</div>
|
||
<div class="end-box"><div><!-- Bottom Corners --></div></div>
|
||
</div>
|
||
|
||
</body>
|
||
</html>
|
||
<?php
|
||
|
||
break;
|
||
}
|
||
|
||
$db->end_transaction();
|
||
$db->close();
|
||
|
||
if ($query_str != '')
|
||
exit('<meta http-equiv="refresh" content="0;url=db_update.php'.$query_str.'&uid='.$uid.'" /><hr /><p>'.sprintf($lang_update['Automatic redirect failed'], '<a href="db_update.php'.$query_str.'&uid='.$uid.'">'.$lang_update['Click here'].'</a>').'</p>');
|