aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2015-03-22 18:23:37 -0700
committerfriendica <info@friendica.com>2015-03-22 18:23:37 -0700
commitccef9e5636dadeb37cabd70d4a8aece650e70e1f (patch)
tree7270fd9e2965c26d8607ef0cbbdcc1599aadc782
parent2bd19e6b51ff7331c04f23c0ab78f1e16b5a054e (diff)
downloadvolse-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.php8
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) {