1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
|
<?php
require_once "sessions.php";
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) {
print "<p>Error: your access level is insufficient to run this script.</p>";
exit;
}
?>
<html>
<head>
<title>Tiny Tiny Statistics</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<h1>Tiny Tiny Statistics</h1>
<h2>Counters</h2>
<?php
$result = db_query($link, "SELECT count(id) AS cid,
SUM(LENGTH(content)) AS size
FROM ttrss_entries");
$total_articles = db_fetch_result($result, 0, "cid");
$articles_size = round(db_fetch_result($result, 0, "size") / 1024);
print "<p>Total articles stored: $total_articles (${articles_size}K)</p>";
/* $result = db_query($link, "SELECT COUNT(int_id) as cid,owner_uid,login
FROM ttrss_user_entries
LEFT JOIN ttrss_users ON (owner_uid = ttrss_users.id)
GROUP BY owner_uid,login ORDER BY cid DESC"); */
$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 = ttrss_user_entries.owner_uid)
GROUP BY login");
print "<h2>Per-user storage</h2>";
print "<table border width='100%'>";
print "<tr>
<td>Articles</td>
<td>Owner</td>
</tr>";
while ($line = db_fetch_assoc($result)) {
print "<tr>";
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,
(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 border 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>
|