diff options
| -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) { |