Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.08 KB | None | 0 0
  1. public static function rp4wp_get_related_posts_sql($sql, $post_id, $post_type) {
  2.     global $wpdb;
  3.     if ('post' !== $post_type) {
  4.       return $sql;
  5.     }
  6.     $category_ids = [];
  7.     $category_slugs = ['allgemein', 'ausstellung', 'beruf', 'blaulicht', 'brauchtum', 'bremen', 'bremerhaven', 'deichbrand', 'der-norden', 'eisbaeren-bremerhaven', 'europameisterschaft-2016', 'fernsehen', 'fischtown-pinguins', 'pinguins-app-premium-feed', 'pinguins-app-premium-feed-gallery', 'pinguins-app-premium-feed-only'];
  8.     foreach ($category_slugs as $slug) {
  9.       $category_ids[] = get_category_by_slug($slug)->term_id;
  10.     }
  11.     $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 )", " 16 ");
  12.     return str_ireplace('WHERE 1=1', $sql_replace, $sql);
  13.   }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement