opml.php

   1 <?
   2         // FIXME there are some brackets issues here
   3
   4         $op = $_REQUEST["op"];
   5         if ($op == "Export") {
   6                 header("Content-type: application/xml");
   7                 print "<?xml version=\"1.0\"?>";
   8         }
   9
  10         require_once "config.php";
  11         require_once "db.php";
  12
  13         $link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
  14
  15         if (DB_TYPE == "pgsql") {
  16                 pg_query($link, "set client_encoding = 'utf-8'");
  17         }
  18
  19         if ($op == "Export") {
  20                 print "<opml version=\"1.0\">";
  21                 print "<head><dateCreated>" . date("r", time()) . "</dateCreated></head>";
  22                 print "<body>";
  23
  24                 $result = db_query($link, "SELECT * FROM ttrss_feeds ORDER BY title");
  25
  26                 while ($line = db_fetch_assoc($result)) {
  27                         $title = $line["title"];
  28                         $url = $line["feed_url"];
  29
  30                         print "<outline text=\"$title\" xmlUrl=\"$url\"/>";
  31                 }
  32
  33                 print "</body></opml>";
  34         }
  35
  36         function startElement($parser, $name, $attrs) {
  37
  38                 if ($name == "OUTLINE") {
  39                         $title = db_escape_string($attrs['TEXT']);
  40                         $url = db_escape_string($attrs['XMLURL']);
  41
  42                         if (!$title || !$url) return;
  43
  44                         print "Feed <b>$title</b> ($url)... ";
  45
  46                         $link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
  47
  48                         $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
  49                                 title = '$title' OR feed_url = '$url'");
  50
  51                         if ($result && db_num_rows($result) > 0) {
  52
  53                                 print " Already imported.<br>";
  54
  55                         } else {
  56
  57                                 $result = db_query($link, "INSERT INTO ttrss_feeds (title, feed_url) VALUES
  58                                         ('$title', '$url')");
  59
  60                                 print "<b>Done.</b><br>";
  61
  62                         }
  63
  64                         if ($link) db_close($link);
  65
  66                 }
  67         }
  68
  69         function endElement($parser, $name) {
  70
  71
  72         }
  73
  74         if ($op == "Import") {
  75
  76                 print "<html>
  77                         <head>
  78                                 <link rel=\"stylesheet\" href=\"opml.css\" type=\"text/css\">
  79                         </head>
  80                         <body><h1>Importing OPML...</h1>
  81                         <div>";
  82
  83                 if (WEB_DEMO_MODE) {
  84                         print "OPML import is disabled in demo-mode.";
  85                         print "<p><a class=\"button\" href=\"prefs.php\">
  86                         Return to preferences</a></div></body></html>";
  87
  88                         return;
  89                 }
  90
  91                 if (is_file($_FILES['opml_file']['tmp_name'])) {
  92
  93                         $xml_parser = xml_parser_create();
  94
  95                         xml_set_element_handler($xml_parser, "startElement", "endElement");
  96
  97                         $fp = fopen($_FILES['opml_file']['tmp_name'], "r");
  98
  99                         if ($fp) {
 100
 101                                 while ($data = fread($fp, 4096)) {
 102
 103                                         if (!xml_parse($xml_parser, $data, feof($fp))) {
 104
 105                                                 print sprintf("Unable to parse OPML file, XML error: %s at line %d",
 106                                                         xml_error_string(xml_get_error_code($xml_parser)),
 107                                                         xml_get_current_line_number($xml_parser));
 108
 109                                                 print "<p><a class=\"button\" href=\"prefs.php\">
 110                                                         Return to preferences</a>";
 111
 112                                                 return;
 113
 114                                         }
 115                                 }
 116
 117                                 xml_parser_free($xml_parser);
 118                                 fclose($fp);
 119
 120                         } else {
 121                                 print("Error: Could not open OPML input.");
 122                         }
 123
 124                 } else {
 125                         print "Error: please upload OPML file.";
 126                 }
 127
 128                 print "<p><a class=\"button\" href=\"prefs.php\">
 129                         Return to preferences</a>";
 130
 131                 print "</div></body></html>";
 132
 133         }
 134
 135         if ($link) db_close($link);
 136
 137 ?>