Na}{

File Content: `attachment-cleanup-helper.php`

<?php

namespace Yoast\WP\SEO\Helpers;

use Yoast\WP\Lib\Model;

/**
 * A helper object for the cleanup of attachments.
 */
class Attachment_Cleanup_Helper {

	/**
	 * Removes all indexables for attachments.
	 *
	 * @param bool $suppress_errors Whether to suppress db errors when running the cleanup query.
	 *
	 * @return void
	 */
	public function remove_attachment_indexables( $suppress_errors ) {
		global $wpdb;

		if ( $suppress_errors ) {
			// If migrations haven't been completed successfully the following may give false errors. So suppress them.
			$show_errors       = $wpdb->show_errors;
			$wpdb->show_errors = false;
		}

		$indexable_table = Model::get_table_name( 'Indexable' );

		$delete_query = "DELETE FROM $indexable_table WHERE object_type = 'post' AND object_sub_type = 'attachment'";

		// phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: No relevant caches.
		// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery -- Reason: Most performant way.
		// phpcs:disable WordPress.DB.PreparedSQL.NotPrepared -- Reason: Is it prepared already.
		$wpdb->query( $delete_query );
		// phpcs:enable

		if ( $suppress_errors ) {
			$wpdb->show_errors = $show_errors;
		}
	}

	/**
	 * Cleans all attachment links in the links table from target indexable ids.
	 *
	 * @param bool $suppress_errors Whether to suppress db errors when running the cleanup query.
	 *
	 * @return void
	 */
	public function clean_attachment_links_from_target_indexable_ids( $suppress_errors ) {
		global $wpdb;

		if ( $suppress_errors ) {
			// If migrations haven't been completed successfully the following may give false errors. So suppress them.
			$show_errors       = $wpdb->show_errors;
			$wpdb->show_errors = false;
		}

		$links_table = Model::get_table_name( 'SEO_Links' );

		$query = "UPDATE $links_table SET target_indexable_id = NULL WHERE type = 'image-in'";

		// phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: No relevant caches.
		// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery -- Reason: Most performant way.
		// phpcs:disable WordPress.DB.PreparedSQL.NotPrepared -- Reason: Is it prepared already.
		$wpdb->query( $query );
		// phpcs:enable

		if ( $suppress_errors ) {
			$wpdb->show_errors = $show_errors;
		}
	}
}

Name	Size	Permission
open-graph	---	0755
schema	---	0755
twitter	---	0755
aioseo-helper.php	1266 bytes	0644
asset-helper.php	2572 bytes	0644
attachment-cleanup-helper.php	2294 bytes	0644
author-archive-helper.php	5375 bytes	0644
blocks-helper.php	2378 bytes	0644
capability-helper.php	2116 bytes	0644
crawl-cleanup-helper.php	8293 bytes	0644
curl-helper.php	655 bytes	0644
current-page-helper.php	16018 bytes	0644
date-helper.php	3208 bytes	0644
environment-helper.php	793 bytes	0644
first-time-configuration-notice-helper.php	5284 bytes	0644
home-url-helper.php	770 bytes	0644
image-helper.php	11972 bytes	0644
import-cursor-helper.php	1392 bytes	0644
import-helper.php	716 bytes	0644
indexable-helper.php	9459 bytes	0644
indexable-to-postmeta-helper.php	6913 bytes	0644
indexing-helper.php	12991 bytes	0644
language-helper.php	2716 bytes	0644
meta-helper.php	2982 bytes	0644
notification-helper.php	1982 bytes	0644
options-helper.php	4402 bytes	0644
pagination-helper.php	5815 bytes	0644
permalink-helper.php	1286 bytes	0644
post-helper.php	5553 bytes	0644
post-type-helper.php	7349 bytes	0644
primary-term-helper.php	1398 bytes	0644
product-helper.php	1103 bytes	0644
redirect-helper.php	1764 bytes	0644
require-file-helper.php	326 bytes	0644
robots-helper.php	1777 bytes	0644
robots-txt-helper.php	2722 bytes	0644
sanitization-helper.php	1056 bytes	0644
score-icon-helper.php	2846 bytes	0644
short-link-helper.php	3607 bytes	0644
site-helper.php	566 bytes	0644
social-profiles-helper.php	10990 bytes	0644
string-helper.php	1218 bytes	0644
taxonomy-helper.php	5100 bytes	0644
url-helper.php	8357 bytes	0644
user-helper.php	4026 bytes	0644
wincher-helper.php	2569 bytes	0644
woocommerce-helper.php	1312 bytes	0644
wordpress-helper.php	512 bytes	0644
wpdb-helper.php	937 bytes	0644

File Content: attachment-cleanup-helper.php

File Content: `attachment-cleanup-helper.php`