public function rssAction() { $aRss = array('title' => $this->view->lang(array('en' => 'Tyampuru! Only the best stuff from Internet!'), 'Тямпуру! Все только самое отборное и интересное!'), 'description' => '', 'items' => $this->db->select("SELECT\n p.id,\n p.title,\n p.title_en,\n p.announce AS description,\n p.cdate AS date,\n p.tags,\n p.tags_en\n FROM\n ?_posts p\n WHERE\n p.cdate < NOW()\n ORDER BY\n p.cdate DESC\n LIMIT 50;")); if (!empty($aRss['items'])) { foreach ($aRss['items'] as $iKey => $aVal) { $aRss['items'][$iKey]['description'] = str_replace('<img', '<img style="max-width: 570px;"', $aVal['description']); $aRss['items'][$iKey]['tags'] = Helpers\prepareTags($aVal['tags']); $aRss['items'][$iKey]['tags_en'] = Helpers\prepareTags($aVal['tags_en']); } } $this->view->assign('aRss', $aRss); }
public function apiGetPostAction($iId) { $aData = $this->db->selectRow("SELECT * FROM ?_posts WHERE id >= ?d ORDER BY id ASC LIMIT 1;", $iId); $aTags = Helpers\prepareTags($aData['tags']); $aData['tags'] = ''; foreach ($aTags as $aVal) { $aData['tags'] .= '#' . $aVal[1] . ' '; } if (preg_match('/src\\s*=\\s*"(.+?)"/', $aData['announce'], $aMatches)) { $aData['image'] = $aMatches[1]; } $this->setLayout('ajax_jsonp.php'); $this->view->assign('sRequest', $aData); }