diff options
Diffstat (limited to 'update_daemon.php')
| -rw-r--r-- | update_daemon.php | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/update_daemon.php b/update_daemon.php index 75229f667..e5d368a8d 100644 --- a/update_daemon.php +++ b/update_daemon.php @@ -126,13 +126,19 @@ $login_thresh_qpart = ""; } + if (DB_TYPE == "pgsql") { + $update_limit_qpart = "AND ttrss_feeds.last_updated < NOW() - INTERVAL '".(DAEMON_SLEEP_INTERVAL*2)." seconds'"; + } else { + $update_limit_qpart = "AND ttrss_feeds.last_updated < DATE_SUB(NOW(), INTERVAL ".(DAEMON_SLEEP_INTERVAL*2)." SECOND)"; + } + $result = db_query($link, "SELECT feed_url,ttrss_feeds.id,owner_uid, SUBSTRING(last_updated,1,19) AS last_updated, update_interval FROM ttrss_feeds,ttrss_users WHERE - ttrss_users.id = owner_uid $login_thresh_qpart + ttrss_users.id = owner_uid $login_thresh_qpart $update_limit_qpart ORDER BY $random_qpart DESC LIMIT " . DAEMON_FEED_LIMIT); $user_prefs_cache = array(); |