"; print ""; if (get_pref($link, 'ENABLE_FEED_CATS')) { print ""; } 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 ""; $edit_title = htmlspecialchars(db_unescape_string($line["title"])); $edit_link = htmlspecialchars(db_unescape_string($line["feed_url"])); $edit_cat = htmlspecialchars(db_unescape_string($line["category"])); if (!$edit_cat) $edit_cat = "Uncategorized"; if (!$edit_feed_id || $subop != "edit") { print ""; $edit_title = truncate_string($edit_title, 40); $edit_link = truncate_string($edit_link, 60); print ""; print ""; if (get_pref($link, 'ENABLE_FEED_CATS')) { print ""; } if ($line["update_interval"] == "0") $line["update_interval"] = "Default"; print ""; if ($line["purge_interval"] == "0") $line["purge_interval"] = "Default"; if ($line["purge_interval"] < 0) $line["purge_interval"] = "Disabled"; print ""; } else if ($feed_id != $edit_feed_id) { print ""; $edit_title = truncate_string($edit_title, 40); $edit_link = truncate_string($edit_link, 60); print ""; print ""; if (get_pref($link, 'ENABLE_FEED_CATS')) { print ""; } if ($line["update_interval"] == "0") $line["update_interval"] = "Default"; print ""; if ($line["purge_interval"] == "0") $line["purge_interval"] = "Default"; if ($line["purge_interval"] < 0) $line["purge_interval"] = "Disabled"; print ""; } else { print ""; print ""; print ""; if (get_pref($link, 'ENABLE_FEED_CATS')) { print ""; print ""; } print ""; print ""; } /* if (!$line["last_updated"]) $line["last_updated"] = "Never"; print ""; */ print ""; ++$lnum; } print "

Select

Title

Link

Categories

"; print ""; $lnum = 0; while ($line = db_fetch_assoc($result)) { $class = ($lnum % 2) ? "even" : "odd"; $cat_id = $line["id"]; $edit_cat_id = $_GET["id"]; if ($subop == "editCat" && $cat_id != $edit_cat_id) { $class .= "Grayed"; } print ""; $edit_title = htmlspecialchars(db_unescape_string($line["title"])); if (!$edit_cat_id || $subop != "editCat") { print ""; print ""; } else if ($cat_id != $edit_cat_id) { print ""; print ""; } else { print ""; print ""; } print ""; ++$lnum; } print "

Select	Title
	" . $edit_title . "		$edit_title

"; print "

"; if ($subop == "editCat") { print "Edit category: "; } else { print " Selection: "; } } else { print "

Import OPML

"; print_select("fadd_match", "Title", $filter_types); print " "; print ""; $result = db_query($link, "SELECT ttrss_filters.id AS id,reg_exp, ttrss_filters.description AS description, ttrss_filter_types.name AS filter_type_name, ttrss_filter_types.description AS filter_type_descr, feed_id, (SELECT title FROM ttrss_feeds WHERE id = feed_id) AS feed_title FROM ttrss_filters,ttrss_filter_types WHERE filter_type = ttrss_filter_types.id AND ttrss_filters.owner_uid = ".$_SESSION["uid"]." ORDER by reg_exp"); if (db_num_rows($result) != 0) { 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 (!$line["feed_title"]) $line["feed_title"] = "All feeds"; if (!$edit_filter_id || $subop != "edit") { if (!$line["description"]) $line["description"] = "[No description]"; print ""; print ""; print ""; print ""; print ""; } else if ($filter_id != $edit_filter_id) { if (!$line["description"]) $line["description"] = "[No description]"; print ""; print ""; print ""; print ""; print ""; } else { print ""; print ""; print ""; print ""; print ""; print ""; } print ""; ++$lnum; } if ($lnum == 0) { print ""; } print "
Select Filter expression Feed Match Description
" . $line["reg_exp"] . " " . $line["feed_title"] . " " . $line["filter_type_descr"] . " " . $line["description"] . " ".$line["reg_exp"]." ".$line["feed_title"]." ".$line["filter_type_descr"]." ".$line["description"]." "; print " "; print_select("iedit_match", $line["filter_type_descr"], $filter_types); print "
No filters defined.
"; print "

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

No filters defined.

"; } } if ($op == "pref-labels") { $subop = $_GET["subop"]; if ($subop == "test") { $expr = $_GET["expr"]; $descr = $_GET["descr"]; print "

"; print "

Label «$descr»

"; // print "

Expression: $expr

"; $result = db_query($link, "SELECT count(id) AS num_matches FROM ttrss_entries,ttrss_user_entries WHERE ($expr) AND ttrss_user_entries.ref_id = ttrss_entries.id AND owner_uid = " . $_SESSION["uid"]); $num_matches = db_fetch_result($result, 0, "num_matches");; if ($num_matches > 0) { print "

Query returned $num_matches matches, first 5:

