";
print "
".__("Showing top 25 registered feeds, sorted by popularity:")."
";
# $result = db_query($link, "SELECT feed_url,count(id) AS subscribers
# FROM ttrss_feeds
# WHERE auth_login = '' AND auth_pass = '' AND private = false
# GROUP BY feed_url ORDER BY subscribers DESC LIMIT 25");
$owner_uid = $_SESSION["uid"];
$result = db_query($link, "SELECT feed_url,COUNT(id) AS subscribers
FROM ttrss_feeds WHERE (SELECT COUNT(id) = 0 FROM ttrss_feeds AS tf
WHERE tf.feed_url = ttrss_feeds.feed_url
AND owner_uid = '$owner_uid') GROUP BY feed_url
ORDER BY subscribers DESC LIMIT 25");
print "
";
print "
";
print "
";
}
if (subscribe_to_feed($link, $feed_url, $cat_id, $auth_login, $auth_pass)) {
print_notice(T_sprintf("Subscribed to
%s .", $feed_url));
} else {
print_warning(T_sprintf("Already subscribed to
%s .", $feed_url));
}
if ($p_from != 'tt-rss') {
$tt_uri = 'http://' . $_SERVER['SERVER_NAME'] .
preg_replace('/backend\.php.*$/',
'tt-rss.php', $_SERVER["REQUEST_URI"]);
$tp_uri = 'http://' . $_SERVER['SERVER_NAME'] .
preg_replace('/backend\.php.*$/',
'prefs.php', $_SERVER["REQUEST_URI"]);
print "
Return to Tiny Tiny RSS |";
$result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
feed_url = '$feed_url' AND owner_uid = " . $_SESSION["uid"]);
$feed_id = db_fetch_result($result, 0, "id");
if ($feed_id) {
print "
Edit subscription options | ";
}
print "Close this window .
";
print "
";
$action = $_REQUEST["action"];
if ($action == "save") {
$cat_title = db_escape_string(trim($_GET["title"]));
$cat_id = db_escape_string($_GET["id"]);
$result = db_query($link, "UPDATE ttrss_feed_categories SET
title = '$cat_title' WHERE id = '$cat_id' AND owner_uid = ".$_SESSION["uid"]);
}
if ($action == "add") {
if (!WEB_DEMO_MODE) {
$feed_cat = db_escape_string(trim($_GET["cat"]));
$result = db_query($link,
"SELECT id FROM ttrss_feed_categories
WHERE title = '$feed_cat' AND owner_uid = ".$_SESSION["uid"]);
if (db_num_rows($result) == 0) {
$result = db_query($link,
"INSERT INTO ttrss_feed_categories (owner_uid,title)
VALUES ('".$_SESSION["uid"]."', '$feed_cat')");
} else {
print_warning(T_sprintf("Category
$%s already exists in the database.",
$feed_cat));
}
}
}
if ($action == "remove") {
if (!WEB_DEMO_MODE) {
$ids = split(",", db_escape_string($_GET["ids"]));
foreach ($ids as $id) {
db_query($link, "BEGIN");
$result = db_query($link,
"SELECT count(id) as num_feeds FROM ttrss_feeds
WHERE cat_id = '$id'");
$num_feeds = db_fetch_result($result, 0, "num_feeds");
if ($num_feeds == 0) {
db_query($link, "DELETE FROM ttrss_feed_categories
WHERE id = '$id' AND owner_uid = " . $_SESSION["uid"]);
} else {
print format_warning(__("Unable to delete non empty feed categories."));
}
db_query($link, "COMMIT");
}
}
}
print "
";
$result = db_query($link, "SELECT title,id FROM ttrss_feed_categories
WHERE owner_uid = ".$_SESSION["uid"]."
ORDER BY title");
print "
";
if (db_num_rows($result) != 0) {
print "
";
print "
";
} else {
print "
".__('No feed categories defined.')."
";
}
print "
";
print "
";
if ($action == "edit") {
print "
";
print "
No feeds defined.
";
}
print "".__('Published articles are exported as a public RSS feed and can be subscribed by anyone who knows the address specified below.')."
";
$url_path = 'http://' . $_SERVER["HTTP_HOST"] . \
parse_url($_SERVER["REQUEST_URI"], PHP_URL_PATH);
$url_path .= "?op=publish&key=" . get_pref($link, "_PREFS_PUBLISH_KEY");
print "![](\"images/blank_icon.gif\"){kind=spacer}
";
}
$check_box = "";
$class = ($feedctr % 2) ? "even" : "odd";
print "![\"Tiny](\"images/ttrss_logo.png\"){kind=logo}