From 490c366d39126d8abab29547e8dd983ee254e859 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 9 Nov 2010 22:41:13 +0300 Subject: add tag cache for user_entries (bump schema) --- modules/backend-rpc.php | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'modules') diff --git a/modules/backend-rpc.php b/modules/backend-rpc.php index 8f31cd748..a825242c6 100644 --- a/modules/backend-rpc.php +++ b/modules/backend-rpc.php @@ -423,8 +423,8 @@ $id = db_escape_string($_REQUEST["id"]); $tags_str = db_escape_string($_REQUEST["tags_str"]); - $tags = array_unique(trim_array(split(",", $tags_str))); + $tags_str = db_escape_string(join(",", $tags)); db_query($link, "BEGIN"); @@ -458,6 +458,10 @@ } } + db_query($link, "UPDATE ttrss_user_entries + SET tag_cache = '$tags_str' WHERE ref_id = '$id' + AND owner_uid = " . $_SESSION["uid"]); + db_query($link, "COMMIT"); if ($memcache) { -- cgit v1.2.3