link, "SORT_HEADLINES_BY_FEED_DATE", $owner_uid)) { $date_sort_field = "updated"; } else { $date_sort_field = "date_entered"; } $qfh_ret = queryFeedHeadlines($this->link, $feed, $limit, $view_mode, $is_cat, $search, $search_mode, $match_on, "$date_sort_field DESC", $offset, $owner_uid); $result = $qfh_ret[0]; $feed_title = htmlspecialchars($qfh_ret[1]); $feed_site_url = $qfh_ret[2]; $last_error = $qfh_ret[3]; $feed_self_url = get_self_url_prefix() . "/public.php?op=rss&id=-2&key=" . get_feed_access_key($this->link, -2, false, $owner_uid); if (!$feed_site_url) $feed_site_url = get_self_url_prefix(); if ($format == 'atom') { $tpl = new MiniTemplator; $tpl->readTemplateFromFile("templates/generated_feed.txt"); $tpl->setVariable('FEED_TITLE', $feed_title, true); $tpl->setVariable('VERSION', VERSION, true); $tpl->setVariable('FEED_URL', htmlspecialchars($feed_self_url), true); if (PUBSUBHUBBUB_HUB && $feed == -2) { $tpl->setVariable('HUB_URL', htmlspecialchars(PUBSUBHUBBUB_HUB), true); $tpl->addBlock('feed_hub'); } $tpl->setVariable('SELF_URL', htmlspecialchars(get_self_url_prefix()), true); while ($line = db_fetch_assoc($result)) { $tpl->setVariable('ARTICLE_ID', htmlspecialchars($line['link']), true); $tpl->setVariable('ARTICLE_LINK', htmlspecialchars($line['link']), true); $tpl->setVariable('ARTICLE_TITLE', htmlspecialchars($line['title']), true); $tpl->setVariable('ARTICLE_EXCERPT', truncate_string(strip_tags($line["content_preview"]), 100, '...'), true); $content = sanitize($this->link, $line["content_preview"], false, $owner_uid); if ($line['note']) { $content = "
Article note: " . $line['note'] . "
" . $content; } $tpl->setVariable('ARTICLE_CONTENT', $content, true); $tpl->setVariable('ARTICLE_UPDATED_ATOM', date('c', strtotime($line["updated"])), true); $tpl->setVariable('ARTICLE_UPDATED_RFC822', date(DATE_RFC822, strtotime($line["updated"])), true); $tpl->setVariable('ARTICLE_AUTHOR', htmlspecialchars($line['author']), true); $tags = get_article_tags($this->link, $line["id"], $owner_uid); foreach ($tags as $tag) { $tpl->setVariable('ARTICLE_CATEGORY', htmlspecialchars($tag), true); $tpl->addBlock('category'); } $enclosures = get_article_enclosures($this->link, $line["id"]); foreach ($enclosures as $e) { $type = htmlspecialchars($e['content_type']); $url = htmlspecialchars($e['content_url']); $length = $e['duration']; $tpl->setVariable('ARTICLE_ENCLOSURE_URL', $url, true); $tpl->setVariable('ARTICLE_ENCLOSURE_TYPE', $type, true); $tpl->setVariable('ARTICLE_ENCLOSURE_LENGTH', $length, true); $tpl->addBlock('enclosure'); } $tpl->addBlock('entry'); } $tmp = ""; $tpl->addBlock('feed'); $tpl->generateOutputToString($tmp); header("Content-Type: text/xml; charset=utf-8"); print $tmp; } else if ($format == 'json') { $feed = array(); $feed['title'] = $feed_title; $feed['version'] = VERSION; $feed['feed_url'] = $feed_self_url; if (PUBSUBHUBBUB_HUB && $feed == -2) { $feed['hub_url'] = PUBSUBHUBBUB_HUB; } $feed['self_url'] = get_self_url_prefix(); $feed['articles'] = array(); while ($line = db_fetch_assoc($result)) { $article = array(); $article['id'] = $line['link']; $article['link'] = $line['link']; $article['title'] = $line['title']; $article['excerpt'] = truncate_string(strip_tags($line["content_preview"]), 100, '...'); $article['content'] = sanitize($this->link, $line["content_preview"], false, $owner_uid); $article['updated'] = date('c', strtotime($line["updated"])); if ($line['note']) $article['note'] = $line['note']; if ($article['author']) $article['author'] = $line['author']; $tags = get_article_tags($this->link, $line["id"], $owner_uid); if (count($tags) > 0) { $article['tags'] = array(); foreach ($tags as $tag) { array_push($article['tags'], $tag); } } $enclosures = get_article_enclosures($this->link, $line["id"]); if (count($enclosures) > 0) { $article['enclosures'] = array(); foreach ($enclosures as $e) { $type = $e['content_type']; $url = $e['content_url']; $length = $e['duration']; array_push($article['enclosures'], array("url" => $url, "type" => $type, "length" => $length)); } } array_push($feed['articles'], $article); } header("Content-Type: text/plain; charset=utf-8"); print json_encode($feed); } else { header("Content-Type: text/plain; charset=utf-8"); print json_encode(array("error" => array("message" => "Unknown format"))); } } function getUnread() { $login = db_escape_string($_REQUEST["login"]); $fresh = $_REQUEST["fresh"] == "1"; $result = db_query($this->link, "SELECT id FROM ttrss_users WHERE login = '$login'"); if (db_num_rows($result) == 1) { $uid = db_fetch_result($result, 0, "id"); print getGlobalUnread($this->link, $uid); if ($fresh) { print ";"; print getFeedArticles($this->link, -3, false, true, $uid); } } else { print "-1;User not found"; } } function getProfiles() { $login = db_escape_string($_REQUEST["login"]); $result = db_query($this->link, "SELECT * FROM ttrss_settings_profiles,ttrss_users WHERE ttrss_users.id = ttrss_settings_profiles.owner_uid AND login = '$login' ORDER BY title"); print ""; } function pubsub() { $mode = db_escape_string($_REQUEST['hub_mode']); $feed_id = (int) db_escape_string($_REQUEST['id']); $feed_url = db_escape_string($_REQUEST['hub_topic']); if (!PUBSUBHUBBUB_ENABLED) { header('HTTP/1.0 404 Not Found'); echo "404 Not found"; return; } // TODO: implement hub_verifytoken checking $result = db_query($this->link, "SELECT feed_url FROM ttrss_feeds WHERE id = '$feed_id'"); if (db_num_rows($result) != 0) { $check_feed_url = db_fetch_result($result, 0, "feed_url"); if ($check_feed_url && ($check_feed_url == $feed_url || !$feed_url)) { if ($mode == "subscribe") { db_query($this->link, "UPDATE ttrss_feeds SET pubsub_state = 2 WHERE id = '$feed_id'"); print $_REQUEST['hub_challenge']; return; } else if ($mode == "unsubscribe") { db_query($this->link, "UPDATE ttrss_feeds SET pubsub_state = 0 WHERE id = '$feed_id'"); print $_REQUEST['hub_challenge']; return; } else if (!$mode) { // Received update ping, schedule feed update. //update_rss_feed($this->link, $feed_id, true, true); db_query($this->link, "UPDATE ttrss_feeds SET last_update_started = '1970-01-01', last_updated = '1970-01-01' WHERE id = '$feed_id'"); } } else { header('HTTP/1.0 404 Not Found'); echo "404 Not found"; } } else { header('HTTP/1.0 404 Not Found'); echo "404 Not found"; } } function logout() { logout_user(); header("Location: index.php"); } function fbexport() { $access_key = db_escape_string($_POST["key"]); // TODO: rate limit checking using last_connected $result = db_query($this->link, "SELECT id FROM ttrss_linked_instances WHERE access_key = '$access_key'"); if (db_num_rows($result) == 1) { $instance_id = db_fetch_result($result, 0, "id"); $result = db_query($this->link, "SELECT feed_url, site_url, title, subscribers FROM ttrss_feedbrowser_cache ORDER BY subscribers DESC LIMIT 100"); $feeds = array(); while ($line = db_fetch_assoc($result)) { array_push($feeds, $line); } db_query($this->link, "UPDATE ttrss_linked_instances SET last_status_in = 1 WHERE id = '$instance_id'"); print json_encode(array("feeds" => $feeds)); } else { print json_encode(array("error" => array("code" => 6))); } } function share() { $uuid = db_escape_string($_REQUEST["key"]); $result = db_query($this->link, "SELECT ref_id, owner_uid FROM ttrss_user_entries WHERE uuid = '$uuid'"); if (db_num_rows($result) != 0) { header("Content-Type: text/html"); $id = db_fetch_result($result, 0, "ref_id"); $owner_uid = db_fetch_result($result, 0, "owner_uid"); $article = format_article($this->link, $id, false, true, $owner_uid); print_r($article['content']); } else { print "Article not found."; } } function 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"]); $offset = (int)db_escape_string($_REQUEST["offset"]); $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"]); $format = db_escape_string($_REQUEST['format']); if (!$format) $format = 'atom'; if (SINGLE_USER_MODE) { authenticate_user($this->link, "admin", null); } $owner_id = false; if ($key) { $result = db_query($this->link, "SELECT owner_uid FROM ttrss_access_keys WHERE access_key = '$key' AND feed_id = '$feed'"); if (db_num_rows($result) == 1) $owner_id = db_fetch_result($result, 0, "owner_uid"); } if ($owner_id) { $this->generate_syndicated_feed($owner_id, $feed, $is_cat, $limit, $offset, $search, $search_mode, $match_on, $view_mode, $format); } else { header('HTTP/1.1 403 Forbidden'); } } function globalUpdateFeeds() { include "rssfuncs.php"; // Update all feeds needing a update. update_daemon_common($this->link, 0, true, false); } function sharepopup() { header('Content-Type: text/html; charset=utf-8'); print " Tiny Tiny RSS "; $action = $_REQUEST["action"]; if ($_SESSION["uid"]) { if ($action == 'share') { $title = db_escape_string(strip_tags($_REQUEST["title"])); $url = db_escape_string(strip_tags($_REQUEST["url"])); $content = db_escape_string(strip_tags($_REQUEST["content"])); create_published_article($this->link, $title, $url, $content, $_SESSION["uid"]); print ""; } else { $title = htmlspecialchars($_REQUEST["title"]); $url = htmlspecialchars($_REQUEST["url"]); ?>

">
">
link, $login, $password)) { $_POST["password"] = ""; $_SESSION["language"] = $_POST["language"]; $_SESSION["ref_schema_version"] = get_schema_version($this->link, true); $_SESSION["bw_limit"] = !!$_POST["bw_limit"]; if ($_POST["profile"]) { $profile = db_escape_string($_POST["profile"]); $result = db_query($this->link, "SELECT id FROM ttrss_settings_profiles WHERE id = '$profile' AND owner_uid = " . $_SESSION["uid"]); if (db_num_rows($result) != 0) { $_SESSION["profile"] = $profile; $_SESSION["prefs_cache"] = array(); } } } else { $_SESSION["login_error_msg"] = __("Incorrect username or password"); } if ($_REQUEST['return']) { header("Location: " . $_REQUEST['return']); } else { header("Location: " . SELF_URL_PATH); } } } function subscribe() { if ($_SESSION["uid"]) { $feed_url = db_escape_string(trim($_REQUEST["feed_url"])); header('Content-Type: text/html; charset=utf-8'); print " Tiny Tiny RSS \"Tiny

".__("Subscribe to feed...")."

"; $rc = subscribe_to_feed($this->link, $feed_url); switch ($rc['code']) { case 0: print_warning(T_sprintf("Already subscribed to %s.", $feed_url)); break; case 1: print_notice(T_sprintf("Subscribed to %s.", $feed_url)); break; case 2: print_error(T_sprintf("Could not subscribe to %s.", $feed_url)); break; case 3: print_error(T_sprintf("No feeds found in %s.", $feed_url)); break; case 4: print_notice(__("Multiple feed URLs found.")); $feed_urls = $rc["feeds"]; break; case 5: print_error(T_sprintf("Could not subscribe to %s.
Can't download the Feed URL.", $feed_url)); break; } if ($feed_urls) { print "
"; print ""; print ""; print "
"; } $tp_uri = get_self_url_prefix() . "/prefs.php"; $tt_uri = get_self_url_prefix(); if ($rc['code'] <= 2){ $result = db_query($this->link, "SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]); $feed_id = db_fetch_result($result, 0, "id"); } else { $feed_id = 0; } print "

