diff options
| author | Max Kostikov <max@kostikov.co> | 2019-11-25 21:50:02 +0100 |
|---|---|---|
| committer | Mario <mario@mariovavti.com> | 2019-11-25 21:50:02 +0100 |
| commit | 901785663edc7045c66d9393432a18bb376436bb (patch) | |
| tree | 8e3c393a518656b1349e43205eed2554814c2924 /Zotlabs | |
| parent | 38de059156f9a6ec63727d47a96d1b15e96e3b47 (diff) | |
| download | volse-hubzilla-901785663edc7045c66d9393432a18bb376436bb.tar.gz volse-hubzilla-901785663edc7045c66d9393432a18bb376436bb.tar.bz2 volse-hubzilla-901785663edc7045c66d9393432a18bb376436bb.zip | |
Fix once cached embedded content is used and stored forever
Diffstat (limited to 'Zotlabs')
| -rw-r--r-- | Zotlabs/Daemon/Cron_daily.php | 5 | ||||
| -rw-r--r-- | Zotlabs/Lib/Cache.php | 13 |
2 files changed, 9 insertions, 9 deletions
diff --git a/Zotlabs/Daemon/Cron_daily.php b/Zotlabs/Daemon/Cron_daily.php index b41625963..452ef45f1 100644 --- a/Zotlabs/Daemon/Cron_daily.php +++ b/Zotlabs/Daemon/Cron_daily.php @@ -50,6 +50,11 @@ class Cron_daily { dbesc('sse_id.%') ); + // Clean up emdedded content cache + q("DELETE FROM cache WHERE updated < %s - INTERVAL %s", + db_utcnow(), + db_quoteinterval(get_config('system','active_expire_days', '30') . ' DAY') + ); //update statistics in config require_once('include/statistics_fns.php'); diff --git a/Zotlabs/Lib/Cache.php b/Zotlabs/Lib/Cache.php index cea075659..878201a42 100644 --- a/Zotlabs/Lib/Cache.php +++ b/Zotlabs/Lib/Cache.php @@ -11,8 +11,10 @@ class Cache { $hash = hash('whirlpool',$key); - $r = q("SELECT v FROM cache WHERE k = '%s' limit 1", - dbesc($hash) + $r = q("SELECT v FROM cache WHERE k = '%s' AND updated > %s - INTERVAL %s LIMIT 1", + dbesc($hash), + db_utcnow(), + db_quoteinterval(get_config('system','object_cache_days', '30') . ' DAY') ); if ($r) @@ -40,12 +42,5 @@ class Cache { dbesc(datetime_convert())); } } - - - public static function clear() { - q("DELETE FROM cache WHERE updated < '%s'", - dbesc(datetime_convert('UTC','UTC',"now - 30 days"))); - } - } |