function loadPage($page_id)
{
$objUrl = new FriendlyurlModel();
$pageInfo = $this->load($page_id, 'pages');
if ($pageInfo) {
$pageInfo['url'] = $objUrl->getUrl($pageInfo['url_id']);
$pageInfo['meta'] = $objUrl->getMetaData($pageInfo['url_id']);
}
return $pageInfo;
}
function getPrevArticle($category_id, $timestamp)
{
$sql = "\n\t\tSELECT\n\t\t\t`id`,\n\t\t\t`title`,\n\t\t\t`url_id`\n\t\tFROM\n\t\t\t`blog_articles`\n\t\tWHERE\n\t\t\t`publishDate` < '" . $this->db->makeSafe($timestamp) . "' AND\n\t\t\t`category_id` = " . intval($category_id) . "\n\t\tORDER BY\n\t\t\t`publishDate` DESC\n\t\tLIMIT\n\t\t\t1\n\t\t";
$prevArticle = $this->db->getRow($sql);
if (!empty($prevArticle)) {
$objUrl = new FriendlyurlModel();
$prevArticle['url'] = $objUrl->getUrl($prevArticle['url_id']);
}
return $prevArticle;
}
