update_daemon.php

   1 #!/usr/bin/php4
   2 <?
   3         // this daemon runs in the background and updates all feeds
   4         // continuously
   5
   6         define('SLEEP_INTERVAL', 10); // seconds
   7
   8         // TODO: allow update scheduling from users
   9
  10         define('MAGPIE_CACHE_DIR', '/var/tmp/magpie-ttrss-cache-daemon');
  11
  12         define('DISABLE_SESSIONS', true);
  13
  14         require_once "sanity_check.php";
  15         require_once "config.php";
  16         require_once "db.php";
  17         require_once "db-prefs.php";
  18         require_once "functions.php";
  19         require_once "magpierss/rss_fetch.inc";
  20
  21         $link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
  22
  23         if (!$link) {
  24                 if (DB_TYPE == "mysql") {
  25                         print mysql_error();
  26                 }
  27                 // PG seems to display its own errors just fine by default.
  28                 return;
  29         }
  30
  31         if (DB_TYPE == "pgsql") {
  32                 pg_query("set client_encoding = 'utf-8'");
  33         }
  34
  35         while (true) {
  36
  37                 // FIXME: get all scheduled updates w/forced refetch
  38
  39 #               $result = db_query($link, "SELECT * FROM ttrss_scheduled_updates ORDER BY id");
  40 #               while ($line = db_fetch_assoc($result)) {
  41 #                       print "Scheduled feed update: " . $line["feed_id"] . ", UID: " .
  42 #                               $line["owner_uid"] . "\n";
  43 #               }
  44
  45                 // Process all other feeds using last_updated and interval parameters
  46
  47                 $result = db_query($link, "SELECT feed_url,id,owner_uid,
  48                         SUBSTRING(last_updated,1,19) AS last_updated,
  49                         update_interval FROM ttrss_feeds ORDER BY last_updated DESC");
  50
  51                 while ($line = db_fetch_assoc($result)) {
  52
  53                         print "Checking feed: " . $line["feed_url"] . "\n";
  54
  55                         $upd_intl = $line["update_interval"];
  56
  57                         $user_id = $line["owner_uid"];
  58
  59                         if (!$upd_intl || $upd_intl == 0) {
  60                                 $upd_intl = get_pref($link, 'DEFAULT_UPDATE_INTERVAL', $user_id);
  61                         }
  62
  63                         if ($upd_intl < 0) {
  64                                 print "Updates disabled.\n";
  65                                 continue;
  66                         }
  67
  68                         printf("%d ? %d\n", time() - strtotime($line["last_updated"]) > $upd_intl*60,
  69                                 $upd_intl*60);
  70
  71                         if (!$line["last_updated"] ||
  72                                 time() - strtotime($line["last_updated"]) > ($upd_intl * 60)) {
  73
  74                                 print "Updating...\n";
  75
  76                                 update_rss_feed($link, $line["feed_url"], $line["id"], true);
  77
  78                         }
  79                 }
  80
  81                 print "Sleeping for " . SLEEP_INTERVAL . " seconds...\n";
  82
  83                 sleep(SLEEP_INTERVAL);
  84         }
  85
  86         db_close($link);
  87
  88 ?>