From 4fec9fd7795c4258a50b87ec88d076b85e7c040d Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Sun, 20 Nov 2005 08:31:58 +0100
Subject: feed details improvements

---
 backend.php | 26 +++++++++++++++++++++++---
 1 file changed, 23 insertions(+), 3 deletions(-)

(limited to 'backend.php')

diff --git a/backend.php b/backend.php
index b8455b485..cd7d65c2d 100644
--- a/backend.php
+++ b/backend.php
@@ -2175,7 +2175,7 @@
 
 		$result = db_query($link, 
 			"SELECT 
-				title,feed_url,last_updated,
+				title,feed_url,last_updated,icon_url,
 				(SELECT COUNT(int_id) FROM ttrss_user_entries 
 					WHERE feed_id = id) AS total,
 				(SELECT COUNT(int_id) FROM ttrss_user_entries 
@@ -2190,19 +2190,39 @@
 		$title = db_fetch_result($result, 0, "title");
 		$last_updated = db_fetch_result($result, 0, "last_updated");
 		$feed_url = db_fetch_result($result, 0, "feed_url");
+		$icon_url = db_fetch_result($result, 0, "icon_url");
 		$total = db_fetch_result($result, 0, "total");
 		$unread = db_fetch_result($result, 0, "unread");
 		$marked = db_fetch_result($result, 0, "marked");
 
-		print "<div class=\"infoBoxContents\"><h1>$title</h1>";
+
+		$result = db_query($link, "SELECT COUNT(id) AS subscribed
+					FROM ttrss_feeds WHERE feed_url = '$feed_url'");
+
+		$subscribed = db_fetch_result($result, 0, "subscribed");
+
+		print "<div class=\"infoBoxContents\">";
+
+		$icon_file = ICONS_DIR . "/$feed_id.ico";
+
+		if (file_exists($icon_file) && filesize($icon_file) > 0) {
+				$feed_icon = "<img width=\"16\" height=\"16\"
+					src=\"" . ICONS_URL . "/$feed_id.ico\">";
+		} else {
+			$feed_icon = "";
+		}
+
+		print "<h1>$feed_icon $title</h1>";
 
 		print "<table width='100%'>";
 
-		print "<tr><td>Feed URL</td><td><a href=\"$feed_url\">$feed_url</a></td></tr>";
+		print "<tr><td width='30%'>Feed URL</td>
+			<td><a href=\"$feed_url\">$feed_url</a></td></tr>";
 		print "<tr><td>Last updated</td><td>$last_updated</td></tr>";
 		print "<tr><td>Total articles</td><td>$total</td></tr>";
 		print "<tr><td>Unread articles</td><td>$unread</td></tr>";
 		print "<tr><td>Starred articles</td><td>$marked</td></tr>";
+		print "<tr><td>Subscribed users</td><td>$subscribed</td></tr>";
 
 		print "</table>";
 
-- 
cgit v1.2.3