diff options
author | Andrew Dolgov <[email protected]> | 2008-10-08 05:14:20 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2008-10-08 05:14:20 +0100 |
commit | fad8506f6511c83be66442aa6231b0455281a9d1 (patch) | |
tree | 3d2ef12239176ef81e680b02bf40dd2a8404f420 | |
parent | f46192bb191acdbc733f60bad60c4eb83ebb2e26 (diff) |
display size of stored articles in the user details window
-rw-r--r-- | modules/pref-users.php | 22 |
1 files changed, 10 insertions, 12 deletions
diff --git a/modules/pref-users.php b/modules/pref-users.php index 061927033..75afb00a3 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>"; |