Tiny Tiny RSS : Feedlist

"; $result = db_query($link, "SELECT id,sql_exp,description FROM ttrss_labels ORDER by description"); while ($line = db_fetch_assoc($result)) { $id = -$line["id"] - 11; error_reporting (0); $tmp_result = db_query($link, "SELECT count(id) as count FROM ttrss_entries WHERE " . $line["sql_exp"]); $count = db_fetch_result($tmp_result, 0, "count"); print ""; error_reporting (E_ERROR | E_WARNING | E_PARSE); } } function getFeedCounters($link) { $result = db_query($link, "SELECT id, (SELECT count(id) FROM ttrss_entries WHERE feed_id = ttrss_feeds.id AND unread = true) as count FROM ttrss_feeds"); while ($line = db_fetch_assoc($result)) { $id = $line["id"]; $count = $line["count"]; print ""; } } function outputFeedList($link) { print " Tiny Tiny RSS : Feedlist "; print "

$total_unread

"; getLabelCounters($link); print "

"; getFeedCounters($link); print "

"; getLabelCounters($link); getFeedCounters($link); print "

Tiny Tiny RSS : Article $id

Comments

"; print "

"; print ""; print ""; print "

Title:	" . $line["title"] . "
Link:	".$line["link"]." $entry_comments

"; print "

" . $feed_icon . "

"; print "

" . $line["content"] . "

"; print "

Tiny Tiny RSS : Feed $feed

$\"Updated\"$

$\"Reset$

$\"Set$

" . $line["title"] . "

Could not display feed (query failed). Please check match syntax or local configuration.
$update_pic	$marked_pic	".$line["updated"]."	$content_link	".$line["feed_title"]."	$content_link
No articles found.

Add feed

"; print ""; $lnum = 0; while ($line = db_fetch_assoc($result)) { $class = ($lnum % 2) ? "even" : "odd"; $feed_id = $line["id"]; $edit_feed_id = $_GET["id"]; if ($subop == "edit" && $feed_id != $edit_feed_id) { $class .= "Grayed"; } print ""; $icon_file = ICONS_DIR . "/$feed_id.ico"; if (file_exists($icon_file) && filesize($icon_file) > 0) { $feed_icon = ""; } else { $feed_icon = " "; } print ""; if (!$edit_feed_id || $subop != "edit") { print ""; print ""; print ""; } else if ($feed_id != $edit_feed_id) { print ""; print ""; print ""; } else { print ""; print ""; print ""; } if (!$line["last_updated"]) $line["last_updated"] = "Never"; print ""; print ""; ++$lnum; } if ($lnum == 0) { print ""; } print "
Select Title Link Last updated
$feed_icon " . $line["title"] . " " . $line["feed_url"] . " ".$line["title"]." ".$line["feed_url"]." " . $line["last_updated"] . "
No feeds defined.
"; print "

"; if ($subop == "edit") { print "Edit feed: "; } else { print " Selection: "; if (ENABLE_PREFS_CATCHUP_UNCATCHUP) { print " "; } print " All feeds: "; } } if ($op == "pref-filters") { $subop = $_GET["subop"]; if ($subop == "editSave") { $regexp = db_escape_string($_GET["r"]); $descr = db_escape_string($_GET["d"]); $match = db_escape_string($_GET["m"]); $filter_id = db_escape_string($_GET["id"]); $result = db_query($link, "UPDATE ttrss_filters SET reg_exp = '$regexp', description = '$descr', filter_type = (SELECT id FROM ttrss_filter_types WHERE description = '$match') WHERE id = '$filter_id'"); } if ($subop == "remove") { if (!WEB_DEMO_MODE) { $ids = split(",", $_GET["ids"]); foreach ($ids as $id) { db_query($link, "DELETE FROM ttrss_filters WHERE id = '$id'"); } } } if ($subop == "add") { if (!WEB_DEMO_MODE) { $regexp = db_escape_string($_GET["regexp"]); $match = db_escape_string($_GET["match"]); $result = db_query($link, "INSERT INTO ttrss_filters (reg_exp,filter_type) VALUES ('$regexp', (SELECT id FROM ttrss_filter_types WHERE description = '$match'))"); } } $result = db_query($link, "SELECT description FROM ttrss_filter_types ORDER BY description"); $filter_types = array(); while ($line = db_fetch_assoc($result)) { array_push($filter_types, $line["description"]); } print "
"; print_select("fadd_match", "Title", $filter_types); print" Add filter

