X-Git-Url: https://git.wh0rd.org/?a=blobdiff_plain;f=backend.php;h=c2efc73d6f0e43a63f72dcb676334e8663590482;hb=11adc49e719c87e79d9cc04c33b76351a4992a05;hp=02b52e68aadf66f9599aab38442b911825dd8b9e;hpb=5d17ead9b20017e1e0aad674912dae7fe61b8bd0;p=tt-rss.git diff --git a/backend.php b/backend.php index 02b52e68..6b93d1b3 100644 --- a/backend.php +++ b/backend.php @@ -1,102 +1,70 @@ -

Error: Not logged in.

- - - "; - } - exit; + + if (SINGLE_USER_MODE) { + authenticate_user($link, "admin", null); + } + + if (!($_SESSION["uid"] && validate_session($link)) && $op != "globalUpdateFeeds" && + $op != "rss" && $op != "getUnread" && $op != "getProfiles" && + $op != "fbexport" && $op != "logout" && $op != "pubsub") { + + header("Content-Type: text/plain"); + print json_encode(array("error" => array("code" => 6))); + return; } $purge_intervals = array( @@ -109,7 +77,7 @@ 90 => __("3 months old")); $update_intervals = array( - 0 => __("Use default"), + 0 => __("Default interval"), -1 => __("Disable updates"), 15 => __("Each 15 minutes"), 30 => __("Each 30 minutes"), @@ -119,9 +87,31 @@ 1440 => __("Daily"), 10080 => __("Weekly")); + $update_intervals_nodefault = array( + -1 => __("Disable updates"), + 15 => __("Each 15 minutes"), + 30 => __("Each 30 minutes"), + 60 => __("Hourly"), + 240 => __("Each 4 hours"), + 720 => __("Each 12 hours"), + 1440 => __("Daily"), + 10080 => __("Weekly")); + + $update_methods = array( + 0 => __("Default"), + 1 => __("Magpie"), + 2 => __("SimplePie"), + 3 => __("Twitter OAuth")); + + if (DEFAULT_UPDATE_METHOD == "1") { + $update_methods[0] .= ' (SimplePie)'; + } else { + $update_methods[0] .= ' (Magpie)'; + } $access_level_names = array( - 0 => __("User"), + 0 => __("User"), + 5 => __("Power User"), 10 => __("Administrator")); require_once "modules/pref-prefs.php"; @@ -131,432 +121,505 @@ require_once "modules/pref-filters.php"; require_once "modules/pref-labels.php"; require_once "modules/pref-users.php"; - require_once "modules/pref-feed-browser.php"; + require_once "modules/pref-instances.php"; - if (!sanity_check($link)) { return; } + $error = sanity_check($link); - if ($op == "rpc") { - handle_rpc_request($link); + if ($error['code'] != 0 && $op != "logout") { + print json_encode(array("error" => $error)); + return; } - - if ($op == "feeds") { - - $tags = $_GET["tags"]; - $subop = $_GET["subop"]; + switch($op) { // Select action according to $op value. + case "rpc": + // Handle remote procedure calls. + handle_rpc_request($link); + break; // rpc + + case "feeds": + $subop = $_REQUEST["subop"]; + $root = (bool)$_REQUEST["root"]; + + switch($subop) { + case "catchupAll": + db_query($link, "UPDATE ttrss_user_entries SET + last_read = NOW(),unread = false WHERE owner_uid = " . $_SESSION["uid"]); + ccache_zero_all($link, $_SESSION["uid"]); + + break; + + case "collapse": + $cat_id = db_escape_string($_REQUEST["cid"]); + $mode = (int) db_escape_string($_REQUEST['mode']); + toggle_collapse_cat($link, $cat_id, $mode); + return; + break; + } - if ($subop == "catchupAll") { - db_query($link, "UPDATE ttrss_user_entries SET - last_read = NOW(),unread = false WHERE owner_uid = " . $_SESSION["uid"]); - } + if (!$root) { + print json_encode(outputFeedList($link)); + } else { - if ($subop == "collapse") { - $cat_id = db_escape_string($_GET["cid"]); + $feeds = outputFeedList($link, false); - db_query($link, "UPDATE ttrss_feed_categories SET - collapsed = NOT collapsed WHERE id = '$cat_id' AND owner_uid = " . - $_SESSION["uid"]); - return; - } + $root = array(); + $root['id'] = 'root'; + $root['name'] = __('Feeds'); + $root['items'] = $feeds['items']; - outputFeedList($link, $tags); + $fl = array(); + $fl['identifier'] = 'id'; + $fl['label'] = 'name'; + $fl['items'] = array($root); - } + print json_encode($fl); + } - if ($op == "view") { + break; // feeds - $id = db_escape_string($_GET["id"]); - $feed_id = db_escape_string($_GET["feed"]); - $cids = split(",", db_escape_string($_GET["cids"])); - $mode = db_escape_string($_GET["mode"]); - $omode = db_escape_string($_GET["omode"]); + case "la": + $id = db_escape_string($_REQUEST['id']); - print ""; + $result = db_query($link, "SELECT link FROM ttrss_entries, ttrss_user_entries + WHERE id = '$id' AND id = ref_id AND owner_uid = '".$_SESSION['uid']."' + LIMIT 1"); - // in prefetch mode we only output requested cids, main article - // just gets marked as read (it already exists in client cache) + if (db_num_rows($result) == 1) { + $article_url = db_fetch_result($result, 0, 'link'); + $article_url = str_replace("\n", "", $article_url); - if ($mode == "") { - outputArticleXML($link, $id, $feed_id); - } else { - catchupArticleById($link, $id, 0); - } + header("Location: $article_url"); + return; - foreach ($cids as $cid) { - if ($cid) { - outputArticleXML($link, $cid, $feed_id, false); + } else { + print_error(__("Article not found.")); } - } + break; - if ($mode != "prefetch_old") { - print ""; - getAllCounters($link, $omode); - print ""; - } + case "view": - print ""; - } + $id = db_escape_string($_REQUEST["id"]); + $cids = split(",", db_escape_string($_REQUEST["cids"])); + $mode = db_escape_string($_REQUEST["mode"]); + $omode = db_escape_string($_REQUEST["omode"]); - if ($op == "viewfeed") { + // in prefetch mode we only output requested cids, main article + // just gets marked as read (it already exists in client cache) - $print_exec_time = true; - $timing_info = getmicrotime(); + $articles = array(); - print ""; + if ($mode == "") { + array_push($articles, format_article($link, $id, false)); + } else if ($mode == "zoom") { + array_push($articles, format_article($link, $id, false, true, true)); + } else if ($mode == "raw") { + if ($_REQUEST['html']) { + header("Content-Type: text/html"); + print ''; + } - if ($_GET["debug"]) $timing_info = print_checkpoint("0", $timing_info); + $article = format_article($link, $id, false); + print $article['content']; + return; + } else { + catchupArticleById($link, $id, 0); + } - $omode = db_escape_string($_GET["omode"]); + if (!$_SESSION["bw_limit"]) { + foreach ($cids as $cid) { + if ($cid) { + array_push($articles, format_article($link, $cid, false, false)); + } + } + } - $feed = db_escape_string($_GET["feed"]); - $subop = db_escape_string($_GET["subop"]); - $view_mode = db_escape_string($_GET["view_mode"]); - $limit = db_escape_string($_GET["limit"]); - $cat_view = db_escape_string($_GET["cat"]); - $next_unread_feed = db_escape_string($_GET["nuf"]); - $offset = db_escape_string($_GET["skip"]); + print json_encode($articles); - set_pref($link, "_DEFAULT_VIEW_MODE", $view_mode); - set_pref($link, "_DEFAULT_VIEW_LIMIT", $limit); + break; // view - print ""; + if ($_REQUEST["debug"]) $timing_info = print_checkpoint("0", $timing_info); - print ""; + $omode = db_escape_string($_REQUEST["omode"]); - $headlines_unread = getFeedUnread($link, $returned_feed); + $feed = db_escape_string($_REQUEST["feed"]); + $subop = db_escape_string($_REQUEST["subop"]); + $view_mode = db_escape_string($_REQUEST["view_mode"]); + $limit = (int) get_pref($link, "DEFAULT_ARTICLE_LIMIT"); + @$cat_view = db_escape_string($_REQUEST["cat"]); + @$next_unread_feed = db_escape_string($_REQUEST["nuf"]); + @$offset = db_escape_string($_REQUEST["skip"]); + @$vgroup_last_feed = db_escape_string($_REQUEST["vgrlf"]); + $order_by = db_escape_string($_REQUEST["order_by"]); - print ""; + /* Feed -5 is a special case: it is used to display auxiliary information + * when there's nothing to load - e.g. no stuff in fresh feed */ - if ($_GET["debug"]) $timing_info = print_checkpoint("10", $timing_info); + if ($feed == -5) { + print json_encode(generate_dashboard_feed($link)); + return; + } - if (is_array($topmost_article_ids) && !get_pref($link, 'COMBINED_DISPLAY_MODE')) { - print ""; - foreach ($topmost_article_ids as $id) { - outputArticleXML($link, $id, $feed, false); + $result = false; + + if ($feed < -10) { + $label_feed = -11-$feed; + $result = db_query($link, "SELECT id FROM ttrss_labels2 WHERE + id = '$label_feed' AND owner_uid = " . $_SESSION['uid']); + } else if (!$cat_view && $feed > 0) { + $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE + id = '$feed' AND owner_uid = " . $_SESSION['uid']); + } else if ($cat_view && $feed > 0) { + $result = db_query($link, "SELECT id FROM ttrss_feed_categories WHERE + id = '$feed' AND owner_uid = " . $_SESSION['uid']); } - print ""; - } - if ($_GET["debug"]) $timing_info = print_checkpoint("20", $timing_info); + if ($result && db_num_rows($result) == 0) { + print json_encode(generate_error_feed($link, __("Feed not found."))); + return; + } - print ""; - getAllCounters($link, $omode, $feed); - print ""; + /* Updating a label ccache means recalculating all of the caches + * so for performance reasons we don't do that here */ - if ($_GET["debug"]) $timing_info = print_checkpoint("30", $timing_info); + if ($feed >= 0) { + ccache_update($link, $feed, $_SESSION["uid"], $cat_view); + } - print_runtime_info($link); + set_pref($link, "_DEFAULT_VIEW_MODE", $view_mode); + set_pref($link, "_DEFAULT_VIEW_LIMIT", $limit); + set_pref($link, "_DEFAULT_VIEW_ORDER_BY", $order_by); - print ""; - } + 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"]); + } - if ($op == "pref-feeds") { - module_pref_feeds($link); - } + $reply['headlines'] = array(); - if ($op == "pref-filters") { - module_pref_filters($link); - } + if (!$next_unread_feed) + $reply['headlines']['id'] = $feed; + else + $reply['headlines']['id'] = $next_unread_feed; - if ($op == "pref-labels") { - module_pref_labels($link); - } + $reply['headlines']['is_cat'] = (bool) $cat_view; - if ($op == "pref-prefs") { - module_pref_prefs($link); - } + $override_order = false; - if ($op == "pref-users") { - module_pref_users($link); - } + if (get_pref($link, "SORT_HEADLINES_BY_FEED_DATE", $owner_uid)) { + $date_sort_field = "updated"; + } else { + $date_sort_field = "date_entered"; + } - if ($op == "help") { - module_help($link); - } + switch ($order_by) { + case "date": + if (get_pref($link, 'REVERSE_HEADLINES', $owner_uid)) { + $override_order = "$date_sort_field"; + } else { + $override_order = "$date_sort_field DESC"; + } + break; - if ($op == "dlg") { - module_popup_dialog($link); - } + case "title": + if (get_pref($link, 'REVERSE_HEADLINES', $owner_uid)) { + $override_order = "title DESC, $date_sort_field"; + } else { + $override_order = "title, $date_sort_field DESC"; + } + break; - if ($op == "pref-pub-items") { - module_pref_pub_items($link); - } + case "score": + if (get_pref($link, 'REVERSE_HEADLINES', $owner_uid)) { + $override_order = "score, $date_sort_field"; + } else { + $override_order = "score DESC, $date_sort_field DESC"; + } + break; + } + if ($_REQUEST["debug"]) $timing_info = print_checkpoint("04", $timing_info); - // update feeds of all users, may be used anonymously - if ($op == "globalUpdateFeeds") { + $ret = format_headlines_list($link, $feed, $subop, + $view_mode, $limit, $cat_view, $next_unread_feed, $offset, + $vgroup_last_feed, $override_order); - $result = db_query($link, "SELECT id FROM ttrss_users"); + $topmost_article_ids = $ret[0]; + $headlines_count = $ret[1]; + $returned_feed = $ret[2]; + $disable_cache = $ret[3]; + $vgroup_last_feed = $ret[4]; - while ($line = db_fetch_assoc($result)) { - $user_id = $line["id"]; -// print ""; - update_all_feeds($link, false, $user_id); - } + $reply['headlines']['content'] = $ret[5]; + $reply['headlines']['toolbar'] = $ret[6]; - print " - - "; + if ($_REQUEST["debug"]) $timing_info = print_checkpoint("05", $timing_info); - } + $headlines_unread = ccache_find($link, $returned_feed, $_SESSION["uid"], + $cat_view, true); - if ($op == "user-details") { + if ($headlines_unread == -1) { + $headlines_unread = getFeedUnread($link, $returned_feed, $cat_view); + } - if (WEB_DEMO_MODE || $_SESSION["access_level"] < 10) { - return; - } - -/* print " - Tiny Tiny RSS : User Details - - - "; */ - - $uid = sprintf("%d", $_GET["id"]); - - print "
User details
"; - - print "
"; - - $result = db_query($link, "SELECT login, - 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, - SUBSTRING(created,1,16) AS created - FROM ttrss_users - WHERE id = '$uid'"); - - if (db_num_rows($result) == 0) { - print "

