aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2018-05-30 14:09:24 +0200
committerMario Vavti <mario@mariovavti.com>2018-05-30 14:09:24 +0200
commit293e405f5b9761ade0c621c3696b93439b2440bf (patch)
tree78938b680dc3daff17b6899dcd7ddb7ab4843158
parent8d6441704bdc8d0628149dbb32321b6921f097ba (diff)
downloadvolse-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.php8
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) {