+
+ function markArticlesById($link, $ids, $cmode) {
+
+ $tmp_ids = array();
+
+ foreach ($ids as $id) {
+ array_push($tmp_ids, "ref_id = '$id'");
+ }
+
+ $ids_qpart = join(" OR ", $tmp_ids);
+
+ if ($cmode == 0) {
+ db_query($link, "UPDATE ttrss_user_entries SET
+ marked = false,last_read = NOW()
+ WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
+ } else if ($cmode == 1) {
+ db_query($link, "UPDATE ttrss_user_entries SET
+ marked = true
+ WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
+ } else {
+ db_query($link, "UPDATE ttrss_user_entries SET
+ marked = NOT marked,last_read = NOW()
+ WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
+ }
+ }
+
+ function catchupArticlesById($link, $ids, $cmode) {
+
+ $tmp_ids = array();
+
+ foreach ($ids as $id) {
+ array_push($tmp_ids, "ref_id = '$id'");
+ }
+
+ $ids_qpart = join(" OR ", $tmp_ids);
+
+ if ($cmode == 0) {
+ db_query($link, "UPDATE ttrss_user_entries SET
+ unread = false,last_read = NOW()
+ WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
+ } else if ($cmode == 1) {
+ db_query($link, "UPDATE ttrss_user_entries SET
+ unread = true
+ WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
+ } else {
+ db_query($link, "UPDATE ttrss_user_entries SET
+ unread = NOT unread,last_read = NOW()
+ WHERE ($ids_qpart) AND owner_uid = " . $_SESSION["uid"]);
+ }
+ }
+
+ function escape_for_form($s) {
+ return htmlspecialchars(db_unescape_string($s));
+ }
+
+ function make_guid_from_title($title) {
+ return preg_replace("/[ \"\',.:;]/", "-",
+ mb_strtolower(strip_tags($title)));
+ }
+
+ function print_headline_subtoolbar($link, $feed_site_url, $feed_title,
+ $bottom = false, $rtl_content = false, $feed_id = 0,
+ $is_cat = false, $search = false, $match_on = false,
+ $search_mode = false, $offset = 0) {
+
+ $user_page_offset = $offset + 1;
+
+ if (!$bottom) {
+ $class = "headlinesSubToolbar";
+ $tid = "headlineActionsTop";
+ } else {
+ $class = "headlinesSubToolbar";
+ $tid = "headlineActionsBottom";
+ }
+
+ print "<table class=\"$class\" id=\"$tid\"
+ width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tr>";
+
+ if ($rtl_content) {
+ $rtl_cpart = "RTL";
+ } else {
+ $rtl_cpart = "";
+ }
+
+ $page_prev_link = "javascript:viewFeedGoPage(-1)";
+ $page_next_link = "javascript:viewFeedGoPage(1)";
+ $page_first_link = "javascript:viewFeedGoPage(0)";
+
+ $catchup_page_link = "javascript:catchupPage()";
+ $catchup_feed_link = "javascript:catchupCurrentFeed()";
+
+ if (!get_pref($link, 'COMBINED_DISPLAY_MODE')) {
+
+ $sel_all_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, '', true)";
+ $sel_unread_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', true, 'Unread', true)";
+ $sel_none_link = "javascript:selectTableRowsByIdPrefix('headlinesList', 'RROW-', 'RCHK-', false)";
+
+ $tog_unread_link = "javascript:selectionToggleUnread()";
+ $tog_marked_link = "javascript:selectionToggleMarked()";
+
+ } else {
+
+ $sel_all_link = "javascript:cdmSelectArticles('all')";
+ $sel_unread_link = "javascript:cdmSelectArticles('unread')";
+ $sel_none_link = "javascript:cdmSelectArticles('none')";
+
+ $tog_unread_link = "javascript:selectionToggleUnread(true)";
+ $tog_marked_link = "javascript:selectionToggleMarked(true)";
+
+ }
+
+ if (!strstr($_SESSION["client.userAgent"], "MSIE")) {
+
+ print "<td class=\"headlineActions$rtl_cpart\">
+ <ul class=\"headlineDropdownMenu\">
+ <li class=\"top2\">
+ Select:
+ <a href=\"$sel_all_link\">All</a>,
+ <a href=\"$sel_unread_link\">Unread</a>,
+ <a href=\"$sel_none_link\">None</a></li>
+ <li class=\"vsep\"> </li>
+ <li class=\"top\">Selection<ul>
+ <li onclick=\"$tog_unread_link\">Toggle unread</li>
+ <li onclick=\"$tog_marked_link\">Toggle starred</li></ul></li>
+ <li class=\"vsep\"> </li>
+ <li class=\"top\"><a href=\"$catchup_page_link\">Mark as read</a><ul>
+ <li onclick=\"$catchup_page_link\">This page</li>
+ <li onclick=\"$catchup_feed_link\">Entire feed</li></ul></li>
+ <li class=\"vsep\"> </li>
+ <!-- <li class=\"top2\">
+ Page:
+ <a href=\"$page_prev_link\">Previous</a>,
+ <a href=\"$page_next_link\">Next</a></li> -->
+
+ <li class=\"top\"><a href=\"$page_next_link\">Next page</a><ul>
+ <li onclick=\"$page_prev_link\">Previous page</li>
+ <li onclick=\"$page_first_link\">First page</li></ul></li>
+ </ul>
+
+ </td>";
+
+ } else {
+ // old style subtoolbar:
+
+ print "<td class=\"headlineActions$rtl_cpart\">".
+ _('Select:')."
+ <a href=\"$sel_all_link\">All</a>,
+ <a href=\"$sel_unread_link\">Unread</a>,
+ <a href=\"$sel_none_link\">None</a>
+ ".
+ _('Toggle:')." <a href=\"$tog_unread_link\">Unread</a>,
+ <a href=\"$tog_marked_link\">Starred</a>
+ ".
+ _('Mark as read:')."
+ <a href=\"#\" onclick=\"$catchup_page_link\">Page</a>,
+ <a href=\"#\" onclick=\"$catchup_feed_link\">Feed</a>";
+ print "</td>";
+
+ }
+
+ if ($search && $feed_id >= 0 && get_pref($link, 'ENABLE_LABELS') && GLOBAL_ENABLE_LABELS) {
+ print "<td class=\"headlineActions$rtl_cpart\">
+ <a href=\"javascript:labelFromSearch('$search', '$search_mode',
+ '$match_on', '$feed_id', '$is_cat');\">
+ "._('Convert to Label')."</a></td>";
+ }
+
+ print "<td class=\"headlineTitle$rtl_cpart\">";
+
+ if ($feed_site_url) {
+ if (!$bottom) {
+ $target = "target=\"_blank\"";
+ }
+ print "<a $target href=\"$feed_site_url\">$feed_title</a>";
+ } else {
+ print $feed_title;
+ }
+
+ if ($search) {
+ $search_q = "&q=$search&m=$match_on&smode=$search_mode";
+ }
+
+ if ($user_page_offset > 1) {
+ print " [$user_page_offset] ";
+ }
+
+ if (!$bottom) {
+ print "
+ <a target=\"_new\"
+ href=\"backend.php?op=rss&id=$feed_id&is_cat=$is_cat$search_q\">
+ <img class=\"noborder\"
+ alt=\"Generated feed\" src=\"images/feed-icon-12x12.png\">
+ </a>";
+ }
+
+ print "</td>";
+ print "</tr></table>";
+
+ }
+
+ function outputFeedList($link, $tags = false) {
+
+ print "<ul class=\"feedList\" id=\"feedList\">\n";
+
+ $owner_uid = $_SESSION["uid"];
+
+ /* virtual feeds */
+
+ if (get_pref($link, 'ENABLE_FEED_CATS')) {
+ print "<li class=\"feedCat\">"._('Special')."</li>";
+ print "<li id=\"feedCatHolder\"><ul class=\"feedCatList\">";
+ }
+
+ $num_starred = getFeedUnread($link, -1);
+
+ $class = "virt";
+
+ if ($num_starred > 0) $class .= "Unread";
+
+ printFeedEntry(-1, $class, _("Starred articles"), $num_starred,
+ "images/mark_set.png", $link);
+
+ if (get_pref($link, 'ENABLE_FEED_CATS')) {
+ print "</ul>\n";
+ }
+
+ if (!$tags) {
+
+ if (GLOBAL_ENABLE_LABELS && get_pref($link, 'ENABLE_LABELS')) {
+
+ $result = db_query($link, "SELECT id,sql_exp,description FROM
+ ttrss_labels WHERE owner_uid = '$owner_uid' ORDER by description");
+
+ if (db_num_rows($result) > 0) {
+ if (get_pref($link, 'ENABLE_FEED_CATS')) {
+ print "<li class=\"feedCat\">"._('Labels')."</li>";
+ print "<li id=\"feedCatHolder\"><ul class=\"feedCatList\">";
+ } else {
+ print "<li><hr></li>";
+ }
+ }
+
+ while ($line = db_fetch_assoc($result)) {
+
+ error_reporting (0);
+
+ $label_id = -$line['id'] - 11;
+ $count = getFeedUnread($link, $label_id);
+
+ $class = "label";
+
+ if ($count > 0) {
+ $class .= "Unread";
+ }
+
+ error_reporting (DEFAULT_ERROR_LEVEL);
+
+ printFeedEntry($label_id,
+ $class, db_unescape_string($line["description"]),
+ $count, "images/label.png", $link);
+
+ }
+
+ if (db_num_rows($result) > 0) {
+ if (get_pref($link, 'ENABLE_FEED_CATS')) {
+ print "</ul>";
+ }
+ }
+
+ }
+
+ if (!get_pref($link, 'ENABLE_FEED_CATS')) {
+ print "<li><hr></li>";
+ }
+
+ if (get_pref($link, 'ENABLE_FEED_CATS')) {
+ if (get_pref($link, "FEEDS_SORT_BY_UNREAD")) {
+ $order_by_qpart = "category,unread DESC,title";
+ } else {
+ $order_by_qpart = "category,title";
+ }
+ } else {
+ if (get_pref($link, "FEEDS_SORT_BY_UNREAD")) {
+ $order_by_qpart = "unread DESC,title";
+ } else {
+ $order_by_qpart = "title";
+ }
+ }
+
+ $result = db_query($link, "SELECT ttrss_feeds.*,
+ SUBSTRING(last_updated,1,19) AS last_updated_noms,
+ (SELECT COUNT(id) FROM ttrss_entries,ttrss_user_entries
+ WHERE feed_id = ttrss_feeds.id AND unread = true
+ AND ttrss_user_entries.ref_id = ttrss_entries.id
+ AND owner_uid = '$owner_uid') as unread,
+ cat_id,last_error,
+ ttrss_feed_categories.title AS category,
+ ttrss_feed_categories.collapsed
+ FROM ttrss_feeds LEFT JOIN ttrss_feed_categories
+ ON (ttrss_feed_categories.id = cat_id)
+ WHERE
+ ttrss_feeds.hidden = false AND
+ ttrss_feeds.owner_uid = '$owner_uid' AND parent_feed IS NULL
+ ORDER BY $order_by_qpart");
+
+ $actid = $_GET["actid"];
+
+ /* real feeds */
+
+ $lnum = 0;
+
+ $total_unread = 0;
+
+ $category = "";
+
+ $short_date = get_pref($link, 'SHORT_DATE_FORMAT');
+
+ while ($line = db_fetch_assoc($result)) {
+
+ $feed = db_unescape_string($line["title"]);
+ $feed_id = $line["id"];
+
+ $subop = $_GET["subop"];
+
+ $unread = $line["unread"];
+
+ if (get_pref($link, 'HEADLINES_SMART_DATE')) {
+ $last_updated = smart_date_time(strtotime($line["last_updated_noms"]));
+ } else {
+ $last_updated = date($short_date, strtotime($line["last_updated_noms"]));
+ }
+
+ $rtl_content = sql_bool_to_bool($line["rtl_content"]);
+
+ if ($rtl_content) {
+ $rtl_tag = "dir=\"RTL\"";
+ } else {
+ $rtl_tag = "";
+ }
+
+ $tmp_result = db_query($link,
+ "SELECT id,COUNT(unread) AS unread
+ FROM ttrss_feeds LEFT JOIN ttrss_user_entries
+ ON (ttrss_feeds.id = ttrss_user_entries.feed_id)
+ WHERE parent_feed = '$feed_id' AND unread = true
+ GROUP BY ttrss_feeds.id");
+
+ if (db_num_rows($tmp_result) > 0) {
+ while ($l = db_fetch_assoc($tmp_result)) {
+ $unread += $l["unread"];
+ }
+ }
+
+ $cat_id = $line["cat_id"];
+
+ $tmp_category = $line["category"];
+
+ if (!$tmp_category) {
+ $tmp_category = _("Uncategorized");
+ }
+
+ // $class = ($lnum % 2) ? "even" : "odd";
+
+ if ($line["last_error"]) {
+ $class = "error";
+ } else {
+ $class = "feed";
+ }
+
+ if ($unread > 0) $class .= "Unread";
+
+ if ($actid == $feed_id) {
+ $class .= "Selected";
+ }
+
+ $total_unread += $unread;
+
+ if ($category != $tmp_category && get_pref($link, 'ENABLE_FEED_CATS')) {
+
+ if ($category) {
+ print "</ul></li>";
+ }
+
+ $category = $tmp_category;
+
+ $collapsed = $line["collapsed"];
+
+ // workaround for NULL category
+ if ($category == _("Uncategorized")) {
+ if ($_COOKIE["ttrss_vf_uclps"] == 1) {
+ $collapsed = "t";
+ }
+ }
+
+ if ($collapsed == "t" || $collapsed == "1") {
+ $holder_class = "invisible";
+ $ellipsis = "...";
+ } else {
+ $holder_class = "";
+ $ellipsis = "";
+ }
+
+ $cat_id = sprintf("%d", $cat_id);
+
+ $cat_unread = getCategoryUnread($link, $cat_id);
+
+ $catctr_class = ($cat_unread > 0) ? "catCtrHasUnread" : "catCtrNoUnread";
+
+ print "<li class=\"feedCat\" id=\"FCAT-$cat_id\">
+ <a id=\"FCATN-$cat_id\" href=\"#\"onclick=\"javascript:toggleCollapseCat($cat_id)\">$tmp_category</a>
+ <a href=\"#\" onclick=\"javascript:viewCategory($cat_id)\" id=\"FCAP-$cat_id\">
+ <span id=\"FCATCTR-$cat_id\" title=\"Click to browse category\"
+ class=\"$catctr_class\">($cat_unread)</span> $ellipsis
+ </a></li>";
+
+ // !!! NO SPACE before <ul...feedCatList - breaks firstChild DOM function
+ // -> keyboard navigation, etc.
+ print "<li id=\"feedCatHolder\" class=\"$holder_class\"><ul class=\"feedCatList\" id=\"FCATLIST-$cat_id\">";
+ }
+
+ printFeedEntry($feed_id, $class, $feed, $unread,
+ "icons/$feed_id.ico", $link, $rtl_content,
+ $last_updated, $line["last_error"]);
+
+ ++$lnum;
+ }
+
+ if (db_num_rows($result) == 0) {
+ print "<li>"._('No feeds to display.')."</li>";
+ }
+
+ } else {
+
+ // tags
+
+/* $result = db_query($link, "SELECT tag_name,count(ttrss_entries.id) AS count
+ FROM ttrss_tags,ttrss_entries,ttrss_user_entries WHERE
+ post_int_id = ttrss_user_entries.int_id AND
+ unread = true AND ref_id = ttrss_entries.id
+ AND ttrss_tags.owner_uid = '$owner_uid' GROUP BY tag_name
+ UNION
+ select tag_name,0 as count FROM ttrss_tags WHERE owner_uid = '$owner_uid'
+ ORDER BY tag_name"); */
+
+ if (get_pref($link, 'ENABLE_FEED_CATS')) {
+ print "<li class=\"feedCat\">"._('Tags')."</li>";
+ print "<li id=\"feedCatHolder\"><ul class=\"feedCatList\">";
+ }
+
+ $result = db_query($link, "SELECT tag_name,SUM((SELECT COUNT(int_id)
+ FROM ttrss_user_entries WHERE int_id = post_int_id
+ AND unread = true)) AS count FROM ttrss_tags
+ WHERE owner_uid = ".$_SESSION['uid']." GROUP BY tag_name ORDER BY tag_name");
+
+ $tags = array();
+
+ while ($line = db_fetch_assoc($result)) {
+ $tags[$line["tag_name"]] += $line["count"];
+ }
+
+ foreach (array_keys($tags) as $tag) {
+
+ $unread = $tags[$tag];
+
+ $class = "tag";
+
+ if ($unread > 0) {
+ $class .= "Unread";
+ }
+
+ printFeedEntry($tag, $class, $tag, $unread, "images/tag.png", $link);
+
+ }
+
+ if (db_num_rows($result) == 0) {
+ print "<li>No tags to display.</li>";
+ }
+
+ if (get_pref($link, 'ENABLE_FEED_CATS')) {
+ print "</ul>\n";
+ }
+
+ }
+
+ print "</ul>";
+
+ }
+
+ function get_article_tags($link, $id) {
+
+ $a_id = db_escape_string($id);
+
+ $tmp_result = db_query($link, "SELECT DISTINCT tag_name FROM
+ ttrss_tags WHERE post_int_id = (SELECT int_id FROM ttrss_user_entries WHERE
+ ref_id = '$a_id' AND owner_uid = '".$_SESSION["uid"]."') ORDER BY tag_name");
+
+ $tags = array();
+
+ while ($tmp_line = db_fetch_assoc($tmp_result)) {
+ array_push($tags, $tmp_line["tag_name"]);
+ }
+
+ return $tags;
+ }
+
+ function trim_value(&$value) {
+ $value = trim($value);
+ }
+
+ function trim_array($array) {
+ $tmp = $array;
+ array_walk($tmp, 'trim_value');
+ return $tmp;
+ }
+
+ function tag_is_valid($tag) {
+ return ($tag !='' && !preg_match("/^[0-9]*$/", $tag));
+ }
+