PDA

View Full Version : Administrative and Maintenance Tools - Clean the cache automatically with schedule task


mc0676
02-12-2020, 10:00 PM
TEXTED in VB5.5.6

This simply mod "truncate" there two table:
- cache
- cacheevent

How u know vb5 cache everything and after some hous the dabatase is huge.

So with this tool and a scheduled task u can decide to truncate those table when you want.

INSTALL

1) download the zip and unzip;

2) open cleancache.php with Notepad or a txt editor;

3) fill the first 6 lines (connection information and tables name) and save the file;
$localhost = 'xx.xx.xx.xx';
$user = 'xxxxxx';
$password = 'xxxxxx';
$database = 'xxxxxx';
$cache_table = xxxx; // cache table name, example vb_cache
$cacheevent_table = xxxx; // cacheevent table nama, example vb_cacheevent

4) upload the file in this folder:
/core/includes/cron

5) go in admin panel and open the Scheduled Task Manager

6) scroll ad the and choose Add New Scheduled Task

7) fill like in attachment: in this example the cache will be "cleaned" every hour at 45 minutes (14:45, 15:45, 16:45, etc etc), but u can choose to clear one a day or other;

8) save the scheduled task.

delicjous
02-13-2020, 01:32 PM
Sorry, but I would not recomment to fill db-data to that files. There is another possibility here: https://vbulletin.org/forum/showthread.php?t=327063 which use vb-standard-classes.

In Omnibus
02-13-2020, 02:13 PM
As Joe pointed out in his mod most sites do not need to clear the cache automatically and there are reasons for not doing so. Clearing the cache via cron job can cause sites to lose data.