From 62eee07b6ee7ad7f34dbe7c5080630435acbb0bf Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Tue, 20 Dec 2022 14:06:14 +0100 Subject: make sure to include only zot6 hublocs in this query. including other networks could lead to unexpected results --- include/hubloc.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'include') diff --git a/include/hubloc.php b/include/hubloc.php index 965725cba..0236e4ae7 100644 --- a/include/hubloc.php +++ b/include/hubloc.php @@ -79,9 +79,10 @@ function prune_hub_reinstalls() { $r = q("select site_url from site where site_type = %d", intval(SITE_TYPE_ZOT) ); + if($r) { foreach($r as $rr) { - $x = q("select count(*) as t, hubloc_sitekey, max(hubloc_connected) as c from hubloc where hubloc_url = '%s' group by hubloc_sitekey order by c", + $x = q("select count(*) as t, hubloc_sitekey, max(hubloc_connected) as c from hubloc where hubloc_url = '%s' and hubloc_network = 'zot6' group by hubloc_sitekey order by c", dbesc($rr['site_url']) ); -- cgit v1.2.3