User not found

"; - return; - } - -# print "

User Details

"; + $reply['headlines-info'] = array("count" => (int) $headlines_count, + "vgroup_last_feed" => $vgroup_last_feed, + "unread" => (int) $headlines_unread, + "disable_cache" => (bool) $disable_cache); + + if ($_REQUEST["debug"]) $timing_info = print_checkpoint("20", $timing_info); + + if (is_array($topmost_article_ids) && !get_pref($link, 'COMBINED_DISPLAY_MODE') && !$_SESSION["bw_limit"]) { + $articles = array(); + + foreach ($topmost_article_ids as $id) { + array_push($articles, format_article($link, $id, $feed, false)); + } + + $reply['articles'] = $articles; + } + + if ($subop) { + $reply['counters'] = getAllCounters($link, $omode, $feed); + } + + if ($_REQUEST["debug"]) $timing_info = print_checkpoint("30", $timing_info); - $login = db_fetch_result($result, 0, "login"); + $reply['runtime-info'] = make_runtime_info($link); -# print "

$login

"; + print json_encode($reply); - print ""; + break; // viewfeed - $last_login = date(get_pref($link, 'LONG_DATE_FORMAT'), - strtotime(db_fetch_result($result, 0, "last_login"))); + case "pref-feeds": + module_pref_feeds($link); + break; // pref-feeds - $created = date(get_pref($link, 'LONG_DATE_FORMAT'), - strtotime(db_fetch_result($result, 0, "created"))); + case "pref-filters": + module_pref_filters($link); + break; // pref-filters - $access_level = db_fetch_result($result, 0, "access_level"); - $stored_articles = db_fetch_result($result, 0, "stored_articles"); + case "pref-labels": + module_pref_labels($link); + break; // pref-labels -# print ""; -# print ""; - print ""; - print ""; - print ""; + case "pref-prefs": + module_pref_prefs($link); + break; // pref-prefs - $result = db_query($link, "SELECT COUNT(id) as num_feeds FROM ttrss_feeds - WHERE owner_uid = '$uid'"); + case "pref-users": + module_pref_users($link); + break; // prefs-users - $num_feeds = db_fetch_result($result, 0, "num_feeds"); + case "help": + module_help($link); + break; // help - print ""; + case "dlg": + module_popup_dialog($link); + break; // dlg -/* $result = db_query($link, "SELECT - SUM(LENGTH(content)+LENGTH(title)+LENGTH(link)+LENGTH(guid)) AS db_size - FROM ttrss_user_entries,ttrss_entries - WHERE owner_uid = '$uid' AND ref_id = id"); + case "pref-pub-items": + module_pref_pub_items($link); + break; // pref-pub-items - $db_size = round(db_fetch_result($result, 0, "db_size") / 1024); + case "globalUpdateFeeds": + // Update all feeds needing a update. + update_daemon_common($link, 0, true, true); + break; // globalUpdateFeeds - print ""; */ + case "pref-feed-browser": + module_pref_feed_browser($link); + break; // pref-feed-browser - print "
Username$login
Access level$access_level
".__('Registered')."$created
".__('Last logged in')."$last_login
".__('Stored articles')."$stored_articles
".__('Subscribed feeds count')."$num_feeds
Approx. used DB size$db_size KBytes
"; + case "pref-instances": + module_pref_instances($link); + break; // pref-instances - print "