"; if ($feed_id) { print "

"; } print "

"; print ""; } else { render_login_form($this->link); } } function subscribe2() { $feed_url = db_escape_string(trim($_REQUEST["feed_url"])); $cat_id = db_escape_string($_REQUEST["cat_id"]); $from = db_escape_string($_REQUEST["from"]); /* only read authentication information from POST */ $auth_login = db_escape_string(trim($_POST["auth_login"])); $auth_pass = db_escape_string(trim($_POST["auth_pass"])); $rc = subscribe_to_feed($this->link, $feed_url, $cat_id, $auth_login, $auth_pass); switch ($rc) { case 1: print_notice(T_sprintf("Subscribed to %s.", $feed_url)); break; case 2: print_error(T_sprintf("Could not subscribe to %s.", $feed_url)); break; case 3: print_error(T_sprintf("No feeds found in %s.", $feed_url)); break; case 0: print_warning(T_sprintf("Already subscribed to %s.", $feed_url)); break; case 4: print_notice(__("Multiple feed URLs found.")); $feed_urls = get_feeds_from_html($feed_url); break; case 5: print_error(T_sprintf("Could not subscribe to %s.
Can't download the Feed URL.", $feed_url)); break; } if ($feed_urls) { print "
"; print ""; print ""; print ""; print ""; print "
"; } $tp_uri = get_self_url_prefix() . "/prefs.php"; $tt_uri = get_self_url_prefix(); if ($rc <= 2){ $result = db_query($this->link, "SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]); $feed_id = db_fetch_result($result, 0, "id"); } else { $feed_id = 0; } print "

"; if ($feed_id) { print "

"; } print "

"; print ""; } function index() { header("Content-Type: text/plain"); print json_encode(array("error" => array("code" => 7))); } } ?>