From 186649709a15de3b36411ae250d28abb574b1c53 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Mon, 31 Jul 2006 12:35:50 +0100
Subject: [PATCH] add aggregated feed generator

---
 NEWS                       |   1 +
 backend.php                |  34 +++++++++++++++---
 functions.php              |  69 ++++++++++++++++++++++++++++++++++++-
 images/feed-icon-12x12.png | Bin 0 -> 552 bytes
 4 files changed, 99 insertions(+), 5 deletions(-)
 create mode 100644 images/feed-icon-12x12.png

diff --git a/NEWS b/NEWS
index f051034b..fb7fed77 100644
--- a/NEWS
+++ b/NEWS
@@ -2,6 +2,7 @@ v1.2.2	(Aug xx, 2006)
 
 	* Bugfixes
 	* Support for HTTP Digest authentication (via included Snoopy class)
+	* Support for generation of aggregated feeds
 
 v1.2.1	(Jul 17, 2006)
 
diff --git a/backend.php b/backend.php
index ff19595f..107074fb 100644
--- a/backend.php
+++ b/backend.php
@@ -33,11 +33,12 @@
 		print_error_xml(9, $err_msg); die;
 	}
 
-	if ((!$op || $op == "rpc" || $op == "globalUpdateFeeds") && !$_REQUEST["noxml"]) {
+	if ((!$op || $op == "rpc" || $op == "rss" || 
+			$op == "globalUpdateFeeds") && !$_REQUEST["noxml"]) {
 		header("Content-Type: application/xml");
 	}
 
-	if (!$_SESSION["uid"] && $op != "globalUpdateFeeds") {
+	if (!$_SESSION["uid"] && $op != "globalUpdateFeeds" && $op != "rss") {
 
 		if ($op == "rpc") {
 			print_error_xml(6); die;
@@ -805,7 +806,8 @@
 		}
 
 		function print_headline_subtoolbar($link, $feed_site_url, $feed_title, 
-						$bottom = false, $rtl_content = false) {
+			$bottom = false, $rtl_content = false, $feed_id = 0,
+			$is_cat = false) {
 
 			if (!$bottom) {
 				$class = "headlinesSubToolbar";
@@ -861,6 +863,13 @@
 			} else {
 				print $feed_title;
 			}
+
+			print "&nbsp;
+				<a target=\"_new\" 
+					href=\"backend.php?op=rss&id=$feed_id&is_cat=$is_cat\"
+					<img class=\"noborder\" 
+						alt=\"Generated feed\" src=\"images/feed-icon-12x12.png\">
+				</a>";
 				
 			print "</td>";
 			print "</tr></table>";
@@ -870,7 +879,7 @@
 		if (db_num_rows($result) > 0) {
 
 			print_headline_subtoolbar($link, $feed_site_url, $feed_title, false, 
-				$rtl_content);
+				$rtl_content, $feed, $cat_view);
 
 			if (!get_pref($link, 'COMBINED_DISPLAY_MODE')) {
 				print "<table class=\"headlinesList\" id=\"headlinesList\" 
@@ -3647,6 +3656,23 @@
 
 	}
 
+	if ($op == "rss") {
+		$feed = db_escape_string($_GET["id"]);
+		$user = db_escape_string($_GET["user"]);
+		$pass = db_escape_string($_GET["pass"]);
+		$is_cat = $_GET["is_cat"] != false;
+
+		if (!$_SESSION["uid"] && $user && $pass) {
+			authenticate_user($link, $user, $pass);
+		}
+
+		if ($_SESSION["uid"] ||
+			http_authenticate_user($link)) {
+
+				generate_syndicated_feed($link, $feed, $is_cat);
+		}
+	}
+
 	function check_configuration_variables() {
 		if (!defined('SESSION_EXPIRE_TIME')) {
 			return "config: SESSION_EXPIRE_TIME is undefined";
diff --git a/functions.php b/functions.php
index 686cecfe..e77f2d5a 100644
--- a/functions.php
+++ b/functions.php
@@ -948,6 +948,28 @@
 		}
 	}
 
+	function http_authenticate_user($link) {
+
+		if (!$_SERVER["PHP_AUTH_USER"]) {
+
+			header('WWW-Authenticate: Basic realm="Tiny Tiny RSS RSSGen"');
+			header('HTTP/1.0 401 Unauthorized');
+			exit;
+					
+		} else {
+			$auth_result = authenticate_user($link, 
+				$_SERVER["PHP_AUTH_USER"], $_SERVER["PHP_AUTH_PW"]);
+
+			if (!$auth_result) {
+				header('WWW-Authenticate: Basic realm="Tiny Tiny RSS RSSGen"');
+				header('HTTP/1.0 401 Unauthorized');
+				exit;
+			}
+		}
+
+		return true;
+	}
+
 	function authenticate_user($link, $login, $password) {
 
 		if (!SINGLE_USER_MODE) {
@@ -1406,7 +1428,13 @@
 
 	function getCategoryUnread($link, $cat) {
 
-		$result = db_query($link, "SELECT id FROM ttrss_feeds WHERE cat_id = '$cat' 
+		if ($cat != 0) {
+			$cat_query = "cat_id = '$cat'";
+		} else {
+			$cat_query = "cat_id IS NULL";
+		}
+
+		$result = db_query($link, "SELECT id FROM ttrss_feeds WHERE $cat_query 
 				AND owner_uid = " . $_SESSION["uid"]);
 
 		$cat_feeds = array();
@@ -1414,6 +1442,8 @@
 			array_push($cat_feeds, "feed_id = " . $line["id"]);
 		}
 
+		if (count($cat_feeds) == 0) return 0;
+
 		$match_part = implode(" OR ", $cat_feeds);
 
 		$result = db_query($link, "SELECT COUNT(int_id) AS unread 
@@ -2179,4 +2209,41 @@
 			
 	}
 
+	function generate_syndicated_feed($link, $feed, $is_cat) {
+
+		$qfh_ret = queryFeedHeadlines($link, $feed, 
+				30, false, $is_cat, false, false, false);
+
+		$result = $qfh_ret[0];
+		$feed_title = $qfh_ret[1];
+		$feed_site_url = $qfh_ret[2];
+		$last_error = $qfh_ret[3];
+
+		print "<rss version=\"2.0\">
+			<channel>
+			<title>$feed_title</title>
+			<link>$feed_site_url</link>
+			<generator>Tiny Tiny RSS v".VERSION."</generator>";
+
+		while ($line = db_fetch_assoc($result)) {
+			print "<item>";
+			print "<link>" . htmlspecialchars($line["link"]) . "</link>";
+
+			$rfc822_date = date('r', strtotime($line["updated"]));
+
+			print "<pubDate>$rfc822_date</pubDate>";
+
+			print "<title>" . 
+				htmlspecialchars($line["title"]) . "</title>";
+
+			print "<description>" . 
+				htmlspecialchars($line["content_preview"]) . "</description>";
+
+			print "</item>";
+		}
+
+		print "</channel></rss>";
+
+	}
+
 ?>
diff --git a/images/feed-icon-12x12.png b/images/feed-icon-12x12.png
new file mode 100644
index 0000000000000000000000000000000000000000..291000eab2b97c9a5a6f76e77afd6837ec10ac5f
GIT binary patch
literal 552
zcmV+@0@wYCP)<h;3K|Lk000e1NJLTq000aC000aK1^@s6R&`wG00004XF*Lt006JZ
zHwB960000PbVXQnQ*UN;cVTj606}DLVr3vnZDD6+Qe|Oed2z{QJOBUzx=BPqRCwA<
zk-bYCQ540``<S=0VIzacF0qn?L<AuU3K9{qFa#uBAf2RH(xeDBHdZ32e?YL%O0cm}
zPy$=6l{RW6grHy*B?iqTyJ2^}-phS&R2;a&8|Iw*e)nAVeWq`~SAN}BD&QW6kPQ4m
zF~I<nq4_rs!(Yt_X~i<h0{OHb=K2)S|G*3h!ND25ITe{Y%U)nisV+Uv1Fj4@t81{2
z{&R`++b*(`P4KMg#EeX7tWhfYL{U@_1%~FvM@0LpK-_>DsltE14pDw_FHTz;S!}2Q
zaSCGhdWN7cjuCB6BdN`T6&^!QeSz+H=EP~+8Z;p~14Ci7isHK!_|sc?*RP)(qI|uK
z%sjd^nA~8~X{}8n-CF=n3pu$2<5$qG&4YJ5f#{pc4atKW950Ep?GG@GONdvW(LSj|
zhZiWke2X-)2D-uKY)$ITGQ{{CO!pY#gH_j=RR+;I+JV>I>-cqQkwl)exjBW28i>yi
z5uF`6e%AFI@zoD^7L{JYO2B?D4*#}Gxr@%S-dB_-V~5p*Bf3;5?Yiv-i$xhgE6^{1
q8!(Rsq%R12HppZeCWt2f3ormBw8_v>x+2X00000<MNUMnLSTYE*zK$U

literal 0
HcmV?d00001

-- 
2.39.5