function phorum_htmlpurifier_migrate_sigs($offset)
{
global $PHORUM;
if (!$offset) {
return;
}
// bail out quick of $offset == 0
@set_time_limit(0);
// attempt to let this run
$increment = $PHORUM['mod_htmlpurifier']['migrate-sigs-increment'];
require_once dirname(__FILE__) . '/../migrate.php';
// migrate signatures
// do this in batches so we don't run out of time/space
$end = $offset + $increment;
$user_ids = array();
for ($i = $offset; $i < $end; $i++) {
$user_ids[] = $i;
}
$userinfos = phorum_db_user_get_fields($user_ids, 'signature');
foreach ($userinfos as $i => $user) {
if (empty($user['signature'])) {
continue;
}
$sig = $user['signature'];
// perform standard Phorum processing on the sig
$sig = str_replace(array("&", "<", ">"), array("&", "<", ">"), $sig);
$sig = preg_replace("/<((http|https|ftp):\\/\\/[a-z0-9;\\/\\?:@=\\&\$\\-_\\.\\+!*'\\(\\),~%]+?)>/i", "\$1", $sig);
// prepare fake data to pass to migration function
$fake_data = array(array("author" => "", "email" => "", "subject" => "", 'body' => $sig));
list($fake_message) = phorum_htmlpurifier_migrate($fake_data);
$user['signature'] = $fake_message['body'];
if (!phorum_user_save($user)) {
exit('Error while saving user data');
}
}
unset($userinfos);
// free up memory
// query for highest ID in database
$type = $PHORUM['DBCONFIG']['type'];
if ($type == 'mysql') {
$conn = phorum_db_mysql_connect();
$sql = "select MAX(user_id) from {$PHORUM['user_table']}";
$res = mysql_query($sql, $conn);
$row = mysql_fetch_row($res);
$top_id = (int) $row[0];
} elseif ($type == 'mysqli') {
$conn = phorum_db_mysqli_connect();
$sql = "select MAX(user_id) from {$PHORUM['user_table']}";
$res = mysqli_query($conn, $sql);
$row = mysqli_fetch_row($res);
$top_id = (int) $row[0];
} else {
exit('Unrecognized database!');
}
$offset += $increment;
if ($offset > $top_id) {
// test for end condition
echo 'Migration finished';
$PHORUM['mod_htmlpurifier']['migrate-sigs'] = false;
phorum_htmlpurifier_commit_settings();
return true;
}
$host = $_SERVER['HTTP_HOST'];
$uri = rtrim(dirname($_SERVER['PHP_SELF']), '/\\');
$extra = 'admin.php?module=modsettings&mod=htmlpurifier&migrate-sigs=' . $offset;
// relies on output buffering to work
header("Location: http://{$host}{$uri}/{$extra}");
exit;
}
/**
* This function is used by the sanity checking system to let the
* database layer do sanity checks of its own. This function can
* be used by every database layer to implement specific checks.
*
* The return value for this function should be exactly the same
* as the return value expected for regular sanity checking
* function (see include/admin/sanity_checks.php for information).
*
* There's no need to load the sanity_check.php file for the needed
* constants, because this function should only be called from the
* sanity checking system.
*/
function phorum_db_sanitychecks()
{
$PHORUM = $GLOBALS["PHORUM"];
// Retrieve the MySQL server version.
$conn = phorum_db_mysqli_connect();
$res = mysqli_query($conn, "SELECT @@global.version");
if (!$res) return array(
PHORUM_SANITY_WARN,
"The database layer could not retrieve the version of the
running MySQL server",
"This probably means that you are running a really old MySQL
server, which does not support \"SELECT @@global.version\"
as an SQL command. If you are not running a MySQL server
with version 4.0.18 or higher, then please upgrade your
MySQL server. Else, contact the Phorum developers to see
where this warning is coming from"
);
if (mysqli_num_rows($res))
{
$row = mysqli_fetch_array($res);
$ver = explode(".", $row[0]);
// Version numbering format which is not recognized.
if (count($ver) != 3) return array(
PHORUM_SANITY_WARN,
"The database layer was unable to recognize the MySQL server's
version number \"" . htmlspecialchars($row[0]) . "\". Therefore,
checking if the right version of MySQL is used is not possible.",
"Contact the Phorum developers and report this specific
version number, so the checking scripts can be updated."
);
settype($ver[0], 'int');
settype($ver[1], 'int');
settype($ver[2], 'int');
// MySQL before version 4.
if ($ver[0] < 4) return array(
PHORUM_SANITY_CRIT,
"The MySQL database server that is used is too old. The
running version is \"" . htmlspecialchars($row[0]) . "\",
while MySQL version 4.0.18 or higher is recommended.",
"Upgrade your MySQL server to a newer version. If your
website is hosted with a service provider, please contact
the service provider to upgrade your MySQL database."
);
// MySQL before version 4.0.18, with full text search enabled.
if ($PHORUM["DBCONFIG"]["mysql_use_ft"] &&
$ver[0] == 4 && $ver[1] == 0 && $ver[2] < 18) return array(
PHORUM_SANITY_WARN,
"The MySQL database server that is used does not
support all Phorum features. The running version is
\"" . htmlspecialchars($row[0]) . "\", while MySQL version
4.0.18 or higher is recommended.",
"Upgrade your MySQL server to a newer version. If your
website is hosted with a service provider, please contact
the service provider to upgrade your MySQL database."
);
// All checks are okay.
return array (PHORUM_SANITY_OK, NULL);
}
return array(
PHORUM_SANITY_CRIT,
"An unexpected problem was found in running the sanity
check function phorum_db_sanitychecks().",
"Contact the Phorum developers to find out what the problem is."
);
}
