summaryrefslogtreecommitdiffstats
path: root/modules-available/statistics_reporting/inc/queries.inc.php
diff options
context:
space:
mode:
Diffstat (limited to 'modules-available/statistics_reporting/inc/queries.inc.php')
-rw-r--r--modules-available/statistics_reporting/inc/queries.inc.php5
1 files changed, 4 insertions, 1 deletions
diff --git a/modules-available/statistics_reporting/inc/queries.inc.php b/modules-available/statistics_reporting/inc/queries.inc.php
index 47a07375..fc61c68a 100644
--- a/modules-available/statistics_reporting/inc/queries.inc.php
+++ b/modules-available/statistics_reporting/inc/queries.inc.php
@@ -384,11 +384,14 @@ class Queries
AND dateline BETWEEN :from AND :to", $data);
} else {
$data['locs'] = explode(',', $row['locs']);
- $exam = Database::queryFirst("SELECT Count(*) AS `event`, Avg(s.data) AS length FROM statistic s
+ $exam = Database::queryFirst("SELECT Count(*) AS `sessions`, Avg(s.data) AS length FROM statistic s
INNER JOIN machine m USING (machineuuid)
WHERE typeid = '~session-length' AND m.locationid IN (:locs)
AND dateline BETWEEN :from AND :to", $data);
}
+ settype($exam['length'], 'int');
+ settype($exam['sessions'], 'int');
+ $exam['duration'] = $row['endtime'] - $row['starttime'];
$return[] = $exam;
}
return $return;