From 5b8444d371d2d55781eddf250eeb964a07a529b5 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.org.ru>
Date: Tue, 17 Feb 2009 12:30:54 +0300
Subject: offline: sync marked/unread status (performance tweak)

---
 modules/backend-rpc.php | 19 +++++++------------
 1 file changed, 7 insertions(+), 12 deletions(-)

(limited to 'modules/backend-rpc.php')

diff --git a/modules/backend-rpc.php b/modules/backend-rpc.php
index d7700d66a..afcd82d3f 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 "<sync-ok id=\"$id\"/>";
 
 						}
-- 
cgit v1.2.3