// $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'] . "'";