public static function get_recent_posts($params = NULL, $conditions = NULL)
{
Logger::log("Enter: function CNContent::get");
$sql = " SELECT * FROM {contents} AS C , {recent_media_track} AS RT WHERE RT.cid=C.content_id AND C.is_active = 1 ";
if ($conditions) {
$sql = $sql . ' AND ' . $conditions;
}
$sort_by = $params['sort_by'] ? $params['sort_by'] : 'C.created';
$direction = $params['direction'] ? $params['direction'] : 'DESC';
$order_by = ' ORDER BY ' . $sort_by . ' ' . $direction;
if (!empty($params['page']) && !empty($params['show']) && empty($params['cnt'])) {
$start = ($params['page'] - 1) * $params['show'];
$limit = ' LIMIT ' . $start . ',' . $params['show'];
} else {
$limit = "";
}
$sql = $sql . $order_by . $limit;
$res = Dal::query($sql);
if (!empty($params['cnt']) && $params['cnt'] == TRUE) {
return $res->numRows();
}
$i = 0;
$content_id = array();
while ($row = $res->fetchRow(DB_FETCHMODE_ASSOC)) {
$content_id[$i] = array('content_id' => $row['content_id'], 'collection_id' => $row['collection_id'], 'title' => $row['title'], 'body' => $row['body'], 'author_id' => $row['author_id'], 'type' => $row['type'], 'changed' => $row['changed'], 'created' => $row['created'], 'is_active' => $row['is_active']);
$i++;
}
$contents = array();
foreach ($content_id as &$_content) {
if (!CNContent::check_content_privacy($_content)) {
// check is content from a private Group
$contents[] = $_content;
}
}
// echo '<pre>'.print_r($cont,1).'</pre>';
Logger::log("Exit: function CNContent::get");
return $contents;
}
