]>
Commit | Line | Data |
---|---|---|
81f8401d | 1 | <? |
36bfab86 | 2 | require_once "sessions.php"; |
81f8401d AD |
3 | |
4 | require_once "sanity_check.php"; | |
5 | require_once "version.php"; | |
6 | require_once "config.php"; | |
7 | require_once "db-prefs.php"; | |
8 | require_once "functions.php"; | |
9 | ||
10 | $link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME); | |
11 | ||
12 | login_sequence($link); | |
13 | ||
14 | if ($_SESSION["access_level"] < 10) { | |
f2b6a2d4 | 15 | header("Location: login.php"); die; |
81f8401d AD |
16 | } |
17 | ?> | |
18 | ||
19 | <html> | |
20 | <head> | |
21 | <title>Tiny Tiny Statistics</title> | |
22 | </head> | |
23 | ||
24 | <body> | |
25 | ||
26 | <h1>Tiny Tiny Statistics</h1> | |
27 | ||
28 | <h2>Counters</h2> | |
29 | ||
30 | <? | |
3e4950c7 AD |
31 | $result = db_query($link, "SELECT count(id) AS cid, |
32 | SUM(LENGTH(content)) AS size | |
33 | FROM ttrss_entries"); | |
81f8401d AD |
34 | |
35 | $total_articles = db_fetch_result($result, 0, "cid"); | |
3e4950c7 | 36 | $articles_size = round(db_fetch_result($result, 0, "size") / 1024); |
81f8401d | 37 | |
3e4950c7 | 38 | print "<p>Total articles stored: $total_articles (${articles_size}K)</p>"; |
81f8401d | 39 | |
f26ef034 | 40 | /* $result = db_query($link, "SELECT COUNT(int_id) as cid,owner_uid,login |
81f8401d | 41 | FROM ttrss_user_entries |
f26ef034 AD |
42 | LEFT JOIN ttrss_users ON (owner_uid = ttrss_users.id) |
43 | GROUP BY owner_uid,login ORDER BY cid DESC"); */ | |
44 | ||
45 | $result = db_query($link, "SELECT count(ttrss_entries.id) AS cid, | |
46 | login FROM ttrss_entries | |
47 | LEFT JOIN ttrss_user_entries ON (ref_id = ttrss_entries.id) | |
48 | LEFT JOIN ttrss_users ON (ttrss_users.id = owner_uid) GROUP BY login"); | |
81f8401d AD |
49 | |
50 | print "<h2>Per-user storage</h2>"; | |
51 | ||
52 | print "<table width='100%'>"; | |
53 | ||
54 | print "<tr> | |
55 | <td>Articles</td> | |
56 | <td>Owner</td> | |
57 | </tr>"; | |
58 | ||
59 | while ($line = db_fetch_assoc($result)) { | |
60 | print "<tr>"; | |
61 | print "<td>" . $line["cid"] . "</td><td>" . $line["login"] . "</td>"; | |
62 | print "</tr>"; | |
63 | } | |
64 | ||
65 | print "</table>"; | |
66 | ||
67 | print "<h2>User subscriptions</h2>"; | |
68 | ||
69 | $result = db_query($link, "SELECT title,feed_url,site_url,login, | |
70 | (SELECT count(int_id) FROM ttrss_user_entries | |
71 | WHERE feed_id = ttrss_feeds.id) AS num_articles, | |
72 | (SELECT count(int_id) FROM ttrss_user_entries | |
73 | WHERE feed_id = ttrss_feeds.id AND unread = true) AS num_articles_unread | |
74 | FROM ttrss_feeds,ttrss_users | |
75 | WHERE owner_uid = ttrss_users.id ORDER BY login"); | |
76 | ||
77 | print "<table width='100%'>"; | |
78 | print "<tr> | |
79 | <td>Site</td> | |
80 | <td>Feed</td> | |
81 | <td>Owner</td> | |
82 | <td>Stored Articles</td> | |
83 | <td>Unread Articles</td> | |
84 | </tr>"; | |
85 | ||
86 | $cur_login = ""; | |
87 | ||
88 | while ($line = db_fetch_assoc($result)) { | |
89 | print "<tr>"; | |
90 | print "<td><a href=\"".$line["site_url"]."\">".$line["title"]."</a></td>"; | |
91 | print "<td><a href=\"".$line["feed_url"]."\">".$line["feed_url"]."</a></td>"; | |
92 | print "<td>" . $line["login"] . "</td>"; | |
93 | print "<td>" . $line["num_articles"] . "</td>"; | |
94 | print "<td>" . $line["num_articles_unread"] . "</td>"; | |
95 | print "</tr>"; | |
96 | ||
97 | if ($cur_login != $line["login"] && $cur_login != "") { | |
98 | print "<tr><td> </td></tr>"; | |
99 | $cur_login = $line["login"]; | |
100 | } | |
101 | } | |
102 | ||
103 | print "</table>"; | |
104 | ||
105 | ?> | |
106 | </pre> | |
107 | ||
108 | </body> | |
109 | </html> |