diff options
author | Simon Rettberg | 2016-02-19 15:02:08 +0100 |
---|---|---|
committer | Simon Rettberg | 2016-02-19 15:02:08 +0100 |
commit | 1e57f42bde0d2cc11f77ff834c9d6d3631ac27cb (patch) | |
tree | 9949b0fa81c6ffdf31f30c5abf197e7c3f82c930 /apis | |
parent | [locations] New module for managing locations (diff) | |
download | slx-admin-1e57f42bde0d2cc11f77ff834c9d6d3631ac27cb.tar.gz slx-admin-1e57f42bde0d2cc11f77ff834c9d6d3631ac27cb.tar.xz slx-admin-1e57f42bde0d2cc11f77ff834c9d6d3631ac27cb.zip |
[statistics] cron: log usage
Diffstat (limited to 'apis')
-rw-r--r-- | apis/cron.inc.php | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/apis/cron.inc.php b/apis/cron.inc.php index 318fb67f..7171fb4e 100644 --- a/apis/cron.inc.php +++ b/apis/cron.inc.php @@ -31,5 +31,20 @@ case 6: break; } +// TODO: Move to some module +function logstats() { + $NOW = time(); + $cutoff = $NOW - 86400 * 30; + $online = $NOW - 610; + $known = Database::queryFirst("SELECT Count(*) AS val FROM machine WHERE lastseen > $cutoff"); + $on = Database::queryFirst("SELECT Count(*) AS val FROM machine WHERE lastseen > $online"); + $used = Database::queryFirst("SELECT Count(*) AS val FROM machine WHERE lastseen > $online AND logintime <> 0"); + Database::exec("INSERT INTO statistic (dateline, typeid, clientip, username, data) VALUES (:now, '~stats', '', '', :vals)", array( + 'now' => $NOW, + 'vals' => $known['val'] . '#' . $on['val'] . '#' . $used['val'], + )); +} +logstats(); + Trigger::checkCallbacks(); Trigger::ldadp(); |