Thanks.
I found this and it works.
/*
Plugin Name: WordPress MU Recent Posts
Plugin URI: http://atypicalhomeschool.net/wordpress-plugins/
Description: Retrieves a list of the most recent posts in a WordPress MU installation. Based on (Andrea - fill this in)
Version: 0.3
Author: Ron Rennick
Author URI: http://atypicalhomeschool.net/
*/
function ah_recent_posts_mu($how_many = 10) {
global $wpdb;
$counter = 0;
// get a list of blogs in order of most recent update
$blogs = $wpdb->get_col("SELECT blog_id FROM $wpdb->blogs WHERE
last_updated >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
ORDER BY last_updated DESC");
if ($blogs) {
foreach ($blogs as $blog) {
// we need _posts and _options tables for this to work
$blogOptionsTable = "wp_".$blog."_options";
$blogPostsTable = "wp_".$blog."_posts";
$options = $wpdb->get_results("SELECT option_value FROM
$blogOptionsTable WHERE option_name IN ('siteurl','blogname')
ORDER BY option_name DESC");
// we fetch the title and link for the latest post
$thispost = $wpdb->get_results("SELECT post_title, guid
FROM $blogPostsTable WHERE post_status = 'publish'
AND post_type = 'post' AND post_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
ORDER BY id DESC LIMIT 0,1");
// if it is found put it to the output
if($thispost) {
echo '<li class="page_item">guid
.'">'.$thispost[0]->post_title.' by <a href="'
.$options[0]->option_value.'">'
.$options[1]->option_value."
";
$counter++;
}
// don't go over the limit
if($counter >= $how_many) {
break;
}
}
}
}
another question,is wp-includes/wpmu-functions.php a right place to put some functions you designed for your MU? or wp-content/themes/exampleTheme/functions.php?