diff options
| author | friendica <info@friendica.com> | 2014-05-25 23:00:06 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2014-05-25 23:00:06 -0700 |
| commit | 9fa929fab5c4c547951a0b42e7d56a94aea17564 (patch) | |
| tree | 408fe09857ddccfee71c194bd985a4b578b9e347 /include/Contact.php | |
| parent | 810515f1a10082ac7bc75550089ce9c40b44b003 (diff) | |
| download | volse-hubzilla-9fa929fab5c4c547951a0b42e7d56a94aea17564.tar.gz volse-hubzilla-9fa929fab5c4c547951a0b42e7d56a94aea17564.tar.bz2 volse-hubzilla-9fa929fab5c4c547951a0b42e7d56a94aea17564.zip | |
filter randprof results to avoid channels that are known to be deceased.
Diffstat (limited to 'include/Contact.php')
| -rw-r--r-- | include/Contact.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/include/Contact.php b/include/Contact.php index 540e1169d..0cd4be72c 100644 --- a/include/Contact.php +++ b/include/Contact.php @@ -510,7 +510,7 @@ function unmark_for_death($contact) { }} function random_profile() { - $r = q("select xchan_url from xchan where 1 order by rand() limit 1"); + $r = q("select xchan_url from xchan left join hubloc on hubloc_hash = xchan_hash where hubloc_connected > UTC_TIMESTAMP() - interval 30 day order by rand() limit 1"); if($r) return $r[0]['xchan_url']; return ''; |