public function getImageByGalleryId($id, $pagination = NULL)
{
$sql = 'SELECT SQL_CALC_FOUND_ROWS g.image_id,g.cat,g.id as imgid,g.image_title,g.image_description,g.visits, m.url, m.id, m.url_thumb
FROM `[prefix]_gallery_imgs` AS g
LEFT JOIN `[prefix]_media` m ON g.image_id = m.id
WHERE g.cat = ' . $id . ' ORDER BY g.id DESC
LIMIT ' . implode(',', $pagination->getLimit());
$imageArray = $this->db()->queryArray($sql);
$pagination->setRows($this->db()->querycell('SELECT FOUND_ROWS()'));
$entry = array();
foreach ($imageArray as $entries) {
$entryModel = new ImageModel();
$entryModel->setImageUrl($entries['url']);
$entryModel->setImageThumb($entries['url_thumb']);
$entryModel->setId($entries['imgid']);
$entryModel->setImageTitle($entries['image_title']);
$entryModel->setImageDesc($entries['image_description']);
$entryModel->setVisits($entries['visits']);
$entryModel->setCat($entries['cat']);
$entry[] = $entryModel;
}
return $entry;
}
