1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
foreach($blogs as $blogid)
{
$blog = $wpdb->get_row("SELECT `domain` FROM wp_blogs
WHERE blog_id = ".$blogid);
foreach($blog as $blog1)
{
if($blogid == 1)
{
next($blog);
}
else
{
echo '<li><a href="http://'.$blog->domain.'"><b>'.$blog->domain.'</b></a></li><ul style="margin:0; padding:0;">';
$zen = $wpdb->get_results("SELECT DISTINCT post_title, post_date
FROM wp_".$blogid."_posts where post_type ='post'
group by post_title order by post_date_gmt desc LIMIT 4",ARRAY_A);
foreach($zen as $zenb)
{
echo "<li style='margin: 0 0 0 8px;'>".$zenb['post_title'].$zen->post_date."</li>";
}
echo "</ul>";
}
}
} |
Partager