summaryrefslogtreecommitdiff
path: root/backend.php
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2005-11-18 14:29:32 +0100
committerAndrew Dolgov <[email protected]>2005-11-18 14:29:32 +0100
commitd9f115c3b2e799ad7fccd4a8eefa462a9c1d6408 (patch)
tree0c9401c8199669a21c3512b0c33215a3190ea995 /backend.php
parent967955b7594bee6fcf9c9ea60931fbcd1697b447 (diff)
approx db size in user details shows kbytes
Diffstat (limited to 'backend.php')
-rw-r--r--backend.php6
1 files changed, 3 insertions, 3 deletions
diff --git a/backend.php b/backend.php
index 2f1e7c2f8..36d1a66ee 100644
--- a/backend.php
+++ b/backend.php
@@ -1996,16 +1996,16 @@
SUM(LENGTH(content)+LENGTH(title)+LENGTH(link)+LENGTH(guid)) AS db_size
FROM ttrss_entries WHERE owner_uid = '$uid'");
- $db_size = db_fetch_result($result, 0, "db_size");
+ $db_size = round(db_fetch_result($result, 0, "db_size") / 1024);
- print "<tr><td>Approx. DB size</td><td>$db_size bytes</td></tr>";
+ print "<tr><td>Approx. DB size</td><td>$db_size KBytes</td></tr>";
print "</table>";
print "<h1>Subscribed feeds</h1>";
$result = db_query($link, "SELECT id,title,feed_url FROM ttrss_feeds
- WHERE owner_uid = '$uid'");
+ WHERE owner_uid = '$uid' ORDER BY title");
print "<ul class=\"nomarks\">";