}
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);
}
}