From 3e4950c7bb00a0ed819a81f20ca3cb3a004fdccc Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Sun, 12 Feb 2006 11:48:47 +0100
Subject: [PATCH] statistics stub (2)

---
 stats.php | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

diff --git a/stats.php b/stats.php
index 65723ff2..d56389ec 100644
--- a/stats.php
+++ b/stats.php
@@ -29,11 +29,14 @@
 <h2>Counters</h2>
 
 <?
-	$result = db_query($link, "SELECT count(int_id) as cid FROM ttrss_user_entries");
+	$result = db_query($link, "SELECT count(id) AS cid,
+		SUM(LENGTH(content)) AS size
+		FROM ttrss_entries");
 
 	$total_articles = db_fetch_result($result, 0, "cid");
+	$articles_size = round(db_fetch_result($result, 0, "size") / 1024);
 
-	print "<p>Total articles stored: $total_articles</p>";
+	print "<p>Total articles stored: $total_articles (${articles_size}K)</p>";
 
 	$result = db_query($link, "SELECT COUNT(int_id) as cid,owner_uid,login 
 		FROM ttrss_user_entries 
-- 
2.39.5