add script to build release tarball

[tt-rss.git] / utils / stats.php

diff --git a/utils/stats.php b/utils/stats.php
index 5bc4355db7862d01669d56763f62e01617ef1b7e..b8e6e06dfc7eba8de1ee0944fbc6517ddc7938e5 100644 (file)
--- a/utils/stats.php
+++ b/utils/stats.php
@@ -12,7 +12,8 @@
        login_sequence($link);
 
        if ($_SESSION["access_level"] < 10) { 
-               header("Location: login.php"); die;
+               print "<p>Error: your access level is insufficient to run this script.</p>";
+               exit;
        }
 ?>
 
@@ -46,7 +47,8 @@
        $result = db_query($link, "SELECT count(ttrss_entries.id) AS cid,
                login FROM ttrss_entries 
                LEFT JOIN ttrss_user_entries ON (ref_id = ttrss_entries.id) 
-               LEFT JOIN ttrss_users ON (ttrss_users.id = owner_uid) GROUP BY login");
+               LEFT JOIN ttrss_users ON (ttrss_users.id = ttrss_user_entries.owner_uid) 
+                       GROUP BY login");
 
        print "<h2>Per-user storage</h2>";
 
@@ -59,12 +61,36 @@
 
        while ($line = db_fetch_assoc($result)) {
                print "<tr>";
-               print "<td>" . $line["cid"] . "</td><td>" . $line["login"] . "</td>";
+               print "<td>" . $line["cid"] . "</td>";
+               print "<td>" . $line["login"] . "</td>";
                print "</tr>";
        }
 
        print "</table>";
 
+       $result = db_query($link, "SELECT COUNT(ttrss_feeds.id) AS fc,
+               login FROM ttrss_users, ttrss_feeds
+                       WHERE ttrss_users.id = ttrss_feeds.owner_uid
+               GROUP BY login ORDER BY fc DESC");
+
+       print "<h2>Per-user subscriptions</h2>";
+
+       print "<table border width='100%'>";
+       
+       print "<tr>
+               <td>Owner</td>
+               <td>Feeds</td>
+       </tr>";
+
+       while ($line = db_fetch_assoc($result)) {
+               print "<tr>";
+               print "<td>" . $line["login"] . "</td>";
+               print "<td>" . $line["fc"] . "</td>";
+               print "</tr>";
+       }
+
+       print "</table>"; 
+
        print "<h2>User subscriptions</h2>";
 
        $result = db_query($link, "SELECT title,feed_url,site_url,login,