How to show popular posts from all blogs on WPMU?

The plugin doesn’t currently have the ability to pull the top posts site wide.

It could potentially get the post IDs network wide (it’s stored in the Top 10 table), but I’m not sure yet of how to pull the details across the various sites.

It’s something I need to do a lot more research on.

Any news on this one? Can you point me in the right direction as to which file/function fetches the post counts from the db? Should be possible to loop it to get tables for all sites…

I’ve not looked at this.

This is the function that fetches the counts:
https://github.com/WebberZone/top-10/blob/master/includes/counter.php#L374

And specifically this piece of mySQL:

$resultscount = $wpdb->get_row( $wpdb->prepare( "SELECT postnumber, cntaccess FROM {$table_name} WHERE postnumber = %d AND blog_id = %d " , $id, $blog_id ) );

The blog ID is also passed which works as an additional limiter. If you removed the blog ID, you would be able to pull all the top posts. So something like this:

$resultscount = $wpdb->get_row( $wpdb->prepare( "SELECT postnumber, cntaccess, blog_id FROM {$table_name} WHERE postnumber = %d " , $id ) );

This would get you the post ID, counts and the blog ID. However, I’m not sure how to pull out the correct posts based on blog ID.