dbh->num_rows($result) != 0) { $ts = strtotime($this->dbh->fetch_result($result, 0, "date_entered")); if (isset($_SERVER['HTTP_IF_MODIFIED_SINCE']) && strtotime($_SERVER['HTTP_IF_MODIFIED_SINCE']) >= $ts) { header('HTTP/1.0 304 Not Modified'); return; } $last_modified = gmdate("D, d M Y H:i:s", $ts) . " GMT"; header("Last-Modified: $last_modified", true); } $qfh_ret = queryFeedHeadlines($feed, $limit, $view_mode, $is_cat, $search, $search_mode, $date_sort_field, $offset, $owner_uid, false, 0, false, true); $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(-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 = $this->dbh->fetch_assoc($result)) { $tpl->setVariable('ARTICLE_ID', htmlspecialchars($orig_guid ? $line['link'] : get_self_url_prefix() . "/public.php?url=" . urlencode($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($line["content_preview"], false, $owner_uid); if ($line['note']) { $content = "
Article note: " . $line['note'] . "
" . $content; $tpl->setVariable('ARTICLE_NOTE', htmlspecialchars($line['note']), true); } $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); $tpl->setVariable('ARTICLE_SOURCE_LINK', htmlspecialchars($line['site_url']), true); $tpl->setVariable('ARTICLE_SOURCE_TITLE', htmlspecialchars($line['feed_title']), true); $tags = get_article_tags($line["id"], $owner_uid); foreach ($tags as $tag) { $tpl->setVariable('ARTICLE_CATEGORY', htmlspecialchars($tag), true); $tpl->addBlock('category'); } $enclosures = get_article_enclosures($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); if (@!$_REQUEST["noxml"]) { header("Content-Type: text/xml; charset=utf-8"); } else { header("Content-Type: text/plain; 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 = $this->dbh->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($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($line["id"], $owner_uid); if (count($tags) > 0) { $article['tags'] = array(); foreach ($tags as $tag) { array_push($article['tags'], $tag); } } $enclosures = get_article_enclosures($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/json; 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 = $this->dbh->escape_string($_REQUEST["login"]); $fresh = $_REQUEST["fresh"] == "1"; $result = $this->dbh->query("SELECT id FROM ttrss_users WHERE login = '$login'"); if ($this->dbh->num_rows($result) == 1) { $uid = $this->dbh->fetch_result($result, 0, "id"); print getGlobalUnread($uid); if ($fresh) { print ";"; print getFeedArticles(-3, false, true, $uid); } } else { print "-1;User not found"; } } function getProfiles() { $login = $this->dbh->escape_string($_REQUEST["login"]); $result = $this->dbh->query("SELECT ttrss_settings_profiles.* 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 = $this->dbh->escape_string($_REQUEST['hub_mode']); $feed_id = (int) $this->dbh->escape_string($_REQUEST['id']); $feed_url = $this->dbh->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 = $this->dbh->query("SELECT feed_url FROM ttrss_feeds WHERE id = '$feed_id'"); if ($this->dbh->num_rows($result) != 0) { $check_feed_url = $this->dbh->fetch_result($result, 0, "feed_url"); if ($check_feed_url && ($check_feed_url == $feed_url || !$feed_url)) { if ($mode == "subscribe") { $this->dbh->query("UPDATE ttrss_feeds SET pubsub_state = 2 WHERE id = '$feed_id'"); print $_REQUEST['hub_challenge']; return; } else if ($mode == "unsubscribe") { $this->dbh->query("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($feed_id, true, true); $this->dbh->query("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 share() { $uuid = $this->dbh->escape_string($_REQUEST["key"]); $result = $this->dbh->query("SELECT ref_id, owner_uid FROM ttrss_user_entries WHERE uuid = '$uuid'"); if ($this->dbh->num_rows($result) != 0) { header("Content-Type: text/html"); $id = $this->dbh->fetch_result($result, 0, "ref_id"); $owner_uid = $this->dbh->fetch_result($result, 0, "owner_uid"); $article = format_article($id, false, true, $owner_uid); print_r($article['content']); } else { print "Article not found."; } } function rss() { $feed = $this->dbh->escape_string($_REQUEST["id"]); $key = $this->dbh->escape_string($_REQUEST["key"]); $is_cat = sql_bool_to_bool($_REQUEST["is_cat"]); $limit = (int)$this->dbh->escape_string($_REQUEST["limit"]); $offset = (int)$this->dbh->escape_string($_REQUEST["offset"]); $search = $this->dbh->escape_string($_REQUEST["q"]); $search_mode = $this->dbh->escape_string($_REQUEST["smode"]); $view_mode = $this->dbh->escape_string($_REQUEST["view-mode"]); $order = $this->dbh->escape_string($_REQUEST["order"]); $format = $this->dbh->escape_string($_REQUEST['format']); $orig_guid = !sql_bool_to_bool($_REQUEST["no_orig_guid"]); if (!$format) $format = 'atom'; if (SINGLE_USER_MODE) { authenticate_user("admin", null); } $owner_id = false; if ($key) { $result = $this->dbh->query("SELECT owner_uid FROM ttrss_access_keys WHERE access_key = '$key' AND feed_id = '$feed'"); if ($this->dbh->num_rows($result) == 1) $owner_id = $this->dbh->fetch_result($result, 0, "owner_uid"); } if ($owner_id) { $this->generate_syndicated_feed($owner_id, $feed, $is_cat, $limit, $offset, $search, $search_mode, $view_mode, $format, $order, $orig_guid); } else { header('HTTP/1.1 403 Forbidden'); } } function globalUpdateFeeds() { include "rssfuncs.php"; // Update all feeds needing a update. update_daemon_common(0, true, false); housekeeping_common(false); PluginHost::getInstance()->run_hooks(PluginHost::HOOK_UPDATE_TASK, "hook_update_task", $op); } function sharepopup() { if (SINGLE_USER_MODE) { login_sequence(); } header('Content-Type: text/html; charset=utf-8'); print "Tiny Tiny RSS"; stylesheet_tag("css/utility.css"); javascript_tag("lib/prototype.js"); javascript_tag("lib/scriptaculous/scriptaculous.js?load=effects,dragdrop,controls"); print " "; $action = $_REQUEST["action"]; if ($_SESSION["uid"]) { if ($action == 'share') { $title = $this->dbh->escape_string(strip_tags($_REQUEST["title"])); $url = $this->dbh->escape_string(strip_tags($_REQUEST["url"])); $content = $this->dbh->escape_string(strip_tags($_REQUEST["content"])); $labels = $this->dbh->escape_string(strip_tags($_REQUEST["labels"])); Article::create_published_article($title, $url, $content, $labels, $_SESSION["uid"]); print ""; } else { $title = htmlspecialchars($_REQUEST["title"]); $url = htmlspecialchars($_REQUEST["url"]); ?>

">
">
dbh->escape_string($_POST["login"]); $password = $_POST["password"]; $remember_me = $_POST["remember_me"]; if ($remember_me) { session_set_cookie_params(SESSION_COOKIE_LIFETIME); } else { session_set_cookie_params(0); } @session_start(); if (authenticate_user($login, $password)) { $_POST["password"] = ""; if (get_schema_version() >= 120) { $_SESSION["language"] = get_pref("USER_LANGUAGE", $_SESSION["uid"]); } $_SESSION["ref_schema_version"] = get_schema_version(true); $_SESSION["bw_limit"] = !!$_POST["bw_limit"]; if ($_POST["profile"]) { $profile = $this->dbh->escape_string($_POST["profile"]); $result = $this->dbh->query("SELECT id FROM ttrss_settings_profiles WHERE id = '$profile' AND owner_uid = " . $_SESSION["uid"]); if ($this->dbh->num_rows($result) != 0) { $_SESSION["profile"] = $profile; } } } else { $_SESSION["login_error_msg"] = __("Incorrect username or password"); user_error("Failed login attempt from {$_SERVER['REMOTE_ADDR']}", E_USER_WARNING); } if ($_REQUEST['return']) { header("Location: " . $_REQUEST['return']); } else { header("Location: " . SELF_URL_PATH); } } } function subscribe() { if (SINGLE_USER_MODE) { login_sequence(); } if ($_SESSION["uid"]) { $feed_url = $this->dbh->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($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 = $this->dbh->query("SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]); $feed_id = $this->dbh->fetch_result($result, 0, "id"); } else { $feed_id = 0; } print "

"; if ($feed_id) { print "

"; } print "

"; print "
"; } else { render_login_form(); } } function subscribe2() { $feed_url = $this->dbh->escape_string(trim($_REQUEST["feed_url"])); $cat_id = $this->dbh->escape_string($_REQUEST["cat_id"]); $from = $this->dbh->escape_string($_REQUEST["from"]); $feed_urls = array(); /* only read authentication information from POST */ $auth_login = $this->dbh->escape_string(trim($_POST["auth_login"])); $auth_pass = $this->dbh->escape_string(trim($_POST["auth_pass"])); $rc = subscribe_to_feed($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.")); $contents = @fetch_file_contents($url, false, $auth_login, $auth_pass); if (is_html($contents)) { $feed_urls = get_feeds_from_html($url, $contents); } 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 = $this->dbh->query("SELECT id FROM ttrss_feeds WHERE feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]); $feed_id = $this->dbh->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))); } function forgotpass() { startup_gettext(); header('Content-Type: text/html; charset=utf-8'); print "Tiny Tiny RSS"; stylesheet_tag("css/utility.css"); javascript_tag("lib/prototype.js"); print " "; print ''; print "

".__("Password recovery")."

"; print "
"; @$method = $_POST['method']; if (!$method) { print_notice(__("You will need to provide valid account name and email. New password will be sent on your email address.")); print "
"; print ""; print ""; print "
"; print ""; print ""; print "
"; print "
"; print ""; print ""; print "
"; print "
"; print ""; print ""; print "
"; print "

"; print ""; print "

"; } else if ($method == 'do') { $login = $this->dbh->escape_string($_POST["login"]); $email = $this->dbh->escape_string($_POST["email"]); $test = $this->dbh->escape_string($_POST["test"]); if (($test != 4 && $test != 'four') || !$email || !$login) { print_error(__('Some of the required form parameters are missing or incorrect.')); print "
"; } else { $result = $this->dbh->query("SELECT id FROM ttrss_users WHERE login = '$login' AND email = '$email'"); if ($this->dbh->num_rows($result) != 0) { $id = $this->dbh->fetch_result($result, 0, "id"); Pref_Users::resetUserPassword($id, false); print "

"; print "

"."Completed."."

"; print "
"; } else { print_error(__("Sorry, login and email combination not found.")); print "
"; } } } print "
"; print ""; print ""; } function dbupdate() { startup_gettext(); if (!SINGLE_USER_MODE && $_SESSION["access_level"] < 10) { $_SESSION["login_error_msg"] = __("Your access level is insufficient to run this script."); render_login_form(); exit; } ?> Database Updater

isUpdateRequired()) { print "

Performing updates

"; print "

Updating to schema version " . SCHEMA_VERSION . "

"; print ""; print_warning("One of the updates failed. Either retry the process or perform updates manually."); print "

"; break; } else { print "OK!"; } } print ""; print_notice("Your Tiny Tiny RSS database is now updated to the latest version."); print "

"; } else { print "

Your database is up to date.

"; print "

"; } } else { if ($updater->isUpdateRequired()) { print "

Database update required

"; print "

"; printf("Your Tiny Tiny RSS database needs update to the latest version: %d to %d.", $updater->getSchemaVersion(), SCHEMA_VERSION); print "

"; print_warning("Please backup your database before proceeding."); print "
"; } else { print_notice("Tiny Tiny RSS database is up to date."); print "

"; } } ?>