X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Ftext.php;h=fc5e79294f261bfbe1942b42a7daad69f46f3aeb;hb=d0ade828c05545e45ce129c05090fa795d0376c1;hp=200e2c9bcad260053a9741cf3d722224a2bd7ddd;hpb=092c2e54333b3cecd49f034623886c7fd8c8981a;p=friendica.git diff --git a/include/text.php b/include/text.php index 200e2c9bca..fc5e79294f 100644 --- a/include/text.php +++ b/include/text.php @@ -895,9 +895,9 @@ function contact_block() { $micropro = Null; } else { - $r = q("SELECT * FROM `contact` - WHERE `uid` = %d AND `self` = 0 AND `blocked` = 0 and `pending` = 0 - AND `hidden` = 0 AND `archive` = 0 + $r = q("SELECT `id`, `uid`, `addr`, `url`, `name`, `micro`, `network` FROM `contact` + WHERE `uid` = %d AND NOT `self` AND NOT `blocked` AND NOT `pending` + AND NOT `hidden` AND NOT `archive` AND `network` IN ('%s', '%s', '%s') ORDER BY RAND() LIMIT %d", intval($a->profile['uid']), dbesc(NETWORK_DFRN),