From 1572afe508162a4e475669e3bb651ee659568c20 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sun, 27 Nov 2005 15:56:10 +0100 Subject: headlines subtoolbar, misc api changes --- backend.php | 151 +++++++++++++++++++++++++++++++++++++++++++++++++++++------- 1 file changed, 134 insertions(+), 17 deletions(-) (limited to 'backend.php') diff --git a/backend.php b/backend.php index b357cb18b..9d22a3d09 100644 --- a/backend.php +++ b/backend.php @@ -55,6 +55,13 @@ $fetch = $_GET["fetch"]; + function getAllCounters($link) { + getLabelCounters($link); + getFeedCounters($link); + getTagCounters($link); + getGlobalCounters($link); + } + /* FIXME this needs reworking */ function getGlobalCounters($link) { @@ -408,10 +415,7 @@ if ($subop == "getAllCounters") { print ""; - getLabelCounters($link); - getFeedCounters($link); - getTagCounters($link); - getGlobalCounters($link); + getAllCounters($link); print ""; } @@ -465,19 +469,60 @@ getGlobalCounters($link); print ""; } - + + /* GET["cmode"] = 0 - mark as read, 1 - as unread, 2 - toggle */ if ($subop == "catchupSelected") { $ids = split(",", $_GET["ids"]); - foreach ($ids as $id) { + $cmode = sprintf("%d", $_GET["cmode"]); - db_query($link, "UPDATE ttrss_user_entries SET unread=false,last_read = NOW() - WHERE id = '$id' AND owner_uid = " . $_SESSION["uid"]); + foreach ($ids as $id) { + if ($cmode == 0) { + db_query($link, "UPDATE ttrss_user_entries SET + unread = false,last_read = NOW() + WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]); + } else if ($cmode == 1) { + db_query($link, "UPDATE ttrss_user_entries SET + unread = true + WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]); + } else { + db_query($link, "UPDATE ttrss_user_entries SET + unread = NOT unread,last_read = NOW() + WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]); + } } + print ""; + getAllCounters($link); + print ""; + } + + if ($subop == "markSelected") { + + $ids = split(",", $_GET["ids"]); + + $cmode = sprintf("%d", $_GET["cmode"]); + + foreach ($ids as $id) { - print "Marked active page as read."; + if ($cmode == 0) { + db_query($link, "UPDATE ttrss_user_entries SET + marked = false + WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]); + } else if ($cmode == 1) { + db_query($link, "UPDATE ttrss_user_entries SET + marked = true + WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]); + } else { + db_query($link, "UPDATE ttrss_user_entries SET + marked = NOT marked + WHERE ref_id = '$id' AND owner_uid = " . $_SESSION["uid"]); + } + } + print ""; + getAllCounters($link); + print ""; } if ($subop == "sanityCheck") { @@ -753,8 +798,6 @@ } - print ""; - $search = $_GET["search"]; $search_mode = $_GET["smode"]; @@ -834,13 +877,77 @@ $query_strategy_part = "id > 0"; // dumb } - $order_by = "updated DESC"; // if ($feed < -10) { // $order_by = "feed_id,updated DESC"; // } + $feed_title = ""; + + if ($search && $search_mode == "All feeds") { + $feed_title = "Search results"; + } else if (sprintf("%d", $feed) == 0) { + $feed_title = $feed; + } else if ($feed > 0) { + $result = db_query($link, "SELECT title,site_url FROM ttrss_feeds + WHERE id = '$feed'"); + + $feed_title = db_fetch_result($result, 0, "title"); + $feed_site_url = db_fetch_result($result, 0, "site_url"); + + } else if ($feed == -1) { + $feed_title = "Starred articles"; + } else if ($feed < -10) { + $label_id = -$feed - 11; + $result = db_query($link, "SELECT description FROM ttrss_labels + WHERE id = '$label_id'"); + $feed_title = db_fetch_result($result, 0, "description"); + } else { + $feed_title = "?"; + } + + print "
"; + + print ""; + + print ""; + print "
+ Select: + All, + Unread, + None +    + Toggle: Unread, + Starred"; + +/* print "   + View: + All, + Unread, + Starred +    + Feed: + Update, + Mark as read"; */ + + print ""; + + if ($feed_site_url) { + print "$feed_title"; + } else { + print $feed_title; + } + + print "
"; + + print ""; + + if ($feed < -10) error_reporting (0); if (sprintf("%d", $feed) != 0) { @@ -852,7 +959,9 @@ } $result = db_query($link, "SELECT - id,title,updated,unread,feed_id,marked,link,last_read, + id,title, + SUBSTRING(updated,1,16) as updated, + unread,feed_id,marked,link,last_read, SUBSTRING(last_read,1,19) as last_read_noms, $vfeed_query_part SUBSTRING(updated,1,19) as updated_noms @@ -872,7 +981,9 @@ $feed_kind = "Tags"; $result = db_query($link, "SELECT - ttrss_entries.id as id,title,updated,unread,feed_id, + ttrss_entries.id as id,title, + SUBSTRING(updated,1,16) as updated, + unread,feed_id, marked,link,last_read, SUBSTRING(last_read,1,19) as last_read_noms, $vfeed_query_part @@ -956,17 +1067,23 @@ // onclick=\"javascript:view($id,$feed_id)\"> print ""; + + print ""; + print ""; - print ""; if ($line["feed_title"]) { - print ""; + print ""; print ""; } else { - print ""; + print ""; } print ""; -- cgit v1.2.3-54-g00ecf
$update_pic + + $marked_pic + print " ".$line["updated"]."$content_link$content_link ".$line["feed_title"]."$content_link$content_link