Forgot Username Reminder

[ecroswell21]

Does anyone out there know how I can include the username in the email thats sent to the user when they request a new password?

 

Thanks

Erik

[FIMBLE]

Username is the email address used during account creation so i would asume it already is?

It would take a small code change to make this happen if you really wanted it though

Nic

 

 

[Guest]

Erik,

 

You can add that to the email by editing the password_forgotten.php file in this area:

 

$check_customer_query = tep_db_query("select customers_firstname, customers_lastname, customers_password, customers_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");

if (tep_db_num_rows($check_customer_query)) {

$check_customer = tep_db_fetch_array($check_customer_query);

 

$new_password = tep_create_random_value(ENTRY_PASSWORD_MIN_LENGTH);

$crypted_password = tep_encrypt_password($new_password);

 

tep_db_query("update " . TABLE_CUSTOMERS . " set customers_password = '" . tep_db_input($crypted_password) . "' where customers_id = '" . (int)$check_customer['customers_id'] . "'");

 

tep_mail($check_customer['customers_firstname'] . ' ' . $check_customer['customers_lastname'], $email_address, EMAIL_PASSWORD_REMINDER_SUBJECT, sprintf(EMAIL_PASSWORD_REMINDER_BODY, $new_password), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

 

$messageStack->add_session('login', SUCCESS_PASSWORD_SENT, 'success');

 

It would appear something like this:

 

$check_customer_query = tep_db_query("select customers_username, customers_firstname, customers_lastname, customers_password, customers_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");

if (tep_db_num_rows($check_customer_query)) {

$check_customer = tep_db_fetch_array($check_customer_query);

 

$new_password = tep_create_random_value(ENTRY_PASSWORD_MIN_LENGTH);

$crypted_password = tep_encrypt_password($new_password);

 

tep_db_query("update " . TABLE_CUSTOMERS . " set customers_password = '" . tep_db_input($crypted_password) . "' where customers_id = '" . (int)$check_customer['customers_id'] . "'");

 

tep_mail($check_customer ['customers_username'] . ' ' . $check_customer['customers_firstname'] . ' ' . $check_customer['customers_lastname'], $email_address, EMAIL_PASSWORD_REMINDER_SUBJECT, sprintf(EMAIL_PASSWORD_REMINDER_BODY, $new_password), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

 

$messageStack->add_session('login', SUCCESS_PASSWORD_SENT, 'success');

 

 

I can't remember exactly what the username contribution called for, but give that a try.

 

 

Chris