// $DB_OptMethod = $ResponderInfo['OptinMethod'];
// if ($DB_OptMethod == "Double") {$DB_Confirm_Join = '1'}
// else {$DB_Confirm_Join = '0';}
# Setup the data
$DB_ResponderID = $Responder_ID;
$DB_SentMsgs = '';
$DB_EmailAddress = $Email_Address;
$DB_TimeJoined = time();
$DB_Real_TimeJoined = time();
$CanReceiveHTML = $Set_HTML;
$DB_LastActivity = time();
$DB_FirstName = $FirstName;
$DB_LastName = $LastName;
$DB_IPaddy = $IPaddy;
$DB_ReferralSource = "email join";
$DB_UniqueCode = generate_unique_code();
if ($DB_Confirm_Join == 1) {
# 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
if ($_REQUEST["infinitycode"]) {
exit;
}
if ($_REQUEST["source"]) {
exit;
}
if ($_REQUEST["responder"]) {
exit;
}
$ip_number = $_SERVER['REMOTE_ADDR'];
if ($name) {
$names = explode(" ", $name);
}
if (empty($firstname)) {
$firstname = $names[0];
}
if (empty($lastname)) {
$lastname = $names[1];
}
// Add the subscriber if the variables are set...
if ($infinitycode == $config['site_code'] && !empty($email) && !empty($responder) && !empty($firstname)) {
$Email_Address = $email;
if (!UserIsSubscribed($responder, $email)) {
if (!isInBlacklist($email)) {
$uniq_code = generate_unique_code();
$Timestamper = time();
$query = "INSERT INTO " . infrespsubscribers . " (ResponderID, SentMsgs, EmailAddress, TimeJoined, Real_TimeJoined, CanReceiveHTML, LastActivity, FirstName, LastName, IP_Addy, ReferralSource, UniqueCode, Confirmed) VALUES('{$responder}','', '{$email}', '{$Timestamper}', '{$Timestamper}', '{$html}', '{$Timestamper}', '{$firstname}', '{$lastname}', '{$ip_number}', '{$source}', '{$uniq_code}', '1')";
$DB_result = @mysql_query($query);
}
}
}
public function forgot_password()
{
$this->mTitle = "Forgot Password";
$this->mViewFile = 'account/forgot_password';
$this->mViewData['alert'] = get_alert();
if (validate_form()) {
$email = $this->input->post('email');
$user = $this->users->get_by(array('email' => $email, 'active' => 1));
if (!empty($user)) {
// generate unique code
$forgot_password_code = generate_unique_code();
$this->users->update($user['id'], array('forgot_password_code' => $forgot_password_code, 'forgot_password_time' => date('Y-m-d H:i:s')));
// send Reset Password email (make sure config/email.php is properly set first)
$to_name = $user['first_name'] . ' ' . $user['last_name'];
$subject = 'Reset Password';
$user['forgot_password_code'] = $forgot_password_code;
send_email($user['email'], $to_name, $subject, 'reset_password', $user);
// success
set_alert('success', 'A email is sent to you to reset your password.');
redirect('account/forgot_password');
exit;
} else {
// failed
set_alert('danger', 'No record found.');
redirect('account/login');
}
}
}
}
$delete_result = mysql_query($query) or die("Invalid query: " . mysql_error());
}
} else {
# Make the data array
$user_data['SentMsgs'] = '';
$user_data['EmailAddress'] = $safe['EMAIL'];
$user_data['TimeJoined'] = time();
$user_data['Real_TimeJoined'] = time();
$user_data['CanReceiveHTML'] = '1';
$user_data['LastActivity'] = time();
$user_data['FirstName'] = $safe['FIRST'];
$user_data['LastName'] = $safe['LAST'];
$user_data['IP_Addy'] = $safe['IP'];
$user_data['ReferralSource'] = 'Added w/ Move Subscriber';
$user_data['UniqueCode'] = generate_unique_code();
$user_data['Confirmed'] = '1';
}
# Check for existance in new responder.
$query = "SELECT * FROM " . $infrespsubscribers . " WHERE EmailAddress = '" . $safe['EMAIL'] . "' AND ResponderID = '" . $passed['MOVE_TO'] . "'";
# echo $query . "<br>\n";
$result = mysql_query($query) or die("Invalid query: " . mysql_error());
if (mysql_num_rows($result) > 0) {
# Update existing data
$query = "UPDATE " . $infRespsubscribers . " SET SentMsgs = '', TimeJoined = '" . $user_data['TimeJoined'] . "', Real_TimeJoined = '" . $user_data['Real_TimeJoined'] . "', LastActivity = '" . $user_data['LastActivity'] . "', FirstName = '" . $user_data['FirstName'] . "', LastName = '" . $user_data['LastName'] . "', IP_Addy = '" . $user_data['IP_Addy'] . "', ReferralSource = '" . $user_data['ReferralSource'] . "', Confirmed = '" . $user_data['Confirmed'] . "' WHERE EmailAddress = '" . $safe['EMAIL'] . "' AND ResponderID = '" . $passed['MOVE_TO'] . "'";
# echo $query . "<br>\n";
$result = mysql_query($query) or die("Invalid query: " . mysql_error());
} else {
# Make a new entry?
if ($passed['ONLYDEL'] != TRUE) {
$insert_values = "'" . $passed['MOVE_TO'] . "','" . $user_data['SentMsgs'] . "','" . $user_data['EmailAddress'] . "','" . $user_data['TimeJoined'] . "','" . $user_data['Real_TimeJoined'] . "','" . $user_data['CanReceiveHTML'] . "','" . $user_data['LastActivity'] . "','" . $user_data['FirstName'] . "','" . $user_data['LastName'] . "','" . $user_data['IP_Addy'] . "','" . $user_data['ReferralSource'] . "','" . $user_data['UniqueCode'] . "','" . $user_data['Confirmed'] . "'";
