From 18eddb2cb9b58c015e2cc04dd0d41008a03961a4 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 19 Sep 2006 05:16:42 +0100 Subject: optimize mark selected function --- functions.php | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) (limited to 'functions.php') diff --git a/functions.php b/functions.php index bb80cac57..600a776c6 100644 --- a/functions.php +++ b/functions.php @@ -2587,6 +2587,31 @@ } } + 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(); -- cgit v1.2.3