[Savannah-cvs] [SavaneTasks] (edit) other spam stats

[Beuc]

??changed:
-
 -- Posts per IP suspicious and per day
 SELECT DATE_FORMAT(date, '%Y-%m-%d') AS day,ip, count(*) AS sum FROM 
spam_stats WHERE (check_value IS NOT NULL OR check_value != '421') AND details 
LIKE "%http%" GROUP BY day,ip ORDER BY day,sum;
 -- Number of different IP adresses
 SELECT COUNT(DISTINCT ip) FROM spam_stats;

--
forwarded from 
https://savannah.gnu.org/maintenance/address@hidden://savannah.gnu.org/maintenance