From aa4f8b2901bbd15cac0a6dec704bc800686a1eb0 Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Thu, 15 Mar 2018 13:34:40 +0100 Subject: add xchan_network = zot and xchan_deleted = 0 to the random_profile() query --- include/connections.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'include/connections.php') diff --git a/include/connections.php b/include/connections.php index e9d7daa2d..c5d74d4ca 100644 --- a/include/connections.php +++ b/include/connections.php @@ -421,7 +421,10 @@ function random_profile() { for($i = 0; $i < $retryrandom; $i++) { - $r = q("select xchan_url, xchan_hash from xchan left join hubloc on hubloc_hash = xchan_hash where xchan_hidden = 0 and xchan_system = 0 and hubloc_connected > %s - interval %s order by $randfunc limit 1", + $r = q("select xchan_url, xchan_hash from xchan left join hubloc on hubloc_hash = xchan_hash where + xchan_hidden = 0 and xchan_system = 0 and + xchan_network = 'zot' and xchan_deleted = 0 and + hubloc_connected > %s - interval %s order by $randfunc limit 1", db_utcnow(), db_quoteinterval('30 day') ); -- cgit v1.2.3