Skip to content

Instantly share code, notes, and snippets.

@barrykooij
Last active Nov 15, 2015
Embed
What would you like to do?
Exclude RP4WP categories
function rp4wp_exclude_category( $sql, $post_id, $post_type ) {
global $wpdb;
if ( 'post' !== $post_type ) {
return $sql;
}
$sql_replace = sprintf( "
INNER JOIN " . $wpdb->term_relationships . " ON (R.`post_id` = " . $wpdb->term_relationships . ".object_id)
INNER JOIN " . $wpdb->term_taxonomy . " ON (" . $wpdb->term_relationships . ".term_taxonomy_id = " . $wpdb->term_taxonomy . ".term_taxonomy_id)
WHERE 1=1
AND " . $wpdb->term_taxonomy . ".taxonomy = 'category'
AND " . $wpdb->term_taxonomy . ".term_id NOT IN ( %s )
", " 100,200,300 " );
return str_ireplace( 'WHERE 1=1', $sql_replace, $sql );
}
add_filter( 'rp4wp_get_related_posts_sql', 'rp4wp_exclude_category', 11, 3 );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment