From bca02305ba0a0f7ae90e328f838b17c409465599 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Sun, 20 Nov 2005 11:36:00 +0100
Subject: show latest headlines in feed details

---
 backend.php | 26 ++++++++++++++++++++++----
 1 file changed, 22 insertions(+), 4 deletions(-)

(limited to 'backend.php')

diff --git a/backend.php b/backend.php
index 169ce297a..9b2cd288f 100644
--- a/backend.php
+++ b/backend.php
@@ -2221,12 +2221,30 @@
 
 		print "</table>";
 
-		print "</div>";
+		$result = db_query($link, "SELECT title,updated 
+			FROM ttrss_entries,ttrss_user_entries
+			WHERE ref_id = id AND feed_id = '$feed_id' 
+			ORDER BY date_entered LIMIT 5");
 
-		print "<div align='center'>
-			<input type='submit' class='button'			
-			onclick=\"closeInfoBox()\" value=\"Close this window\"></div>";
+		if (db_num_rows($result) > 0) {
+
+			print "<h1>Latest headlines</h1>";
 
+			print "<ul class=\"nomarks\">";
+	
+			while ($line = db_fetch_assoc($result)) {
+				print "<li>" . $line["title"].
+				"&nbsp;<span class=\"insensitive\">(" .$line["updated"].")</span></li>";
+			}
+	
+			print "</ul>";
+	
+			print "</div>";
+	
+			print "<div align='center'>
+				<input type='submit' class='button'			
+				onclick=\"closeInfoBox()\" value=\"Close this window\"></div>";
+		}
 	}
 
 	db_close($link);
-- 
cgit v1.2.3-54-g00ecf