|
Server : Apache System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64 User : rainic ( 1014) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/stando/www/wp-content/plugins/wordpress-seo-premium/admin/links/ |
Upload File : |
<?php
/**
* WPSEO plugin file.
*
* @package WPSEO\Admin\Links
*/
/**
* Database helper class.
*/
class WPSEO_Link_Query {
/**
* Determine if there are any unprocessed public posts.
*
* @param array $post_types List of post types to check with.
*
* @return bool True if unprocessed posts are found, false if none are found.
*/
public static function has_unprocessed_posts( array $post_types ) {
global $wpdb;
if ( empty( $post_types ) ) {
return false;
}
$post_types = self::format_post_types( $post_types );
$count_table = self::get_count_table_name();
// Get any object which has not got the processed meta key.
$query = '
SELECT ID
FROM ' . $wpdb->posts . ' AS posts
LEFT JOIN ' . $count_table . ' AS yoast_meta
ON yoast_meta.object_id = posts.ID
WHERE posts.post_status = "publish"
AND posts.post_type IN ( ' . $post_types . ' )
AND yoast_meta.internal_link_count IS NULL
LIMIT 1';
// If anything is found, we have unprocessed posts.
$results = $wpdb->get_var( $query );
return ! empty( $results );
}
/**
* Filter out posts that have not been processed yet.
*
* @param array $post_ids Post IDs to filter.
*
* @return array
*/
public static function filter_unprocessed_posts( array $post_ids ) {
global $wpdb;
$post_ids = array_filter( $post_ids );
if ( empty( $post_ids ) || $post_ids === [] ) {
return $post_ids;
}
$count_table = self::get_count_table_name();
$query = '
SELECT object_id
FROM ' . $count_table . '
WHERE object_id IN ( ' . implode( ',', $post_ids ) . ' )
';
$results = $wpdb->get_results( $query, ARRAY_A );
return array_map( 'intval', wp_list_pluck( $results, 'object_id' ) );
}
/**
* Returns a limited set of unindexed posts.
*
* @param array $post_types The post type.
* @param int $limit The limit for the resultset.
*
* @return array|null|object The set of unindexed posts.
*/
public static function get_unprocessed_posts( array $post_types, $limit = 5 ) {
global $wpdb;
$count_table = self::get_count_table_name();
$post_types = self::format_post_types( $post_types );
// @codingStandardsIgnoreStart
$query = 'SELECT posts.ID, posts.post_content
FROM ' . $wpdb->posts . ' AS posts
LEFT JOIN ' . $count_table . ' AS yoast_meta
ON yoast_meta.object_id = posts.ID
WHERE posts.post_status = "publish"
AND posts.post_type IN ( ' . $post_types . ' )
AND yoast_meta.internal_link_count IS NULL
LIMIT %d
';
// @codingStandardsIgnoreEnd
return $wpdb->get_results(
$wpdb->prepare( $query, $limit )
);
}
/**
* Returns the total amount of unindexed posts for given post type.
*
* @param array $post_types The post types.
*
* @return int The total of unindexed posts.
*/
public static function get_unprocessed_count( array $post_types ) {
global $wpdb;
if ( empty( $post_types ) ) {
return 0;
}
$count_table = self::get_count_table_name();
$post_types = self::format_post_types( $post_types );
// @codingStandardsIgnoreStart
$query = '
SELECT COUNT( posts.ID )
FROM ' . $wpdb->posts . ' AS posts
LEFT JOIN ' . $count_table . ' AS yoast_meta
ON yoast_meta.object_id = posts.ID
WHERE posts.post_status = "publish"
AND posts.post_type IN ( ' . $post_types . ' )
AND yoast_meta.internal_link_count IS NULL';
// @codingStandardsIgnoreEnd
return (int) $wpdb->get_var( $query );
}
/**
* Returns the table name where the counts are stored.
*
* @return string
*/
protected static function get_count_table_name() {
$storage = new WPSEO_Meta_Storage();
return $storage->get_table_name();
}
/**
* Formats an array with post types as an SQL string.
*
* @param array $post_types The post types to format.
*
* @return string Post types formatted for use in SQL statement.
*/
protected static function format_post_types( array $post_types ) {
$sanitized_post_types = array_map( 'esc_sql', $post_types );
$post_types = sprintf( '"%s"', implode( '", "', $sanitized_post_types ) );
return $post_types;
}
}