Changeset 2151 for branches/branch-1_7/feed.php

Timestamp:

Oct 23, 2007, 2:08:48 AM (17 years ago)

Author:

rvelices

Message:

• update last_check from time to time even if no news, so that we don't delete used feeds

File:

• branches/branch-1_7/feed.php (modified) (2 diffs)

branches/branch-1_7/feed.php

@@ -118 +118 @@
 // +-----------------------------------------------------------------------+
 
+$news = array();
 if (!$image_only)
 {
@@ -152 +153 @@
   }
 }
-else
-{
-  if ( !empty($feed_id) )
-  {// update the last check to avoid deletion by maintenance task
+
+if ( !empty($feed_id) and empty($news) )
+{// update the last check from time to time to avoid deletion by maintenance tasks
+  if ( !isset($feed_row['last_check'])
+    or time()-mysqldt_to_ts($feed_row['last_check']) > 30*24*3600 )
+  {
     $query = '
-  UPDATE '.USER_FEED_TABLE.'
-    SET last_check = \''.$dbnow.'\'
-    WHERE id = \''.$feed_id.'\'
-  ;';
+UPDATE '.USER_FEED_TABLE.'
+  SET last_check = DATE_ADD(\''.$dbnow.'\', INTERVAL -15 DAY )
+  WHERE id = \''.$feed_id.'\'
+;';
     pwg_query($query);
   }