diff options
author | Andrew Dolgov <[email protected]> | 2006-04-28 08:01:41 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2006-04-28 08:01:41 +0100 |
commit | eed55fd30e4ba648f9678c526d58749638ff5e62 (patch) | |
tree | 1f67c02911700139df3673475dbbe8903adb7635 /update_daemon.php | |
parent | 550e37d59df7c830756d7810e002907b13ddb169 (diff) |
new option: DAEMON_UPDATE_LOGIN_LIMIT
Diffstat (limited to 'update_daemon.php')
-rw-r--r-- | update_daemon.php | 38 |
1 files changed, 35 insertions, 3 deletions
diff --git a/update_daemon.php b/update_daemon.php index d61ed69f1..a6fb5461d 100644 --- a/update_daemon.php +++ b/update_daemon.php @@ -75,12 +75,44 @@ $random_qpart = sql_random_function(); - $result = db_query($link, "SELECT feed_url,id,owner_uid, - SUBSTRING(last_updated,1,19) AS last_updated, - update_interval FROM ttrss_feeds ORDER BY $random_qpart DESC"); +/* + ttrss_entries.date_entered < NOW() - INTERVAL '$purge_interval days'"); + } + + $rows = pg_affected_rows($result); + + } else { + + $result = db_query($link, "DELETE FROM ttrss_user_entries + USING ttrss_user_entries, ttrss_entries + WHERE ttrss_entries.id = ref_id AND + marked = false AND + feed_id = '$feed_id' AND + ttrss_entries.date_entered < DATE_SUB(NOW(), INTERVAL $purge_interval DAY)"); */ + + if (DAEMON_UPDATE_LOGIN_LIMIT > 0) { + if (DB_TYPE == "pgsql") { + $login_thresh_qpart = "AND ttrss_users.last_login >= NOW() - INTERVAL '".DAEMON_UPDATE_LOGIN_LIMIT." days'"; + } else { + $login_thresh_qpart = "AND ttrss_users.last_login >= DATE_SUB(NOW(), INTERVAL ".DAEMON_UPDATE_LOGIN_LIMIT." DAY)"; + } + } else { + $login_thresh_qpart = ""; + } + + $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 + ORDER BY $random_qpart DESC"); $user_prefs_cache = array(); + printf("Scheduled %d feeds to update...\n", db_num_rows($result)); + while ($line = db_fetch_assoc($result)) { $upd_intl = $line["update_interval"]; |