From 31df7af61f449d2fe307b3440c7dd7bf4b016cf0 Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Thu, 15 Sep 2016 10:36:46 +0200 Subject: do not show hidden channels in /randprof issue #513 --- include/connections.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/include/connections.php b/include/connections.php index 4f685388c..017117dda 100644 --- a/include/connections.php +++ b/include/connections.php @@ -608,7 +608,7 @@ function random_profile() { for($i = 0; $i < $retryrandom; $i++) { - $r = q("select xchan_url from xchan left join hubloc on hubloc_hash = xchan_hash where xchan_addr not like '%s' and hubloc_connected > %s - interval %s order by $randfunc limit 1", + $r = q("select xchan_url from xchan left join hubloc on hubloc_hash = xchan_hash where xchan_addr not like '%s' and xchan_hidden = 0 and hubloc_connected > %s - interval %s order by $randfunc limit 1", dbesc('sys@%'), db_utcnow(), db_quoteinterval('30 day') ); -- cgit v1.2.3