From 717f5e645b47a444bb0a2f524658e36ad1a4b74f Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 18 Nov 2005 13:02:38 +0100 Subject: user details for user manager --- backend.php | 97 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 92 insertions(+), 5 deletions(-) (limited to 'backend.php') diff --git a/backend.php b/backend.php index 9078a2043..f7318ff47 100644 --- a/backend.php +++ b/backend.php @@ -11,9 +11,6 @@ require_once "functions.php"; require_once "magpierss/rss_fetch.inc"; -// $_SESSION["uid"] = PLACEHOLDER_UID; // FIXME: placeholder -// $_SESSION["name"] = PLACEHOLDER_NAME; - $op = $_REQUEST["op"]; if ($op == "rpc" || $op == "updateAllFeeds") { @@ -1928,12 +1925,102 @@ print " Selection: + onclick=\"javascript:selectedUserDetails()\" value=\"User details\"> "; + onclick=\"javascript:removeSelectedUsers()\" value=\"Remove\"> + "; + + } + } + + if ($op == "user-details") { + + if (WEB_DEMO_MODE || $_SESSION["access_level"] < 10) { + return; + } + + print " + Tiny Tiny RSS : User Details + + + "; + + $uid = sprintf("%d", $_GET["id"]); + + /* FIXME this badly needs real implementation */ + + print "
"; + + $result = db_query($link, "SELECT login,last_login,access_level + FROM ttrss_users + WHERE id = '$uid'"); + + if (db_num_rows($result) == 0) { + print "

User not found

"; + return; + } + + print "

User Details

"; + + print ""; + + $login = db_fetch_result($result, 0, "login"); + $last_login = db_fetch_result($result, 0, "last_login"); + $access_level = db_fetch_result($result, 0, "access_level"); + + print ""; + print ""; + print ""; + + $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 ""; + + $result = db_query($link, "SELECT + 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"); + + print ""; + + print "
Username$login
Access level$access_level
Last logged in$last_login
Subscribed feeds count$num_feeds
Approx. DB size$db_size bytes
"; + + print "

Subscribed feeds

"; + + $result = db_query($link, "SELECT id,title,feed_url FROM ttrss_feeds + WHERE owner_uid = '$uid'"); + + print ""; + + print "

+ (Close this window)

"; + + print "
"; + + print ""; + } -- cgit v1.2.3