Quarantine Reports

Questions and answers about how to do stuff
Post Reply
User avatar
shawniverson
Posts: 3573
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Quarantine Reports

Post by shawniverson »


* Shorter "daily" quarantine reports - right now they are 7 days, and that's too big of a report - I only want to see what was not on the last report. I personally have close to 500 spam messages a day in my report - 3500 for 7 days is too much (maybe I can figure this out in the PHP file)

Danita
To modify the duration of the reports, for now do the following:

Edit /var/www/html/mailscanner/conf.php:

Code: Select all

define('QUARANTINE_REPORT_DAYS', 1);
Next, you are probably only interested in spam in the report.

Edit /usr/local/bin/mailwatch/tools/Cron_jobs/quarantine_report.php

Modify this block of code:

Code: Select all

AND
 a.date >= DATE_SUB(CURRENT_DATE(), INTERVAL ".QUARANTINE_REPORT_DAYS." DAY)
ORDER BY a.date DESC, a.time DESC";
as follows:

Code: Select all

AND
 a.date >= DATE_SUB(CURRENT_DATE(), INTERVAL ".QUARANTINE_REPORT_DAYS." DAY)
AND
 a.isspam>0
ORDER BY a.date DESC, a.time DESC";
Post Reply