Support Forum

/*
    For migrating from Simple:Press (WordPress forum plugin) 4.5 to 5.1.3 and cleaning up link shortening
    In 4.5, links were shortened on save
    In 5.1.3, links are shortened on display

    Run this script in the root of your WordPress directory: php clean_up_links.php

    Source: https://simple-press.com/suppo.....5-to-5-1-3
*/

include 'wp-load.php';

$postCount = $wpdb->get_var( 'SELECT COUNT(*) FROM wp_sfposts' );
$limit = 100;

print "\n Total post count: $postCount";
print "\n Looping through $limit at a time";
print "\n";

for( $offset = 0; $offset < $postCount; $offset += $limit )
{
    $posts = $wpdb->get_results( "SELECT post_id, post_content FROM wp_sfposts LIMIT $limit, $offset ORDER BY post_id ASC" );
    foreach( $posts as $post )
    {
        /*
            Matches would be:
            0 = The entire string
            1 = The link in the <a> tag
            2 = The rest of the parameters in the <a> tag (nofollow, target, etc.)
            3 = The part after the 5 periods

            So then we want to replace 0 with 1 for each result

            We are assuming that the links have 5 consecutive periods
        */

        $postContent = $post->post_content;
        $postID = $post->post_id;

        preg_match_all( "/<a href=\"(.*?)\"(.*?)\.\.\.\.\.(.*?)<\/a>/is", $postContent, $linkMatches );

        if( !empty( $linkMatches[0] ) )
        {
            foreach( $linkMatches[0] as $index => $stringMatch )
            {
                $postContent = str_replace( $stringMatch, $linkMatches[1][$index], $postContent );
                $wpdb->query( $wpdb->prepare( "UPDATE wp_sfposts SET post_content = %s WHERE post_id = %d LIMIT 1;", $postContent, $postID ) );
            }
        }
    }

    // Basic feedback to the user
    print '+';
}

?>