Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- global $wpdb;
- $prefix = 'ZkUy_';
- $limit = 3;
- $sitesquery = '
- SELECT blog_id
- FROM '.$prefix.'blogs';
- $sites = $wpdb->get_results( $sitesquery );
- foreach( $sites as $site ) {
- $posts_table = $prefix.$site->blog_id.'_posts';
- $posts_table = esc_sql( $posts_table );
- $blogs_table = esc_sql( $prefix . 'blogs' );
- $postsquery = '
- SELECT *
- FROM '.$posts_table.'
- WHERE post_type="post"
- AND post_status="publish"
- ORDER BY post_date DESC LIMIT 0, '.$limit;
- $postsquery = $wpdb->prepare($postsquery);
- $siteposts = $wpdb->get_results($postsquery);
- foreach( $siteposts as $post ) : setup_postdata($post); ?>
- <div id="post-<?php the_ID(); ?>" <?php post_class( array('row') ); ?>>
- <div class="span1">
- <div class="timestamp">
- <span class="timestamp_year"><?php the_time('Y'); ?></span>
- <span class="timestamp_bottom">
- <span class="timestamp_month"><?php the_time('M'); ?></span>
- <span class="timestamp_day"><?php the_time('j'); ?></span>
- </span>
- </div>
- <div class="comments_number">
- <?php $commentNo = get_comments_number();
- if( $commentNo == 0 ) { ?>
- <a href="<?php comments_link(); ?>" class="comments_number_link">Discuss!</a>
- <?php } else { ?>
- <a href="<?php comments_link(); ?>" class="comments_number_bubble"><?php echo $commentNo; ?></a>
- <?php } ?>
- </div>
- </div>
- <div class="span7">
- <div class="post_content">
- <h2 class="post_title"><a href="<?php the_permalink(); ?>"><?php the_title(); ?></a></h2>
- <div class="postmeta_top">
- <span class="post_author">by <?php the_author_link(); ?></span> • <span class="post_category">posted in <?php the_category(', '); ?></span>
- </div>
- <div class="post_entry">
- <?php the_post_thumbnail(); ?>
- <?php the_content(); ?>
- </div>
- </div><!-- .post_content -->
- </div>
- </div>
- <?php endforeach; wp_reset_postdata();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement