null); $catlimit = ""; } $feedtitle = $_lang['rss.recentarticles']; break; // nejnovejsi temata case 5: $query = DB::query("SELECT title FROM `" . _mysql_prefix . "-root` WHERE type=8" . $public . " AND id=" . $id); $feedtitle = $_lang['rss.recenttopics']; $typelimit = " AND type=5 AND xhome=-1"; break; // nejnovejsi odpovedi na tema case 6: $query = DB::query("SELECT subject FROM `" . _mysql_prefix . "-posts` WHERE type=5 AND id=" . $id . " AND (" . _loginindicator . "=1 OR (SELECT public FROM `" . _mysql_prefix . "-root` WHERE id=`" . _mysql_prefix . "-posts`.id)=1)"); $feedtitle = $_lang['rss.recentanswers']; $typelimit = "type=5 AND xhome=" . $id; $homelimit = ""; $pagetitle_column = "subject"; break; // nelegalni typ default: exit; break; } // nacteni polozek if ($custom_cond and ($donottestsource or DB::size($query) != 0)) { $feeditems = array(); if (!$donottestsource) { $query = DB::row($query); } $pagetitle = $query[$pagetitle_column]; switch ($type) { // komentare/prispevky/temata case 1: case 2: case 3: case 5: case 6: $items = DB::query("SELECT * FROM `" . _mysql_prefix . "-posts` WHERE " . $homelimit . $typelimit . " ORDER BY id DESC LIMIT " . _rsslimit); $titlebonus = ""; while ($item = DB::row($items)) { // nacteni jmena autora if ($item['author'] != -1) { $author = _linkUser($item['author'], null, true, true); } else { $author = $item['guest']; } // odkaz na stranku switch ($item['type']) { case 1: case 3: $homelink = _linkRoot($item['home']); break; case 2: $homelink = _linkArticle($item['home']); break; case 5: if ($item['xhome'] == -1) { $homelink = "index.php?m=topic&id=" . $item['id']; } else { $homelink = "index.php?m=topic&id=" . $item['xhome']; } break; } // ulozeni zaznamu $feeditems[] = array($author . ": " . $item['subject'], $homelink . "#posts", _cutStr(strip_tags(_parsePost($item['text'])), 255, false), $item['time']); } break; // nejnovejsi clanky case 4: $items = DB::query("SELECT art.id,art.time,art.confirmed,art.public,art.home1,art.home2,art.home3,art.title,art.title_seo,art.perex,cat.title_seo AS cat_title_seo FROM `" . _mysql_prefix . "-articles` AS art JOIN `" . _mysql_prefix . "-root` AS cat ON(cat.id=art.home1) WHERE " . _sqlArticleFilter(true) . $catlimit . " ORDER BY art.time DESC LIMIT " . _rsslimit); while ($item = DB::row($items)) { $feeditems[] = array($item['title'], _linkArticle($item['id'], $item['title_seo'], $item['cat_title_seo']), strip_tags($item['perex']), $item['time']); } break; } $continue = true; } /* --- vystup --- */ if ($continue) { header("Content-Type: application/xml; charset=UTF-8"); $maintitle = _title . ' ' . _titleseparator . (($pagetitle != null) ? ' ' . $pagetitle . ' ' . _titleseparator : '') . ' ' . $feedtitle; echo ' ' . $maintitle . ' ' . _url . '/ ' . _description . ' ' . $_lang['main.languagespecification'] . ' ' . $maintitle . ' ' . _url . '/plugins/templates/' . _template . '/images/system/rss-logo.gif ' . _url . '/ 60 60 '; // polozky foreach ($feeditems as $feeditem) { echo ' ' . $feeditem[0] . ' ' . _url . '/' . $feeditem[1] . ' ' . date('r', $feeditem[3]) . ' '; } echo ' '; }