vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=327824

Clean the cache automatically with schedule task
by mc0676
13 Feb 2020 13:30

2 Attachment(s)
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 13 Feb 2020 14:32

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 13 Feb 2020 15:13

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.


All times are GMT. The time now is 18:57.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.