".__('Subscribed feeds')."

"; + case "rss": + $feed = db_escape_string($_REQUEST["id"]); + $key = db_escape_string($_REQUEST["key"]); + $is_cat = $_REQUEST["is_cat"] != false; + $limit = (int)db_escape_string($_REQUEST["limit"]); - $result = db_query($link, "SELECT id,title,site_url FROM ttrss_feeds - WHERE owner_uid = '$uid' ORDER BY title"); + $search = db_escape_string($_REQUEST["q"]); + $match_on = db_escape_string($_REQUEST["m"]); + $search_mode = db_escape_string($_REQUEST["smode"]); + $view_mode = db_escape_string($_REQUEST["view-mode"]); - print ""; + print getGlobalUnread($link, $uid); - print "
"; + if ($fresh) { + print ";"; + print getFeedArticles($link, -3, false, true, $uid); + } - print "
-
"; + } else { + print "-1;User not found"; + } -// print ""; + break; // getUnread - } + case "digestTest": + print_r(prepare_headlines_digest($link, $_SESSION["uid"])); + break; // digestTest - if ($op == "pref-feed-browser") { - module_pref_feed_browser($link); - } + case "digestSend": + send_headlines_digests($link); + break; // digestSend - if ($op == "publish") { - $key = db_escape_string($_GET["key"]); + case "loading": + header("Content-type: text/html"); + print __("Loading, please wait...") . " " . + ""; + break; // loading - $result = db_query($link, "SELECT login, owner_uid - FROM ttrss_user_prefs, ttrss_users WHERE - pref_name = '_PREFS_PUBLISH_KEY' AND - value = '$key' AND - ttrss_users.id = owner_uid"); + case "getProfiles": + $login = db_escape_string($_REQUEST["login"]); + $password = db_escape_string($_REQUEST["password"]); - if (db_num_rows($result) == 1) { - $owner = db_fetch_result($result, 0, "owner_uid"); - $login = db_fetch_result($result, 0, "login"); + if (authenticate_user($link, $login, $password)) { + $result = db_query($link, "SELECT * FROM ttrss_settings_profiles + WHERE owner_uid = " . $_SESSION["uid"] . " ORDER BY title"); - generate_syndicated_feed($link, $owner, -2, false); + print ""; - if (!$_SESSION["uid"] && $user && $pass) { - authenticate_user($link, $user, $pass); - } + $_SESSION = array(); + } + break; // getprofiles - if ($_SESSION["uid"] || - http_authenticate_user($link)) { + case "pubsub": + $mode = db_escape_string($_REQUEST['hub_mode']); + $feed_id = db_escape_string($_REQUEST['id']); + $feed_url = db_escape_string($_REQUEST['hub_topic']); - generate_syndicated_feed($link, 0, $feed, $is_cat, - $search, $search_mode, $match_on); - } + // TODO: implement hub_verifytoken checking - } + $result = db_query($link, "SELECT feed_url FROM ttrss_feeds + WHERE id = '$feed_id'"); - if ($op == "labelFromSearch") { - $search = db_escape_string($_GET["search"]); - $search_mode = db_escape_string($_GET["smode"]); - $match_on = db_escape_string($_GET["match"]); - $is_cat = db_escape_string($_GET["is_cat"]); - $title = db_escape_string($_GET["title"]); - $feed = sprintf("%d", $_GET["feed"]); + $check_feed_url = db_fetch_result($result, 0, "feed_url"); - $label_qparts = array(); + if ($check_feed_url && ($check_feed_url == $feed_url || !$feed_url)) { + if ($mode == "subscribe") { - $search_expr = getSearchSql($search, $match_on); + db_query($link, "UPDATE ttrss_feeds SET pubsub_state = 2 + WHERE id = '$feed_id'"); - if ($is_cat) { - if ($feed != 0) { - $search_expr .= " AND ttrss_feeds.cat_id = $feed "; - } else { - $search_expr .= " AND ttrss_feeds.cat_id IS NULL "; - } - } else { - if ($search_mode == "all_feeds") { - // NOOP - } else if ($search_mode == "this_cat") { + print $_REQUEST['hub_challenge']; + return; + + } else if ($mode == "unsubscribe") { - $tmp_result = db_query($link, "SELECT cat_id - FROM ttrss_feeds WHERE id = '$feed'"); + db_query($link, "UPDATE ttrss_feeds SET pubsub_state = 0 + WHERE id = '$feed_id'"); - $cat_id = db_fetch_result($tmp_result, 0, "cat_id"); + print $_REQUEST['hub_challenge']; + return; + + } else if (!$mode) { + + // Received update ping, schedule feed update. + + update_rss_feed($link, $feed_id, true, true); - if ($cat_id > 0) { - $search_expr .= " AND ttrss_feeds.cat_id = $cat_id "; - } else { - $search_expr .= " AND ttrss_feeds.cat_id IS NULL "; } } else { - $search_expr .= " AND ttrss_feeds.id = $feed "; + header('HTTP/1.0 404 Not Found'); } - } + break; // pubsub - $search_expr = db_escape_string($search_expr); + case "logout": + logout_user(); + header("Location: tt-rss.php"); + break; // logout - print $search_expr; + case "fbexport": - if ($title) { - $result = db_query($link, - "INSERT INTO ttrss_labels (sql_exp,description,owner_uid) - VALUES ('$search_expr', '$title', '".$_SESSION["uid"]."')"); - } - } + $access_key = db_escape_string($_POST["key"]); - if ($op == "getUnread") { - $login = db_escape_string($_GET["login"]); + // TODO: rate limit checking using last_connected + $result = db_query($link, "SELECT id FROM ttrss_linked_instances + WHERE access_key = '$access_key'"); - header("Content-Type: text/plain; charset=utf-8"); + if (db_num_rows($result) == 1) { - $result = db_query($link, "SELECT id FROM ttrss_users WHERE login = '$login'"); + $instance_id = db_fetch_result($result, 0, "id"); - if (db_num_rows($result) == 1) { - $uid = db_fetch_result($result, 0, "id"); - print getGlobalUnread($link, $uid); - } else { - print "-1;User not found"; - } + $result = db_query($link, "SELECT feed_url, site_url, title, subscribers + FROM ttrss_feedbrowser_cache ORDER BY subscribers DESC LIMIT 100"); - $print_exec_time = false; - } + $feeds = array(); - if ($op == "digestTest") { - header("Content-Type: text/plain"); - print_r(prepare_headlines_digest($link, $_SESSION["uid"])); - $print_exec_time = false; + while ($line = db_fetch_assoc($result)) { + array_push($feeds, $line); + } - } + db_query($link, "UPDATE ttrss_linked_instances SET + last_status_in = 1 WHERE id = '$instance_id'"); - if ($op == "digestSend") { - header("Content-Type: text/plain"); - send_headlines_digests($link); - $print_exec_time = false; + print json_encode(array("feeds" => $feeds)); + } else { + print json_encode(array("error" => array("code" => 6))); + } + break; // fbexport - } + default: + header("Content-Type: text/plain"); + print json_encode(array("error" => array("code" => 7))); + break; // fallback + } // Select action according to $op value. + // We close the connection to database. db_close($link); ?> - - - -