function extractEmailsOnly($emails, $mysql, $table_prefix, $extension, $arraycount, $log_enabled)
{
$i = 0;
$new = 0;
$old = 0;
while (isset($emails[$i])) {
$email = " ";
$j = 0;
if ($emails[$i] == " " || $emails[$i] == "(" || $emails[$i] == ")" || $emails[$i] == "]" || $emails[$i] == "[" || $emails[$i] == "\r\n" || $emails[$i] == "\r" || $emails[$i] == "\n" || $emails[$i] == "," || $emails[$i] == "<" || $emails[$i] == ">" || $emails[$i] == ":" || $emails[$i] == "'" || $emails[$i] == "\"") {
$i += 1;
while (1) {
if (!isset($emails[$i])) {
break;
}
$email[$j] = $emails[$i];
$j += 1;
$i += 1;
if (!isset($emails[$i])) {
break;
}
if ($emails[$i] == " " || $emails[$i] == "(" || $emails[$i] == ")" || $emails[$i] == "]" || $emails[$i] == "[" || $emails[$i] == "\r\n" || $emails[$i] == "\r" || $emails[$i] == "\n" || $emails[$i] == "," || $emails[$i] == ">" || $emails[$i] == "<" || $emails[$i] == ":" || $emails[$i] == "'" || $emails[$i] == "\"" || $emails[$i] == "\\" || $emails[$i] == "/" || $emails[$i] == "&" || $emails[$i] == ";") {
$email = trim($email);
$email = replaceAllSubStr($email, " ", "");
$email = replaceAllSubStr($email, "(", "");
$email = replaceAllSubStr($email, ")", "");
$email = replaceAllSubStr($email, "[", "");
$email = replaceAllSubStr($email, "]", "");
$email = replaceAllSubStr($email, "\r\n", "");
$email = replaceAllSubStr($email, "\n", "");
$email = replaceAllSubStr($email, ",", "");
$email = replaceAllSubStr($email, "<", "");
$email = replaceAllSubStr($email, ">", "");
$email = replaceAllSubStr($email, "\\'", "");
$email = replaceAllSubStr($email, "\"", "");
$email = replaceAllSubStr($email, "\\", "");
$email = replaceAllSubStr($email, "/", "");
$email = replaceAllSubStr($email, ";", "");
$email = replaceAllSubStr($email, "&", "");
$email = replaceAllSubStr($email, "|", "");
//if((substr_count($email,"@")==1)&&(substr_count($email,".")>=1))
if (is_valid_email($email)) {
if ($mysql->total("" . $table_prefix . "email_advt", "email='{$email}'") == 0) {
mysql_query("INSERT INTO `" . $table_prefix . "email_advt` ( `id` , `email` , `unsubstatus` , `time` )VALUES ('', '{$email}', '0', '" . time() . "');");
echo "<span class=\"inserted\">" . $email . " - > Inserted Into Database. <br></span>";
$roww = $mysql->select_last_row("" . $table_prefix . "email_advt", "id");
$id = $roww[0];
//echo $name;
$arraycount = addEmailToList($mysql, $id, $table_prefix, $arraycount);
$new += 1;
} else {
echo "<span class=\"already\">" . $email . " - > Already In Database <br</span>";
$old += 1;
$id = $mysql->echo_one("select id from `" . $table_prefix . "email_advt` where email='{$email}'");
$arraycount = addEmailToList($mysql, $id, $table_prefix, $arraycount);
}
}
$i -= 1;
break;
}
}
}
$i += 1;
}
?>
<br>
<strong>
Total number of new emails added to the database :<?php
echo $new . "<br>";
$catlist = $mysql->echo_one("select name from " . $table_prefix . "email_advt_category where id={$_POST['category']}");
echo "Total number of emails added to the list [{$catlist}] :{$arraycount[1]}<br>";
if ($_POST['category2'] != $_POST['category'] && $_POST['category2'] != "") {
$catlist = $mysql->echo_one("select name from " . $table_prefix . "email_advt_category where id={$_POST['category2']}");
echo "Total number of emails added to the list [{$catlist}] :{$arraycount[2]}<br>";
}
if ($_POST['category3'] != $_POST['category2'] && $_POST['category3'] != $_POST['category'] && $_POST['category3'] != "") {
$catlist = $mysql->echo_one("select name from " . $table_prefix . "email_advt_category where id={$_POST['category3']}");
echo "Total number of emails added to the list [{$catlist}] :{$arraycount[3]}<br>";
}
if ($log_enabled == 1) {
writeLog($new, $table_prefix, $extension, $arraycount, $mysql);
}
?>
Total number of emails which are already in database :<?php
echo $old;
?>
<br><br>
<?php
if ($entityname != "") {
?>
<span class="already">Invalid Access!!! Emails not added to the list(s) [<?php
echo $entityname;
?>
]!!! </span>
<?php
}
?>
</strong>
<?php
}
$email = replaceAllSubStr($email, "(", "");
$email = replaceAllSubStr($email, ")", "");
$email = replaceAllSubStr($email, "[", "");
$email = replaceAllSubStr($email, "]", "");
$email = replaceAllSubStr($email, "\r\n", "");
$email = replaceAllSubStr($email, "\n", "");
$email = replaceAllSubStr($email, ",", "");
$email = replaceAllSubStr($email, "<", "");
$email = replaceAllSubStr($email, ">", "");
$email = replaceAllSubStr($email, "\\'", "");
$email = replaceAllSubStr($email, "\"", "");
$email = replaceAllSubStr($email, "\\", "");
$email = replaceAllSubStr($email, "/", "");
$email = replaceAllSubStr($email, ";", "");
$email = replaceAllSubStr($email, "&", "");
$email = replaceAllSubStr($email, "|", "");
//if((substr_count($email,"@")==1)&&(substr_count($email,".")>=1))
if (eregi("^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,4})\$", $email)) {
//echo "valid email ".$email."<br>";
if ($mysql->total("" . $table_prefix . "email_advt", "email='{$email}'") == 0) {
//echo "hiiii";
//mysql_query("INSERT INTO `".$table_prefix."email_advt` ( `id` , `email` , `unsubstatus` , `time` )VALUES ('', '$email', '0', '".time()."');");
//echo "<span class=\"inserted\">".$email." - > Inserted Into Database. <br></span>";
//$roww=$mysql->select_last_row("".$table_prefix."email_advt","id");
//$id=$roww[0]; //echo $name;
//$arraycount=addEmailToList($mysql,$id,$table_prefix,$arraycount);
if (substr_count($str1, $email) == 0) {
$new += 1;
$str1 .= $email . "<br>";
}
} else {
