diff options
Diffstat (limited to 'modules-available')
-rw-r--r-- | modules-available/statistics_reporting/inc/queries.inc.php | 5 |
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; |