aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2018-03-15 13:34:40 +0100
committerMario Vavti <mario@mariovavti.com>2018-03-15 13:34:40 +0100
commitaa4f8b2901bbd15cac0a6dec704bc800686a1eb0 (patch)
tree7c7a5ea7c74850b6912dd0972f2af18ca9a61710
parent95c53c7e0b1cd0e70d81d2b9b83fee02952234b8 (diff)
downloadvolse-hubzilla-aa4f8b2901bbd15cac0a6dec704bc800686a1eb0.tar.gz
volse-hubzilla-aa4f8b2901bbd15cac0a6dec704bc800686a1eb0.tar.bz2
volse-hubzilla-aa4f8b2901bbd15cac0a6dec704bc800686a1eb0.zip
add xchan_network = zot and xchan_deleted = 0 to the random_profile() query
-rw-r--r--include/connections.php5
1 files changed, 4 insertions, 1 deletions
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')
);