summaryrefslogtreecommitdiff
path: root/modules
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2010-11-10 18:50:51 +0300
committerAndrew Dolgov <[email protected]>2010-11-10 19:01:14 +0300
commit905ff52a362b6afc28a2c3ed1cbc9b90d63253ba (patch)
tree2bcf77d8c7d7f4235fef3bd9aa5171c0c5e3d549 /modules
parent23d064cc81c2ece13781662ccf6dd99106587f67 (diff)
implement label cache; misc fixes (bump schema)
Diffstat (limited to 'modules')
-rw-r--r--modules/backend-rpc.php2
-rw-r--r--modules/pref-labels.php15
2 files changed, 16 insertions, 1 deletions
diff --git a/modules/backend-rpc.php b/modules/backend-rpc.php
index 047558fc2..f28e72475 100644
--- a/modules/backend-rpc.php
+++ b/modules/backend-rpc.php
@@ -595,7 +595,7 @@
if ($subop == "removeFromLabel") {
- $ids = split(",", db_escape_string($_REQUEST["ids"]));
+ $ids = explode(",", db_escape_string($_REQUEST["ids"]));
$label_id = db_escape_string($_REQUEST["lid"]);
$label = db_escape_string(label_find_caption($link, $label_id,
diff --git a/modules/pref-labels.php b/modules/pref-labels.php
index 73d6e583f..884a25d1a 100644
--- a/modules/pref-labels.php
+++ b/modules/pref-labels.php
@@ -21,6 +21,14 @@
fg_color = '$fg', bg_color = '$bg' WHERE id = '$id'
AND owner_uid = " . $_SESSION["uid"]);
}
+
+ $caption = db_escape_string(label_find_caption($link, $id, $_SESSION["uid"]));
+
+ /* Remove cached data */
+
+ db_query($link, "UPDATE ttrss_user_entries SET label_cache = ''
+ WHERE label_cache LIKE '%$caption%' AND owner_uid = " . $_SESSION["uid"]);
+
}
return;
@@ -33,6 +41,13 @@
db_query($link, "UPDATE ttrss_labels2 SET
fg_color = '', bg_color = '' WHERE id = '$id'
AND owner_uid = " . $_SESSION["uid"]);
+
+ $caption = db_escape_string(label_find_caption($link, $id, $_SESSION["uid"]));
+
+ /* Remove cached data */
+
+ db_query($link, "UPDATE ttrss_user_entries SET label_cache = ''
+ WHERE label_cache LIKE '%$caption%' AND owner_uid = " . $_SESSION["uid"]);
}
}