"; $result = db_query($link, "SELECT id,reg_exp,description, (SELECT name FROM ttrss_filter_types WHERE id = filter_type) as filter_type_name, (SELECT description FROM ttrss_filter_types WHERE id = filter_type) as filter_type_descr FROM ttrss_filters ORDER by reg_exp"); print "

"; print ""; $lnum = 0; while ($line = db_fetch_assoc($result)) { $class = ($lnum % 2) ? "even" : "odd"; $filter_id = $line["id"]; $edit_filter_id = $_GET["id"]; if ($subop == "edit" && $filter_id != $edit_filter_id) { $class .= "Grayed"; } print ""; $line["regexp"] = htmlspecialchars($line["reg_exp"]); $line["description"] = htmlspecialchars($line["description"]); if (!$edit_filter_id || $subop != "edit") { if (!$line["description"]) $line["description"] = "[No description]"; print ""; print ""; print ""; print ""; } else if ($filter_id != $edit_filter_id) { if (!$line["description"]) $line["description"] = "[No description]"; print ""; print ""; print ""; print ""; } else { print ""; print ""; print ""; print ""; } print ""; ++$lnum; } if ($lnum == 0) { print ""; } print "
Select Filter expression Description Match
" . $line["reg_exp"] . " " . $line["description"] . " ".$line["filter_type_descr"]." ".$line["reg_exp"]." ".$line["description"]." ".$line["filter_type_descr"]." "; print_select("iedit_match", $line["filter_type_descr"], $filter_types); print "
No filters defined.
"; print "

"; if ($subop == "edit") { print "Edit feed: "; } else { print " Selection: "; } } if ($op == "pref-labels") { $subop = $_GET["subop"]; if ($subop == "editSave") { $sql_exp = $_GET["s"]; $descr = $_GET["d"]; $label_id = db_escape_string($_GET["id"]); // print "$sql_exp : $descr : $label_id"; $result = db_query($link, "UPDATE ttrss_labels SET sql_exp = '$sql_exp', description = '$descr' WHERE id = '$label_id'"); } if ($subop == "remove") { if (!WEB_DEMO_MODE) { $ids = split(",", $_GET["ids"]); foreach ($ids as $id) { db_query($link, "DELETE FROM ttrss_labels WHERE id = '$id'"); } } } if ($subop == "add") { if (!WEB_DEMO_MODE) { $exp = $_GET["exp"]; $result = db_query($link, "INSERT INTO ttrss_labels (sql_exp,description) VALUES ('$exp', '$exp')"); } } print ""; print"
Add label

"; $result = db_query($link, "SELECT id,sql_exp,description FROM ttrss_labels ORDER by description"); print "

"; print ""; $lnum = 0; while ($line = db_fetch_assoc($result)) { $class = ($lnum % 2) ? "even" : "odd"; $label_id = $line["id"]; $edit_label_id = $_GET["id"]; if ($subop == "edit" && $label_id != $edit_label_id) { $class .= "Grayed"; } print ""; $line["sql_exp"] = htmlspecialchars($line["sql_exp"]); $line["description"] = htmlspecialchars($line["description"]); if (!$edit_label_id || $subop != "edit") { if (!$line["description"]) $line["description"] = "[No caption]"; print ""; print ""; print ""; } else if ($label_id != $edit_label_id) { if (!$line["description"]) $line["description"] = "[No description]"; print ""; print ""; print ""; } else { print ""; print ""; print ""; } print ""; ++$lnum; } if ($lnum == 0) { print ""; } print "
Select SQL expression Caption
" . $line["sql_exp"] . " " . $line["description"] . " ".$line["sql_exp"]." ".$line["description"]."
No labels defined.
"; print "

"; if ($subop == "edit") { print "Edit label: "; } else { print " Selection: "; } } if ($op == "error") { print "

"; $msg = $_GET["msg"]; print $msg; print "

	Select	Title	Link	Last updated
$feed_icon		" . $line["title"] . "	" . $line["feed_url"] . "		".$line["title"]."	".$line["feed_url"]."	" . $line["last_updated"] . "
No feeds defined.

Select	Filter expression	Description	Match
	" . $line["reg_exp"] . "	" . $line["description"] . "	".$line["filter_type_descr"]."	".$line["reg_exp"]."	".$line["description"]."	".$line["filter_type_descr"]."	"; print_select("iedit_match", $line["filter_type_descr"], $filter_types); print "
No filters defined.

Select	SQL expression	Caption
	" . $line["sql_exp"] . "	" . $line["description"] . "	".$line["sql_exp"]."	".$line["description"]."
No labels defined.