/**
* Get the most popular blog posts in a blog from DB
* @param num the number of blog posts to get
* @return array with blog post objects
*/
private function getPopularBlogPostsDB($num) {
$sql = 'SELECT * FROM `blog_post` WHERE ';
$params = array();
if ($this->course_id != 0) {//course blog
$sql .= '`course_id` = ?d ORDER BY `views` DESC LIMIT ?d';
$params[] = $this->course_id;
} else {//user blog
$sql .= '`course_id` = ?d AND `user_id` = ?d ORDER BY `views` DESC LIMIT ?d';
$params[] = 0;
$params[] = $this->user_id;
}
$params[] = $num;
$result = Database::get()->queryArray($sql, $params);
$ret = array();
if (is_array($result)) {
$ret = BlogPost::loadFromPDOArr($result);
}
return $ret;
}