Error: your access level is insufficient to run this script.

"; exit; } ?> Tiny Tiny Statistics

Tiny Tiny Statistics

Counters

Total articles stored: $total_articles (${articles_size}K)

"; /* $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 "

Per-user storage

"; print ""; print ""; while ($line = db_fetch_assoc($result)) { print ""; print ""; print ""; print ""; } print "
Articles Owner
" . $line["cid"] . "" . $line["login"] . "
"; $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 "

Per-user subscriptions

"; print ""; print ""; while ($line = db_fetch_assoc($result)) { print ""; print ""; print ""; print ""; } print "
Owner Feeds
" . $line["login"] . "" . $line["fc"] . "
"; print "

User subscriptions

"; $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 ""; print ""; $cur_login = ""; while ($line = db_fetch_assoc($result)) { print ""; print ""; print ""; print ""; print ""; print ""; print ""; if ($cur_login != $line["login"] && $cur_login != "") { print ""; $cur_login = $line["login"]; } } print "
Site Feed Owner Stored Articles Unread Articles
".$line["title"]."".$line["feed_url"]."" . $line["login"] . "" . $line["num_articles"] . "" . $line["num_articles_unread"] . "
 
"; ?>