aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-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) {