From fad8506f6511c83be66442aa6231b0455281a9d1 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.spb.ru>
Date: Wed, 8 Oct 2008 05:14:20 +0100
Subject: [PATCH] display size of stored articles in the user details window

---
 modules/pref-users.php | 22 ++++++++++------------
 1 file changed, 10 insertions(+), 12 deletions(-)

diff --git a/modules/pref-users.php b/modules/pref-users.php
index 06192703..75afb00a 100644
--- a/modules/pref-users.php
+++ b/modules/pref-users.php
@@ -53,26 +53,24 @@
 			// print "<tr><td>Access level</td><td>$access_level</td></tr>";
 			print "<tr><td>".__('Registered')."</td><td>$created</td></tr>";
 			print "<tr><td>".__('Last logged in')."</td><td>$last_login</td></tr>";
-			print "<tr><td>".__('Stored articles')."</td><td>$stored_articles</td></tr>";
 
-			$result = db_query($link, "SELECT COUNT(id) as num_feeds FROM ttrss_feeds
-				WHERE owner_uid = '$uid'");
-
-			$num_feeds = db_fetch_result($result, 0, "num_feeds");
-
-			print "<tr><td>".__('Subscribed feeds count')."</td><td>$num_feeds</td></tr>";
-
-			/*
 			$result = db_query($link, "SELECT 
-				SUM(LENGTH(content)+LENGTH(title)+LENGTH(link)+LENGTH(guid)) AS db_size 
+				SUM(LENGTH(content)) AS db_size 
 				FROM ttrss_user_entries,ttrss_entries 
 					WHERE owner_uid = '$uid' AND ref_id = id");
 
 			$db_size = round(db_fetch_result($result, 0, "db_size") / 1024);
 
-			print "<tr><td>Approx. used DB size</td><td>$db_size KBytes</td></tr>";
-			*/
+			print "<tr><td>".__('Stored articles').
+				"</td><td>$stored_articles (${db_size}K)</td></tr>";
 
+			$result = db_query($link, "SELECT COUNT(id) as num_feeds FROM ttrss_feeds
+				WHERE owner_uid = '$uid'");
+
+			$num_feeds = db_fetch_result($result, 0, "num_feeds");
+
+			print "<tr><td>".__('Subscribed feeds count')."</td><td>$num_feeds</td></tr>";
+	
 			print "</table>";
 
 			print "<h1>".__('Subscribed feeds')."</h1>";
-- 
2.39.5