The first script was for ubbt_POSTS. Here the rest:

ubbt_TOPICS:
Code
<?php
$db = new mysqli( "localhost", "DATABASE_USERNAME", "DATABASE_PASSWORD", "DATABASE_NAME" );
$db -> set_charset( "utf8" );

$result = $db -> query( "
    SELECT 
    TOPIC_ID, 
    convert(cast(convert(TOPIC_SUBJECT using latin1) as binary) using utf8), 
    convert(cast(convert(TOPIC_LAST_POSTER_NAME using latin1) as binary) using utf8), 
    convert(cast(convert(TOPIC_POSTER_NAME using latin1) as binary) using utf8) 
    FROM 
    ubbt_TOPICS;
" );

while( list( $topic_id, $topic_subject, $topic_last_poster_name, $topic_poster_name ) = $result -> fetch_row() )
{
    $db -> query( "
        UPDATE 
        ubbt_TOPICS 
        SET 
        TOPIC_SUBJECT = '" . $db -> escape_string( $topic_subject ) . "',
        TOPIC_LAST_POSTER_NAME = '" . $db -> escape_string( $topic_last_poster_name ) . "',
        TOPIC_POSTER_NAME = '" . $db -> escape_string( $topic_poster_name ) . "'
        WHERE
        TOPIC_ID = '" . $topic_id . "';
    " );
    
    echo "Processing topic #".$topic_id."<br>";
}

$db -> close();
?>
ubbt_PRIVATE_MESSAGE_TOPICS:
Code
<?php
$db = new mysqli( "localhost", "DATABASE_USERNAME", "DATABASE_PASSWORD", "DATABASE_NAME" );
$db -> set_charset( "utf8" );

$result = $db -> query( "
    SELECT 
    TOPIC_ID, 
    convert(cast(convert(TOPIC_SUBJECT using latin1) as binary) using utf8), 
    convert(cast(convert(TOPIC_LAST_POSTER_NAME using latin1) as binary) using utf8)
    FROM 
    ubbt_PRIVATE_MESSAGE_TOPICS;
" );

while( list( $topic_id, $topic_subject, $topic_last_poster_name ) = $result -> fetch_row() )
{
    $db -> query( "
        UPDATE 
        ubbt_PRIVATE_MESSAGE_TOPICS
        SET 
        TOPIC_SUBJECT = '" . $db -> escape_string( $topic_subject ) . "',
        TOPIC_LAST_POSTER_NAME = '" . $db -> escape_string( $topic_last_poster_name ) . "'
        WHERE
        TOPIC_ID = '" . $topic_id . "';
    " );
    
    echo "Processing PM topic #".$topic_id."<br>";
}

$db -> close();
?>
ubbt_PRIVATE_MESSAGE_POSTS:
Code
<?php
$db = new mysqli( "localhost", "DATABASE_USERNAME", "DATABASE_PASSWORD", "DATABASE_NAME" );
$db -> set_charset( "utf8" );

$result = $db -> query( "
    SELECT 
    POST_ID, 
    convert(cast(convert(POST_BODY using latin1) as binary) using utf8), 
    convert(cast(convert(POST_DEFAULT_BODY using latin1) as binary) using utf8)
    FROM 
    ubbt_PRIVATE_MESSAGE_POSTS;
" );

while( list( $post_id, $post_body, $post_default_body ) = $result -> fetch_row() )
{
    $db -> query( "
        UPDATE 
        ubbt_PRIVATE_MESSAGE_POSTS
        SET 
        POST_BODY = '" . $db -> escape_string( $post_body ) . "',
        POST_DEFAULT_BODY = '" . $db -> escape_string( $post_default_body ) . "'
        WHERE
        POST_ID = '" . $post_id . "';
    " );
    
    echo "Processing PM post #".$post_id."<br>";
}

$db -> close();
?>
ubbt_PROFILE_COMMENTS:
Code
<?php
$db = new mysqli( "localhost", "DATABASE_USERNAME", "DATABASE_PASSWORD", "DATABASE_NAME" );
$db -> set_charset( "utf8" );

$result = $db -> query( "
    SELECT 
    COMMENT_ID, 
    convert(cast(convert(COMMENT_BODY using latin1) as binary) using utf8), 
    convert(cast(convert(COMMENT_DEFAULT_BODY using latin1) as binary) using utf8)
    FROM 
    ubbt_PROFILE_COMMENTS;
" );

while( list( $comment_id, $comment_body, $comment_default_body ) = $result -> fetch_row() )
{
    $db -> query( "
        UPDATE 
        ubbt_PROFILE_COMMENTS
        SET 
        COMMENT_BODY = '" . $db -> escape_string( $comment_body ) . "',
        COMMENT_DEFAULT_BODY = '" . $db -> escape_string( $comment_default_body ) . "'
        WHERE
        COMMENT_ID = '" . $comment_id . "';
    " );
    
    echo "Processing comment #".$comment_id."<br>";
}

$db -> close();
?>