Check domains (Mailscanner)

#!/usr/bin/php -q

<?php

/*

Fuzzy logic to guestimate number of email addresses per domain

Dru <topdog>

29-11-2006

*/

mysql_connect("localhost","root","") or die("Failed :: Could not connect to DB");

mysql_select_db("mailscanner") or die("Failed :: Could not select DB");

$result = mysql_query("select filter from user_filters") or die("Query Failed");

while($data = mysql_fetch_array($result)){

$domain = $data[0];

$r2 = mysql_query("select distinct to_address from maillog where to_domain='$domain' and isspam=0 and to_address not like '%,%' group by to_address having count(to_address) > 30;");

$n = mysql_num_rows($r2);

echo "Domain \t:$domain [$n]\n";

echo "========================================\n";

if($r2){

while($d2 = mysql_fetch_array($r2)){

echo $d2[0]."\n";

}

}

echo "\n\n";

}

?>