function fix_profile($profile)
{
$text = html_to_bbcode($profile->response2);
if ($text != $profile->response2) {
$query = "update profile set response2 = '" . _mysql_escape_string($text) . "' where userid=" . $profile->userid;
//echo "$profile->response2\n\n";
//echo "$profile->thread $query\n\n";
$retval = _mysql_query($query);
if (!$retval) {
echo _mysql_error();
exit;
}
}
}
function fix_post($post)
{
$text = html_to_bbcode($post->content);
if ($text != $post->content) {
$query = "update post set content = '" . _mysql_escape_string($text) . "' where id=" . $post->id;
//echo "$post->content\n\n";
//echo "$post->thread $query\n\n";
$retval = _mysql_query($query);
if (!$retval) {
echo _mysql_error();
exit;
}
}
}
function fix_forum_preferences($forum_preferences)
{
$text = html_to_bbcode($forum_preferences->signature);
if ($text != $forum_preferences->signature) {
$query = "update forum_preferences set signature = '" . _mysql_escape_string($text) . "' where userid=" . $forum_preferences->userid;
//echo "$forum_preferences->signature\n\n";
//echo "$forum_preferences->thread $query\n\n";
$retval = _mysql_query($query);
if (!$retval) {
echo _mysql_error();
exit;
}
}
}
function cherokee_mysql_real_escape_string($unescaped_string, $link = NULL)
{
if (!_dbslayer($link)) {
return _call('_mysql_real_escape_string', $unescaped_string, $link);
}
return _mysql_escape_string($unescaped_string);
}
if (isset($item[2])) {
$title = $item[2];
} else {
$n = strpos($content, ". ");
if ($n) {
$title = substr($content, 0, $n);
} else {
$title = $content;
}
}
$when = strtotime($item[0]);
$title = html_to_bbcode($title);
$title = str_replace("\n", " ", $title);
$title = _mysql_escape_string($title);
$content = html_to_bbcode($content);
$content = str_replace("\n", " ", $content);
$content = _mysql_escape_string($content);
$thread_id = BoincThread::insert("(forum, owner, title, create_time, timestamp, replies) values ({$forum_id}, {$user->id}, '{$title}', {$when}, {$when}, 0)");
if (!$thread_id) {
echo "thread insert failed\n";
echo "title: [{$title}]\n";
echo "when: {$when}\n";
exit;
}
$id = BoincPost::insert("(thread, user, timestamp, content) values ({$thread_id}, {$user->id}, {$when}, '{$content}')");
if (!$id) {
die("post insert");
}
$forum->update("threads=threads+1, posts=posts+1");
}
echo "\n\nProject news has been successfully converted from\nhtml/project/project_news.inc to forum format.\nChange your index.php to use\n show_news(0, 5)\nto show news and related links.\n\nIf everything looks OK, you can delete html/project/project_news.inc\n\n";
