From 368e1d42d7b87f21645ed8cfe9959562aab99c26 Mon Sep 17 00:00:00 2001
From: Christian Klinger
Date: Thu, 29 Sep 2016 10:37:04 +0200
Subject: use INET_ATON() on `clientip` so fix #3000.

---
 modules-available/statistics/inc/filterset.inc.php | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

diff --git a/modules-available/statistics/inc/filterset.inc.php b/modules-available/statistics/inc/filterset.inc.php
index 8f506654..9676732a 100644
--- a/modules-available/statistics/inc/filterset.inc.php
+++ b/modules-available/statistics/inc/filterset.inc.php
@@ -43,7 +43,13 @@ class FilterSet
 
 		$col = $this->sortColumn;
 		$isMapped = array_key_exists('map_sort', Page_Statistics::$columns[$col]);
-		$sort = " ORDER BY " . ($isMapped ? Page_Statistics::$columns[$col]['map_sort'] : $col) . " " . $this->sortDirection
+		$concreteCol = ($isMapped ? Page_Statistics::$columns[$col]['map_sort'] : $col) ;
+
+		if ($concreteCol === 'clientip') {
+			$concreteCol = "INET_ATON(clientip)";
+		}
+
+		$sort = " ORDER BY " . $concreteCol . " " . $this->sortDirection
 			. ", machineuuid ASC";
 	}
 
-- 
cgit v1.2.3-55-g7522