diff options
| author | friendica <info@friendica.com> | 2015-01-26 18:27:03 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2015-01-26 18:27:03 -0800 |
| commit | ac594183c6fdc6cf4d5a2a29ade7478a17336397 (patch) | |
| tree | d38f73727da4d8697b00d2102ae10b501d1909ce /include/poller.php | |
| parent | e6bfe3f2c10e851ed5ba49886ec8d0a9a9de2296 (diff) | |
| parent | 9f5bfca28dde23893156ad36682e20ca2fc0dd45 (diff) | |
| download | volse-hubzilla-ac594183c6fdc6cf4d5a2a29ade7478a17336397.tar.gz volse-hubzilla-ac594183c6fdc6cf4d5a2a29ade7478a17336397.tar.bz2 volse-hubzilla-ac594183c6fdc6cf4d5a2a29ade7478a17336397.zip | |
Merge branch 'master' into tres and add some work on the item_deleted flag refactor
Conflicts:
include/attach.php
include/onedirsync.php
include/zot.php
mod/locs.php
Diffstat (limited to 'include/poller.php')
| -rw-r--r-- | include/poller.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/include/poller.php b/include/poller.php index a9647c725..b655259a4 100644 --- a/include/poller.php +++ b/include/poller.php @@ -388,7 +388,7 @@ function poller_run($argv, $argc){ } if($dirmode == DIRECTORY_MODE_SECONDARY || $dirmode == DIRECTORY_MODE_PRIMARY) { - $r = q("select distinct ud_addr, updates.* from updates where ( ud_flags & %d ) = 0 and ud_addr != '' and ( ud_last = '%s' OR ud_last > %s - INTERVAL %s ) group by ud_addr ", + $r = q("SELECT u.ud_addr, u.ud_id, u.ud_last FROM updates AS u INNER JOIN (SELECT ud_addr, max(ud_id) AS ud_id FROM updates WHERE ( ud_flags & %d ) = 0 AND ud_addr != '' AND ( ud_last = '%s' OR ud_last > %s - INTERVAL %s ) GROUP BY ud_addr) AS s ON s.ud_id = u.ud_id ", intval(UPDATE_FLAGS_UPDATED), dbesc(NULL_DATE), db_utcnow(), db_quoteinterval('7 DAY') |