update_feedbrowser.php

   1 #!/usr/bin/php
   2 <?php
   3         // this script is probably run not from your httpd-user, so cache
   4         // directory defined in config.php won't be accessible
   5         define('MAGPIE_CACHE_DIR', '/var/tmp/magpie-ttrss-cache-cli');
   6         define('SIMPLEPIE_CACHE_DIR',   '/var/tmp/simplepie-ttrss-cache-cli');
   7         define('DEFAULT_ERROR_LEVEL', E_ERROR | E_WARNING | E_PARSE);
   8         define('DISABLE_SESSIONS', true);
   9
  10         error_reporting(DEFAULT_ERROR_LEVEL);
  11
  12         require_once "sanity_check.php";
  13         require_once "config.php";
  14         require_once "db.php";
  15         require_once "db-prefs.php";
  16         require_once "functions.php";
  17
  18         $lock_filename = "update_feedbrowser.lock";
  19
  20         $lock_handle = make_lockfile($lock_filename);
  21
  22                 // Try to lock a file in order to avoid concurrent update.
  23         if (!$lock_handle) {
  24                 die("error: Can't create lockfile ($lock_filename). ".
  25                         "Maybe another process is already running.\n");
  26         }
  27
  28         // Create a database connection.
  29         $link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
  30
  31         if (!$link) {
  32                 if (DB_TYPE == "mysql") {
  33                         print mysql_error();
  34                 }
  35                 // PG seems to display its own errors just fine by default.
  36                 return;
  37         }
  38
  39         init_connection($link);
  40
  41         $result = db_query($link, "SELECT feed_url,COUNT(id) AS subscribers
  42                 FROM ttrss_feeds WHERE (SELECT COUNT(id) = 0 FROM ttrss_feeds AS tf
  43                         WHERE tf.feed_url = ttrss_feeds.feed_url
  44                         AND (private IS true OR feed_url LIKE '%:%@%/%'))
  45                         GROUP BY feed_url ORDER BY subscribers DESC");
  46
  47         db_query($link, "BEGIN");
  48
  49         db_query($link, "DELETE FROM ttrss_feedbrowser_cache");
  50
  51         $count = 0;
  52
  53         while ($line = db_fetch_assoc($result)) {
  54                 $subscribers = db_escape_string($line["subscribers"]);
  55                 $feed_url = db_escape_string($line["feed_url"]);
  56
  57                 db_query($link, "INSERT INTO ttrss_feedbrowser_cache
  58                         (feed_url, subscribers) VALUES ('$feed_url', '$subscribers')");
  59
  60                 ++$count;
  61         }
  62
  63         db_query($link, "COMMIT");
  64
  65         print "Finished, $count feeds processed.\n";
  66
  67         db_close($link);
  68
  69         unlink(LOCK_DIRECTORY . "/$lock_filename");
  70
  71 ?>