if (!empty($_GET['dcat'])) { $where = 'WHERE `#__category`.`cat_chpu`=\'' . PHP_slashes(htmlspecialchars($_GET['dcat'])) . '\''; } else { $where = ''; } $news = $DB->getAll('SELECT `#__news`.*, `#__category`.`name`, `#__category`.`cat_chpu` FROM `#__news` LEFT JOIN `#__category` ON `#__news`.`cat`=`#__category`.`id` ' . $where . ' ORDER BY `#__news`.`date` DESC LIMIT 10'); if (count($news) == 0) { header("Location: /"); } $config['domen'] = $_SERVER['HTTP_HOST']; $config['site_title'] = $DB->getOne('SELECT `#__setting`.`value` FROM `#__setting` WHERE `#__setting`.`name`=\'site_title\' LIMIT 1'); $rss = new rss('utf-8'); $rss->channel('RSS - ' . $news[0]['name'], 'http://' . $config['domen'], $config['site_title']); $rss->language('ru-RU'); $rss->copyright('Copyright by ' . $config['domen'] . ' ' . date('Y')); $rss->managingEditor('support@' . str_replace('www.', '', $config['domen'])); $rss->category($news[0]['name']); $rss->startRSS(); foreach ($news as $ne) { $rss->itemTitle($ne['title']); $rss->itemLink('http://' . $config['domen'] . '/doc/' . $ne['cat_chpu'] . '/' . $ne['chpu'] . '/'); $rss->itemDescription(strip_tags($ne['text'])); $rss->itemAuthor('support@' . str_replace('www.', '', $config['domen'])); $rss->itemGuid('http://' . $config['domen'] . '/doc/' . $ne['cat_chpu'] . '/' . $ne['chpu'] . '/'); $rss->itemSource($config['site_title'], 'http:/' . $config['domen'] . '/rss/' . $ne['name'] . '/'); $rss->addItem(); $count++; } echo $rss->RSSdone(); exit;
$row = mysql_fetch_assoc($result); $tempCompanyEmail = $row['value']; // Get SystemURL $query = "Select * FROM tblconfiguration where setting='SystemURL' limit 0,1"; $result = mysql_query($query) or die("tblconfiguration: SystemURL not found"); if (mysql_num_rows($result) == 0) { die("tblconfiguration: SystemURL not found"); } $row = mysql_fetch_assoc($result); $tempSystemURL = $row['value']; ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////// $rss = new rss('utf-8'); $rss->channel($tempCompanyName . ' Tickets', $tempSystemURL, $tempCompanyName . ' Tickets'); $rss->language('en-us'); $rss->copyright('Copyright ' . $tempCompanyName); $rss->managingEditor($tempCompanyEmail); $rss->category('CategoryName'); $rss->startRSS(); $query = "Select * FROM tbltickets " . $tempSQL . " order by lastreply desc limit 0," . $constTicketsToDisplay; $result = mysql_query($query) or die("No Tickets Found"); if (mysql_num_rows($result) == 0) { die("No Tickets Found"); } while ($row = mysql_fetch_assoc($result)) { $rss->itemTitle("<![CDATA[" . $row['title'] . "]]>"); $rss->itemLink("<![CDATA[" . $tempSystemURL . "/admin/supporttickets.php?action=viewticket&id=" . $row['id'] . "]]>"); $rss->itemDescription("<![CDATA[" . $row['message'] . "]]>"); $rss->itemAuthor($row['name'] . " " . $row['email']); $rss->addItem(); } echo $rss->RSSdoneVar();
/** * Действие просмотр rss ленты всех постов: */ public function rssAllAction(Application $application, Template $template) { $posts = Blog_BlogPostsModel::GetAllPosts(0, 20, false); if ($posts) { $rss = new rss('utf-8'); $rss->channel('Первый канал - Все', 'http://1chan.ru/', 'Новости имиджборд и не только.'); $rss->language('ru-ru'); $rss->copyright('Все права пренадлежат вам © 2010'); $rss->managingEditor('*****@*****.**'); $rss->category('Все'); $rss->startRSS(); foreach ($posts as $key => $post) { $title = $post['category'] ? TemplateHelper::BlogCategory($post['category'], 'title') . ' — ' . $post['title'] : $post['title']; $rss->itemTitle($title); $rss->itemLink('http://' . TemplateHelper::getSiteUrl() . '/news/res/' . $post['id'] . '/'); $rss->itemDescription($post['link'] ? '<a href="' . $post['link'] . '">' . $post['link'] . '</a><br />' . $post['text'] : $post['text']); $rss->itemAuthor('anonymous'); $rss->itemGuid('http://' . TemplateHelper::getSiteUrl() . '/news/res/' . $post['id'] . '/', true); $rss->itemPubDate(date('D, d M Y H:i:s O', $post['created_at'])); $rss->addItem(); } $result = $rss->RSSdone(); } EventModel::getInstance()->Broadcast('view_rss_all_post'); $template->headerOk(); $template->headerContentType('application/rss+xml', 'UTF-8'); echo $result; return false; }