$DB_SentMsgs = $result_data['SentMsgs'];
$DB_EmailAddress = $result_data['EmailAddress'];
$DB_TimeJoined = $result_data['TimeJoined'];
$DB_Real_TimeJoined = $result_data['Real_TimeJoined'];
$CanReceiveHTML = $result_data['CanReceiveHTML'];
$DB_LastActivity = $result_data['LastActivity'];
$DB_FirstName = $result_data['FirstName'];
$DB_LastName = $result_data['LastName'];
$DB_IPaddy = $result_data['IP_Addy'];
$DB_ReferralSource = $result_data['ReferralSource'];
$DB_UniqueCode = $result_data['UniqueCode'];
$DB_Confirmed = $result_data['Confirmed'];
# Remove user and custom fields
$query = "DELETE FROM " . $infrespsubscribers . " WHERE EmailAddress = '{$bounced_addy}'";
$DB_result = mysql_query($query) or die("Invalid query: " . mysql_error());
$query = "DELETE FROM " . infrespcustomfields . " WHERE email_attached = '{$bounced_addy}'";
$DB_result = mysql_query($query) or die("Invalid query: " . mysql_error());
# Notify owner
if ($bouncer['NotifyOwner'] == "1") {
# print "Got a bounce, assigned email: " . $bouncer['EmailAddy'] . "<br>\n";
# print "sending notify...<br>\n";
SendMessageTemplate('templates/messages/subscriber_removed.notify.txt', $bouncer['EmailAddy'], $bouncer['EmailAddy']);
}
}
}
}
}
# Should we disconnect from the DB?
if ($included != TRUE) {
DB_disconnect();
}
# Add a non-confirmed row to the DB
$DB_Confirmed = "0";
$query = "INSERT INTO " . $infrespsubscribers . " (ResponderID, SentMsgs, EmailAddress, TimeJoined, Real_TimeJoined, CanReceiveHTML, LastActivity, FirstName, LastName, IP_Addy, ReferralSource, UniqueCode, Confirmed)\n\t\t\t\t\t\t\tVALUES('{$DB_ResponderID}','{$DB_SentMsgs}', '{$DB_EmailAddress}', '{$DB_TimeJoined}', '{$DB_Real_TimeJoined}', '{$CanReceiveHTML}', '{$DB_LastActivity}', '{$DB_FirstName}', '{$DB_LastName}', '{$DB_IPaddy}', '{$DB_ReferralSource}', '{$DB_UniqueCode}', '{$DB_Confirmed}')";
$DB_result = mysql_query($query) or die("Invalid query: " . mysql_error());
$DB_SubscriberID = mysql_insert_id();
# Send confirmation msg
SendMessageTemplate('templates/messages/subscribe.confirm.txt', $DB_EmailAddress, $ResponderInfo['FromEmail'], $DB_SubscriberID);
} else {
# Add a confirmed row to the DB
$DB_Confirmed = "1";
$query = "INSERT INTO " . $infrespsubscribers . " (ResponderID, SentMsgs, EmailAddress, TimeJoined, Real_TimeJoined, CanReceiveHTML, LastActivity, FirstName, LastName, IP_Addy, ReferralSource, UniqueCode, Confirmed)\n\t\t\t\t\t\t\tVALUES('{$DB_ResponderID}','{$DB_SentMsgs}', '{$DB_EmailAddress}', '{$DB_TimeJoined}', '{$DB_Real_TimeJoined}', '{$CanReceiveHTML}', '{$DB_LastActivity}', '{$DB_FirstName}', '{$DB_LastName}', '{$DB_IPaddy}', '{$DB_ReferralSource}', '{$DB_UniqueCode}', '{$DB_Confirmed}')";
$DB_result = mysql_query($query) or die("Invalid query: " . mysql_error());
$DB_SubscriberID = mysql_insert_id();
# Send welcome and notification
SendMessageTemplate('templates/messages/subscribe.complete.txt', $DB_EmailAddress, $ResponderInfo['FromEmail'], $DB_SubscriberID);
if ($DB_NotifyOnSub == "1") {
SendMessageTemplate('templates/messages/new_subscriber.notify.txt', $ResponderInfo['FromEmail'], $ResponderInfo['FromEmail']);
}
}
}
}
@imap_expunge($conn);
@imap_close($conn);
}
}
}
}
# Should we disconnect from the DB?
if ($included != TRUE) {
DB_disconnect();
}
$ResponderInfo = GetResponderInfo($Responder_ID);
$Timestamper = time();
$uniq_code = generate_unique_code();
if ($ReferralSource == "") {
$ReferralSource = "Bulk Import";
}
if ($CanReceiveHTML == "") {
$CanReceiveHTML = $HandleHTML;
}
if ($_REQUEST['subconfirmation'] == 'email' && $DB_OptMethod == "Double") {
# Add a non-confirmed row to the DB
$query = "INSERT INTO " . $infrespsubscribers . " (ResponderID, SentMsgs, EmailAddress, TimeJoined, Real_TimeJoined, CanReceiveHTML, LastActivity, FirstName, LastName, IP_Addy, ReferralSource, UniqueCode, Confirmed)\n\t\t\t\t\t\t\t\t VALUES('{$Responder_ID}','{$Blank}', '{$Email_Address}', '{$Timestamper}', '{$Timestamper}', '{$HandleHTML}', '{$Timestamper}', '{$First_Name}', '{$Last_Name}', '{$IP_Addy}', '{$ReferralSource}', '{$uniq_code}', '0')";
// VALUES('$Responder_ID','$DB_SentMsgs', '$DB_EmailAddress', '$DB_TimeJoined', '$DB_Real_TimeJoined', '$CanReceiveHTML', '$DB_LastActivity', '$DB_FirstName', '$DB_LastName', '$DB_IPaddy', '$DB_ReferralSource', '$DB_UniqueCode', '$DB_Confirmed')";
$DB_result = mysql_query($query) or die("Invalid query: " . mysql_error());
$DB_SubscriberID = mysql_insert_id();
SendMessageTemplate('templates/messages/subscribe.confirm.txt', $Email_Address, $ResponderInfo['FromEmail']);
print "<strong>Confirmation Email sent to: {$Email_Address}</strong><br>\n";
} elseif ($_REQUEST['subconfirmation'] == 'auto' && $DB_OptMethod == "Double") {
$query = "INSERT INTO " . $infrespsubscribers . " (ResponderID, SentMsgs, EmailAddress, TimeJoined, Real_TimeJoined, CanReceiveHTML, LastActivity, FirstName, LastName, IP_Addy, ReferralSource, UniqueCode, Confirmed)\n\t\t\t\t\t\t\t\t VALUES('{$Responder_ID}','{$Blank}', '{$Email_Address}', '{$Timestamper}', '{$Timestamper}', '{$HandleHTML}', '{$Timestamper}', '{$First_Name}', '{$Last_Name}', '{$IP_Addy}', 'ReferralSource', '{$uniq_code}', '1')";
$DB_result = mysql_query($query) or die("Invalid query: " . mysql_error());
print "Added Confirmed Subscriber: {$Email_Address} <br>\n";
} elseif ($_REQUEST['subconfirmation'] == 'off' || $DB_OptMethod == "Single") {
$query = "INSERT INTO " . $infrespsubscribers . " (ResponderID, SentMsgs, EmailAddress, TimeJoined, Real_TimeJoined, CanReceiveHTML, LastActivity, FirstName, LastName, IP_Addy, ReferralSource, UniqueCode, Confirmed)\n\t\t\t\t\t\t\t\t\t VALUES('{$Responder_ID}','{$Blank}', '{$Email_Address}', '{$Timestamper}', '{$Timestamper}', '{$HandleHTML}', '{$Timestamper}', '{$First_Name}', '{$Last_Name}', '{$IP_Addy}', '{$ReferralSource}', '{$uniq_code}', '0')";
$DB_result = mysql_query($query) or die("Invalid query: " . mysql_error());
print "Added Subscriber: {$Email_Address} <br>\n";
}
}
}
}
}
}
