From 31234407bffa5debe79250e93a4168ea2251e094 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.org.ru>
Date: Mon, 2 Feb 2009 15:14:34 +0300
Subject: enable cache of feedlist data

---
 viewfeed.js | 13 ++++++++++++-
 1 file changed, 12 insertions(+), 1 deletion(-)

(limited to 'viewfeed.js')

diff --git a/viewfeed.js b/viewfeed.js
index 615f366f3..6f018d19c 100644
--- a/viewfeed.js
+++ b/viewfeed.js
@@ -1500,6 +1500,11 @@ function cache_inject(id, article, param) {
 function cache_find(id) {
 
 	if (db) {
+		var rs = db.execute("SELECT article FROM cache WHERE id = ?", [id]);
+
+		if (rs.isValidRow()) {
+			return rs.field(0);
+		}
 
 	} else {
 		for (var i = 0; i < article_cache.length; i++) {
@@ -1572,7 +1577,13 @@ function cache_check_param(id, param) {
 }
 
 function cache_expire() {
-	if (!db) {
+	if (db) {
+		var date = new Date();
+		var ts = Math.round(date.getTime() / 1000);
+
+		db.execute("DELETE FROM cache WHERE added < ? - 600", [ts]);
+
+	} else {
 		while (article_cache.length > 25) {
 			article_cache.shift();
 		}
-- 
cgit v1.2.3