function get_blogs_linking_blog($blog_id, $limit = 10) { $post_ids = get_posts_linking_to(false, $blog_id); if (!$post_id) { return array(); } $query = "SELECT DISTINCT blog_id, blogs.title AS blog_name FROM posts, blogs WHERE posts.blog_id = blogs.blog_id AND post_id IN (" . implode(",", $post_ids) . ")"; if ($limit) { $query .= " LIMIT {$limit}"; } $results = mysql_query($query); $blogs = array(); $mapping = array(); while ($row = mysql_fetch_assoc($results)) { $blogs[$row['blog_id']] = $row['count']; $mapping[$row['blog_id']] = $row['blog_name']; } return array("blogs" => $blogs, "mapping" => $mapping); }
# category : category you want posts from # term : posts containing term x # any filters? $filters = array(); $output_available = 1; # basics... $filters['limit'] = $posts_return_limit; if ($limit && $limit < $max_posts_return_limit) { $filters['limit'] = $limit; } if ($start && is_numeric($start)) { $filters['skip'] = $start; } # posts citing another post? if ($citing_url) { $citing_posts = get_posts_linking_to(false, false, $citing_url); if (sizeof($citing_posts) >= 1) { $filters['post_id'] = $citing_posts; } else { $filters['post_id'] = array(); $output_available = 0; } } # posts citing a paper? if ($citing_paper) { $citing_posts = get_posts_for_paper($citing_paper, true); if (sizeof($citing_posts) >= 1) { $filters['post_id'] = $citing_posts; } else { $filters['post_id'] = array(); $output_available = 0;
foreach ($posts as $post) { print_post($post); } print "</div>"; } $posts = get_posts("cited", array("blog_id" => $safe_blog_id, "limit" => 3)); if ($posts) { print "<div class='blogbox_postboxes'>"; print "<h3>Most popular posts</h3>"; foreach ($posts as $post) { print_post($post); } print "</div>"; } $posts = array(); $post_ids = get_posts_linking_to(false, $safe_blog_id); if ($post_ids) { print "<div class='blogbox_postboxes'>"; print "<h3>Latest posts linking here</h3>"; $posts = get_posts("published_on", array("post_id" => $post_ids, "limit" => 3)); foreach ($posts as $post) { print_post($post); } print "</div>"; } } else { print_error("No blog specified", "Sorry, I'm not sure which blog you're looking for."); } ?> </div> <?php
print "</div>"; print "</div>"; print "</div>"; print "</div>"; } ?> <div class='content <?php if (!sizeof($terms)) { print "fullwidth"; } ?> '> <?php $posts = get_posts("added_on", array("post_id" => array($safe_post_id))); foreach ($posts as $post) { print_post($post, array("magnify" => true, "image" => true, "fulltext" => $config['use_post_fulltext'])); } $post_ids = get_posts_linking_to($safe_post_id, false); print "<div class='postbox_postboxes'>"; if ($post_ids) { print "<h3>Posts linking to this one</h3>"; $posts = get_posts("added_on", array("post_id" => $post_ids)); foreach ($posts as $post) { print_post($post, array("image" => true)); } } print "</div>"; ?> </div> <?php include "footer.php";