diff options
| author | Andrew Dolgov <[email protected]> | 2010-11-10 11:08:33 +0300 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2010-11-10 11:08:33 +0300 |
| commit | 779560b7a388408d032ca42f8828cb5242244b53 (patch) | |
| tree | 1312f14f8f1b2a5355ca3781a30fba0715282950 /modules | |
| parent | 5eeb387497a6a35115d41a20a9a9f8f82531975b (diff) | |
fix tag caching issues
Diffstat (limited to 'modules')
| -rw-r--r-- | modules/backend-rpc.php | 17 |
1 files changed, 12 insertions, 5 deletions
diff --git a/modules/backend-rpc.php b/modules/backend-rpc.php index a825242c6..047558fc2 100644 --- a/modules/backend-rpc.php +++ b/modules/backend-rpc.php @@ -424,7 +424,6 @@ $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"); @@ -433,6 +432,8 @@ if (db_num_rows($result) == 1) { + $tags_to_cache = array(); + $int_id = db_fetch_result($result, 0, "int_id"); db_query($link, "DELETE FROM ttrss_tags WHERE @@ -455,12 +456,18 @@ db_query($link, "INSERT INTO ttrss_tags (post_int_id, owner_uid, tag_name) VALUES ('$int_id', '".$_SESSION["uid"]."', '$tag')"); } + + array_push($tags_to_cache, $tag); } - } - db_query($link, "UPDATE ttrss_user_entries - SET tag_cache = '$tags_str' WHERE ref_id = '$id' - AND owner_uid = " . $_SESSION["uid"]); + /* update tag cache */ + + $tags_str = join(",", $tags_to_cache); + + 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"); |