diff options
author | Andrew Dolgov <[email protected]> | 2015-08-12 16:01:47 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2015-08-12 16:01:47 +0300 |
commit | 1edff0d439202fdf5fab831f91dc7b3e9ce839e1 (patch) | |
tree | 0bed184e50f6f488c92d4204df97751e4b9b821c | |
parent | f76d2435b9fa833e61ba2c5c5c79e414ce0e265b (diff) |
user manager: show stored feeds/articles
-rw-r--r-- | classes/pref/users.php | 19 |
1 files changed, 13 insertions, 6 deletions
diff --git a/classes/pref/users.php b/classes/pref/users.php index a5d48ac96..e87751335 100644 --- a/classes/pref/users.php +++ b/classes/pref/users.php @@ -377,14 +377,17 @@ class Pref_Users extends Handler_Protected { } $result = $this->dbh->query("SELECT - id,login,access_level,email, + tu.id, + login,access_level,email, ".SUBSTRING_FOR_DATE."(last_login,1,16) as last_login, - ".SUBSTRING_FOR_DATE."(created,1,16) as created + ".SUBSTRING_FOR_DATE."(created,1,16) as created, + (SELECT COUNT(id) FROM ttrss_feeds WHERE owner_uid = tu.id) AS num_feeds, + (SELECT COUNT(ref_id) FROM ttrss_user_entries WHERE owner_uid = tu.id) AS num_articles FROM - ttrss_users + ttrss_users tu WHERE $user_search_query - id > 0 + tu.id > 0 ORDER BY $sort"); if ($this->dbh->num_rows($result) > 0) { @@ -394,8 +397,10 @@ class Pref_Users extends Handler_Protected { print "<tr class=\"title\"> <td align='center' width=\"5%\"> </td> - <td width='30%'><a href=\"#\" onclick=\"updateUsersList('login')\">".__('Login')."</a></td> - <td width='30%'><a href=\"#\" onclick=\"updateUsersList('access_level')\">".__('Access Level')."</a></td> + <td width='20%'><a href=\"#\" onclick=\"updateUsersList('login')\">".__('Login')."</a></td> + <td width='20%'><a href=\"#\" onclick=\"updateUsersList('access_level')\">".__('Access Level')."</a></td> + <td width='10%'><a href=\"#\" onclick=\"updateUsersList('num_feeds')\">".__('Subscribed feeds')."</a></td> + <td width='10%'><a href=\"#\" onclick=\"updateUsersList('num_articles')\">".__('Stored articles')."</a></td> <td width='20%'><a href=\"#\" onclick=\"updateUsersList('created')\">".__('Registered')."</a></td> <td width='20%'><a href=\"#\" onclick=\"updateUsersList('last_login')\">".__('Last login')."</a></td></tr>"; @@ -423,6 +428,8 @@ class Pref_Users extends Handler_Protected { if (!$line["email"]) $line["email"] = " "; print "<td $onclick>" . $access_level_names[$line["access_level"]] . "</td>"; + print "<td $onclick>" . $line["num_feeds"] . "</td>"; + print "<td $onclick>" . $line["num_articles"] . "</td>"; print "<td $onclick>" . $line["created"] . "</td>"; print "<td $onclick>" . $line["last_login"] . "</td>"; |