0 && ($Start) >= $Total) {
$link = MakeAdminLink("import?Action=ImportFinished&ListID=$ListID&SuccessfulImports=$SuccessfulImports&BannedAttempts=$BannedAttempts&DuplicateAttempts=$DuplicateAttempts&OverwrittenRecords=$OverwrittenRecords");
?>
:: 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) {
$num_done = $Start;
$timediff = ($SYSTEMTIME - $StartTime);
$time_so_far = timedifference($timediff);
$timeunits = $timediff / $num_done;
$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.
Has taken approximately so far...
Have to wait approximately until it finishes...
$data) {
if (!is_array($data)) continue;
$table = current(array_keys($data));
if ($field == 'CustomFields') continue;
$field_name = $data[$table];
$query = "SELECT " . $field_name . " FROM " . $table . " LIMIT " . $Start . ", " . $limit;
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result)) {
$user_details[$field][$field_name][] = $row[$field_name];
}
}
if (isset($map['tablemapping']['CustomFields'])) {
foreach($map['tablemapping']['CustomFields'] as $field => $data) {
$table = current(array_keys($data));
$field_name = $data[$table];
$query = "SELECT " . $field_name . " FROM " . $table . " LIMIT " . $Start . ", " . $limit;
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result)) {
$user_details['CustomFields'][$field][$field_name][] = $row[$field_name];
}
}
}
mysql_close($database_result);
// we need to re-establish the old database connection. we can't just use mysql_connect(host, user, pass, new_connection=1) since that came in at php 4.2 :(
// so here we go!
MySQLConnect($DBHOST, $DBUSER, $DBPASS, $DBNAME);
foreach($user_details['Email'] as $field => $email_list) {
foreach($email_list as $pos => $emailaddress) {
$emailaddress = stripslashes($emailaddress);
$bad_in_email = array(' ', ',', '"', '\'', ';');
$emailaddress = str_replace($bad_in_email, '', $emailaddress);
if (isset($user_details['Format']) && is_array($user_details['Format'])) {
$f = current(array_keys($user_details['Format']));
$Format = $user_details['Format'][$f][$pos];
}
if (isset($user_details['Status']) && is_array($user_details['Status'])) {
$s = current(array_keys($user_details['Status']));
$Status = $user_details['Status'][$s][$pos];
}
if (isset($user_details['Confirmed']) && is_array($user_details['Confirmed'])) {
$c = current(array_keys($user_details['Confirmed']));
$Confirmed = $user_details['Confirmed'][$c][$pos];
}
$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 ($OverWrite) {
$memberid = mysql_result($user_check_result, 0, 0);
// First, update status, format, confirmation details.
$update_query = "UPDATE " . $TABLEPREFIX . "members SET Format='".addslashes($Format)."', Status='".addslashes($Status)."', Confirmed='".addslashes($Confirmed)."' WHERE MemberID='".addslashes($memberid)."'";
mysql_query($update_query);
// secondly, clear out their old fields.
$delete_query = "DELETE FROM " . $TABLEPREFIX . "list_field_values WHERE UserID='".addslashes($memberid)."' AND ListID='".addslashes($ListID)."'";
mysql_query($delete_query);
$OverwrittenRecords++;
} else {
$DuplicateAttempts++;
continue;
}
}
if (isset($user_details['CustomFields']) && is_array($user_details['CustomFields'])) {
foreach($user_details['CustomFields'] as $fieldid => $data) {
$name = current(array_keys($data));
$value = $user_details['CustomFields'][$fieldid][$name][$pos];
$query = "INSERT INTO " . $TABLEPREFIX . "list_field_values(ListID, FieldID, UserID, Value) VALUES ('" . addslashes($_REQUEST['ListID']) . "', '" . addslashes($fieldid) . "', '" . addslashes($memberid) . "', '" . addslashes($value) . "')";
mysql_query($query);
}
}
}
}
$map = urlencode(serialize($map));
$num_done = ($Start > 0 || $Total > 0) ? $Start + $limit : 0;
$import_link = MakeAdminLink("import?Action=DoDatabaseImport&OverWrite=$OverWrite&Confirmed=$Confirmed&Status=$Status&Format=$Format&PageID=DoImporting&ImportID=$ImportID&ListID=$ListID&Total=$Total&Start=$num_done&ImportMap=$map&DatabaseHost=$DatabaseHost&DatabaseUser=$DatabaseUser&DatabasePass=$DatabasePass&DatabaseName=$DatabaseName&SuccessfulImports=$SuccessfulImports&BannedAttempts=$BannedAttempts&DuplicateAttempts=$DuplicateAttempts&OverwrittenRecords=$OverwrittenRecords&StartTime=$StartTime");
?>