diff options
| author | Mario Vavti <mario@mariovavti.com> | 2018-05-30 14:09:24 +0200 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2018-05-30 14:09:24 +0200 |
| commit | 293e405f5b9761ade0c621c3696b93439b2440bf (patch) | |
| tree | 78938b680dc3daff17b6899dcd7ddb7ab4843158 | |
| parent | 8d6441704bdc8d0628149dbb32321b6921f097ba (diff) | |
| download | volse-hubzilla-293e405f5b9761ade0c621c3696b93439b2440bf.tar.gz volse-hubzilla-293e405f5b9761ade0c621c3696b93439b2440bf.tar.bz2 volse-hubzilla-293e405f5b9761ade0c621c3696b93439b2440bf.zip | |
just query for data we actually need
| -rw-r--r-- | Zotlabs/Daemon/Poller.php | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/Zotlabs/Daemon/Poller.php b/Zotlabs/Daemon/Poller.php index e4bc9c143..49151437c 100644 --- a/Zotlabs/Daemon/Poller.php +++ b/Zotlabs/Daemon/Poller.php @@ -71,14 +71,18 @@ class Poller { $randfunc = db_getfunc('RAND'); - $contacts = q("SELECT * FROM abook LEFT JOIN xchan on abook_xchan = xchan_hash + $contacts = q("SELECT abook.abook_updated, abook.abook_connected, abook.abook_feed, + abook.abook_channel, abook.abook_id, abook.abook_archived, abook.abook_pending, + abook.abook_ignored, abook.abook_blocked, + xchan.xchan_network, + account.account_lastlog, account.account_flags + FROM abook LEFT JOIN xchan on abook_xchan = xchan_hash LEFT JOIN account on abook_account = account_id where abook_self = 0 $sql_extra AND (( account_flags = %d ) OR ( account_flags = %d )) $abandon_sql ORDER BY $randfunc", intval(ACCOUNT_OK), intval(ACCOUNT_UNVERIFIED) // FIXME - ); if($contacts) { |