From b5b20494741a721eae44c1afea8369437d8ce97e Mon Sep 17 00:00:00 2001 From: Christian Hofmaier Date: Tue, 20 Dec 2016 16:09:55 +0100 Subject: [statistics_reporting] deleted vm per user (for udo) after adding it last commit --- modules-available/statistics_reporting/inc/statisticreporting.inc.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'modules-available/statistics_reporting/inc') diff --git a/modules-available/statistics_reporting/inc/statisticreporting.inc.php b/modules-available/statistics_reporting/inc/statisticreporting.inc.php index 0e6039bb..c9fe1c64 100644 --- a/modules-available/statistics_reporting/inc/statisticreporting.inc.php +++ b/modules-available/statistics_reporting/inc/statisticreporting.inc.php @@ -46,11 +46,11 @@ class StatisticReporting // logins between bounds public static function getUserStatistics($cutOffTimeInSeconds, $lowerTimeBound = 0, $upperTimeBound = 24) { $queryTime = time() - $cutOffTimeInSeconds; - $res = Database::simpleQuery("SELECT username, data, COUNT(*) AS 'count' + $res = Database::simpleQuery("SELECT username, COUNT(*) AS 'count' FROM statistic WHERE typeid='.vmchooser-session-name' AND dateline>=$queryTime AND ((FROM_UNIXTIME(dateline+data, '%H')*1 >= $lowerTimeBound) AND (FROM_UNIXTIME(dateline, '%H')*1 < $upperTimeBound)) - GROUP BY username, data ORDER BY 3 DESC"); + GROUP BY username ORDER BY 2 DESC"); return $res; } -- cgit v1.2.3-55-g7522