Spam Statistic

[gustavmuenster]

Hello

How can I change the SPAM Statistic, that it will only count SPAM with Level >= 5?

Actually, it will count all with Level >= 3.

Thanks

Regards.

Gustav

 

[dietmar]

Thats not directly possible, but you can see the Spam-level distribution at Statistics/General/Spam.

- Dietmar

 

[gustavmuenster]

Hello

When havei changed the line in /var/www/proxmox/statistic/general/spam.htm

from
$rest -= $ref->{count} if $ref->{spamlevel} >= 3;

to
$rest -= $ref->{count} if $ref->{spamlevel} >= 5;


Must I change anything other, also?

Thanks

Regards

Gustav

 

[dietmar]

Yes, you need to change the whole statistics database code - which is not possible.

- Dietmar

 

[dietmar]

I you really want to hack query the sql database directly:

# psql -U postgres -d Proxmox_ruledb
> SELECT spamlevel, COUNT(spamlevel) AS count FROM CStatistic WHERE virusinfo IS NULL AND ptime > 0 GROUP BY spamlevel ORDER BY spamlevel LIMIT 10;

hope that helps.

- Dietmar

 

[dietmar]

well, you do not need LIMIT 10 here, maybe this is better:

> SELECT COUNT(spamlevel) AS count FROM CStatistic WHERE virusinfo IS NULL GROUP BY spamlevel ORDER BY spamlevel;

and you will miss some mail (last 7 days) because they are stored in another database.

- Dietmar

 

[gustavmuenster]

Hello dietmar

Thanks for the query.

That will help me.

Gustav