/** * Fetch the list of tags for a list of items * * @param array $ids The ids of the items to grab. * @return array */ public static function getForTags(array $ids) { // fetch items $items = (array) FrontendModel::getDB()->getRecords('SELECT i.title, m.url FROM blog_posts AS i INNER JOIN meta AS m ON m.id = i.meta_id WHERE i.status = ? AND i.hidden = ? AND i.id IN (' . implode(',', $ids) . ') ORDER BY i.publish_on DESC', array('active', 'N')); // has items if (!empty($items)) { // init var $link = FrontendNavigation::getURLForBlock('blog', 'detail'); $folders = FrontendModel::getThumbnailFolders(FRONTEND_FILES_PATH . '/blog/images', true); // reset url foreach ($items as &$row) { $row['full_url'] = $link . '/' . $row['url'] . '?gn=' . str_pad($row['id'], 3, '0', STR_PAD_LEFT); // image? if (isset($row['image'])) { foreach ($folders as $folder) { $row['image_' . $folder['dirname']] = $folder['url'] . '/' . $folder['dirname'] . '/' . $row['image']; } } } } // return return $items; }