From 5b8444d371d2d55781eddf250eeb964a07a529b5 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 17 Feb 2009 12:30:54 +0300 Subject: [PATCH] offline: sync marked/unread status (performance tweak) --- modules/backend-rpc.php | 19 +++++++------------ 1 file changed, 7 insertions(+), 12 deletions(-) diff --git a/modules/backend-rpc.php b/modules/backend-rpc.php index d7700d66..afcd82d3 100644 --- a/modules/backend-rpc.php +++ b/modules/backend-rpc.php @@ -545,9 +545,15 @@ $id = (int) $e[0]; $unread = bool_to_sql_bool((bool) $e[1]); - $marked = bool_to_sql_bool((bool) $e[2]); + $marked = (bool)$e[2]; + + if ($marked) { + $marked = bool_to_sql_bool($marked); + $marked_qpart = "marked = $marked,"; + } $query = "UPDATE ttrss_user_entries SET + $marked_qpart unread = $unread, last_read = '$last_online' WHERE ref_id = '$id' AND @@ -556,17 +562,6 @@ $result = db_query($link, $query); - if ($marked) { - $query = "UPDATE ttrss_user_entries SET - marked = $marked, - last_read = '$last_online' - WHERE ref_id = '$id' AND - (last_read IS NULL OR last_read < '$last_online') AND - owner_uid = ".$_SESSION["uid"]; - - $result = db_query($link, $query); - } - print ""; } -- 2.39.5