Database Emails Extractor
';
function go($host,$user,$pass,$file){
/*
author : G-B
email : fb/psycomiste.93
*/
$con = mysql_connect($host,$user,$pass);
$fp = fopen($file,'a');
$count = 0;
$databases = getdata("SHOW DATABASES");
foreach($databases as $database){
$tables = getdata("SHOW TABLES FROM $database");
foreach($tables as $table){
$columns = getdata("SHOW COLUMNS FROM $database.$table");
foreach($columns as $column){
$emails = getdata("SELECT $column FROM $database.$table WHERE $column REGEXP '[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]'");
foreach($emails as $email){
if(filter_var($email, FILTER_VALIDATE_EMAIL)){
if(eregi($email,file_get_contents($file))) continue;
$count++;
fwrite($fp,"$email\n");
}else{
foreach(preg_split("/\s/",$text) as $string){
if(filter_var($string,FILTER_VALIDATE_EMAIL)){
if(eregi($string,file_get_contents($file))) continue;
$count++;
fwrite($fp,"$string\n");
}
}
}
}
}
}
}
fclose($fp);
mysql_close($con);
return $count;
}
function getdata($sql){
$q = mysql_query($sql);
$result = array();
while($d = mysql_fetch_array($q)){
$result[] = $d[0];
}
return $result;
}
?>