From ccef9e5636dadeb37cabd70d4a8aece650e70e1f Mon Sep 17 00:00:00 2001 From: friendica Date: Sun, 22 Mar 2015 18:23:37 -0700 Subject: put a lower time limit on time travellers --- include/poller.php | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'include') 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) { -- cgit v1.2.3