"; $result = db_query($link, "SELECT title, (SELECT title FROM ttrss_feeds WHERE id = feed_id) AS feed_title FROM ttrss_entries,ttrss_user_entries WHERE ($expr) AND ttrss_user_entries.ref_id = ttrss_entries.id AND owner_uid = " . $_SESSION["uid"] . " ORDER BY date_entered DESC LIMIT 5"); print "

".$line["title"]. " (".$line["feed_title"].")

"; } else { print "

Query didn't return any matches.

"; } print "

"; print "

"; return; } 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) { // no escaping is done here on purpose $exp = trim($_GET["exp"]); $result = db_query($link, "INSERT INTO ttrss_labels (sql_exp,description,owner_uid) VALUES ('$exp', '$exp', '".$_SESSION["uid"]."')"); } } print "

"; print"

"; $result = db_query($link, "SELECT id,sql_exp,description FROM ttrss_labels WHERE owner_uid = ".$_SESSION["uid"]." ORDER by description"); print "

PLACEHOLDER

"; if (db_num_rows($result) != 0) { 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: "; } } else { print "

No labels defined.

"; } } if ($op == "error") { print "

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

"; } if ($op == "help") { print " Tiny Tiny RSS : Help "; $tid = sprintf("%d", $_GET["tid"]); /* FIXME this badly needs real implementation */ print "

"; ?>

Help for SQL expressions

Description

The «SQL expression» is added to WHERE clause of view feed query. You can match on ttrss_entries table fields and even use subselect to query additional information. This functionality is considered to be advanced and requires basic understanding of SQL.

Examples

unread = true

Matches all unread articles

title like '%Linux%'

Matches all articles which mention Linux in the title. You get the idea.

See the database schema included in the distribution package for gruesome details.

(Close this window)

"; print "

"; print ""; $lnum = 0; while ($line = db_fetch_assoc($result)) { $class = ($lnum % 2) ? "even" : "odd"; $uid = $line["id"]; $edit_uid = $_GET["id"]; if ($uid == $_SESSION["uid"] || ($subop == "edit" && $uid != $edit_uid)) { $class .= "Grayed"; } print ""; $line["login"] = htmlspecialchars($line["login"]); if ($uid == $_SESSION["uid"]) { print ""; print ""; print ""; } else if (!$edit_uid || $subop != "edit") { print ""; print ""; print ""; } else if ($uid != $edit_uid) { print ""; print ""; print ""; } else { print ""; print ""; print ""; } print ""; print ""; ++$lnum; } print "

Select

Username

Access Level

Last login

".$line["login"]."

".$line["access_level"]."

" . $line["login"] . "

" . $line["access_level"] . "

".$line["login"]."

".$line["access_level"]."

".$line["last_login"]."

"; print "

"; if ($subop == "edit") { print "Edit label: "; } else { print " Selection: "; } } if ($op == "user-details") { if (WEB_DEMO_MODE || $_SESSION["access_level"] < 10) { return; } /* print " Tiny Tiny RSS : User Details "; */ $uid = sprintf("%d", $_GET["id"]); 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 FROM ttrss_users WHERE id = '$uid'"); if (db_num_rows($result) == 0) { print "

User not found

"; return; } print "

User Details

"; print ""; $login = db_fetch_result($result, 0, "login"); $last_login = db_fetch_result($result, 0, "last_login"); $access_level = db_fetch_result($result, 0, "access_level"); $stored_articles = db_fetch_result($result, 0, "stored_articles"); print ""; print ""; print ""; print ""; $result = db_query($link, "SELECT COUNT(id) as num_feeds FROM ttrss_feeds WHERE owner_uid = '$uid'"); $num_feeds = db_fetch_result($result, 0, "num_feeds"); print ""; /* $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"); $db_size = round(db_fetch_result($result, 0, "db_size") / 1024); print ""; */ print "

Username	$login
Access level	$access_level
Last logged in	$last_login
Stored articles	$stored_articles
Subscribed feeds count	$num_feeds
Approx. used DB size	$db_size KBytes

"; print "

Subscribed feeds

"; $result = db_query($link, "SELECT id,title,feed_url FROM ttrss_feeds WHERE owner_uid = '$uid' ORDER BY title"); print "

$feed_icon ".$line["title"]."

"; print "

" . $line["title"] . "
".$line["link"]." $entry_comments	$tags_str
Tags:	$tags_str

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.

$active_section
Option	Value
" . $line["short_desc"]; if ($help_text) print " $help_text "; print "	"; if ($type_name == "bool") { // print_select($pref_name, $value, array("true", "false")); if ($value == "true") { $value = "Yes"; } else { $value = "No"; } print_radio($pref_name, $value, array("Yes", "No")); } else { print ""; } print "

Link	$site_url (feed)
Feed URL	$feed_url
Last updated	$last_updated
Total articles	$total
Unread articles	$unread
Starred articles	$marked
Subscribed users	$subscribed

Edit Feeds

Edit Categories

Categories

Import OPML

Label «$descr»

Help for SQL expressions

Description

Examples

Authentication

$active_section

User not found

User Details

Subscribed feeds

$feed_icon $title

Latest headlines

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

Authentication
Old password
New password