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";
