$rss = "<?xml version=\"1.0\" encoding=\"" . $PMF_LANG["metaCharset"] . "\" standalone=\"yes\" ?>\n<rss version=\"2.0\">\n<channel>\n"; $rss .= "<title>" . htmlspecialchars($PMF_CONF["title"]) . " - " . htmlspecialchars($PMF_LANG["msgTopTen"]) . "</title>\n"; $rss .= "<description>" . htmlspecialchars($PMF_CONF["metaDescription"]) . "</description>\n"; $rss .= "<link>http" . (isset($_SERVER['HTTPS']) ? 's' : '') . "://" . $_SERVER["HTTP_HOST"] . str_replace("/feed/topten/rss.php", "", $_SERVER["PHP_SELF"]) . "</link>"; if ($db->num_rows($result) > 0) { $i = 1; $counter = 0; $oldId = 0; while (($row = $db->fetch_object($result)) && $counter < 10) { $counter++; if ($oldId != $row->id) { $rss .= "\t<item>\n"; $rss .= "\t\t<title><![CDATA[" . makeShorterText($row->thema, 8) . " (" . $row->visits . " " . $PMF_LANG["msgViews"] . ")]]></title>\n"; $rss .= "\t\t<description><![CDATA[[" . $i . ".] " . $row->thema . " (" . $row->visits . " " . $PMF_LANG["msgViews"] . ")]]></description>\n"; $rss .= "\t\t<link>http" . (isset($_SERVER['HTTPS']) ? 's' : '') . "://" . $_SERVER["HTTP_HOST"] . str_replace("feed/topten/rss.php", "index.php", $_SERVER["PHP_SELF"]) . "?action=artikel&cat=" . $row->category_id . "&id=" . $row->id . "&artlang=" . $row->lang . "</link>\n"; $rss .= "\t\t<!-- The real FAQ publication date -->\n"; // $$row->datum is a phpMyFAQ date $rss .= "\t\t<!-- " . makeRFC822Date($row->datum) . " -->\n"; // $row->last_visit is a mktime timpestamp date $rss .= "\t\t<pubDate>" . makeRFC822Date($row->last_visit, false) . "</pubDate>\n"; $rss .= "\t</item>\n"; $i++; } $oldId = $row->id; } } $rss .= "</channel>\n</rss>"; header("Content-Type: text/xml"); header("Content-Length: " . strlen($rss)); print $rss; $db->dbclose();
PMF_Init::cleanRequest(); /* read configuration, include classes and functions */ require_once PMF_ROOT_DIR . "/inc/data.php"; require_once PMF_ROOT_DIR . "/inc/db.php"; define("SQLPREFIX", $DB["prefix"]); $db = db::db_select($DB["type"]); $db->connect($DB["server"], $DB["user"], $DB["password"], $DB["db"]); require_once PMF_ROOT_DIR . "/inc/config.php"; require_once PMF_ROOT_DIR . "/inc/constants.php"; require_once PMF_ROOT_DIR . "/inc/category.php"; require_once PMF_ROOT_DIR . "/lang/" . $PMF_CONF["language"]; $result = $db->query("SELECT id, datum, header, artikel, link, linktitel, target FROM " . SQLPREFIX . "faqnews ORDER BY datum desc"); $rss = "<?xml version=\"1.0\" encoding=\"" . $PMF_LANG["metaCharset"] . "\" standalone=\"yes\" ?>\n<rss version=\"2.0\">\n<channel>\n"; $rss .= "<title>" . htmlspecialchars($PMF_CONF["title"]) . " - " . htmlspecialchars($PMF_LANG['msgNews']) . "</title>\n"; $rss .= "<description>" . htmlspecialchars($PMF_CONF["metaDescription"]) . "</description>\n"; $rss .= "<link>http" . (isset($_SERVER['HTTPS']) ? 's' : '') . "://" . $_SERVER["HTTP_HOST"] . str_replace("/feed/news/rss.php", "", $_SERVER["PHP_SELF"]) . "</link>"; if ($db->num_rows($result) > 0) { while ($row = $db->fetch_object($result)) { $rss .= "\t<item>\n"; $rss .= "\t\t<title><![CDATA[" . $row->header . "]]></title>\n"; $rss .= "\t\t<description><![CDATA[" . $row->artikel . "]]></description>\n"; $rss .= "\t\t<link>http" . (isset($_SERVER['HTTPS']) ? 's' : '') . "://" . $_SERVER["HTTP_HOST"] . str_replace("/feed/news/rss.php", "", $_SERVER["PHP_SELF"]) . "#news_" . $row->id . "</link>\n"; $rss .= "\t\t<pubDate>" . makeRFC822Date($row->datum) . "</pubDate>\n"; $rss .= "\t</item>\n"; } } $rss .= "</channel>\n</rss>"; header("Content-Type: text/xml"); header("Content-Length: " . strlen($rss)); print $rss; $db->dbclose();
require_once PMF_ROOT_DIR . "/lang/" . $PMF_CONF["language"]; // Get the open questions result set with a time descedant order (the first is the last entered) $query = "SELECT id, ask_username, ask_usermail, ask_rubrik, ask_content, ask_date FROM " . SQLPREFIX . "faqfragen ORDER BY ask_date DESC"; $result = $db->query($query); $rss = "<?xml version=\"1.0\" encoding=\"" . $PMF_LANG["metaCharset"] . "\" standalone=\"yes\" ?>\n<rss version=\"2.0\">\n<channel>\n"; $rss .= "<title>" . htmlspecialchars($PMF_CONF["title"]) . " - " . htmlspecialchars($PMF_LANG['msgOpenQuestions']) . "</title>\n"; $rss .= "<description>" . htmlspecialchars($PMF_CONF["metaDescription"]) . "</description>\n"; $rss .= "<link>http" . (isset($_SERVER['HTTPS']) ? 's' : '') . "://" . $_SERVER["HTTP_HOST"] . str_replace("/feed/openquestions/rss.php", "", $_SERVER["PHP_SELF"]) . "</link>"; if ($num = $db->num_rows($result) > 0) { $counter = 0; while (($row = $db->fetch_object($result)) && $counter < PMF_RSS_OPENQUESTIONS_MAX) { $counter++; $rss .= "\t<item>\n"; // Get the content $content = $row->ask_content; $rss .= "\t\t<title><![CDATA[" . makeShorterText($row->ask_content, 8) . " (" . $row->ask_username . ")]]></title>\n"; $rss .= "\t\t<description><![CDATA[" . $content . "]]></description>\n"; // Let the PMF administrator manually choose between (1) (default) and (2) // 1. This link below goes to the "Open questions page" $rss .= "\t\t<link>http" . (isset($_SERVER['HTTPS']) ? 's' : '') . "://" . $_SERVER["HTTP_HOST"] . str_replace("feed/openquestions/rss.php", "index.php", $_SERVER["PHP_SELF"]) . "?action=open#openq_" . $row->id . "</link>\n"; // 2. This link below is a shortcut for a fast reply ("Add content" page within the context of the current question) //$rss .= "\t\t<link><![CDATA[http".(isset($_SERVER['HTTPS']) ? 's' : '')."://".$_SERVER["HTTP_HOST"].str_replace("feed/openquestions/rss.php", "index.php", $_SERVER["PHP_SELF"])."?action=add&question=".rawurlencode($content)."&cat=".$row->ask_rubrik."]]></link>\n"; $rss .= "\t\t<pubDate>" . makeRFC822Date($row->ask_date) . "</pubDate>\n"; $rss .= "\t</item>\n"; } } $rss .= "</channel>\n</rss>"; header("Content-Type: text/xml"); header("Content-Length: " . strlen($rss)); print $rss; $db->dbclose();