0 && ($Start) >= $Total)) {
list($status, $mailbox) = ConnectEmail($_REQUEST['EmailHost'], $_REQUEST['EmailUser'], $_REQUEST['EmailPass'], $_REQUEST['EmailPort']);
foreach($_SESSION['MsgsToDelete'] as $msgid) {
imap_delete($mailbox, $msgid);
}
imap_expunge($mailbox);
imap_close($mailbox);
$link = MakeAdminLink("import?Action=ImportFinished&ListID=$ListID&SuccessfulImports=$SuccessfulImports&BannedAttempts=$BannedAttempts&DuplicateAttempts=$DuplicateAttempts&OverwrittenRecords=$OverwrittenRecords&RemovedRecords=$RemovedRecords");
?>
:: Import Complete! ::
:: Import Information ::
Your user list is currently being imported. Please do not close this window. There are approximately users remaining to import...
0) {
$timediff = ($SYSTEMTIME - $StartTime);
$time_so_far = timedifference($timediff);
$timeunits = $timediff / $Start;
$timediff = ($timeunits * ($Total - $Start));
$timewaiting = timedifference($timediff);
?>
I have imported subscribers successfully.
I have skipped banned subscribers.
I have found duplicate subscribers.
I have updated subscribers successfully.
I have removed subscribers so far.
Has taken approximately so far...
Have to wait approximately until it finishes...
Nmsgs;
$Empty = ($Total == 0) ? 1 : 0;
} else {
$Total = $_GET['Total'];
$Empty = 0;
}
if ($perpagelimit > $Total) $perpagelimit = $Total;
$numdone = 0;
while($numdone < $perpagelimit) {
$Start++;
$numdone++;
$insert = false;
$unsubscribe = false;
if ($Start > $Total) break;
$msgheader = imap_header($mailbox, $Start);
$subject = strtolower($msgheader->Subject);
if ($subject == 'subscribe') {
$insert = true;
}
if ($subject == 'unsubscribe') {
$unsubscribe = true;
}
if (!$insert && !$unsubscribe) continue;
$_SESSION['MsgsToDelete'][] = $Start;
$emailaddress = stripslashes($msgheader->from['0']->mailbox. '@' . $msgheader->from['0']->host);
$user_check_query = "SELECT * FROM " . $TABLEPREFIX . "members WHERE Email = '".addslashes($emailaddress)."' AND ListID='".addslashes($ListID)."'";
$user_check_result = mysql_query($user_check_query);
//now insert this member!
if(!mysql_num_rows($user_check_result)) {
if(Banned($emailaddress, $ListID))
{
$BannedAttempts++;
continue;
} else {
$confirm_code = md5(time());
$query = "INSERT INTO " . $TABLEPREFIX . "members(ListID, Email, Subscribedate, Format, Status, Confirmed, ImportID, ConfirmCode) VALUES ('" . addslashes($ListID) . "', '" . addslashes($emailaddress) . "', '" . addslashes($SYSTEMTIME) . "', '" . addslashes($Format) . "', '" . addslashes($Status) . "', '" . addslashes($Confirmed) . "', '" . addslashes($ImportID) . "', '" . addslashes($confirm_code) . "')";
$result = mysql_query($query);
if ($result) {
$SuccessfulImports++;
$memberid = mysql_insert_id();
}
}
} else {
if ($unsubscribe) {
$member = mysql_fetch_assoc($user_check_result);
$memberid = $member['MemberID'];
if (UNSUBSCRIBE_DELETE_USER) {
$qry = "DELETE FROM " . $TABLEPREFIX . "members WHERE MemberID='" . addslashes($memberid) . "' AND ListID='" . addslashes($ListID) . "'";
mysql_query($qry);
$qry = "DELETE FROM " . $TABLEPREFIX . "list_field_values WHERE UserID='" . addslashes($memberid) . "' AND ListID='" . addslashes($ListID) . "'";
mysql_query($qry);
} else {
$qry = "UPDATE " . $TABLEPREFIX . "members SET Status=0 WHERE MemberID='" . addslashes($memberid) . "' AND ListID='" . addslashes($ListID) . "'";
mysql_query($qry);
}
$RemovedRecords++;
} else {
$DuplicateAttempts++;
}
}
}
imap_close($mailbox);
}
$num_done = ($Start > 0 || $Total > 0) ? $Start : 0;
$import_link = MakeAdminLink("import?Action=DoEmailImport&OverWrite=$OverWrite&Confirmed=$Confirmed&Status=$Status&Format=$Format&PageID=DoImporting&ImportID=$ImportID&ListID=$ListID&Total=$Total&Start=$num_done&EmailHost=$EmailHost&EmailUser=$EmailUser&EmailPass=$EmailPass&EmailPort=$EmailPort&SuccessfulImports=$SuccessfulImports&BannedAttempts=$BannedAttempts&DuplicateAttempts=$DuplicateAttempts&OverwrittenRecords=$OverwrittenRecords&Empty=$Empty&RemovedRecords=$RemovedRecords");
?>