function getBlogMemberships($pPostContentId)
{
global $gBitSystem;
$ret = NULL;
if (@$this->verifyId($pPostContentId)) {
$bindVars = array((int) $pPostContentId);
$query = "SELECT b.`content_id` AS hash_key, bpm.*, b.*, lc.*\n\t\t\t\tFROM `" . BIT_DB_PREFIX . "blogs_posts_map` bpm\n\t\t\t\tINNER JOIN\t\t`" . BIT_DB_PREFIX . "blogs`\t\t\t\t b ON b.`content_id` = bpm.`blog_content_id`\n\t\t\t\tINNER JOIN\t\t`" . BIT_DB_PREFIX . "liberty_content`\t\tlc ON lc.`content_id` = b.`content_id`\n\t\t\t\tWHERE bpm.post_content_id = ?";
if ($ret = $this->mDb->getAssoc($query, $bindVars)) {
foreach (array_keys($ret) as $blogContentId) {
$ret[$blogContentId]['blog_url'] = BitBlog::getDisplayUrlFromHash($ret[$blogContentId]['blog_id']);
}
}
} else {
$this->mErrors['post_id'] = "Invalid post id.";
}
return $ret;
}
