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