/** * Returns article model found by the key. * * @param string $id * @param string $locale * @return ArticleModel|null */ public function getArticleByIdLocale($id, $locale = '') { $sql = 'SELECT * FROM [prefix]_articles as p INNER JOIN [prefix]_articles_content as pc ON p.id = pc.article_id WHERE p.`id` = "' . (int) $id . '" AND pc.locale = "' . $this->db()->escape($locale) . '"'; $articleRow = $this->db()->queryRow($sql); if (empty($articleRow)) { return null; } $articleModel = new ArticleModel(); $articleModel->setId($articleRow['id']); $articleModel->setCatId($articleRow['cat_id']); $articleModel->setAuthorId($articleRow['author_id']); $articleModel->setVisits($articleRow['visits']); $articleModel->setDescription($articleRow['description']); $articleModel->setTitle($articleRow['title']); $articleModel->setContent($articleRow['content']); $articleModel->setLocale($articleRow['locale']); $articleModel->setPerma($articleRow['perma']); $articleModel->setDateCreated($articleRow['date_created']); $articleModel->setArticleImage($articleRow['article_img']); $articleModel->setArticleImageSource($articleRow['article_img_source']); return $articleModel; }