diff options
| author | friendica <info@friendica.com> | 2015-03-22 18:23:37 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2015-03-22 18:23:37 -0700 |
| commit | ccef9e5636dadeb37cabd70d4a8aece650e70e1f (patch) | |
| tree | 7270fd9e2965c26d8607ef0cbbdcc1599aadc782 | |
| parent | 2bd19e6b51ff7331c04f23c0ab78f1e16b5a054e (diff) | |
| download | volse-hubzilla-ccef9e5636dadeb37cabd70d4a8aece650e70e1f.tar.gz volse-hubzilla-ccef9e5636dadeb37cabd70d4a8aece650e70e1f.tar.bz2 volse-hubzilla-ccef9e5636dadeb37cabd70d4a8aece650e70e1f.zip | |
put a lower time limit on time travellers
| -rw-r--r-- | include/poller.php | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/include/poller.php b/include/poller.php index 43cc3f3c0..b70ef75b0 100644 --- a/include/poller.php +++ b/include/poller.php @@ -82,11 +82,13 @@ function poller_run($argv, $argc){ } // publish any applicable items that were set to be published in the future - // (time travel posts) + // (time travel posts). Restrict to items that have come of age in the last + // couple of days to limit the query to something reasonable. - $r = q("select id from item where ( item_restrict & %d ) > 0 and created <= %s ", + $r = q("select id from item where ( item_restrict & %d ) > 0 and created <= %s and created > '%s' ", intval(ITEM_DELAYED_PUBLISH), - db_utcnow() + db_utcnow(), + dbesc(datetime_convert('UTC','UTC','now - 2 days')) ); if($r) { foreach($r as $rr) { |