On Fri, November 3, 2006 04:26, Gary V wrote: > AFAIK awl will grow forever. To trim it, you could use a simple minded: > DELETE FROM awl WHERE count = 1;
$sql = 'SELECT * FROM `awl` WHERE `count` = 1 AND `totscore` > 12'; i just gava 12 as an example, but users that sent the first mail that is not spam is then still in awl with is good for first time senders tracking this sql will defeat tracking first time senders :( -- "This message was sent using 100% recycled spam mails." ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/