/** * Gets last news * * @access public * @return array Result */ public function getLast() { $query = 'SELECT distinct(kla_posts.id), title, content, date, author, name as photo, post_id, description FROM kla_posts LEFT JOIN kla_photos ON kla_posts.id = kla_photos.post_id ORDER BY id DESC LIMIT 2'; $result = $this->db->fetchAll($query); return !$result ? array() : $result; }
/** * Gets all events * * @access public * @return array Result */ public function getAll() { $query = 'SELECT kla_events.id, kla_events.name, kla_events.date, kla_events.price, kla_events.info, kla_places.name as place, kla_places.name as meeting, kla_types.name as type FROM kla_events LEFT JOIN kla_places ON kla_places.id = kla_events.place OR kla_places.id = kla_events.meeting JOIN kla_types ON kla_types.id = kla_events.type_id ORDER BY kla_events.id;'; $result = $this->db->fetchAll($query); return !$result ? array() : $result; }
/** * Gets all images. * * @access public * @return array Result */ public function getAllImages() { $query = ' SELECT images.id, images.name, images.title FROM images ORDER BY images.date DESC; '; $result = $this->db->fetchAll($query); return !$result ? array() : $result; }
/** * Gets all albums. * * @access public * @return array Result */ public function getAll() { $query = ' SELECT comments.id, comments.comment, comments.user_id, users.login FROM comments INNER JOIN users ON comments.user_id=users.id ORDER BY comments.data DESC; '; $result = $this->db->fetchAll($query); return !$result ? array() : $result; }