From 5dd18528ebd23cbc8b6d86c988d398a0058d1bab Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Tue, 7 Feb 2017 14:55:23 +0100
Subject: [statistics_reporting] Use indexed fields for joins, return location
 id from GetData::*

---
 modules-available/statistics_reporting/inc/getdata.inc.php | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'modules-available/statistics_reporting/inc/getdata.inc.php')

diff --git a/modules-available/statistics_reporting/inc/getdata.inc.php b/modules-available/statistics_reporting/inc/getdata.inc.php
index b19af966..9604d652 100644
--- a/modules-available/statistics_reporting/inc/getdata.inc.php
+++ b/modules-available/statistics_reporting/inc/getdata.inc.php
@@ -49,6 +49,9 @@ class GetData
 				'sessions' => $row['longSessions'],
 				'shortSessions' => $row['shortSessions']
 			);
+			if (!$anonymize) {
+				$entry['locationId'] = $row['locId'];
+			}
 			if ($printable) {
 				$entry['time_s'] = self::formatSeconds($row['timeSum']);
 				$entry['medianTime_s'] = self::formatSeconds($median);
@@ -78,6 +81,9 @@ class GetData
 				'shortSessions' => $row['shortSessions'],
 				'location' => ($anonymize ? $row['locHash'] : $row['locName']),
 			);
+			if (!$anonymize) {
+				$entry['locationId'] = $row['locId'];
+			}
 			if ($printable) {
 				$entry['time_s'] = self::formatSeconds($row['timeSum']);
 				$entry['medianTime_s'] = self::formatSeconds($median);
-- 
cgit v1.2.3-55-g7522