PunBB Forums — [Request] Use email address to login rather than username

Re: [Request] Use email address to login rather than username

null@example.com (elbekko) — Sun, 05 Mar 2006 19:56:35 +0000

On the wiki. But I don't really get the syntax of the DokuWiki tho

Re: [Request] Use email address to login rather than username

null@example.com (elbekko) — Sun, 05 Mar 2006 19:10:16 +0000

Ok, I'll put it on soonish

Re: [Request] Use email address to login rather than username

null@example.com (Connorhd) — Sun, 05 Mar 2006 00:46:51 +0000

btw, elbekko this is a great thing to put on the PunRes wiki, http://punres.org/doku.php for people to find in the future

Re: [Request] Use email address to login rather than username

null@example.com (elbekko) — Sat, 04 Mar 2006 23:48:29 +0000

Only the login part

Re: [Request] Use email address to login rather than username

null@example.com (Dr.Jeckyl) — Sat, 04 Mar 2006 23:44:45 +0000

does this replace the username displayed also?

Re: [Request] Use email address to login rather than username

null@example.com (elbekko) — Sat, 04 Mar 2006 15:46:57 +0000

No problem, it's just a small modification

Re: [Request] Use email address to login rather than username

null@example.com (mgrice) — Sat, 04 Mar 2006 15:45:52 +0000

THANKS, elbekko, for the code and for the clarity of your instructions!

Re: [Request] Use email address to login rather than username

null@example.com (elbekko) — Sat, 04 Mar 2006 15:43:55 +0000

This is quite easy

Ok, open login.php

Find this line:

$form_username     = trim($_POST['req_username']);

Replace with

$form_email        = trim($_POST['req_email']);

Then, find this line:

$username_sql     = ($db_type == 'mysql' || $db_type == 'mysqli') ? 'username=\''.$db->escape($form_username).'\'' : 'LOWER(username)=LOWER(\''.$db->escape($form_username).'\')';

Replace with:

$email_sql         = ($db_type == 'mysql' || $db_type == 'mysqli') ? 'email=\''.$db->escape($form_email).'\'' : 'LOWER(email)=LOWER(\''.$db->escape($form_email).'\')';

After that, find:

$result = $db->query('SELECT id, group_id, password, save_pass FROM '.$db->prefix.'users WHERE '.$username_sql) or error('Unable to fetch user info', __FILE__, __LINE__, $db->error());

Replace with:

$result = $db->query('SELECT id, group_id, password, save_pass FROM '.$db->prefix.'users WHERE '.$email_sql) or error('Unable to fetch user info', __FILE__, __LINE__, $db->error());

Find:

$required_fields = array('req_username' => $lang_common['Username'], 'req_password' => $lang_common['Password']);

Replace with:

$required_fields = array('req_email' => $lang_common['E-mail'], 'req_password' => $lang_common['Password']);

Find:

Replace with:

This should do it Have fun

[Request] Use email address to login rather than username

null@example.com (mgrice) — Sat, 04 Mar 2006 14:52:43 +0000

I would like to have my users enter their email address and password in order to login. I still want to allow them to have/create a username at sign-up. But because people change their email addresses so frequently, and often forget to update it everywhere, my info quickly goes stale.

I have searched here and punres.org and did not find it. But that does not mean it hasn't been asked, and done, before.