diff options
author | Andrew Dolgov <[email protected]> | 2006-02-12 11:45:47 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2006-02-12 11:45:47 +0100 |
commit | 81f8401db744830ca78f6aa7a54e11de79bcf1e9 (patch) | |
tree | c644675cadc7b52e637aee2ab693bc792c55d8c8 | |
parent | cce5b59a751d5a6189ee4e988efe25e06fa589c6 (diff) |
statistics stub
-rw-r--r-- | error.php | 1 | ||||
-rw-r--r-- | stats.php | 102 |
2 files changed, 103 insertions, 0 deletions
@@ -28,6 +28,7 @@ $ERRORS[8] = "Could not display feed: query failed. Please check label match syntax or local configuration."; + $ERRORS[8] = "Denied. Your access level is insufficient to access this page."; ?> <html> diff --git a/stats.php b/stats.php new file mode 100644 index 000000000..65723ff2e --- /dev/null +++ b/stats.php @@ -0,0 +1,102 @@ +<? + session_start(); + + require_once "sanity_check.php"; + require_once "version.php"; + require_once "config.php"; + require_once "db-prefs.php"; + require_once "functions.php"; + + $link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME); + + login_sequence($link); + + if ($_SESSION["access_level"] < 10) { + header("Location: error.php?c=8"); + exit; + } +?> + +<html> +<head> + <title>Tiny Tiny Statistics</title> +</head> + +<body> + +<h1>Tiny Tiny Statistics</h1> + +<h2>Counters</h2> + +<? + $result = db_query($link, "SELECT count(int_id) as cid FROM ttrss_user_entries"); + + $total_articles = db_fetch_result($result, 0, "cid"); + + print "<p>Total articles stored: $total_articles</p>"; + + $result = db_query($link, "SELECT COUNT(int_id) as cid,owner_uid,login + FROM ttrss_user_entries + JOIN ttrss_users ON (owner_uid = ttrss_users.id) + GROUP BY owner_uid,login ORDER BY cid DESC"); + + print "<h2>Per-user storage</h2>"; + + print "<table width='100%'>"; + + print "<tr> + <td>Articles</td> + <td>Owner</td> + </tr>"; + + while ($line = db_fetch_assoc($result)) { + print "<tr>"; + print "<td>" . $line["cid"] . "</td><td>" . $line["login"] . "</td>"; + print "</tr>"; + } + + print "</table>"; + + print "<h2>User subscriptions</h2>"; + + $result = db_query($link, "SELECT title,feed_url,site_url,login, + (SELECT count(int_id) FROM ttrss_user_entries + WHERE feed_id = ttrss_feeds.id) AS num_articles, + (SELECT count(int_id) FROM ttrss_user_entries + WHERE feed_id = ttrss_feeds.id AND unread = true) AS num_articles_unread + FROM ttrss_feeds,ttrss_users + WHERE owner_uid = ttrss_users.id ORDER BY login"); + + print "<table width='100%'>"; + print "<tr> + <td>Site</td> + <td>Feed</td> + <td>Owner</td> + <td>Stored Articles</td> + <td>Unread Articles</td> + </tr>"; + + $cur_login = ""; + + while ($line = db_fetch_assoc($result)) { + print "<tr>"; + print "<td><a href=\"".$line["site_url"]."\">".$line["title"]."</a></td>"; + print "<td><a href=\"".$line["feed_url"]."\">".$line["feed_url"]."</a></td>"; + print "<td>" . $line["login"] . "</td>"; + print "<td>" . $line["num_articles"] . "</td>"; + print "<td>" . $line["num_articles_unread"] . "</td>"; + print "</tr>"; + + if ($cur_login != $line["login"] && $cur_login != "") { + print "<tr><td> </td></tr>"; + $cur_login = $line["login"]; + } + } + + print "</table>"; + +?> +</pre> + +</body> +</html> |