Page 1 of 2

Login with e-mail instead of username

Posted: Tue Nov 25, 2014 8:27 am
by Tomtefar2
Hi,

I want users to log in with e-mail instead of username. Can someone instruct me how to modify my phpbb 3.1.1 board to achieve this? For obvious reasons I will not allow reuse of e-mail.

Thank you!

Re: Login with e-mail instead of username

Posted: Tue Nov 25, 2014 9:27 am
by Holger
+1
Would be cool to have the choise!

Re: Login with e-mail instead of username

Posted: Tue Nov 25, 2014 2:30 pm
by stevemaury
Add instructions telling them to use their email address as their username at registration?

Re: Login with e-mail instead of username

Posted: Tue Nov 25, 2014 2:39 pm
by Holger
Nobody wants to show theire emailaddresses as usernames all over the place.
It would just be convenient to have the possibility to login either with username or with emailaddress. Only the username should be shown everywhere ...

Re: Login with e-mail instead of username

Posted: Tue Nov 25, 2014 4:07 pm
by Walther
Basically you want this mod ported to an extension: https://www.phpbb.com/customise/db/mod/ ... via_email/

Re: Login with e-mail instead of username

Posted: Tue Nov 25, 2014 4:16 pm
by Wolfsblvt
I've done a quick check, there is no event in login functionality in phpBB 3.1, or I didn't found it.
So maybe you have to do an event reqeust first to get an event where you can implement code for this.

Otherwise the only solution I would know at the moment is do an own authorisation system.

Re: Login with e-mail instead of username

Posted: Tue Nov 25, 2014 4:37 pm
by Tomtefar2
Add instructions telling them to use their email address as their username at registration?
I have thought about this but then I would have to modify the entire forum to view the username.
Walther wrote:Basically you want this mod ported to an extension: https://www.phpbb.com/customise/db/mod/ ... via_email/
Yes, but I do not want usersame to be used as login at all (why?: viewtopic.php?f=466&t=2278011 )
I've done a quick check, there is no event in login functionality in phpBB 3.1, or I didn't found it.
So maybe you have to do an event reqeust first to get an event where you can implement code for this.

Otherwise the only solution I would know at the moment is do an own authorisation system.
Too bad, it would be nice to just redirect the verification to a different field.



Thank you for all your help so far!

Re: Login with e-mail instead of username

Posted: Tue Jan 27, 2015 6:17 pm
by jerome1362
Quelqu'un serait-il capable de créer une extension pour que les utilisateurs se connecte via leurs email au lieu de leur pseudo.

Simplement pour la connexion et non l'affichage sur le forum.

Merci.

Re: Login with e-mail instead of username

Posted: Tue Jan 27, 2015 11:27 pm
by marian0810
jerome1362 wrote:Quelqu'un serait-il capable de créer une extension pour que les utilisateurs se connecte via leurs email au lieu de leur pseudo.

Simplement pour la connexion et non l'affichage sur le forum.

Merci.
We'd appreciate it if you stick to English only, thanks :)

Re: Login with e-mail instead of username

Posted: Mon Feb 01, 2016 4:27 pm
by promod
I have got a search result about login with email, Can anyone verify the same please.
How-to:
Open /phpbb_root/phpbb/auth/provider/db.php and search for $username_clean = utf8_clean_string($username);. Just below that, make sure the SQL-query looks like this instead:

Code: Select all

$sql = 'SELECT *
FROM ' . USERS_TABLE . "
WHERE user_email = '" . $this->db->sql_escape($username_clean) . "' OR username_clean = '" . $this->db->sql_escape($username_clean) . "'";
Source

Re: Login with e-mail instead of username

Posted: Mon Feb 01, 2016 4:32 pm
by SiteSplat
Tomtefar2 wrote:Hi,

I want users to log in with e-mail instead of username. Can someone instruct me how to modify my phpbb 3.1.1 board to achieve this? For obvious reasons I will not allow reuse of e-mail.

Thank you!

There is already an extension for this. https://github.com/ForumHulp/loginwithemail
You can use it with my premium themes as well.

Re: Login with e-mail instead of username

Posted: Thu Feb 04, 2016 7:57 am
by promod
Is this recommended to use with a live board?

Re: Login with e-mail instead of username

Posted: Thu Feb 04, 2016 8:01 am
by Holger
When trying to activate the ext I get: The update process errored.

Edit: my fault, I did not install the ForumHulp Helper

Re: Login with e-mail instead of username

Posted: Sat Feb 06, 2016 5:32 am
by promod
SiteSplat wrote:There is already an extension for this. https://github.com/ForumHulp/loginwithemail
You can use it with my premium themes as well.
After enabling (including installing 'helper' and 'allow email login' i'm not able to succeed login with email,, Anything else to be done?

Re: Login with e-mail instead of username

Posted: Sat Feb 06, 2016 7:35 pm
by John P
Do you have a message in ACP log "Files succesfully changed" from Forumhulp helper?