add multiprocess update daemon

[tt-rss.git] / backend.php

diff --git a/backend.php b/backend.php
index c5757a2ff13b5960d99007d17e44aa7448dbd857..ea96a0e41207ce55f326e5398f643006ecc4c02e 100644 (file)
--- a/backend.php
+++ b/backend.php
@@ -50,8 +50,10 @@
                pg_query("set client_encoding = 'UTF-8'");
                pg_set_client_encoding("UNICODE");
        } else {
-               db_query($link, "SET NAMES utf8");
-               db_query($link, "SET CHARACTER SET utf8");
+               if (defined('MYSQL_CHARSET') && MYSQL_CHARSET) {
+                       db_query($link, "SET NAMES " . MYSQL_CHARSET);
+//                     db_query($link, "SET CHARACTER SET " . MYSQL_CHARSET);
+               }
        }
 
        $op = $_REQUEST["op"];
@@ -62,8 +64,12 @@
                        $op == "digestSend" || $op == "viewfeed" || $op == "publish" ||
                        $op == "globalUpdateFeeds") && !$_REQUEST["noxml"]) {
                header("Content-Type: application/xml; charset=utf-8");
-       } else {
-               header("Content-Type: text/html; charset=utf-8");
+               } else {
+               if (!$_REQUEST["noxml"]) {
+                       header("Content-Type: text/html; charset=utf-8");
+               } else {
+                       header("Content-Type: text/plain; charset=utf-8");
+               }
        }
 
        if (!$op) {
@@ -213,13 +219,30 @@
                set_pref($link, "_DEFAULT_VIEW_MODE", $view_mode);
                set_pref($link, "_DEFAULT_VIEW_LIMIT", $limit);
 
+               if (!$cat_view && preg_match("/^[0-9][0-9]*$/", $feed)) {
+                       db_query($link, "UPDATE ttrss_feeds SET last_viewed = NOW()
+                               WHERE id = '$feed' AND owner_uid = ".$_SESSION["uid"]);
+               }
+
                print "<headlines id=\"$feed\"><![CDATA[";
 
-               $topmost_article_ids = outputHeadlinesList($link, $feed, $subop, 
+               $ret = outputHeadlinesList($link, $feed, $subop, 
                        $view_mode, $limit, $cat_view, $next_unread_feed, $offset);
 
+               $topmost_article_ids = $ret[0];
+               $headlines_count = $ret[1];
+               $returned_feed = $ret[2];
+               $disable_cache = $ret[3];
+
                print "]]></headlines>";
 
+               print "<headlines-count value=\"$headlines_count\"/>";
+
+               $headlines_unread = getFeedUnread($link, $returned_feed);
+
+               print "<headlines-unread value=\"$headlines_unread\"/>";
+               printf("<disable-cache value=\"%d\"/>", $disable_cache);
+
                if ($_GET["debug"]) $timing_info = print_checkpoint("10", $timing_info);
 
                if (is_array($topmost_article_ids) && !get_pref($link, 'COMBINED_DISPLAY_MODE')) {
@@ -233,7 +256,7 @@
                if ($_GET["debug"]) $timing_info = print_checkpoint("20", $timing_info);
 
                print "<counters>";
-               getAllCounters($link, $omode);
+               getAllCounters($link, $omode, $feed);
                print "</counters>";
 
                if ($_GET["debug"]) $timing_info = print_checkpoint("30", $timing_info);
@@ -315,7 +338,8 @@
                        SUBSTRING(last_login,1,16) AS last_login,
                        access_level,
                        (SELECT COUNT(int_id) FROM ttrss_user_entries 
-                               WHERE owner_uid = id) AS stored_articles
+                               WHERE owner_uid = id) AS stored_articles,
+                       SUBSTRING(created,1,16) AS created
                        FROM ttrss_users 
                        WHERE id = '$uid'");
                        
@@ -334,20 +358,25 @@
 
                $last_login = date(get_pref($link, 'LONG_DATE_FORMAT'),
                        strtotime(db_fetch_result($result, 0, "last_login")));
+
+               $created = date(get_pref($link, 'LONG_DATE_FORMAT'),
+                       strtotime(db_fetch_result($result, 0, "created")));
+
                $access_level = db_fetch_result($result, 0, "access_level");
                $stored_articles = db_fetch_result($result, 0, "stored_articles");
 
 #              print "<tr><td>Username</td><td>$login</td></tr>";
 #              print "<tr><td>Access level</td><td>$access_level</td></tr>";
-               print "<tr><td>Last logged in</td><td>$last_login</td></tr>";
-               print "<tr><td>Stored articles</td><td>$stored_articles</td></tr>";
+               print "<tr><td>".__('Registered')."</td><td>$created</td></tr>";
+               print "<tr><td>".__('Last logged in')."</td><td>$last_login</td></tr>";
+               print "<tr><td>".__('Stored articles')."</td><td>$stored_articles</td></tr>";
 
                $result = db_query($link, "SELECT COUNT(id) as num_feeds FROM ttrss_feeds
                        WHERE owner_uid = '$uid'");
 
                $num_feeds = db_fetch_result($result, 0, "num_feeds");
 
-               print "<tr><td>Subscribed feeds count</td><td>$num_feeds</td></tr>";
+               print "<tr><td>".__('Subscribed feeds count')."</td><td>$num_feeds</td></tr>";
 
 /*             $result = db_query($link, "SELECT 
                        SUM(LENGTH(content)+LENGTH(title)+LENGTH(link)+LENGTH(guid)) AS db_size 
@@ -360,7 +389,7 @@
 
                print "</table>";
 
-               print "<h1>Subscribed feeds</h1>";
+               print "<h1>".__('Subscribed feeds')."</h1>";
 
                $result = db_query($link, "SELECT id,title,site_url FROM ttrss_feeds
                        WHERE owner_uid = '$uid' ORDER BY title");