thumbnails_updated)
); ?>
get_col("
SELECT ID FROM {$wpdb->posts}
WHERE post_type = 'post' AND post_status = 'publish'
");
if (empty($post_ids)) {
$this->error_message = __('No published posts found to randomize.', '1platform-content-ai');
return;
}
foreach ($post_ids as $post_id) {
$days_ago = wp_rand(0, 365);
$hours = wp_rand(0, 23);
$minutes = wp_rand(0, 59);
$seconds = wp_rand(0, 59);
$timestamp = strtotime("-{$days_ago} days");
$timestamp = mktime($hours, $minutes, $seconds, (int) gmdate('n', $timestamp), (int) gmdate('j', $timestamp), (int) gmdate('Y', $timestamp));
$local_date = wp_date('Y-m-d H:i:s', $timestamp);
$gmt_date = get_gmt_from_date($local_date);
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
$wpdb->update(
$wpdb->posts,
[
'post_date' => $local_date,
'post_date_gmt' => $gmt_date,
'post_modified' => $local_date,
'post_modified_gmt' => $gmt_date,
],
['ID' => $post_id],
['%s', '%s', '%s', '%s'],
['%d']
);
clean_post_cache((int) $post_id);
}
$this->dates_randomized = count($post_ids);
}
private function update_all_post_thumbnails(): void {
global $wpdb;
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
$post_ids = $wpdb->get_col("
SELECT ID FROM {$wpdb->posts}
WHERE post_type = 'post' AND post_status = 'publish'
");
if (empty($post_ids)) {
$this->error_message = __('No published posts found to update.', '1platform-content-ai');
return;
}
foreach ($post_ids as $post_id) {
if ($this->set_random_image_as_thumbnail((int) $post_id)) {
$this->thumbnails_updated++;
}
}
}
private function set_random_image_as_thumbnail(int $post_id): bool {
$content = get_post_field('post_content', $post_id);
if (empty($content)) {
return false;
}
preg_match_all('/