X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FWorker%2FDirectory.php;h=12dfda087368864b37cfb4576d0daf33fb33b9d3;hb=2647514603852fe5fb9f47f0bf153dd20c124ce6;hp=ff844ca39209df506abbeb4042f1402f223d51c4;hpb=2c56d2f3360c08e312e5c167261af8e5d4b87af4;p=friendica.git diff --git a/src/Worker/Directory.php b/src/Worker/Directory.php index ff844ca392..12dfda0873 100644 --- a/src/Worker/Directory.php +++ b/src/Worker/Directory.php @@ -1,6 +1,6 @@ fetch($dir . '?url=' . bin2hex($arr['url'])); } return; } private static function updateAll() { - $r = q("SELECT `url` FROM `contact` - INNER JOIN `profile` ON `profile`.`uid` = `contact`.`uid` - INNER JOIN `user` ON `user`.`uid` = `contact`.`uid` - WHERE `contact`.`self` AND `profile`.`net-publish` AND - NOT `user`.`account_expired` AND `user`.`verified`"); - - if (DBA::isResult($r)) { - foreach ($r AS $user) { - Worker::add(PRIORITY_LOW, 'Directory', $user['url']); - } + $users = DBA::select('owner-view', ['url'], ['net-publish' => true, 'account_expired' => false, 'verified' => true]); + while ($user = DBA::fetch($users)) { + Worker::add(PRIORITY_LOW, 'Directory', $user['url']); } + DBA::close($users); } }