<?php

[0] Fix | Delete

[1] Fix | Delete

namespace ImageOptimization\Classes\Image;

[2] Fix | Delete

[3] Fix | Delete

use WP_Query;

[4] Fix | Delete

[5] Fix | Delete

if ( ! defined( 'ABSPATH' ) ) {

[6] Fix | Delete

exit; // Exit if accessed directly.

[7] Fix | Delete

}

[8] Fix | Delete

[9] Fix | Delete

class Image_DB_Update {

[10] Fix | Delete

public static function update_posts_table_urls( string $old_url, string $new_url ) {

[11] Fix | Delete

$query = new WP_Query( [

[12] Fix | Delete

'post_type' => 'any',

[13] Fix | Delete

'post_status' => 'any',

[14] Fix | Delete

's' => $old_url,

[15] Fix | Delete

'search_columns' => [ 'post_content' ],

[16] Fix | Delete

] );

[17] Fix | Delete

[18] Fix | Delete

if ( ! $query->post_count ) {

[19] Fix | Delete

return;

[20] Fix | Delete

}

[21] Fix | Delete

[22] Fix | Delete

foreach ( $query->posts as $post ) {

[23] Fix | Delete

$new_content = str_replace( $old_url, $new_url, $post->post_content );

[24] Fix | Delete

[25] Fix | Delete

wp_update_post([

[26] Fix | Delete

'ID' => $post->ID,

[27] Fix | Delete

'post_content' => $new_content,

[28] Fix | Delete

]);

[29] Fix | Delete

}

[30] Fix | Delete

}

[31] Fix | Delete

}

[32] Fix | Delete

[33] Fix | Delete