From 7b5c5c0fa234852b7bc01621e1c9be5e1b5f92e1 Mon Sep 17 00:00:00 2001 From: Jens Tautenhahn Date: Wed, 9 Nov 2016 21:48:36 +0100 Subject: [PATCH] count only version numbers starting with "numbers / dot or dash / numbers" in federation statistics --- mod/admin.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/mod/admin.php b/mod/admin.php index 287eff2725..0e9032cf3c 100644 --- a/mod/admin.php +++ b/mod/admin.php @@ -290,7 +290,7 @@ function admin_page_federation(&$a) { // what versions for that platform do we know at all? // again only the active nodes $v = qu('SELECT COUNT(*) AS `total`, `version` FROM `gserver` - WHERE `last_contact` > `last_failure` AND `platform` LIKE "%s" AND `version` != "" + WHERE `last_contact` > `last_failure` AND `platform` LIKE "%s" AND `version` RLIKE "^[[:digit:]]+[-.][[:digit:]]+" GROUP BY `version` ORDER BY `version`;', $p); -- 2.39.5