Posted By

chasecrawford on 06/06/12

Tagged

wordpress

Versions (?)

Last Edited at 06/06/12 03:08am

Statistics

Viewed 1574 times

Favorited by 0 user(s)

Related snippets

Recent Posts from All Sites (WordPress Multisite)

/ Published in: PHP

A function to query the 10 most recent posts on a multisite WordPress installation

Highlighted TextExpand

function recent_mu_posts( $howMany = 10 ) {

global $wpdb;
  global $table_prefix;

// get an array of the table names that our posts will be in
  // we do this by first getting all of our blog ids and then forming the name of the 
  // table and putting it into an array
  $rows = $wpdb->get_results( "SELECT blog_id from $wpdb->blogs WHERE
    public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0';" );

if ( $rows ) :

$blogPostTableNames = array();
    foreach ( $rows as $row ) :
    
      $blogPostTableNames[$row->blog_id] = $wpdb->get_blog_prefix( $row->blog_id ) . 'posts';

endforeach;
    # print_r($blogPostTableNames); # debugging code

// now we need to do a query to get all the posts from all our blogs
    // with limits applied
    if ( count( $blogPostTableNames ) > 0 ) :

$query = '';
      $i = 0;

foreach ( $blogPostTableNames as $blogId => $tableName ) :

if ( $i > 0 ) :
        $query.= ' UNION ';
        endif;

$query.= " (SELECT ID, post_date, $blogId as `blog_id` FROM $tableName WHERE post_status = 'publish' AND post_type = 'post')";
        $i++;

endforeach;

$query.= " ORDER BY post_date DESC LIMIT 0,$howMany;";
      # echo $query; # debugging code
      $rows = $wpdb->get_results( $query );

// now we need to get each of our posts into an array and return them
      if ( $rows ) :

$posts = array();
        foreach ( $rows as $row ) :
        $posts[] = get_blog_post( $row->blog_id, $row->ID );
        endforeach;
        # echo "<pre>"; print_r($posts); echo "</pre>"; exit; # debugging code
        return $posts;

else:

return "Error: No Posts found";

endif;

else:

return "Error: Could not find blogs in the database";

endif;
  
  else:

return "Error: Could not find blogs";
    
  endif;
}

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.